01Relates to the patient
ENCOUNTER_ID + GOAL_SEQUENCE_NO + OBJECTIVE_SEQUENCE matches EMR_ENCOUNTERS_TX_OBJECTIVES.ENCOUNTER_ID + EMR_ENCOUNTERS_TX_OBJECTIVES.GOAL_SEQUENCE_NO + EMR_ENCOUNTERS_TX_OBJECTIVES.OBJECTIVE_SEQUENCE on a row of EMR_ENCOUNTERS_TX_OBJECTIVES that relates to the patient
Single-patient export: the patient's rows.
02References
ENCOUNTER_ID,GOAL_SEQUENCE_NO,OBJECTIVE_SEQUENCE→EMR_ENCOUNTERS_TX_OBJECTIVES.ENCOUNTER_ID,GOAL_SEQUENCE_NO,OBJECTIVE_SEQUENCEACTIVITY_CODE→ACTIVITIES.ACTIVITY_CODEGOAL_NUMBER,OBJECTIVE_NUMBER,ACTION_NUMBER→W_ACTIONS.GOAL_NUMBER,OBJECTIVE_NUMBER,ACTION_NUMBERGROUPID,PROBLEMNUMBER,OBJECTIVENUMBER,INTERVENTIONNUMBER→OBJECTIVEINTERVENTION.GROUPID,PROBLEMNUMBER,OBJECTIVENUMBER,INTERVENTIONNUMBER
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | ENCOUNTER_ID PK | integer | int | no | |
| 2 | GOAL_SEQUENCE_NO PK | integer | int | no | |
| 3 | OBJECTIVE_SEQUENCE PK | integer | int | no | |
| 4 | ACTION_SEQUENCE PK | integer | int | no | |
| 5 | ACTION_DESCRIPTION | string | varchar(max) | yes | |
| 6 | SERVICE_MODALITY | string | varchar(max) | yes | |
| 7 | SESSIONS_NEEDED | integer | int | yes | |
| 8 | FREQUENCY | string | varchar(max) | yes | |
| 9 | CPT_CODE | string | varchar(max) | yes | |
| 10 | PROVIDER_TYPE | string | varchar(100) | yes | |
| 11 | PROVIDER | string | varchar(20) | yes | |
| 12 | RELATIONSHIP | string | varchar(40) | yes | |
| 13 | LOCATION | string | varchar(40) | yes | |
| 14 | DATE_IDENTIFIED | datetime | datetime | yes | |
| 15 | TARGET_DATE | datetime | datetime | yes | |
| 16 | PURPOSE | string | varchar(max) | yes | |
| 17 | ANTICIPATED_OUTCOME | string | varchar(max) | yes | |
| 18 | ACTIVITY_CODE | string | varchar(15) | yes | |
| 19 | GROUPID | integer | smallint | yes | |
| 20 | PROBLEMNUMBER | integer | smallint | yes | |
| 21 | OBJECTIVENUMBER | integer | smallint | yes | |
| 22 | INTERVENTIONNUMBER | integer | smallint | yes | |
| 23 | ACTION_TYPE | integer | int | yes | |
| 24 | CLIENT_RESPONSE | string | varchar(max) | yes | |
| 25 | PROGRESS_SUMMARY | string | varchar(max) | yes | |
| 26 | GOAL_NUMBER | integer | int | yes | |
| 27 | OBJECTIVE_NUMBER | integer | int | yes | |
| 28 | ACTION_NUMBER | integer | int | yes | |
| 29 | CLINICAL_INTERVENTION | string | varchar(500) | yes | |
| 30 | ACTION_ACTIVITY | string | varchar(500) | yes | |
| 31 | IS_DELETED | boolean | bit | yes |