Table: dbo.Shortfall_Balance_Payroll_Check_Treatment
Type table which defines the actions to take to apply gains to a prior shortfall.
Columns
Name | Type | Constraints | Description
shortfall_balance_payroll_check_treatment_KEY | int (4) | NOT NULL | Primary Key
description | nvarchar (200) | NOT NULL | Shortfall balance treatment description.

Primary key
Name | Columns | Description
PK_Shortfall_Balance_Payroll_Check_Treatment | shortfall_balance_payroll_check_treatment_KEY |
Unique constraints
Name | Columns | Description
UK_Shortfall_Balance_Payroll_Check_Treatment$description | description |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Payroll_Check_Entry_Option__Shortfall_Balance_Payroll_Check_Treatment__shortfall_balance_payroll_check_treatment_KEY | shortfall_balance_payroll_check_treatment_KEY | Payroll_Check_Entry_Option |