Table: dbo.Insurepay_Setup_Transmission
Table containing client specific InsurePay setup information.
Columns
Name | Type | Constraints | Description
insurepay_setup_transmission_KEY | int (4) | NOT NULL | Primary key for this table.
client_KEY | int (4) | NOT NULL | Foreign key for this table.The associated InsurePay_Client key.
number_of_employee | int (4) | NOT NULL | number of employee included in the Insurepay setup file.
setup_data_xml | nvarchar (-1) | NOT NULL | insurepay setup xml data for the client.

Primary key
Name | Columns | Description
PK_Insurepay_Setup_Transmission | insurepay_setup_transmission_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Insurepay_Setup_Transmission__Insurepay_Client__client_KEY | client_KEY | Insurepay_Client (client_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Insurepay_Setup_Transmission_Result__Insurepay_Setup_Transmission__insurepay_setup_transmission_KEY | insurepay_setup_transmission_KEY | Insurepay_Setup_Transmission_Result |