SVC_ARCH_EXPORT_HIST
This table is used to store history of bulk export jobs submitted by archive job.
Details
-
Schema: FUSION
-
Object owner: SVC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
SVC_ARCH_EXPORT_HIST_PK |
ARCH_EXP_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| BULK_EXPORT_JOB_ID | NUMBER | 18 | Yes | Job Id generated from a bulk export Job. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
| ARCH_EXP_ID | NUMBER | 18 | Yes | Primary Key, Auto-generated number. | ||
| OBJECT_TYPE | VARCHAR2 | 30 | Yes | Name of object that is exported, e.g., ServiceRequest, HRHelpDeskRequest, InternalServiceRequest. | ||
| OBJECT_IDS | VARCHAR2 | 4000 | Yes | Comma-separated Object IDs, e.g., SR IDs that are being passed to the export job. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
| ARCH_STATUS | VARCHAR2 | 32 | Yes | Current status of Export Job. Here are the details of possible values: QUEUED - This is the status of the Export Job API. PREPARING_TO_EXPORT - This is the status of the Export Job API. EXPORTING_DATA - This is the status of the Export Job API. COMPLETING_EXPORT_ACTIVITY - This is the status of the Export Job API. COMPLETE - This is the status of the Export Job API. | ||
| DOCUMENT_ID | NUMBER | 18 | Document ID pointing to the file created by Export job. | |||
| DOCUMENT_LINK | VARCHAR2 | 2000 | Link to download the Archived file. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SVC_ARCH_EXPORT_HIST_N1 | Non Unique | Default | ARCH_STATUS |
| SVC_ARCH_EXPORT_HIST_N2 | Non Unique | Default | CREATION_DATE, ARCH_STATUS |
| SVC_ARCH_EXPORT_HIST_N3 | Non Unique | Default | OBJECT_TYPE |
| SVC_ARCH_EXPORT_HIST_PK | Unique | Default | ARCH_EXP_ID |
| SVC_ARCH_EXPORT_HIST_U1 | Unique | Default | BULK_EXPORT_JOB_ID |