Table: dbo.Insurepay_Setup_Transmission_Result
Table containing client specific InsurePay setup transmission result information.
Columns
NameTypeConstraintsDescription
insurepay_setup_transmission_result_KEYint (4)NOT NULLPrimary key for this table.
insurepay_setup_transmission_KEYint (4)NOT NULLForeign key for this table. The associated Insurepay_Setup_Transmission table primary key.
thirdparty_worker_compensation_transmission_status_type_KEYint (4)NOT NULLForeign key for this table. Transmission Status for this Insurepay setup file.The associated. Thirdparty_Worker_Compensation_Transmission_Status_Type table primary key.
status_change_datedatetime (8, 3)NOT NULLinsurepay setup transmission date.
ack_data_xmlnvarchar (-1)NOT NULLThe data from the acknowledgement file.
connect_event_idint (4)NOT NULLThe associated event id from Connect. This connect_event_id will be used to determine the chronological order of events when multiple events take place at the same time.
Primary key
NameColumnsDescription
PK_Insurepay_Setup_Transmission_Resultinsurepay_setup_transmission_result_KEY
Unique constraints
NameColumnsDescription
UK_Insurepay_Setup_Transmission_Result$insurepay_setup_transmission_KEY$status_change_date$connect_event_idinsurepay_setup_transmission_KEY, status_change_date, connect_event_id
Foreign keys
NameColumnsReferenced tableDescription
FK_Insurepay_Setup_Transmission_Result__Insurepay_Setup_Transmission__insurepay_setup_transmission_KEYinsurepay_setup_transmission_KEYInsurepay_Setup_Transmission (insurepay_setup_transmission_KEY)
FK_Insurepay_Setup_Transmission_Result__Thirdparty_Worker_Compensation_Transmission_Status_Type__thirdparty_worker_compensation_thirdparty_worker_compensation_transmission_status_type_KEYThirdparty_Worker_Compensation_Transmission_Status_Type (thirdparty_worker_compensation_transmission_status_type_KEY)

Schema diagram