Table: dbo.Payroll_Check_Entry_Option_Shortfall_Deduction_Treatment
This table contains the client deduction items used to reduce a negative check.
Columns
Name | Type | Constraints | Description
payroll_check_entry_option_shortfall_deduction_treatment_KEY | int (4) | NOT NULL | Primary Key.
client_pay_schedule_KEY | int (4) | NOT NULL | Indicates which payroll check entry option this is related to.
client_payroll_item_KEY | int (4) | NOT NULL | Indicates a client deduction that will be used to reduce a negative check.
payroll_check_entry_option_shortfall_deduction_treatment_version | timestamp (8) | NOT NULL | The version of this row. It's an aid in versioning the row.

Primary key
Name | Columns | Description
PK_Payroll_Check_Entry_Option_Shortfall_Deduction_Treatment | payroll_check_entry_option_shortfall_deduction_treatment_KEY |
Unique constraints
Name | Columns | Description
UK_Payroll_Check_Entry_Option_Shortfall_Deduction_Treatment$client_pay_schedule_KEY$client_payroll_item_KEY | client_pay_schedule_KEY, client_payroll_item_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Check_Entry_Option_Shortfall_Deduction_Treatment__Client_Payroll_Item__client_payroll_item_KEY | client_payroll_item_KEY | Client_Payroll_Item (client_payroll_item_KEY) |
FK_Payroll_Check_Entry_Option_Shortfall_Deduction_Treatment__Payroll_Check_Entry_Option__client_pay_schedule_KEY | client_pay_schedule_KEY | Payroll_Check_Entry_Option (client_pay_schedule_KEY) |