Table: dbo.Complete_Forms_Output_Session
This table stores the information associated with a complete forms output session.
Columns
Name | Type | Constraints | Description
complete_forms_output_session_KEY | int (4) | NOT NULL | Primary key for this table.
session_start_time_utc | datetime (8, 3) | NOT NULL | Date and time the complete forms output session started.
staff_KEY | int (4) | NOT NULL | Staff key associated with the staff running the complete forms output session.
complete_forms_output_session_status_KEY | tinyint (1) | NOT NULL | Complete forms output session status key.
session_finish_time_utc | datetime (8, 3) |  | Date and time the complete forms output session completed or failed. If this date is null, then the session is still in progress.
user_session_guid | uniqueidentifier (16) | NOT NULL | The user session for the person running the complete forms output session. This will be used to determine if clean up of aborted sessions is needed in this table.
liability_adjustment_threshold | decimal (9, 2) | NOT NULL | The firm level liability adjustment threshold used.
clear_form_overrides | bit (1) | NOT NULL | Flag to indicate whether form overrides are being cleared.
clear_employee_overrides | bit (1) | NOT NULL | Flag to indicate whether employee overrides are being cleared.
do_not_include_summary_report | bit (1) | NOT NULL | Flag to indicate whether the summary report is being generated.
calc_penalty_interest | bit (1) | NOT NULL | Flag to indicate whether penalty and interest is being calculated.
details | nvarchar (-1) |  | Details, if any, of what happened in the session. Nonscalar data stored using JSON.
exclude_withholding_forms | bit (1) | NOT NULL | A bool flag to indicate if a Complete Forms Output session should exclude withholding forms from liability adjustment threshold.

Primary key
Name | Columns | Description
PK_Complete_Forms_Output_Session | complete_forms_output_session_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Complete_Forms_Output_Session__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) |
FK_Complete_Forms_Output_Session__Complete_Forms_Output_Session_Status__complete_forms_output_session_status_KEY | complete_forms_output_session_status_KEY | Complete_Forms_Output_Session_Status (complete_forms_output_session_status_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Complete_Forms_Output_Session_Client_Detail__Complete_Forms_Output_Session__complete_forms_output_session_KEY | complete_forms_output_session_KEY | Complete_Forms_Output_Session_Client_Detail |