CDQ Data Quality as Service

Idea Portal

Activating existend Data Qualty Rules

Scope

Action / Rule Category

Identifier

Identifier Name

SAP

Example

Description

TW

Identifier format accuracy

TW_GUID

GUI registration number

TW1/STCD1

XX12345678

Activating the Rule: https://meta.cdq.com/Identifier_format_inaccurate_(GUI_registration_number)


US

Identifier missing

US_SEC_ID

Social security number

US1/STCD1


Activating the existing rules: https://meta.cdq.com/Social_security_number_(United_States)

AT

Format inaccurate

BR_ID_AT

Business register identifier

AT1/STCD1

FN 12345678

Activating the existing rules: https://meta.cdq.com/Identifier_format_inaccurate_(National_business_register_identifier_(Austria))

AT

Checksum

BR_ID_AT

Business register identifier

AT1/STCD1

FN 12345678

Activating the existing rules: https://meta.cdq.com/Invalid_checksum_of_National_business_register_identifier_(Austria)

BR

Identifer format

BR_TAX_STATE

State tax number

BR3/STCD3

123456789012

Activating the existing rules: https://meta.cdq.com/Identifier_format_invalid_(State_tax_number_(Brazil))

CA

Identifier format

BN_CA

Federal Business Number

CA2/STCD2

121130173

Activating the existing rule: https://meta.cdq.com/Identifier_format_inaccurate_(Business_number_(Canada))


Identifier format

GST_CA

Goods and Services Tax number

CA1/STCD1

864917687RC0001

Activating the existing rule: https://meta.cdq.com/Identifier_format_inaccurate_(GST_number_(Canada))

CA

identifier missing

HST_CA

Harmonized Sales Tax number

CA4/STCD4

1234567891 TQ 0001

Activating the existing rule: https://meta.cdq.com/HST_presence_consistency_(Harmonized_Sales_Tax_number_(Canada))

CA

Identifer format

HST_CA

Harmonized Sales Tax number

CA4/STCD4

1234567891 TQ 0001

Activating the existing rule: https://meta.cdq.com/Invalid_checksum_of_HST_CA_(Canada)

CL

Identifer format

CL_RUT

RUT number

CL1/STCD1

80.621.200-8

Activating the existing rule: https://meta.cdq.com/Identifier_format_inaccurate_(RUT_number_(Chile))

CZ

identifier format

CZ_ICO

Company identification number

CZ2/STCD2

27864898

Activating the existing rule: https://meta.cdq.com/Identifier_format_inaccurate_(ICO_number_(Czech_Republic))

  • Onur Dinc
  • Jul 27 2023
  • Will not do
  • Attach files