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_SBMAO_FN_UITT_V

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

View Text

SELECT SAFUT.ROWID ROW_ID
, SAFUT.SUBMISSION_YR SUBMISSION_YR
, SAFUT.SUBMISSION_NUMBER SUBMISSION_NUMBER
, SAFUT.ORG_UNIT_CD ORG_UNIT_CD
, SAFUT.OU_START_DT OU_START_DT
, SAFUT.FUNDING_SOURCE FUNDING_SOURCE
, SAFUT.UNIT_INT_COURSE_LEVEL_CD UNIT_INT_COURSE_LEVEL_CD
, SAFUT.INTAKE_TARGET_TYPE INTAKE_TARGET_TYPE
, SAFUT.TARGET TARGET
, SAFUT.MAX_TARGET MAX_TARGET
, SAFUT.OVERRIDE_S_AMOUNT_TYPE OVERRIDE_S_AMOUNT_TYPE
, LKUPV.MEANING DSP_OVERRIDE_S_AMOUNT_TYPE
, SAFUT.ACTUAL_ENROLMENT ACTUAL_ENROLMENT
, SAFUT.ACTUAL_ENR_EFFECTIVE_DT ACTUAL_ENR_EFFECTIVE_DT
, SAFUT.CREATED_BY CREATED_BY
, SAFUT.CREATION_DATE CREATION_DATE
, SAFUT.LAST_UPDATED_BY LAST_UPDATED_BY
, SAFUT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SAFUT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_SBMAO_FN_UITT SAFUT
, IGS_LOOKUP_VALUES LKUPV
WHERE LKUPV.LOOKUP_TYPE(+) = 'AMOUNT_TYPE'
AND LKUPV.LOOKUP_CODE(+) = SAFUT.OVERRIDE_S_AMOUNT_TYPE

Columns

Name
ROW_ID
SUBMISSION_YR
SUBMISSION_NUMBER
ORG_UNIT_CD
OU_START_DT
FUNDING_SOURCE
UNIT_INT_COURSE_LEVEL_CD
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