| 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 | ||