Table: dbo.Complete_Forms_Output_Session_Client_Detail
This table stores the client detail associated with a complete forms output session.
Columns
NameTypeConstraintsDescription
complete_forms_output_session_client_detail_KEYint (4)NOT NULLPrimary key for this table.
complete_forms_output_session_KEYint (4)NOT NULLForeign key to the parent table Complete_Forms_Output_Session.
client_KEYint (4)NOT NULLA client we are processing inside this complete forms output session.
liability_adjustment_thresholddecimal (9, 2)The client level liability adjustment threshold used, NULL if the firm level threshold was used.
detailsnvarchar (-1)Details, if any, of what happened in the session. Nonscalar data stored using JSON. Can include error messages as well as basic processing information.
exclude_withholding_formsbit (1)NOT NULLA bool flag to indicate if a Complete Forms Output Client Detail Session should exclude withholding forms from liability adjustment threshold.
Primary key
NameColumnsDescription
PK_Complete_Forms_Output_Session_Client_Detailcomplete_forms_output_session_client_detail_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Complete_Forms_Output_Session_Client_Detail__Complete_Forms_Output_Session__complete_forms_output_session_KEYcomplete_forms_output_session_KEYComplete_Forms_Output_Session (complete_forms_output_session_KEY)
FK_Complete_Forms_Output_Session_Client_Detail__Client__client_KEYclient_KEYClient (client_KEY)

Schema diagram