Table: dbo.Work_Location
Columns
NameTypeConstraintsDescription
work_location_KEYint (4)NOT NULLwork_location_KEY
ste_location_codenvarchar (70)NOT NULLSTE location code of work location
location_KEYint (4)NOT NULLKey to a Location record
contact_address_type_KEYint (4)NOT NULLKey to a Location record Contact_Address_Type key (this is the address line used to generate the STE code)
work_location_guiduniqueidentifier (16)NOT NULLA unique GUID key for this row
reporting_unitnvarchar (20)NOT NULLA string used in tax processing for the state to identify a particular work location
Primary key
NameColumnsDescription
PK_Work_Locationwork_location_KEY
Unique constraints
NameColumnsDescription
UK_Work_Location$location_KEYlocation_KEY
UK_Work_Location$work_location_guidwork_location_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Work_Location__Contact_Address_Type__contact_address_type_KEYcontact_address_type_KEYContact_Address_Type (contact_address_type_KEY)
FK_Work_Location__Location__location_KEYlocation_KEYLocation (location_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Work_Location_Tax_Jurisdiction__Work_Location__work_location_KEYwork_location_KEYWork_Location_Tax_Jurisdiction
FK_Employee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override__Work_Location__work_location_KEYwork_location_KEYEmployee_Reconciliation_Tax_Form_Tax_Jurisdiction_Override
FK_Employee_Work_Location_Payroll_Department__Work_Location__work_location_KEYwork_location_KEYEmployee_Work_Location_Payroll_Department
FK_Payroll_Check_Sales_Amount_Distribution__Work_Location__work_location_KEYwork_location_KEYPayroll_Check_Sales_Amount_Distribution
FK_Direct_Deposit_Bank_Transaction_Allocation_Distribution__Work_Location__work_location_KEYwork_location_KEYDirect_Deposit_Bank_Transaction_Allocation_Distribution
FK_Payroll_Check_Payroll_Item_Distribution__Work_Location__work_location_KEYwork_location_KEYPayroll_Check_Payroll_Item_Distribution
FK_Payroll_Check_Tax_Item_Distribution__Work_Location__work_location_KEYwork_location_KEYPayroll_Check_Tax_Item_Distribution
FK_Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution__Work_Location__work_location_KEYwork_location_KEYPayroll_Bank_Transaction_Worker_Compensation_Item_Distribution

Schema diagram