[Home] [Help]
View: IGSBV_PR_COHORTS
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | Stores Cohort details |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
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
, '_LA:COH.DFLT_DISPLAY_TYPE:IGS_LOOKUP_VALUES:DFLT_DISPLAY_TYPE:MEANING'
, '_LA:COH.TIMEFRAME:IGS_LOOKUP_VALUES:TIMEFRAME:MEANING'
, COH.CLOSED_IND
, COH.CREATED_BY
, COH.CREATION_DATE
, COH.LAST_UPDATED_BY
, COH.LAST_UPDATE_DATE
FROM IGS_PR_COHORT COH WITH READ ONLY
Columns
| Name |
| COHORT_NAME |
| DESCRIPTION |
| ORGANIZATION_CODE |
| STATISTICS_TYPE |
| DEFAULT_DISPLAY_TYPE |
| TIMEFRAME |
| DENSE_RANK_IND |
| INCL_ON_TRANSCRIPT_IND |
| INCL_ON_STUD_ACAD_HIST_IND |
| RULE_SEQUENCE_NUMBER |
| "_LA: DFLT_DISPLAY_TYPE_DESC" |
| "_LA: TIMEFRAME_MEANING" |
| CLOSED_IND |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |