Table: dbo.Thirdparty_Worker_Compensation_Transmission_Status_Type
Table containing third party worker compensation transmission status types.
Columns
Name | Type | Constraints | Description
thirdparty_worker_compensation_transmission_status_type_KEY | int (4) | NOT NULL | Primary key for this table.
description | nvarchar (100) | NOT NULL |

Primary key
Name | Columns | Description
PK_Thirdparty_Worker_Compensation_Transmission_Status_Type | thirdparty_worker_compensation_transmission_status_type_KEY |
Unique constraints
Name | Columns | Description
UK_Thirdparty_Worker_Compensation_Transmission_Status_Type$description | description |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_XactPay_Payroll_Transmission_Result__Thirdparty_Worker_Compensation_Transmission_Status_Type__thirdparty_worker_compensation_ | thirdparty_worker_compensation_transmission_status_type_KEY | XactPay_Payroll_Transmission_Result |
FK_XactPay_Setup_Transmission_Result__Thirdparty_Worker_Compensation_Transmission_Status_Type__thirdparty_worker_compensation_tr | thirdparty_worker_compensation_transmission_status_type_KEY | XactPay_Setup_Transmission_Result |
FK_Insurepay_Payroll_Transmission_Result__Thirdparty_Worker_Compensation_Transmission_Status_Type__thirdparty_worker_compensatio | thirdparty_worker_compensation_transmission_status_type_KEY | Insurepay_Payroll_Transmission_Result |
FK_Insurepay_Setup_Transmission_Result__Thirdparty_Worker_Compensation_Transmission_Status_Type__thirdparty_worker_compensation_ | thirdparty_worker_compensation_transmission_status_type_KEY | Insurepay_Setup_Transmission_Result |