01Relates to the patient
reference data (no patient link)
Single-patient export: included in full (reference data).
02References
PROGRAM_ADMIN→USERS.USER_IDPROGRAM_ASSOC_DIRECTOR→USERS.USER_IDATTEND_PROVIDER_CODE→PROVIDERS.PROVIDER_CODESERVICE_NAME_BAC→SERVICES.SERVICE_NAMEPROGRAM_CLASS→PROGRAM_CLASSES.PROGRAM_CLASSCLINICAL_DIRECTOR→USERS.USER_IDCREDENTIALED_COUNSELOR→USERS.USER_IDMEDICAL_DOCTOR→USERS.USER_IDMMT_1ST_PROC_CODE,MMT_1ST_CODING_METHOD→PROCEDURES.PROC_CODE,CODING_METHODPROC_UNIT_CODE→PROCEDURE_UNITS.PROC_UNIT_CODEREF_PROV_CODE→REFERRING_PROVIDERS.REF_PROV_CODEREVIEW_USER→USERS.USER_IDSERVICE_NAME_URINE→SERVICES.SERVICE_NAMEPROGRAM_DIRECTOR→USERS.USER_IDPROGRAM_MANAGER→USERS.USER_IDSERVICE_NAME→SERVICES.SERVICE_NAME
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | PROGRAM_CODE PK | string | varchar(15) | no | |
| 2 | PROGRAM_DESC | string | varchar(40) | no | |
| 3 | SERVICE_NAME | string | varchar(40) | yes | |
| 4 | PROGRAM_DIRECTOR | string | varchar(20) | yes | |
| 5 | PROGRAM_ADMIN | string | varchar(20) | yes | |
| 6 | PROGRAM_MANAGER | string | varchar(20) | yes | |
| 7 | LANGUAGE_INCENTIVE | string | char(1) | yes | |
| 8 | USE_ACTIVITY | string | char(1) | yes | |
| 9 | USE_DSM | string | char(1) | yes | |
| 10 | USE_EMR | string | char(1) | yes | |
| 11 | SERVICE_TYPE | integer | int | yes | |
| 12 | PROGRAM_ACTIVE | string | char(1) | yes | |
| 13 | PROGRAM_CLASS | string | varchar(15) | yes | |
| 14 | SEND_SIU_ATTEND | string | char(1) | yes | |
| 15 | PROC_UNIT_CODE | string | varchar(20) | yes | |
| 16 | SHARE_TX_PLAN | boolean | bit | yes | |
| 17 | PROGRAM_ASSOC_DIRECTOR | string | varchar(20) | yes | |
| 18 | SERVICE_NAME_URINE | string | varchar(40) | yes | |
| 19 | REVIEW_USER | string | varchar(20) | yes | |
| 20 | MMT_1ST_PROC_CODE | string | varchar(20) | yes | |
| 21 | MMT_1ST_CODING_METHOD | string | varchar(5) | yes | |
| 22 | SERVICE_NAME_BAC | string | varchar(40) | yes | |
| 23 | TEAM_WORKFLOW | boolean | bit | yes | |
| 24 | TAXONOMY_CODE | string | varchar(10) | yes | |
| 25 | OASAS | boolean | bit | yes | |
| 26 | PROGRAM_COLOR | integer | int | yes | |
| 27 | CREDENTIALED_COUNSELOR | string | varchar(20) | yes | |
| 28 | MEDICAL_DOCTOR | string | varchar(20) | yes | |
| 29 | CLINICAL_DIRECTOR | string | varchar(20) | yes | |
| 30 | ATTEND_PROVIDER_CODE | string | varchar(20) | yes | |
| 31 | REF_PROV_CODE | string | varchar(20) | yes | |
| 32 | ALLOW_INITIAL_TX | boolean | bit | yes | |
| 33 | ROUNDING_INTERVAL | integer | int | yes | |
| 34 | USES_NURSING_SHIFT | boolean | bit | yes |