Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Stores Cohort details |
Implementation/DBA Data: | Not implemented in this database |
SELECT COH.COHORT_NAME
, COH.DESCRIPTION
, COH.ORG_UNIT_CD
, COH.STAT_TYPE
, COH.DFLT_DISPLAY_TYPE
, COH.TIMEFRAME
, COH.DENSE_RANK_IND
, COH.INCL_ON_TRANSCRIPT_IND
, COH.INCL_ON_STUD_ACAD_HIST_IND
, COH.RULE_SEQUENCE_NUMBER
, STAT.DESCRIPTION
, '_LA:COH.DFLT_DISPLAY_TYPE:IGS_LOOKUP_VALUES:DFLT_DISPLAY_TYPE:MEANING'
, '_LA:COH.TIMEFRAME:IGS_LOOKUP_VALUES:TIMEFRAME:MEANING'
, HP.PARTY_NAME
, COH.CLOSED_IND
, COH.CREATED_BY
, COH.CREATION_DATE
, COH.LAST_UPDATED_BY
, COH.LAST_UPDATE_DATE
FROM IGS_PR_COHORT COH
, IGS_PR_STAT_TYPE STAT
, HZ_PARTIES HP
WHERE COH.STAT_TYPE = STAT.STAT_TYPE
AND COH.ORG_UNIT_CD = HP.PARTY_NUMBER WITH READ ONLY