NAV

Longitudinal Plan EDW Schema v1

Overview

The Longitudinal Plan enterprise data warehouse (EDW) bundle contains files that make up a patient’s longitudinal plan in HealtheEDW.

See the Longitudinal Plan EDW Feed Type page for more information about how to process the feed type and how the feed type is designed.

Character Separated Values (CSV) Properties

Property Value
Header Record Yes
Field Delimiter Comma
Record Delimiter CR/LF
Character Encoding UTF-8

Files

File Name Description
PH_D_LP_Activity_Content This table contains activity content.
PH_D_LP_Activity_Content_Coding This table contains coding for activity content.
PH_D_LP_Activity_Category_Content This table contains activity category content.
PH_D_LP_Activity_Content_Target This table contains activity content target information.
PH_D_LP_Activity_Target_Group_Content This table contains activity content group target information.
PH_D_LP_Activity_Target_Group_Target_Content This table contains activity content group target content.
PH_D_LP_Activity_Content_Ext_Identifier This table contains activity content external identifiers.
PH_D_LP_Activity_Content_Int_Identifier This table contains activity content internal identifiers.
PH_D_LP_Activity_Content_Discipline This table contains activity content disciplines.
PH_F_LP_Activity This table contains references to activity information.
PH_F_LP_Activity_History This table contains historical information about revisions to the activity.
PH_F_LP_Activity_Target This table contains information about activity targets.
PH_F_LP_Activity_Target_Group This table contains information about activity group targets.
PH_F_LP_Activity_Target_Group_Target This table contains information about activity target group targets.
PH_F_LP_Activity_Int_Identifier This table contains activity internal identifiers.
PH_F_LP_Activity_Ext_Identifier This table contains activity external identifiers.
PH_F_LP_Activity_Category This table contains information about activity categories.
PH_F_LP_Activity_Discipline This table contains information about activity disciplines.
PH_F_LP_Activity_Goal This table contains information about activity goals.
PH_F_LP_Activity_Performer This table contains information about activity performers.
PH_F_LP_Activity_Note This table contains information about activity notes.
PH_F_LP_Health_Concern_Activity This table contains information about health concern activities.
PH_D_LP_Category_Content This table contains category content.
PH_D_LP_Category_Content_Coding This table contains the category content coding.
PH_D_LP_Discipline_Content This table contains discipline content.
PH_D_LP_Discipline_Content_Coding This table contains the discipline content coding.
PH_D_LP_Goal_Barrier_Definition This table contains information about goal barrier definitions.
PH_D_LP_Goal_Barrier_Definition_Coding This table contains goal barrier definition coding.
PH_D_LP_Goal_Content This table contains goal content.
PH_D_LP_Goal_Content_Coding This table contains goal content coding.
PH_D_LP_Goal_Category_Content This table contains goal category content.
PH_D_LP_Goal_Content_Target This table contains information about goal content targets.
PH_D_LP_Goal_Target_Group_Content This table contains goal target group content.
PH_D_LP_Goal_Target_Group_Target_Content This table contains goal target group target content.
PH_D_LP_Goal_Content_Discipline This table contains information about goal content disciplines.
PH_F_LP_Goal This table contains information about a goal.
PH_F_LP_Goal_Owner This table contains information about a goal owner.
PH_F_LP_Health_Concern_Goal This table contains information about health concern goals.
PH_F_LP_Goal_Note This table contains information about goal notes.
PH_F_LP_Goal_Category This table contains information about goal categories.
PH_F_LP_Goal_Discipline This table contains information about goal disciplines.
PH_F_LP_Goal_Target This table contains information about goal targets.
PH_F_LP_Goal_Target_Group This table contains information about goal target groups.
PH_F_LP_Goal_Target_Group_Target This table contains information about goal target group targets.
PH_F_LP_Goal_Goal_Relation This table contains goal to goal relations.
PH_F_LP_Goal_History This table contains information about goal history.
PH_F_LP_Goal_Barrier This table contains information about goal barriers.
PH_F_LP_Goal_Barrier_Coding This table contains goal barrier coding.
PH_F_HC_Health_Concern This table contains information about health concerns.
PH_F_HC_Coding This table contains health concern coding.
PH_D_HC_Definition This table contains information about health concern definitions.
PH_F_HC_Note This table contains information about health concern notes.
PH_F_HC_Health_Concern_History This table contains information about the update history of health concerns.
PH_F_LPT_Care_Plan This table contains information about care plans.
PH_F_LPT_Care_Plan_Relation This table contains care plan relations.
PH_F_PSM_MeasureSuggestionDefinition This table contains information about measure suggestion definitions.
PH_F_S_Strength This table contains information about strengths.
PH_D_S_Strength_Definition This table contains information about strength definitions.

Field Definitions

PH_D_LP_Activity_Content

Field Data Type Definition
activity_content_id STRING 32 The ID of the activity content.
tenant_id STRING 60 The Tenant ID associated with the activity content.
text STRING 100 The text of the activity content.
status STRING 8 The current status of the activity definition. The following statuses are possible: ACTIVE: Indicates that the definition can be used when adding the resource to the plan. INACTIVE: Indicates that the definition cannot be used when adding the resource to the plan.

PH_D_LP_Activity_Content_Coding

Field Data Type Definition
code_id STRING 60 The ID of the code.
code_display STRING 100 The human-readable representation of the code.
code_system STRING 100 The ID of the coding system that gives meaning to the code.
activity_content_id STRING 32 The ID of the activity content.
id_uuid STRING 32 The UUID of the activity content coding.

PH_D_LP_Activity_Category_Content

Field Data Type Definition
activity_content_id STRING 32 The ID of the activity content.
category_content_id STRING 32 The ID of the category content.

PH_D_LP_Activity_Content_Target

Field Data Type Definition
activity_content_id STRING 32 The ID of the activity content.
boolean_value STRING 10 Indicates whether the measure type should be met.
measure_concept_alias STRING 1000 The alias of the concept in the context for the unit of measure.
measure_context_id STRING 60 The ID of the context for the unit of measure.
numeric_operator STRING 10 The operator that indicates how the measure type value can be evaluated.
numeric_value_decimal BIGDECIMAL 12 The numeric value of the measure type, which can include a decimal.
range_high_decimal BIGDECIMAL 12 The inclusive upper boundary of the range, which can include a decimal.
range_low_decimal BIGDECIMAL 12 The inclusive lower boundary of the range, which can include a decimal.
detail_type STRING 50 Indicates the type of detail provided.
measure_type_description STRING 1000 A textual description of the measure type.
unit_description STRING 1000 A textual description of the unit of measure.
unit_context_id STRING 60 The ID of the context for the unit of measure.
unit_concept_alias STRING 1000 The alias of the concept in the context for the unit of measure.
id_uuid STRING 32 The UUID of the activity content target.

PH_D_LP_Activity_Target_Group_Content

Field Data Type Definition
id STRING 32 The target group content ID.
name STRING 1000 The target group name.
activity_content_id STRING 32 The ID of the activity content.
list_index INT Field for indexing.

PH_D_LP_Activity_Target_Group_Target_Content

Field Data Type Definition
group_id STRING 32 The ID of the target group.
measure_context_id STRING 60 The ID of the context for the unit of measure.
measure_concept_alias STRING 1000 The alias of the concept in the context for the unit of measure.
boolean_value STRING 10 Indicates whether the measure type should be met.
numeric_operator STRING 10 The operator that indicates how the measure type value can be evaluated.
numeric_value_decimal BIGDECIMAL 12 The numeric value of the measure type, which can include a decimal.
range_high_decimal BIGDECIMAL 12 The inclusive upper boundary of the range, which can include a decimal.
range_low_decimal BIGDECIMAL 12 The inclusive lower boundary of the range, which can include a decimal.
detail_type STRING 50 Indicates the type of detail provided.
unit_description STRING 1000 A textual description of the unit of measure.
unit_context_id STRING 60 The ID of the context for the unit of measure.
unit_concept_alias STRING 1000 The alias of the concept in the context for the unit of measure.
measure_type_description STRING 1000 A textual description of the measure type.
id_uuid STRING 32 The UUID of the activity target group target content.
list_index INT Field for indexing.

PH_D_LP_Activity_Content_Ext_Identifier

Field Data Type Definition
activity_content_id STRING 32 The ID of the activity content.
external_id STRING 100 The ID of the resource in the system namespace.
system STRING 1000 The namespace that contains the resource.
id_uuid STRING 32 The UUID of the activity content external identifier.

PH_D_LP_Activity_Content_Int_Identifier

Field Data Type Definition
activity_content_id STRING 32 The ID of the activity content.
internal_id STRING 100 The ID of the resource in Oracle Health Data Intelligence.
kind STRING 1000 A description of the type of referenced resource.
id_uuid STRING 32 The UUID of the activity content internal identifier.

PH_D_LP_Activity_Content_Discipline

Field Data Type Definition
activity_content_id STRING 32 The ID of the activity content.
discipline_content_id STRING 32 The ID of the discipline content.

PH_F_LP_Activity

Field Data Type Definition
activity_id STRING 32 The ID of the activity.
version INT The current version of the activity.
source_id STRING 100 The source ID identifies an entity that is unique in a Health Data Intelligence data partition.
source_data_partition STRING 36 The source data partition location.
description STRING 1000 The textual description of the activity.
definition_id STRING 32 The ID of the activity definition.
definition_text STRING 100 The short textual description of the activity definition.
status STRING 20 Indicates the current state of the activity. Currently, the following statuses are possible: - NOT_STARTED: Indicates that the activity has yet to begin. - IN_PROGRESS: Indicates that the activity began and is ongoing. - COMPLETED: Indicates that the activity is in a final state of completion. - CANCELLED: Indicates that the activity will no longer take place. - SUSPENDED: Indicates that the activity is on hold. - SCHEDULED: Indicates that the activity has been scheduled but has not yet begun. - PROPOSED: Indicates that the activity is proposed. - ACCEPTED: Indicates that the activity is accepted or acknowledged. - REJECTED: Indicates that the activity is rejected. - IN_ERROR: Indicates that the activity was mistakenly identified.
status_reason STRING 100 A textual representation of the reason the activity is in its current status.
created_by STRING 36 The individual who entered the activity into the system.
created_by_type STRING 20 The type of the activity creator.
created_by_display STRING 1000 The human-readable representation of the activity creator.
created_at TIMESTAMP The ISO 8601date and time when the activity was initially entered into the system.
updated_by STRING 36 A representation of the individual who last modified the activity in the system.
updated_by_type STRING 20 The type of the activity updater.
updated_by_display STRING 1000 The human-readable representation of the activity updater.
updated_at TIMESTAMP The ISO 8601 date and time when the activity was updated.
duration INT The duration of the activity.
duration_unit STRING 255 The unit of the activity duration.
frequency INT The frequency of the activity.
period INT The period of the activity.
period_unit STRING 255 The unit of the activity period.
started_dt STRING 10 The date when the activity began or is planned to begin.
end_dt STRING 10 The date when the activity was or is planned to be completed.
tenant_id STRING 60 The tenant ID of the activity.
consumer_id STRING 60 The ID of the consumer.
encounter_id STRING 100 The ID of the encounter.
encounter_data_partition STRING 36 The encounter data partition.
upd_encounter_id STRING 100 The encounter ID of an activity update.
upd_encounter_data_partition STRING 36 The encounter data partition of an activity update.
supporting_information STRING 1000 The textual supporting information of the activity.
source_template_id STRING 32 The ID of the source template.

PH_F_LP_Activity_History

Field Data Type Definition
activity_id STRING 32 The ID of the activity.
status STRING 20 The status of the activity. The following statuses are possible: - NOT_STARTED: Indicates that the activity has not yet begun. - IN_PROGRESS: Indicates that the activity has begun and is ongoing. - COMPLETED: Indicates that the activity is in a final state of completion. - CANCELLED: Indicates that the activity will no longer occur. - SUSPENDED: Indicates that the activity is on hold. - SCHEDULED: Indicates that the activity is scheduled but has not yet begun. - PROPOSED: Indicates that the activity is proposed. - ACCEPTED: Indicates that the activity is accepted or acknowledged. - REJECTED: Indicates that the activity is rejected. - IN_ERROR: Indicates that the activity was mistakenly identified.
updated_by STRING 36 The individual who last modified the activity history.
updated_by_type STRING 20 The type of the activity history updator.
updated_by_display STRING 1000 The human-readable representation of the activity history updater.
updated_at TIMESTAMP The ISO 8601 date and time when the activity history was updated.
status_mod BOOLEAN This is used for internal purposes.
tenant_id STRING 60 The ID of the tenant.
consumer_id STRING 60 The ID of the consumer.

PH_F_LP_Activity_Target

Field Data Type Definition
activity_id STRING 32 The ID of the activity.
measure_context_id STRING 60 The ID of the context for the unit of measure.
measure_concept_alias STRING 1000 The alias of the concept in the context for the unit of measure.
boolean_value STRING 10 This is used for internal purposes.
numeric_operator STRING 10 The operator that indicates how the measure type value can be evaluated.
numeric_value_decimal BIGDECIMAL 12 The numeric value of the measure type, which can include a decimal.
range_high_decimal BIGDECIMAL 12 The inclusive upper boundary of the range, which can include a decimal.
range_low_decimal BIGDECIMAL 12 The inclusive lower boundary of the range, which can include a decimal.
unit_description STRING 1000 A textual description of the unit of measure.
unit_context_id STRING 60 The ID of the context for the unit of measure.
unit_concept_alias STRING 1000 The alias of the concept in the context for the unit of measure.
measure_type_description STRING 1000 A textual description of the measure type.
id_uuid STRING 32 The UUID of the activity target.

PH_F_LP_Activity_Target_Group

Field Data Type Definition
id STRING 32 The ID of the target group.
name STRING 1000 The target group name.
activity_id STRING 32 The ID of the activity.
list_index INT Field for indexing.

PH_F_LP_Activity_Target_Group_Target

Field Data Type Definition
group_id STRING 32 The ID of the group.
measure_context_id STRING 60 The ID of the context for the unit of measure.
measure_concept_alias STRING 1000 The alias of the concept in the context for the unit of measure.
boolean_value STRING 10 This is used for internal purposes.
numeric_operator STRING 10 The operator that indicates how the measure type value can be evaluated.
numeric_value_decimal BIGDECIMAL 12 The numeric value of the measure type, which can include a decimal.
range_high_decimal BIGDECIMAL 12 The inclusive upper boundary of the range, which can include a decimal.
range_low_decimal BIGDECIMAL 12 The inclusive lower boundary of the range, which can include a decimal.
unit_description STRING 1000 A textual description of the unit of measure.
unit_context_id STRING 60 The ID of the context for the unit of measure.
unit_concept_alias STRING 1000 The alias of the concept in the context for the unit of measure.
measure_type_description STRING 1000 A textual description of the measure type.
id_uuid STRING 32 The UUID of the activity target group target.
list_index INT Field for indexing.

PH_F_LP_Activity_Int_Identifier

Field Data Type Definition
activity_id STRING 32 The ID of the activity.
internal_id STRING 100 The ID of the resource in Health Data Intelligence.
kind STRING 1000 A description of the type of referenced resource.
id_uuid STRING 32 The UUID of the activity internal identifier.

PH_F_LP_Activity_Ext_Identifier

Field Data Type Definition
activity_id STRING 32 The ID of the activity.
external_id STRING 100 The ID of the resource in the system namespace.
system STRING 1000 The namespace that contains the resource.
id_uuid STRING 32 The UUID of the activity external identifier.

PH_F_LP_Activity_Category

Field Data Type Definition
activity_id STRING 32 The ID of the activity.
category_code_id STRING 32 The ID of the category code.
codeable_concept_text STRING 100 Describes the activity category. Includes a text description of the activity category and possibly a set of codings.
id_uuid STRING 32 The UUID of the activity category.

PH_F_LP_Activity_Discipline

Field Data Type Definition
activity_id STRING 32 The ID of the activity.
discipline_code_id STRING 32 The ID of the discipline code.
codeable_concept_text STRING 100 Describes the activity discipline. Includes a text description of the activity discipline and possibly a set of codings.
id_uuid STRING 32 The UUID of the activity discipline.

PH_F_LP_Activity_Goal

Field Data Type Definition
activity_id STRING 32 The ID of the activity.
goal_id STRING 32 The ID of the goal.
created_at TIMESTAMP The ISO 8601 date and time when the activity was initially entered into the system.
updated_at TIMESTAMP The ISO 8601 date and time when the activity goal was updated.
id_uuid STRING 32 The UUID of the activity goal.

PH_F_LP_Activity_Performer

Field Data Type Definition
activity_id STRING 32 The ID of the activity.
performer_id STRING 36 The ID of the performer.
performer_type STRING 20 The type of the activity performer.
performer_display STRING 1000 The human-readable representation of the activity performer.
id_uuid STRING 32 The UUID of the activity performer.

PH_F_LP_Activity_Note

Field Data Type Definition
activity_note_id STRING 32 The ID of the activity note.
activity_id STRING 32 The ID of the activity.
created_by STRING 36 The individual who entered the activity note into the system.
created_by_type STRING 20 The type of the activity note creator.
created_by_display STRING 1000 The human-readable representation of the activity note creator.
created_at TIMESTAMP The ISO 8601 date and time when the activity note was initially entered into the system.
updated_by STRING 36 The individual who last updated the activity note.
updated_by_type STRING 20 The type of the activity note updater.
updated_by_display STRING 1000 The human-readable representation of the activity note updater.
updated_at TIMESTAMP The ISO 8601 date and time when the activity note was updated.
version INT The current version of the activity note.
text STRING 100 The text of the activity note.
status STRING 20 The status of the note.

PH_F_LP_Health_Concern_Activity

Field Data Type Definition
activity_id STRING 32 The ID of the activity.
health_concern_id STRING 32 The ID of the health concern.
created_at TIMESTAMP The ISO 8601 date and time when the health concern activity was created.
updated_at TIMESTAMP The ISO 8601 date and time when the health concern activity was updated.
id_uuid STRING 32 The UUID of the health concern activity.

PH_D_LP_Category_Content

Field Data Type Definition
category_content_id STRING 32 The ID of the category content.
tenant_id STRING 60 The ID of the tenant.
text STRING 100 A textual description for the category.
status STRING 8 The current status of the category. The following statuses are possible: - ACTIVE: Indicates that the category is active and can be assigned to a resource. - INACTIVE: Indicates that the category is inactive and cannot be assigned to a resource.

PH_D_LP_Category_Content_Coding

Field Data Type Definition
category_content_coding_id STRING 20 The ID of the category content coding.
code_id STRING 60 The ID of the category content code.
code_display STRING 100 The human-readable representation of the code.
code_system STRING 100 The ID of the coding system that gives meaning to the code.
category_content_id STRING 32 The ID of the category content.
id_uuid STRING 32 The UUID of the category content coding.

PH_D_LP_Discipline_Content

Field Data Type Definition
discipline_content_id STRING 32 The ID of the discipline content.
tenant_id STRING 60 The ID of the tenant.
text STRING 100 A textual description for the discipline.
status STRING 20 The current status of the discipline. The following statuses are possible: - ACTIVE: Indicates that the discipline is active and can be assigned to a resource. - INACTIVE: Indicates that the discipline is inactive and cannot be assigned to a resource.
version INT The current version of the discipline.

PH_D_LP_Discipline_Content_Coding

Field Data Type Definition
discipline_content_coding_id STRING 20 The ID of the discipline content coding.
code_id STRING 60 The ID of the code.
code_display STRING 100 The human-readable representation of the code.
code_system STRING 100 The ID of the coding system that gives meaning to the code.
discipline_content_id STRING 32 The ID of the discipline content.
discipline_content_coding_id_uuid STRING 32 The UUID of the discipline content coding.

PH_D_LP_Goal_Barrier_Definition

Field Data Type Definition
id STRING 32 The ID of the goal barrier definition.
tenant_id STRING 60 The ID of the tenant.
created_dt_tm TIMESTAMP The ISO 8601 date and time when the goal barrier definition was created.
updated_dt_tm TIMESTAMP The ISO 8601 date and time when the goal barrier definition was last updated.
status STRING 20 The status of the goal barrier definition.
text STRING 1000 The textual description of the goal definition.
version INT The latest version of the goal barrier definition.
context_id STRING 60 The ID of the context.
concept_alias STRING 1000 The most applicable concept to use for coding purposes when instantiating the defined barrier definition.

PH_D_LP_Goal_Barrier_Definition_Coding

Field Data Type Definition
goal_barrier_definition_id STRING 32 The ID of the goal barrier definition.
tenant_id STRING 60 The ID of the tenant.
code_id STRING 60 The ID of the code.
code_system STRING 100 The ID of the coding system that gives meaning to the code.
id_uuid STRING 32 The UUID of the goal barrier definition coding.

PH_D_LP_Goal_Content

Field Data Type Definition
goal_content_id STRING 32 The ID of the goal content.
tenant_id STRING 60 The ID of the tenant.
text STRING 100 The textual description of the goal content.
status STRING 8 The status of the goal content.

PH_D_LP_Goal_Content_Coding

Field Data Type Definition
code_id STRING 60 The ID of the coding.
code_display STRING 100 The human-readable representation of the code.
code_system STRING 100 The ID of the coding system that gives meaning to the code.
goal_content_id STRING 32 The ID of the goal content.
id_uuid STRING 32 The UUID of the goal content coding.

PH_D_LP_Goal_Category_Content

Field Data Type Definition
goal_content_id STRING 32 The ID of the goal content.
category_content_id STRING 32 The ID of the category content.

PH_D_LP_Goal_Content_Target

Field Data Type Definition
goal_content_id STRING 32 The ID of the goal content.
boolean_value STRING 10 This is used for internal purposes.
measure_concept_alias STRING 1000 The alias of the concept in the context for the unit of measure.
measure_context_id STRING 60 The ID of the context for the unit of measure.
numeric_operator STRING 10 The operator that indicates how the measure type value can be evaluated.
numeric_value_decimal BIGDECIMAL 12 The numeric value of the measure type, which can include a decimal.
range_high_decimal BIGDECIMAL 12 The inclusive upper boundary of the range, which can include a decimal.
range_low_decimal BIGDECIMAL 12 The inclusive lower boundary of the range, which can include a decimal.
detail_type STRING 50 Indicates the type of detail provided.
measure_type_description STRING 1000 A textual description of the measure type.
unit_description STRING 1000 A textual description of the unit of measure.
unit_context_id STRING 60 The ID of the context for the unit of measure.
unit_concept_alias STRING 1000 The alias of the concept in the context for the unit of measure.
id_uuid STRING 32 The UUID of the goal content target.

PH_D_LP_Goal_Target_Group_Content

Field Data Type Definition
id STRING 32 The ID of the goal target group content.
name STRING 1000 The goal target group name.
goal_content_id STRING 32 The ID of the goal content.
list_index INT Field for indexing.

PH_D_LP_Goal_Target_Group_Target_Content

Field Data Type Definition
group_id STRING 32 The ID of the group.
measure_context_id STRING 60 The ID of the context for the unit of measure.
measure_concept_alias STRING 1000 The alias of the concept in the context for the unit of measure.
boolean_value STRING 10 This is used for internal purposes.
numeric_operator STRING 10 The operator that indicates how the measure type value can be evaluated.
numeric_value_decimal BIGDECIMAL 12 The numeric value of the measure type, which can include a decimal.
range_high_decimal BIGDECIMAL 12 The inclusive upper boundary of the range, which can include a decimal.
range_low_decimal BIGDECIMAL 12 The inclusive lower boundary of the range, which can include a decimal.
detail_type STRING 50 Indicates the type of detail provided.
unit_description STRING 1000 A textual description of the unit of measure.
unit_context_id STRING 60 The ID of the context for the unit of measure.
unit_concept_alias STRING 1000 The alias of the concept in the context for the unit of measure.
measure_type_description STRING 1000 A textual description of the measure type.
id_uuid STRING 32 The UUID of the goal target group target content.
list_index INT Field for indexing.

PH_D_LP_Goal_Content_Discipline

Field Data Type Definition
goal_content_id STRING 32 The ID of the goal content.
discipline_content_id STRING 32 The ID of the discipline content.

PH_F_LP_Goal

Field Data Type Definition
goal_id STRING 32 The ID of the goal.
consumer_id STRING 60 The ID of the consumer.
version INT The latest version of the goal.
description STRING 1000 The textual description of the goal.
status STRING 20 Indicates the current state of the goal. Currently, the following statuses are possible: - PLANNED: Indicates that the goal is planned but is not yet being pursued. - IN_PROGRESS: Indicates that the goal is being pursued and is ongoing. - CANCELLED: Indicates that the goal will no longer be pursued. - IN_ERROR: Indicates that the goal was mistakenly identified. - PROPOSED: Indicates that the goal is proposed. - ACCEPTED: Indicates that the goal is accepted or acknowledged. - REJECTED: Indicates that the goal is rejected. - SUSPENDED: Indicates that the goal is on hold. - COMPLETED: Indicates that the goal is in a final state of completion.
progress STRING 20 Indicates an assessment of the patient’s progress toward a goal. Currently, the following statuses are possible: - AT_TARGET: Indicates that the patient is currently meeting the goal and will continue to work toward maintaining it. - PROGRESSING: Indicates that the patient is progressing toward the goal or is doing better than they were previously. - REGRESSING: Indicates that the patient is doing worse than they were previously. - ACHIEVED: Indicates that the patient met the goal. - NOT_ACHIEVED: Indicates that the patient did not meet the goal.
status_reason STRING 100 A text representation of the reason the goal is in its current status.
started_dt STRING 10 The ISO 8601 date when the individual begins making progress on the goal.
due_dt STRING 10 The ISO 8601 date when the goal should be completed.
created_by STRING 36 The individual who entered the goal into the system.
created_by_type STRING 20 The type of the goal creator.
created_by_display STRING 1000 The human-readable representation of the goal creator.
created_at TIMESTAMP The ISO 8601 date and time when the goal was initially entered into the system.
updated_by STRING 36 A representation of the individual who last modified the goal in the system.
updated_by_type STRING 20 The type of the goal updater.
updated_by_display STRING 1000 The human-readable representation of the goal updater.
updated_at TIMESTAMP The ISO 8601 date and time when the goal was last modified.
expressed_by_id STRING 32 The ID of the individual responsible for initially establishing or expressing the goal.
expressed_by_type STRING 32 The type of the goal expresser.
expressed_by_display STRING 32 The human-readable representation of the goal expresser.
tenant_id STRING 60 The ID of the tenant.
definition_id STRING 32 The ID of the goal definition that was referenced when the goal was first created.
definition_text STRING 100 The textual description of the goal definition.
priority INT The field is deprecated. The ‘priorityCategory’ should be used instead. A numeric value defining the importance relative to other goals.
source_id STRING 100 The ID of the source.
encounter_id STRING 100 The ID of the encounter.
encounter_data_partition STRING 36 The encounter data partition of the goal.
upd_encounter_id STRING 100 The encounter ID of a goal update.
upd_encounter_data_partition STRING 36 The encounter data partition of a goal update.
priority_category STRING 20 The priority of a goal. Possible values are HIGH, MEDIUM, LOW.
source_data_partition STRING 36 The source data partition of the goal.
progress_start_dt_tm TIMESTAMP The ISO 8601 date and time when progress was initiated for a goal.
source_template_id STRING 32 The ID of the source template.

PH_F_LP_Goal_Owner

Field Data Type Definition
owner_id STRING 36 The ID of the goal owner.
goal_id STRING 32 The ID of the goal.
owner_type STRING 20 The type of the owner.
owner_display STRING 1000 The human-readable representation of the goal owner.
id_uuid STRING 32 The UUID of the goal owner.

PH_F_LP_Health_Concern_Goal

Field Data Type Definition
health_concern_id STRING 32 The ID of the health concern.
goal_id STRING 32 The ID of the goal.
created_at TIMESTAMP The ISO 8601 date and time when the health concern goal was initially entered into the system.
updated_at TIMESTAMP The ISO 8601 date and time when the health concern goal was last modified.
id_uuid STRING 32 The UUID of the health concern goal.

PH_F_LP_Goal_Note

Field Data Type Definition
goal_note_id STRING 32 The ID of the goal note.
goal_id STRING 32 The ID of the goal.
created_by STRING 36 The individual who entered the goal note into the system.
created_by_type STRING 20 The type of the goal note creator.
created_by_display STRING 1000 The human-readable representation of the goal note creator.
created_at TIMESTAMP The ISO 8601 date and time when the goal note was initially entered into the system.
updated_by STRING 36 A representation of the individual who last modified the goal note in the system.
updated_by_type STRING 20 The type of the goal note updater.
updated_by_display STRING 1000 The human-readable representation of the goal note updater.
updated_at TIMESTAMP The ISO 8601 date and time when the goal note was last modified.
version INT The latest version of the goal note.
text STRING 100 A human-readable, potentially personalized description of the goal note.
status STRING 20 The status of the goal note.

PH_F_LP_Goal_Category

Field Data Type Definition
goal_id STRING 32 The ID of the goal.
codeable_concept_text STRING 100 Describes the goal category. Includes a text description of the activity discipline and possibly a set of codings.
category_code_id STRING 32 The ID of the category code.
id_uuid STRING 32 The UUID of the goal category.

PH_F_LP_Goal_Discipline

Field Data Type Definition
goal_id STRING 32 The ID of the goal.
codeable_concept_text STRING 100 Describes the goal discipline. Includes a text description of the activity discipline and possibly a set of codings.
discipline_code_id STRING 32 The ID of the discipline code.
id_uuid STRING 32 The UUID of the goal discipline.

PH_F_LP_Goal_Target

Field Data Type Definition
goal_id STRING 32 The ID of the goal.
measure_context_id STRING 60 The ID of the context of the unit of measure.
measure_concept_alias STRING 1000 The alias of the concept in the context of the unit of measure.
boolean_value STRING 10 This is used for internal purposes.
numeric_operator STRING 10 The operator that indicates how the measure type value can be evaluated.
numeric_value_decimal BIGDECIMAL 12 The numeric value of the measure type, which can include a decimal.
range_high_decimal BIGDECIMAL 12 The inclusive upper boundary of the range, which can include a decimal.
range_low_decimal BIGDECIMAL 12 The inclusive lower boundary of the range, which can include a decimal.
unit_description STRING 1000 A textual description of the unit of measure.
unit_context_id STRING 60 The ID of the context for the unit of measure.
unit_concept_alias STRING 1000 The alias of the concept in the context for the unit of measure.
measure_type_description STRING 1000 A textual description of the measure type.
id_uuid STRING 32 The UUID of the goal target.

PH_F_LP_Goal_Target_Group

Field Data Type Definition
id STRING 32 The ID of the goal target group.
name STRING 1000 The goal target group name.
goal_id STRING 32 The ID of the goal.
list_index INT Field for indexing.

PH_F_LP_Goal_Target_Group_Target

Field Data Type Definition
group_id STRING 32 The ID of the group.
measure_context_id STRING 60 The ID of the context for the unit of measure.
measure_concept_alias STRING 1000 The alias of the concept in the context of the unit of measure.
boolean_value STRING 10 This is used for internal purposes.
numeric_operator STRING 10 The operator that indicates how the measure type value can be evaluated.
numeric_value_decimal BIGDECIMAL 12 The numeric value of the measure type, which can include a decimal.
range_high_decimal BIGDECIMAL 12 The inclusive upper boundary of the range, which can include a decimal.
range_low_decimal BIGDECIMAL 12 The inclusive lower boundary of the range, which can include a decimal.
unit_description STRING 1000 A textual description of the unit of measure.
unit_context_id STRING 60 The ID of the context for the unit of measure.
unit_concept_alias STRING 1000 The alias of the concept in the context for the unit of measure.
measure_type_description STRING 1000 A textual description of the measure type.
id_uuid STRING 32 The UUID of the goal target group target.
list_index INT Field for indexing.

PH_F_LP_Goal_Goal_Relation

Field Data Type Definition
parent_goal_id STRING 32 The ID of the parent goal.
child_goal_id STRING 32 The ID of the child goal.
created_at TIMESTAMP The ISO 8601 date and time when the goal to goal relation was initially entered into the system.
updated_at TIMESTAMP The ISO 8601 date and time when the goal to goal relation was last modified.
id_uuid STRING 32 The UUID of the goal to goal relation.

PH_F_LP_Goal_History

Field Data Type Definition
goal_id STRING 32 The ID of the goal.
status STRING 20 The status of the goal. The following statuses are possible: - PLANNED: Indicates that the goal is planned but is not yet being pursued. - IN_PROGRESS: Indicates that the goal is being pursued and is ongoing. - CANCELLED: Indicates that the goal will no longer be pursued. - IN_ERROR: Indicates that the goal was mistakenly identified. - PROPOSED: Indicates that the goal is proposed. - ACCEPTED: Indicates that the goal is accepted or acknowledged. - REJECTED: Indicates that the goal is rejected. - SUSPENDED: Indicates that the goal is on hold. - COMPLETED: Indicates that the goal is in a final state of completion.
updated_by STRING 36 A representation of the individual who last modified the goal history in the system.
updated_by_type STRING 20 The type of the goal history updater.
updated_by_display STRING 1000 The human-readable representation of the goal history updater.
updated_at TIMESTAMP The ISO 8601 date and time when the goal history was last modified.
status_mod BOOLEAN This is used for internal purposes.
tenant_id STRING 60 The ID of the tenant.
consumer_id STRING 60 The ID of the consumer.
progress_start_dt_tm TIMESTAMP The ISO 8601 date and time when progress was initiated for a goal.

PH_F_LP_Goal_Barrier

Field Data Type Definition
id STRING 32 The ID of the goal barrier.
tenant_id STRING 60 The ID of the tenant.
goal_id STRING 32 The ID of the goal.
status STRING 20 Indicates the current state of the barrier. Currently, the following statuses are possible: - INACTIVE: Indicates that the barrier no longer exists. - ACTIVE: Indicates that the barrier is currently evident.
text STRING 1000 A human-readable, potentially personalized description of the barrier.
context_id STRING 60 The ID of the context.
definition_id STRING 32 The ID of the definition.
definition_text STRING 1000 The text description of the barrier definition.
concept_alias STRING 1000 The most applicable concept to use for coding purposes when instantiating the defined barrier definition.
created_by STRING 36 The individual who entered the goal barrier into the system.
created_by_type STRING 20 The type of the goal barrier creator.
created_dt_tm TIMESTAMP The ISO 8601 date and time when the goal barrier was created.
created_by_display STRING 32 The human-readable representation of the goal barrier creator.
updated_by STRING 60 A representation of the individual who last modified the goal barrier in the system.
updated_by_type STRING 20 The type of the goal barrier updater.
updated_by_display STRING 1000 The human-readable representation of the goal barrier updater.
updated_dt_tm TIMESTAMP The ISO 8601 date and time when the goal barrier was updated.
version INT The latest version of the goal barrier.

PH_F_LP_Goal_Barrier_Coding

Field Data Type Definition
goal_barrier_id STRING 32 The ID of the goal barrier.
tenant_id STRING 60 The ID of the tenant.
code_id STRING 60 The ID of the code.
code_system STRING 100 The ID of the coding system that gives meaning to the code.
id_uuid STRING 32 The UUID of the goal barrier coding.

PH_F_HC_Health_Concern

Field Data Type Definition
health_concern_id STRING 32 The ID of the health concern.
version INT The latest version of the health concern.
consumer_id STRING 36 The ID of the consumer.
tenant_id STRING 36 The ID of the tenant.
text STRING 1000 A human-readable, potentially personalized description of the health concern.
health_concern_definition_id STRING 32 The ID of the health concern definition.
status STRING 20 The current status of the health concern. The following statuses are possible: - ACCEPTED: Indicates that the health concern was accepted or acknowledged. - ACTIVE: Indicates that signs or symptoms of the health concern are currently evident. - IN_ERROR: Indicates that the health concern was mistakenly identified. - PROPOSED: Indicates that the health concern was proposed. - REJECTED: Indicates that the health concern was rejected. - RELAPSE: Indicates that signs or symptoms of the health concern have returned after a period of improvement or remission. - REMISSION: Indicates that signs or symptoms of the health concern are no longer evident but are at risk of returning. - RESOLVED: Indicates that signs or symptoms of the health concern are no longer evident. - INACTIVE: Indicates that the person is no longer experiencing symptoms of the concern or that evidence of the concern no longer exists.
status_reason STRING 100 A text representation of the reason the health concern is in its current status.
onset STRING 10 The onset of the health concern.
abatement STRING 10 The abatement of the health concern.
created_by STRING 36 The individual who entered the goal barrier into the system.
created_by_type STRING 20 The type of the health concern creator.
updated_by STRING 36 A representation of the individual who last modified the health concern in the system.
updated_by_type STRING 20 The type of the health concern updater.
created_at TIMESTAMP The ISO 8601 date and time when the health concern was initially entered into the system.
updated_at TIMESTAMP The ISO 8601 date and time when the health concern was last modified.
expressed_by STRING 36 The ID of the individual responsible for initially establishing or expressing the health concern.
expressed_by_type STRING 20 The type of the expresser of the health concern.
expressed_by_display STRING 1000 The human-readable description of the expresser.
encounter_id STRING 100 The ID of the encounter.
encounter_data_partition STRING 36 The data partition of the encounter.
upd_encounter_id STRING 100 The ID of the update encounter.
upd_encounter_data_partition STRING 36 The data partition of the update encounter.
source_template_id STRING 32 The ID of the source template.

PH_F_HC_Coding

Field Data Type Definition
coding_id_uuid STRING 32 The UUID of the health concern coding.
health_concern_id STRING 32 The ID of the health concern.
code STRING 60 The ID of the code.
system STRING 100 The ID of the coding system that gives meaning to the code.

PH_D_HC_Definition

Field Data Type Definition
health_concern_definition_id STRING 32 The ID of the health concern definition.
created_dt_tm TIMESTAMP The ISO 8601 date and time when the health concern definition was created.
tenant_id STRING 60 The ID of the tenant.
status STRING 10 The status of the health concern definition.
text STRING 100 A human-readable, potentially personalized description of the health concern definition.
updated_dt_tm TIMESTAMP The ISO 8601 date and time when the health concern definition was last updated.
version INT The latest version of the health concern definition.

PH_F_HC_Note

Field Data Type Definition
note_id STRING 32 The ID of the note.
health_concern_id STRING 32 The ID of the health concern.
created_by STRING 60 The individual who entered the health concern note into the system.
created_by_type STRING 20 The type of the health concern note creator.
created_at TIMESTAMP The ISO 8601 date and time when the note was initially entered into the system.
updated_by_type STRING 20 The type of the health concern note updater.
updated_by STRING 60 The individual who last updated the health concern note.
updated_at TIMESTAMP The ISO 8601 date and time when the note was last modified.
version INT The latest version of the health concern note.
health_concern_note_text STRING 100 The human-readable description of the note.
status STRING 20 The status of the health concern note.

PH_F_HC_Health_Concern_History

Field Data Type Definition
health_concern_id STRING 32 The ID of the health concern.
status STRING 20 The status of the health concern history.
updated_by STRING 60 The individual who last updated the health concern history.
updated_at TIMESTAMP The ISO 8601 date and time when the health concern history was last modified.
updated_by_type STRING 20 The type of the health concern history updater.
status_mod BOOLEAN This is used for internal purposes.
consumer_id STRING 36 The ID of the consumer.
tenant_id STRING 36 The ID of the tenant.

PH_F_LPT_Care_Plan

Field Data Type Definition
id STRING 32 The ID of the care plan.
consumer_id STRING 36 The ID of the consumer.
tenant_id STRING 36 The ID of the tenant.
status STRING 20 The current status of the care plan. The following statuses are possible: - ACTIVE: Indicates that the plan is currently in effect and being acted upon for the consumer. - INACTIVE: Indicates that the plan is not currently in effect for the consumer. - COMPLETED: Indicates that the plan is in a final state of completion. - REJECTED: Indicates that the plan is rejected. - IN_ERROR: Indicates that the plan was mistakenly identified. - SUSPENDED: Indicates that the plan is on hold.
type STRING 20 The type of the care plan. The following types are possible: - VISIT: Indicates that the plan is associated with a specific encounter. - ONGOING: Indicates that the plan is for an ongoing or chronic concern or condition and not specific to a single encounter.
description STRING 1000 A textual description of the care plan.
priority STRING 20 The priority of the care plan. The following priorities are possible: - HIGH: Indicates that the priority is high. - MEDIUM: Indicates that the priority is medium. - LOW: Indicates that the priority is low.
progress STRING 20 The progress towards the care plan. The following progresses are possible: - PROGRESSING: Indicates that the patient/consumer is progressing towards the care plan goals or is doing better than before. - REGRESSING: Indicates that the patient/consumer is doing worse than before. - AT_TARGET: Indicates that the patient/consumer is currently meeting the care plan goals and will continue to work toward maintaining them. - ACHIEVED: Indicates that the patient/consumer met the care plan goals. - NOT_ACHIEVED: Indicates that the patient/consumer did not meet the care plan goals.
plan_template_id STRING 32 The ID of the plan template.
encounter_id STRING 100 The ID of the encounter.
encounter_data_partition STRING 36 The data partition of the encounter.
updt_encounter_id STRING 100 The ID of the update encounter.
updt_encounter_data_partition STRING 36 The data partition of the update encounter.
created_by STRING 60 The individual who entered the care plan into the system.
created_by_type STRING 20 The type of the care plan creator.
created_dt_tm TIMESTAMP The ISO 8601 date and time when the care plan was created.
updated_by STRING 60 The individual who last updated the care plan.
updated_by_type STRING 20 The type of the care plan updater.
updated_dt_tm TIMESTAMP The ISO 8601 date and time when the care plan was last updated.
version INT The latest version of the care plan.

PH_F_LPT_Care_Plan_Relation

Field Data Type Definition
id_uuid STRING 32 The UUID of the care plan relation.
care_plan_id STRING 32 The ID of the care plan.
plan_entity_uuid STRING 32 The UUID of the plan entity.
plan_entity_type STRING 32 The type of the plan entity.
list_index INT Field for indexing.

PH_F_PSM_MeasureSuggestionDefinition

Field Data Type Definition
id STRING 36 The ID of the measure suggestion definition.
tenant_id STRING 255 The ID of the tenant.
population_id STRING 255 The ID of the population.
program_group_id STRING 255 The ID of the program group.
program_id STRING 255 The ID of the program.
measure_id STRING 255 The ID of the measure.
measure_outcome STRING 255 Indicates the current state of the measure. Currently, the following outcomes are possible: NOT_ACHIEVED: Indicates that the measure is not successfully achieved. MISSING_DATA: Indicates that the measure is missing some data. ACHIEVED: Indicates that the measure is successfully achieved. EXCLUDED: Indicates that the measure is excluded.
plan_definition_id STRING 255 The ID of the plan definition.
plan_definition_type STRING 255 The type of the plan definition.
status STRING 255 The status of the measure suggestion definition.
created_at TIMESTAMP The ISO 8601 date and time when the measure suggestion definition was initially entered into the system.
updated_at TIMESTAMP The ISO 8601 date and time when the measure suggestion definition was last modified.
plan_entity_action STRING 255 Indicates the type of action that should be performed.
activity_status STRING 255 The status of the activity.

PH_F_S_Strength

Field Data Type Definition
id STRING 32 The ID of the strength.
created_at TIMESTAMP The ISO 8601 date and time when the strength was initially entered into the system.
updated_at TIMESTAMP The ISO 8601 date and time when the strength was last modified.
consumer_id STRING 36 The ID of the consumer.
created_by STRING 36 The individual who entered the strength into the system.
created_by_type STRING 20 The type of the strength creator.
created_by_display STRING 1000 The human-readable representation of the strength creator.
description STRING 1000 The description of the strength.
end_date TIMESTAMP The date when the strength was no longer reported as present.
start_date TIMESTAMP The date when the strength was first reported as present.
performed_by STRING 36 The individual responsible for initially establishing or expressing the strength.
performed_by_display STRING 1000 The human-readable representation of the strength performer.
performed_by_type STRING 20 The type of the strength performer.
strength_definition_id STRING 32 The ID of the strength definition.
strength_status STRING 20 The status of the strength.
tenant_id STRING 36 The ID of the tenant.
updated_by STRING 36 The individual who last updated the strength.
updated_by_type STRING 20 The type of the strength updater.
updated_by_display STRING 1000 The human-readable representation of the strength updater.
version INT The latest version of the strength.
encounter_id STRING 100 The ID of the encounter.
encounter_data_partition STRING 36 The data partition of the encounter.
upd_encounter_id STRING 100 The ID of the update encounter.
upd_encounter_data_partition STRING 36 The data partition of the update encounter.

PH_D_S_Strength_Definition

Field Data Type Definition
id STRING 32 The ID of the strength definition.
created_at TIMESTAMP The ISO 8601 date and time when the strength definition was initially entered into the system.
updated_at TIMESTAMP The ISO 8601 date and time when the strength definition was last modified.
status STRING 20 The status of the strength definition.
tenant_id STRING 36 The ID of the tenant.
text STRING 1000 A human-readable, potentially personalized description of the strength definition.
version INT The latest version of the strength definition.