Table containing client specific InsurePay setup transmission result information. |
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. |