Table: dbo.Insurepay_Client
Table containing client specific InsurePay consent information.
Columns
Name | Type | Constraints | Description
client_KEY | int (4) | NOT NULL | Primary key and Foreign key for this table.
insurepay_client_name | nvarchar (150) | NOT NULL | insurepay client name.
policy_number | nvarchar (80) | NOT NULL | insurepay policy number for this client.
effective_date | smalldatetime (4) | NOT NULL | insurepay policy effective date.
expiration_date | smalldatetime (4) | NOT NULL | insurepay policy expiration date.
retrieve_date | smalldatetime (4) | NOT NULL | insurepay consent file retrieving date.
is_disabled_by_user | bit (1) | NOT NULL | This is a flag to indicate that user disabled the insurepay consent. 0 means user did not disable the insurepay consent, 1 means user disabled the insurepay consent.
ack_data_xml | nvarchar (-1) |  | The data from the acknowledgement file.

Primary key
Name | Columns | Description
PK_Insurepay_Client$client_KEY | client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Insurepay_Client__Client__client_KEY | client_KEY | Client (client_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Insurepay_Client_Class_Code__Insurepay_Client__client_KEY | client_KEY | Insurepay_Client_Class_Code |
FK_Insurepay_Setup_Transmission__Insurepay_Client__client_KEY | client_KEY | Insurepay_Setup_Transmission |
FK_Insurepay_Payroll_Transmission__Insurepay_Client__client_KEY | client_KEY | Insurepay_Payroll_Transmission |