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_AMTT_V

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

View Text

SELECT SAFAT.ROWID ROW_ID
, SAFAT.SUBMISSION_YR SUBMISSION_YR
, SAFAT.SUBMISSION_NUMBER SUBMISSION_NUMBER
, SAFAT.ORG_UNIT_CD ORG_UNIT_CD
, SAFAT.OU_START_DT OU_START_DT
, SAFAT.FUNDING_SOURCE FUNDING_SOURCE
, SAFAT.ATTENDANCE_MODE ATTENDANCE_MODE
, SAFAT.INTAKE_TARGET_TYPE INTAKE_TARGET_TYPE
, SAFAT.TARGET TARGET
, SAFAT.MAX_TARGET MAX_TARGET
, SAFAT.OVERRIDE_S_AMOUNT_TYPE OVERRIDE_S_AMOUNT_TYPE
, DECODE (SAFAT.OVERRIDE_S_AMOUNT_TYPE
, NULL
, NULL
, (SELECT MEANING
FROM IGS_LOOKUP_VALUES
WHERE LOOKUP_CODE = SAFAT.OVERRIDE_S_AMOUNT_TYPE
AND LOOKUP_TYPE = 'AMOUNT_TYPE' )) DSP_OVERRIDE_S_AMOUNT_TYPE
, SAFAT.ACTUAL_ENROLMENT ACTUAL_ENROLMENT
, SAFAT.ACTUAL_ENR_EFFECTIVE_DT ACTUAL_ENR_EFFECTIVE_DT
, SAFAT.CREATED_BY CREATED_BY
, SAFAT.CREATION_DATE CREATION_DATE
, SAFAT.LAST_UPDATED_BY LAST_UPDATED_BY
, SAFAT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SAFAT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_SBMAO_FN_AMTT SAFAT

Columns

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