[Home] [Help] [Dependency Information]
Object Name: | IGF_AW_DB_COD_DTLS |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_AW_DB_COD_DTLS |
Subobject Name: | |
Status: | VALID |
Table storing disbursement details for the Direct Loan as well as Pell which are sent to COD
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_AW_DB_COD_DTLS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
AWARD_ID
DISB_NUM DISB_SEQ_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AWARD_ID | NUMBER | Yes | Identifier for the award | |
DOCUMENT_ID_TXT | VARCHAR2 | (30) | Identifier for the document | |
DISB_NUM | NUMBER | Yes | Identifier for disbursements. Number of disbursement. | |
DISB_SEQ_NUM | NUMBER | Yes | Identifies sequence of change to disbursement amount or disbursement date | |
DISB_ACCEPTED_AMT | NUMBER | Yes | Indicates disbursement accepted amount. | |
ORIG_FEE_AMT | NUMBER | Indicates new origination fees in case of Direct Loan | ||
DISB_NET_AMT | NUMBER | Indicates new disbursement net amount at time of adjustment | ||
DISB_DATE | DATE | Yes | Identifies new disbursement date after disbursement date change or existing value of disbursement date at time of adjustment | |
DISB_REL_FLAG | VARCHAR2 | (30) | The indicator identifying if the Entity is submitting an actual disbursement used to substantiate cash that has been drawn down or may lead to change in the CFL | |
FIRST_DISB_FLAG | VARCHAR2 | (30) | Flag identifying the disbursement with the earliest disbursement date | |
INTEREST_REBATE_AMT | NUMBER | Indicates the disbursement interest rebate amount | ||
DISB_CONF_FLAG | VARCHAR2 | (30) | Indication that the borrower at the school has confirmed this disbursement. | |
PYMNT_PER_START_DATE | DATE | Beginning date of the Payment Period. Used to pay on awards submitted by schools that have become ineligible. | ||
REP_ENTITY_ID_TXT | VARCHAR2 | (8) | Indicates Reporting Entity ID | |
ATD_ENTITY_ID_TXT | VARCHAR2 | (8) | Indicates Attending Entity ID | |
NOTE_MESSAGE | VARCHAR2 | (100) | Indicates the Note Message | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who column for Concurrent Program | |
PROGRAM_ID | NUMBER | (15) | Standard Who column for Concurrent Program | |
PROGRAM_UPDATE_DATE | DATE | Standard Who column for Concurrent Program | ||
REQUEST_ID | NUMBER | (15) | Standard Who column for Concurrent Program |
Cut, paste (and edit) the following text to query this object:
SELECT AWARD_ID
, DOCUMENT_ID_TXT
, DISB_NUM
, DISB_SEQ_NUM
, DISB_ACCEPTED_AMT
, ORIG_FEE_AMT
, DISB_NET_AMT
, DISB_DATE
, DISB_REL_FLAG
, FIRST_DISB_FLAG
, INTEREST_REBATE_AMT
, DISB_CONF_FLAG
, PYMNT_PER_START_DATE
, REP_ENTITY_ID_TXT
, ATD_ENTITY_ID_TXT
, NOTE_MESSAGE
, 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_AW_DB_COD_DTLS;
IGF.IGF_AW_DB_COD_DTLS does not reference any database object
IGF.IGF_AW_DB_COD_DTLS is referenced by following:
|
|
|