| Atomic Warehouse 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. |
| Relationship | |
 Patient Adverse Reaction Detail_Patient Adverse Reaction_FK |
|
| Primary Key | |
 Patient Adverse Reaction Detail PK |
|
| Dependencies | |
 |
|
| Reverse Dependencies | |
 |
|
| Attribute Details |
Action Reason Code Sk
| Description | Indicates the reason reported for the patient's adverse reaction. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| 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 | false |
| Is Derived | false |
| Is Surrogate Key | false |
Alert Device Code Sk
| 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/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Allergen Code Sk
| 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/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Allergen Group Code Sk
| Description | Indicates an allergen group when both 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 specific drug can be detailed in the allergen and the group of drugs to which the specific drug belongs can identified in the allergen group. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Allergy Clinical Status Code Sk
| 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/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Allergy Severity Code Sk
| Description | Indicates the general seriousness of the allergy. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Causative Agent Sensitivity Code Sk
| 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/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Effective From Dt
| Description | Establishes a period where a set of attributes are true according to the business. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Effective To Dt
| Description | Ends a period of effectivity. |
| 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 |
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 |
Load Info Sk
| Description | The surrogate key of the load information entry describing the details regarding the loading of the row. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| 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 |
Onset Dt
| 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 |
Patient Adverse Reaction Sk
| Description | An allergen reaction documented for an allergy experienced by a patient. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG] |
| Is Part Of PrimaryKey | true |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Reported By Nm
| 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 |
Reported By Relationship Type Code Sk
| Description | Indicates the personal relationship the person reporting the allergy has to the patient. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| 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 |
Source Code Sk
| Description | The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| 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 |
Tenant Sk
| Description | The surrogate key of the entry identifying the legal owner of the data. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Valid From Ts
| Description | Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | true |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Valid To Ts
| Description | Ends a period of validity. |
| 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 Detail_Patient Adverse Reaction_FK
| Is Identifying Relationship | true |
| Child Table | Patient Adverse Reaction Detail |
| Child Role Name | is documented 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 | Patient Adverse Reaction |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Primary Key Details |
Patient Adverse Reaction Detail PK
| Key Attribute | Patient Adverse Reaction Sk |
| Key Attribute | Valid From Ts |
| Atomic Warehouse Model Data Model |