Table: dbo.Insurepay_Payroll_Transmission_Result
Table containing client specific InsurePay payroll transmission result information.
Columns
Name | Type | Constraints | Description
insurepay_payroll_transmission_result_KEY | int (4) | NOT NULL | Primary key for this table.
insurepay_payroll_transmission_KEY | int (4) | NOT NULL | Foreign key for this table.The associated Insurepay_Payroll_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 payroll file.The associated .Thirdparty_Worker_Compensation_Transmission_Status_Type primary key.
status_change_date | datetime (8, 3) | NOT NULL | insurepay Payroll 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_Payroll_Transmission_Result | insurepay_payroll_transmission_result_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Insurepay_Payroll_Transmission_Result__Insurepay_Payroll_Transmission__insurepay_payroll_transmission_KEY | insurepay_payroll_transmission_KEY | Insurepay_Payroll_Transmission (insurepay_payroll_transmission_KEY) |
FK_Insurepay_Payroll_Transmission_Result__Thirdparty_Worker_Compensation_Transmission_Status_Type__thirdparty_worker_compensatio | thirdparty_worker_compensation_transmission_status_type_KEY | Thirdparty_Worker_Compensation_Transmission_Status_Type (thirdparty_worker_compensation_transmission_status_type_KEY) |