These staging tables are modified. The new columns are highlighted.
| CREATE TABLE alex_import_ts_line_item ( |
|
|
| external_key |
nvarchar(255) |
NOT NULL |
| user_ekey |
nvarchar(255) |
NOT NULL |
| import_status |
smallint |
DEFAULT 1 NOT NULL |
| import_error_message |
nvarchar(255) |
|
| import_change_timestamp |
datetime |
|
| parent_type |
smallint |
DEFAULT 0 NOT NULL |
| parent_ekey |
nvarchar(255) |
|
| project_number_id_ekey |
nvarchar(255) |
|
| ts_date |
datetime |
NOT NULL |
| ts_hours |
numeric(14,4) |
|
| hourly_charge_type_id_ekey |
nvarchar(255) |
|
| charge_type_id_ekey |
nvarchar(255) |
|
| ts_start_time |
datetime |
|
| ts_end_time |
datetime |
|
| location_id_ekey |
nvarchar(255) |
|
| charge_role_id_ekey |
nvarchar(255) |
|
| app_ts_hours |
numeric(14,4) |
|
| app_hourly_charge_type_id_ekey |
int |
|
| ts_billable_rate |
numeric(28,10) |
|
| ts_billable_rate_id_ekey |
nvarchar(255) |
|
| currency_fmt_defn_id_ekey |
nvarchar(255) |
|
| cost_center_id_ekey |
nvarchar(255) |
|
| description |
nvarchar(255) |
|
| attd_in1 |
datetime |
|
| attd_out1 |
datetime |
|
| attd_in2 |
datetime |
|
| attd_out2 |
datetime |
|
| attd_in3 |
datetime |
|
| attd_out3 |
datetime |
|
| attd_in4 |
datetime |
|
| attd_out4 |
datetime |
|
| attd_in5 |
datetime |
|
| attd_out5 |
datetime |
|
| attd_in6 |
datetime |
|
| attd_out6 |
datetime |
|
| attd_absence_hours |
numeric(14,4) |
|
| keyword_note |
nvarchar(max) |
|
| imported_read_only |
smallint |
|
|
ref_doc_id
|
nvarchar(255)
|
|
| CONSTRAINT PK135 PRIMARY KEY CLUSTERED ( external_key ) |
|
|
| ) |
|
|
| go |
|
|
| CREATE TABLE alex_project_code ( |
|
|
| external_key |
nvarchar(255) |
NOT NULL |
| project_charge_code |
nvarchar(255) |
NOT NULL |
| project_code |
nvarchar(255) |
|
| project_name |
nvarchar(255) |
NOT NULL |
| active_status |
smallint |
NOT NULL |
| project_desc |
nvarchar(255) |
|
| level_1_leader_user_ekey |
nvarchar(255) |
|
| level_2_leader_user_ekey |
nvarchar(255) |
|
| level_3_leader_user_ekey |
nvarchar(255) |
|
| level_4_leader_user_ekey |
nvarchar(255) |
|
| default_reviewer_user_ekey |
nvarchar(255) |
|
| alt_default_reviewer_user_ekey |
nvarchar(255) |
|
| is_required |
smallint |
|
| client_ekey |
nvarchar(255) |
|
| parent_project_ekey |
nvarchar(255) |
|
| code_level |
smallint |
NOT NULL |
| is_chargeable |
smallint |
|
| top_project_ekey |
nvarchar(255) |
|
| office_ekey |
nvarchar(255) |
|
| charge_type_ekey |
nvarchar(255) |
|
| start_date |
datetime |
|
| end_date |
datetime |
|
| project_activity_type_ekey |
nvarchar(255) |
|
| hier_project_name |
nvarchar(255) |
|
|
project_accounting_entity_code
|
nvarchar(255)
|
|
| CONSTRAINT pk__al1b0907ce PRIMARY KEY CLUSTERED ( external_key ) |
|
|
| ) |
|
|
| go |
|
|