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_APLINSTUNT_UNITHST_V

Product:	IGS - Student System (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ACAIUH1.PERSON_ID
, ACAIUH1.ADMISSION_APPL_NUMBER
, ACAIUH1.NOMINATED_COURSE_CD
, ACAIUH1.ACAI_SEQUENCE_NUMBER
, ACAIUH1.UNIT_CD
, ACAIUH1.HIST_START_DT
, ACAIUH1.HIST_END_DT
, ACAIUH1.HIST_WHO
, NVL(ACAIUH1.UV_VERSION_NUMBER
, NVL(TO_NUMBER(IGS_AU_GEN_001.AUDP_GET_ACAIUH_COL( 'UV_VERSION_NUMBER'
, ACAIUH1.ADM_PS_APPL_INST_UNIT_ID
, ACAIUH1.PERSON_ID
, ACAIUH1.ADMISSION_APPL_NUMBER
, ACAIUH1.NOMINATED_COURSE_CD
, ACAIUH1.ACAI_SEQUENCE_NUMBER
, ACAIUH1.UNIT_CD
, ACAIUH1.HIST_END_DT))
, ACAIU1.UV_VERSION_NUMBER))
, NVL(ACAIUH1.CAL_TYPE
, NVL(SUBSTR(IGS_AU_GEN_001.AUDP_GET_ACAIUH_COL( 'CAL_TYPE'
, ACAIUH1.ADM_PS_APPL_INST_UNIT_ID
, ACAIUH1.PERSON_ID
, ACAIUH1.ADMISSION_APPL_NUMBER
, ACAIUH1.NOMINATED_COURSE_CD
, ACAIUH1.ACAI_SEQUENCE_NUMBER
, ACAIUH1.UNIT_CD
, ACAIUH1.HIST_END_DT)
, 1
, 10)
, ACAIU1.CAL_TYPE))
, NVL(ACAIUH1.CI_SEQUENCE_NUMBER
, NVL(TO_NUMBER(IGS_AU_GEN_001.AUDP_GET_ACAIUH_COL( 'CI_SEQUENCE_NUMBER'
, ACAIUH1.ADM_PS_APPL_INST_UNIT_ID
, ACAIUH1.PERSON_ID
, ACAIUH1.ADMISSION_APPL_NUMBER
, ACAIUH1.NOMINATED_COURSE_CD
, ACAIUH1.ACAI_SEQUENCE_NUMBER
, ACAIUH1.UNIT_CD
, ACAIUH1.HIST_END_DT))
, ACAIU1.CI_SEQUENCE_NUMBER))
, NVL(ACAIUH1.LOCATION_CD
, NVL(SUBSTR(IGS_AU_GEN_001.AUDP_GET_ACAIUH_COL( 'LOCATION_CD'
, ACAIUH1.ADM_PS_APPL_INST_UNIT_ID
, ACAIUH1.PERSON_ID
, ACAIUH1.ADMISSION_APPL_NUMBER
, ACAIUH1.NOMINATED_COURSE_CD
, ACAIUH1.ACAI_SEQUENCE_NUMBER
, ACAIUH1.UNIT_CD
, ACAIUH1.HIST_END_DT)
, 1
, 10)
, ACAIU1.LOCATION_CD))
, NVL(ACAIUH1.UNIT_CLASS
, NVL(SUBSTR(IGS_AU_GEN_001.AUDP_GET_ACAIUH_COL( 'UNIT_CLASS'
, ACAIUH1.ADM_PS_APPL_INST_UNIT_ID
, ACAIUH1.PERSON_ID
, ACAIUH1.ADMISSION_APPL_NUMBER
, ACAIUH1.NOMINATED_COURSE_CD
, ACAIUH1.ACAI_SEQUENCE_NUMBER
, ACAIUH1.UNIT_CD
, ACAIUH1.HIST_END_DT)
, 1
, 10)
, ACAIU1.UNIT_CLASS))
, NVL(ACAIUH1.UNIT_MODE
, NVL(SUBSTR(IGS_AU_GEN_001.AUDP_GET_ACAIUH_COL( 'UNIT_MODE'
, ACAIUH1.ADM_PS_APPL_INST_UNIT_ID
, ACAIUH1.PERSON_ID
, ACAIUH1.ADMISSION_APPL_NUMBER
, ACAIUH1.NOMINATED_COURSE_CD
, ACAIUH1.ACAI_SEQUENCE_NUMBER
, ACAIUH1.UNIT_CD
, ACAIUH1.HIST_END_DT)
, 1
, 10)
, ACAIU1.UNIT_MODE))
, NVL(ACAIUH1.ADM_UNIT_OUTCOME_STATUS
, NVL(SUBSTR(IGS_AU_GEN_001.AUDP_GET_ACAIUH_COL( 'ADM_UNIT_OUTCOME_STATUS'
, ACAIUH1.ADM_PS_APPL_INST_UNIT_ID
, ACAIUH1.PERSON_ID
, ACAIUH1.ADMISSION_APPL_NUMBER
, ACAIUH1.NOMINATED_COURSE_CD
, ACAIUH1.ACAI_SEQUENCE_NUMBER
, ACAIUH1.UNIT_CD
, ACAIUH1.HIST_END_DT)
, 1
, 10)
, ACAIU1.ADM_UNIT_OUTCOME_STATUS))
, NVL(ACAIUH1.ASS_TRACKING_ID
, NVL(TO_NUMBER(IGS_AU_GEN_001.AUDP_GET_ACAIUH_COL( 'ASS_TRACKING_ID'
, ACAIUH1.ADM_PS_APPL_INST_UNIT_ID
, ACAIUH1.PERSON_ID
, ACAIUH1.ADMISSION_APPL_NUMBER
, ACAIUH1.NOMINATED_COURSE_CD
, ACAIUH1.ACAI_SEQUENCE_NUMBER
, ACAIUH1.UNIT_CD
, ACAIUH1.HIST_END_DT))
, ACAIU1.ASS_TRACKING_ID))
, NVL(ACAIUH1.RULE_WAIVED_DT
, NVL( IGS_GE_DATE.IGSDATE(IGS_AU_GEN_001.AUDP_GET_ACAIUH_COL( 'RULE_WAIVED_DT'
, ACAIUH1.ADM_PS_APPL_INST_UNIT_ID
, ACAIUH1.PERSON_ID
, ACAIUH1.ADMISSION_APPL_NUMBER
, ACAIUH1.NOMINATED_COURSE_CD
, ACAIUH1.ACAI_SEQUENCE_NUMBER
, ACAIUH1.UNIT_CD
, ACAIUH1.HIST_END_DT))
, ACAIU1.RULE_WAIVED_DT))
, NVL(ACAIUH1.RULE_WAIVED_PERSON_ID
, NVL(TO_NUMBER(IGS_AU_GEN_001.AUDP_GET_ACAIUH_COL( 'RULE_WAIVED_PERSON_ID'
, ACAIUH1.ADM_PS_APPL_INST_UNIT_ID
, ACAIUH1.PERSON_ID
, ACAIUH1.ADMISSION_APPL_NUMBER
, ACAIUH1.NOMINATED_COURSE_CD
, ACAIUH1.ACAI_SEQUENCE_NUMBER
, ACAIUH1.UNIT_CD
, ACAIUH1.HIST_END_DT))
, ACAIU1.RULE_WAIVED_PERSON_ID))
, NVL(ACAIUH1.SUP_UNIT_CD
, NVL(SUBSTR(IGS_AU_GEN_001.AUDP_GET_ACAIUH_COL( 'SUP_UNIT_CD'
, ACAIUH1.ADM_PS_APPL_INST_UNIT_ID
, ACAIUH1.PERSON_ID
, ACAIUH1.ADMISSION_APPL_NUMBER
, ACAIUH1.NOMINATED_COURSE_CD
, ACAIUH1.ACAI_SEQUENCE_NUMBER
, ACAIUH1.UNIT_CD
, ACAIUH1.HIST_END_DT)
, 1
, 10)
, ACAIU1.SUP_UNIT_CD))
, NVL(ACAIUH1.SUP_UV_VERSION_NUMBER
, NVL(TO_NUMBER(IGS_AU_GEN_001.AUDP_GET_ACAIUH_COL( 'SUP_UV_VERSION_NUMBER'
, ACAIUH1.ADM_PS_APPL_INST_UNIT_ID
, ACAIUH1.PERSON_ID
, ACAIUH1.ADMISSION_APPL_NUMBER
, ACAIUH1.NOMINATED_COURSE_CD
, ACAIUH1.ACAI_SEQUENCE_NUMBER
, ACAIUH1.UNIT_CD
, ACAIUH1.HIST_END_DT))
, ACAIU1.SUP_UV_VERSION_NUMBER))
, ACAIUH1.CREATED_BY
, ACAIUH1.CREATION_DATE
, ACAIUH1.LAST_UPDATED_BY
, ACAIUH1.LAST_UPDATE_DATE
, ACAIUH1.LAST_UPDATE_LOGIN
, ACAIUH1.ADM_PS_APPL_INST_UNIT_ID FROM IGS_AD_PS_APINTUNTHS ACAIUH1
, IGS_AD_PS_APLINSTUNT ACAIU1
WHERE ACAIUH1.ADM_PS_APPL_INST_UNIT_ID = ACAIU1.ADM_PS_APPL_INST_UNIT_ID UNION ALL SELECT ACAIU2.PERSON_ID
, ACAIU2.ADMISSION_APPL_NUMBER
, ACAIU2.NOMINATED_COURSE_CD
, ACAIU2.ACAI_SEQUENCE_NUMBER
, ACAIU2.UNIT_CD
, NVL( MAX(ACAIUH2.HIST_END_DT)
, ACAIU2.LAST_UPDATE_DATE)
, IGS_GE_DATE.IGSDATE(NULL)
, ACAIU2.LAST_UPDATED_BY
, ACAIU2.UV_VERSION_NUMBER
, ACAIU2.CAL_TYPE
, ACAIU2.CI_SEQUENCE_NUMBER
, ACAIU2.LOCATION_CD
, ACAIU2.UNIT_CLASS
, ACAIU2.UNIT_MODE
, ACAIU2.ADM_UNIT_OUTCOME_STATUS
, ACAIU2.ASS_TRACKING_ID
, ACAIU2.RULE_WAIVED_DT
, ACAIU2.RULE_WAIVED_PERSON_ID
, ACAIU2.SUP_UNIT_CD
, ACAIU2.SUP_UV_VERSION_NUMBER
, ACAIU2.CREATED_BY
, ACAIU2.CREATION_DATE
, ACAIU2.LAST_UPDATED_BY
, ACAIU2.LAST_UPDATE_DATE
, ACAIU2.LAST_UPDATE_LOGIN
, ACAIU2.ADM_PS_APPL_INST_UNIT_ID FROM IGS_AD_PS_APINTUNTHS ACAIUH2
, IGS_AD_PS_APLINSTUNT ACAIU2 WHERE ACAIUH2.ADM_PS_APPL_INST_UNIT_ID (+) = ACAIU2.ADM_PS_APPL_INST_UNIT_ID GROUP BY ACAIU2.PERSON_ID
, ACAIU2.ADMISSION_APPL_NUMBER
, ACAIU2.NOMINATED_COURSE_CD
, ACAIU2.ACAI_SEQUENCE_NUMBER
, ACAIU2.UNIT_CD
, ACAIU2.UV_VERSION_NUMBER
, ACAIU2.CAL_TYPE
, ACAIU2.CI_SEQUENCE_NUMBER
, ACAIU2.LOCATION_CD
, ACAIU2.UNIT_CLASS
, ACAIU2.UNIT_MODE
, ACAIU2.ADM_UNIT_OUTCOME_STATUS
, ACAIU2.ASS_TRACKING_ID
, ACAIU2.RULE_WAIVED_DT
, ACAIU2.RULE_WAIVED_PERSON_ID
, ACAIU2.SUP_UNIT_CD
, ACAIU2.SUP_UV_VERSION_NUMBER
, ACAIU2.CREATED_BY
, ACAIU2.CREATION_DATE
, ACAIU2.LAST_UPDATED_BY
, ACAIU2.LAST_UPDATE_DATE
, ACAIU2.LAST_UPDATE_LOGIN
, ACAIU2.ADM_PS_APPL_INST_UNIT_ID

Columns

Name
PERSON_ID
ADMISSION_APPL_NUMBER
NOMINATED_COURSE_CD
ACAI_SEQUENCE_NUMBER
UNIT_CD
HIST_START_DT
HIST_END_DT
HIST_WHO
UV_VERSION_NUMBER
CAL_TYPE
CI_SEQUENCE_NUMBER
LOCATION_CD
UNIT_CLASS
UNIT_MODE
ADM_UNIT_OUTCOME_STATUS
ASS_TRACKING_ID
RULE_WAIVED_DT
RULE_WAIVED_PERSON_ID
SUP_UNIT_CD
SUP_UV_VERSION_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
ADM_PS_APPL_INST_UNIT_ID