Table: dbo.Insurepay_Pay_Item_Type
Table containing Insurepay pay item types.
Columns
NameTypeConstraintsDescription
insurepay_pay_item_type_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (100)NOT NULLDescription of the Insurepay pay item type.
insurepay_descriptionnvarchar (100)NOT NULLInsurepay pay item type as written in Insurepay file
Primary key
NameColumnsDescription
PK_Insurepay_Pay_Item_Typeinsurepay_pay_item_type_KEY
Unique constraints
NameColumnsDescription
UK_Insurepay_Pay_Item_Type$descriptiondescription
UK_Insurepay_Pay_Item_Type$insurepay_descriptioninsurepay_description
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Pay_Item__Insurepay_Pay_Item_Type__insurepay_pay_item_type_KEYinsurepay_pay_item_type_KEYPay_Item
FK_Employee_Payroll_Item__Insurepay_Pay_Item_Type__insurepay_pay_item_type_KEYinsurepay_pay_item_type_KEYEmployee_Payroll_Item

Schema diagram