01Relates to the patient
reference data (no patient link)
Single-patient export: included in full (reference data).
02References
FACILITY_TYPE_CODE→V_FACILITY_TYPES.FACILITY_TYPE_CODEABORTION_STERILIZATION→V_MM_ABORT_STERIL.ABORTION_STERILIZATIONCATEGORY→V_MM_CATEGORY_OF_SERVICE.CATEGORYCHAP_REFERRAL→V_MM_CHAP_REFERRAL.CHAP_REFERRALACCIDENT→V_MM_ACCIDENT.ACCIDENTMEDICAID_SPECIALTY_CODE→V_MM_CLINIC_SPECIALTY.MEDICAID_SPECIALTY_CODEOTHER_INS_MMIS→V_MM_OTHER_INSURANCE.OTHER_INS_MMISPATIENT_STATUS→V_MM_PATSTAT_A.PATIENT_STATUSPATIENT_STATUS_FORM_B→V_MM_PATSTAT_B.PATIENT_STATUS_FORM_BPOS_CODE_MMIS→V_MM_PLACE_OF_SERVICE.POS_CODE_MMISPOS_CODE→V_PLACE_OF_SERVICE.POS_CODESTATE→US_STATES.STATESVC_AUTH_EXCEPTION→MMIS_SVC_AUTH_EXCEPT_CODES.SVC_AUTH_EXCEPTIONTAXONOMY_CODE→TAXONOMY_CODES.TAXONOMY_CODELOCATION_CLASS→LOCATION_CLASSES.LOCATION_CLASS
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | OFFICE_LOCATION PK | string | varchar(20) | no | |
| 2 | LOCATOR_CODE | string | varchar(3) | yes | |
| 3 | POS_CODE | string | varchar(2) | yes | |
| 4 | MEDICAID_SPECIALTY_CODE | string | varchar(3) | yes | |
| 5 | MC_COINS_RATE | decimal | decimal(19,4) | yes | |
| 6 | AUTO_INS_FLAG | string | char(1) | yes | |
| 7 | LOCATION_CLASS | string | varchar(15) | yes | |
| 8 | FACILITY_NAME | string | varchar(40) | yes | |
| 9 | ADDR1 | string | varchar(55) | yes | |
| 10 | ADDR2 | string | varchar(55) | yes | |
| 11 | CITY | string | varchar(30) | yes | |
| 12 | STATE | string | varchar(2) | yes | |
| 13 | ZIP | string | varchar(10) | yes | |
| 14 | COUNTRY_CODE | string | varchar(2) | yes | |
| 15 | string | varchar(254) | yes | ||
| 16 | MAMMOGRAPHY_CERT_NO | string | varchar(10) | yes | |
| 17 | EMERGENCY | string | char(1) | yes | |
| 18 | HANDICAPPED_CHILDREN | string | char(1) | yes | |
| 19 | DISABILITY | string | char(1) | yes | |
| 20 | FAMILY_PLANNING | string | char(1) | yes | |
| 21 | ACCIDENT | string | char(1) | yes | |
| 22 | PATIENT_STATUS | string | char(1) | yes | |
| 23 | CHAP_REFERRAL | string | char(1) | yes | |
| 24 | OTHER_INS_MMIS | string | varchar(2) | yes | |
| 25 | ABORTION_STERILIZATION | string | char(1) | yes | |
| 26 | PATIENT_STATUS_FORM_B | string | varchar(2) | yes | |
| 27 | POS_CODE_MMIS | string | char(1) | yes | |
| 28 | ORG_CODE | string | varchar(10) | yes | |
| 29 | CLIA_ID | string | varchar(15) | yes | |
| 30 | CATEGORY | string | varchar(4) | yes | |
| 31 | MMIS_COPS | string | char(1) | yes | |
| 32 | MMIS_PT_CLINIC_ID | string | varchar(13) | yes | |
| 33 | LOCATION_NUMBER | string | varchar(15) | yes | |
| 34 | FACILITY_TYPE_CODE | string | varchar(2) | yes | |
| 35 | RADIOLOGY_SITE_ID | string | varchar(3) | yes | |
| 36 | ENCOUNTER_FORM_NAME | string | varchar(40) | yes | |
| 37 | SVC_AUTH_EXCEPTION | string | char(1) | yes | |
| 38 | NPID | string | varchar(18) | yes | |
| 39 | SVC_FACILITY_NPID | string | varchar(18) | yes | |
| 40 | TAXONOMY_CODE | string | varchar(10) | yes | |
| 41 | LOCATION_ACTIVE | string | char(1) | yes | |
| 42 | OPEN_MON | boolean | bit | yes | |
| 43 | OPEN_TUE | boolean | bit | yes | |
| 44 | OPEN_WED | boolean | bit | yes | |
| 45 | OPEN_THU | boolean | bit | yes | |
| 46 | OPEN_FRI | boolean | bit | yes | |
| 47 | OPEN_SAT | boolean | bit | yes | |
| 48 | OPEN_SUN | boolean | bit | yes | |
| 49 | TOX_MON | boolean | bit | yes | |
| 50 | TOX_TUE | boolean | bit | yes | |
| 51 | TOX_WED | boolean | bit | yes | |
| 52 | TOX_THU | boolean | bit | yes | |
| 53 | TOX_FRI | boolean | bit | yes | |
| 54 | TOX_SAT | boolean | bit | yes | |
| 55 | TOX_SUN | boolean | bit | yes | |
| 56 | APPT_REMINDER | boolean | bit | yes | |
| 57 | PIN | string | varchar(15) | yes | |
| 58 | MMT_DISPENSE | boolean | bit | yes |