Product: | IGF - Financial Aid |
---|---|
Description: | Base View for the Entity that holds the information about multiple reporting records which are uploaded from an external system |
Implementation/DBA Data: | APPS.IGFBV_PELL_MULT_REPORT_RECORDS |
SELECT GMRR.RECORD_TYPE
, GMRR.MRR_CODE1
, GMRR.MRR_CODE2
, GMRR.MR_STUD_ID
, GMRR.MR_INST_PELL_ID
, GMRR.ORIG_NAME_CD
, GMRR.INST_PELL_ID
, GMRR.INST_NAME
, GMRR.INST_ADDR1
, GMRR.INST_ADDR2
, GMRR.INST_CITY
, GMRR.INST_STATE
, GMRR.ZIP_CODE
, GMRR.FAA_NAME
, GMRR.FAA_TEL
, GMRR.FAA_FAX
, GMRR.FAA_INTERNET_ADDR
, GMRR.SCHD_PELL_GRANT
, GMRR.ORIG_AWD_AMT
, GMRR.TRAN_NUM
, GMRR.EFC
, GMRR.ENRL_DT
, GMRR.ORIG_CREATION_DT
, GMRR.DISB_ACCEPTED_AMT
, GMRR.LAST_ACTIVE_DT
, GMRR.NEXT_EST_DISB_DT
, GMRR.ELIGIBILITY_USED
, GMRR.ED_USE_FLAGS
, GMRR.STUD_LAST_NAME
, GMRR.STUD_FIRST_NAME
, GMRR.STUD_MIDDLE_NAME
, GMRR.STUD_DOB
, GMRR.REQ_INST_PELL_ID
, GMRR.MRR_ID
, GMRR.CREATED_BY
, GMRR.CREATION_DATE
, GMRR.LAST_UPDATED_BY
, GMRR.LAST_UPDATE_DATE
FROM IGF_GR_MRR_ALL GMRR WITH READ ONLY