VIEW: APPS.IGFFV_PELL_YTD_ORIGINATIONS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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