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