Table: dbo.Complete_Forms_Output_Session
This table stores the information associated with a complete forms output session.
Columns
NameTypeConstraintsDescription
complete_forms_output_session_KEYint (4)NOT NULLPrimary key for this table.
session_start_time_utcdatetime (8, 3)NOT NULLDate and time the complete forms output session started.
staff_KEYint (4)NOT NULLStaff key associated with the staff running the complete forms output session.
complete_forms_output_session_status_KEYtinyint (1)NOT NULLComplete forms output session status key.
session_finish_time_utcdatetime (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_guiduniqueidentifier (16)NOT NULLThe 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_thresholddecimal (9, 2)NOT NULLThe firm level liability adjustment threshold used.
clear_form_overridesbit (1)NOT NULLFlag to indicate whether form overrides are being cleared.
clear_employee_overridesbit (1)NOT NULLFlag to indicate whether employee overrides are being cleared.
do_not_include_summary_reportbit (1)NOT NULLFlag to indicate whether the summary report is being generated.
calc_penalty_interestbit (1)NOT NULLFlag to indicate whether penalty and interest is being calculated.
detailsnvarchar (-1)Details, if any, of what happened in the session. Nonscalar data stored using JSON.
exclude_withholding_formsbit (1)NOT NULLA bool flag to indicate if a Complete Forms Output session should exclude withholding forms from liability adjustment threshold.
Primary key
NameColumnsDescription
PK_Complete_Forms_Output_Sessioncomplete_forms_output_session_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Complete_Forms_Output_Session__Staff__staff_KEYstaff_KEYStaff (staff_KEY)
FK_Complete_Forms_Output_Session__Complete_Forms_Output_Session_Status__complete_forms_output_session_status_KEYcomplete_forms_output_session_status_KEYComplete_Forms_Output_Session_Status (complete_forms_output_session_status_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Complete_Forms_Output_Session_Client_Detail__Complete_Forms_Output_Session__complete_forms_output_session_KEYcomplete_forms_output_session_KEYComplete_Forms_Output_Session_Client_Detail

Schema diagram