Table: dbo.Insurepay_Client
Table containing client specific InsurePay consent information.
Columns
NameTypeConstraintsDescription
client_KEYint (4)NOT NULLPrimary key and Foreign key for this table.
insurepay_client_namenvarchar (150)NOT NULLinsurepay client name.
policy_numbernvarchar (80)NOT NULLinsurepay policy number for this client.
effective_datesmalldatetime (4)NOT NULLinsurepay policy effective date.
expiration_datesmalldatetime (4)NOT NULLinsurepay policy expiration date.
retrieve_datesmalldatetime (4)NOT NULLinsurepay consent file retrieving date.
is_disabled_by_userbit (1)NOT NULLThis 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_xmlnvarchar (-1)The data from the acknowledgement file.
Primary key
NameColumnsDescription
PK_Insurepay_Client$client_KEYclient_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Insurepay_Client__Client__client_KEYclient_KEYClient (client_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Insurepay_Client_Class_Code__Insurepay_Client__client_KEYclient_KEYInsurepay_Client_Class_Code
FK_Insurepay_Setup_Transmission__Insurepay_Client__client_KEYclient_KEYInsurepay_Setup_Transmission
FK_Insurepay_Payroll_Transmission__Insurepay_Client__client_KEYclient_KEYInsurepay_Payroll_Transmission

Schema diagram