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 known as the Federal Employer Identification Number (FEIN) or the Federal Tax Identification Number, is a unique nine-digit number assigned by the Internal Revenue Service (IRS) to business entities operating in the United States for the purposes of identification. |
| 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 |
|---|---|---|---|
| 0000000000GZPBE6GRAEYKFFT1 | Specifies the allowed formats for the Employer identification number (United States) | IDENTIFIER_FORMAT
|
^(0[1-8]|1[0-6]|2[0-7]|30|31|3[2-9]|4[0-8]|5[0-9]|6[0-8]|7[1-7]|8[0-8]|9[0-5]|9[8-9])[\-|\‑]?\d{7}$
|
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 format inaccurate (EIN (United States)) | This rule checks the syntax, i.e. format of the Employer identification number (United States) with respect to the reference format. Any deviation (i.e. white spaces where they are not specified) result in a violation.
The EIN (USA) consists of exactly 9 numerical digits. This rule checks possible whitespaces, hyphens or dots that might be comprised in the identifier value. If there are any whitespaces, hyphens or dots then the rule is violated. |
IDEA
|
INFO
|
| Identifier format invalid (Employer identification number (United States)) | The Employer identification number consists of exactly 9 digits. Prior to 2001, the first two digits of an EIN (the EIN Prefix) indicated the business was located in a particular geographic area. The prefixes as provided here [1] are allowed. | RELEASED
|
ERROR
|
| Identifier missing (Employer identification number (United States)) | Checks whether there is an Employer identification number maintained for this partner, if not then the rule is violated. | RELEASED
|
INFO
|
| Mandatory identifier not maintained (United States) | A business partner in US should have at least a Employer identification number (United States) or a state business register ID. If none of these two is available the record is invalid. | RELEASED
|
ERROR
|
| 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
|