VIEW: APPS.IGSFV_UC_APPLICANT_STATISTICS

Source

View Text - Preformatted

SELECT AP.APP_STAT_ID APPLICANT_STAT_IDENTIFIER, AP.APP_NO UCAS_APPLICANT_NUMBER, AP.STARH_ETHNIC IVSTARH_ETHNIC_CODE, (SELECT CODE_TEXT FROM IGS_UC_REF_CODES WHERE CODE_TYPE='ET' AND CODE= AP.STARH_ETHNIC) IVSTARH_ETHNIC_DESC, AP.STARH_SOCIAL_CLASS IVSTARH_SOCIAL_CLASS_CODE, (SELECT CODE_TEXT FROM IGS_UC_REF_CODES WHERE CODE_TYPE='PC' AND CODE= AP.STARH_SOCIAL_CLASS) IVSTARH_SOCIAL_CLASS_DESC, AP.STARH_POCC_EDU_CHG_DT IVSTARH_POCC_EDU_CHANGE_DATE, AP.STARH_POCC IVSTARH_POCC_CODE, AP.STARH_POCC_TEXT IVSTARH_POCC_TEXT, AP.STARH_LAST_EDU_INST IVSTARH_LAST_EDU_INSTITUTION, AP.STARH_EDU_LEAVE_DATE IVSTARH_EDU_LEAVE_DATE, AP.STARH_LEA IVSTARH_LEA, AP.STARH_SOCIO_ECONOMIC IVSTARH_SOCIO_ECONOMIC_CODE, (SELECT CODE_TEXT FROM IGS_UC_REF_CODES WHERE CODE_TYPE='PE' AND CODE= AP.STARH_SOCIO_ECONOMIC) IVSTARH_SOCIO_ECONOMIC_DESC, AP.IVSTARH_DEPENDANTS IVSTARH_DEPENDANTS, AP.IVSTARH_MARRIED IVSTARH_MARRIED, AP.STARX_ETHNIC IVSTARX_ETHNIC_CODE, (SELECT CODE_TEXT FROM IGS_UC_REF_CODES WHERE CODE_TYPE='ET' AND CODE= AP.STARX_ETHNIC) IVSTARX_ETHNIC_DESC, AP.STARX_POCC_EDU_CHG IVSTARX_POCC_EDU_CHANGE_DATE, AP.STARX_POCC IVSTARX_POCC_CODE, AP.STARX_POCC_TEXT IVSTARX_POCC_TEXT, AP.STARX_SOCIO_ECONOMIC IVSTARX_SOCIO_ECONOMIC_CODE, (SELECT CODE_TEXT FROM IGS_UC_REF_CODES WHERE CODE_TYPE='PE' AND CODE= AP.STARX_SOCIO_ECONOMIC) IVSTARX_SOCIO_ECONOMIC_DESC, AP.STARX_OCC_BACKGROUND IVSTARX_OCC_BACKGROUND, AP.IVSTARX_RELIGION IVSTARX_RELIGION, AP.IVSTARX_DEPENDANTS IVSTARX_DEPENDANTS, AP.IVSTARX_MARRIED IVSTARX_MARRIED, AP.SENT_TO_HESA SENT_TO_HESA, FT1.OSS_PERSON_ID OSS_PERSON_IDENTIFIER, FT2.PARTY_NUMBER OSS_PERSON_NUMBER, FT2.PARTY_NAME OSS_PERSON_NAME, AP.APP_ID APPLICANT_IDENTIFIER, AP.CREATED_BY CREATED_BY, AP.CREATION_DATE CREATION_DATE, AP.LAST_UPDATED_BY LAST_UPDATED_BY, AP.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM IGS_UC_APP_STATS AP, IGS_UC_APPLICANTS FT1, HZ_PARTIES FT2 WHERE AP.APP_NO = FT1.APP_NO AND FT1.OSS_PERSON_ID = FT2.PARTY_ID (+) WITH READ ONLY

View Text - HTML Formatted

SELECT AP.APP_STAT_ID APPLICANT_STAT_IDENTIFIER
, AP.APP_NO UCAS_APPLICANT_NUMBER
, AP.STARH_ETHNIC IVSTARH_ETHNIC_CODE
, (SELECT CODE_TEXT
FROM IGS_UC_REF_CODES
WHERE CODE_TYPE='ET'
AND CODE= AP.STARH_ETHNIC) IVSTARH_ETHNIC_DESC
, AP.STARH_SOCIAL_CLASS IVSTARH_SOCIAL_CLASS_CODE
, (SELECT CODE_TEXT
FROM IGS_UC_REF_CODES
WHERE CODE_TYPE='PC'
AND CODE= AP.STARH_SOCIAL_CLASS) IVSTARH_SOCIAL_CLASS_DESC
, AP.STARH_POCC_EDU_CHG_DT IVSTARH_POCC_EDU_CHANGE_DATE
, AP.STARH_POCC IVSTARH_POCC_CODE
, AP.STARH_POCC_TEXT IVSTARH_POCC_TEXT
, AP.STARH_LAST_EDU_INST IVSTARH_LAST_EDU_INSTITUTION
, AP.STARH_EDU_LEAVE_DATE IVSTARH_EDU_LEAVE_DATE
, AP.STARH_LEA IVSTARH_LEA
, AP.STARH_SOCIO_ECONOMIC IVSTARH_SOCIO_ECONOMIC_CODE
, (SELECT CODE_TEXT
FROM IGS_UC_REF_CODES
WHERE CODE_TYPE='PE'
AND CODE= AP.STARH_SOCIO_ECONOMIC) IVSTARH_SOCIO_ECONOMIC_DESC
, AP.IVSTARH_DEPENDANTS IVSTARH_DEPENDANTS
, AP.IVSTARH_MARRIED IVSTARH_MARRIED
, AP.STARX_ETHNIC IVSTARX_ETHNIC_CODE
, (SELECT CODE_TEXT
FROM IGS_UC_REF_CODES
WHERE CODE_TYPE='ET'
AND CODE= AP.STARX_ETHNIC) IVSTARX_ETHNIC_DESC
, AP.STARX_POCC_EDU_CHG IVSTARX_POCC_EDU_CHANGE_DATE
, AP.STARX_POCC IVSTARX_POCC_CODE
, AP.STARX_POCC_TEXT IVSTARX_POCC_TEXT
, AP.STARX_SOCIO_ECONOMIC IVSTARX_SOCIO_ECONOMIC_CODE
, (SELECT CODE_TEXT
FROM IGS_UC_REF_CODES
WHERE CODE_TYPE='PE'
AND CODE= AP.STARX_SOCIO_ECONOMIC) IVSTARX_SOCIO_ECONOMIC_DESC
, AP.STARX_OCC_BACKGROUND IVSTARX_OCC_BACKGROUND
, AP.IVSTARX_RELIGION IVSTARX_RELIGION
, AP.IVSTARX_DEPENDANTS IVSTARX_DEPENDANTS
, AP.IVSTARX_MARRIED IVSTARX_MARRIED
, AP.SENT_TO_HESA SENT_TO_HESA
, FT1.OSS_PERSON_ID OSS_PERSON_IDENTIFIER
, FT2.PARTY_NUMBER OSS_PERSON_NUMBER
, FT2.PARTY_NAME OSS_PERSON_NAME
, AP.APP_ID APPLICANT_IDENTIFIER
, AP.CREATED_BY CREATED_BY
, AP.CREATION_DATE CREATION_DATE
, AP.LAST_UPDATED_BY LAST_UPDATED_BY
, AP.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_UC_APP_STATS AP
, IGS_UC_APPLICANTS FT1
, HZ_PARTIES FT2
WHERE AP.APP_NO = FT1.APP_NO
AND FT1.OSS_PERSON_ID = FT2.PARTY_ID (+) WITH READ ONLY