View: IGFFV_PELL_MULT_REPORT_RECORDS

Product:	IGF - Financial Aid
Description:	Full View for the Entity that holds the information about multiple reporting records which are uploaded from an external system
Implementation/DBA Data:	APPS.IGFFV_PELL_MULT_REPORT_RECORDS

View Text

SELECT GMRR.RECORD_TYPE
, GMRR.MRR_CODE1
, GMRR.MRR_CODE2
, GMRR.MR_STUD_ID
, GMRR.MR_INST_PELL_ID
, GMRR.STUD_ORIG_SSN
, 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

Columns