Table: dbo.Insurepay_Setup_Transmission_Result
Table containing client specific InsurePay setup transmission result information.
Columns
Name | Type | Constraints | Description
insurepay_setup_transmission_result_KEY | int (4) | NOT NULL | Primary key for this table.
insurepay_setup_transmission_KEY | int (4) | NOT NULL | Foreign key for this table. The associated Insurepay_Setup_Transmission table primary key.
thirdparty_worker_compensation_transmission_status_type_KEY | int (4) | NOT NULL | Foreign key for this table. Transmission Status for this Insurepay setup file.The associated. Thirdparty_Worker_Compensation_Transmission_Status_Type table primary key.
status_change_date | datetime (8, 3) | NOT NULL | insurepay setup transmission date.
ack_data_xml | nvarchar (-1) | NOT NULL | The data from the acknowledgement file.
connect_event_id | int (4) | NOT NULL | The 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
Name | Columns | Description
PK_Insurepay_Setup_Transmission_Result | insurepay_setup_transmission_result_KEY |
Unique constraints
Name | Columns | Description
UK_Insurepay_Setup_Transmission_Result$insurepay_setup_transmission_KEY$status_change_date$connect_event_id | insurepay_setup_transmission_KEY, status_change_date, connect_event_id |

Foreign keys
Name | Columns | Referenced table | Description
FK_Insurepay_Setup_Transmission_Result__Insurepay_Setup_Transmission__insurepay_setup_transmission_KEY | insurepay_setup_transmission_KEY | Insurepay_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_KEY | Thirdparty_Worker_Compensation_Transmission_Status_Type (thirdparty_worker_compensation_transmission_status_type_KEY) |