Consult Required IndMedication Conversion IndPick Up TypePrice Override Reason TxtRefill Initiator Source TxtTeen Confidentiality Ind
| Business Data Model Data Model |
| Description | A set of descriptive notes included in a pharmacy order that is to be dispensed directly to a patient or guardian by a retail pharmacy. For example: Collection note Confidentiality note Billing note |
| Attributes | |
| Consult Required Ind |
|
| Medication Conversion Ind |
|
| Pick Up Type |
|
| Price Override Reason Txt |
|
| Refill Initiator Source Txt |
|
| Teen Confidentiality Ind |
|
| Relationship | |
 Retail Pharmacy Order Notes_Pharmacy Order_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Consult Required Ind
| Description | Indicator if pharmacist is required to consult with the patient or guardian on use, risks and timing of the prescribed medicine. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Medication Conversion Ind
| Description | Indicator of whether the medication dispensed to the patient or guardian is a substitution or alteration from the initial prescription. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Pick Up Type
| Description | Nature of the dispense to the retail customer. For Example: Pharmacy delivery to home Customer to Wait Prescription Called In |
| 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 |
Price Override Reason Txt
| Description | Reason for price adjustment from standard price. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Refill Initiator Source Txt
| Description | Short description of how refill was initiated. |
| 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 |
Teen Confidentiality Ind
| Description | Indicator the confidentiality protocols must be observed for medications prescribed to teen minors. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Retail Pharmacy Order Notes_Pharmacy Order_FK
| Is Identifying Relationship | true |
| Child Table | Retail Pharmacy Order Notes |
| 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 |