Customer Data Parser Attributes - trillium_discovery - trillium_quality - Latest

Receives the parser return codes.

Reserved for future use.

Stores the original line pattern of ten (10) input address lines corresponding to the in_area definitions. The line pattern is determined through a combination of weighting the orientation of the line within the full address and the number and weight of the elements identified on the line.

Values are:

• A - Additional address data (for example, apartment information)
• B - Post office box
• E - Line containing the email address (must be by itself on line)
• G - Geography (city, state, and postal code)
• H - Hold line
• I - Ignore line
• M - Miscellaneous line
• N - Name
• R - Rural route
• S - Street address
• Y - Miscellaneous line with care-of
• Z - Miscellaneous street line
• ? - Unidentified line
• 2 - Consisting of secondary street info only

Contains the two-byte line type identification rule.

Values are:

• 00 - No Rule Applied
• 01 - User Wins
• 02 - First Is Name
• 03 - By Line Flag
• 04 - Has House number
• 05 - Has Zip Code
• 06 - Has Score
• 07 - Surrounded By Geography
• 08 - Identify Geography
• 09 - Same Last Name
• 10 - First Token Miscellaneous
• 11 - Surrounded By Street
• 12 - Matched Name Pattern
• 13 - Has Apostrophe
• 14 - Surrounded By Names
• 15 - Last Line Has Geography
• 16 - Connected To Previous
• 17 - Adjusted By Overall Context
• 18 - Miscellaneous Has Name Score
• 19 - Miscellaneous. Has Street Name
• 20 - Street Line Already Present

Stores the review code for names.

Stores the review code for streets.

Stores the review code for geography attributes.

Stores the review code for miscellaneous problems.

Stores the review codes for global review problems.

Contains the number of names (personal and business) on the input record. Value is a two-digit number from 00 to 10.

Contains the number of names (personal and business) on the output record.

Contains a categorization value based on the name types identified on the input record.

Values are:

• 1 - Retail or personal (for example, John Smith)
• 2 - Business (for example, Trillium Software)
• 3 - Reject (neither a business or personal name was identified)
• 4 - Mixed (business and individual name)

Stores the standard or user-defined category codes assigned to word definitions in the Word and Pattern tables. Note that concatenated codes from the overall address are terminated with a character.

Provides review group codes that guide you to areas for parser tuning.

Stores the input house value: for example, 5 Main Street.

Stores the original input house value.

Stores the shape of the input house values:

• N - Numeric
• A - Alpha
• -,/ - Special

Stores the input house type. Values are:

• N - Numeric
• – - Hyphenated
• U - Unusual
• S - Slash
• B - Blank
• A - Alpha

Stores input street title: for example, Main, Elm, and so forth.

Stores the original input street title.

Stores the first street type input: for example, Rd. or St.

Stores the original first street type input.

Stores second street type input.

Stores original second street type input.

Stores the input prefix street direction, such as N, S, W, E, and so forth. This attribute is populated depending on the position of the incoming direction. The pattern structure determines the final answer.

Values are:

• Direction BEFORE street - this attribute is populated.
• Direction AFTER street - pr_street_secondary_dir_recoded is populated.

Stores the original prefix street direction input.

Stores the post street direction input. This attribute will or will not be populated depending on the position of the incoming direction. The pattern structure determines the final answer.

Values are:

• Direction BEFORE street name - pr_street_primary_dir attribute is populated.
• Direction AFTER street name - this attribute is populated.

Stores the original post street direction input.

Stores the input route name: for example, Route, Rt. and so forth.

Stores the input route name.

Stores the input route value.

Stores the shape of the input route value.

Stores input route type. Values are:

• R - Route
• H - Highway

Stores the input box name.

Stores the original input box name.

Stores the input box value: for example, 6, 12, and so forth.

Stores the shape of the input box value. Values are:

• N - Numeric
• A - Alpha
• -,/ - Special

Stores the input box type. Values are:

• B - Box
• D - Drawer
• P - PO Box
• T - Pole

Stores the input box name.

Stores the original input box name.

Stores the input box value: for example, 6, 12, and so forth.

Stores the shape of the input box value. Values are:

• N - Numeric
• A - Alpha
• -,/ - Special

Stores the input box type. Values are:

• B - Box
• D - Drawer
• P - PO Box
• T - Pole

Stores the standardized name of an apartment, military, or business complex: for example, stores "Marvin" in "Marvin Gardens".

Stores the original input name of an apartment, military, or business complex.

Stores the standardized type of apartment, military, or business complex: for example, stores "Gardens" in "Marvin Gardens".

Stores the original type of apartment, military, or business complex.

Stores the standardized name of a secondary apartment, military, or business complex.

Stores the original input name of a secondary apartment, military, or business complex.

Stores the standardized type of a secondary apartment, military, or business complex.

Stores the original type of a secondary apartment, military, or business complex.

Stores the standardized name of a tertiary apartment, military, or business complex.

Stores the original input name of a tertiary apartment, military, or business complex.

Stores the standardized type of a tertiary apartment, military, or business complex.

Stores the original type of a tertiary apartment complex, military complex, or business complex.

Stores the standardized type of dwelling when pairs of two-part dwelling tokens exist. This attribute is filled left-to-right, top-to-bottom.

Stores original dwelling type when pairs of two-part dwelling tokens exist.

Stores the dwelling value when pairs of two-part dwelling tokens exist.

Stores the shape of the dwelling value when pairs of two-part dwelling tokens exist. Values are:

• N - Numeric
• A - Alpha
• -,/ - Special

Stores the dwelling type value when pairs of two-part dwelling tokens exist. Values are:

• A - Apartment
• F - Floor
• U - Unit
• L - Lot
• D - Department
• S - Site
• T - Suite
• ? - Record has a dwelling number, but no type.

Stores standardized type of the secondary dwelling when pairs of two-part dwelling tokens exist. Attribute is filled left-to-right, top-to-bottom.

Stores the original type of secondary dwelling when pairs of two-part dwelling token exist. No recodes are applied.

Stores the secondary dwelling value when pairs of two-part dwelling tokens exist.

Stores the shape of the secondary dwelling value when pairs of two-part dwelling tokens exist.

Stores the dwelling type value when pairs of two-part dwelling tokens exist. Values are:

• A - Apartment
• F - Floor
• U - Unit
• L - Lot
• D - Department
• S - Site
• T - Suite
• ? - Record has a dwelling number, but no type.

Stores standardized type of the tertiary dwelling when pairs of two-part dwelling tokens exist. Attribute is filled left-to-right, top-to-bottom.

Stores the original type of tertiary dwelling when pairs of two-part dwelling tokens exist.

Stores the tertiary dwelling value when pairs of two-part dwelling token exist.

Stores the shape of the tertiary dwelling value when pairs of two-part dwelling token exist.

Stores the tertiary dwelling type value when pairs of two-part dwelling token exist. Values are:

• A - Apartment
• F - Floor
• U - Unit
• L - Lot
• D - Department
• S - Site
• T - Suite
• ? - Record has a dwelling number, but no type.

Stores the miscellaneous address values.

Best number composite:

- If house # exists, use house number.

- If APT # exists, use APT number.

- If box # exists, use box number.

- If route # exists, use route number.

Number is used primarily in the relationship linking process.

Best street title composite:

- If street name exists, use it.

- If complex name/type exists, use it.

- If box name exists, use it.

Number is used primarily in the relationship linking process.

Stores the country name. Populated when a country attribute is found within address lines (not assigned by the program).

Stores the original country name.

Stores the neighborhood 1/locality name.

Stores original neighborhood 1/locality name. No recodes are applied.

Examples: Bo Barcelona, URB El Duque

This attribute is typically used in data from the UK and Latin America.

Stores the neighborhood 2/locality name.

Store the original neighborhood 2/locality name.

Stores the city name.

Stores the original city name.

Stores the city number. This value is assigned in the parser and is generally used as a primary look-up key in any postal matching process.

Examples : V22663, (ANNNNNN)

Stores the city status numeric that helps to determine the correct city name. Values are:

• 1 - Preferred mailing name
• 2 - Acceptable mailing name
• 9 - Unacceptable mailing name

Stores the long city name from the directory and displays the city and state abbreviations.

Stores the state, province, or county name.

Stores the original state, province, or county name.

Stores the state number.

Stores the input postal code.

Examples: 01821, 01879, M8X 2X3

Stores the shape of the input postal code (pr_postal_code) mask.

Stores the type of input postal code.

Stores the postal code found on the xxCITY.len/ben city table, for the unidentified city and state.

Receives the shape of the postal code identified by the CDP (pr_postal_code_dir) mask.

Contains codes assigned by the USPS, found in the USCITY.len/ben city table. Values are:

0 - Non-US record

4 - Box Code

5 - Special Military

8 - Non Unique

Other - Non-US record

Contains the country that the record is from.

1=United States (US)

2=Canada (CA)

3=United Kingdom (UK)

4=Other

5=Brazil (BZ)

6=Australia (AU)

7=Germany (DE)

8=Italy (IT)

Contains US postal finance code (and other future foreign postal info).

Contains US postal finance code (and other future foreign postal info) where X is a letter from A to J.

INPUT GEOGRAPHIC MATCH SECTION—See country-specific postal matcher documentation for other country formats.

OUTPUT GEOGRAPHIC MATCH SECTION—See country-specific postal matcher documentation for other country formats.

This and all name attributes repeat nine (9) times for a total of ten (10) names. Each section is described by one attribute (for example, pr_name_sect_01, pr_name_sect_02, and so on) and redefines the entire 1982 byte area.

Stores the number representing the occurrence of this name within the record (01-10). If generating records, this contains 01 for first name encountered, 02 for 2nd name, and so forth.

A one-byte attribute in each of the ten (10) name segments in the PREPOS indicating whether the name is in consumer or business form. Values are:

• 1 - Consumer 
• 2 - Business
• 3 - Errors (consumer/business unknown)
• Blank - No name present or identified.

If the address has no name line recognized, this attribute is not populated.

An ignore line becomes a miscellaneous line type. Note that this should be the only occasion when the name form attribute is not populated.

Stores the personal name prefix, using a recoded word: for example, titles such as Mr., Ms., and Dr.

Stores the original personal name prefix display: for example, titles such as Mr., Ms., and Dr. No recodes are applied.

Stores the personal name, given name 1, using a recoded word: for example, John, Joseph, or Jillian.

Stores the original personal name, given name 1 display: for example, John, Joe, or Jill. No recodes are applied.

Stores the personal name, given name 2, using a recoded word.

Stores the original personal name, given name 2 display. No recodes are applied.

Stores the personal name, given name 3, using a recoded word.

Stores the original personal name, given name 3 display. No recodes are applied.

Stores the personal name, given name 4, using a recoded word.

Stores the original personal name, given name 4 display. No recodes are applied.

Stores a personal name, surname display, using a recoded word.

Stores the original personal name, surname display. No recodes are applied.

Stores a personal name, surname display, using a recoded word.

Stores the original personal name, surname display. No recodes are applied.

Stores the personal name, generation display, using a recoded word: for example, Jr., Sr., and so forth.

Stores the original personal name, generation display. No recodes are applied.

Personal name, suffix display, using a recoded word: for example, titles after a personal name, such as DMD, ORTH, and so forth.

Stores the original personal name, suffix display: for example, titles after a personal name, such as DMD, ORTH, and so forth. No recodes are applied.

Contains a personal name, gender, using a recoded word. Values are:

• F - Female
• M - Male
• N - Neutral
• Blank - No value

Stores the business name, using a recoded word.

Stores the original business name display: for example, International Business Machines. No recodes are applied.

Stores the Connector, last name display, using recoded word.

Stores the original Connector display. No recodes are applied.

Contains the parser-identified standardized relationship: for example, Trustee for, Executor for, or In Trust for.

Contains the parser-identified input relationship.

Original line number (01-10).

Concatenated codes from category.

Contains the address line where xx indicates a number between 01 and 10.

Stores ten (10) three-character token identifiers for each name and address line. See Numerical List of Attributes.

Example: 054060054051053

Contains the line types of the original input address lines. Values are:

• A - Apartment
• B - Box
• E - E-mail
• F - Firm
• G - Geography
• H - Hold
•  I - Ignore line
• M - Miscellaneous
• N - Name
• R - Rural Route
• S - Street
• Y - Miscellaneous with care-of
• Z - Miscellaneous Street
• ? - Unidentified
• 2 - Consisting of secondary street info only
• Blank - No Input Information

Used to be a function of a parm offset

where xx indicates a number between 00 and 10.

Contains the attributes specific to each postal matcher, where xx indicates the country code. Values include the list of all input attributes.

Stores the input prefix street direction, such as N, S, W, E, and so forth for the secondary street.

Stores the post street direction for the secondary street.

Stores the sub-city name. Czech only.