01Relates to the patient
ACCOUNT is the patient's ACCOUNT; or ENCOUNTER_ID matches EMR_ENCOUNTERS.ENCOUNTER_ID on a row of EMR_ENCOUNTERS that relates to the patient
Single-patient export: the patient's rows.
02References
CURR_PROGRAM_CODE→PROGRAM_CODES.PROGRAM_CODEENCOUNTER_ID→EMR_ENCOUNTERS.ENCOUNTER_IDNEW_PROGRAM_CODE→PROGRAM_CODES.PROGRAM_CODENEW_PROGRAM_PROVIDER→PROVIDERS.PROVIDER_CODENEW_PROGRAM_STATUS→PROGRAM_STATUS_CODES.PROGRAM_STATUSACCOUNT,NEW_PROGRAM_EPISODE→PAT_PROGRAMS.ACCOUNT,EPISODE_CARE_ID
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | ENCOUNTER_ID PK | integer | int | no | |
| 2 | CURR_PROGRAM_CODE | string | varchar(15) | no | |
| 3 | NEW_PROGRAM_CODE | string | varchar(15) | yes | |
| 4 | NEW_PROGRAM_STATUS | string | char(1) | yes | |
| 5 | NEW_PROGRAM_PROVIDER | string | varchar(20) | yes | |
| 6 | NEW_PROGRAM_ADMISSION_DATE | datetime | datetime | yes | |
| 7 | ACCOUNT | string | varchar(12) | yes | |
| 8 | NEW_PROGRAM_EPISODE | integer | int | yes | |
| 9 | TRANSFER_DIAGS | boolean | bit | yes | |
| 10 | DISCHARGE_CURR_PROGRAM | boolean | bit | yes |