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_PS_TYPE_HIST_V

Product:	IGS - Student System (Obsolete)
Description:	This view is used to merge program type history with the current program type details enabling all details to be accessed over time, up till the current day. Each entry represents all column values over defined time periods.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CTH1.COURSE_TYPE
, CTH1.HIST_START_DT
, CTH1.HIST_END_DT
, CTH1.HIST_WHO
, NVL( CTH1.DESCRIPTION
, NVL( SUBSTR( IGS_AU_GEN_001.AUDP_GET_CTH_COL( 'DESCRIPTION'
, CTH1.COURSE_TYPE
, CTH1.HIST_END_DT)
, 1
, 60)
, CT1.DESCRIPTION))
, NVL( CTH1.GOVT_COURSE_TYPE
, NVL( TO_NUMBER(IGS_AU_GEN_001.AUDP_GET_CTH_COL( 'GOVT_COURSE_TYPE'
, CTH1.COURSE_TYPE
, CTH1.HIST_END_DT))
, CT1.GOVT_COURSE_TYPE))
, NVL( CTH1.AWARD_COURSE_IND
, NVL( SUBSTR( IGS_AU_GEN_001.AUDP_GET_CTH_COL( 'AWARD_COURSE_IND'
, CTH1.COURSE_TYPE
, CTH1.HIST_END_DT)
, 1
, 1)
, CT1.AWARD_COURSE_IND))
, NVL( CTH1.COURSE_TYPE_GROUP_CD
, NVL( SUBSTR( IGS_AU_GEN_001.AUDP_GET_CTH_COL( 'COURSE_TYPE_GROUP_CD'
, CTH1.COURSE_TYPE
, CTH1.HIST_END_DT)
, 1
, 10)
, CT1.COURSE_TYPE_GROUP_CD))
, NVL( CTH1.TAC_COURSE_LEVEL
, NVL( SUBSTR( IGS_AU_GEN_001.AUDP_GET_CTH_COL( 'TAC_COURSE_LEVEL'
, CTH1.COURSE_TYPE
, CTH1.HIST_END_DT)
, 1
, 4)
, CT1.TAC_COURSE_LEVEL))
, NVL( CTH1.RESEARCH_TYPE_IND
, NVL( SUBSTR( IGS_AU_GEN_001.AUDP_GET_CTH_COL( 'RESEARCH_TYPE_IND'
, CTH1.COURSE_TYPE
, CTH1.HIST_END_DT)
, 1
, 1)
, CT1.RESEARCH_TYPE_IND))
, NVL( CTH1.CLOSED_IND
, NVL( SUBSTR( IGS_AU_GEN_001.AUDP_GET_CTH_COL( 'CLOSED_IND'
, CTH1.COURSE_TYPE
, CTH1.HIST_END_DT)
, 1
, 1)
, CT1.CLOSED_IND))
, NVL( CTH1.PRIMARY_AUTO_SELECT
, NVL( SUBSTR( IGS_AU_GEN_001.AUDP_GET_CTH_COL( 'PRIMARY_AUTO_SELECT'
, CTH1.COURSE_TYPE
, CTH1.HIST_END_DT)
, 1
, 1)
, CT1.PRIMARY_AUTO_SELECT))
, CTH1.CREATED_BY
, CTH1.CREATION_DATE
, CTH1.LAST_UPDATED_BY
, CTH1.LAST_UPDATE_DATE
, CTH1.LAST_UPDATE_LOGIN
, NVL( CTH1.FIN_AID_PROGRAM_TYPE
, NVL( SUBSTR( IGS_AU_GEN_001.AUDP_GET_CTH_COL( 'FIN_AID_PROGRAM_TYPE'
, CTH1.COURSE_TYPE
, CTH1.HIST_END_DT)
, 1
, 1)
, CT1.FIN_AID_PROGRAM_TYPE))
, LV1.MEANING FROM IGS_PS_TYPE_HIST CTH1
, IGS_PS_TYPE CT1
, IGS_LOOKUP_VALUES LV1
WHERE CT1.COURSE_TYPE = CTH1.COURSE_TYPE AND CTH1.FIN_AID_PROGRAM_TYPE = LV1.LOOKUP_CODE (+) AND LV1.LOOKUP_TYPE (+) = 'IGS_PS_FA_PROGRAM_TYPE' UNION ALL SELECT CT2.COURSE_TYPE
, NVL( MAX(CTH2.HIST_END_DT)
, CT2.LAST_UPDATE_DATE)
, TO_DATE(NULL)
, CT2.LAST_UPDATED_BY
, CT2.DESCRIPTION
, CT2.GOVT_COURSE_TYPE
, CT2.AWARD_COURSE_IND
, CT2.COURSE_TYPE_GROUP_CD
, CT2.TAC_COURSE_LEVEL
, CT2.RESEARCH_TYPE_IND
, CT2.CLOSED_IND
, CT2.PRIMARY_AUTO_SELECT
, CT2.CREATED_BY
, CT2.CREATION_DATE
, CT2.LAST_UPDATED_BY
, CT2.LAST_UPDATE_DATE
, CT2.LAST_UPDATE_LOGIN
, CT2.FIN_AID_PROGRAM_TYPE
, LV2.MEANING FROM IGS_PS_TYPE_HIST CTH2
, IGS_PS_TYPE CT2
, IGS_LOOKUP_VALUES LV2 WHERE CT2.COURSE_TYPE = CTH2.COURSE_TYPE (+) AND CT2.FIN_AID_PROGRAM_TYPE = LV2.LOOKUP_CODE (+) AND LV2.LOOKUP_TYPE (+) = 'IGS_PS_FA_PROGRAM_TYPE' GROUP BY CT2.COURSE_TYPE
, CT2.DESCRIPTION
, CT2.GOVT_COURSE_TYPE
, CT2.AWARD_COURSE_IND
, CT2.COURSE_TYPE_GROUP_CD
, CT2.TAC_COURSE_LEVEL
, CT2.RESEARCH_TYPE_IND
, CT2.CLOSED_IND
, CT2.PRIMARY_AUTO_SELECT
, CT2.CREATED_BY
, CT2.CREATION_DATE
, CT2.LAST_UPDATED_BY
, CT2.LAST_UPDATE_DATE
, CT2.LAST_UPDATE_LOGIN
, CT2.FIN_AID_PROGRAM_TYPE
, LV2.MEANING

Columns

Name
COURSE_TYPE
HIST_START_DT
HIST_END_DT
HIST_WHO
DESCRIPTION
GOVT_COURSE_TYPE
AWARD_COURSE_IND
COURSE_TYPE_GROUP_CD
TAC_COURSE_LEVEL
RESEARCH_TYPE_IND
CLOSED_IND
PRIMARY_AUTO_SELECT
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
FIN_AID_PROGRAM_TYPE
FIN_AID_PROGRAM_TYPE_MEANING