Version 2023.10
These staging tables are modified. The new columns are highlighted.
| CREATE TABLE alex_user ( | ||
|---|---|---|
| external_key | nvarchar(255) | NOT NULL |
| employee_number | nvarchar(255) | |
| cost_center_ekey | nvarchar(255) | NOT NULL |
| user_first_name | nvarchar(255) | NOT NULL |
| user_middle_initial | nvarchar(1) | |
| user_last_name | nvarchar(255) | NOT NULL |
| user_password | nvarchar(255) | NOT NULL |
| user_title | nvarchar(255) | |
| user_location_name | nvarchar(255) | |
| user_telephone | nvarchar(255) | |
| user_mailstop | nvarchar(255) | |
| user_email_address | nvarchar(255) | |
| user_email_product | nvarchar(255) | |
| user_login_name | nvarchar(255) | NOT NULL |
| fax_number | nvarchar(255) | |
| payroll_system_code | nvarchar(255) | |
| active_status | smallint | NOT NULL |
| user_ssn | nvarchar(40) | |
| currency_ekey | nvarchar(255) | NOT NULL |
| country_ekey | nvarchar(255) | |
| default_approver_user_ekey | nvarchar(255) | |
| creation_date | datetime | NOT NULL |
| credit_card_ekey | nvarchar(255) | |
| credit_card_number | nvarchar(40) | |
| cc_processor_ekey | nvarchar(255) | |
| cc_payment_type_ekey | nvarchar(255) | |
| set_of_books_ekey | nvarchar(255) | |
| auth_amount | numeric(28,10) | |
| auth_amount_currency_ekey | nvarchar(255) | |
| pr_auth_amount | numeric(28,10) | |
| pr_auth_amount_currency_ekey | nvarchar(255) | |
| system_code_1 | nvarchar(255) | |
| system_code_2 | nvarchar(255) | |
| system_code_3 | nvarchar(255) | |
| system_code_4 | nvarchar(255) | |
| system_code_5 | nvarchar(255) | |
| system_code_6 | nvarchar(255) | |
| system_code_7 | nvarchar(255) | |
| system_code_8 | nvarchar(255) | |
| start_date | datetime | |
| end_date | datetime | |
| system_date_1 | datetime | |
| system_date_2 | datetime | |
| out_of_office | smallint | NOT NULL |
| proxy_can_submit | smallint | |
| audit_group_ekey | nvarchar(255) | |
| is_html_client_user | smallint | NOT NULL |
| second_currency_ekey | nvarchar(255) | |
| proxy_reviewer_can_submit | smallint | |
| commute_miles | numeric(26,16) | |
| identity2 | nvarchar(36) | |
| preferred_timezone | nvarchar(255) | |
| user_email_address_2 | nvarchar(255) | |
| user_email_address_3 | nvarchar(255) | |
| preferred_locale | nvarchar(255) | |
| fx_source_ekey | nvarchar(255) | |
| long_user_id | nvarchar(128) | |
| security_bod_control | nvarchar(16) | |
| default_mileage_rate_id_ekey | nvarchar(255) | |
| CONSTRAINT pk__al1367e606 PRIMARY KEY CLUSTERED ( external_key ) | ||
| ) | ||
| go |