View: IGF_AP_ATTEND_MAP_V

Product:	IGF - Financial Aid
Description:	Stores the mapping from Attendance Types, which are user-defined in OSS to the Attendance Types(enrollment status of Pell Grants/FFELP Loans/Application Processing) which is used in Financial Aid
Implementation/DBA Data:	APPS.IGF_AP_ATTEND_MAP_V

View Text

SELECT ATMMV.ROW_ID
, ATMMV.ATM_ID
, ATMMV.ATTENDANCE_TYPE
, ATMMV.PELL_ATT_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_GR_RFMS_ENROL_STAT'
, ATMMV.PELL_ATT_CODE)
, ATMMV.CL_ATT_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_ENROL_STATUS'
, ATMMV.CL_ATT_CODE)
, ATMMV.AP_ATT_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_AP_ENRL_STAT'
, ATMMV.AP_ATT_CODE)
, ATMMV.CREATED_BY
, ATMMV.CREATION_DATE
, ATMMV.LAST_UPDATED_BY
, ATMMV.LAST_UPDATE_DATE
, ATMMV.LAST_UPDATE_LOGIN
, ATMMV.ORG_ID
, ATMMV.CAL_TYPE
, ATMMV.SEQUENCE_NUMBER
, CA.ALTERNATE_CODE
, CA.START_DT
, CA.END_DT
FROM IGF_AP_ATTEND_MAP ATMMV
, IGS_CA_INST CA
WHERE CA.CAL_TYPE = ATMMV.CAL_TYPE
AND CA.SEQUENCE_NUMBER = ATMMV.SEQUENCE_NUMBER

Columns