[Home] [Help] [Dependency Information]
Object Name: | IGF_AW_DB_CHG_DTLS |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_AW_DB_CHG_DTLS |
Subobject Name: | |
Status: | VALID |
Table storing disbursement details for the Direct Loan as well as Pell Grant
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_AW_DB_CHG_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 | |
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 new gross disbursement amount after adjustment | |
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_ACTIVITY | VARCHAR2 | (30) | Indicates whether disbursement record stands for actual disbursement made, adjustments on disbursement net amount, or changes on disbursement date | |
DISB_STATUS | VARCHAR2 | (30) | Indicates status of adjustment for particular student availing Direct Loan | |
DISB_STATUS_DATE | DATE | Indicates the date on which the disbursement status was changed | ||
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_PRD_START_DATE | DATE | Beginning date of the Payment Period. Used to pay on awards submitted by schools that have become ineligible. | ||
NOTE_MESSAGE | VARCHAR2 | (100) | Indicates the Note Message | |
BATCH_ID_TXT | VARCHAR2 | (40) | Indiacates batch id | |
ACK_DATE | DATE | Indicates acknowledge date | ||
BOOKING_ID_TXT | VARCHAR2 | (40) | Indicates booking id | |
BOOKING_DATE | DATE | Indicates booking date | ||
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
, DISB_NUM
, DISB_SEQ_NUM
, DISB_ACCEPTED_AMT
, ORIG_FEE_AMT
, DISB_NET_AMT
, DISB_DATE
, DISB_ACTIVITY
, DISB_STATUS
, DISB_STATUS_DATE
, DISB_REL_FLAG
, FIRST_DISB_FLAG
, INTEREST_REBATE_AMT
, DISB_CONF_FLAG
, PYMNT_PRD_START_DATE
, NOTE_MESSAGE
, BATCH_ID_TXT
, ACK_DATE
, BOOKING_ID_TXT
, BOOKING_DATE
, 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_CHG_DTLS;
IGF.IGF_AW_DB_CHG_DTLS does not reference any database object
IGF.IGF_AW_DB_CHG_DTLS is referenced by following:
|
|
|