| 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 | |