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_SL_RESP_F_SMRY

Object Details

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

Table storing the Response Financial Summary Tag 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_SL_RESP_F_SMRY_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	FIN_SMRY_RESP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FIN_SMRY_RESP_ID	NUMBER		Yes	Identifier for the financial summary response records
REP_SCHL_RESP_ID	NUMBER		Yes	Identifier for the corresponding reporting school response record.
FIN_AWARD_TYPE	VARCHAR2	(30)		Indicates the financial award type
FIN_AWARD_YEAR	VARCHAR2	(30)		Indicates the financial award year
TOT_CNT_NUM	NUMBER			Indicates the total number of student tags in the document. This information is summarized by award type by award year.
TOT_CNT_ACPT_NUM	NUMBER			Indicates the total number of accepted awards in this document. This information is summarized by award type and by award year.
TOT_CNT_REJ_NUM	NUMBER			Indicates the total number of rejected awards in this document. This information is summarized by award type by award year.
TOT_CNT_DUP_NUM	NUMBER			Indicates the total number of duplicate awards in this document. This information is summarized by award type by award year
TOT_CNT_CORR_NUM	NUMBER			Indicates the total number of corrected awards in this document. This information is summarized by award type by award year
TOT_CNT_VER_SLCTD_NUM	NUMBER			Indicates the total number of students in this document that are reported selected for verification by CPS. This information is summarized by award type by award year.
TOT_CNT_SSADMIN_NUM	NUMBER			Indicates the total number of students in this document that are reported by CPS to have an SSA match not equal to 4. This information is summarized by award type by award year.
TOT_REP_AWD_AMT	NUMBER			Indicates the total dollar value for awards reported in this document. This information is summarized by award type by award year.
TOT_REP_DISB_AMT	NUMBER			Indicates the total dollar value reported in this document. For Direct Loan, this is the total gross disbursement amount. This information is summarized by award type by award year.
TOT_FIN_AWD_ACPT_AMT	NUMBER			Indicates the total dollar amount accepted in this document. For Pell Grant and Direct Loan, this is the accepted award amount. This information is summarized by year by award type.
TOT_FIN_DISB_ACPT_AMT	NUMBER			Indicates the total dollar amount accepted in this document. For Pell Grant, the total disbursement amount accepted. For Direct Loan, the total gross disbursement amount accepted, regardless of the Disbursement Release Indicator. This information is summarized by year by award type.
TOT_FUND_DISB_ACPT_AMT	NUMBER			For Pell Grant, the total disbursement amount accepted with a Disbursement Release Indicator of "true". For Direct Loan, the total net disbursement amount accepted with Disbursement Release indicator of "true". This information is summarized by award type by award year.
TOT_NONFUND_DISB_ACPT_AMT	NUMBER			For Pell Grant, the total disbursement amount accepted with a Disbursement Release Indicator of "false". For Direct Loan, the total net disbursement amount accepted with Disbursement Release indicator of "false". This information is summarized by award type by award year.
TOT_FIN_AWD_CORR_AMT	NUMBER			Indicates the total dollar value reported in this document for corrected Pell disbursements. This information is summarized by award type by award year.
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 FIN_SMRY_RESP_ID
,      REP_SCHL_RESP_ID
,      FIN_AWARD_TYPE
,      FIN_AWARD_YEAR
,      TOT_CNT_NUM
,      TOT_CNT_ACPT_NUM
,      TOT_CNT_REJ_NUM
,      TOT_CNT_DUP_NUM
,      TOT_CNT_CORR_NUM
,      TOT_CNT_VER_SLCTD_NUM
,      TOT_CNT_SSADMIN_NUM
,      TOT_REP_AWD_AMT
,      TOT_REP_DISB_AMT
,      TOT_FIN_AWD_ACPT_AMT
,      TOT_FIN_DISB_ACPT_AMT
,      TOT_FUND_DISB_ACPT_AMT
,      TOT_NONFUND_DISB_ACPT_AMT
,      TOT_FIN_AWD_CORR_AMT
,      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_SL_RESP_F_SMRY;

Dependencies

[top of page]

IGF.IGF_SL_RESP_F_SMRY does not reference any database object

IGF.IGF_SL_RESP_F_SMRY is referenced by following:

APPS: IGF_SL_RESP_F_SMRY