Table: dbo.XactPay_Setup_Transmission_Result
Table containing XactPay setup file history
Columns
Name | Type | Constraints | Description
xactpay_setup_transmission_result_KEY | int (4) | NOT NULL | Primary key for this table.
xactpay_setup_transmission_KEY | int (4) | NOT NULL | XactPay_Setup_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_Setup_Transmission_Result | xactpay_setup_transmission_result_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_XactPay_Setup_Transmission_Result__Thirdparty_Worker_Compensation_Transmission_Status_Type__thirdparty_worker_compensation_tr | thirdparty_worker_compensation_transmission_status_type_KEY | Thirdparty_Worker_Compensation_Transmission_Status_Type (thirdparty_worker_compensation_transmission_status_type_KEY) |
FK_XactPay_Setup_Transmission_Result__XactPay_Setup_Transmission__xactpay_setup_transmission_KEY | xactpay_setup_transmission_KEY | XactPay_Setup_Transmission (xactpay_setup_transmission_KEY) |