Table: dbo.Creditor_Garnishment_Order
Contains creditor garnishment orders for employee payroll items.
Columns
NameTypeConstraintsDescription
creditor_garnishment_order_KEYint (4)NOT NULLPrimary key.
employee_payroll_item_KEYint (4)NOT NULLEach creditor garnishment is linked to an employee payroll item. More than one creditor garnishment can be associated with an employee payroll item.
case_identifiernvarchar (40)NOT NULLCase identifier - determined by the creditor that issued the garnishment order.
order_datesmalldatetime (4)NOT NULLOrder date.
ste_state_code_KEYnvarchar (4)NOT NULLSymmetry code for the state from which the order originated.
ste_county_KEYint (4)The county in which the order originated. Not required for most states.
vendor_KEYint (4)The agent (vendor) to whom payment is due.
amountdecimal (9, 2)NOT NULLGarnishment amount.
total_order_amountdecimal (9, 2)NOT NULLTotal amount limit of this order.
payroll_item_special_timing_KEYint (4)NOT NULLForeign key into the Payroll Item Special timing table.
inactive_datesmalldatetime (4)Optional date when to stop calculating the garnishment. Date checking will be skipped when the date is null.
Primary key
NameColumnsDescription
PK_Creditor_Garnishment_Ordercreditor_garnishment_order_KEY
Unique constraints
NameColumnsDescription
UK_Creditor_Garnishment_Order$payroll_item_special_timing_KEYpayroll_item_special_timing_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Creditor_Garnishment_Order__Employee_Payroll_Item__employee_payroll_item_KEYemployee_payroll_item_KEYEmployee_Payroll_Item (employee_payroll_item_KEY)
FK_Creditor_Garnishment_Order__Payroll_Item_Special_Timing__payroll_item_special_timing_KEYpayroll_item_special_timing_KEYPayroll_Item_Special_Timing (payroll_item_special_timing_KEY)
FK_Creditor_Garnishment_Order__Ste_County__ste_county_KEYste_county_KEYSte_County (ste_county_KEY)
FK_Creditor_Garnishment_Order__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_State_Code (ste_state_code_KEY)
FK_Creditor_Garnishment_Order__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail__Creditor_Garnishment_Order__creditor_garnishment_order_Kcreditor_garnishment_order_KEYPayroll_Check_Payroll_Item_Distribution_Creditor_Garnishment_Detail

Schema diagram