Table: dbo.Child_Support_Order
Columns
Name | Type | Constraints | Description
child_support_order_KEY | int (4) | NOT NULL | Primary key.
employee_payroll_item_KEY | int (4) | NOT NULL | Each 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_identifier | nvarchar (40) | NOT NULL | Court case identifier - determined by the jurisidiction that issued the support order.
ste_state_code_KEY | nvarchar (4) | NOT NULL | Symmetry code for the state from which the support order originated.
ste_county_KEY | int (4) |  | The county in which the support order originated. Not required for most states.
vendor_KEY | int (4) |  | The tax agent (vendor) to whom payment is due.
amount | decimal (9, 2) | NOT NULL | Garnishment amount.
direct_deposit_status_KEY | nvarchar (40) |  | Status of the direct deposit transaction associated with the garnishment. Most, but not all, states support garnishment via direct deposit.
in_arrears | bit (1) | NOT NULL | When this flag is true, it indicates that at least one payment is overdue.
prenote_date | smalldatetime (4) |  | Date prenote request was processed for this order.
prenote_created | bit (1) | NOT NULL | Flag indicating that a prenote was created for this order.
total_order_amount | decimal (9, 2) | NOT NULL | Total amount limit of this order.
payroll_item_special_timing_KEY | int (4) | NOT NULL | Foreign key into the Payroll Item Special timing table.
order_date | smalldatetime (4) |  | Optional date when this order should start being deducted from pay. If null deduct from pay.
prenote_effective_date | smalldatetime (4) |  | The effective date used when prenoting this allocation.
notes | nvarchar (480) | NOT NULL | Direct deposit processing notes when this allocation is prenoted.
inactive_date | smalldatetime (4) |  | Optional date when to stop calculating the garnishment. Date checking will be skipped when the date is null.

Primary key
Name | Columns | Description
PK_Child_Support_Order | child_support_order_KEY |
Unique constraints
Name | Columns | Description
UK_Child_Support_Order$payroll_item_special_timing_KEY | payroll_item_special_timing_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Child_Support_Order__Direct_Deposit_Status__direct_deposit_status_KEY | direct_deposit_status_KEY | Direct_Deposit_Status (direct_deposit_status_KEY) |
FK_Child_Support_Order__Employee_Payroll_Item__employee_payroll_item_KEY | employee_payroll_item_KEY | Employee_Payroll_Item (employee_payroll_item_KEY) |
FK_Child_Support_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_Child_Support_Order__Ste_County__ste_county_KEY | ste_county_KEY | Ste_County (ste_county_KEY) |
FK_Child_Support_Order__Ste_State_Code__ste_state_code_KEY | ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) |
FK_Child_Support_Order__Vendor__vendor_KEY | vendor_KEY | Vendor (vendor_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Payroll_Check_Payroll_Item_Distribution_Child_Support_Detail__Child_Support_Order__child_support_order_KEY | child_support_order_KEY | Payroll_Check_Payroll_Item_Distribution_Child_Support_Detail |