CDQ Data Quality as Service
Idea Portal
Idea Portal
Idea Portal
TN - New Identifier "TN_TIN"
TN- Identifier TN_TIN missing / WARNING
TH- Identifier TH_PERS_ID missing / WARNING
TH- Identifier TH_PERS_ID format check: / WARNING
The Thai Personal ID is a 13-digit number. Personal IDs are always 13 digits long, while company Tax IDs are 10 digits long. For individuals, the Tax ID usually matches their Personal ID, meaning it is also a 13-digit number. However, for companies, it is a 10-digit number. The Personal-ID format is structed as:
The first digit represents the region of birth.
The next four digits represent the year of birth.
The following five digits are a serial number.
The last three digits are a checksum for verification
HR - Rule "Inconsistency between HR_OIB and EU_VAT_ID_HR" / WARNING
EU_VAT_ID_HR consists of HR_OIB with HR-Prefix!
OIB number corresponding to VAT number without HR letters. Has to be mandatory, so the rule category would be identifier missing and then rule name Identifier missing (OIB number Croatia) HR1 tax number field is related to the OIB and OIB is VAT without HR
The Personal identification number (Croatian: Osobni identifikacijski broj or OIB) is a permanent national identification number of every Croatian citizen and legal persons domiciled in the Republic of Croatia.
US - Activate the Rules for "US_SEC_ID" https://meta.cdq.com/Social_security_number_(United_States)
XK - Removing the "Whitespace" after the second digit in the Post Code Format Check, because it is not mandatory (https://postakosoves.com/en/zip-codes/)
https://meta.cdq.com/Post_code_format_invalid_(Kosovo)
Onur Dinc
We are closing this idea ticket, US and HR ideas were separated (see above comment).
For Kosovo the adjustments were delivered here
For Thailand the following was introduced:
The Thai Personal ID is a 13-digit number. Personal IDs are always 13 digits long, while company Tax IDs are 10 digits long. For individuals, the Tax ID usually matches their Personal ID, meaning it is also a 13-digit number. However, for companies, it is a 10-digit number. The Personal-ID format is structed as:
We now support checks for both identifier types explicitly.
For the Personal ID and Tax ID the following checks were introduced
Mandatory identifier missing
For the Personal ID
Identifier format invalid
For the Tax ID
The identifier format check was adjusted to just allow the 10 digits for companies
The identifier missing rule was adjusted to the criticality INFO by default as it is superseded by the Mandatory identifier missing rule
For Croatia please see this idea: https://cdqag.aha.io/ideas/ideas/IPOC-I-469
For checks of the Social Security Number in US, please refer to this idea: https://cdqag.aha.io/ideas/ideas/IPOC-I-470