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 |