Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT USRC.ROWID ROW_ID
, NULL REFERENCE_CODE_ID
, USRC.UNIT_SECTION_REFERENCE_CD_ID UNIT_SECTION_REFERENCE_CD_ID
, USRC.UNIT_SECTION_REFERENCE_ID UNIT_SECTION_REFERENCE_ID
, USRC.REFERENCE_CODE_TYPE REFERENCE_CODE_TYPE
, RCT.DESCRIPTION REFERENCE_CODE_TYPE_DESC
, USRC.REFERENCE_CODE_DESC REFERENCE_CODE_DESC
, USRC.REFERENCE_CODE REFERENCE_CODE
, USRC.CREATED_BY CREATED_BY
, USRC.CREATION_DATE CREATION_DATE
, USRC.LAST_UPDATED_BY LAST_UPDATED_BY
, USRC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, USRC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_USEC_REF_CD USRC
, IGS_GE_REF_CD_TYPE RCT
WHERE USRC.REFERENCE_CODE_TYPE = RCT.REFERENCE_CD_TYPE