01Relates to the patient
ACCOUNT is the patient's ACCOUNT
Single-patient export: the patient's rows.
02References
ACCOUNT→PATIENTS.ACCOUNTCATEGORY→V_MM_CATEGORY_OF_SERVICE.CATEGORYCLAIM_CURRENT_INS_ID,CLAIM_CURRENT_PAYOR→INSURANCE_POLICIES.INSURANCE_ID,COMPANY_CODEDEPT_CODE→DEPARTMENTS.DEPT_CODELICENSE_PLATE→LICENSE_PLATES.LICENSE_PLATEOFFICE_LOCATION→LOCATIONS.OFFICE_LOCATIONPROGRAM_CODE→PROGRAM_CODES.PROGRAM_CODEPROVIDER_CODE→PROVIDERS.PROVIDER_CODEREF_PROV_CODE→REFERRING_PROVIDERS.REF_PROV_CODEREFERRAL_SOURCE→REFERRAL_SOURCES.REFERRAL_SOURCEREV_CODE→REV_CODES.REV_CODESERVICE_NAME→SERVICES.SERVICE_NAMEAPG_CODE→APG_CODES.APG_CODEATTEND_PROVIDER_CODE→PROVIDERS.PROVIDER_CODECLAIM_CLASS→CLAIM_CLASSES.CLAIM_CLASSACCOUNT,EPISODE_CARE_ID→PAT_PROGRAMS.ACCOUNT,EPISODE_CARE_IDSCHOOL_NAME→SCHOOLS.SCHOOL_NAMEABORTION_STERILIZATION→V_MM_ABORT_STERIL.ABORTION_STERILIZATIONACCIDENT→V_MM_ACCIDENT.ACCIDENTADMIT_DIAG_CODE→DIAGNOSIS_CODES.DIAG_CODEADMISSION_SOURCE_CODE→V_ADMISSION_SOURCE.ADMISSION_SOURCE_CODEADMISSION_TYPE_CODE→V_ADMISSION_TYPE.ADMISSION_TYPE_CODEACCOUNT,AMB_TRIP_DATE→PAT_AMB_TRIPS.ACCOUNT,AMB_TRIP_DATEAPPT_ID→APPOINTMENTS.APPT_IDCHAP_REFERRAL→V_MM_CHAP_REFERRAL.CHAP_REFERRALPATIENT_STATUS→V_MM_PATSTAT_A.PATIENT_STATUSPATIENT_STATUS_UB→V_PATSTAT_UB.PATIENT_STATUS_UBMEDICAID_SPECIALTY_CODE→V_MM_CLINIC_SPECIALTY.MEDICAID_SPECIALTY_CODESVC_AUTH_EXCEPTION→MMIS_SVC_AUTH_EXCEPT_CODES.SVC_AUTH_EXCEPTION
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | INVOICE PK | integer | int | no | |
| 2 | AR_ONLY | string | char(1) | yes | |
| 3 | ACCOUNT | string | varchar(12) | no | |
| 4 | CLAIM_STATUS | string | char(1) | no | |
| 5 | CLAIM_CURRENT_PAYOR | string | varchar(20) | yes | |
| 6 | CLAIM_CURRENT_INS_ID | string | varchar(25) | yes | |
| 7 | CLAIM_CLASS | string | varchar(15) | yes | |
| 8 | OFFICE_LOCATION | string | varchar(20) | yes | |
| 9 | PROVIDER_CODE | string | varchar(20) | yes | |
| 10 | REF_PROV_CODE | string | varchar(20) | yes | |
| 11 | ACCIDENT_DATE | datetime | smalldatetime | yes | |
| 12 | DATE_OF_ADMISSION | datetime | smalldatetime | yes | |
| 13 | EMERGENCY | string | char(1) | yes | |
| 14 | OVER_90_REASON | string | varchar(2) | yes | |
| 15 | CATEGORY | string | varchar(4) | yes | |
| 16 | MEDICAID_SPECIALTY_CODE | string | varchar(3) | yes | |
| 17 | ADJUST_VOID | string | char(1) | yes | |
| 18 | CLAIM_REFERENCE_NO | string | varchar(30) | yes | |
| 19 | SVC_AUTH_EXCEPTION | string | char(1) | yes | |
| 20 | OTHER_REF_PROV | string | varchar(15) | yes | |
| 21 | SERVICE_NAME | string | varchar(40) | yes | |
| 22 | OUTSIDE_LAB_IND | string | char(1) | yes | |
| 23 | OUTSIDE_LAB_CHARGES | decimal | decimal(19,4) | yes | |
| 24 | PATIENT_STATUS_FORM_B | string | varchar(2) | yes | |
| 25 | COPAY | decimal | decimal(19,4) | yes | |
| 26 | WCB_STATUS | string | char(1) | yes | |
| 27 | FILE_NUMBER | string | varchar(20) | yes | |
| 28 | ENTRY_USER_ID | string | varchar(20) | no | |
| 29 | ENTRY_DATE | datetime | datetime | no | |
| 30 | CHANGE_USER_ID | string | varchar(20) | no | |
| 31 | CHANGE_DATE | datetime | datetime | yes | |
| 32 | PATIENT_STATUS | string | char(1) | yes | |
| 33 | ACCIDENT | string | char(1) | yes | |
| 34 | ABORTION_STERILIZATION | string | char(1) | yes | |
| 35 | CHAP_REFERRAL | string | char(1) | yes | |
| 36 | HANDICAPPED_CHILDREN | string | char(1) | yes | |
| 37 | DISABILITY | string | char(1) | yes | |
| 38 | FAMILY_PLANNING | string | char(1) | yes | |
| 39 | LOCATOR_CODE | string | varchar(3) | yes | |
| 40 | VERIFIED | string | char(1) | yes | |
| 41 | CLAIM_SOURCE | string | varchar(20) | no | |
| 42 | CLIA_ID | string | varchar(15) | yes | |
| 43 | RECEIPT_NUMBER | integer | int | yes | |
| 44 | RECEIPT_DATE | datetime | datetime | yes | |
| 45 | ACCEPT_ASSIGNMENT | string | char(1) | yes | |
| 46 | SCHOOL_DISTRICT | string | varchar(30) | yes | |
| 47 | REFERRAL_SOURCE | string | varchar(30) | yes | |
| 48 | NUMBER_OF_VISITS | integer | int | yes | |
| 49 | PROGRAM_CODE | string | varchar(15) | yes | |
| 50 | REV_CODE | string | varchar(5) | yes | |
| 51 | AMB_TRIP_DATE | datetime | datetime | yes | |
| 52 | LICENSE_PLATE | string | varchar(10) | yes | |
| 53 | APPT_ID | integer | int | yes | |
| 54 | HOSPICE_ID | string | varchar(15) | yes | |
| 55 | ADMIT_DIAG_CODE | string | varchar(8) | yes | |
| 56 | ADMISSION_SOURCE_CODE | string | char(1) | yes | |
| 57 | ADMISSION_TYPE_CODE | string | char(1) | yes | |
| 58 | PATIENT_STATUS_UB | string | varchar(2) | yes | |
| 59 | SPEND_DOWN | decimal | decimal(19,4) | yes | |
| 60 | DISCIPLINE | string | varchar(2) | yes | |
| 61 | PROJECTED_VISITS | integer | int | yes | |
| 62 | MRO | string | char(1) | yes | |
| 63 | THERAPY_TYPE | string | varchar(2) | yes | |
| 64 | DENIAL_NOTICE | string | char(1) | yes | |
| 65 | NUM_ENC_RADIOGRAPH | integer | int | yes | |
| 66 | NUM_ENC_IMAGE | integer | int | yes | |
| 67 | NUM_ENC_MODEL | integer | int | yes | |
| 68 | ORTHO_TREATMENT_IND | string | char(1) | yes | |
| 69 | DATE_APPLIANCE_PLACED | datetime | datetime | yes | |
| 70 | MONTHS_TX_REMAIN | integer | int | yes | |
| 71 | REPLACE_PROSTHESIS | string | char(1) | yes | |
| 72 | DATE_PRIOR_PLACEMENT | datetime | datetime | yes | |
| 73 | PLACE_OF_TREATMENT | string | varchar(2) | yes | |
| 74 | DEPT_CODE | string | varchar(15) | yes | |
| 75 | DURATION_HOURS | integer | int | yes | |
| 76 | APG_CODE | string | varchar(4) | yes | |
| 77 | DISASTER_RECOVERY | string | char(1) | yes | |
| 78 | ARBITRATION_FEE | decimal | decimal(19,4) | yes | |
| 79 | EVALUATION_NOTES | string | varchar(240) | yes | |
| 80 | PROGRESS_NOTES | string | varchar(240) | yes | |
| 81 | TREATMENT_NOTES | string | varchar(240) | yes | |
| 82 | HISTORY_DESC | string | varchar(240) | yes | |
| 83 | SCHOOL_NAME | string | varchar(30) | yes | |
| 84 | PRE_EXISTING_INJURY | string | char(1) | yes | |
| 85 | EPISODE_CARE_ID | integer | int | yes | |
| 86 | ATTEND_PROVIDER_CODE | string | varchar(20) | yes | |
| 87 | COUNTY | string | varchar(30) | yes |