[Home] [Help] [Dependency Information]
Object Name: | IGF_SL_DLDB_RSP_DTL |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_SL_DLDB_RSP_DTL |
Subobject Name: | |
Status: | VALID |
Table storing the Direct Loan Disbursement Response Elements from the response XML file
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_SL_DLDB_RSP_DTL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | DISB_RESP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DISB_RESP_ID | NUMBER | Yes | Identifier for the Direct Loan Disbursement Response records | |
DL_LOAN_RESP_ID | NUMBER | Identifier for the corresponding Direct Loan response record. | ||
DISB_NUM | NUMBER | Indicates the disbursement number | ||
DISB_AMT | NUMBER | Yes | Indicates the amount of money credited to the student's account at the school or paid to the student (or borrower if PLUS) directly. For Direct Loan, this is the gross disbursement amount before the fee and interest rebate calculations are made. | |
DISB_DATE | DATE | Indicates the date money was credited to the student's account at the school or paid to the student (or borrower if a PLUS loan) directly. | ||
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 | |
DISB_SEQ_NUM | VARCHAR2 | (30) | Indicates the number that determines the order in which transactions must be processed for a given disbursement number. | |
FIRST_DISB_FLAG | VARCHAR2 | (30) | Flag identifying the disbursement with the earliest disbursement date. | |
DISB_NET_AMT | NUMBER | Indicates the disbursement net amount | ||
DISB_FEE_AMT | NUMBER | Indicates the disbursement fee amount | ||
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. | |
PREV_SEQ_NUM | NUMBER | The previous disbursement sequence number on the COD database for the disbursement number. This tag is returned on all disbursement responses, including COD system generated responses. | ||
NOTE_MESSAGE | VARCHAR2 | (100) | Indicates the Note Message | |
RESP_CODE | VARCHAR2 | (30) | Indicates the Response Code | |
STATUS_CODE | VARCHAR2 | (30) | Indicates the status of the record whether it has been processed or not. P - Processed R - Received N - Processed, Not found in the System | |
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 DISB_RESP_ID
, DL_LOAN_RESP_ID
, DISB_NUM
, DISB_AMT
, DISB_DATE
, DISB_REL_FLAG
, DISB_SEQ_NUM
, FIRST_DISB_FLAG
, DISB_NET_AMT
, DISB_FEE_AMT
, INTEREST_REBATE_AMT
, DISB_CONF_FLAG
, PREV_SEQ_NUM
, NOTE_MESSAGE
, RESP_CODE
, STATUS_CODE
, 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_DLDB_RSP_DTL;
IGF.IGF_SL_DLDB_RSP_DTL does not reference any database object
IGF.IGF_SL_DLDB_RSP_DTL is referenced by following:
|
|
|