| Table: dbo.Employee_Work_Location_Payroll_Department | |||
| Columns | |||
| Name | Type | Constraints | Description |
| employee_work_location_payroll_department_KEY | int (4) | NOT NULL | Primary key for he record. |
| work_location_KEY | int (4) | NOT NULL | Parent work location record |
| payroll_department_KEY | int (4) | Optional payroll department key. | |
| employee_KEY | int (4) | NOT NULL | Parent employee record |
| is_primary | bit (1) | NOT NULL | Indicates if this is the primary work location for the employee |
| pay_distribution_percent | decimal (5, 2) | NOT NULL | Percentage of pay distributed to this work location/payroll department |
| employee_work_location_payroll_department_guid | uniqueidentifier (16) | NOT NULL | A unique GUID key for this row |
| Primary key | |||
| Name | Columns | Description | |
| PK_Employee_Work_Location_Payroll_Department | employee_work_location_payroll_department_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Employee_Work_Location_Payroll_Department$employee_KEY$work_location_KEY$payroll_department_KEY | employee_KEY, work_location_KEY, payroll_department_KEY | ||
| UK_Employee_Work_Location_Payroll_Department$employee_work_location_payroll_department_guid | employee_work_location_payroll_department_guid | ||