This table stores the information associated with a complete forms output session. |
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. |