| Business Data Model Data Model |
| Description | A patient's allergic reaction to an actual exposure to a substance, situation, or physical state that normally does not have a negative effect on the average individual. For example: John had difficulty breathing after ingesting peanuts on April 4th 2014. |
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Action Reason
| Description | Indicates the reason reported for the patient's adverse reaction. |
| 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 |
Adverse Reaction Onset Date
| Description | The date upon which the patient had their first known reaction to the allergen. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Adverse Reaction Reported By Name
| Description | The name of the person that reported the allergy to the caregiver. This may be someone other than the patient or the practitioner. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name Compound [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Adverse Reaction Seq
| Description | A number identifying the sequence in which a single patient adverse reaction was reported. The first adverse reaction reported has a sequence number of one, the second a value of two and so on. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Alert Device Type
| Description | Indicates the type of allergy alert device the patient may be carrying or wearing. For example: Bracelet Necklace Wallet Card |
| 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 |
Allergen
| Description | Identifies a particular allergen. It may conform to an external, standard coding system (that must be identified), or it may conform to a local, largely textual or mnemonic description. |
| 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 | false |
Allergen Group
| Description | An allergen group when a detailed allergen and an allergen group or category need to be communicated. For example: If the patient has a drug allergy, the code for the drug can be detailed in the allergen and the group of drugs to which the specific drug belongs can be identified in the allergen group. |
| 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 |
Allergy Clinical Status
| Description | Indicates the verification status for the patient's allergy. For example: Unconfirmed Confirmed Confirmed but inactive. |
| 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 |
Allergy Severity
| Description | Indicates the general seriousness of the allergy. |
| 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 |
Causative Agent Sensitivity Type
| Description | Indicates why the patient should not be exposed to a substance. For example: Allergy Contraindication Intolerance |
| 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 |
First Occurrence Age In Years Cnt
| Description | The age (specified in years) of the patient when the allergy was first detected. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Last Occurrence Age In Years Cnt
| Description | The age (specified in years) of the patient when the last allergic reaction was experienced. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Onset Date Descr
| Description | A textual description of the time period of the patient's first reaction to an allergen when an exact date is not known. For example: Adolescence Childhood Spring 1990 |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Reported Ts
| Description | The date and time the allergy was reported to the caregiver. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Statused Ts
| Description | Date and time that the patient's allergy status was last checked by the practitioner. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Patient Adverse Reaction_Organization_FK
| Is Identifying Relationship | false |
| Child Table | Patient Adverse Reaction |
| Child Role Name | is statused by |
| 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 | Organization |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Patient Allergy / Allergen Reaction_Patient_FK
| Is Identifying Relationship | true |
| Child Table | Patient Adverse Reaction |
| Child Role Name | affects |
| 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 | Patient |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Patient Adverse Reaction_Allergen_FK
| Is Identifying Relationship | true |
| Child Table | Patient Adverse Reaction |
| Child Role Name | is reaction to |
| 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 | Allergen |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Patient Adverse Reaction_Practitioner_FK
| Is Identifying Relationship | false |
| Child Table | Patient Adverse Reaction |
| Child Role Name | is statused by |
| 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 | Practitioner |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Patient Adverse Reaction_Encounter_FK
| Is Identifying Relationship | false |
| Child Table | Patient Adverse Reaction |
| Child Role Name | is reported on |
| 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 | Encounter |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Patient Adverse Reaction_Plan Member_FK
| Is Identifying Relationship | true |
| Child Table | Patient Adverse Reaction |
| Child Role Name | affects |
| 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 | Plan Member |
| 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 |