Table: dbo.Insurepay_Setup_Transmission
Table containing client specific InsurePay setup information.
Columns
NameTypeConstraintsDescription
insurepay_setup_transmission_KEYint (4)NOT NULLPrimary key for this table.
client_KEYint (4)NOT NULLForeign key for this table.The associated InsurePay_Client key.
number_of_employeeint (4)NOT NULLnumber of employee included in the Insurepay setup file.
setup_data_xmlnvarchar (-1)NOT NULLinsurepay setup xml data for the client.
Primary key
NameColumnsDescription
PK_Insurepay_Setup_Transmissioninsurepay_setup_transmission_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Insurepay_Setup_Transmission__Insurepay_Client__client_KEYclient_KEYInsurepay_Client (client_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Insurepay_Setup_Transmission_Result__Insurepay_Setup_Transmission__insurepay_setup_transmission_KEYinsurepay_setup_transmission_KEYInsurepay_Setup_Transmission_Result

Schema diagram