US_SEC_ID (US - Social security number)
DataModel:CDQ/Business Partner/Identifier/US SEC ID
| 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
|