RCS_EXTRACT_DEFS
This table holds general information about the user defined extracts such as name and descriptions. This serves as the data model for the data to be presented in the Extract Definition UI.
Details
-
Schema: FUSION
-
Object owner: RCS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
rcs_extract_defs_PK |
EXTRACT_DEFINITION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| EXTRACT_DEFINITION_ID | NUMBER | 18 | Yes | The identifier for each new extract registered through Create and manage extracts UI. | |
| EXTRACT_DEFINITION_NAME | VARCHAR2 | 100 | Yes | Name for the user defined extract definition. | |
| EXTRACT_DEFINITION_DESC | VARCHAR2 | 1000 | Description for the user defined extract definition. | ||
| SDTE_EXTRACT_ID | NUMBER | 18 | The foreign key to the sdte_extract_detail table. Populated once the given extract definition row has been registered with TEMS. | ||
| OUTPUT_FORMAT | VARCHAR2 | 100 | Yes | User configured data format for extracted data. | |
| CSV_DELIMITER | VARCHAR2 | 2 | For output format set to CSV, the delimiter to be used in the extracted data. | ||
| INCREMENTAL_FLAG | VARCHAR2 | 1 | Flag to indicate whether extraction mode of the extract definition is incremental. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| IS_REGISTERED | VARCHAR2 | 20 | Yes | Indicates the state of the user defined extract definition based on TEMS registration. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| rcs_extract_defs_U1 | Unique | Default | EXTRACT_DEFINITION_ID |
| rcs_extract_defs_U2 | Unique | Default | EXTRACT_DEFINITION_NAME |