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_REP_F_SMRY

Object Details

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

Table storing the Reported 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_REP_F_SMRY_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	FIN_SMRY_REC_ID

Columns

Name	Datatype	Length	Mandatory	Comments
FIN_SMRY_REC_ID	NUMBER		Yes	Identifier for the financial reported summary 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_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.
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_REC_ID
,      REP_SCHL_RESP_ID
,      FIN_AWARD_TYPE
,      FIN_AWARD_YEAR
,      TOT_CNT_NUM
,      TOT_REP_AWD_AMT
,      TOT_REP_DISB_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_REP_F_SMRY;

Dependencies

[top of page]

IGF.IGF_SL_REP_F_SMRY does not reference any database object

IGF.IGF_SL_REP_F_SMRY is referenced by following:

APPS: IGF_SL_REP_F_SMRY