| 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 | |