Entity Personal Health Information Health Risk Snapshot

DescriptionHealth Risk information related to an individual, captured through health risk assessment, medical record analysis, claim data analysis or otherwise.

Attributes
Alcohol Control IndAlcohol Control Ind
Alcohol Intake Level IndAlcohol Intake Level Ind
Alcohol Intake Unit of MeasureAlcohol Intake Unit of Measure
Blood Pressure Control Adherence IndBlood Pressure Control Adherence Ind
Blood Pressure Monitor Adherence IndBlood Pressure Monitor Adherence Ind
Calendar DkCalendar Dk
Calorie Intake Adherence IndCalorie Intake Adherence Ind
Carbohydrate Intake Adherence IndCarbohydrate Intake Adherence Ind
Cigarette Smoking Cessation DurationCigarette Smoking Cessation Duration
Cigarette Smoking DurationCigarette Smoking Duration
Cigar Smoking Cessation DurationCigar Smoking Cessation Duration
Cigar Usage DurationCigar Usage Duration
Condition DkCondition Dk
Daily Exercise Level IndDaily Exercise Level Ind
Dangerous Activities IndDangerous Activities Ind
Diet IndDiet Ind
Encounter DkEncounter Dk
Exercise Program IndExercise Program Ind
Exercise Tolerance LevelExercise Tolerance Level
Exercise Unit of MeasureExercise Unit of Measure
Family Health Involvement IndFamily Health Involvement Ind
Fiber Diet Adherence IndFiber Diet Adherence Ind
Geographic Area DkGeographic Area Dk
Hypertension Medication Adherence IndHypertension Medication Adherence Ind
Illicit Drug Control IndIllicit Drug Control Ind
Illicit Drug Intake Level IndIllicit Drug Intake Level Ind
Illicit Drug Intake Unit of MeasureIllicit Drug Intake Unit of Measure
Lifestyle IndLifestyle Ind
Load Info SkLoad Info Sk
Low Sodium Diet Adherence IndLow Sodium Diet Adherence Ind
Monounsaturated Fat Control Adherence IndMonounsaturated Fat Control Adherence Ind
Nutrition Counseled IndNutrition Counseled Ind
Patient DkPatient Dk
Physical Activity Counseled IndPhysical Activity Counseled Ind
Pipe Smoking Cessation DurationPipe Smoking Cessation Duration
Pipe Usage DurationPipe Usage Duration
Practitioner DkPractitioner Dk
Protein Intake Adherence IndProtein Intake Adherence Ind
Provider DkProvider Dk
Sleeping Habits IndSleeping Habits Ind
Sleeping Patterns Improvement IndSleeping Patterns Improvement Ind
Smoking Cessation IndSmoking Cessation Ind
Tenant SkTenant Sk
Tobacco Cessation Duration UnitTobacco Cessation Duration Unit
Tobacco Cessation Offered IndTobacco Cessation Offered Ind
Tobacco Cessation Participant IndTobacco Cessation Participant Ind
Tobacco Consumption Unit of MeasureTobacco Consumption Unit of Measure
Tobacco Counseled IndTobacco Counseled Ind
Tobacco Screened IndTobacco Screened Ind
Tobacco Usage Level IndTobacco Usage Level Ind
Tobacco Usage StatusTobacco Usage Status
Transfat Intake Adherence IndTransfat Intake Adherence Ind
Treadmill Exercise Test IndTreadmill Exercise Test Ind
Weight Control IndWeight Control Ind

Relationship
Personal Health Information - Health Risk Snapshot_Patient Dimension_FKPersonal Health Information - Health Risk Snapshot_Patient Dimension_FK
Personal Health Information - Health Risk Snapshot_Practitioner Dimension_FKPersonal Health Information - Health Risk Snapshot_Practitioner Dimension_FK
Personal Health Information - Health Risk Snapshot_Provider Dimension_FKPersonal Health Information - Health Risk Snapshot_Provider Dimension_FK
Personal Health Information - Health Risk Snapshot_Geographic Area Dimension_FKPersonal Health Information - Health Risk Snapshot_Geographic Area Dimension_FK
Personal Health Information - Health Risk Snapshot_Calendar Dimension_FKPersonal Health Information - Health Risk Snapshot_Calendar Dimension_FK
Personal Health Information - Health Risk Snapshot_Encounter Dimension_FKPersonal Health Information - Health Risk Snapshot_Encounter Dimension_FK
Personal Health Information - Health Risk Snapshot_Condition Dimension_FKPersonal Health Information - Health Risk Snapshot_Condition Dimension_FK

Primary Key
Personal Health Information Health Risk Snapshot PKPersonal Health Information Health Risk Snapshot PK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Alcohol Control Ind
DescriptionDegree to which patient complies with limiting alcohol intake.

For example:
H = High
L = Low
M = Medium
N = Non-Compliant
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Alcohol Intake Level Ind
DescriptionThe Alcohol Intake Level Indicator of the Person.

For example:
H = High
L = Low
M = Medium
N = None
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Alcohol Intake Unit of Measure
DescriptionAlcohol Intake Unit of Measure specifies the Unit of Measure in which alcohol intake is expressed.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Blood Pressure Control Adherence Ind
DescriptionIndicates the degree to which the person is conforming to a program of Blood Pressure control.

For example:
H = High
L = Low
M = Medium
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Blood Pressure Monitor Adherence Ind
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Calendar Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Calorie Intake Adherence Ind
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Carbohydrate Intake Adherence Ind
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Cigarette Smoking Cessation Duration
DescriptionThe period of time since the person smoked cigarettes.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Cigarette Smoking Duration
DescriptionThe number of years that the person smoked cigarettes over their lifetime.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Cigar Smoking Cessation Duration
DescriptionThe period of time since the person smoked cigars.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Cigar Usage Duration
DescriptionThe number of years that the person smoked cigars over their lifetime.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Condition Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Daily Exercise Level Ind
DescriptionAmount of daily exercise the person engages in.

For example:
High
Low
Medium
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Dangerous Activities Ind
DescriptionIndication that the person is currently involved in dangerous hobbies or activities.

For example:
Level 3 (Scaffolding Employment)
Level 4 (Competitive Motor Cycle Racing)
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Diet Ind
DescriptionA 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 TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Encounter Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Exercise Program Ind
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Exercise Tolerance Level
DescriptionResults of an exercise test, for example: running on a treadmill.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Decimal [DECIMAL(10,4)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Exercise Unit of Measure
DescriptionExercise Unit of Measure specifies the Unit of Measure in which exercise frequency is expressed.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Family Health Involvement Ind
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Fiber Diet Adherence Ind
DescriptionIndicates the degree to which the person is conforming to a fiber diet.

For example:
H = High
L = Low
M = Medium
N = Non-compliant
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Geographic Area Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Hypertension Medication Adherence Ind
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Illicit Drug Control Ind
DescriptionDegree to which patient complies with avoiding illicit drugs.

For example:
H = High
L = Low
M = Medium
N = Non-Compliant
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Illicit Drug Intake Level Ind
DescriptionIndicates the level at which the person partakes of illicit drugs.

For example:
H = High
L = Low
M = Medium
N = None
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Illicit Drug Intake Unit of Measure
DescriptionIllicit Drug Intake Unit of Measure specifies the Unit of Measure in which illicit drug intake is expressed.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Lifestyle Ind
DescriptionA general indication of the person's lifestyle.

For example:
Active Outgoing
Reclusive
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Low Sodium Diet Adherence Ind
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Monounsaturated Fat Control Adherence Ind
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Nutrition Counseled Ind
DescriptionIndicator that patient received nutrition and diet assessment and advice.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Patient Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Physical Activity Counseled Ind
DescriptionIndicator that patient received an assessment and advice on appropriate levels of physical activity.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pipe Smoking Cessation Duration
DescriptionThe period of time since the person smoked a pipe.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Pipe Usage Duration
DescriptionThe number of years that the person used a pipe over their lifetime.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Practitioner Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Protein Intake Adherence Ind
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Sleeping Habits Ind
DescriptionAn 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 TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Sleeping Patterns Improvement Ind
DescriptionAn 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 TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Smoking Cessation Ind
DescriptionIndicates the status of the person with respect to smoking.

For example:
N = Non-smoker
R = Reducing smoking
S = Smoker
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Tenant Sk
DescriptionThe surrogate key of the entry identifying the legal owner of the data.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Tobacco Cessation Duration Unit
DescriptionTobacco Cessation Duration Unit specifies the Unit of Measure in which tobacco cessation duration is expressed.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Tobacco Cessation Offered Ind
DescriptionIndicator that patient identified as a tobacco user, was offered a place on a tobacco cessation intervention program within a two-year measurement period.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Tobacco Cessation Participant Ind
DescriptionIndicator that patient identified as a tobacco user, received cessation intervention within a two-year measurement period.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Tobacco Consumption Unit of Measure
DescriptionTobacco Consumption Unit of Measure specifies the Unit of Measure in which tobacco consumption is expressed.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Tobacco Counseled Ind
DescriptionIndicator that patient received smoking assessment and advice to stop smoking within a two-year measurement period.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Tobacco Screened Ind
DescriptionIndicator that patient was queried about tobacco use one or more times within a two-year measurement period.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Tobacco Usage Level Ind
DescriptionIndicates the extent of tobacco usage, through all mediums.

For example:
High
Low
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Tobacco Usage Status
DescriptionTobacco Usage Status classifies persons according to whether or not the person is a smoker or tobacco user.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Transfat Intake Adherence Ind
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Treadmill Exercise Test Ind
Descriptionpatient has had treadmill exercise test as recommended.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Weight Control Ind
DescriptionIndicates 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 TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric Small [VARCHAR(6)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Personal Health Information - Health Risk Snapshot_Patient Dimension_FK
Is Identifying Relationshiptrue
Child TablePersonal Health Information Health Risk Snapshot
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePatient Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Personal Health Information - Health Risk Snapshot_Practitioner Dimension_FK
Is Identifying Relationshiptrue
Child TablePersonal Health Information Health Risk Snapshot
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePractitioner Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Personal Health Information - Health Risk Snapshot_Provider Dimension_FK
Is Identifying Relationshiptrue
Child TablePersonal Health Information Health Risk Snapshot
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableProvider Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Personal Health Information - Health Risk Snapshot_Geographic Area Dimension_FK
Is Identifying Relationshiptrue
Child TablePersonal Health Information Health Risk Snapshot
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableGeographic Area Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Personal Health Information - Health Risk Snapshot_Calendar Dimension_FK
Is Identifying Relationshiptrue
Child TablePersonal Health Information Health Risk Snapshot
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableCalendar Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Personal Health Information - Health Risk Snapshot_Encounter Dimension_FK
Is Identifying Relationshiptrue
Child TablePersonal Health Information Health Risk Snapshot
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableEncounter Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Personal Health Information - Health Risk Snapshot_Condition Dimension_FK
Is Identifying Relationshiptrue
Child TablePersonal Health Information Health Risk Snapshot
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableCondition Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Primary Key Details

 Personal Health Information Health Risk Snapshot PK
Key AttributePatient Dk
Key AttributePractitioner Dk
Key AttributeProvider Dk
Key AttributeGeographic Area Dk
Key AttributeCalendar Dk
Key AttributeEncounter Dk
Key AttributeCondition Dk