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)
Informal and comprehensive human-readable definition of a concept. Description The Social security number (SSN) is the nine-digit number that the Social Security Administration issues to individuals in the United States. It is used for social security records, payroll and tax purposes and serves as the taxpayer identification number of a natural person.
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

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 missing (Social security number (United States))
COMPLETENESS
US (United States of America) This rule checks whether a social security number has been maintained for the business partner and reports the record when none is present. INFO IDEA
Social Security Number identified as Employer Identification Number
REPRESENTATIONAL_CONSISTENCY
US (United States of America) The United States Employer Identification Number consists of exactly nine digits, and so does the social security number. Because both are usually maintained in the same SAP field, they are easily mixed up. This rule identifies an Employer Identification Number whose format is wrong and then checks, purely on the basis of the format of the given value, whether the number could in fact be a social security number. INFO DRAFT