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]

VIEW: APPS.IGFBV_PELL_MULT_REPORT_RECORDS

Object Details

Object Name:	IGFBV_PELL_MULT_REPORT_RECORDS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGFBV_PELL_MULT_REPORT_RECORDS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Base View for the Entity that holds the information about multiple reporting records which are uploaded from an external system

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
RECORD_TYPE	VARCHAR2	(2)		Code that indicates reason institution receives record
MULTI_REP_REC_CODE1	VARCHAR2	(30)		Indicates institution requests origination or disbursement information
MULTI_REP_REC_CODE2	VARCHAR2	(30)		Indicates institution requests by selected student, selected institution, or all students
MULTI_REP_STUDENT_ID	VARCHAR2	(30)		Student SSN and name code for which multiple reporting record is requested
MULTI_REP_INSTITN_PELL_ID	VARCHAR2	(30)		Institution code for which multiple reporting records are requested
ORIGINATION_NAME_CODE	VARCHAR2	(2)		Student's name code from origination record
INSTITUTION_PELL_ID	VARCHAR2	(30)		Pell identifier of student's attended campus
INSTITUTION_NAME	VARCHAR2	(70)		Institution's name
INSTITUTION_ADDR1	VARCHAR2	(35)		Street or post office box address of institution
INSTITUTION_ADDR2	VARCHAR2	(35)		Street or post office box address of institution
INSTITUTION_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.
ORIGINATION_AWD_AMOUNT	NUMBER	(12)		Annual award amount supplied on origination record
TRANSACTION_NUMBER	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_DATE	DATE			First date student was enrolled in eligible program for award year
ORIG_CREATION_DATE	DATE			Date origination was created in recipient financial management system
DISB_ACCEPTED_AMOUNT	NUMBER	(12)		Total amount of all disbursements accepted by federal Pell grant program for POP student
LAST_ACTIVE_DATE	DATE			Date last payment was received from institution
NEXT_EST_DISB_DATE	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
STUDENT_DT_OF_BIRTH	DATE			Student's date of birth
REQ_INST_PELL_ID	VARCHAR2	(30)		Pell identifier of requesting attended campus of student
MRR_ID	NUMBER	(15)	Yes	Identifier for multiple reporting record
CREATED_BY	NUMBER	(15)	Yes	WHO column
CREATION_DATE	DATE		Yes	WHO column
LAST_UPDATED_BY	NUMBER	(15)	Yes	WHO column
LAST_UPDATE_DATE	DATE		Yes	WHO column

Query Text

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


SELECT RECORD_TYPE
,      MULTI_REP_REC_CODE1
,      MULTI_REP_REC_CODE2
,      MULTI_REP_STUDENT_ID
,      MULTI_REP_INSTITN_PELL_ID
,      ORIGINATION_NAME_CODE
,      INSTITUTION_PELL_ID
,      INSTITUTION_NAME
,      INSTITUTION_ADDR1
,      INSTITUTION_ADDR2
,      INSTITUTION_CITY
,      INST_STATE
,      ZIP_CODE
,      FAA_NAME
,      FAA_TEL
,      FAA_FAX
,      FAA_INTERNET_ADDR
,      SCHD_PELL_GRANT
,      ORIGINATION_AWD_AMOUNT
,      TRANSACTION_NUMBER
,      EFC
,      ENRL_DATE
,      ORIG_CREATION_DATE
,      DISB_ACCEPTED_AMOUNT
,      LAST_ACTIVE_DATE
,      NEXT_EST_DISB_DATE
,      ELIGIBILITY_USED
,      ED_USE_FLAGS
,      STUD_LAST_NAME
,      STUD_FIRST_NAME
,      STUD_MIDDLE_NAME
,      STUDENT_DT_OF_BIRTH
,      REQ_INST_PELL_ID
,      MRR_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGFBV_PELL_MULT_REPORT_RECORDS;

Dependencies

[top of page]

APPS.IGFBV_PELL_MULT_REPORT_RECORDS references the following:

APPS: IGF_GR_MRR_ALL

APPS.IGFBV_PELL_MULT_REPORT_RECORDS is not referenced by any database object