US_SEC_ID (US - Social security number)

From CDQ Wiki
DataModel:CDQ/Business Partner/Identifier/US SEC ID
Jump to navigation Jump to search
Property Value
A technical identifier, unique in a certain context. Technical key US_SEC_ID
The country a linked concept is active or generally relevant for. Country scope US (United States of America)
Language-specific name. Monolingual name Social security number (en)
Language-specific short name. Monolingual short name US - Social security number (en)
Category of business identifiers. Identifier category Personal Identification Number
Legacy property. A technical SAP code. SAP mapping STCD1

Formal definition

No format rules.

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 missing (Social security number (United States)) ... IDEA INFO
Social Security Number identified as Employer Identification Number The Employer identification number consists of exactly 9 digits likewise the Social security number. As both numbers are usually maintained in the identical SAP field a wrong mapping might easily happen. This rule identifies whether an Employer identification number in the input has a wrong EIN format, and then checks whether it is possible if the number is a social security number purely based on the format of the given value DRAFT INFO