[Home] [Help] [Dependency Information]
Object Name: | IGF_GR_RFMS_DISB_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGF_GR_RFMS_DISB_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Database rowid for igf_gr_rfms_disb table | |
RFMD_ID | NUMBER | (15) | Yes | Identifier for each recipient financial management system disbursement |
ORIGINATION_ID | VARCHAR2 | (30) | Yes | Unique code for each origination |
DISB_REF_NUM | VARCHAR2 | (30) | Yes | Number of this disbursement |
DISB_DT | DATE | Date this disbursement was or will be made to the student | ||
DISB_AMT | NUMBER | (12) | Yes | Amount of disbursement for student |
DB_CR_FLAG | VARCHAR2 | (1) | Yes | Indicates if the disbursement amount is positive or negative |
DISB_ACK_ACT_STATUS | VARCHAR2 | (1) | Code to indicate processing status of disbursement | |
DISB_STATUS_DT | DATE | Reflects the date on which the status of this disbursement has been changed | ||
ACCPT_DISB_DT | DATE | Date on which the disbursement was accepted | ||
DISB_ACCPT_AMT | NUMBER | (12) | Amount of disbursement for student | |
ACCPT_DB_CR_FLAG | VARCHAR2 | (1) | Indicates if the Disbursement Amount is positive or negative | |
PYMT_PRD_START_DT | DATE | Beginning date of the payment period | ||
ACCPT_PYMT_PRD_START_DT | DATE | Accepted beginning date of the payment period | ||
DISB_YTD_AMT | NUMBER | (12) | Total amount that has been disbursed to the student for the award year | |
EDIT_CODE | VARCHAR2 | (75) | Error code that gets sent from the government | |
RFMB_ID | NUMBER | (15) | Stores the batch id which will be sent to the external recipient financial management system | |
BATCH_ID | VARCHAR2 | (30) | Unique batch identifier that gets generated everytime the process is run | |
RFMS_PROCESS_DT | DATE | Date on which the process is run | ||
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 | |
ED_USE_FLAGS | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, 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
, PYMT_PRD_START_DT
, ACCPT_PYMT_PRD_START_DT
, DISB_YTD_AMT
, EDIT_CODE
, RFMB_ID
, BATCH_ID
, RFMS_PROCESS_DT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ED_USE_FLAGS
FROM APPS.IGF_GR_RFMS_DISB_V;
|
|
|