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. |