Skip to content

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

VIEW: APPS.IGF_GR_PELL_RNG_AMT

Object Details
Object Name: IGF_GR_PELL_RNG_AMT
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGF.IGF_GR_PELL_RNG_AMT
Subobject Name:
Status: VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.


No longer used.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Database rowid for igf_gr_pell_rng_amt table
ENROLLMENT_STAT VARCHAR2 (30) Yes Enrollment status code of the student
CI_CAL_TYPE VARCHAR2 (10) Yes Indicates the code for the award year calender type, used within the operating unit
CI_SEQUENCE_NUMBER NUMBER (6) Yes Indicates a unique identifier for the award year calender instance
COA_START NUMBER (12) Yes Start range of the cost of attendance values
COA_END NUMBER (12) Yes End range of the cost of attendance values
EFC_START NUMBER (12) Yes Start range of the expected family contribution
EFC_END NUMBER (12) Yes End range of the expected family contribution
AMOUNT NUMBER (12) Yes Amount of Pell grant
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
ORG_ID NUMBER (15)
Query Text

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


SELECT ROW_ID
,      ENROLLMENT_STAT
,      CI_CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      COA_START
,      COA_END
,      EFC_START
,      EFC_END
,      AMOUNT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
FROM APPS.IGF_GR_PELL_RNG_AMT;

Dependencies

[top of page]

APPS.IGF_GR_PELL_RNG_AMT references the following:

SchemaAPPS
SynonymIGF_GR_PELL_RNG_AMT_ALL
APPS.IGF_GR_PELL_RNG_AMT is referenced by following:

SchemaAPPS
ViewIGF_GR_PELL_RNG_AMT_V