[Home] [Help]
View: IGF_AP_FA_ANT_DATA_V
Product: | IGF - Financial Aid |
Description: | Financial Aid Base Record Anticipated Data View |
Implementation/DBA Data: |
APPS.IGF_AP_FA_ANT_DATA_V
|
View Text
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
Columns
Name |
ROW_ID |
BASE_ID |
LD_ALTERNATE_CODE |
LD_CAL_TYPE |
LD_SEQUENCE_NUMBER |
LD_START_DT |
LD_END_DT |
ORG_UNIT_CD |
PROGRAM_TYPE |
PROGRAM_LOCATION_CD |
PROGRAM_CD |
CLASS_STANDING |
RESIDENCY_STATUS_CODE |
HOUSING_STATUS_CODE |
ATTENDANCE_TYPE |
ATTENDANCE_MODE |
MONTHS_ENROLLED_NUM |
CREDIT_POINTS_NUM |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |