VIEW: APPS.IGFBV_PELL_ORIGINATIONS

Source

View Text - Preformatted

SELECT RFMS.ORIGINATION_ID, RFMS.SYS_ORIG_SSN, RFMS.SYS_ORIG_NAME_CD, RFMS.TRANSACTION_NUM, RFMS.EFC, '_LA:RFMS.VER_STATUS_CODE:IGF_LOOKUPS_VIEW:IGF_GR_VER_STAT_CD:MEANING', RFMS.SECONDARY_EFC, '_LA:RFMS.SECONDARY_EFC_CD:IGF_LOOKUPS_VIEW:IGF_GR_SEC_EFC_CD:MEANING', RFMS.PELL_AMOUNT, '_LA:RFMS.ENROLLMENT_STATUS:IGF_LOOKUPS_VIEW:IGF_GR_RFMS_ENROL_STAT:MEANING', RFMS.ENROLLMENT_DT, RFMS.COA_AMOUNT, '_LA:RFMS.ACADEMIC_CALENDAR:IGF_LOOKUPS_VIEW:IGF_GR_ACAD_CAL:MEANING', '_LA:RFMS.PAYMENT_METHOD:IGF_LOOKUPS_VIEW:IGF_GR_PAYMENT_METHOD:MEANING', RFMS.TOTAL_PYMT_PRDS, '_LA:RFMS.INCRCD_FED_PELL_RCP_CD:IGF_LOOKUPS_VIEW:IGF_GR_STU_INCARCE_STATUS:MEANING', RFMS.ATTENDING_CAMPUS_ID, RFMS.EST_DISB_DT1, '_LA:RFMS.ORIG_ACTION_CODE:IGF_LOOKUPS_VIEW:IGF_GR_ORIG_STATUS:MEANING', RFMS.ORIG_STATUS_DT, RFMS.ORIG_ED_USE_FLAGS, RFMS.FT_PELL_AMOUNT, RFMS.PREV_ACCPT_EFC, RFMS.PREV_ACCPT_TRAN_NO, RFMS.PREV_ACCPT_SEC_EFC_CD, RFMS.PREV_ACCPT_COA, RFMS.ORIG_REJECT_CODE, RFMS.WK_INST_TIME_CALC_PYMT, RFMS.WK_INT_TIME_PRG_DEF_YR, RFMS.CR_CLK_HRS_PRDS_SCH_YR, RFMS.CR_CLK_HRS_ACAD_YR, RFMS.INST_CROSS_REF_CD, RFMS.LOW_TUTION_FEE, RFMS.REC_SOURCE, RFMS.FIRST_NAME, RFMS.MIDDLE_NAME, RFMS.LAST_NAME, RFMS.BIRTH_DT, RFMS.PENDING_AMOUNT, RFMS.CURRENT_SSN, '_LA:RFMS.LEGACY_RECORD_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING', RFMS.CI_CAL_TYPE, RFMS.CI_SEQUENCE_NUMBER, RFMS.AWARD_ID, RFMS.RFMB_ID, RFMS.BASE_ID, RFMS.CREATED_BY, RFMS.CREATION_DATE, RFMS.LAST_UPDATED_BY, RFMS.LAST_UPDATE_DATE, FABASE.PERSON_ID FROM IGF_GR_RFMS_ALL RFMS, IGF_AP_FA_BASE_REC_ALL FABASE WHERE FABASE.BASE_ID = RFMS.BASE_ID WITH READ ONLY

View Text - HTML Formatted

SELECT RFMS.ORIGINATION_ID
, RFMS.SYS_ORIG_SSN
, RFMS.SYS_ORIG_NAME_CD
, RFMS.TRANSACTION_NUM
, RFMS.EFC
, '_LA:RFMS.VER_STATUS_CODE:IGF_LOOKUPS_VIEW:IGF_GR_VER_STAT_CD:MEANING'
, RFMS.SECONDARY_EFC
, '_LA:RFMS.SECONDARY_EFC_CD:IGF_LOOKUPS_VIEW:IGF_GR_SEC_EFC_CD:MEANING'
, RFMS.PELL_AMOUNT
, '_LA:RFMS.ENROLLMENT_STATUS:IGF_LOOKUPS_VIEW:IGF_GR_RFMS_ENROL_STAT:MEANING'
, RFMS.ENROLLMENT_DT
, RFMS.COA_AMOUNT
, '_LA:RFMS.ACADEMIC_CALENDAR:IGF_LOOKUPS_VIEW:IGF_GR_ACAD_CAL:MEANING'
, '_LA:RFMS.PAYMENT_METHOD:IGF_LOOKUPS_VIEW:IGF_GR_PAYMENT_METHOD:MEANING'
, RFMS.TOTAL_PYMT_PRDS
, '_LA:RFMS.INCRCD_FED_PELL_RCP_CD:IGF_LOOKUPS_VIEW:IGF_GR_STU_INCARCE_STATUS:MEANING'
, RFMS.ATTENDING_CAMPUS_ID
, RFMS.EST_DISB_DT1
, '_LA:RFMS.ORIG_ACTION_CODE:IGF_LOOKUPS_VIEW:IGF_GR_ORIG_STATUS:MEANING'
, RFMS.ORIG_STATUS_DT
, RFMS.ORIG_ED_USE_FLAGS
, RFMS.FT_PELL_AMOUNT
, RFMS.PREV_ACCPT_EFC
, RFMS.PREV_ACCPT_TRAN_NO
, RFMS.PREV_ACCPT_SEC_EFC_CD
, RFMS.PREV_ACCPT_COA
, RFMS.ORIG_REJECT_CODE
, RFMS.WK_INST_TIME_CALC_PYMT
, RFMS.WK_INT_TIME_PRG_DEF_YR
, RFMS.CR_CLK_HRS_PRDS_SCH_YR
, RFMS.CR_CLK_HRS_ACAD_YR
, RFMS.INST_CROSS_REF_CD
, RFMS.LOW_TUTION_FEE
, RFMS.REC_SOURCE
, RFMS.FIRST_NAME
, RFMS.MIDDLE_NAME
, RFMS.LAST_NAME
, RFMS.BIRTH_DT
, RFMS.PENDING_AMOUNT
, RFMS.CURRENT_SSN
, '_LA:RFMS.LEGACY_RECORD_FLAG:IGF_LOOKUPS_VIEW:IGF_AP_YES_NO:MEANING'
, RFMS.CI_CAL_TYPE
, RFMS.CI_SEQUENCE_NUMBER
, RFMS.AWARD_ID
, RFMS.RFMB_ID
, RFMS.BASE_ID
, RFMS.CREATED_BY
, RFMS.CREATION_DATE
, RFMS.LAST_UPDATED_BY
, RFMS.LAST_UPDATE_DATE
, FABASE.PERSON_ID
FROM IGF_GR_RFMS_ALL RFMS
, IGF_AP_FA_BASE_REC_ALL FABASE
WHERE FABASE.BASE_ID = RFMS.BASE_ID WITH READ ONLY