EXTRACTION_TRANS_LOG



Column Section Top of Page


Table-level Detail

Description: Extraction Transaction Log
Definition: This table is used to track processing status for each extraction request.
Table Type: ACTIVITY





Column Detail - EXTRACTION_TRANS_LOG


Column Name Type Null? Definition
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.