Product: | IGF - Financial Aid (Obsolete) |
---|---|
Description: | Financial Aid Base Record Anticipated Data View |
Implementation/DBA Data: | Not implemented in this database |
SELECT FA.ROWID
, FA.BASE_ID
, LD.ALTERNATE_CODE
, FA.LD_CAL_TYPE
, FA.LD_SEQUENCE_NUMBER
, LD.START_DT
, LD.END_DT
, FA.ORG_UNIT_CD
, FA.PROGRAM_TYPE
, FA.PROGRAM_LOCATION_CD
, FA.PROGRAM_CD
, FA.CLASS_STANDING
, FA.RESIDENCY_STATUS_CODE
, FA.HOUSING_STATUS_CODE
, FA.ATTENDANCE_TYPE
, FA.ATTENDANCE_MODE
, FA.MONTHS_ENROLLED_NUM
, FA.CREDIT_POINTS_NUM
, FA.CREATED_BY
, FA.CREATION_DATE
, FA.LAST_UPDATED_BY
, FA.LAST_UPDATE_DATE
, FA.LAST_UPDATE_LOGIN
FROM IGF_AP_FA_ANT_DATA FA
, IGS_CA_INST LD
WHERE FA.LD_CAL_TYPE = LD.CAL_TYPE
AND FA.LD_SEQUENCE_NUMBER = LD.SEQUENCE_NUMBER