Table: dbo.Payroll_Department
Columns
Name | Type | Constraints | Description
payroll_department_KEY | int (4) | NOT NULL | Key of payroll department record
client_KEY | int (4) | NOT NULL | Key of associated client.
description | nvarchar (60) | NOT NULL | Description of Payroll_Department record.
payroll_department_guid | uniqueidentifier (16) | NOT NULL | A unique GUID key for this row
is_active | bit (1) | NOT NULL | If the is active set to true, then the payroll department description is active; if false, then the department description is inactive.

Primary key
Name | Columns | Description
PK_Payroll_Department | payroll_department_KEY |
Unique constraints
Name | Columns | Description
UK_Payroll_Department$client_KEY$description | client_KEY, description |
UK_Payroll_Department$payroll_department_guid | payroll_department_guid |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Department__Client__client_KEY | client_KEY | Client (client_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Recorded_Event_Object_N_Payroll_Department__Payroll_Department__payroll_department_KEY | payroll_department_KEY | Recorded_Event_Object_N_Payroll_Department |
FK_Ascii_Time_Clock_Payroll_Department_Id_Map__Payroll_Department__payroll_department_KEY | payroll_department_KEY | Ascii_Time_Clock_Payroll_Department_Id_Map |
FK_Employee_Work_Location_Payroll_Department__Payroll_Department__payroll_department_KEY | payroll_department_KEY | Employee_Work_Location_Payroll_Department |
FK_Payroll_Check_Sales_Amount_Distribution__Payroll_Department__payroll_department_KEY | payroll_department_KEY | Payroll_Check_Sales_Amount_Distribution |
FK_Payroll_Check_One_Big_Beautiful_Bill_Act_Overtime_Amount_Distribution__Payroll_Department__payroll_department_KEY | payroll_department_KEY | Payroll_Check_One_Big_Beautiful_Bill_Act_Overtime_Amount_Distribution | FOREIGN KEY constraint of payroll_department_KEY for the Payroll_Check_One_Big_Beautiful_Bill_Act_Overtime_Amount_Distribution table
FK_Direct_Deposit_Bank_Transaction_Allocation_Distribution__Payroll_Department__payroll_department_KEY | payroll_department_KEY | Direct_Deposit_Bank_Transaction_Allocation_Distribution |
FK_Payroll_Check_Payroll_Item_Distribution__Payroll_Department__payroll_department_KEY | payroll_department_KEY | Payroll_Check_Payroll_Item_Distribution |
FK_Payroll_Check_Tax_Item_Distribution__Payroll_Department__payroll_department_KEY | payroll_department_KEY | Payroll_Check_Tax_Item_Distribution |
FK_Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution__Payroll_Department__payroll_department_KEY | payroll_department_KEY | Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution |