Table: dbo.Payroll_Check_Entry_Option_Shortfall_Tax_Treatment
This table contains the client tax items used to reduce a negative check.
Columns
Name | Type | Constraints | Description
payroll_check_entry_option_shortfall_tax_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.
shortfall_tax_treatment_type_KEY | int (4) | NOT NULL | Indicates which tax treatment types can be used to reduce a negative check.
payroll_check_entry_option_shortfall_tax_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_Tax_Treatment | payroll_check_entry_option_shortfall_tax_treatment_KEY |
Unique constraints
Name | Columns | Description
UK_Payroll_Check_Entry_Option_Shortfall_Tax_Treatment$client_pay_schedule_KEY$shortfall_tax_treatment_type_KEY | client_pay_schedule_KEY, shortfall_tax_treatment_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Check_Entry_Option_Shortfall_Tax_Treatment__Payroll_Check_Entry_Option__client_pay_schedule_KEY | client_pay_schedule_KEY | Payroll_Check_Entry_Option (client_pay_schedule_KEY) |
FK_Payroll_Check_Entry_Option_Shortfall_Tax_Treatment__Shortfall_Tax_Treatment_Type__shortfall_tax_treatment_type_KEY | shortfall_tax_treatment_type_KEY | Shortfall_Tax_Treatment_Type (shortfall_tax_treatment_type_KEY) |