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_INST_CONTEXT_V

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

View Text

SELECT ACAIV.ROW_ID ROW_ID
, ACAIV.PERSON_ID
, PDV.PERSON_NUMBER
, PDV.FULL_NAME CONTEXT_BLOCK_NAME
, PDV.GENDER SEX
, PDV.BIRTH_DATE BIRTH_DT
, (SELECT DECODE(COUNT(ROWID)
, 0
, 'N'
, 'Y')
FROM IGS_PE_PERS_ENCUMB
WHERE PERSON_ID = PDV.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN START_DT
AND (NVL(EXPIRY_DT
, TRUNC(SYSDATE)+1)-1)) ENCUMBERED_IND
, DECODE(PP.DATE_OF_DEATH
, NULL
, NVL(PD.DECEASED_IND
, 'N')
, 'Y') DECEASED_IND
, AA.ADMISSION_APPL_NUMBER
, AA.ADMISSION_CAT
, AA.S_ADMISSION_PROCESS_TYPE
, AA.ACAD_CAL_TYPE
, AA.ACAD_CI_SEQUENCE_NUMBER
, CI1.ALTERNATE_CODE
, AA.ADM_CAL_TYPE
, AA.ADM_CI_SEQUENCE_NUMBER
, CI2.ALTERNATE_CODE
, CI1.ALTERNATE_CODE || '/' || CI2.ALTERNATE_CODE
, ACAIV.NOMINATED_COURSE_CD
, ACAIV.SEQUENCE_NUMBER
, ACAIV.COURSE_CD
, ACAIV.CRV_VERSION_NUMBER
, ACAIV.LOCATION_CD
, ACAIV.ATTENDANCE_MODE
, ACAIV.ATTENDANCE_TYPE
, ACAIV.PREFERENCE_NUMBER
, ACAIV.COURSE_CD || ' ' || ACAIV.CRV_VERSION_NUMBER
, PSV.TITLE COURSE_TITLE_DISPLAY
, ACAIV.CREATED_BY
, ACAIV.CREATION_DATE
, ACAIV.LAST_UPDATED_BY
, ACAIV.LAST_UPDATE_DATE
, ACAIV.LAST_UPDATE_LOGIN
, AA.APPLICATION_ID APPLICATION_ID
, AA.ALT_APPL_ID ALT_APPL_ID
FROM IGS_AD_PS_APPL_INST ACAIV
, IGS_AD_APPL AA
, IGS_PE_PERSON_BASE_V PDV
, IGS_CA_INST CI1
, IGS_CA_INST CI2
, IGS_PS_VER PSV
, IGS_PE_HZ_PARTIES PD
, HZ_PERSON_PROFILES PP
WHERE ACAIV.PERSON_ID = AA.PERSON_ID
AND ACAIV.ADMISSION_APPL_NUMBER = AA.ADMISSION_APPL_NUMBER
AND ACAIV.PERSON_ID = PDV.PERSON_ID
AND CI1.CAL_TYPE = AA.ACAD_CAL_TYPE
AND CI1.SEQUENCE_NUMBER = AA.ACAD_CI_SEQUENCE_NUMBER
AND CI2.CAL_TYPE = AA.ADM_CAL_TYPE
AND CI2.SEQUENCE_NUMBER = AA.ADM_CI_SEQUENCE_NUMBER
AND ACAIV.NOMINATED_COURSE_CD = PSV.COURSE_CD
AND ACAIV.CRV_VERSION_NUMBER = PSV.VERSION_NUMBER
AND AA.PERSON_ID = PD.PARTY_ID
AND AA.PERSON_ID = PP.PARTY_ID
AND PP.CONTENT_SOURCE_TYPE(+) = 'USER_ENTERED'
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE)

Columns

Name
ROW_ID
PERSON_ID
PERSON_NUMBER
CONTEXT_BLOCK_NAME
SEX
BIRTH_DT
ENCUMBERED_IND
DECEASED_IND
ADMISSION_APPL_NUMBER
ADMISSION_CAT
S_ADMISSION_PROCESS_TYPE
ACAD_CAL_TYPE
ACAD_CI_SEQUENCE_NUMBER
ACAD_ALTERNATE_CODE
ADM_CAL_TYPE
ADM_CI_SEQUENCE_NUMBER
ADM_ALTERNATE_CODE
COMMENCEMENT_PERIOD
NOMINATED_COURSE_CD
SEQUENCE_NUMBER
COURSE_CD
CRV_VERSION_NUMBER
LOCATION_CD
ATTENDANCE_MODE
ATTENDANCE_TYPE
PREFERENCE_NUMBER
COURSE_VERSION
CRV_TITLE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
APPLICATION_ID
ALT_APPL_ID