XCC_BC_REPROCESS_DATASETS_GT
The table contains a record for each budgetary control validation request to reprocess transactions that failed budgetary control validations previously. Each record includes potentially different parameter values submitted in repeated requests.
Details
-
Schema: FUSION
-
Object owner: XCC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
XCC_BC_REPROCESS_DATASETS_PK |
DATA_SET_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DATA_SET_ID | NUMBER | 18 | Yes | Unique identifier for smaller group of budgetary control transaction to be processed by a particular budgetary control request. | |
| TRANSACTION_TYPE_CODE | VARCHAR2 | 30 | Yes | Unique identifier for transaction type. | |
| SOURCE_ACTION_CODE | VARCHAR2 | 30 | Yes | Action performed on transaction. | |
| LEDGER_ID | NUMBER | 18 | Yes | Unique identifier for ledger associated with transaction. | |
| REPROCESS_DATA_SET | VARCHAR2 | 500 | Yes | Budgetary control transaction or group of transactions processed in each ESS request. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| XCC_BC_REPROCESS_DATASETS_U1 | Unique | DATA_SET_ID |
| XCC_BC_REPROCESS_DATASETS_U2 | Unique | TRANSACTION_TYPE_CODE, SOURCE_ACTION_CODE, LEDGER_ID, REPROCESS_DATA_SET |