| Table: dbo.Shortfall_Deduction_Treatment_Selection | |||
| Table that defines which client deduction items are applicable for shortfall processing | |||
| Columns | |||
| Name | Type | Constraints | Description |
| client_payroll_item_KEY | int (4) | NOT NULL | Foreign key to selected client payroll item |
| Primary key | |||
| Name | Columns | Description | |
| PK_Shortfall_Deduction_Treatment_Selection$client_payroll_item_KEY | client_payroll_item_KEY | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_Shortfall_Deduction_Treatment_Selection__Client_Payroll_Item__client_payroll_item_KEY | client_payroll_item_KEY | Client_Payroll_Item (client_payroll_item_KEY) | |