IM Relationship Resolution Information Center, Version 4.2

DQM function 140: Number format check

DQM function 140 compares the number of characters and the mask format of the value of a UMF number value tag to a configured number type.

DQM Rule 140 first determines if the UMF number value tag contains the correct number of valid characters.

This function also creates a number hash needed for entity resolution.

If you configure the DQM rule to correct the data, the value of the UMF tag is formatted based on the configuration of each number type as configured in the console. All non-alphanumeric values are removed from the UMF tag value, and the number type mask format is applied to the base value, adding missing symbols and default characters. If the correction procedure is not configured, the function logs an exception to the configured error log and does not load the invalid value.

Parameters

Ignore Unmatched Formatting
Stop formatting after the last alpha/numeric value.
Y
The function stops formatting after the last alpha/numeric value in UMF tag.
For example, if the format of the number type in question is (###) ### - #### and the incoming record value is 5551212, 5551212 becomes 555-1212.
N
The function continues with fill characters and mask symbols after the last alpha numeric value in the UMF tag.
For example, if the format of the number type in question is (###) ### - ####, and the incoming record value is 5551212, 5551212 becomes ( ) 555-1212.

Exception codes

Exception Code Description Severity*
-2 The number value failed the required length check. 3
-1 The number type was not valid.. 3
2 The current number value was blank or zero. 2


Feedback

Last updated: 2009