Table: dbo.Employee_Payroll_Item_Garnishment_Order
Contains each garnishment order amount per employee payroll item.
Columns
NameTypeConstraintsDescription
employee_payroll_item_garnishment_order_KEYint (4)NOT NULLPrimary key for this table.
employee_payroll_item_KEYint (4)NOT NULLEmployee payroll item this garnishment order belongs to.
garnishment_order_KEYint (4)NOT NULLThe garnishment order that belongs to this employee payroll item.
amountdecimal (9, 2)NOT NULLThe required amount or percent of pay this particular garnishment is ordered for.
Primary key
NameColumnsDescription
PK_Employee_Payroll_Item_Garnishment_Orderemployee_payroll_item_garnishment_order_KEY
Unique constraints
NameColumnsDescription
UK_Employee_Payroll_Item_Garnishment_Order$employee_payroll_item_KEY$garnishment_order_KEYemployee_payroll_item_KEY, garnishment_order_KEY
UK_Employee_Payroll_Item_Garnishment_Order$garnishment_order_KEY$employee_payroll_item_KEYgarnishment_order_KEY, employee_payroll_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Employee_Payroll_Item_Garnishment_Order__Employee_Payroll_Item__employee_payroll_item_KEYemployee_payroll_item_KEYEmployee_Payroll_Item (employee_payroll_item_KEY)
FK_Employee_Payroll_Item_Garnishment_Order__Garnishment_Order__garnishment_order_KEYgarnishment_order_KEYGarnishment_Order (garnishment_order_KEY)

Schema diagram