Id Configuration CodeId NumItem Id Type
| Business Data Model Data Model |
| Description | A code that is used to identify an item master. For example: A numerical code An alphanumerical code |
| Attributes | |
| Id Configuration Code |
|
| Id Num |
|
| Item Id Type |
|
| Relationship | |
 Product Identifier_Product_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Id Configuration Code
| Description | Indicates how the Id Num is formatted. |
| 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 |
Id Num
| Description | Any item identifier number as defined by Id Type cd. For example, Universal Medical Device Nomenclature System™ (UMDNS) is a standard international nomenclature and computer coding system for medical devices. UMDNS is the worldwide nomenclature that has been officially adopted by many nations. It is used in ECRI Institute's databases and publications, as well as in thousands of healthcare institutions worldwide. |
| 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 |
Item Id Type
| Description | The type of identifier used for the item. For example: The United Nations Standard Products and Services Code (UNSPSC) is a taxonomy of products and services for use in e-commerce, and is a five-level hierarchy coded as an eight-digit number. |
| 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 |
Product Identifier_Product_FK
| Is Identifying Relationship | true |
| Child Table | Item Master Identifier |
| Child Role Name | has identifier |
| 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 | Item Master |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |