JE_SSN (JE - Social Security Number)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/JE SSN
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key JE_SSN
The country a linked concept is active or generally relevant for. Country scope JE (Jersey)
Language-specific name. Monolingual name Social Security Number (en)
Language-specific short name. Monolingual short name JE - Social Security Number (en)
Informal and comprehensive human-readable definition of a concept. Description The Social Security Number of Jersey is issued to residents by the social security administration and doubles as their taxpayer identification number, for example in reporting under the Common Reporting Standard. Employers and financial institutions quote it for contributions, payroll and tax reporting.
Category of business identifiers. Identifier category Personal 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
Regular expression/JE SSN/format Validates the format of the Jersey social security number, which serves as the taxpayer identification number of a Jersey resident individual under the Common Reporting Standard. The pattern accepts two letters, usually JY, followed by six digits and the closing letter A, B, C or D. IDENTIFIER_FORMAT
^(\s*\.*-*)(\w\s*\.*-*){2}(\d\s*\.*-*){6}(A|B|C|D)(\s*\.*-*)$
Regular expression/JE SSN/reference schema Defines the reference format in which the Jersey social security number is stored, namely two letters, six digits and a closing letter, nine characters in total. Used to bring values into a single canonical notation. IDENTIFIER_SCHEMA
^(\w{2})(\d{6})(\w{1})$

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 inaccurate (Social Security Number (Jersey))
REPRESENTATIONAL_CONSISTENCY
JE (Jersey) This rule checks that the social security number of Jersey is written in its reference schema of two letters, six digits and a final letter, including that all applicable hyphens, dots and spaces are in place. A value formatted differently is flagged. INFO RELEASED(2024-04-16)
Identifier format invalid (Social Security Number (Jersey))
REPRESENTATIONAL_CONSISTENCY
JE (Jersey) This rule checks that the social security number of Jersey consists of exactly nine characters in the pattern of two letters, six digits and one final letter, disregarding any whitespaces, hyphens or dots in the value. The first two letters are usually, but not exclusively, JY, and the last letter must be A, B, C or D. A value with too few or too many digits or letters, or with an unexpected letter, violates the rule. An example of the identifier is JY123456A. ERROR RELEASED
Identifier missing (Social Security Number (Jersey))
COMPLETENESS
JE (Jersey) Every individual in Jersey is expected to hold a social security number, and this rule flags records in which it is missing. INFO RELEASED(2024-04-16)
Identifier unknown (Social Security Number (Jersey))
ACCURACY
JE (Jersey) This rule checks whether the social security number is known, meaning that it is assigned to a business partner listed in the official registry of Jersey. A value that cannot be found there is flagged. ERROR IDEA