Atomic Warehouse Model Data Model

Entity

Entity Health Management Program Detail

Description

A program that is focused on health maintenance or improvement.

For example:
Weight loss program
Fitness program

Attributes
Date of First Session
Date of Last Session
Effective From Dt
Effective To Dt
Followup Frequency Code Sk
Followup Strategy Code Sk
Health Management Program Sk
Incentive Type Code Sk
Load Info Sk
Number of Sessions
Participant Targeting Rule
Participant Targeting Source Code Sk
Participation Fee
Participation Fee Type Code Sk
Program Cost
Program Nm
Program Status Code Sk
Program Type Code Sk
Session Frequency Code Sk
Session Type Code Sk
Source Code Sk
Tenant Sk
Type Code Sk
Valid From Ts
Valid To Ts

Relationship
Health Management Program Detail_Health Management Program_FK

Primary Key
Health Management Program Detail PK

Dependencies

Reverse Dependencies

Attribute Details

Date of First Session

Description	The date upon which the first session within a program begins.
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

Date of Last Session

Description	The date upon which the last session within a program begins.
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

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

Followup Frequency Code Sk

Description	Defines the follow up frequency of Health Management Program.
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

Followup Strategy Code Sk

Description	Approach used to follow up with a patient to reassess their condition. For Example: Clinical assessment by PCP Clinical assessment by specialist Diagnostic tests Self-report via web or phone Surveys
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

Health Management Program Sk

Description	Surrogate key for the anchor entity.
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

Incentive Type Code Sk

Description	The incentive for members to participate in the program. For Example: Bonus Coupon Reduced Premium
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

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

Number of Sessions

Description	The count of sessions in the program.
Data Type	Standards - Data Domains.ddm/Data Domains/Small Counter [SHORT]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Participant Targeting Rule

Description	The business rules for identifying a member for participation. For Example: Two or more encounters with a diagnosis of asthma
Data Type	Standards - Data Domains.ddm/Data Domains/Text Very Large [VARCHAR(2048)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Participant Targeting Source Code Sk

Description	Indicates how the health plan categorizes the target members into condition severity groups. For Example: Claims history Clinical assessment Survey
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

Participation Fee

Description	The financial fee for participation in the health management program.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Participation Fee Type Code Sk

Description	An indication of whether the cost of the program is borne by participants, employers or the health plan itself. For example: Member liability No charge Reimbursed
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

Program Cost

Description	The financial cost of the health management program.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Program Nm

Description	The word or phrase used to identify (but not uniquely) the Health Management Program.
Data Type	Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Program Status Code Sk

Description	An indicator of the stage of a program. For Example: Active Cancelled Complete Initiated Planning Suspended
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

Program Type Code Sk

Description	An indicator of the generic category or type of a program. For Example: Disease Management Prevention and Wellness Smoking Cessation Weight Loss
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

Session Frequency Code Sk

Description	Defines the session frequency of Health Management Program. For example: Once a week Once a month
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

Session Type Code Sk

Description	An indication of how the program is conducted, such as in-person or online. For Example: Group meetings Individual counseling Online chat Self study
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

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

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

Type Code Sk

Description	Identifies the actual type of the entry based on the entity type hierarchy defined in the business data model.
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

Health Management Program Detail_Health Management Program_FK

Is Identifying Relationship	true
Child Table	Health Management Program Detail
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	Health Management Program
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Health Management Program Detail PK

Key Attribute	Valid From Ts
Key Attribute	Health Management Program Sk

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model