Modifying Name Parser User-Defined Tables

Attention: The Name Parser stage is deprecated and may not be supported in future releases. Use Open Name Parser for parsing names.

You can add, modify, and delete values in the Name Parser tables to customize them for your unique business environment.

Name Parser's user-defined tables are XML files located by default in the <Drive>:\Program Files\Precisely\Spectrum\server\modules\parser\data folder. Spectrum Technology Platform includes the following user-defined tables:

UserAccountDescriptions.xml

Table 1. UserAccountDescriptions.xml Columns

Column Name

Description / Valid Values

LookupValue

A lookup term commonly found in an Account Description. Any single-word text. Case insensitive.

Example entry:


<table-data>
    <deleted-entries delimiter-character="|">
        <deleted-entry-group> 
            <![CDATA[
                LookupValue
                ART
                AND
            ]]>
        </deleted-entry-group>
    </deleted-entries>
    <added-entries delimiter-character="|">
        <![CDATA[
            LookupValue
            A/C
            ACCOUNT
            EXP
        ]]>
    </added-entries>
</table-data>

UserCompanyPrepositions.xml

Table 2. UserCompanyPrepositions.xml Columns

Column Name

Description / Valid Values

LookupValue

Any preposition (for example, "of" or "on") commonly found in company names. Any single-word text. Case insensitive.

Example entry:


<table-data>
    <deleted-entries delimiter-character="|"> 
        <deleted-entry-group> 
            <![CDATA[ 
                LookupValue 
                AROUND 
                NEAR 
            ]]> 
        </deleted-entry-group> 
    </deleted-entries> 
    <added-entries delimiter-character="|"> 
        <![CDATA[ 
            LookupValue 
            ABOUT 
            AFTER 
            ACROSS 
        ]]> 
    </added-entries> 
</table-data>

UserCompanySuffixes.xml

Table 3. UserCompanySuffixes.xml Columns

Column Name

Description / Valid Values

LookupValue

Any suffix commonly found in company names. Examples include "Inc." and "Co." Any single-word text. Case insensitive.

Example entry:


<table-data>
    <deleted-entries delimiter-character="|"> 
        <deleted-entry-group> 
            <![CDATA[ 
                LookupValue 
                SANDY 
                CLUE 
            ]]> 
        </deleted-entry-group> 
    </deleted-entries> 
    <added-entries delimiter-character="|"> 
        <![CDATA[ 
            LookupValue 
            LTD 
            LLC 
            CO 
            INC 
        ]]> 
    </added-entries> 
</table-data>

UserCompanyTerms.xml

Table 4. UserCompanyTerms.xml Columns

Column Name

Description / Valid Values

LookupValue

Any term commonly found in a company name. Any single-word text. Case insensitive.

Example entry:


<table-data>
    <deleted-entries delimiter-character="|"> 
        <deleted-entry-group> 
            <![CDATA[ 
                LookupValue 
                MARY 
                BLUE 
            ]]> 
        </deleted-entry-group> 
    </deleted-entries> 
    <added-entries delimiter-character="|"> 
        <![CDATA[ 
            LookupValue 
            ARC 
            ARCADE 
            ASSEMBLY 
            ARIZONA 
        ]]>
    </added-entries> 
</table-data>

UserCompoundFirstNames.xml

This table contains user-defined compound first names. Compound names are names that consist of two words.

Table 5. UserCompoundFirstNames.xml Columns

Column Name

Description / Valid Values

FirstName

The compound first name. Maximum of two words. Case insensitive.

Culture

The culture in which this FirstName/Gender combination applies. You may use any of the values that are valid in the GenderDeterminationSource input field. For more information, see Input.

Gender

The gender most commonly associated with this FirstName/Culture combination. One of the following:

M
The name is a male name.
F
The name is a female name.
A
Ambiguous. The name can be either male or female.
U
Unknown. The gender of this name is not known. Unknown is assumed if this field is left blank.

Frequency

Not used in this release. You may leave this column blank.

Example entry:


<table-data>
    <deleted-entries delimiter-character="|"> 
        <deleted-entry-group> 
            <![CDATA[ 
                    FirstName 
                    ANN MARIE 
                    BILLY JOE 
            ]]> 
        </deleted-entry-group> 
        <deleted-entry-group> 
            <![CDATA[ 
                FirstName|Frequency 
                KAREN SUE|0.126 
                BILLY JOE|0.421 
            ]]> 
        </deleted-entry-group> 
        <deleted-entry-group> 
            <![CDATA[ 
                FirstName|Gender|Culture 
                JEAN ANN|M|DEFAULT 
                JEAN CLUADE|F|FRENCH 
            ]]> 
        </deleted-entry-group> 
    </deleted-entries> 
    <added-entries delimiter-character="|"> 
        <![CDATA[ 
            FirstName|Gender|Culture 
            JOHN Henry|M|DEFAULT 
            A'SHA A'MAR|F|ARABIC 
            BILLY JO|A|DEFAULT 
        ]]> 
    </added-entries> 
</table-data>

UserConjunctions.xml

This table contains a list of user-defined conjunctions, such as "and", "or", or "&".

Table 6. UserConjunctions.xml Columns

Column Name

Description / Valid Values

LookupValue

Any conjunction. Must be a single word. Case insensitive.

Example entries:


<table-data>
    <deleted-entries delimiter-character="|"> 
        <deleted-entry-group> 
            <![CDATA[ 
                LookupValue 
                FIND 
                CARE 
                % 
            ]]> 
        </deleted-entry-group> 
    </deleted-entries> 
    <added-entries delimiter-character="|"> 
        <![CDATA[ 
            LookupValue 
            & 
            AND 
            OR 
        ]]> 
    </added-entries> 
</table-data>

UserFirstNames.xml

Table 7. UserFirstNames.xml Columns

Column Name

Description / Valid Values

FirstName

The first name described by this table row. Case insensitive.

Gender

The gender most commonly associated with this FirstName/Culture combination. One of the following:

M
The name is a male name.
F
The name is a female name.
A
Ambiguous. The name can be either male or female.
U
Unknown. The gender of this name is not known. Unknown is assumed if this field is left blank.

Culture

The culture in which this FirstName/Gender combination applies. You may use any of the values that are valid in the GenderDeterminationSource input field. For more information, see Input.

Example entry:


<table-data>
    <deleted-entries delimiter-character="|"> 
        <deleted-entry-group> 
            <![CDATA[ 
                FirstName 
                AADEL 
                AADIL 
            ]]> 
        </deleted-entry-group> 
        <deleted-entry-group> 
            <![CDATA[ 
                FirstName 
                A'SACE 
                A'BOCKETT 
            ]]> 
        </deleted-entry-group> 
        <deleted-entry-group> 
            <![CDATA[ 
                FirstName|Gender|Culture 
                ALII|M|DEFAULT 
                AISHA|F|ARABIC 
            ]]> 
        </deleted-entry-group> 
        <deleted-entry-group> 
            <![CDATA[ 
                FirstName|Gender 
                JOHE|M 
            ]]> 
        </deleted-entry-group> 
    </deleted-entries> 
    <added-entries delimiter-character="|"> 
        <![CDATA[ 
            FirstName|Gender|Culture 
            JOHE|M|DEFAULT 
            A'SHAN|F|ARABIC 
        ]]> 
    </added-entries> 
</table-data>

UserGeneralSuffixes.xml

This table contains a list of user-defined suffixes used in personal names that are not maturity suffixes, such as "MD" or "PhD".

Table 8. UserGeneralSuffixes.xml Columns

Column Name

Description / Valid Values

LookupValue

Any suffix that is frequently applied to personal names and is not a maturity suffix. Must be a single word. Case insensitive.

Example entry:


<table-data>
    <deleted-entries delimiter-character="|"> 
        <deleted-entry-group> 
            <![CDATA[ 
                LookupValue 
                AND 
                WILL 
                TUNA 
            ]]> 
        </deleted-entry-group> 
    </deleted-entries> 
    <added-entries delimiter-character="|"> 
        <![CDATA[ 
            LookupValue 
            ACCOUNTANT 
            ATTORNEY 
            ANALYST 
            ASSISTANT 
        ]]> 
    </added-entries> 
</table-data>

UserLastNamePrefixes.xml

This table contains a list of user-defined prefixes that occur in a person's last name such as "Van", "De", or "La".

Table 9. UserLastNamePrefixes.xml Columns

Column Name

Description / Valid Values

LookupValue

Any prefix that occurs as part of an individual's last name. Any single-word text. Case insensitive.

Example entry:


<table-data>
    <deleted-entries delimiter-character="|"> 
        <deleted-entry-group> 
            <![CDATA[ 
                LookupValue 
                DO 
                RUN 
                ANIMAL 
            ]]> 
        </deleted-entry-group> 
    </deleted-entries> 
    <added-entries delimiter-character="|"> 
        <![CDATA[ 
            LookupValue 
            D' 
            DA 
            DEN 
            DEL 
        ]]> 
    </added-entries> 
</table-data>

UserLastNames.xml

Table 10. UserLastNames.xml Columns

Column Name

Description / Valid Values

LastName

The last name described by this table row. Case insensitive.

Gender

The gender most commonly associated with this FirstName/Culture combination. One of the following:

M
The name is a male name.
F
The name is a female name.
A
Ambiguous. The name can be either male or female.
U
Unknown. The gender of this name is not known. Unknown is assumed if this field is left blank.

Culture

The culture in which this FirstName/Gender combination applies. You may use any of the values that are valid in the GenderDeterminationSource input field. For more information, see Input.

Example entry:


<table-data>
    <deleted-entries delimiter-character="|"> 
        <deleted-entry-group> 
            <![CDATA[ 
                LastName 
                Rusod 
                AADIL 
            ]]> 
        </deleted-entry-group> 
        <deleted-entry-group> 
            <![CDATA[ 
                LastName 
                KAASEEY 
                JOIEN 
            ]]> 
        </deleted-entry-group> 
    </deleted-entries> 
    <added-entries delimiter-character="|"> 
        <![CDATA[ 
            LastName|Culture|Gender 
            SMITH|ENGLISH|A 
            WILSON|ENGLISH|A 
            JONES|ENGLISH|A 
        ]]> 
    </added-entries> 
</table-data>

UserMaturitySuffixes.xml

This table contains user-defined generational suffixes used in a person's name, such as "Jr." or "Sr.".

Table 11. UserMaturitySuffixes.xml Columns

Column Name

Description / Valid Values

LookupValue

A generational suffix used in personal names. Any single-word text. Case insensitive.

Example entry:


<table-data>
    <deleted-entries delimiter-character="|"> 
        <deleted-entry-group> 
            <![CDATA[ 
                LookupValue 
                I 
                V 
                18 
                VI 
            ]]> 
        </deleted-entry-group> 
    </deleted-entries> 
    <added-entries delimiter-character="|"> 
        <![CDATA[ 
            LookupValue 
            I 
            II 
            III 
        ]]> 
    </added-entries> 
</table-data>

UserTitles.xml

This table contains user-defined titles used in a person's name, such as "Mr." or "Ms."

Table 12. UserTitles.xml Columns

Column Name

Description / Valid Values

LookupValue

A title used in personal names. Any single-word text. Case insensitive.

Gender

The gender most commonly associated with this title. One of the following:

M
The name is a male name.
F
The name is a female name.
A
Ambiguous. The name can be either male or female.
U
Unknown. The gender of this name is not known. Unknown is assumed if this field is left blank.

Example entry:


<table-data>
    <deleted-entries delimiter-character="|"> 
        <deleted-entry-group> 
            <![CDATA[ 
                LookupValue 
                Belt 
                Friend 
                Thursday 
                Red 
            ]]> 
        </deleted-entry-group> 
    </deleted-entries> 
    <added-entries delimiter-character="|"> 
        <![CDATA[ 
            LookupValue|Gender 
            Mrs|F 
            Mr|M 
            Most|F 
        ]]> 
    </added-entries> 
</table-data>

Sample User-Defined Table

The figure below shows a sample UserFirstNames.xml table and the syntax to use when modifying user-defined tables.


<table-data>
    <deleted-entries delimiter-character="|"> 
        <deleted-entry-group> 
            <![CDATA[ 
                FirstName 
                AADEL 
                AADIL 
            ]]> 
        </deleted-entry-group> 
        <deleted-entry-group> 
            <![CDATA[ 
                FirstName|Frequency 
                A'SACE|0.126 
                A'BECKETT|0.421 
            ]]> 
        </deleted-entry-group> 
        <deleted-entry-group> 
            <![CDATA[ 
                FirstName|Gender|Culture|VariantGroup 
                ALI|M|DEFAULT|GROUP88 
                AISHA|F|ARABIC|GROUP43 
            ]]> 
        </deleted-entry-group> 
        <deleted-entry-group> 
            <![CDATA[ 
                FirstName|Gender 
                JOHN|M 
            ]]> 
        </deleted-entry-group> 
    </deleted-entries> 
    <added-entries delimiter-character="|"> 
        <![CDATA[ 
            FirstName|Gender|Culture 
            JOHN|M|DEFAULT 
            A'SHA|F|ARABIC 
            JAMES|M|DEFAULT 
        ]]> 
    </added-entries> 
</table-data>