eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGSBV_HIGH_EDU_PRG_REFERENCES

Product:	IGS - Student System (Obsolete)
Description:	This is a base view, which describes a reference code or codes that relates to the program.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT REC.COURSE_CD PROGRAM_CODE
, REC.VERSION_NUMBER PROGRAM_VERSION_NUMBER
, REC.REFERENCE_CD_TYPE REFERENCE_CODE_TYPE
, REC.REFERENCE_CD REFERENCE_CODE
, REC.DESCRIPTION REFERENCE_CODE_DESCRIPTION
, VE.TITLE PROGRAM_TITLE
, RET.DESCRIPTION REFERENCE_CODE_TYPE_DESC
, REC.CREATED_BY
, REC.CREATION_DATE
, REC.LAST_UPDATED_BY
, REC.LAST_UPDATE_DATE
FROM IGS_PS_REF_CD REC
, IGS_PS_VER_ALL VE
, IGS_GE_REF_CD_TYPE_ALL RET
WHERE REC.COURSE_CD = VE.COURSE_CD
AND REC.VERSION_NUMBER = VE.VERSION_NUMBER
AND REC.REFERENCE_CD_TYPE = RET.REFERENCE_CD_TYPE WITH READ ONLY

Columns

Name
PROGRAM_CODE
PROGRAM_VERSION_NUMBER
REFERENCE_CODE_TYPE
REFERENCE_CODE
REFERENCE_CODE_DESCRIPTION
PROGRAM_TITLE
REFERENCE_CODE_TYPE_DESC
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE