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.
Property | Value |
---|---|
Header Record | Yes |
Field Delimiter | Comma |
Record Delimiter | CR/LF |
Character Encoding | UTF-8 |
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 | 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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |