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_PR_COHORT_INST_V

Product:	IGS - Student System (Obsolete)
Description:	Stores Cohort Instance with denormalised references
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT COHI.ROWID
, COHI.COHORT_NAME
, COHI.LOAD_CAL_TYPE
, COHI.LOAD_CI_SEQUENCE_NUMBER
, CI.START_DT
, CI.END_DT
, CI.DESCRIPTION
, COHI.COHORT_STATUS
, LKV.MEANING
, COHI.RANK_STATUS
, LKV1.MEANING
, COHI.RUN_DATE
, COHI.CREATED_BY
, COHI.CREATION_DATE
, COHI.LAST_UPDATED_BY
, COHI.LAST_UPDATE_DATE
, COHI.LAST_UPDATE_LOGIN
, COHI.REQUEST_ID
, COHI.PROGRAM_APPLICATION_ID
, COHI.PROGRAM_ID
, COHI.PROGRAM_UPDATE_DATE
FROM IGS_PR_COHORT_INST COHI
, IGS_LOOKUP_VALUES LKV
, IGS_LOOKUP_VALUES LKV1
, IGS_CA_INST CI
WHERE COHI.COHORT_STATUS = LKV.LOOKUP_CODE
AND LKV.LOOKUP_TYPE = 'COHORT_STATUS'
AND COHI.RANK_STATUS = LKV1.LOOKUP_CODE
AND LKV1.LOOKUP_TYPE = 'RANK_STATUS'
AND COHI.LOAD_CAL_TYPE = CI.CAL_TYPE
AND COHI.LOAD_CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER

Columns

Name
ROW_ID
COHORT_NAME
LOAD_CAL_TYPE
LOAD_CI_SEQUENCE_NUMBER
START_DT
END_DT
DESCRIPTION
COHORT_STATUS
COHORT_STATUS_MEANING
RANK_STATUS
RANK_STATUS_MEANING
RUN_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE