US_EMPL_ID (US - Employer ID Num.)
DataModel:CDQ/Business Partner/Identifier/US EMPL ID
| Property | Value |
|---|---|
| A technical identifier, unique in a certain context. Technical key | US_EMPL_ID
|
| The country a linked concept is active or generally relevant for. Country scope | US (United States of America) |
| Language-specific name. Monolingual name | Employer identification number (en) |
| Language-specific short name. Monolingual short name | US - Employer ID Num. (en) |
| Informal and comprehensive human-readable definition of a concept. Description | The Employer Identification Number (EIN), also called the Federal Employer Identification Number or Federal Tax Identification Number, is the nine-digit number that the Internal Revenue Service assigns to business entities in the United States. It is required for payroll, tax returns, bank accounts and many contracts. |
| Category of business identifiers. Identifier category | Tax 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/US EMPL ID/format | Validates the format of the Employer Identification Number (EIN) of the United States, the nine-digit federal tax identification number that the Internal Revenue Service assigns to a business. The pattern accepts a valid two-digit prefix of the issuing campus followed by seven digits, written with or without the hyphen. | IDENTIFIER_FORMAT
|
|
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 (EIN (United States))REPRESENTATIONAL_CONSISTENCY
|
US (United States of America) | The United States Employer Identification Number consists of exactly nine numerical digits. This rule checks whether the value is written exactly in its reference format and flags any whitespace, hyphen or dot it contains. | INFO
|
IDEA(2020-01-01)
|
Identifier format invalid (Employer identification number (United States))REPRESENTATIONAL_CONSISTENCY
|
US (United States of America) | The United States Employer Identification Number consists of exactly nine digits. Before 2001 the first two digits, the EIN prefix, indicated that the business was located in a particular geographic area, and this rule accepts the prefixes published by the IRS at https://www.irs.gov/businesses/small-businesses-self-employed/how-eins-are-assigned-and-valid-ein-prefixes. | ERROR
|
RELEASED(2020-12-28)
|
Identifier missing (Employer identification number (United States))COMPLETENESS
|
US (United States of America) | This rule checks whether an Employer Identification Number has been maintained for the business partner and is violated when none is present. | INFO
|
RELEASED(2021-07-01)
|
Mandatory identifier not maintained (United States)COMPLETENESS
|
US (United States of America) | A business partner in the United States should carry at least one of two identifiers: the Employer Identification Number or a state business register identifier. If neither is available, the record is invalid. | ERROR
|
RELEASED(2024-09-18)
|
Social Security Number identified as Employer Identification NumberREPRESENTATIONAL_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
|