eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_AD_PS_APPL_APLCNTX_V

Product:	IGS - Student System (Obsolete)
Description:	View of IGS_AD_PS_APPL, for forms requiring this table as a context block. - Obsolete
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ACA.ROW_ID ROW_ID
, ACA.PERSON_ID
, PDV.PERSON_NUMBER
, ACA.ADMISSION_APPL_NUMBER
, ACA.NOMINATED_COURSE_CD
, PDV.API_PERSON_ID
, PDV.PERSON_ID_TYPE
, PDV.FULL_NAME
, PDV.SEX_MEANING
, PDV.SURNAME
, PDV.GIVEN_NAMES
, PDV.PREFERRED_GIVEN_NAME
, PDV.TITLE PE_TITLE
, PDV.CONTEXT_BLOCK_NAME
, PDV.SEX
, PDV.BIRTH_DT
, PDV.ENCUMBERED_IND
, PDV.DECEASED_IND
, AAV.COMMENCEMENT_PERIOD
, AAV.ADMISSION_PROCESS_CAT
, CRV.TITLE
, ACA.CREATED_BY
, ACA.CREATION_DATE
, ACA.LAST_UPDATED_BY
, ACA.LAST_UPDATE_DATE
, ACA.LAST_UPDATE_LOGIN
FROM IGS_AD_PS_APPL ACA
, IGS_PE_PERSON_V PDV
, IGS_AD_APPL_ADMAPPL_V AAV
, IGS_PS_VER CRV
WHERE ACA.PERSON_ID = PDV.PERSON_ID
AND ACA.PERSON_ID = AAV.PERSON_ID
AND ACA.ADMISSION_APPL_NUMBER = AAV.ADMISSION_APPL_NUMBER
AND ACA.NOMINATED_COURSE_CD = CRV.COURSE_CD
AND CRV.VERSION_NUMBER = ( SELECT MAX(CRV2.VERSION_NUMBER)
FROM IGS_PS_VER CRV2
WHERE CRV2.COURSE_CD = ACA.NOMINATED_COURSE_CD)

Columns

Name
ROW_ID
PERSON_ID
PERSON_NUMBER
ADMISSION_APPL_NUMBER
NOMINATED_COURSE_CD
API_PERSON_ID
PERSON_ID_TYPE
FULL_NAME
SEX_MEANING
SURNAME
GIVEN_NAMES
PREFERRED_GIVEN_NAME
PE_TITLE
CONTEXT_BLOCK_NAME
SEX
BIRTH_DT
ENCUMBERED_IND
DECEASED_IND
COMMENCEMENT_PERIOD
ADMISSION_PROCESS_CAT
TITLE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN