Table: dbo.Check_Template_Usage_Preference_Setting
This table stores the usage settings used for payroll check templates, for when possibly initializing a payroll check based on a template, and for when possibly updating a payroll check template based on edits to a payroll check.
Columns
NameTypeConstraintsDescription
check_template_usage_preference_setting_KEYtinyint (1)NOT NULLthe primary key of this table.
descriptionnvarchar (40)NOT NULLThe check_template_usage_preference_setting_KEY description.
Primary key
NameColumnsDescription
PK_Check_Template_Usage_Preference_Settingcheck_template_usage_preference_setting_KEY
Unique constraints
NameColumnsDescription
UK_Check_Template_Usage_Preference_Setting$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Enter_Transaction_User_Preference$template_retrieval__check_template_usage_preference_setting_KEYtemplate_retrieval__check_template_usage_preference_setting_KEYEnter_Transaction_User_Preference
FK_Enter_Transaction_User_Preference$template_update__check_template_usage_preference_setting_KEYtemplate_update__check_template_usage_preference_setting_KEYEnter_Transaction_User_Preference

Schema diagram