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