Table: dbo.Payroll_Check_Entry_Option_Shortfall_Deduction_Treatment
This table contains the client deduction items used to reduce a negative check.
Columns
NameTypeConstraintsDescription
payroll_check_entry_option_shortfall_deduction_treatment_KEYint (4)NOT NULLPrimary Key.
client_pay_schedule_KEYint (4)NOT NULLIndicates which payroll check entry option this is related to.
client_payroll_item_KEYint (4)NOT NULLIndicates a client deduction that will be used to reduce a negative check.
payroll_check_entry_option_shortfall_deduction_treatment_versiontimestamp (8)NOT NULLThe version of this row. It's an aid in versioning the row.
Primary key
NameColumnsDescription
PK_Payroll_Check_Entry_Option_Shortfall_Deduction_Treatmentpayroll_check_entry_option_shortfall_deduction_treatment_KEY
Unique constraints
NameColumnsDescription
UK_Payroll_Check_Entry_Option_Shortfall_Deduction_Treatment$client_pay_schedule_KEY$client_payroll_item_KEYclient_pay_schedule_KEY, client_payroll_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Check_Entry_Option_Shortfall_Deduction_Treatment__Client_Payroll_Item__client_payroll_item_KEYclient_payroll_item_KEYClient_Payroll_Item (client_payroll_item_KEY)
FK_Payroll_Check_Entry_Option_Shortfall_Deduction_Treatment__Payroll_Check_Entry_Option__client_pay_schedule_KEYclient_pay_schedule_KEYPayroll_Check_Entry_Option (client_pay_schedule_KEY)

Schema diagram