Table: dbo.Form_Processing_Run
This table holds the data for each form processing run.
Columns
NameTypeConstraintsDescription
form_processing_run_KEYint (4)NOT NULLPrimary Key
client_KEYint (4)NOT NULLThe client this form processing run is related to.
processing_datedatetime (8, 3)NOT NULLThe date that this form processing run was performed.
is_printed_formbit (1)NOT NULLWhether or not this form was printed or electronically processed.
was_client_copy_printedbit (1)NOT NULLWhether or not a client copy was printed.
Primary key
NameColumnsDescription
PK_Form_Processing_Runform_processing_run_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Form_Processing_Run__Client__client_KEYclient_KEYClient (client_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Form_Processing_Run_Form_Count__Form_Processing_Run__form_processing_run_KEYform_processing_run_KEYForm_Processing_Run_Form_Count
FK_Billable_Item_N_Form_Processing_Run__Form_Processing_Run__form_processing_run_KEYform_processing_run_KEYBillable_Item_N_Form_Processing_Run

Schema diagram