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_APLUNIT_V

Product:	IGS - Student System (Obsolete)
Description:	View of IGS_AD_PS_APLINSTUNT table. Incorporates alternate codes and calendar instance start and end dates for Teaching calendars.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ACAIU.ROW_ID ROW_ID
, ACAIU.PERSON_ID
, ACAIU.ADMISSION_APPL_NUMBER
, ACAIU.NOMINATED_COURSE_CD
, ACAIU.ACAI_SEQUENCE_NUMBER
, ACAIU.UNIT_CD
, ACAIU.UV_VERSION_NUMBER
, UV.TITLE
, UV.UNIT_STATUS
, ACAIU.CAL_TYPE
, ACAIU.CI_SEQUENCE_NUMBER
, CI.ALTERNATE_CODE
, ACAIU.LOCATION_CD
, ACAIU.UNIT_CLASS
, ACAIU.UNIT_MODE
, ACAIU.ASS_TRACKING_ID
, ACAIU.ADM_UNIT_OUTCOME_STATUS
, ACAIU.RULE_WAIVED_DT
, ACAIU.RULE_WAIVED_PERSON_ID
, ACAIU.SUP_UNIT_CD
, ACAIU.SUP_UV_VERSION_NUMBER
, ACAIU.CREATED_BY
, ACAIU.CREATION_DATE
, ACAIU.LAST_UPDATED_BY
, ACAIU.LAST_UPDATE_DATE
, ACAIU.LAST_UPDATE_LOGIN
, ACAIU.ADM_PS_APPL_INST_UNIT_ID
FROM IGS_AD_PS_APLINSTUNT ACAIU
, IGS_CA_INST CI
, IGS_PS_UNIT_VER UV
WHERE CI.CAL_TYPE (+) = ACAIU.CAL_TYPE
AND CI.SEQUENCE_NUMBER (+) = ACAIU.CI_SEQUENCE_NUMBER
AND UV.UNIT_CD = ACAIU.UNIT_CD
AND UV.VERSION_NUMBER = ACAIU.UV_VERSION_NUMBER

Columns

Name
ROW_ID
PERSON_ID
ADMISSION_APPL_NUMBER
NOMINATED_COURSE_CD
ACAI_SEQUENCE_NUMBER
UNIT_CD
UV_VERSION_NUMBER
UV_TITLE
UV_UNIT_STATUS
CAL_TYPE
CI_SEQUENCE_NUMBER
TEACH_ALTERNATE_CODE
LOCATION_CD
UNIT_CLASS
UNIT_MODE
ASS_TRACKING_ID
ADM_UNIT_OUTCOME_STATUS
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