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. |