Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT UOR.ROWID ROW_ID
, UOR.UNIT_SEC_OCCUR_REFERENCE_ID UNIT_SEC_OCCUR_REFERENCE_ID
, UOR.UNIT_SECTION_OCCURRENCE_ID UNIT_SECTION_OCCURRENCE_ID
, UOR.REFERENCE_CODE_TYPE REFERENCE_CODE_TYPE
, RCT.DESCRIPTION REFERENCE_TYPE_DESCRIPTION
, UOR.REFERENCE_CODE REFERENCE_CODE
, UOR.REFERENCE_CODE_DESC REFERENCE_CODE_DESCRIPTION
, UOR.CREATED_BY CREATED_BY
, UOR.CREATION_DATE CREATION_DATE
, UOR.LAST_UPDATED_BY LAST_UPDATED_BY
, UOR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, UOR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_PS_USEC_OCUR_REF UOR
, IGS_GE_REF_CD_TYPE RCT
WHERE UOR.REFERENCE_CODE_TYPE = RCT.REFERENCE_CD_TYPE