01Relates to the patient
reference data (no patient link)
Single-patient export: included in full (reference data).
02References
PAYOR_CLASS→PAYOR_CLASSES.PAYOR_CLASSSTATE→US_STATES.STATEFORM_ID→FORMS.FORM_IDSUPPLY_CODE→V_MMT_STOCK_SUPPLY.SUPPLY_CODE
03Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | COMPANY_CODE PK | string | varchar(20) | no | |
| 2 | COMPANY_NAME | string | varchar(40) | no | |
| 3 | PAYOR_CLASS | string | varchar(15) | yes | |
| 4 | RECEIVER_TYPE | string | char(1) | yes | |
| 5 | PAYOR_ID | string | varchar(15) | yes | |
| 6 | PAYOR_SUB_ID | string | varchar(4) | yes | |
| 7 | PAYOR_ID_QUAL | string | varchar(4) | yes | |
| 8 | CLAIM_PROCESSOR | string | varchar(4) | yes | |
| 9 | HMO_CODE | string | varchar(4) | yes | |
| 10 | ADDR1 | string | varchar(55) | yes | |
| 11 | ADDR2 | string | varchar(55) | yes | |
| 12 | CITY | string | varchar(30) | yes | |
| 13 | STATE | string | varchar(2) | yes | |
| 14 | ZIP | string | varchar(10) | yes | |
| 15 | COUNTRY_CODE | string | varchar(2) | yes | |
| 16 | string | varchar(254) | yes | ||
| 17 | SERVICE_CLASS | string | varchar(15) | yes | |
| 18 | OTHER_INS_MMIS | string | varchar(2) | yes | |
| 19 | HMO_PPO_IND | string | char(1) | yes | |
| 20 | REF_PROV_REQUIRED | string | char(1) | yes | |
| 21 | CROSSOVER_AS_BILLED | string | char(1) | yes | |
| 22 | ID_VALIDATION | integer | int | yes | |
| 23 | MMIS_COPS | string | char(1) | yes | |
| 24 | INSTITUTIONAL | string | char(1) | yes | |
| 25 | CLAIM_TYPE | string | char(1) | yes | |
| 26 | COMMENT_TEXT | string | varchar(max) | yes | |
| 27 | AMT_PAID_ON_CLAIM | string | char(1) | yes | |
| 28 | ORG_ON_CLAIM | string | char(1) | yes | |
| 29 | BILL_PROV_NAME_ON_CLAIM | string | char(1) | yes | |
| 30 | CONTRACT_NUMBER | string | varchar(25) | yes | |
| 31 | CONTRACT_EXPIRATION_DATE | datetime | smalldatetime | yes | |
| 32 | ALLOW_CLAIM_ADJUSTMENT | string | char(1) | yes | |
| 33 | TPL_CODE | string | varchar(5) | yes | |
| 34 | ENTRY_DATE | datetime | datetime | no | |
| 35 | ENTRY_USER_ID | string | varchar(20) | no | |
| 36 | CHANGE_DATE | datetime | datetime | no | |
| 37 | CHANGE_USER_ID | string | varchar(20) | no | |
| 38 | ONLY_PAYOR_ON_CLAIM | string | char(1) | yes | |
| 39 | REALTIME_PAYOR_ID | string | varchar(15) | yes | |
| 40 | INCLUDE_837D | string | char(1) | yes | |
| 41 | INCLUDE_837I | string | char(1) | yes | |
| 42 | INCLUDE_837P | string | char(1) | yes | |
| 43 | SUPPRESS_UNITS | string | char(1) | yes | |
| 44 | TIMELY_FILING_DAYS | integer | int | yes | |
| 45 | OUT_OF_NETWORK | string | char(1) | yes | |
| 46 | BILL_SUPV_PROVIDER | string | char(1) | yes | |
| 47 | FORM_ID | integer | int | yes | |
| 48 | LANGUAGE_INCENTIVE | string | char(1) | yes | |
| 49 | SPEND_DOWN | string | char(1) | yes | |
| 50 | APG | string | char(1) | yes | |
| 51 | ALPHA_DIAG_POINTERS | boolean | bit | yes | |
| 52 | ICD10 | boolean | bit | no | |
| 53 | EXT_COMPANY_CODE | string | varchar(20) | yes | |
| 54 | MCO | boolean | bit | yes | |
| 55 | LOCATION_ON_CLAIM | string | char(1) | yes | |
| 56 | BILL_DIAG1_ONLY | boolean | bit | yes | |
| 57 | ATYPICAL | boolean | bit | yes | |
| 58 | SUPPLY_CODE | string | varchar(10) | yes | |
| 59 | MMT_SVC_TYPE | string | varchar(2) | yes | |
| 60 | BALANCE_HOLD | boolean | bit | yes | |
| 61 | AUTO_XOVER_PAYOR_ID | string | varchar(15) | yes | |
| 62 | MMT_BUNDLING_TYPE | integer | int | yes | |
| 63 | THERAPY_WAIVER | boolean | bit | yes | |
| 64 | ONLY_PROVIDER_ON_CLAIM | boolean | bit | yes | |
| 65 | PAYOR_ACTIVE | boolean | bit | yes | |
| 66 | GRANT_PAYOR | boolean | bit | yes | |
| 67 | LOOP_2420A | boolean | bit | yes | |
| 68 | APG_DUP_CPT | boolean | bit | yes | |
| 69 | ORG_ADDR_ON_CLAIM | boolean | bit | yes | |
| 70 | DED_MONTH | integer | int | yes |