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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IGF.IGF_GR_MRR_ALL

Object Details

Object Name:	IGF_GR_MRR_ALL
Object Type:	TABLE
Owner:	IGF
FND Design Data:	IGF.IGF_GR_MRR_ALL
Subobject Name:
Status:	VALID

IGF_GR_MRR_ALL stores multiple reporting records that are uploaded from an external system.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_GR_MRR_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	MRR_ID

Columns

Name	Datatype	Length	Mandatory	Comments
MRR_ID	NUMBER	(15)	Yes	Identifier for multiple reporting record
RECORD_TYPE	VARCHAR2	(2)		Code that indicates reason institution receives record
REQ_INST_PELL_ID	VARCHAR2	(30)		Pell identifier of requesting attended campus of student
MRR_CODE1	VARCHAR2	(30)		Indicates institution requests origination or disbursement information
MRR_CODE2	VARCHAR2	(30)		Indicates institution requests by selected student, selected institution, or all students
MR_STUD_ID	VARCHAR2	(30)		Student SSN and name code for which multiple reporting record is requested
MR_INST_PELL_ID	VARCHAR2	(30)		Institution code for which multiple reporting records are requested
STUD_ORIG_SSN	VARCHAR2	(9)		Student's original SSN from origination record
ORIG_NAME_CD	VARCHAR2	(2)		Student's name code from origination record
INST_PELL_ID	VARCHAR2	(30)		Pell identifier of student's attended campus
INST_NAME	VARCHAR2	(70)		Institution's name
INST_ADDR1	VARCHAR2	(35)		Street or post office box address of institution
INST_ADDR2	VARCHAR2	(35)		Street or post office box address of institution
INST_CITY	VARCHAR2	(25)		City in which institution is located
INST_STATE	VARCHAR2	(2)		Two-character code assigned by US Postal Service to state or other entity in which institution is located
ZIP_CODE	VARCHAR2	(9)		Institution's zip code
FAA_NAME	VARCHAR2	(30)		Full name of institutional administrator officially responsible for accuracy and completeness of data, starting with first name
FAA_TEL	VARCHAR2	(30)		Work phone number for person indicated as institutional adminstrator
FAA_FAX	VARCHAR2	(30)		Work fax number used by person indicated as institutional adminstrator
FAA_INTERNET_ADDR	VARCHAR2	(100)		Internet address of authorized official
SCHD_PELL_GRANT	NUMBER	(12)		Scheduled federal Pell grant for student with EFC and cost of attendance. Attended full time for full academic year.
ORIG_AWD_AMT	NUMBER	(12)		Annual award amount supplied on origination record
TRAN_NUM	VARCHAR2	(2)		Transaction number from eligible student aid report used to calculate award
EFC	NUMBER	(12)		Amount of student's EFC from student aid report used to calculate award
ENRL_DT	DATE			First date student was enrolled in eligible program for award year
ORIG_CREATION_DT	DATE			Date origination was created in recipient financial management system
DISB_ACCEPTED_AMT	NUMBER	(12)		Total amount of all disbursements accepted by federal Pell grant program for POP student
LAST_ACTIVE_DT	DATE			Date last payment was received from institution
NEXT_EST_DISB_DT	DATE			Date of next estimated disbursement
ELIGIBILITY_USED	NUMBER	(7)		Percentage of student's eligibility used by institution
ED_USE_FLAGS	VARCHAR2	(30)		Flags set to inform institutions of modifications made to database that require immediate action to rectify
STUD_LAST_NAME	VARCHAR2	(30)		Student's last name
STUD_FIRST_NAME	VARCHAR2	(30)		Student's first name
STUD_MIDDLE_NAME	VARCHAR2	(30)		Student's middle initial
STUD_DOB	DATE			Student's date of birth
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who column for concurrent programs
PROGRAM_ID	NUMBER	(15)		Standard Who column for concurrent programs
PROGRAM_UPDATE_DATE	DATE			Standard Who column for concurrent programs
REQUEST_ID	NUMBER	(15)		Standard Who column for concurrent programs
ORG_ID	NUMBER	(15)		Operating unit identifier
CURRENT_SSN	VARCHAR2	(30)		Current Social Security Number

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT MRR_ID
,      RECORD_TYPE
,      REQ_INST_PELL_ID
,      MRR_CODE1
,      MRR_CODE2
,      MR_STUD_ID
,      MR_INST_PELL_ID
,      STUD_ORIG_SSN
,      ORIG_NAME_CD
,      INST_PELL_ID
,      INST_NAME
,      INST_ADDR1
,      INST_ADDR2
,      INST_CITY
,      INST_STATE
,      ZIP_CODE
,      FAA_NAME
,      FAA_TEL
,      FAA_FAX
,      FAA_INTERNET_ADDR
,      SCHD_PELL_GRANT
,      ORIG_AWD_AMT
,      TRAN_NUM
,      EFC
,      ENRL_DT
,      ORIG_CREATION_DT
,      DISB_ACCEPTED_AMT
,      LAST_ACTIVE_DT
,      NEXT_EST_DISB_DT
,      ELIGIBILITY_USED
,      ED_USE_FLAGS
,      STUD_LAST_NAME
,      STUD_FIRST_NAME
,      STUD_MIDDLE_NAME
,      STUD_DOB
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      ORG_ID
,      CURRENT_SSN
FROM IGF.IGF_GR_MRR_ALL;

Dependencies

[top of page]

IGF.IGF_GR_MRR_ALL does not reference any database object

IGF.IGF_GR_MRR_ALL is referenced by following:

APPS: IGF_GR_MRR_ALL