Table: dbo.Shortfall_Deduction_Treatment_Selection
Table that defines which client deduction items are applicable for shortfall processing
Columns
NameTypeConstraintsDescription
client_payroll_item_KEYint (4)NOT NULLForeign key to selected client payroll item
Primary key
NameColumnsDescription
PK_Shortfall_Deduction_Treatment_Selection$client_payroll_item_KEYclient_payroll_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Shortfall_Deduction_Treatment_Selection__Client_Payroll_Item__client_payroll_item_KEYclient_payroll_item_KEYClient_Payroll_Item (client_payroll_item_KEY)

Schema diagram