UK_IN_ID (UK - NI number)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/UK IN ID
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key UK_IN_ID
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 NI number (en)
Language-specific short name. Monolingual short name UK - NI number (en)
Informal and comprehensive human-readable definition of a concept. Description The National Insurance number, in short NI number or NINO, is used in the United Kingdom to administer National Insurance and social security and for certain tax purposes. It consists of two prefix letters, six digits and a suffix letter from A to D and is quoted by employers in payroll reporting.
Category of business identifiers. Identifier category Personal Identification Number
Legacy property. A technical SAP code. SAP mapping STCD2

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
Regular expression/UK IN ID/format Validates the format of the British National Insurance number, which is used to administer the National Insurance and social security system and as a reference in tax matters. The pattern accepts two letters, six digits and a final letter from A to D. IDENTIFIER_FORMAT
^[A-Za-z]{2}\d{6}[A-Da-d]$

Data quality rules

Data quality rule The country a linked concept is active or generally relevant for. Country scope Informal and comprehensive human-readable definition of a concept. Description 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 Rule release status<br/>The release status in terms of development progress or maturity of a data quality rule.<br/>IDEA: Initial rule definition that documents a business requirement but is not yet active in services.<br/>PLANNED: Rule is specified and scheduled for implementation, but not yet active in services.<br/>DRAFT: Rule concept is being prepared or refined but is not yet finalized for implementation or execution.<br/>HYPERCARE: Rule is newly released and under increased observation to ensure stable behaviour and correct results.<br/>RELEASED: Rule has passed verification and is actively executed in productive CDQ services.<br/>DEACTIVATED: Rule is temporarily removed from the active rule set because it needs correction or clarification before re release.<br/>BLOCKED: Rule cannot be released because something it depends on is missing, for example a data source or a clarification.<br/>ARCHIVED: Rule is permanently retired and no longer maintained or intended for future activation. Rule release status
Identifier format invalid (NI number (United Kingdom))
REPRESENTATIONAL_CONSISTENCY
GB (United Kingdom of Great Britain and Northern Ireland) This rule checks the format of the National Insurance number of the United Kingdom. The National Insurance number, sometimes referred to as an NI No or NINO, is used in the administration of the National Insurance and social security system and for some purposes in the British tax system. It consists of two prefix letters, six digits and one suffix letter, which must be A, B, C or D, for example AA123456C. ERROR RELEASED