Table: dbo.Insurepay_Payroll_Transmission_Result
Table containing client specific InsurePay payroll transmission result information.
Columns
NameTypeConstraintsDescription
insurepay_payroll_transmission_result_KEYint (4)NOT NULLPrimary key for this table.
insurepay_payroll_transmission_KEYint (4)NOT NULLForeign key for this table.The associated Insurepay_Payroll_Transmission table Primary Key.
thirdparty_worker_compensation_transmission_status_type_KEYint (4)NOT NULLForeign key for this table. Transmission Status for this Insurepay payroll file.The associated .Thirdparty_Worker_Compensation_Transmission_Status_Type primary key.
status_change_datedatetime (8, 3)NOT NULLinsurepay Payroll transmission date.
ack_data_xmlnvarchar (-1)NOT NULLThe data from the acknowledgement file.
connect_event_idint (4)NOT NULLThe 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
NameColumnsDescription
PK_Insurepay_Payroll_Transmission_Resultinsurepay_payroll_transmission_result_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Insurepay_Payroll_Transmission_Result__Insurepay_Payroll_Transmission__insurepay_payroll_transmission_KEYinsurepay_payroll_transmission_KEYInsurepay_Payroll_Transmission (insurepay_payroll_transmission_KEY)
FK_Insurepay_Payroll_Transmission_Result__Thirdparty_Worker_Compensation_Transmission_Status_Type__thirdparty_worker_compensatiothirdparty_worker_compensation_transmission_status_type_KEYThirdparty_Worker_Compensation_Transmission_Status_Type (thirdparty_worker_compensation_transmission_status_type_KEY)

Schema diagram