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: IGS_AD_APL_RVPF_RSL_V

Product:	IGS - Student System (Obsolete)
Description:	View where all Rating Scale related information corresponding to an Application Review Profile will be recorded.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT RS.ROWID
, RS.APPL_REVPROF_RTSCALE_ID
, RS.APPL_REV_PROFILE_ID
, RS.RATING_TYPE_ID
, CC.NAME
, CC.DESCRIPTION
, RS.RATING_SCALE_ID
, ARS.RATING_SCALE_NAME
, ARS.DESCRIPTION
, RS.CREATED_BY
, RS.CREATION_DATE
, RS.LAST_UPDATED_BY
, RS.LAST_UPDATE_DATE
, RS.LAST_UPDATE_LOGIN
FROM IGS_AD_APL_RVPF_RSL RS
, IGS_AD_RATING_SCALES_V ARS
, IGS_AD_CODE_CLASSES CC
WHERE RS.RATING_TYPE_ID = CC.CODE_ID
AND NVL(CC.CLOSED_IND
, 'N') <> 'Y'
AND RS.RATING_SCALE_ID = ARS. RATING_SCALE_ID
AND NVL(ARS.CLOSED_IND
, 'N') <> 'Y'

Columns

Name
ROW_ID
APPL_REVPROF_RTSCALE_ID
APPL_REV_PROFILE_ID
RATING_TYPE_ID
RATING_TYPE
RATING_TYPE_DESC
RATING_SCALE_ID
RATING_SCALE_NAME
RATING_SCALE_DESC
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN