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 |

Foreign keys
Name | Columns | Referenced table | Description
FK_Shortfall_Transaction__Employee__employee_KEY | employee_KEY | Employee (employee_KEY) |
FK_Shortfall_Transaction__Shortfall_Transaction_Type__shortfall_transaction_type_KEY | shortfall_transaction_type_KEY | Shortfall_Transaction_Type (shortfall_transaction_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Shortfall_Transaction_N_Client_Payroll_Item__Shortfall_Transaction__shortfall_transaction_KEY | shortfall_transaction_KEY | Shortfall_Transaction_N_Client_Payroll_Item |
FK_Shortfall_Transaction_N_Client_Tax_Item__Shortfall_Transaction__shortfall_transaction_KEY | shortfall_transaction_KEY | Shortfall_Transaction_N_Client_Tax_Item |
FK_Shortfall_Transaction_N_Payroll_Check_Tax_Item__Shortfall_Transaction__shortfall_transaction_KEY | shortfall_transaction_KEY | Shortfall_Transaction_N_Payroll_Check_Tax_Item |
FK_Shortfall_Transaction_N_Payroll_Check_Payroll_Item__Shortfall_Transaction__shortfall_transaction_KEY | shortfall_transaction_KEY | Shortfall_Transaction_N_Payroll_Check_Payroll_Item |
FK_Payable_Transaction_N_Shortfall_Transaction__Shortfall_Transaction__shortfall_transaction_KEY | shortfall_transaction_KEY | Payable_Transaction_N_Shortfall_Transaction |