| 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 | |
Personal Health Information Health Risk Snapshot PK |
|
| Dependencies | |
NONE |
|
| Reverse Dependencies | |
|
|
| Attribute Details |
Alcohol Control Ind
| 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 |
Alcohol Intake Level Ind
| 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 |
Alcohol Intake Unit of Measure
| 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 |
Blood Pressure Control Adherence Ind
| 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 |
Blood Pressure Monitor Adherence Ind
| 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 |
Calendar Dk
| 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 |
Calorie Intake Adherence Ind
| 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 |
Carbohydrate Intake Adherence Ind
| 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 |
Cigarette Smoking Cessation Duration
| 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 |
Cigarette Smoking Duration
| 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 |
Cigar Smoking Cessation Duration
| 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 |
Cigar Usage Duration
| 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 |
Condition Dk
| 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 |
Daily Exercise Level Ind
| 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 |
Dangerous Activities Ind
| 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 |
Diet Ind
| 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 |
Encounter Dk
| 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 |
Exercise Program Ind
| 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 |
Exercise Tolerance Level
| 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 |
Exercise Unit of Measure
| 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 |
Family Health Involvement Ind
| 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 |
Fiber Diet Adherence Ind
| 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 |
Geographic Area Dk
| 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 |
Hypertension Medication Adherence Ind
| 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 |
Illicit Drug Control Ind
| 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 |
Illicit Drug Intake Level Ind
| 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 |
Illicit Drug Intake Unit of Measure
| 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 |
Lifestyle Ind
| 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 |
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 |
Low Sodium Diet Adherence Ind
| 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 |
Monounsaturated Fat Control Adherence Ind
| 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 |
Nutrition Counseled Ind
| 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 |
Patient Dk
| 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 |
Physical Activity Counseled Ind
| 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 |
Pipe Smoking Cessation Duration
| 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 |
Pipe Usage Duration
| 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 |
Practitioner Dk
| 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 |
Protein Intake Adherence Ind
| 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 |
Provider Dk
| 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 |
Sleeping Habits Ind
| 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 |
Sleeping Patterns Improvement Ind
| 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 |
Smoking Cessation Ind
| 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 |
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 |
Tobacco Cessation Duration Unit
| 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 |
Tobacco Cessation Offered Ind
| 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 |
Tobacco Cessation Participant Ind
| 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 |
Tobacco Consumption Unit of Measure
| 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 |
Tobacco Counseled Ind
| 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 |
Tobacco Screened Ind
| 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 |
Tobacco Usage Level Ind
| 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 |
Tobacco Usage Status
| 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 |
Transfat Intake Adherence Ind
| 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 |
Treadmill Exercise Test Ind
| 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 |
Weight Control Ind
| 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 |
Personal Health Information - Health Risk Snapshot_Patient Dimension_FK
| 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 |
Personal Health Information - Health Risk Snapshot_Practitioner Dimension_FK
| 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 |
Personal Health Information - Health Risk Snapshot_Provider Dimension_FK
| 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 |
Personal Health Information - Health Risk Snapshot_Geographic Area Dimension_FK
| 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 |
Personal Health Information - Health Risk Snapshot_Calendar Dimension_FK
| 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 |
Personal Health Information - Health Risk Snapshot_Encounter Dimension_FK
| 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 |
Personal Health Information - Health Risk Snapshot_Condition Dimension_FK
| 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 |
Personal Health Information Health Risk Snapshot PK
| 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 |