Table: dbo.Payroll_Check_Payroll_Item_Distribution_Garnishment_Detail
Contains garnishment detail information for each payroll check distribution record.
Columns
NameTypeConstraintsDescription
payroll_check_payroll_item_distribution_garnishment_detail_KEYint (4)NOT NULLPrimary key for this table.
garnishment_order_KEYint (4)NOT NULL
payroll_check_payroll_item_distribution_KEYint (4)NOT NULLThe payroll check distribution that this garnishment is associated with.
case_identifiernvarchar (60)NOT NULLOptional court case identifier that is determined by the jurisidiction that issued the garnishment order.
ste_state_code_KEYnvarchar (4)Optional Symmetry code for the state from which the garnishment order originated.
vendor_KEYint (4)Optional tax agent (vendor) to whom payment is due.
amountdecimal (9, 2)NOT NULLRepresents 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
NameColumnsDescription
PK_Payroll_Check_Payroll_Item_Distribution_Garnishment_Detailpayroll_check_payroll_item_distribution_garnishment_detail_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Check_Payroll_Item_Distribution_Garnishment_Detail__Garnishment_Order__garnishment_order_KEYgarnishment_order_KEYGarnishment_Order (garnishment_order_KEY)
FK_Payroll_Check_Payroll_Item_Distribution_Garnishment_Detail__Payroll_Check_Payroll_Item_Distribution__payroll_check_payroll_itpayroll_check_payroll_item_distribution_KEYPayroll_Check_Payroll_Item_Distribution (payroll_check_payroll_item_distribution_KEY)
FK_Payroll_Check_Payroll_Item_Distribution_Garnishment_Detail__Ste_State_Code__ste_state_code_KEYste_state_code_KEYSte_State_Code (ste_state_code_KEY)
FK_Payroll_Check_Payroll_Item_Distribution_Garnishment_Detail__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)

Schema diagram