ASYNC_PUSH_STATUS |
DOUBLE |
Y |
This flag indicates if the Async response is submitted to the client successfully or not. |
DEFAULT_CONSUMER_ROUTE |
VARCHAR(10) |
Y |
Dex Async request requires consumer routing information to be passed by the client. The first route id is considered as a default consumer route. In case of Async server crash, This route information will be used to post the failure response to the client. |
DEX_EXTERNAL_REF |
VARCHAR(128) |
Y |
DEX can not return any ID when the request is submitted to Async API, so it expects the client to provide a unique ID for every request. The ID will be used by the client to Map the response with the request. |
END_DT_TM |
DATETIME |
Y |
The date/time of when the extraction process was completed. |
ERROR_MESSAGE |
LONGTEXT |
Y |
The detailed stack trace if there is an error during the extraction. |
EXTRACTION_TRANS_LOG_ID |
DOUBLE |
N |
The unique generated number that identifies a single row on the EXTRACTION_TRANS_LOG table. |
START_DT_TM |
DATETIME |
N |
The date/time of when the extraction process was initiated. |
STATUS_FLAG |
DOUBLE |
N |
The status of this extraction. 0 = In Progress; 1 = Complete; 2 = Failed |
UPDT_APPLCTX |
DOUBLE |
N |
The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT |
DOUBLE |
N |
Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM |
DATETIME |
N |
The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID |
DOUBLE |
N |
The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK |
DOUBLE |
N |
The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |