Table: dbo.Garnishment_Order
Contains the garnishment information order(s) for each valid garnishment type employee payroll item.
Columns
NameTypeConstraintsDescription
garnishment_order_KEYint (4)NOT NULLPrimary key for this table.
garnishment_type_KEYint (4)NOT NULLThe type of garnishment for the order.
employee_KEYint (4)NOT NULLThe employee that this order belongs to.
case_identifiernvarchar (60)NOT NULLOptional court case identifier that is determined by the jurisidiction that issued the garnishment order.
order_datesmalldatetime (4)Optional date when this order should start being deducted from pay.
ste_state_code_KEYnvarchar (4)Optional Symmetry code for the state from which the garnishment order originated.
vendor_KEYint (4)Optional tax agent (vendor) to whom payment is due.
amountdecimal (9, 2)NOT NULLThe garnishment amount or percentage amount for this order to be deducted each paycheck.
total_order_amountdecimal (9, 2)NOT NULLOptional total amount of this order to be paid.
inactive_datesmalldatetime (4)Optional date when to stop calculating the garnishment.
payroll_item_special_timing_KEYint (4)NOT NULLThe special timing that this garnishment is associated with.
Primary key
NameColumnsDescription
PK_Garnishment_Ordergarnishment_order_KEY
Unique constraints
NameColumnsDescription
UK_Garnishment_Order$payroll_item_special_timing_KEYpayroll_item_special_timing_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Garnishment_Order__Employee__employee_KEYemployee_KEYEmployee (employee_KEY)
FK_Garnishment_Order__Garnishment_Type__garnishment_type_KEYgarnishment_type_KEYGarnishment_Type (garnishment_type_KEY)
FK_Garnishment_Order__Payroll_Item_Special_Timing__payroll_item_special_timing_KEYpayroll_item_special_timing_KEYPayroll_Item_Special_Timing (payroll_item_special_timing_KEY)
FK_Garnishment_Order__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_State_Code (ste_state_code_KEY)
FK_Garnishment_Order__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Employee_Payroll_Item_Garnishment_Order__Garnishment_Order__garnishment_order_KEYgarnishment_order_KEYEmployee_Payroll_Item_Garnishment_Order
FK_Payroll_Check_Payroll_Item_Distribution_Garnishment_Detail__Garnishment_Order__garnishment_order_KEYgarnishment_order_KEYPayroll_Check_Payroll_Item_Distribution_Garnishment_Detail

Schema diagram