01Relates to the patient
ACCOUNT is the patient's ACCOUNT
Single-patient export: the patient's rows.
02References
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | ACCOUNT PK | string | varchar(12) | no | |
| 2 | PROVIDER_CODE PK | string | varchar(20) | no | |
| 3 | AGE | integer | int | yes | |
| 4 | IN_PD | boolean | bit | yes | |
| 5 | PROBLEM_LIST_N | integer | int | yes | |
| 6 | PROBLEM_LIST_D | integer | int | yes | |
| 7 | MEDICATION_LIST_N | integer | int | yes | |
| 8 | MEDICATION_LIST_D | integer | int | yes | |
| 9 | MED_ALLERGY_LIST_N | integer | int | yes | |
| 10 | MED_ALLERGY_LIST_D | integer | int | yes | |
| 11 | CPOE_MED_N | integer | int | yes | |
| 12 | CPOE_MED_D | integer | int | yes | |
| 13 | CPOE_LAB_N | integer | int | yes | |
| 14 | CPOE_LAB_D | integer | int | yes | |
| 15 | CPOE_RAD_N | integer | int | yes | |
| 16 | CPOE_RAD_D | integer | int | yes | |
| 17 | E_RX_N | integer | int | yes | |
| 18 | E_RX_D | integer | int | yes | |
| 19 | DEMOGRAPHICS_N | integer | int | yes | |
| 20 | DEMOGRAPHICS_D | integer | int | yes | |
| 21 | VITALS_BMI_GROWTH_N | integer | int | yes | |
| 22 | VITALS_BMI_GROWTH_D | integer | int | yes | |
| 23 | SMOKING_STATUS_N | integer | int | yes | |
| 24 | SMOKING_STATUS_D | integer | int | yes | |
| 25 | LAB_RESULTS_N | integer | int | yes | |
| 26 | LAB_RESULTS_D | integer | int | yes | |
| 27 | PATIENT_REMINDERS_N | integer | int | yes | |
| 28 | PATIENT_REMINDERS_D | integer | int | yes | |
| 29 | VDT_A_N | integer | int | yes | |
| 30 | VDT_A_D | integer | int | yes | |
| 31 | VDT_B_N | integer | int | yes | |
| 32 | VDT_B_D | integer | int | yes | |
| 33 | CLINICAL_SUMMARY_N | integer | int | yes | |
| 34 | CLINICAL_SUMMARY_D | integer | int | yes | |
| 35 | PATIENT_EDUCATION_N | integer | int | yes | |
| 36 | PATIENT_EDUCATION_D | integer | int | yes | |
| 37 | MEDICATION_RECONCILIATION_N | integer | int | yes | |
| 38 | MEDICATION_RECONCILIATION_D | integer | int | yes | |
| 39 | SUMMARY_OF_CARE_A_N | integer | int | yes | |
| 40 | SUMMARY_OF_CARE_A_D | integer | int | yes | |
| 41 | SUMMARY_OF_CARE_B_N | integer | int | yes | |
| 42 | SUMMARY_OF_CARE_B_D | integer | int | yes | |
| 43 | SECURE_MESSAGING_N | integer | int | yes | |
| 44 | SECURE_MESSAGING_D | integer | int | yes | |
| 45 | IMAGING_N | integer | int | yes | |
| 46 | IMAGING_D | integer | int | yes | |
| 47 | FAMILY_HISTORY_N | integer | int | yes | |
| 48 | FAMILY_HISTORY_D | integer | int | yes | |
| 49 | ELECTRONIC_NOTES_N | integer | int | yes | |
| 50 | ELECTRONIC_NOTES_D | integer | int | yes | |
| 51 | CPOE_N | integer | int | yes | |
| 52 | CPOE_D | integer | int | yes | |
| 53 | CCD_CCR_N | integer | int | yes | |
| 54 | CCD_CCR_D | integer | int | yes | |
| 55 | PATIENT_SUMMARY_N | integer | int | yes | |
| 56 | PATIENT_SUMMARY_D | integer | int | yes | |
| 57 | TIMELY_ACCESS_N | integer | int | yes | |
| 58 | TIMELY_ACCESS_D | integer | int | yes | |
| 59 | CPOE_STAGE1_N | integer | int | yes | |
| 60 | CPOE_STAGE1_D | integer | int | yes | |
| 61 | VITALS_STAGE1_D | integer | int | yes | |
| 62 | VITALS_STAGE1_N | integer | int | yes | |
| 63 | VITALS_BP_OUT_SCOPE_D | integer | int | yes | |
| 64 | VITALS_BP_OUT_SCOPE_N | integer | int | yes | |
| 65 | VITALS_HTWT_OUT_SCOPE_D | integer | int | yes | |
| 66 | VITALS_HTWT_OUT_SCOPE_N | integer | int | yes | |
| 67 | PATIENT_REMINDERS_MU1_N | integer | int | yes | |
| 68 | PATIENT_REMINDERS_MU1_D | integer | int | yes | |
| 69 | CLINICAL_INFO_RECONCILIATION_D | integer | int | yes | |
| 70 | CLINICAL_INFO_RECONCILIATION_N | integer | int | yes | |
| 71 | PAT_GENERATED_DATA_D | integer | int | yes | |
| 72 | PAT_GENERATED_DATA_N | integer | int | yes |