Column Naming Conventions
Output files can have a lot of columns after processing input data in ONE Desktop. Because of this, we recommend grouping columns by content. The summary of prefixes and suffixes is described in the following tables.
Use only lowercase for column names. |
Prefixes
Attribute prefix | Explanation | Column type |
---|---|---|
|
Source input values; should be a read-only attribute. |
Read-only columns. |
|
Source input metadata. |
Internal, data quality evaluation, and temporary columns that might not be persisted. |
|
Decoded source input values. |
Internal, data quality evaluation, and temporary columns that might not be persisted. |
|
Attribute where the translated master value is stored (src_xxx is used as a source). |
Internal, data quality evaluation, and temporary columns that might not be persisted. |
|
Precleansed values (operational column). |
Internal, data quality evaluation, and temporary columns that might not be persisted. |
|
Temporary column (operational column). |
Internal, data quality evaluation, and temporary columns that might not be persisted. |
|
Attribute structure description (patterns). |
Internal, data quality evaluation, and temporary columns that might not be persisted. |
|
Counter (operational column). |
Internal, data quality evaluation, and temporary columns that might not be persisted. |
|
Standardized value of the attribute. |
/ |
|
Cleansed instance output of the attribute, that is, the best value available. |
/ |
|
Cleansed master output of the attribute, that is, the result of the merge process. |
/ |
|
Operational output column, that is, the best value available (components interface). |
/ |
|
Attribute score (the higher number, the worse the data, |
Internal, data quality evaluation, and temporary columns that might not be persisted. |
|
Scoring explanation column - cleansing codes for each attribute. |
Internal, data quality evaluation, and temporary columns that might not be persisted. |
|
Human-readable and/or GUI-friendly data quality explanation that is based on sco and exp attributes. |
Internal, data quality evaluation, and temporary columns that might not be persisted. |
|
Instance score (usually the sum of attribute scores). |
Internal, data quality evaluation, and temporary columns that might not be persisted. |
|
Instance explanation code (list of error messages); aggregated attribute explanations. |
Internal, data quality evaluation, and temporary columns that might not be persisted. |
|
Matching value of the attribute. |
Internal, data quality evaluation, and temporary columns that might not be persisted. |
|
Candidate group ID. |
Matching attributes. |
|
Candidate group ID (old, that is, the ID assigned in the last unification process). |
Matching attributes. |
|
Matching group ID (used to be called the "client group"). |
Matching attributes. |
|
Matching group ID (old, that is, the ID assigned in the last unification process). |
Matching attributes. |
or
|
Instance unification role. |
Matching attributes. |
|
Merge survivor record role. |
Matching attributes. |
|
Name of the applied unification rule. |
Matching attributes. |
|
Group unification role (A, C, M, U) for the candidate group. |
uni_grp_mat_role |
Suffixes
Attribute suffix | Explanation |
---|---|
|
Replacement data. |
|
Parsing data. |
|
Attribute ids. |
|
Original values found during parsing (example: pur_first_name_orig). |
Obsolete and/or rarely used prefixes
Attribute suffix | Explanation |
---|---|
|
Attribute analysis of Cyrillic characters (operation column). |
|
Attribute analysis of Latin characters (operation column). |
|
Attribute length analysis (operation column). |
|
Attribute char analysis (operation column). |
|
Attribute word analysis (operation column). |
|
Attribute quality mark - ABCDX (operation column). |
|
Entity quality mark - ABCDX (operation column). |
|
Address lookup file data (operation column). |
|
Replacement candidates (incorrect data). |
|
Dust bin for text waste (operation column). |
|
Primary unification (operation column). |
|
Secondary unification (operation column). |
Was this page useful?