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_RECRUIT_PI_V

Product:	IGS - Student System (Obsolete)
Description:	This view displays all records from IGS_AD_RECRUITMENT_PI table.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT IRP.ROWID ROW_ID
, IRP.PROBABILITY_INDEX_ID
, IRP.PERSON_ID
, IRP.PROBABILITY_TYPE_CODE_ID
, IACT.NAME TYPE_NAME
, IRP.CALCULATION_DATE
, IRP.PROBABILITY_VALUE
, IRP.PROBABILITY_SOURCE_CODE_ID
, IACS.NAME SOURCE_NAME
, IRP.CREATED_BY
, IRP.CREATION_DATE
, IRP.LAST_UPDATED_BY
, IRP.LAST_UPDATE_DATE
, IRP.LAST_UPDATE_LOGIN
FROM IGS_AD_RECRUIT_PI IRP
, IGS_AD_CODE_CLASSES IACT
, IGS_AD_CODE_CLASSES IACS
WHERE IACT.CLASS (+) = 'PROB_TYPE'
AND IACT.CODE_ID (+) = IRP.PROBABILITY_TYPE_CODE_ID
AND IACS.CLASS(+) = 'PROB_SOURCE'
AND IACS.CODE_ID (+) = IRP.PROBABILITY_SOURCE_CODE_ID

Columns

Name
ROW_ID
PROBABILITY_INDEX_ID
PERSON_ID
PROBABILITY_TYPE_CODE_ID
TYPE_NAME
CALCULATION_DATE
PROBABILITY_VALUE
PROBABILITY_SOURCE_CODE_ID
SOURCE_NAME
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN