Table: dbo.Employee_Payroll_Item_Garnishment_Order | |||
Contains each garnishment order amount per employee payroll item. | |||
Columns | |||
Name | Type | Constraints | Description |
employee_payroll_item_garnishment_order_KEY | int (4) | NOT NULL | Primary key for this table. |
employee_payroll_item_KEY | int (4) | NOT NULL | Employee payroll item this garnishment order belongs to. |
garnishment_order_KEY | int (4) | NOT NULL | The garnishment order that belongs to this employee payroll item. |
amount | decimal (9, 2) | NOT NULL | The required amount or percent of pay this particular garnishment is ordered for. |
Primary key | |||
Name | Columns | Description | |
PK_Employee_Payroll_Item_Garnishment_Order | employee_payroll_item_garnishment_order_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Employee_Payroll_Item_Garnishment_Order$employee_payroll_item_KEY$garnishment_order_KEY | employee_payroll_item_KEY, garnishment_order_KEY | ||
UK_Employee_Payroll_Item_Garnishment_Order$garnishment_order_KEY$employee_payroll_item_KEY | garnishment_order_KEY, employee_payroll_item_KEY |