Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Describes occurrence of an application for special consideration. |
Implementation/DBA Data: | Not implemented in this database |
SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, AASS.ANONYMOUS_ID
, AASS.ASSESSMENT_TYPE
, ATYP.DESCRIPTION
, '_LA:AASS.SYSTEM_GENERATED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, AASS.LOAD_CAL_TYPE
, AASS.LOAD_CI_SEQUENCE_NUMBER
, CI.DESCRIPTION
, AASS.PERSON_ID
, AASS.CREATED_BY
, AASS.CREATION_DATE
, AASS.LAST_UPDATED_BY
, AASS.LAST_UPDATE_DATE
FROM HZ_PARTIES HP
, IGS_AS_ANON_ID_ASS AASS
, IGS_AS_ASSESSMNT_TYP ATYP
, IGS_CA_INST_ALL CI
WHERE AASS.PERSON_ID = HP.PARTY_ID AND AASS.LOAD_CAL_TYPE = CI.CAL_TYPE AND AASS.LOAD_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND AASS.ASSESSMENT_TYPE = ATYP.ASSESSMENT_TYPE WITH READ ONLY