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_SBMPS_FN_ITTT_V

Product:	IGS - Student System (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SCFIT.ROWID ROW_ID
, SCFIT.SUBMISSION_YR SUBMISSION_YR
, SCFIT.SUBMISSION_NUMBER SUBMISSION_NUMBER
, SCFIT.COURSE_CD COURSE_CD
, SCFIT.CRV_VERSION_NUMBER CRV_VERSION_NUMBER
, SCFIT.FUNDING_SOURCE FUNDING_SOURCE
, SCFIT.PRIORITY_OF_TARGET PRIORITY_OF_TARGET
, SCFIT.SEQUENCE_NUMBER SEQUENCE_NUMBER
, SCFIT.INTAKE_TARGET_TYPE INTAKE_TARGET_TYPE
, SCFIT.TARGET TARGET
, SCFIT.MAX_TARGET MAX_TARGET
, SCFIT.OVERRIDE_S_AMOUNT_TYPE OVERRIDE_S_AMOUNT_TYPE
, LKUPV.MEANING DSP_OVERRIDE_S_AMOUNT_TYPE
, SCFIT.ACTUAL_ENROLMENT ACTUAL_ENROLMENT
, SCFIT.ACTUAL_ENR_EFFECTIVE_DT ACTUAL_ENR_EFFECTIVE_DT
, SCFIT.CREATED_BY CREATED_BY
, SCFIT.CREATION_DATE CREATION_DATE
, SCFIT.LAST_UPDATED_BY LAST_UPDATED_BY
, SCFIT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SCFIT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_SBMPS_FN_ITTT SCFIT
, IGS_LOOKUPS_VIEW LKUPV
WHERE LKUPV.LOOKUP_TYPE (+) = 'AMOUNT_TYPE'
AND LKUPV.LOOKUP_CODE(+) = SCFIT.OVERRIDE_S_AMOUNT_TYPE

Columns

Name
ROW_ID
SUBMISSION_YR
SUBMISSION_NUMBER
COURSE_CD
CRV_VERSION_NUMBER
FUNDING_SOURCE
PRIORITY_OF_TARGET
SEQUENCE_NUMBER
INTAKE_TARGET_TYPE
TARGET
MAX_TARGET
OVERRIDE_S_AMOUNT_TYPE
DSP_OVERRIDE_S_AMOUNT_TYPE
ACTUAL_ENROLMENT
ACTUAL_ENR_EFFECTIVE_DT
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN