[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_SL_CL_BATCH_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGF |
| FND Design Data: |  IGF.IGF_SL_CL_BATCH_ALL
|
| Subobject Name: | |
| Status: | VALID |
IGF_SL_CL_BATCH_ALL maintains the CommonLine batch file information for send files, which were created by module or response files. These files were received and loaded into the module.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGF_SL_CL_BATCH_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 CBTH_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CBTH_ID | NUMBER | (15) | Yes | Identifier for batch |
| BATCH_ID | VARCHAR2 | (40) | Indicates batch identifier for file created or loaded | |
| FILE_CREATION_DATE | DATE | Indicates date on which file was created | ||
| FILE_TRANS_DATE | DATE | Indicates date on which file is transmitted | ||
| FILE_IDENT_CODE | VARCHAR2 | (30) | Indicates type of data in file, production or test, and file version | |
| RECIPIENT_ID | VARCHAR2 | (30) | Indicates lender identifier or service provider, who receives file, in case of send file and school identifer for response files | |
| RECIP_NON_ED_BRC_ID | VARCHAR2 | (30) | Indicates non-ED branch of recipient as in header | |
| SOURCE_ID | VARCHAR2 | (30) | Indicates school identifier, who receives file in case of send file and lender identifier, or service provider's identifier in header in case of response files | |
| SOURCE_NON_ED_BRC_ID | VARCHAR2 | (30) | Indicates non ed branch of source as in header | |
| SEND_RESP | VARCHAR2 | (30) | Indicates if file is application send file, application response file, application change send file, application change response file, or disbursement roster | |
| 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 | |
| REQUEST_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
| 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 | ||
| ORG_ID | NUMBER | (15) | Operating unit identifier | |
| RECORD_COUNT_NUM | NUMBER | Total Number of @1 Disbursement Records | ||
| TOTAL_NET_DISB_AMT | NUMBER | Total Net Disbursement Amount | ||
| TOTAL_NET_EFT_AMT | NUMBER | Total Net EFT Amount | ||
| TOTAL_NET_NON_EFT_AMT | NUMBER | Total Net Non EFT Amount | ||
| TOTAL_REISSUE_AMT | NUMBER | Total Reissue Amount | ||
| TOTAL_CANCEL_AMT | NUMBER | Total Cancellation Amount | ||
| TOTAL_DEFICIT_AMT | NUMBER | Total Deficit Amount | ||
| TOTAL_NET_CANCEL_AMT | NUMBER | Total Netted Cancellation Amount | ||
| TOTAL_NET_OUT_CANCEL_AMT | NUMBER | Total Netted Outstanding Cancellation Amount |
Cut, paste (and edit) the following text to query this object:
SELECT CBTH_ID
, BATCH_ID
, FILE_CREATION_DATE
, FILE_TRANS_DATE
, FILE_IDENT_CODE
, RECIPIENT_ID
, RECIP_NON_ED_BRC_ID
, SOURCE_ID
, SOURCE_NON_ED_BRC_ID
, SEND_RESP
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
, RECORD_COUNT_NUM
, TOTAL_NET_DISB_AMT
, TOTAL_NET_EFT_AMT
, TOTAL_NET_NON_EFT_AMT
, TOTAL_REISSUE_AMT
, TOTAL_CANCEL_AMT
, TOTAL_DEFICIT_AMT
, TOTAL_NET_CANCEL_AMT
, TOTAL_NET_OUT_CANCEL_AMT
FROM IGF.IGF_SL_CL_BATCH_ALL;
IGF.IGF_SL_CL_BATCH_ALL does not reference any database object
IGF.IGF_SL_CL_BATCH_ALL is referenced by following:
APPS
IGF_SL_CL_BATCH_ALL
|
|
|
|