Table: dbo.Payroll_Department
Columns
NameTypeConstraintsDescription
payroll_department_KEYint (4)NOT NULLKey of payroll department record
client_KEYint (4)NOT NULLKey of associated client.
descriptionnvarchar (60)NOT NULLDescription of Payroll_Department record.
payroll_department_guiduniqueidentifier (16)NOT NULLA unique GUID key for this row
is_activebit (1)NOT NULLIf the is active set to true, then the payroll department description is active; if false, then the department description is inactive.
Primary key
NameColumnsDescription
PK_Payroll_Departmentpayroll_department_KEY
Unique constraints
NameColumnsDescription
UK_Payroll_Department$client_KEY$descriptionclient_KEY, description
UK_Payroll_Department$payroll_department_guidpayroll_department_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Department__Client__client_KEYclient_KEYClient (client_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Recorded_Event_Object_N_Payroll_Department__Payroll_Department__payroll_department_KEYpayroll_department_KEYRecorded_Event_Object_N_Payroll_Department
FK_Ascii_Time_Clock_Payroll_Department_Id_Map__Payroll_Department__payroll_department_KEYpayroll_department_KEYAscii_Time_Clock_Payroll_Department_Id_Map
FK_Employee_Work_Location_Payroll_Department__Payroll_Department__payroll_department_KEYpayroll_department_KEYEmployee_Work_Location_Payroll_Department
FK_Payroll_Check_Sales_Amount_Distribution__Payroll_Department__payroll_department_KEYpayroll_department_KEYPayroll_Check_Sales_Amount_Distribution
FK_Direct_Deposit_Bank_Transaction_Allocation_Distribution__Payroll_Department__payroll_department_KEYpayroll_department_KEYDirect_Deposit_Bank_Transaction_Allocation_Distribution
FK_Payroll_Check_Payroll_Item_Distribution__Payroll_Department__payroll_department_KEYpayroll_department_KEYPayroll_Check_Payroll_Item_Distribution
FK_Payroll_Check_Tax_Item_Distribution__Payroll_Department__payroll_department_KEYpayroll_department_KEYPayroll_Check_Tax_Item_Distribution
FK_Payroll_Bank_Transaction_Worker_Compensation_Item_Distribution__Payroll_Department__payroll_department_KEYpayroll_department_KEYPayroll_Bank_Transaction_Worker_Compensation_Item_Distribution

Schema diagram