Table: dbo.XactPay_Payroll_Transmission_Result
Table containing XactPay payroll file history
Columns
NameTypeConstraintsDescription
xactpay_payroll_transmission_result_KEYint (4)NOT NULLPrimary key for this table.
xactpay_payroll_transmission_KEYint (4)NOT NULLXactPay_Payroll_Transmission key.
thirdparty_worker_compensation_transmission_status_type_KEYint (4)NOT NULLFile status.
status_change_datedatetime (8, 3)NOT NULLThe date the result status changed.
ack_data_xmlnvarchar (-1)NOT NULLAcknowledgement data.
connect_event_idint (4)NOT NULLEvent number from Connect.
Primary key
NameColumnsDescription
PK_XactPay_Payroll_Transmission_Resultxactpay_payroll_transmission_result_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_XactPay_Payroll_Transmission_Result__Thirdparty_Worker_Compensation_Transmission_Status_Type__thirdparty_worker_compensation_thirdparty_worker_compensation_transmission_status_type_KEYThirdparty_Worker_Compensation_Transmission_Status_Type (thirdparty_worker_compensation_transmission_status_type_KEY)
FK_XactPay_Payroll_Transmission_Result__XactPay_Payroll_Transmission__xactpay_payroll_transmission_KEYxactpay_payroll_transmission_KEYXactPay_Payroll_Transmission (xactpay_payroll_transmission_KEY)

Schema diagram