ALEX_IMPORT_TS_LINE_ITEM (Staging Table)
| Column name | Data type | Required | Default update able | Data target | Comments |
|---|---|---|---|---|---|
| external_key** | VARCHAR (255) | Yes* | No | alts_line_item.ts_line_item_id | The external key -- Primary Key |
| user_ekey | VARCHAR (255) | Yes* | No | 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 | |
| parent_type | SMALLINT | Yes | No | The type of parent to attach the line item to (0=document whose ekey is in parent_ekey, 1=line item whose ekey is in parent_ekey, 2=document whose tracking number is in parent_ekey, 3=unattached... no parent, 4=current active document, 5=current active document and create if necessary) | |
| parent_ekey | VARCHAR (255) | No | No | The parents ekey | |
| project_number_id_ekey | VARCHAR (255) | No | Yes | alts_line_item.project_number_id | Identifies the charge code |
| ts_date | DATETIME | Yes | Yes | alts_line_item.ts_date | Date associated with this charge |
| ts_hours | NUMERIC (14, 4) | No | Yes | alts_line_item.ts_hours | Hours associated with this charge |
| hourly_charge_type_id_ekey | VARCHAR (255) | No | Yes | alts_line_item.hourly_charge_type_id | Hourly charge type, like regular or overtime |
| charge_type_id_ekey | VARCHAR (255) | No | Yes | alts_line_item.charge_type_id | Charge type, like billable, etc |
| ts_start_time | DATETIME | No | Yes | alts_line_item.ts_start_time | Starting time |
| ts_end_time | DATETIME | No | Yes | alts_line_item.ts_end_time | Ending time |
| location_id_ekey | VARCHAR (255) | No | Yes | alts_line_item.location_id | The work location where the worker perfomed the job. FK to alco_location. It may be different from the daily tax location. |
| charge_role_id_ekey | VARCHAR (255) | No | Yes | alts_line_item.charge_role_id | id of charge role, which could be 'project manager' or the like |
| app_ts_hours | NUMERIC (14, 4) | No | Yes | alts_line_item.app_ts_hours | Approved hours for this charge |
| app_hourly_charge_type_id_ekey | INTEGER | No | Yes | alts_line_item.app_hourly_charge_type_id | Approved hourly charge type |
| ts_billable_rate | NUMERIC (20, 10) | No | Yes | alts_line_item.ts_billable_rate | billable rate for this time sheet line item, entered by manager |
| ts_billable_rate_id_ekey | VARCHAR (255) | No | Yes | alts_line_item.ts_billable_rate_id | Currency this line item is billing in |
| currency_fmt_defn_id_ekey | VARCHAR (255) | No | Yes | alts_line_item.currency_fmt_defn_id | Currency associated with billable rate, for display on screen |
| cost_center_id_ekey | VARCHAR (255) | No | Yes | alts_line_item.cost_center_id | The cost center that is charged. Default is creator home cost center. FK into alco_cost_center. |
| description | VARCHAR (255) | No | Yes | alts_line_item.description | A short note for the user to add additional information. |
| attd_in1 | DATETIME | No | Yes | alts_line_item.attd_in1 | Stores attendance in-out time pair 1 (in) |
| attd_out1 | DATETIME | No | Yes | alts_line_item.attd_out1 | Stores attendance in-out time pair 1 (out) |
| attd_in2 | DATETIME | No | Yes | alts_line_item.attd_in1 | Stores attendance in-out time pair 2 (in) |
| attd_out2 | DATETIME | No | Yes | alts_line_item.attd_out1 | Stores attendance in-out time pair 2 (out) |
| attd_in3 | DATETIME | No | Yes | alts_line_item.attd_in1 | Stores attendance in-out time pair 3 (in) |
| attd_out3 | DATETIME | No | Yes | alts_line_item.attd_out1 | Stores attendance in-out time pair 3 (out) |
| attd_in4 | DATETIME | No | Yes | alts_line_item.attd_in1 | Stores attendance in-out time pair 4 (in) |
| attd_out4 | DATETIME | No | Yes | alts_line_item.attd_out1 | Stores attendance in-out time pair 4 (out) |
| attd_in5 | DATETIME | No | Yes | alts_line_item.attd_in1 | Stores attendance in-out time pair 5 (in) |
| attd_out5 | DATETIME | No | Yes | alts_line_item.attd_out1 | Stores attendance in-out time pair 5 (out) |
| attd_in6 | DATETIME | No | Yes | alts_line_item.attd_in1 | Stores attendance in-out time pair 6 (in) |
| attd_out6 | DATETIME | No | Yes | alts_line_item.attd_out1 | Stores attendance in-out time pair 6 (out) |
| attd_absence_hours | NUMERIC (14, 4) | No | Yes | alts_line_item.attd_absence_hours | Stores attendance absence hours (when used, all in-out pairs should be null) |
| keyword_note | TEXT | No | Yes | ||
| imported_read_only | NUMERIC(5) | No | Yes | alts_line_item.imported_read_only | Holds the read only status of imported line items. |
| ref_doc_id | VARCHAR(255) | No | Yes | alts_line_item.ref_doc_id | Stores the Reference Document ID |
* System required field
** Value must be unique