Customer Data Parser Change Flag - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

The Customer Data Parser (CDP) will flag changes to the original data if the flag option is enabled (Options > Advanced > Flag name/street/geography line changes). The default is not to flag any changes. A change can be a recode from the definitions tables or the correction of a city name from the city table. As long as the value in the recoded attribute is different from the original attribute in the Parser Repository (PREPOS), it is considered a change.

The change flag will be stored in a section of attributes in the Parser Repository (PREPOS). This section of attributes will be divided into three sub-sections: street line changes, geography line changes, and name line changes. Each changed flag attribute corresponds to a pair of recoded and original attributes and is one character long. A value of '1' in a changed flag attribute indicates that an original attribute has changed. If there is no change, then the changed flag attribute will be blank.

Note: You must add the pr_changed_flags attribute to the output schema to see the flags. See Adding Parser Outputs for how to add Parser output attributes in the Schema Editor.

Example

pr_street_type1_original = ROAD

pr_street_type1_recoded = RD

pr_street_type1_changed = 1

The following table lists the PREPOS attributes to store change flags.

*Attributes pr_name_line_changed_flags_01 to pr_name_suffix_changed_01 are repeated 9 times, one for each of the other 9 name sections.

Attribute

Length (bytes)

pr_changed_flags 230 (Redefine)
pr_street_line_changed_flags 44 (Redefine)
pr_box1_name_changed 2
pr_box2_name_changed 2
pr_complex1_name_changed 2
pr_complex1_type_changed 2
pr_complex2_name_changed 2
pr_complex2_type_changed 2
pr_dwelling1_name_changed 2
pr_dwelling2_name_changed 2
pr_dwelling3_name_changed 2
pr_neigh1_name_changed 2
pr_neigh2_name_changed 2
pr_route_name_changed 2
pr_street_name_changed 2
pr_street_type1_changed 2
pr_street_type2_changed 2
pr_street_primary_dir_changed 2
pr_street_secondary_dir_changed 2
pr_street_name_changed_2 2
pr_street_type1_changed_2 2
pr_street_type2_changed_2 2
pr_street_primary_dir_changed_2 2
pr_street_secondary_dir_changed_2 2
pr_geography_line_changed_flags 6 (Redefine)
pr_city_name_changed 2
pr_country_name_changed 2
pr_state_changed 2
pr_name_line_changed_flags 180 (Redefine)
pr_name_line_changed_flags_01 18
pr_busname_changed_ 01 2
pr_bustype_changed_ 01 2
pr_given_name1_changed _01 2
pr_given_name2_changed _01 2
pr_given_name3_changed _01 2
pr_given_name4_changed _01 2
pr_name_generation_changed _01 2
pr_name_prefix_changed_01 2
pr_name_suffix_changed_01 2