[Home] [Help]
View: IGSBV_PR_COHORT_INSTS
Product: | IGS - Student System (Obsolete) |
Description: | Stores Cohort instance details |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT COHORT_NAME
, LOAD_CAL_TYPE
, LOAD_CI_SEQUENCE_NUMBER
, COHORT_STATUS
, RANK_STATUS
, RUN_DATE
, '_LA:COHI.COHORT_STATUS:IGS_LOOKUP_VALUES:COHORT_STATUS:MEANING'
, '_LA:COHI.RANK_STATUS:IGS_LOOKUP_VALUES:RANK_STATUS:MEANING'
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM IGS_PR_COHORT_INST COHI WITH READ ONLY
Columns
Name |
COHORT_NAME |
LOAD_CAL_TYPE |
LOAD_CI_SEQUENCE_NUMBER |
COHORT_STATUS |
RANK_STATUS |
RUN_DATE |
"_LA: COHORT_STATUS_DESC" |
"_LA: RANK_STATUS_DESC" |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |