[Home] [Help] [Dependency Information]
Object Name: | IGF_GR_DB_RESP_DTLS |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_GR_DB_RESP_DTLS |
Subobject Name: | |
Status: | VALID |
Table storing the Pell Disbursement Record Response Elements from the response XML file
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_GR_DB_RESP_DTLS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | DISB_RESP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DISB_RESP_ID | NUMBER | Yes | Identifier for the Pell Disbursement Response records | |
PELL_RESP_ID | NUMBER | Identifier for the corresponding Pell response record. | ||
DISB_NUM | NUMBER | Indicates the disbursement number | ||
DISB_AMT | VARCHAR2 | (30) | 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 | NUMBER | Indicates the number that determines the order in which transactions must be processed for a given disbursement number. | ||
PYMNT_PER_START_DATE | DATE | Beginning date of the Payment Period. Used to pay on awards submitted by schools that have become ineligible. | ||
PREV_SEQ_NUM | VARCHAR2 | (30) | 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 | |
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 | |
RESP_CODE | VARCHAR2 | (30) | Indicates the response code | |
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
, PELL_RESP_ID
, DISB_NUM
, DISB_AMT
, DISB_DATE
, DISB_REL_FLAG
, DISB_SEQ_NUM
, PYMNT_PER_START_DATE
, PREV_SEQ_NUM
, NOTE_MESSAGE
, STATUS_CODE
, RESP_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_GR_DB_RESP_DTLS;
IGF.IGF_GR_DB_RESP_DTLS does not reference any database object
IGF.IGF_GR_DB_RESP_DTLS is referenced by following:
|
|
|