ALEX_IMPORT_TS_DOCUMENT (Staging Table)
| Column name | Data type | Required | Default update able | Data target | Comments |
|---|---|---|---|---|---|
| external_key** | VARCHAR (255) | Yes* | No | alts_timesheet.ts_document_id | The external key - Primary Key |
| user_ekey | VARCHAR (255) | Yes* | No | alts_timesheet.user_id | The user the entry belongs to |
| import_status | SMALLINT | Yes | Yes | The import command/status (0=dont import, 1=do import, 2=success, 100+=re-process, -1=failed) | |
| import_error_message | VARCHAR (255) | No | No | The import error message | |
| import_change_timestamp | DATETIME | No | No | The import timestamp | |
| submit_status | SMALLINT | Yes | Yes | The auto-submit command/status (0=dont submit, 1=do submit, 2=success, -1=failed) | |
| submit_error_message | VARCHAR (255) | No | No | The submit error message | |
| submit_change_timestamp | DATETIME | No | No | The submit timestamp | |
| create_location_id_ekey | VARCHAR (255) | No | Yes | alts_timesheet.create_location_id | Document element |
| keyword_date_in_period | DATETIME | Yes | Yes | The documents date-in-period | |
| keyword_note | TEXT | No | Yes | The documents note |
* System required field
** Value must be unique