eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGFFV_PELL_ORIGINATIONS

Product:	IGF - Financial Aid
Description:	Full View for the Entity that Stores all the RFMS data that needs to be sent to the COD system.
Implementation/DBA Data:	APPS.IGFFV_PELL_ORIGINATIONS

View Text

SELECT RFMS.ORIGINATION_ID
, RFMS.SYS_ORIG_SSN
, RFMS.SYS_ORIG_NAME_CD
, RFMS.FIRST_NAME
, RFMS.MIDDLE_NAME
, RFMS.LAST_NAME
, RFMS.BIRTH_DT
, RFMS.CURRENT_SSN
, 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.PENDING_AMOUNT
, RFMS.LEGACY_RECORD_FLAG
, CI.ALTERNATE_CODE
, CI.DESCRIPTION
, PE.PARTY_NUMBER
, PE.PARTY_NAME
, RFMB.BATCH_ID
, RFMB.RFMS_PROCESS_DT
, RFMS.BASE_ID
, RFMS.AWARD_ID
, RFMS.RFMB_ID
, RFMS.CI_CAL_TYPE
, RFMS.CI_SEQUENCE_NUMBER
, RFMS.CREATED_BY
, RFMS.CREATION_DATE
, RFMS.LAST_UPDATED_BY
, RFMS.LAST_UPDATE_DATE
, BASE.PERSON_ID
FROM IGF_GR_RFMS_ALL RFMS
, IGF_AP_FA_BASE_REC_ALL BASE
, IGS_CA_INST_ALL CI
, HZ_PARTIES PE
, IGF_GR_RFMS_BATCH_ALL RFMB
, IGF_AW_AWARD_ALL AWD
WHERE RFMS.CI_CAL_TYPE = CI.CAL_TYPE AND RFMS.CI_SEQUENCE_NUMBER = CI.SEQUENCE_NUMBER AND RFMS.BASE_ID = BASE.BASE_ID AND BASE.PERSON_ID = PE.PARTY_ID AND RFMS.RFMB_ID = RFMB.RFMB_ID(+) AND RFMS.AWARD_ID = AWD.AWARD_ID WITH READ ONLY

Columns

Name
ORIGINATION_ID
ORIGINAL_SSN
ORIGINAL_NAME_CODE
FIRST_NAME
MIDDLE_NAME
LAST_NAME
DATE_OF_BIRTH
CURRENT_SSN
TRANSACTION_NUMBER
EFC
"_LA:VERIFICATION_STATUS"
SECONDARY_EFC
"_LA:SECONDARY_EFC_CODE"
PELL_AWARD
"_LA:ENROLLMENT_STATUS"
ENROLLMENT_DATE
COST_OF_ATTENDANCE
"_LA:ACADEMIC_CALENDAR"
"_LA:PAYMENT_METHOD"
TOTAL_PAYMENT_PERIODS
"_LA:INCARCERATED_CODE"
ATTENDING_CAMPUS_ID
FIRST_DISBURSEMENT_DATE
"_LA:ORIGINATION_STATUS"
ORIGINATION_STATUS_DATE
RECTIFICATION_FLAGS
SCHEDULED_AWARD
PREVIOUSLY_ACCPTED_EFC
PREVIOUSLY_ACCPTED_TRAN_NO
PREVIOUSLY_ACCPTED_SEC_EFC
PREVIOUSLY_ACCPTED_COA
ORIGINATION_REJECT_CODE
WK_INST_TIME_CALC_PYMT
WK_INT_TIME_PRG_DEF_YR
CR_CLK_HRS_PRDS_SCH_YR
CR_CLK_HRS_ACAD_YEAR
ORIGINATION_CROSS_REFERENCE
LOW_TUITION_FEE_CODE
RECORD_SOURCE
PENDING_AMOUNT
LEGACY_RECORD_FLAG
AWARD_YEAR
AWARD_YEAR_DESCRIPTION
PERSON_NUMBER
PERSON_NAME
BATCH_IDENTIFICATION_NUMBER
BATCH_PROCESS_DATE
BASE_ID
AWARD_ID
RFMB_ID
CI_CAL_TYPE
CI_SEQUENCE_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
PERSON_ID