Product: | IGF - Financial Aid |
---|---|
Description: | Full View for the Entity that holds the information about the year to date origination data |
Implementation/DBA Data: | APPS.IGFFV_PELL_YTD_ORIGINATIONS |
SELECT YTDOR.ORIGINAL_SSN
, YTDOR.ORIGINAL_NAME_CD
, YTDOR.ATTEND_PELL_ID
, YTDOR.ED_USE
, YTDOR.INST_CROSS_REF_CODE
, '_LA:YTDOR.ACTION_CODE:IGF_LOOKUPS_VIEW:IGF_GR_ACTION_CODE:MEANING'
, YTDOR.ACCPT_AWD_AMT
, YTDOR.ACCPT_DISB_DT1
, YTDOR.ACCPT_DISB_DT2
, YTDOR.ACCPT_DISB_DT3
, YTDOR.ACCPT_DISB_DT4
, YTDOR.ACCPT_DISB_DT5
, YTDOR.ACCPT_DISB_DT6
, YTDOR.ACCPT_DISB_DT7
, YTDOR.ACCPT_DISB_DT8
, YTDOR.ACCPT_DISB_DT9
, YTDOR.ACCPT_DISB_DT10
, YTDOR.ACCPT_DISB_DT11
, YTDOR.ACCPT_DISB_DT12
, YTDOR.ACCPT_DISB_DT13
, YTDOR.ACCPT_DISB_DT14
, YTDOR.ACCPT_DISB_DT15
, YTDOR.ACCPT_ENRL_DT
, YTDOR.ACCPT_LOW_TUT_FLG
, '_LA:YTDOR.ACCPT_VER_STAT_FLG:IGF_LOOKUPS_VIEW:IGF_GR_VER_STAT_CD:MEANING'
, '_LA:YTDOR.ACCPT_INCR_PELL_CD:IGF_LOOKUPS_VIEW:IGF_GR_STU_INCARCE_STATUS:MEANING'
, YTDOR.ACCPT_TRAN_NUM
, YTDOR.ACCPT_EFC
, '_LA:YTDOR.ACCPT_SEC_EFC:IGF_LOOKUPS_VIEW:IGF_GR_SEC_EFC_CD:MEANING'
, '_LA:YTDOR.ACCPT_ACAD_CAL:IGF_LOOKUPS_VIEW:IGF_GR_ACAD_CAL:MEANING'
, '_LA:YTDOR.ACCPT_PYMT_METHOD:IGF_LOOKUPS_VIEW:IGF_GR_PAYMENT_METHOD:MEANING'
, YTDOR.ACCPT_COA
, '_LA:YTDOR.ACCPT_ENRL_STAT:IGF_LOOKUPS_VIEW:IGF_GR_RFMS_ENROL_STAT:MEANING'
, YTDOR.ACCPT_WKS_INST_PYMT
, YTDOR.WK_INST_TIME_CALC_PYMT
, YTDOR.ACCPT_WKS_ACAD
, YTDOR.ACCPT_CR_ACAD_YR
, YTDOR.INST_SEQ_NUM
, YTDOR.SCH_FULL_TIME_PELL
, YTDOR.STUD_NAME
, YTDOR.STUD_DOB
, YTDOR.CPS_VER_SEL_CD
, YTDOR.YTD_DISB_AMT
, YTDOR.BATCH_ID
, YTDOR.PROCESS_DATE
, YTDOR.ORIGINATION_ID
, YTDOR.YTDOR_ID
, YTDOR.CREATED_BY
, YTDOR.CREATION_DATE
, YTDOR.LAST_UPDATED_BY
, YTDOR.LAST_UPDATE_DATE
FROM IGF_GR_YTD_ORIG_ALL YTDOR WITH READ ONLY