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 |