Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT RCT.ROWID ROW_ID
, RCT.REFERENCE_CD_TYPE REFERENCE_CD_TYPE
, RCT.DESCRIPTION DESCRIPTION
, RCT.SELF_SERVICE_FLAG SELF_SERVICE_FLAG
, RCT.PROGRAM_FLAG PROGRAM_FLAG
, RCT.PROGRAM_OFFERING_OPTION_FLAG PROGRAM_OFFERING_OPTION_FLAG
, RCT.UNIT_FLAG UNIT_FLAG
, RCT.UNIT_SECTION_FLAG UNIT_SECTION_FLAG
, RCT.UNIT_SECTION_OCCURRENCE_FLAG UNIT_SECTION_OCCURRENCE_FLAG
, RCT.S_REFERENCE_CD_TYPE S_REFERENCE_CD_TYPE
, RCT.CLOSED_IND CLOSED_IND
, RCT.CREATED_BY CREATED_BY
, RCT.CREATION_DATE CREATION_DATE
, RCT.LAST_UPDATED_BY LAST_UPDATED_BY
, RCT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RCT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ILV.MEANING DSP_MEANING
, ILV.CLOSED_IND DSP_CLOSED_IND
, RCT.MANDATORY_FLAG MANDATORY_FLAG
, RCT.RESTRICTED_FLAG
FROM IGS_GE_REF_CD_TYPE RCT
, IGS_LOOKUPS_VIEW ILV
WHERE ILV.LOOKUP_CODE = RCT.S_REFERENCE_CD_TYPE
AND ILV.LOOKUP_TYPE = 'REFERENCE_CD_TYPE'