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.IGF_GR_REP_PELL_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DOCUMENT_ID_TXT	VARCHAR2	(30)		Indicates the Document ID
REP_ENTITY_ID_TXT	VARCHAR2	(30)		Indicates the reporting school entity ID
ATD_ENTITY_ID_TXT	VARCHAR2	(30)		Indicates the attending school entity ID
BASE_ID	NUMBER		Yes	Indicates the base ID for the student
AWARD_ID	NUMBER		Yes	Identifier for the award
FIN_AWARD_YEAR	VARCHAR2	(30)		Indicates the year corresponding to awards.
CPS_TRANS_NUM	NUMBER			Indicates the transaction number from eligible ISIR used to calculate award.
AWARD_AMT	NUMBER			Indicates the total award amount that the student is eligible to receive as determined by the school.
NOTE_MESSAGE	VARCHAR2	(100)		Indicates the Note Message
ATTENDANCE_COST	NUMBER			Indicates the Attendance Cost
LOW_TUTION_FEE	VARCHAR2	(30)		Indicator identifying tuition ranges when the annual tuition is less than or equal to minimum defined by low tuition and fees table.
INCARC_FLAG	VARCHAR2	(5)		Indicator identifying if the student is incarcerated in local penal institution but otherwise eligible to receive Federal Pell Grants.
VER_STATUS_CODE	VARCHAR2	(30)		Verification status of the applicant as reported by the school.
ENROLLMENT_DATE	VARCHAR2	(10)		Indicates the Enrollment Date
SEC_EFC_CODE	VARCHAR2	(30)		Indicates secondary efc code

Query Text

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


SELECT DOCUMENT_ID_TXT
,      REP_ENTITY_ID_TXT
,      ATD_ENTITY_ID_TXT
,      BASE_ID
,      AWARD_ID
,      FIN_AWARD_YEAR
,      CPS_TRANS_NUM
,      AWARD_AMT
,      NOTE_MESSAGE
,      ATTENDANCE_COST
,      LOW_TUTION_FEE
,      INCARC_FLAG
,      VER_STATUS_CODE
,      ENROLLMENT_DATE
,      SEC_EFC_CODE
FROM APPS.IGF_GR_REP_PELL_V;

Dependencies

[top of page]

APPS.IGF_GR_REP_PELL_V references the following:

APPS: IGF_GR_COD_DTLS

APPS.IGF_GR_REP_PELL_V is not referenced by any database object