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_RESP_DTLS

Object Details

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

Table storing the Pell Record Response Elements from the response XML file

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_GR_RESP_DTLS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PELL_RESP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PELL_RESP_ID	NUMBER		Yes	Identifier for the Pell Response records
STDNT_RESP_ID	NUMBER			Identifier for the corresponding Student response record.
FIN_AWD_YR	VARCHAR2	(30)		Indicates the year corresponding to awards.
CPS_TRANS_NUM	VARCHAR2	(2)		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
COA_AMT	NUMBER			The cost of attending school. For Pell, the amount must equal COA calculated by the School for a full-time student or a full academic year following the Federal Pell Grant Program requirements.
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	(30)		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	DATE			First date that the student was enrolled in an eligible program for the designated award year. If the student enrolled in a crossover payment period before the first day of the Pell award year (July 1), but which will be paid from 2004-2005 funds, report the actual start date of the student's classes for that payment period
SEC_EFC_CODE	VARCHAR2	(30)		Indicator of EFC value used to determine award amount.
YTD_DISB_AMT	NUMBER			For Pell, the total amount that has been disbursed to the student for the award year.
TOT_ELIG_USED	NUMBER			Total percentage for all schools of the student's annual Pell eligibility used for the specific award year.
SCHD_PELL_AMT	NUMBER			Scheduled amount for a full time student.
NEG_PEND_AMT	NUMBER			The amount by which the Pell award is overpaid (i.e., sum of disbursements exceeds Award Amount). School must adjust either award amount or disbursement amount within 30 days to avoid a COD-generated negative disbursement.
FSA_CODE_1	VARCHAR2	(30)		Code set to inform institutions of modifications that have been made to their database and require immediate action to rectify.
FSA_CODE_2	VARCHAR2	(30)		Code set to inform institutions of modifications that have been made to their database and require immediate action to rectify.
FSA_CODE_3	VARCHAR2	(30)		Code set to inform institutions of modifications that have been made to their database and require immediate action to rectify.
CPS_VERIF_FLAG	VARCHAR2	(30)		Indicates whether this student has been selected for verification by the CPS on any transaction number for this award year.
HIGH_CPS_TRANS_NUM	NUMBER			Indicates the highest transaction number on CPS for this student and award.
RESP_CODE	VARCHAR2	(30)		Indicates the Response Code
STATUS_CODE	VARCHAR2	(30)		Indicates the status of the record whether it has been processed or not. P - Processed R - Received N - Processed, Not found in the System
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who column
PROGRAM_ID	NUMBER	(15)		Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
REQUEST_ID	NUMBER	(15)		Standard Who column

Query Text

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


SELECT PELL_RESP_ID
,      STDNT_RESP_ID
,      FIN_AWD_YR
,      CPS_TRANS_NUM
,      AWARD_AMT
,      NOTE_MESSAGE
,      COA_AMT
,      LOW_TUTION_FEE
,      INCARC_FLAG
,      VER_STATUS_CODE
,      ENROLLMENT_DATE
,      SEC_EFC_CODE
,      YTD_DISB_AMT
,      TOT_ELIG_USED
,      SCHD_PELL_AMT
,      NEG_PEND_AMT
,      FSA_CODE_1
,      FSA_CODE_2
,      FSA_CODE_3
,      CPS_VERIF_FLAG
,      HIGH_CPS_TRANS_NUM
,      RESP_CODE
,      STATUS_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM IGF.IGF_GR_RESP_DTLS;

Dependencies

[top of page]

IGF.IGF_GR_RESP_DTLS does not reference any database object

IGF.IGF_GR_RESP_DTLS is referenced by following:

APPS: IGF_GR_RESP_DTLS