Table: dbo.Garnishment_Order
Contains the garnishment information order(s) for each valid garnishment type employee payroll item.
Columns
Name | Type | Constraints | Description
garnishment_order_KEY | int (4) | NOT NULL | Primary key for this table.
garnishment_type_KEY | int (4) | NOT NULL | The type of garnishment for the order.
employee_KEY | int (4) | NOT NULL | The employee that this order belongs to.
case_identifier | nvarchar (60) | NOT NULL | Optional court case identifier that is determined by the jurisidiction that issued the garnishment order.
order_date | smalldatetime (4) |  | Optional date when this order should start being deducted from pay.
ste_state_code_KEY | nvarchar (4) |  | Optional Symmetry code for the state from which the garnishment order originated.
vendor_KEY | int (4) |  | Optional tax agent (vendor) to whom payment is due.
amount | decimal (9, 2) | NOT NULL | The garnishment amount or percentage amount for this order to be deducted each paycheck.
total_order_amount | decimal (9, 2) | NOT NULL | Optional total amount of this order to be paid.
inactive_date | smalldatetime (4) |  | Optional date when to stop calculating the garnishment.
payroll_item_special_timing_KEY | int (4) | NOT NULL | The special timing that this garnishment is associated with.

Primary key
Name | Columns | Description
PK_Garnishment_Order | garnishment_order_KEY |
Unique constraints
Name | Columns | Description
UK_Garnishment_Order$payroll_item_special_timing_KEY | payroll_item_special_timing_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Garnishment_Order__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |
FK_Garnishment_Order__Garnishment_Type__garnishment_type_KEY | garnishment_type_KEY | Garnishment_Type (garnishment_type_KEY) |
FK_Garnishment_Order__Payroll_Item_Special_Timing__payroll_item_special_timing_KEY | payroll_item_special_timing_KEY | Payroll_Item_Special_Timing (payroll_item_special_timing_KEY) |
FK_Garnishment_Order__Ste_State_Code__ste_state_code_KEY | ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) |
FK_Garnishment_Order__Vendor__vendor_KEY | vendor_KEY | Vendor (vendor_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Employee_Payroll_Item_Garnishment_Order__Garnishment_Order__garnishment_order_KEY | garnishment_order_KEY | Employee_Payroll_Item_Garnishment_Order |
FK_Payroll_Check_Payroll_Item_Distribution_Garnishment_Detail__Garnishment_Order__garnishment_order_KEY | garnishment_order_KEY | Payroll_Check_Payroll_Item_Distribution_Garnishment_Detail |