Table: dbo.Thirdparty_Worker_Compensation_Transmission_Status_Type
Table containing third party worker compensation transmission status types.
Columns
NameTypeConstraintsDescription
thirdparty_worker_compensation_transmission_status_type_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (100)NOT NULL
Primary key
NameColumnsDescription
PK_Thirdparty_Worker_Compensation_Transmission_Status_Typethirdparty_worker_compensation_transmission_status_type_KEY
Unique constraints
NameColumnsDescription
UK_Thirdparty_Worker_Compensation_Transmission_Status_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_XactPay_Payroll_Transmission_Result__Thirdparty_Worker_Compensation_Transmission_Status_Type__thirdparty_worker_compensation_thirdparty_worker_compensation_transmission_status_type_KEYXactPay_Payroll_Transmission_Result
FK_XactPay_Setup_Transmission_Result__Thirdparty_Worker_Compensation_Transmission_Status_Type__thirdparty_worker_compensation_trthirdparty_worker_compensation_transmission_status_type_KEYXactPay_Setup_Transmission_Result
FK_Insurepay_Payroll_Transmission_Result__Thirdparty_Worker_Compensation_Transmission_Status_Type__thirdparty_worker_compensatiothirdparty_worker_compensation_transmission_status_type_KEYInsurepay_Payroll_Transmission_Result
FK_Insurepay_Setup_Transmission_Result__Thirdparty_Worker_Compensation_Transmission_Status_Type__thirdparty_worker_compensation_thirdparty_worker_compensation_transmission_status_type_KEYInsurepay_Setup_Transmission_Result

Schema diagram