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