[Home] [Help] [Dependency Information]
Object Name: | IGF_GR_RFMS_DISB_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_GR_RFMS_DISB_ALL |
Subobject Name: | |
Status: | VALID |
IGF_GR_RFMS_DISB_ALL stores the recipient financial management system disbursement data, which needs to be sent to the recipient financial management system.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_GR_RFMS_DISB_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | RFMD_ID |
IGF_GR_RFMS_DISB_ALL_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
DISB_REF_NUM
ORIGINATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RFMD_ID | NUMBER | (15) | Yes | Identifier for each RFMS disbursement |
ORIGINATION_ID | VARCHAR2 | (30) | Yes | Unique code for each origination |
DISB_REF_NUM | VARCHAR2 | (30) | Yes | Number of disbursement |
DISB_DT | DATE | Date disbursement is made to student | ||
DISB_AMT | NUMBER | (12) | Yes | Amount of disbursement for student |
DB_CR_FLAG | VARCHAR2 | (1) | Yes | Indicates if disbursement amount is positive or negative |
DISB_ACK_ACT_STATUS | VARCHAR2 | (1) | Code to indicate processing status of disbursement | |
DISB_STATUS_DT | DATE | Reflects date on which status of disbursement changed | ||
ACCPT_DISB_DT | DATE | Date which disbursement was accepted | ||
DISB_ACCPT_AMT | NUMBER | (12) | Amount of disbursement for student | |
ACCPT_DB_CR_FLAG | VARCHAR2 | (1) | Indicates if disbursement amount is positive or negative | |
DISB_YTD_AMT | NUMBER | (12) | Total amount disbursed to student for award year | |
PYMT_PRD_START_DT | DATE | Begin date of payment period | ||
ACCPT_PYMT_PRD_START_DT | DATE | Accepted begin date of payment period | ||
EDIT_CODE | VARCHAR2 | (75) | Error code sent from government | |
RFMB_ID | NUMBER | (15) | Stores batch identifier sent to external RFMS | |
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 programs | |
PROGRAM_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
PROGRAM_UPDATE_DATE | DATE | Standard Who column for concurrent programs | ||
REQUEST_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
ORG_ID | NUMBER | (15) | Operating unit identifier | |
ED_USE_FLAGS | VARCHAR2 | (30) | Indicates data used by Electronic Data Exchange |
Cut, paste (and edit) the following text to query this object:
SELECT RFMD_ID
, ORIGINATION_ID
, DISB_REF_NUM
, DISB_DT
, DISB_AMT
, DB_CR_FLAG
, DISB_ACK_ACT_STATUS
, DISB_STATUS_DT
, ACCPT_DISB_DT
, DISB_ACCPT_AMT
, ACCPT_DB_CR_FLAG
, DISB_YTD_AMT
, PYMT_PRD_START_DT
, ACCPT_PYMT_PRD_START_DT
, EDIT_CODE
, RFMB_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, ORG_ID
, ED_USE_FLAGS
FROM IGF.IGF_GR_RFMS_DISB_ALL;
IGF.IGF_GR_RFMS_DISB_ALL does not reference any database object
IGF.IGF_GR_RFMS_DISB_ALL is referenced by following:
|
|
|