UK_DRV_LIC (UK - Drv lic number)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/UK DRV LIC
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key UK_DRV_LIC
The country a linked concept is active or generally relevant for. Country scope GB (United Kingdom of Great Britain and Northern Ireland)
Language-specific name. Monolingual name Driver's Licence Number (en)
Language-specific short name. Monolingual short name UK - Drv lic number (en)
Informal and comprehensive human-readable definition of a concept. Description The UK driver's license number is a unique identifier assigned to each driver by the Driver and Vehicle Licensing Agency (DVLA). The UK driver's license number typically follows this 18-character structure:
  • First 5 characters: First five letters of the surname (padded with the number 9 if the surname has fewer than five characters).
  • Next character (6th): Represents the decade of birth (e.g., '8' for 1980s).
  • Following 5 digits (7th to 11th): Encodes the date of birth in the format MMDDY:
    • MM: Birth month (female drivers add 5 to the first digit, making January range from 51 to 62).
    • DD: Day of birth.
    • Y: Last digit of the birth year.
  • Two letters or digits (12th to 13th): Additional characters, often an issue number or other identifier.
  • Last 5 characters (14th to 18th): Numeric sequence, with a check digit to ensure validity.
Category of business identifiers. Identifier category Identification Number

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
0000000000702W65FRNQKTT23T Specifies the allowed formats for the Business partner/identifier/type/GB/UK DRV LIC IDENTIFIER_FORMAT
^[A-Z9]{5}[0-9]{1}[0-5][0-9][0-3][0-9][0-9][A-Z9]{2}[0-9]{5}$

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 Criticality<br/>Specifies how critical of the violation of a data quality rule.<br/>ERROR: Indicates a critical data quality rule violation that requires correction.<br/>WARNING: Indicates a potential data quality issue that should be reviewed.<br/>INFO: Indicates an informational finding with no immediate impact on data quality. Criticality
Identifier format invalid (Driver license number (United Kingdom)) The rule checks the structure of the Driver's License Number in UK. The UK driver's license number follows a 18-character structure.
  • First 5 characters: First five letters of the surname (padded with the number 9 if the surname has fewer than five characters).
  • Next character (6th): Represents the decade of birth (e.g., '8' for 1980s).
  • Following 5 digits (7th to 11th): Encodes the date of birth in the format MMDDY:
    • MM: Birth month (female drivers add 5 to the first digit, making January range from 51 to 62).
    • DD: Day of birth.
    • Y: Last digit of the birth year.
  • Two letters or digits (12th to 13th): Additional characters, often an issue number or other identifier.
  • Last 5 characters (14th to 18th): Numeric sequence, with a check digit to ensure validity.
RELEASED ERROR