01Relates to the patient
ACCOUNT is the patient's ACCOUNT
Single-patient export: the patient's rows.
02References
PROVIDER_CODE→PROVIDERS.PROVIDER_CODEPAT_CLASS→PAT_CLASSES.PAT_CLASSSUPV_PROVIDER_CODE→PROVIDERS.PROVIDER_CODEPROVIDER_CODE→PROVIDERS.PROVIDER_CODEEMPLOYMENT_STATUS→V_EMPLOYMENT_STATUS.EMPLOYMENT_STATUSCONTACT_ID,HEALTH_HOME→HEALTH_HOME_CONTACTS.CONTACT_ID,HEALTH_HOMEHEALTH_HOME→HEALTH_HOMES.HEALTH_HOMEPCP_PROV_CODE→REFERRING_PROVIDERS.REF_PROV_CODEPHARMACY_CODE→PHARMACIES.PHARMACY_CODETIER→V_PAT_TIERS.TIERSCHOOL_NAME→SCHOOLS.SCHOOL_NAMEACCOUNT→PATIENTS.ACCOUNTRESP_ACCOUNT→PEOPLE.ACCOUNTHEALTH_HOME,CONTACT_ID→HEALTH_HOME_CONTACTS.HEALTH_HOME,CONTACT_ID
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | ACCOUNT PK | string | varchar(12) | no | |
| 2 | PAT_MORTALITY_IND | string | char(1) | yes | |
| 3 | AS_NOTIFY | string | char(1) | yes | |
| 4 | STATEMENT_FLAG | string | char(1) | yes | |
| 5 | PAT_ACTIVE | string | char(1) | yes | Y = active patient, N = inactive (including records merged into another account). |
| 6 | PAT_MARITAL_STATUS | string | char(1) | yes | |
| 7 | EMPLOYMENT_STATUS | string | varchar(2) | yes | |
| 8 | PAT_STUDENT_STATUS | string | char(1) | yes | |
| 9 | WORK_RELATED | string | char(1) | yes | |
| 10 | COPAY_EXCEPTION | string | char(1) | yes | |
| 11 | EMP_NAME | string | varchar(30) | yes | |
| 12 | DATE_OF_DEATH | datetime | datetime | yes | |
| 13 | SIGNATURE_SOURCE | string | char(1) | yes | |
| 14 | LEGAL_REP_ACCOUNT | string | varchar(12) | yes | |
| 15 | SEQUENCE_NUMBER | string | varchar(10) | yes | |
| 16 | BENEFIT_CODE | string | varchar(10) | yes | |
| 17 | PROVIDER_CODE | string | varchar(20) | yes | |
| 18 | INCLUDE_FORM_B | string | char(1) | yes | |
| 19 | SCHOOL_NAME | string | varchar(30) | yes | |
| 20 | PAT_CLASS | string | varchar(15) | yes | |
| 21 | RESP_ACCOUNT | string | varchar(12) | yes | Account of the patient's guarantor (responsible party). |
| 22 | AMB_TRAVEL_CODE | string | varchar(2) | yes | |
| 23 | PERSON_IS_PATIENT | string | char(1) | yes | |
| 24 | INCLUDE_CLAIM | string | char(1) | yes | |
| 25 | PAT_PARTICP | decimal | decimal(19,4) | yes | |
| 26 | HEAD_OF_HOUSEHOLD | string | char(1) | yes | |
| 27 | THERAPY_TYPE | string | varchar(2) | yes | |
| 28 | SUPV_PROVIDER_CODE | string | varchar(20) | yes | |
| 29 | TIER | string | varchar(5) | yes | |
| 30 | DO_NOT_BILL | string | char(1) | yes | |
| 31 | DO_NOT_CALL | string | char(1) | yes | |
| 32 | DO_NOT_LV_MSG | string | char(1) | yes | |
| 33 | OK_CALL_HOME | string | char(1) | yes | |
| 34 | OK_CALL_WORK | string | char(1) | yes | |
| 35 | OK_CALL_MOBILE | string | char(1) | yes | |
| 36 | OK_LV_MSG_HOME_ANS | string | char(1) | yes | |
| 37 | OK_LV_MSG_FAMILY | string | char(1) | yes | |
| 38 | OK_LV_MSG_WORK | string | char(1) | yes | |
| 39 | OK_LV_MSG_MOBILE | string | char(1) | yes | |
| 40 | OK_EMAIL | string | char(1) | yes | |
| 41 | OK_FAX | string | char(1) | yes | |
| 42 | OK_WRITTEN_MAIL | string | char(1) | yes | |
| 43 | OK_SMS_MOBILE | string | char(1) | yes | |
| 44 | PORTAL_ACCESS | string | char(1) | yes | |
| 45 | NO_KNOWN_PROBLEMS | boolean | bit | yes | |
| 46 | NO_ACTIVE_MEDICATIONS | boolean | bit | yes | |
| 47 | NO_KNOWN_MED_ALLERGIES | boolean | bit | yes | |
| 48 | PCP_PROV_CODE | string | varchar(20) | yes | |
| 49 | HOMICIDAL_RISK_LEVEL | string | varchar(40) | yes | |
| 50 | SUICIDAL_RISK_LEVEL | string | varchar(40) | yes | |
| 51 | HIGH_RISK | string | char(1) | yes | |
| 52 | PHARMACY_CODE | string | varchar(20) | yes | |
| 53 | HIGH_RISK_REASON | string | varchar(40) | yes | |
| 54 | SEXUALLY_ACTIVE | boolean | bit | yes | |
| 55 | HEALTH_HOME | string | varchar(20) | yes | |
| 56 | CONTACT_ID | string | varchar(12) | yes | |
| 57 | CQI | boolean | bit | yes | |
| 58 | ADMIN_CHILD_SERVICES | boolean | bit | yes | |
| 59 | FAMILY_PLANNING_SERVICES | boolean | bit | yes | |
| 60 | HUGS_PATIENT | boolean | bit | yes | |
| 61 | RHIO_CONSENT | boolean | bit | yes | |
| 62 | HIGH_RISK_DATE | datetime | datetime | yes | |
| 63 | PHI_CONSENT | boolean | bit | yes | |
| 64 | APPT_REMINDER_OK_CALL_HOME | boolean | bit | yes | |
| 65 | APPT_REMINDER_OK_SMS | boolean | bit | yes | |
| 66 | APPT_REMINDER_OK_CALL_MOBILE | boolean | bit | yes | |
| 67 | APPT_REMINDER_OK_EMAIL | boolean | bit | yes | |
| 68 | PSYCHES | boolean | bit | yes | |
| 69 | RISK_LEVEL | integer | int | yes | |
| 70 | CLINICAL_RISK | boolean | bit | yes | |
| 71 | ADMIN_RISK | string | char(1) | yes | |
| 72 | ADMIN_RISK_REASON | string | varchar(40) | yes | |
| 73 | OK_SEND_MAIL | string | char(1) | yes | |
| 74 | SEND_WHITE_ENVELOPE | string | char(1) | yes |