Explanation SeqExplanation TxtExplanation TypeInstructionInstruction TypePriority Sequence Num
| Business Data Model Data Model |
| Description | A set of textual comments that are specified for a pharmacy order. For example: General note Insurance note Clinical note |
| Attributes | |
| Explanation Seq |
|
| Explanation Txt |
|
| Explanation Type |
|
| Instruction |
|
| Instruction Type |
|
| Priority Sequence Num |
|
| Relationship | |
 Pharmacy Order Indication_Pharmacy Order_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Explanation Seq
| Description | A number that identifies the relative order of importance of the explanation. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Explanation Txt
| Description | The descriptive free text notes associated with the pharmacy order explanation. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Explanation Type
| Description | It identifies the type of explanation in relation to the pharmacy order. For Example: Instruction Clinical Insurance Financial |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | true |
Instruction
| Description | Identifies the instructions/guidance for the use of prescribed drug/treatment. |
| 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 |
Instruction Type
| Description | Indicates the type of instruction associated with the pharmacy order. For Example: Patient Preparation Practitioner Communication Instruction |
| 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 |
Priority Sequence Num
| Description | A number that identifies the relative order of importance of the instruction. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Small [VARCHAR(50)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Pharmacy Order Indication_Pharmacy Order_FK
| Is Identifying Relationship | false |
| Child Table | Pharmacy Order Explanation |
| Child Role Name | for |
| 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 | Pharmacy Order |
| 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 |