ATC_PUBLISH_DEST
This stores the details of the jobs published to specific spoke system
Details
-
Schema: FUSION
-
Object owner: ATC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
ATC_PUBLISH_DEST_PK |
PUB_DEST_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
PUB_DEST_ID | NUMBER | 18 | Yes | Indicates the unique identifier for Publish destination record | |
ERROR_REASON | VARCHAR2 | 4000 | This is to store the reason for failure for a publish task | ||
PUBLISH_JOB_UUID | VARCHAR2 | 50 | Yes | Indicates the publish task identifier | |
SPOKE_SYSTEM_PUBLISH_TASKID | VARCHAR2 | 50 | Yes | Indicates the the publishing task id for a specific spoke system | |
PUBLISH_OBJECT_TYPE | VARCHAR2 | 1000 | Yes | Indicates the object type that needs to be updated in the spoke system | |
SPOKE_SYS_NAME | VARCHAR2 | 200 | Yes | Indicates the name of the spoke system | |
SPOKE_SYS_URL | VARCHAR2 | 400 | Yes | Indicates the URL for a specific spoke system | |
PUBLISH_START_TIME | DATE | Indicates the start time during the initiation of the publishing tasks for a specific spoke system | |||
PUBLISH_COMPLN_TIME | DATE | Indicates the completion time during the initiation of the publishing tasks for a specific spoke system | |||
PUBLISH_STATUS | VARCHAR2 | 200 | Indicates the individual spoke system publishing status | ||
RETRY_COUNT | NUMBER | Indicates the number of retrials for task publish transaction | |||
PUBLISH_ORDER | NUMBER | Indicates the order of publish to a destination | |||
ATTMPTD_DUR_OUTAGE | VARCHAR2 | 1 | Indicates if the publish task was submitted during spoke system outage or downtime | ||
IS_BATCH_RETRY | VARCHAR2 | 1 | Indicates if there was a batch retry for a failed published jobY/N as values | ||
PUBLISH_PROGRESS_CODE | NUMBER | Indicates the progress code of the transaction | |||
PUBLISH_OBJ_VERSION | VARCHAR2 | 10 | Yes | Indicates the version of the object being published | |
PUBLISH_OBJ_LIFECYCLE_STATUS | VARCHAR2 | 20 | Indicates the life cycle status of the object | ||
PUBLISH_OBJ_KEY | VARCHAR2 | 100 | Indicates the id of the object that is being published | ||
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. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
ATC_PUBLISH_DEST_U1 | Unique | Default | PUB_DEST_ID |
ATC_PUBLISH_DEST_U2 | Unique | Default | PUBLISH_JOB_UUID, SPOKE_SYSTEM_PUBLISH_TASKID |