Table: dbo.Child_Support_Order
Columns
NameTypeConstraintsDescription
child_support_order_KEYint (4)NOT NULLPrimary key.
employee_payroll_item_KEYint (4)NOT NULLEach child support order is linked to an employee payroll item. More than one child support order can be associated with an employee payroll item.
case_identifiernvarchar (40)NOT NULLCourt case identifier - determined by the jurisidiction that issued the support order.
ste_state_code_KEYnvarchar (4)NOT NULLSymmetry code for the state from which the support order originated.
ste_county_KEYint (4)The county in which the support order originated. Not required for most states.
vendor_KEYint (4)The tax agent (vendor) to whom payment is due.
amountdecimal (9, 2)NOT NULLGarnishment amount.
direct_deposit_status_KEYnvarchar (40)Status of the direct deposit transaction associated with the garnishment. Most, but not all, states support garnishment via direct deposit.
in_arrearsbit (1)NOT NULLWhen this flag is true, it indicates that at least one payment is overdue.
prenote_datesmalldatetime (4)Date prenote request was processed for this order.
prenote_createdbit (1)NOT NULLFlag indicating that a prenote was created for this order.
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.
order_datesmalldatetime (4)Optional date when this order should start being deducted from pay. If null deduct from pay.
prenote_effective_datesmalldatetime (4)The effective date used when prenoting this allocation.
notesnvarchar (480)NOT NULLDirect deposit processing notes when this allocation is prenoted.
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_Child_Support_Orderchild_support_order_KEY
Unique constraints
NameColumnsDescription
UK_Child_Support_Order$payroll_item_special_timing_KEYpayroll_item_special_timing_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Child_Support_Order__Direct_Deposit_Status__direct_deposit_status_KEYdirect_deposit_status_KEYDirect_Deposit_Status (direct_deposit_status_KEY)
FK_Child_Support_Order__Employee_Payroll_Item__employee_payroll_item_KEYemployee_payroll_item_KEYEmployee_Payroll_Item (employee_payroll_item_KEY)
FK_Child_Support_Order__Payroll_Item_Special_Timing__payroll_item_special_timing_KEYpayroll_item_special_timing_KEYPayroll_Item_Special_Timing (payroll_item_special_timing_KEY)
FK_Child_Support_Order__Ste_County__ste_county_KEYste_county_KEYSte_County (ste_county_KEY)
FK_Child_Support_Order__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_State_Code (ste_state_code_KEY)
FK_Child_Support_Order__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payroll_Check_Payroll_Item_Distribution_Child_Support_Detail__Child_Support_Order__child_support_order_KEYchild_support_order_KEYPayroll_Check_Payroll_Item_Distribution_Child_Support_Detail

Schema diagram