| Dimensional Warehouse Model Data Model |
Description | Health Risk information related to an individual, captured through health risk assessment, medical record analysis, claim data analysis or otherwise. |
Primary Key | |
![]() |
Dependencies | |
![]() |
Reverse Dependencies | |
![]() |
Attribute Details |
Description | Degree to which patient complies with limiting alcohol intake. For example: H = High L = Low M = Medium N = Non-Compliant |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The Alcohol Intake Level Indicator of the Person. For example: H = High L = Low M = Medium N = None |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Alcohol Intake Unit of Measure specifies the Unit of Measure in which alcohol intake is expressed. |
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 |
Description | Indicates the degree to which the person is conforming to a program of Blood Pressure control. For example: H = High L = Low M = Medium |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the degree to which the person is conforming to a program of Blood Pressure monitoring. For example: H = High L = Low M = Medium N = Non-compliant |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
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 |
Description | Indicates the degree to which the person is conforming to a program of Calorie control intake. For example: H = High L = Low M = Medium N = Non-compliant |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the degree to which the person is conforming to a program of carbohydrate control. For example: H = High L = Low M = Medium N = Non-compliant |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | The period of time since the person smoked cigarettes. |
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 |
Description | The number of years that the person smoked cigarettes over their lifetime. |
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 |
Description | The period of time since the person smoked cigars. |
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 |
Description | The number of years that the person smoked cigars over their lifetime. |
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 |
Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
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 |
Description | Amount of daily exercise the person engages in. For example: High Low Medium |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indication that the person is currently involved in dangerous hobbies or activities. For example: Level 3 (Scaffolding Employment) Level 4 (Competitive Motor Cycle Racing) |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | A categorization of the person's current diet. For example: I eat some fatty foods or I eat out at restaurants frequently. I don't typically eat many fruits or vegetables. I successfully avoid fatty foods and I typically eat at least 3 servings daily of fruits and vegetables. I successfully follow a diet which mainly consists of a variety of fruits and vegetables, breads and whole grains/cereals, and lean meat/meat-alternative products. OR I am a vegan/vegetarian. I tend to eat fatty foods such as whole milk, regular cheese, fast food, ice cream, fatty cuts of meat (like bacon), chips, salads with regular dressing, or breads with mayonnaise, margarine or butter. I don't typically eat many fruits or vegetables (that is, less than 3 servings daily). I try to avoid fatty foods or limit my fat intake by selecting lean cuts of meat, poultry, or fish. I typically eat 3 servings daily of fruits and vegetables. |
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 |
Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
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 |
Description | Indicates the degree to which the person is conforming to an exercise program specifically prescribed for their personal medical condition or disease risk. For example, a program of stretching and exercise following a broken leg. For example: Enrolled and awaiting commencement H = High High Increased exercise over 6 month period L = Low Low M = Medium Medium N = Non-compliant No planned participation Non-compliant |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Results of an exercise test, for example: running on a treadmill. |
Data Type | Standards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Exercise Unit of Measure specifies the Unit of Measure in which exercise frequency is expressed. |
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 |
Description | Indicates the degree of family involvement and support for the patient's health management programs. For example: H = High L = Low M = Medium N = Negative |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the degree to which the person is conforming to a fiber diet. For example: H = High L = Low M = Medium N = Non-compliant |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
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 |
Description | Indicates the degree to which the person is conforming to a program of Hypertension medication. For example: H = High L = Low M = Medium N = Non-compliant |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Degree to which patient complies with avoiding illicit drugs. For example: H = High L = Low M = Medium N = Non-Compliant |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the level at which the person partakes of illicit drugs. For example: H = High L = Low M = Medium N = None |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Illicit Drug Intake Unit of Measure specifies the Unit of Measure in which illicit drug intake is expressed. |
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 |
Description | A general indication of the person's lifestyle. For example: Active Outgoing Reclusive |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
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 |
Description | Indicates the degree to which the person is conforming to a low sodium diet. For example: H = High L = Low M = Medium N = Non-compliant |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicates the degree to which the person is conforming to a program of Monounsaturated Fat control. For example: H = High L = Low M = Medium N = Non-compliant |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Indicator that patient received nutrition and diet assessment and advice. |
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 |
Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
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 |
Description | Indicator that patient received an assessment and advice on appropriate levels of physical activity. |
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 |
Description | The period of time since the person smoked a pipe. |
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 |
Description | The number of years that the person used a pipe over their lifetime. |
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 |
Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
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 |
Description | Indicates the degree to which the person is conforming to a program of Protein control intake. For example: H = High L = Low M = Medium N = Non-compliant |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | A numeric surrogate key used to uniquely identify entities in the dimensional model. |
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 |
Description | An indication of whether the person has good or bad sleeping patterns, on an average day or week. For example: Bad Good Less than 6 hours sleep a night |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | An indication of the person's position with regard to improved adherence to doctor's advice including following medication plans. For example: Acting on it now and have been for more than 6 months. Acting on it now, but for no more than 6 months. Intending to take action within the next 30 days. Intending to take action within the next 6 months. Not intending to take action within the next 6 months. |
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 |
Description | Indicates the status of the person with respect to smoking. For example: N = Non-smoker R = Reducing smoking S = Smoker |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
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 |
Description | Tobacco Cessation Duration Unit specifies the Unit of Measure in which tobacco cessation duration is expressed. |
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 |
Description | Indicator that patient identified as a tobacco user, was offered a place on a tobacco cessation intervention program within a two-year measurement period. |
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 |
Description | Indicator that patient identified as a tobacco user, received cessation intervention within a two-year measurement period. |
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 |
Description | Tobacco Consumption Unit of Measure specifies the Unit of Measure in which tobacco consumption is expressed. |
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 |
Description | Indicator that patient received smoking assessment and advice to stop smoking within a two-year measurement period. |
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 |
Description | Indicator that patient was queried about tobacco use one or more times within a two-year measurement period. |
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 |
Description | Indicates the extent of tobacco usage, through all mediums. For example: High Low |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | Tobacco Usage Status classifies persons according to whether or not the person is a smoker or tobacco user. |
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 |
Description | Indicates the degree to which the person is conforming to a program of Transfat control intake. For example: H = High L = Low M = Medium N = Non-compliant |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Description | patient has had treadmill exercise test as recommended. |
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 |
Description | Indicates the degree to which the person is conforming to a program of weight control. For example: Control Plan in place but not commenced H = High L = Low M = Medium N = Non-compliant No planned course of action |
Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
Relationship Details |
Is Identifying Relationship | true |
Child Table | Personal Health Information Health Risk Snapshot |
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 Dimension |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | true |
Child Table | Personal Health Information Health Risk Snapshot |
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 Dimension |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | true |
Child Table | Personal Health Information Health Risk Snapshot |
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 | Provider Dimension |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | true |
Child Table | Personal Health Information Health Risk Snapshot |
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 | Geographic Area Dimension |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | true |
Child Table | Personal Health Information Health Risk Snapshot |
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 | Calendar Dimension |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | true |
Child Table | Personal Health Information Health Risk Snapshot |
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 Dimension |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Is Identifying Relationship | true |
Child Table | Personal Health Information Health Risk Snapshot |
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 | Condition Dimension |
Parent Multiplicity | ONE |
Parent Referential Integrity: On Delete | NONE |
Parent Referential Integrity: On Insert | NONE |
Parent Referential Integrity: On Update | NONE |
Primary Key Details |
Key Attribute | Patient Dk |
Key Attribute | Practitioner Dk |
Key Attribute | Provider Dk |
Key Attribute | Geographic Area Dk |
Key Attribute | Calendar Dk |
Key Attribute | Encounter Dk |
Key Attribute | Condition Dk |
| Dimensional Warehouse Model Data Model |