TH_PERS_ID (TH - Personal ID)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/TH PERS ID
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key TH_PERS_ID
The country a linked concept is active or generally relevant for. Country scope TH (Thailand)
Language-specific name. Monolingual name Personal ID (th), Personal ID (en)
Language-specific short name. Monolingual short name TH - Personal ID (en)
Category of business identifiers. Identifier category Tax Number
Legacy property. A technical SAP code. SAP mapping STCD1

Formal definition

Details Informal and comprehensive human-readable definition of a concept. Description The type in terms of a categorization of regular expressions. Regular expression type TThe formal expression of a regular expression. Regular expression
REGEXP_0458 Specifies the allowed formats for the Personal ID (Thailand) IDENTIFIER_FORMAT ^(\d\s*\.*-*){13}$

Data quality rules

Rule Informal and comprehensive human-readable definition of a concept. Description nonetheless, we continue to offer the most recent available data., The release status in terms of development progress or maturity.<br/><code>EMPTY</code> (0): No feature considered yet, just a rough idea.<br/><code>IDEA</code> (1): Just an idea, not yet designed in detail.<br/><code>DESIGN</code> (2): Software design ready, development not yet started.<br/><code>DEVELOPMENT</code> (3): Software development in progress.<br/><code>ALPHA</code> (4): First functional release, in terms of a Minimal Viable Product (MVP).<br/><code>BETA</code> (5): Tested by selected users.<br/><code>RC</code> (6): Release candidate, fully tested, not yet used in production by many customers.<br/><code>LIVE</code> (7): Used in production by customers, fully monitored and supported.<br/><code>DEPRECATED</code> (-1): End of life planned, but still available.<br/><code>EOL</code> (-2): End of life, historic service, no longer available.<br/><code>BROKEN</code> (-3): Service was used in production but is currently not available. However, CDQ tries to repair or reactivate it.<br/><code>DISCONTINUED</code> (-4): The data source has ceased providing updates Release status Specifies how critical of the violation of a data quality rule. The following levels are defined:<br/><code>ERROR</code>: The violation (e.g. missing information) puts a process at risk or hinders regular processing of data.<br/><code>WARNING</code>: The violation does not hinder regular processing of data but represents semantically defective data.<br/><code>INFO</code>: The data quality rule has not uncovered a data defect, but some information is available that might be interesting for the user.<br/> Criticality
Identifier format invalid (Personal ID (Thailand)) 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
LIVE ERROR
Inconsistency between Tax ID and Personal ID number (Thailand) TAX ID (Thailand) consists of 10 digits, but in case that TAX ID should be equal to Personal ID then it consists of 13 digits and all the digits are equal to the Personal number. This rules check if the TAX ID number is equal to the Personal ID number.

Any difference result in a rule violation.

LIVE ERROR