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 |