Employer NumInformation Data
| Business Data Model Data Model |
| Description | An organization or individual engaging a person or persons to perform work under an employment agreement. |
| Attributes | |
| Employer Num |
|
| Information Data |
|
| Relationship | |
 Employer_Organization_FK |
|
| has name |
|
| Employer_Insured_FK |
|
| Employer_Party Name_FK |
|
| Generalization | |
 Generalization1 |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Employer Num
| Description | A reference number or code identifying the employer. It may be a user-defined code or a code defined by a government agency (Federal Tax ID#). When further breakdowns of employer information are needed, such as a division or plant, it is recommended that the coding scheme incorporate the relationships (for example, define separate codes for each division). The assigning authority and identifier type code are strongly recommended for all CX data types. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Information Data
| Description | Required employer information data for UB82 form locator 71. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Employer_Organization_FK
| Is Identifying Relationship | true |
| Child Table | Employer |
| Child Multiplicity | ZERO_TO_ONE |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Organization |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
has name
| Is Identifying Relationship | false |
| Child Table | Employer |
| Child Role Name | has name |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Party Name |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Employer_Insured_FK
| Is Identifying Relationship | false |
| Child Table | Employer |
| Child Role Name | has insured |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Insured |
| Parent Role Name | has employer |
| Parent Multiplicity | ZERO_TO_MANY |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Employer_Party Name_FK
| Is Identifying Relationship | false |
| Child Table | Employer |
| Child Role Name | has contact person |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Party Name |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Generalization Details |
Generalization1
| Supertype | Party Role |
| Subtype | Employer |
| Transform As | TABLE |
| Business Data Model Data Model |