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_V

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

View Text

SELECT COH.ROWID
, COH.COHORT_NAME
, COH.DESCRIPTION
, COH.ORG_UNIT_CD
, OU.DESCRIPTION
, COH.STAT_TYPE
, PST.DESCRIPTION
, COH.TIMEFRAME
, LKV1.MEANING
, COH.DFLT_DISPLAY_TYPE
, LKV.MEANING
, COH.DENSE_RANK_IND
, COH.INCL_ON_TRANSCRIPT_IND
, COH.INCL_ON_STUD_ACAD_HIST_IND
, COH.RULE_SEQUENCE_NUMBER
, IGS_RU_GEN_003.RULP_GET_RULE(COH.RULE_SEQUENCE_NUMBER)
, COH.CLOSED_IND
, COH.CREATED_BY
, COH.CREATION_DATE
, COH.LAST_UPDATED_BY
, COH.LAST_UPDATE_DATE
, COH.LAST_UPDATE_LOGIN
FROM IGS_PR_COHORT COH
, IGS_OR_UNIT OU
, IGS_PR_STAT_TYPE PST
, IGS_LOOKUP_VALUES LKV
, IGS_LOOKUP_VALUES LKV1
WHERE COH.ORG_UNIT_CD = OU.ORG_UNIT_CD (+)
AND COH.STAT_TYPE = PST.STAT_TYPE
AND COH.DFLT_DISPLAY_TYPE = LKV.LOOKUP_CODE
AND LKV.LOOKUP_TYPE = 'DFLT_DISPLAY_TYPE'
AND COH.TIMEFRAME = LKV1.LOOKUP_CODE
AND LKV1.LOOKUP_TYPE = 'TIMEFRAME'

Columns

Name
ROW_ID
COHORT_NAME
DESCRIPTION
ORG_UNIT_CD
ORG_DESCRIPTION
STAT_TYPE
STAT_DESCRIPTION
TIMEFRAME
TIMEFRAME_MEANING
DFLT_DISPLAY_TYPE
DFLT_DISP_MEANING
DENSE_RANK_IND
INCL_ON_TRANSCRIPT_IND
INCL_ON_STUD_ACAD_HIST_IND
RULE_SEQUENCE_NUMBER
RULE_TEXT
CLOSED_IND
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN