[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Base business view to allow queries on Student Admission Application HESA Details. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT HAD.HESA_AD_DTL_ID HESA_AD_DTL_ID
, HAD.PERSON_ID PERSON_ID
, PER.PARTY_NUMBER PERSON_NUMBER
, HAD.NOMINATED_COURSE_CD NOMINATED_PROGRAM_CODE
, HAD.ADMISSION_APPL_NUMBER ADMISSION_APPLICATION_NUMBER
, HAD.SEQUENCE_NUMBER SEQUENCE_NUMBER
, HAD.OCCUPATION_CD OCCUPATION_CODE
, HAD.DOMICILE_CD DOMICILE_CODE
, HAD.SOCIAL_CLASS_CD SOCIAL_CLASS_CODE
, HAD.SPECIAL_STUDENT_CD SPECIAL_STUDENT_CODE
, HAD.CREATION_DATE CREATION_DATE
, HAD.CREATED_BY CREATED_BY
, HAD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, HAD.LAST_UPDATED_BY LAST_UPDATED_BY
FROM IGS_HE_AD_DTL_ALL HAD
, HZ_PARTIES PER
WHERE PER.PARTY_ID = HAD.PERSON_ID WITH READ ONLY