Table: dbo.Minimum_Wage_Payroll_Check_Treatment
Type table which defines the actions to take if minimum wage is not met when saving a check.
Columns
NameTypeConstraintsDescription
minimum_wage_payroll_check_treatment_KEYint (4)NOT NULLPrimary Key
descriptionnvarchar (200)NOT NULLMinimum wage check treatment description.
Primary key
NameColumnsDescription
PK_Minimum_Wage_Payroll_Check_Treatmentminimum_wage_payroll_check_treatment_KEY
Unique constraints
NameColumnsDescription
UK_Minimum_Wage_Payroll_Check_Treatment$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payroll_Check_Entry_Option__Minimum_Wage_Payroll_Check_Treatment__minimum_wage_payroll_check_treatment_KEYminimum_wage_payroll_check_treatment_KEYPayroll_Check_Entry_Option

Schema diagram