Product: | IGS - Student System (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT SAFCT.ROWID ROW_ID
, SAFCT.SUBMISSION_YR SUBMISSION_YR
, SAFCT.SUBMISSION_NUMBER SUBMISSION_NUMBER
, SAFCT.ORG_UNIT_CD ORG_UNIT_CD
, SAFCT.OU_START_DT OU_START_DT
, SAFCT.FUNDING_SOURCE FUNDING_SOURCE
, SAFCT.COURSE_TYPE_GROUP_CD COURSE_TYPE_GROUP_CD
, SAFCT.INTAKE_TARGET_TYPE INTAKE_TARGET_TYPE
, SAFCT.TARGET TARGET
, SAFCT.MAX_TARGET MAX_TARGET
, SAFCT.OVERRIDE_S_AMOUNT_TYPE OVERRIDE_S_AMOUNT_TYPE
, DECODE (SAFCT.OVERRIDE_S_AMOUNT_TYPE
, NULL
, NULL
, (SELECT MEANING
FROM IGS_LOOKUP_VALUES
WHERE LOOKUP_CODE = SAFCT.OVERRIDE_S_AMOUNT_TYPE
AND LOOKUP_TYPE = 'AMOUNT_TYPE' )) DSP_OVERRIDE_S_AMOUNT_TYPE
, SAFCT.ACTUAL_ENROLMENT ACTUAL_ENROLMENT
, SAFCT.ACTUAL_ENR_EFFECTIVE_DT ACTUAL_ENR_EFFECTIVE_DT
, SAFCT.CREATED_BY CREATED_BY
, SAFCT.CREATION_DATE CREATION_DATE
, SAFCT.LAST_UPDATED_BY LAST_UPDATED_BY
, SAFCT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SAFCT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_SBMAO_FN_CTTT SAFCT