Table: dbo.Payroll_Check_Payroll_Item_Distribution_Garnishment_Detail
Contains garnishment detail information for each payroll check distribution record.
Columns
Name | Type | Constraints | Description
payroll_check_payroll_item_distribution_garnishment_detail_KEY | int (4) | NOT NULL | Primary key for this table.
garnishment_order_KEY | int (4) | NOT NULL |
payroll_check_payroll_item_distribution_KEY | int (4) | NOT NULL | The payroll check distribution that this garnishment is associated with.
case_identifier | nvarchar (60) | NOT NULL | Optional court case identifier that is determined by the jurisidiction that issued the garnishment order.
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 | Represents the portion of payment for this particular order and distribution. All orders for the same distribution will total the payroll check payroll item distribution.

Primary key
Name | Columns | Description
PK_Payroll_Check_Payroll_Item_Distribution_Garnishment_Detail | payroll_check_payroll_item_distribution_garnishment_detail_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Check_Payroll_Item_Distribution_Garnishment_Detail__Garnishment_Order__garnishment_order_KEY | garnishment_order_KEY | Garnishment_Order (garnishment_order_KEY) |
FK_Payroll_Check_Payroll_Item_Distribution_Garnishment_Detail__Payroll_Check_Payroll_Item_Distribution__payroll_check_payroll_it | payroll_check_payroll_item_distribution_KEY | Payroll_Check_Payroll_Item_Distribution (payroll_check_payroll_item_distribution_KEY) |
FK_Payroll_Check_Payroll_Item_Distribution_Garnishment_Detail__Ste_State_Code__ste_state_code_KEY | ste_state_code_KEY | Ste_State_Code (ste_state_code_KEY) |
FK_Payroll_Check_Payroll_Item_Distribution_Garnishment_Detail__Vendor__vendor_KEY | vendor_KEY | Vendor (vendor_KEY) |