Table: dbo.W2_Nonqualified_Deferred_Compensation_Type
The table defines types of nonqualified deferred compensation for W2 processing.
Columns
NameTypeConstraintsDescription
w2_nonqualified_deferred_compensation_type_KEYint (4)NOT NULLPrimary key.
descriptionnvarchar (24)NOT NULLNonqualified deferred compensation plan description.
Primary key
NameColumnsDescription
PK_W2_Nonqualified_Deferred_Compensation_Typew2_nonqualified_deferred_compensation_type_KEY
Unique constraints
NameColumnsDescription
UK_W2_Nonqualified_Deferred_Compensation_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_Payroll_Item__W2_Nonqualified_Deferred_Compensation_Type__w2_nonqualified_deferred_compensation_type_KEYw2_nonqualified_deferred_compensation_type_KEYClient_Payroll_Item

Schema diagram