V.6.1.2 Product Characteristics Query Information Model

V.6.1.2.1 E/R Model

The Product Characteristics Query Information Model is represented by the Entity Relationship diagram shown in figure V.6 -1.

[pic]

Figure V.6-1 Product Characteristics E-R Diagram

There is only one Information Entity in the model, which is the Product. The attributes of a Product can be found in the following Module in PS 3.3.

— Product Characteristics Module

V.6.1.2.2 Product Characteristics Query Attributes

Table V.6-1 defines the Attributes of the Product Characteristics Query Information Model:

Table V.6-1ATTRIBUTES FOR THE PRODUCT CHARACTERISTICS QUERY INFORMATION MODEL

Description / Module Tag Match-ing Key Type Return Key Type Remark/Matching Type
Product Package Identifier (0044,0001) R 1 Shall be retrieved with Single Value Matching only.
Product Type Code Sequence (0044,0007) - 1
>Code Value (0008,0100) - 1
>Coding Scheme Designator (0008,0102) - 1
>Code Meaning (0008,0104) - 1
Product Name (0044,0008) - 1
Product Expiration DateTime (0044,000B) - 2
Product Parameter Sequence (0044,0013) - 2
>Value Type (0040,A040) - 1
>Concept Name Code Sequence (0040,A043) - 1
>>Code Value (0008,0100) - 1
>>Coding Scheme Designator (0008,0102) - 1
>>Code Meaning (0008,0104) - 1
>All other Attributes of Product Parameter Sequence - 1C Conditional on value of Value Type (0040,A040); See PS 3.3 Content Item Macro.
All other Attributes of Product Characteristics Module - 3

The Product Package Identifier (0044,0001) might not be globally unique and might conflict with other identifiers used within the scope of the institution.

Note: The package identifiers are typically unique within the scope of the substance administration management systems. This is a warning that they are not UIDs.