Table containing client specific InsurePay consent information. |
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. |