[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Base View for basic person details of a UCAS applicant making an Extra or Clearing application. |
| Implementation/DBA Data: | Not implemented in this database |
SELECT EN.APP_NO UCAS_APPLICANT_NUMBER
, EN.SURNAME SURNAME
, EN.GIVEN_NAMES GIVEN_NAMES
, EN.SEX SEX_CODE
, '_LA:EN.SEX:IGS_LOOKUP_VALUES:SEX:MEANING' "_LA:SEX_DESC"
, EN.BIRTH_DT BIRTH_DATE
, EN.PREFIX PREFIX
, EN.ADDRESS_LINE1 ADDRESS_LINE1
, EN.ADDRESS_LINE2 ADDRESS_LINE2
, EN.ADDRESS_LINE3 ADDRESS_LINE3
, EN.ADDRESS_LINE4 ADDRESS_LINE4
, EN.COUNTRY COUNTRY
, EN.POSTCODE POSTCODE
, EN.EMAIL EMAIL
, EN.TELEPHONE TELEPHONE
, FT1.SYSTEM_CODE UCAS_SYSTEM_CODE
, FT1.EXTRA_PASSPORT_NO EXTRA_PASSPORT_NUMBER
, FT1.REQUEST_APP_DETS_IND REQUEST_APPL_DETAILS_IND
, FT1.REQUEST_COPY_APP_FRM_IND REQUEST_COPY_APPL_FORM_IND
, FT1.CEF_NO CLEARING_ENTRY_FORM_NUMBER
, FT1.OSS_PERSON_ID OSS_PERSON_IDENTIFIER
, EN.CREATED_BY CREATED_BY
, EN.CREATION_DATE CREATION_DATE
, EN.LAST_UPDATED_BY LAST_UPDATED_BY
, EN.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_UC_ENQ_DETAILS EN
, IGS_UC_APPLICANTS FT1
WHERE EN.APP_NO = FT1.APP_NO (+) WITH READ ONLY