Contains the garnishment information order(s) for each valid garnishment type employee payroll item. |
garnishment_order_KEY | int (4) | NOT NULL | Primary key for this table. |
garnishment_type_KEY | int (4) | NOT NULL | The type of garnishment for the order. |
employee_KEY | int (4) | NOT NULL | The employee that this order belongs to. |
case_identifier | nvarchar (60) | NOT NULL | Optional court case identifier that is determined by the jurisidiction that issued the garnishment order. |
order_date | smalldatetime (4) | | Optional date when this order should start being deducted from pay. |
ste_state_code_KEY | nvarchar (4) | | Optional Symmetry code for the state from which the garnishment order originated. |
vendor_KEY | int (4) | | Optional tax agent (vendor) to whom payment is due. |
amount | decimal (9, 2) | NOT NULL | The garnishment amount or percentage amount for this order to be deducted each paycheck. |
total_order_amount | decimal (9, 2) | NOT NULL | Optional total amount of this order to be paid. |
inactive_date | smalldatetime (4) | | Optional date when to stop calculating the garnishment. |
payroll_item_special_timing_KEY | int (4) | NOT NULL | The special timing that this garnishment is associated with. |