Standard Attributes - trillium_discovery - trillium_quality - 17.2

Trillium Input/Output Attributes Reference Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.2
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Input/Output Attributes Reference Guide
Topic type
Administration
Overview
How Do I
Configuration
Reference
Installation
First publish date
2008

The table given below lists the standard Parser Repository (PREPOS) attributes.

Table 1. CDP Standard Attributes

Attribute Name

Length

Description

pr_best_street_name

200

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.

pr_best_street_number

20

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.

pr_box1_mask

20

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

N—Numeric

A—Alpha

-,/—Special

pr_box1_name_original

40

Stores the original input box name.

pr_box1_name_recoded

40

Stores the input box name.

pr_box1_number

20

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

pr_box1_type

2

Stores the input box type. Values are:

B—Box

D—Drawer

P—PO Box

T—Pole

pr_box2_mask

20

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

N—Numeric

A—Alpha

-,/—Special

pr_box2_name_original

40

Stores the original input box name.

pr_box2_name_recoded

40

Stores the input box name.

pr_box2_number

20

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

pr_box2_type

2

Stores the input box type. Values are:

B—Box

D—Drawer

P—PO Box

T—Pole

pr_busname_original_01

200

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

pr_busname_recoded_01

200

Stores the business name, using a recoded word.

pr_category

100

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.

pr_city_lname_dir

100

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

pr_city_name_original

200

Stores the original city name.

pr_city_name_recoded

200

Stores the city name.

pr_city_number

12

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)

pr_city_status

2

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

pr_completion_code

2

Receives the Customer Data Parser return codes:

0—No error

1—Insufficient Storage. When using  attribute sub-segments (line_01a, line_01b, etc.) and the sum of the data in these attributes exceeds the redefine attribute length, the data is truncated and a value of ‘1’ is returned. Processing continues normally for all other lines.

2—Table Error – Pattern, Word and/or City tables not found

3—Log File Error

4—Detail File Error

5—Pattern-Word-City Tab Error – Pattern, Word and/or City tables not readable.

6—Too Many Tokens

7—Line Definition Error

8—Display File Error

9—Invalid Parser Handle

A—Invalid Parm File Entry

B—Invalid Interface Call Type. Must be either:
  • O=Open
  • P=Process
  • C=Close
C—Invalid Service Call Type. Must be either:
  • D=Send to Display File
  • E=Supply Error Text

D—Statistics File Error

F—Parser not successfully initialized. Settings file may not be correctly defined. Check path and file name.

Note: Errors 2, 3, 4, 5, 8, and D are caused by inaccuracies in the file path.

pr_complex1_name_original

200

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

pr_complex1_name_recoded

200

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

pr_complex1_type_original

30

60 (UK)

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

pr_complex1_type_recoded

30

60 (UK)

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

pr_complex2_name_original

200

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

pr_complex2_name_recoded

200

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

pr_complex2_type_original

30

60 (UK)

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

pr_complex2_type_recoded

30

60 (UK)

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

pr_complex3_name_original

200

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

pr_complex3_name_recoded

200

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

pr_complex3_type_original

30

60 (UK)

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

pr_complex3_type_recoded

30

60 (UK)

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

pr_country_name_original

100

Stores the original country name.

pr_country_name_recoded

200

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

pr_dwelling1_mask

20

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

N—Numeric

A—Alpha

-,/—Special

pr_dwelling1_name_original

200

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

pr_dwelling1_name_recoded

200

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

pr_dwelling1_number

20

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

pr_dwelling1_type

2

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.

pr_dwelling2_mask

20

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

pr_dwelling2_name_original

200

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

pr_dwelling2_name_recoded

200

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

pr_dwelling2_number

20

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

pr_dwelling2_type

2

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.

pr_dwelling3_mask

20

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

pr_dwelling3_name_original

200

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

pr_dwelling3_name_recoded

200

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

pr_dwelling3_number

20

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

pr_dwelling3_type

2

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.

pr_filler_01

8

Reserved for future use.

pr_filler_02

168

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.

pr_geocd_x

20

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

pr_geog_review_codes

300

Stores the review code for geography attributes. See CDP Review Codes and Groups for a list of review codes.

pr_given_name1_original_01

100

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

pr_given_name1_recoded_01

100

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

pr_given_name2_original_01

100

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

pr_given_name2_recoded_01

100

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

pr_given_name3_original_01

100

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

pr_given_name3_recoded_01

100

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

pr_given_name4_original_01

100

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

pr_given_name4_recoded_01

100

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

pr_global_review_codes

300

Stores the review codes for global review problems. See CDP Review Codes and Groups for a list of review codes.

pr_house_mask

30

Stores the shape of the input house values:

N—Numeric

A—Alpha

-,/—Special

pr_house_number_original

30

Stores the original input house value.

pr_house_number_recoded

30

Stores the input house value: for example, ‘5’ in the address ‘5 Main Street.’

pr_house_type

2

Stores the input house type. Values are:

N—Numeric

  —Hyphenated

U—Unusual

S—Slash

B—Blank

A—Alpha

pr_line_rules

40

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

pr_line_type

20

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

pr_line_xx

200

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

pr_misc_address

2000

Stores the miscellaneous address values. 200 bytes per line.

pr_misc_review_codes

3000

Stores the review code for miscellaneous problems. See CDP Review Codes and Groups for a list of review codes.

pr_name_category_01

50

Concatenated codes from category.

pr_name_connector_original_01

30

Stores the original Connector display. No recodes are applied.

pr_name_connector_recoded_01

30

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

pr_name_form_01

2

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

1—Personal

2—Business

3—Errors

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.

 

When running the Relationship Linker or Reference Matcher process, check the value of pr_name_form_nn and make sure that you specify corresponding consumer or business match rules. Record types "3" and "Blank" are processed as business records; therefore you must specify business match rules to do the matching of those records. If the corresponding match rules are not specified, records will be dropped from the linking window.

pr_name_gender_01

2

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

F—Female,

M—Male

N—Neutral

BlankNo value

pr_name_generation_original_01

20

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

pr_name_generation_recoded_01

20

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

pr_name_number_01

4

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.

pr_name_original_line_number_01

4

Original line number (01-10).

pr_name_prefix_original_01

30

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

pr_name_prefix_recoded_01

30

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

pr_name_relation_original_01

50

Contains the parser-identified input relationship.

pr_name_relation_recoded_01

50

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

pr_name_review_codes

3000

Stores the review code for names. See CDP Review Codes and Groups for a list of review codes.

pr_name_sect_01

2

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.

Note: If any attribute is removed from the segment then the length of 1982 will be changed to reflect the new length.

pr_name_suffix_original_01

30

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.

pr_name_suffix_recoded_01

30

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

pr_name_types

2

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)

pr_neigh1_name_original

200

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.

pr_neigh1_name_recoded

200

Stores the neighborhood 1/locality name.

pr_neigh2_name_original

200

Stores the original neighborhood 2/locality name.

pr_neigh2_name_recoded

200

Stores the neighborhood 2/locality name.

pr_number_of_input_names

4

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

pr_number_of_output_names

4

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

pr_orig_line_pattern

20

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

pr_pattern

600

Stores ten (10) three-character token identifiers for each name and address line.

Example: 054060054051053

pr_postal_code

30

Stores the input postal code.

Examples: 01821, 01879, M8X 2X3

pr_postal_code_dir

30

Stores the postal code found on the USCITY.len city table, for the unidentified city and state.

pr_postal_code_index_0x   (x=1-6)

12

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

pr_postal_code_mask

30

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

pr_postal_code_mask_dir

30

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

pr_postal_code_type

2

Stores the type of input postal code.

pr_postal_code_type_dir

2

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

0—Non-US record

4—Box Code

5—Special Military

8—Non Unique

Other—Non-US record

pr_rev_group

3

Provides codes that guide you to areas for parser tuning. Refer to page 39 for more information on review groups.

pr_route_mask

16

Stores the shape of the input route value.

pr_route_name_original

40

Stores the input route name.

pr_route_name_recoded

40

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

pr_route_number

16

Stores the input route value.

pr_route_number_type

2

Stores input route type. Values are:

R—Route

H—Highway

pr_state_number

4

Stores the state number.  

pr_state_original

60

Stores the original state, province, or county name.

pr_state_recoded

60

Stores the state, province, or county name.

pr_street_name_original

200

Stores the original input street title.

pr_street_name_recoded

200

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

pr_street_primary_dir_original

24

Stores the original prefix street direction input.

pr_street_primary_dir_recoded

24

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.

pr_street_review_codes

300

Stores the review code for streets. See CDP Review Codes and Groups for a list of review codes.

pr_street_secondary_dir_original

24

Stores the original post street direction input.

pr_street_secondary_dir_recoded

24

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.

pr_street_type1_original

30

Stores the original first street type input.

pr_street_type1_recoded

30

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

pr_street_type2_original

30

Stores original second street type input.

pr_street_type2_recoded

30

Stores second street type input.

pr_surname1_original_01

100

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

pr_surname1_recoded_01

100

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

pr_surname2_original_01

100

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

pr_surname2_recoded_01

100

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

pr_user_field_xx

200

Used to be a function of a parm offset where xx indicates a number between 00 and 10.

pr_world_origin

2

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)

xx_postal_match_input_area

600

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

pr_verified_geography

1

Stores the flag for the Additional geography lookup option. For Hong Kong, this option also returns island for some cities in the pr_sub_city attribute.

Values are:

Y—province/city/postcode combination validated.

N—province/city/postcode combination not validated.

Note: This option is not available for the following countries: Basic Countries (ZZ), China (CN), United Kingdom (GB), Japan (JP), Korea (KR), Singapore (SG), and Taiwan (TW).
Note: For Canada (CA), Netherlands (NL), and Portugal (PL), the flag in the pr_verified_geography attributes is not available.