[Home] [Help] [Dependency Information]
Object Name: | IGF_SL_REP_SMRY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGF_SL_REP_SMRY_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DOCUMENT_ID_TXT | VARCHAR2 | (30) | Indicates the Document ID | |
REP_ENTITY_ID_TXT | VARCHAR2 | (30) | Indicates the reporting school entity ID | |
FIN_AWARD_YEAR | VARCHAR2 | (30) | Indicates the financial award year | |
LOAN_TYPE | VARCHAR2 | (30) | Yes | Indicates loan type |
FIN_AWARD_TYPE | VARCHAR2 | (14) | Indicates the financial award type | |
TOT_CNT_NUM | NUMBER | Indicates the total number of student tags in thedocument. 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. |
Cut, paste (and edit) the following text to query this object:
SELECT DOCUMENT_ID_TXT
, REP_ENTITY_ID_TXT
, FIN_AWARD_YEAR
, LOAN_TYPE
, FIN_AWARD_TYPE
, TOT_CNT_NUM
, TOT_REP_AWD_AMT
, TOT_REP_DISB_AMT
FROM APPS.IGF_SL_REP_SMRY_V;
|
|
|