Table: dbo.Tax_Form_Liability_Processing_Lock
This table is used to implement a locking mechanism for tax form liability processing. When a tax form's liabilities are being processed an entry is first made into this table to indicate that other users are prevented from processing identical liabilities.
Columns
Name | Type | Constraints | Description
tax_form_liability_processing_lock_KEY | int (4) | NOT NULL | Primary key for this table.
user_session_guid | uniqueidentifier (16) | NOT NULL | The user session identifier of the user locking the forms.
client_KEY | int (4) | NOT NULL | Foreign key to client being processed.
tax_form_KEY | int (4) | NOT NULL | Foreign key to the tax form being processed.
period_end_date | smalldatetime (4) | NOT NULL | Period end date for the liabilities being processed.

Primary key
Name | Columns | Description
PK_Tax_Form_Liability_Processing_Lock | tax_form_liability_processing_lock_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Tax_Form_Liability_Processing_Lock__User_Session__user_session_guid | user_session_guid | User_Session (user_session_guid) |
FK_Tax_Form_Liability_Processing_Lock__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Tax_Form_Liability_Processing_Lock__Tax_Form__tax_form_KEY | tax_form_KEY | Tax_Form (tax_form_KEY) |