UDS Data Mapper Validation Rules

This page outlines the validation rules used during record processing by the UDS Data Mapper to ensure data quality. Some of these rules are already implemented, while others are slated for an upcoming release. Each rule is designed to verify specific attributes or relationships within the data.

Implemented Rules: These rules are active in the system and are automatically applied to validate records as they are processed by the UDS Data Mapper.For .txt files (or UDS files), specific formats are expected for certain fields:

• Dates: Must adhere to a predefined format (e.g., YYYYMMDD).
• Currency: Must follow strict guidelines for formatting according to the UDS Manual, such as including implied decimals or positive/negative indicators.
• Agent Commission Rate: Must be formatted as XXXXX to ensure proper ingestion and validation with the implied decimal leaving 2 digits after the decimal.

For .csv files, the system offers more flexibility:

• Dates: Can be provided in various common formats (e.g., MM/DD/YYYY, YYYY-MM-DD).
• Currency: Accepts values in any of the formats specified in UDM16 below.

By enforcing these rules, the system ensures compatibility with both legacy .txt UDS files and modern .csv files while maintaining accurate data validation.

In-Development Rules: These rules are being actively developed and will be included in a future release. They cover additional business logic, complex data relationships, and more advanced validation scenarios.

If you have ideas for new validation rules that could improve the system, please feel free to email us at support@guarantysupport.com. We welcome your suggestions and feedback to help improve the UDS data validation process.

This page will be updated as new validation rules are added or existing ones are modified to reflect the latest changes in the system.

Implemented Rules

Duplicate Entries

UDM1 – Duplicate Entries for A

• Description: Duplicate detected for record type A.
• Unique Fields:
• NAIC Number
• Insolvent Company Claim Number
• Coverage Code
• Claimant Number

UDM2 – Duplicate Entries for B

• Description: Duplicate detected for record type B.
• Unique Fields:
• Policy Number
• Receiver Claim Number
• Coverage Code
• Claimant Number
• Policy Effective Date
• Transaction Code

UDM3 – Duplicate Entries for E

• Description: Duplicate detected for record type E.
• Unique Fields:
• Insolvent Company Claim Number
• Claimant Number
• Coverage Code

UDM4 – Duplicate Entries for F

• Description: Duplicate detected for record type F.
• Unique Fields:
• Insolvent Company Claim Number
• Claimant Number
• Note ID Number
• Note Line Sequence Number
• Entry Date

UDM5 – Duplicate Entries for G

• Description: Duplicate detected for record type G.
• Unique Fields:
• Insolvent Company Claim Number
• Claimant Number
• Coverage Code
• Transaction Code
• Check Amount
• Check Number

UDM6 – Duplicate Entries for I

• Description: Duplicate detected for record type I.
• Unique Fields:
• Insolvent Company Claim Number
• Claimant Number
• Document Path
• Document File Name

UDM7 – Duplicate Entries for M

• Description: Duplicate detected for record type M.
• Unique Fields:
• Insolvent Company Claim Number
• Claimant Number
• CMS

Date and Time Errors

UDM8 – Date Error

• Description: The date is not converting correctly. Acceptable formats are as follows:

• Affected Fields:
• A Record – Date of Loss, Policy Effective Date, Policy Expiration Date, Claim Report Date, Claimant Birthday
• B Record – Date of Loss, Policy Effective Date, Policy Expiration Date, Cancellation Date
• E Record – Date of Loss, Policy Effective Date, Policy Expiration Date, Claim Report Date, Claimant Birthday
• F Record – Entry Date
• G Record – Check Date, Service or Benefit from Date, Service or Benefit to Date
• I Record – Capture Date

UDM9 – Non Leap Year

• Description: The date provided is not valid. It may be a leap year day but not within a valid leap year.
• Affected Fields:
• A Record – Date of Loss, Policy Effective Date, Policy Expiration Date, Claim Report Date, Claimant Birthday
• B Record – Date of Loss, Policy Effective Date, Policy Expiration Date, Cancellation Date
• E Record – Date of Loss, Policy Effective Date, Policy Expiration Date, Claim Report Date, Claimant Birthday
• F Record – Entry Date
• G Record – Check Date, Service or Benefit from Date, Service or Benefit to Date
• I Record – Capture Date

UDM10 – UDS Time Error

• Description: The time entered is not in UDS time format (HHMMSS).
• Affected Fields:
• I Record – Capture Time

UDM11 – Cancellation Date Error

• Description: The Cancellation Date must be between the Policy Effective Date and Policy Expiration Date, inclusively.
• Affected Fields:
• B Record – Cancellation Date

UDM12 – Date of Loss Error

• Description: Date of Loss must be later than the Policy Effective Date.
• Affected Fields:
• A Record – Date of Loss, Policy Effective Date, Policy Expiration Date
• B Record – Date of Loss, Policy Effective Date, Policy Expiration Date
• E Record – Date of Loss, Policy Effective Date, Policy Expiration Date

UDM13 – Policy Expiration Date Error

• Description: Policy Expiration Date must be greater than or equal to the Policy Effective Date.
• Affected Fields:
• A Record – Policy Expiration Date
• B Record – Policy Expiration Date
• E Record – Policy Expiration Date

UDM14 – Policy Effective Date Missing

• Description: A Policy Expiration Date was provided without a Policy Effective Date.
• Affected Fields:
• A Record – Policy Effective Date
• B Record – Policy Effective Date
• E Record – Policy Effective Date

UDM15 – Service or Benefit To Date before Start Date

• Description: The Service or Benefit To Date must be after the Service or Benefit Start Date.
• Affected Fields:
• G Record – Service or Benefit from Date, Service or Benefit to Date

Currency and Numeric Errors

UDM16 – Currency Error

Note: Although not specified in the UDS Manual, + characters are allowed in the rightmost positions of the fields Total Written Premium Policy and Total Inforce Policy Premium for the UDS B record .txt ingestion process to accommodate certain legacy systems.

• Description: The currency are not converting correctly. Acceptable formats are as follows:

• Affected Fields:
• A Record – Transaction Amount
• B Record – Total Written Premium Policy, Total Inforce Policy Premium, Return Premium Amount, Unpaid Premium Amount
• E Record – Transaction Amount
• G Record – Check Amount

UDM20 – Parentheses Where Minus

• Description: A parentheses was found in the transaction amount. Transaction amount cannot be negative. Please update the data.
• Affected Fields:
• A Record – Transaction Amount
• E Record – Transaction Amount

UDM21 – Minus Where Parentheses

• Description: A minus sign was found in the transaction amount. Transaction amount cannot be negative. Please update the data.
• Affected Fields:
• A Record – Transaction Amount
• E Record – Transaction Amount

UDM24 – Claimant Number Zero

• Description: Claimant Numbers cannot be 0.
• Affected Fields:
• A Record – Claimant Number
• B Record – Claimant Number
• E Record – Claimant Number
• G Record – Claimant Number

UDM25 – Claim Number Not Numeric

• Description: The claim number is not a number. If this value appears in scientific notation, it is likely due to conversion by a spreadsheet program such as MS Excel.
• Affected Fields
• All Record Types – Insolvent Company Claim Number

UDM26 – Integer Error

• Description: The field must be a number.
• Affected Fields:
• All Record Types – Claimant Number

UDM27 – Length Error

• Description: The data exceeds the maximum length for this UDS field.
• Affected Fields
• All

Validation and Formatting Errors

UDM28 – Strip Error

• Description: There was a problem stripping whitespace from the beginning and end of the data element.
• Affected Fields
• All

UDM29 – Leading Whitespace Error

• Description: Leading whitespace was detected in the field. This field should be left justified.
• Affected Fields:
• A Record – Insured Last Name, Insured First Name, Insured Address, Insured City, Claimant Last Name, Claimant First Name, Claimant Address, Claimant City
• B Record – Insured Last Name, Insured First Name, Insured Address, Insured City, Claimant Last Name, Claimant First Name, Claimant Address, Claimant City
• E Record – Insured Last Name, Insured First Name, Insured Address, Insured City, Claimant Last Name, Claimant First Name, Claimant Address, Claimant City
• G Record – Payee Last Name, Payee First Name, Payment Comment
• I Record – Doc Descriptor or Comment

UDM31 – SSN Length Error

• Description: SSN and/or EIN (Federal ID) must be 9 digits long.
• Affected Fields:
• A Record – Claimant ID Number
• B Record – Claimant ID Number, Payee ID Number
• E Record – Claimant ID Number
• G Record – Payee ID Number

UDM32 – Zip Code Error

• Description: Zip codes must be either 5 or 9 digits long (55555 or 55555-6789).
• Affected Fields:
• A Record – Insured Zip, Claimant Zip
• B Record – Insured Zip, Claimant Zip
• E Record – Insured Zip, Claimant Zip

UDM33 – Phone Index Error

• Description: There was an issue converting this to a 10-digit phone number.
• Affected Fields:
• A Record – Employer Work Phone Number
• B Record – Claimant Phone Number
• E Record – Employer Work Phone Number

UDM34 – Check Number Not Alphanumeric

• Description: This field must be alphanumeric (only numbers, letters, and spaces are allowed).
• Affected Fields:
• G Record – Check Number

UDM36 – Yes/No/Unsure Error

• Description: The field must be either Y, N or U.
• Affected Fields:
• A Record – Suit Indictor, Second Injury Fund Indictor, Aggregate Policy Indictor, Deductible Policy Indicator, WCIO Vocational Rehab Indicator
• E Record – Suit Indictor, Second Injury Fund Indictor, Aggregate Policy Indictor, Deductible Policy Indicator, WCIO Vocational Rehab Indicator

UDM37 – Yes/No Error

• Description: The field must be either Y or N.
• Affected Fields:
• A Record – Repetitive Payment Indicator
• B Record – Final Audit Indicator
• E Record – Repetitive Payment Indicator

Coverage Code and Location Errors

UDM38 – Coverage Code Error

• Description: The coverage code is not valid.
• Affected Fields:
• A Record – Coverage Code
• B Record – Coverage Code
• E Record – Coverage Code
• G Record – Coverage Code

UDM40 – File Location State Error

• Description: The file location state is not a valid Guaranty Fund location state.
• Affected Fields:
• A Record – File Location State
• B Record – File Location State
• E Record – File Location State
• MRecord – File Location State

UDM41 – File Location Code Error

• Description: The file location code is not a valid Guaranty Fund location code.
• Affected Fields:
• A Record – File Location Code
• B Record – File Location Code
• E Record – File Location Code
• MRecord – File Location Code

UDM43 – File Location State/Code Error

• Description: The state and/or location code provided is not valid.
• Affected Fields:
• A Record – File Location State, File Location Code
• B Record – File Location State, File Location Code
• E Record – File Location State, File Location Code
• MRecord – File Location State, File Location Code

Transaction Code Errors

UDM44 – Transaction Code A

• Description: This value must be 100.
• Affected Fields:
• A Record – Transaction Code

UDM45 – Transaction Code B

• Description: This value must be one of 800, 815, 825, or 835.
• Affected Fields:
• B Record – Transaction Code

UDM46 – Transaction Code G

• Description: This value must be one of 310, 410, 320, 420, or 820.
• Affected Fields:
• G Record – Transaction Code

UDM47 – Final Audit Indicator Error

• Description: The Final Audit Indicator must be ‘Y’ when Transaction Code is 800. Must be ‘N’ when Transaction code is 815
• Affected Fields:
• B Record – Final Audit Indicator

Validation and Logic Errors

UDM48 – Recovery Indicator Code Error

• Description: This value must be one of 0-9 or R-Z.
• Affected Fields:
• A Record – Recovery Indicator Code
• E Record – Recovery Indicator Code

UDM49 – Cancellation Code Error

• Description: This value must be one of 1, 2, 3, 4, 5, or 9.
• Affected Fields:
• B Record – Cancellation Code

UDM53 – Surety Error

• Description: The coverage code indicates a surety claim, which is not covered by the provided state.
• Affected Fields:
• A Record – Coverage Code
• B Record – Coverage Code
• E Record – Coverage Code
• G Record – Coverage Code

I Record Image Errors

UDM54 – Image Location Not Found

• Description: There is no file or image located at the provided path.
• Affected Fields:
• I Record – Document File Name, Document Path

UDM55 – File Type Not Alphabetic

• Description: This field must be alphabetic (only letters are allowed).
• Affected Fields:
• I Record – File Type

UDM56 – Document Path Error

• Description: This value must end with a forward slash (/).
• Affected Fields:
• I Record – Document Path

Generic and Other Errors

UDM57 – Agents Commission Error

• Description: Agents Commission Error must be in format XXX.XX.
• Affected Fields:
• B Record – Agents Commission Rate

Misc Rules

UDM39 – Invalid Coverage Code for Insolvency Company

• Description: Coverage Code must be a valid one for the given NAIC.
• Affected Fields:
• A Record – Coverage Code
• B Record – Coverage Code
• E Record – Coverage Code
• G Record – Coverage Code

UDM42 – Invalid File Location State/Code for Insolvency Company

• Description: Insolvent Companies should only be able to write claims for states/codes they reside over.
• Affected Fields:
• A Record – File Location State, File Location Code, NAIC Number
• B Record – File Location State, File Location Code, NAIC Number
• E Record – File Location State, File Location Code, NAIC Number
• MRecord – File Location State, File Location Code, NAIC Number

UDM50 – Address Invalid

• Description: Use some API to try to validate all parts of claimant and insured address.
• Affected Fields:
• A Record – Insured Last Name, Insured First Name, Insured Address, Insured City, Claimant Last Name, Claimant First Name, Claimant Address, Claimant City
• B Record – Insured Last Name, Insured First Name, Insured Address, Insured City, Claimant Last Name, Claimant First Name, Claimant Address, Claimant City
• E Record – Insured Last Name, Insured First Name, Insured Address, Insured City, Claimant Last Name, Claimant First Name, Claimant Address, Claimant City

UDM51 – Claimant and Insured Names

• Description: Claimant and Insured Names should match on the 00001 Claimant.
• Affected Fields:
• A Record – Claimant Last Name, Claimant First Name, Insured Last Name, Insured First Name, Claimant Number
• B Record – Claimant Last Name, Claimant First Name, Insured Last Name, Insured First Name, Claimant Number
• E Record – Claimant Last Name, Claimant First Name, Insured Last Name, Insured First Name, Claimant Number

UDM52 – Claimant Names Don’t Match

• Description: The Claimant Name should match the previously entered name for the given Claimant Number.
• Affected Fields:
• A Record – Claimant Last Name, Claimant First Name, Claimant Number
• B Record – Claimant Last Name, Claimant First Name, Claimant Number
• E Record – Claimant Last Name, Claimant First Name, Claimant Number

UDM60 – WCIO Injury Code Error

• Description: This value must be in the set of valid WCIO injury codes on page 102 of the UDS Claims Manual
• Affected Fields:
• A Record – WCIO Type of Injury

UDM61 – WCIO Part of Body Error

• Description: This value must be in the set of valid WCIO part of body codes on page 102 of the UDS Claims Manual
• Affected Fields:
• A Record – WCIO Part of Body

UDM62 – WCIO Nature of Injury Error

• Description: This value must be in the set of valid WCIO nature of injury codes on page 105 of the UDS Claims Manual
• Affected Fields:
• A Record – WCIO Nature of Injury

UDM63 – WCIO Cause of Injury Error

• Description: This value must be in the set of valid WCIO cause of injury codes on page 107 of the UDS Claims Manual
• Affected Fields:
• A Record – WCIO Cause of Injury

UDM64 – WCIO Act Error

• Description: This value must be in the set of valid WCIO act codes on page 110 of the UDS Claims Manual
• Affected Fields:
• A Record – WCIO Act

UDM65 – WCIO Type of Loss Error

• Description: This value must be in the set of valid WCIO type of loss codes on page 110 of the UDS Claims Manual
• Affected Fields:
• A Record – WCIO Type of Loss

UDM66 – WCIO Type of Recovery Error

• Description: This value must be in the set of valid WCIO type of recovery codes on page 110 of the UDS Claims Manual
• Affected Fields:
• A Record – WCIO Type of Recovery

UDM67 – WCIO Type of Coverage Error

• Description: This value must be in the set of valid WCIO type of coverage codes on page 110 of the UDS Claims Manual
• Affected Fields:
• A Record –WCIO Type of Coverage

UDM68 – WCIO Type of Settlement Error

• Description: This value must be in the set of valid WCIO type of settlement codes on page 111 of the UDS Claims Manual
• Affected Fields:
• A Record – WCIO Type of Settlement

UDM69 – Claimant ID Indicator Error

• Description: This value must be in the set of valid Claimant ID Indicator codes: ‘F’, ‘S’, or blank.
• Affected Fields:
• A Record – Claimant ID Indicator

UDM70 – Improper NAIC Error

• Description: This value must be in the set of valid NAIC codes for your given Liquidator.
• Affected Fields:
• A Record – NAIC Number
• B Record – NAIC Number
• E Record – NAIC Number

UDM71 – Missing A Record Error

• Description: This error occurs when an A Record is missing for the given claim number and claimant number.
• Affected Fields:
• F Record
• G Record
• I Record
• M Record

UDM72 – Invalid Billing Mode Error

• Description: This error occurs when the billing mode is not one of the valid options (‘A’, ‘D’, or ”).
• Affected Fields:
• B Record – Billing Mode