Table: dbo.Work_Location
Columns
Name | Type | Constraints | Description
work_location_KEY | int (4) | NOT NULL | work_location_KEY
ste_location_code | nvarchar (70) | NOT NULL | STE location code of work location
location_KEY | int (4) | NOT NULL | Key to a Location record
contact_address_type_KEY | int (4) | NOT NULL | Key to a Location record Contact_Address_Type key (this is the address line used to generate the STE code)
work_location_guid | uniqueidentifier (16) | NOT NULL | A unique GUID key for this row
reporting_unit | nvarchar (20) | NOT NULL | A string used in tax processing for the state to identify a particular work location

Primary key
Name | Columns | Description
PK_Work_Location | work_location_KEY |
Unique constraints
Name | Columns | Description
UK_Work_Location$location_KEY | location_KEY |
UK_Work_Location$work_location_guid | work_location_guid |

Foreign keys
Name | Columns | Referenced table | Description
FK_Work_Location__Contact_Address_Type__contact_address_type_KEY | contact_address_type_KEY | Contact_Address_Type (contact_address_type_KEY) |
FK_Work_Location__Location__location_KEY | location_KEY | Location (location_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Work_Location_Tax_Jurisdiction__Work_Location__work_location_KEY | work_location_KEY | Work_Location_Tax_Jurisdiction |
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Work_Location__work_location_KEY | work_location_KEY | Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override |
FK_Employee_Work_Location_Payroll_Department__Work_Location__work_location_KEY | work_location_KEY | Employee_Work_Location_Payroll_Department |
FK_Payroll_Check_Sales_Amount_Distribution__Work_Location__work_location_KEY | work_location_KEY | Payroll_Check_Sales_Amount_Distribution |
FK_Direct_Deposit_Bank_Transaction_Allocation_Distribution__Work_Location__work_location_KEY | work_location_KEY | Direct_Deposit_Bank_Transaction_Allocation_Distribution |
FK_Payroll_Check_Payroll_Item_Distribution__Work_Location__work_location_KEY | work_location_KEY | Payroll_Check_Payroll_Item_Distribution |
FK_Payroll_Check_Tax_Item_Distribution__Work_Location__work_location_KEY | work_location_KEY | Payroll_Check_Tax_Item_Distribution |
FK_Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution__Work_Location__work_location_KEY | work_location_KEY | Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution |