Contains creditor garnishment orders for employee payroll items. |
creditor_garnishment_order_KEY | int (4) | NOT NULL | Primary key. |
employee_payroll_item_KEY | int (4) | NOT NULL | Each creditor garnishment is linked to an employee payroll item. More than one creditor garnishment can be associated with an employee payroll item. |
case_identifier | nvarchar (40) | NOT NULL | Case identifier - determined by the creditor that issued the garnishment order. |
order_date | smalldatetime (4) | NOT NULL | Order date. |
ste_state_code_KEY | nvarchar (4) | NOT NULL | Symmetry code for the state from which the order originated. |
ste_county_KEY | int (4) | | The county in which the order originated. Not required for most states. |
vendor_KEY | int (4) | | The agent (vendor) to whom payment is due. |
amount | decimal (9, 2) | NOT NULL | Garnishment amount. |
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. |
inactive_date | smalldatetime (4) | | Optional date when to stop calculating the garnishment. Date checking will be skipped when the date is null. |