Functional Description
The purpose of this Named ER is to scrub any non numeric char (eg special characters) off the input tax id. It returns the scrubbed tax
id and the length of the scrubbed tax id.
Setup Notes
Technical Specifications
Parameters
Data Item Data Structure DescriptionI/ORequired TableNotes
SSNszUnScrubIdIR
DS20szScrubTaxIdOThe scrub tax id contains only numeric
char
MATH01mnTaxIdLengthOActual Length of the Scrub Tax Id
Related Tables
Table Table Description
Processing
Starting from the 1st char of the unscrubb tax id to the last char of the unscrub tax id,
On each char, convert the char to numeric value
If the numeric value >=0 and <=9
Concatenate the character to the szScrubTaxId
Endif
After all characters of the unscrub tax id are looked at, the szScrubTaxId will have only numeric characters
mnTaxIdLength = length (szScrubTaxID)
^
DN0800014 - Scrub Tax ID
| Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
|---|---|---|---|---|
| szUnscrubTaxID | SSN | char | NONE | NONE |
A number that indicates the tax ID. In the United States, the tax ID is the social security number. In Canada, it is the social insurance number.
| ||||
| szScrubTaxID | DS20 | char | NONE | NONE |
A 20 character generic description. | ||||
| mnTaxIDLength | MATH01 | MATH_NUMERIC | NONE | NONE |
- - - Good Performance Low Value. | ||||
| None |
| None |