Table: dbo.XactPay_Payroll_Transmission_Result | |||
Table containing XactPay payroll file history | |||
Columns | |||
Name | Type | Constraints | Description |
xactpay_payroll_transmission_result_KEY | int (4) | NOT NULL | Primary key for this table. |
xactpay_payroll_transmission_KEY | int (4) | NOT NULL | XactPay_Payroll_Transmission key. |
thirdparty_worker_compensation_transmission_status_type_KEY | int (4) | NOT NULL | File status. |
status_change_date | datetime (8, 3) | NOT NULL | The date the result status changed. |
ack_data_xml | nvarchar (-1) | NOT NULL | Acknowledgement data. |
connect_event_id | int (4) | NOT NULL | Event number from Connect. |
Primary key | |||
Name | Columns | Description | |
PK_XactPay_Payroll_Transmission_Result | xactpay_payroll_transmission_result_KEY |