IM Relationship Resolution Information Center, Version 4.2

DQM function 135: Format check

DQM function 135 compares the value of the UMF tag, if it is not empty, to a configured character mask format. This function allows the system to format values that need to be formatted as part of a pre-process function.

If you configure the DQM rule to correct the data, and if the function is unable to validate the value of the UMF tag against the mask format parameter, it replaces the value of the UMF tag with the replacement value parameter. If the correction procedure is not configured to correct an error, the function logs an exception to the configured error log and does not load the invalid value.

Parameters

Mask Format
The character mask constructed from alpha (A-Z), numeric (0-9), and/or symbols ( "-","." , etc.), used to validate the value of the UMF tag. For example:
  • "9-999-999-9999" (Phone) matches "1-702-555-1212"
  • "999-99-9999" (SSN) matches "555-55-5555"
  • "AA9999999" matches "NY1243534"
Replacement Value
The default replacement value if the value of the UMF tag cannot be validated against the mask format parameter. For example, XXX0000000. If the value of the UMF tag does not match the mask format parameter, this value replaces the non matching value.

Exception codes

Exception Code Description Severity*
-1 The value of the UMF tag does not validate against mask, but the rule is not configured to perform correction procedures. 3
1 The value of the UMF tag does not validate against mask, therefore the default value applied. 2


Feedback

Last updated: 2009