Column Naming Conventions

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.

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

xxx_rpl

Replacement data.

xxx_pat

Parsing data.

xxx_id

Attribute ids.

xxx_orig

Original values found during parsing (example: pur_first_name_orig).

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).