| 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) | |