[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_SL_REP_F_SMRY_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | FIN_SMRY_REC_ID |
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 |
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;
IGF.IGF_SL_REP_F_SMRY does not reference any database object
IGF.IGF_SL_REP_F_SMRY is referenced by following:
|
|
|