| Table: dbo.Shortfall_Transaction | |||
| Transactions to track tax and deduction shortfalls from checks and restitution payments. | |||
| Columns | |||
| Name | Type | Constraints | Description |
| shortfall_transaction_KEY | int (4) | NOT NULL | Primary key |
| shortfall_transaction_type_KEY | int (4) | NOT NULL | Type of transaction |
| employee_KEY | int (4) | NOT NULL | Foreign key to the associated employee |
| transaction_date | smalldatetime (4) | NOT NULL | Date of the transaction |
| amount | decimal (9, 2) | NOT NULL | Dollar amount. Positive is a check shortfall, negative is a restitution or waiver |
| Primary key | |||
| Name | Columns | Description | |
| PK_Shortfall_Transaction | shortfall_transaction_KEY | ||