In the DDM instance of Tide, during Transformation, Tide applies a series of Schema validation rules to submitted data. If these rules are breached a Warning will appear and erroneous data is flagged. You may continue with processing or delete the Bordereau and correct the data.
Schema Validation Rules
These rules are applied to all data processing. The Error Name is the title of the error screen where any validation errors are presented.
Error Name |
Bordereaux Type |
Gross Premium must be equal to the sum of Coverholder Commission and Net Premium to Broker |
Risk and Premium |
Net Premium to Broker must be equal to the sum of Brokerage and Final Net Premium |
Risk and Premium |
Risk Expiry Date cannot be before Risk Inception Date |
Risk and Premium |
Brokerage cannot be positive and Gross Premium be zero |
Risk and Premium |
Coverholder Commission cannot be positive and Gross Premium be zero |
Risk and Premium |
Brokerage cannot be positive and Gross Premium be negative |
Risk and Premium |
Brokerage cannot be negative and Gross Premium be positive |
Risk and Premium |
Coverholder Commission cannot be positive and Gross Premium be negative |
Risk and Premium |
Coverholder Commission cannot be negative and Gross Premium be positive |
Risk and Premium |
Net Premium to Broker cannot be greater than Gross Premium |
Risk and Premium |
Final Net Premium cannot be greater than Net Premium to Broker |
Risk and Premium |
Other Fees cannot be less than zero |
Risk and Premium |
Current position of Gross Premium cannot be negative |
Risk and Premium |
Producing Brokerage cannot be positive and Gross Premium be zero |
Risk and Premium |
Producing Brokerage cannot be positive and Gross Premium be negative |
Risk and Premium |
Producing Brokerage cannot be negative and Gross Premium be positive |
Risk and Premium |
Total Incurred must be equal to the sum of Total Paid and Total Reserve |
Claims |
Total Incurred must be equal to the sum of Indemnity Incurred and Fees Incurred |
Claims |
Total Paid must be equal to the sum of Indemnity Paid and Fees Paid |
Claims |
Total Reserve must be equal to the sum of Indemnity Reserve and Fees Reserve |
Claims |
Fees (Total Incurred) must be equal to the sum of Fees (Paid) and Fees (Reserve) |
Claims |
Indemnity (Total Incurred) must be equal to the sum of Indemnity (Paid) and Indemnity (Reserve) |
Claims |
Risk Expiry Date cannot be before Risk Inception Date |
Claims |
Total Incurred cannot be less than zero |
Claims |
Total Paid cannot be less than zero |
Claims |
Indemnity (Paid) cannot be less than zero |
Claims |
Fees (Paid) cannot be less than zero |
Claims |
Indemnity (Total Incurred) cannot be less than zero |
Claims |
Fees (Reserve) cannot be less than zero |
Claims |
Indemnity (Reserve) cannot be less than zero |
Claims |
Fees (Total Incurred) cannot be less than zero |
Claims |
Total Reserve cannot be less than zero |
Claims |