User Community Service Desk Downloads
If you can't find the product or version you're looking for, visit support.ataccama.com/downloads

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

src_xxx

Source input values; should be a read-only attribute.

Read-only columns.

meta_xxx

Source input metadata.

Internal, data quality evaluation, and temporary columns that might not be persisted.

dec_xxx

Decoded source input values.

Internal, data quality evaluation, and temporary columns that might not be persisted.

dic_xxx

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.

pur_xxx

Precleansed values (operational column).

Internal, data quality evaluation, and temporary columns that might not be persisted.

tmp_xxx

Temporary column (operational column).

Internal, data quality evaluation, and temporary columns that might not be persisted.

pat_xxx

Attribute structure description (patterns).

Internal, data quality evaluation, and temporary columns that might not be persisted.

cnt_xxx

Counter (operational column).

Internal, data quality evaluation, and temporary columns that might not be persisted.

std_xxx

Standardized value of the attribute.

/

cio_xxx

Cleansed instance output of the attribute, that is, the best value available.

/

cmo_xxx

Cleansed master output of the attribute, that is, the result of the merge process.

/

out_xxx

Operational output column, that is, the best value available (components interface).

/

sco_xxx

Attribute score (the higher number, the worse the data, 0 means perfect).

Internal, data quality evaluation, and temporary columns that might not be persisted.

exp_xxx

Scoring explanation column - cleansing codes for each attribute.

Internal, data quality evaluation, and temporary columns that might not be persisted.

lbl_xxx

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.

sco_instance

Instance score (usually the sum of attribute scores).

Internal, data quality evaluation, and temporary columns that might not be persisted.

exp_instance

Instance explanation code (list of error messages); aggregated attribute explanations.

Internal, data quality evaluation, and temporary columns that might not be persisted.

mat_xxx

Matching value of the attribute.

Internal, data quality evaluation, and temporary columns that might not be persisted.

uni_can_id

Candidate group ID.

Matching attributes.

uni_can_id_old

Candidate group ID (old, that is, the ID assigned in the last unification process).

Matching attributes.

uni_mat_id

Matching group ID (used to be called the "client group").

Matching attributes.

uni_mat_id_old

Matching group ID (old, that is, the ID assigned in the last unification process).

Matching attributes.

uni_role

or

uni_instance_role

Instance unification role.

Matching attributes.

uni_msr_role

Merge survivor record role.

Matching attributes.

uni_rule_name

Name of the applied unification rule.

Matching attributes.

uni_grp_can_role

Group unification role (A, C, M, U) for the candidate group.

uni_grp_mat_role

Suffixes

Attribute suffix Explanation

xxx_rpl

Replacement data.

xxx_pat

Parsing data.

xxx_id

Attribute ids.

xxx_orig

Original values found during parsing (example: pur_first_name_orig).

Obsolete and/or rarely used prefixes

Attribute suffix Explanation

cyr_xxx

Attribute analysis of Cyrillic characters (operation column).

lat_xxx

Attribute analysis of Latin characters (operation column).

length_xxx

Attribute length analysis (operation column).

char_xxx

Attribute char analysis (operation column).

word_xxx

Attribute word analysis (operation column).

qma_xxx

Attribute quality mark - ABCDX (operation column).

qme_xxx

Entity quality mark - ABCDX (operation column).

uir_xxx

Address lookup file data (operation column).

rpl_can_xxx

Replacement candidates (incorrect data).

bin_xxx

Dust bin for text waste (operation column).

pri_xxx

Primary unification (operation column).

sec_xxx

Secondary unification (operation column).

Was this page useful?