[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Hesa Admission Details |
| Implementation/DBA Data: | Not implemented in this database |
SELECT A.ROWID ROW_ID
, A.HESA_SEQUENCE_ID HESA_SEQUENCE_ID
, A.PERSON_ID PERSON_ID
, A.ADMISSION_APPL_NUMBER ADMISSION_APPL_NUMBER
, A.NOMINATED_COURSE_CD NOMINATED_COURSE_CD
, A.SEQUENCE_NUMBER SEQUENCE_NUMBER
, A.DOMICILE_CD DOMICILE_CD
, B.VALUE_DESCRIPTION DOMICILE_DESC
, A.OCCUPATION_CD OCCUPATION_CD
, C.VALUE_DESCRIPTION OCCUPATION_DESC
, A.SOCIAL_CLASS_CD SOCIAL_CLASS_CD
, D.VALUE_DESCRIPTION SOCIAL_CLASS_DESC
, A.SPECIAL_STUDENT_CD SPECIAL_STUDENT_CD
, E.VALUE_DESCRIPTION SPECIAL_STUDENT_DESC
, A.CREATION_DATE CREATION_DATE
, A.CREATED_BY CREATED_BY
, A.LAST_UPDATE_DATE LAST_UPDATE_DATE
, A.LAST_UPDATED_BY LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_HE_AD_DTL A
, IGS_HE_CODE_VALUES B
, IGS_HE_CODE_VALUES C
, IGS_HE_CODE_VALUES D
, IGS_HE_CODE_VALUES E
WHERE A.DOMICILE_CD = B.VALUE(+)
AND B.CODE_TYPE(+) = 'OSS_DOM'
AND A.OCCUPATION_CD = C.VALUE(+)
AND C.CODE_TYPE(+) = 'OSS_OCC'
AND A.SOCIAL_CLASS_CD = D.VALUE(+)
AND D.CODE_TYPE(+) = 'OSS_SOC'
AND A.SPECIAL_STUDENT_CD = E.VALUE(+)
AND E.CODE_TYPE(+) = 'OSS_SPEC_STUD'