01Relates to the patient
not linked to a patient
Single-patient export: not included.
02Columns
| # | Column | Type | Source type | Null | Notes |
|---|---|---|---|---|---|
| 1 | CLM_KEY | string | varchar(30) | no | |
| 2 | CLM_PROVIDER_ID | string | varchar(30) | yes | |
| 3 | CLM_NAME | string | varchar(30) | yes | |
| 4 | CLM_SERVICE | string | varchar(30) | yes | |
| 5 | CLM_CLIENT_ID | string | varchar(30) | yes | |
| 6 | CLM_DIVISION | string | varchar(30) | yes | |
| 7 | CLM_PHYSICIAN | string | varchar(30) | yes | |
| 8 | CLM_BILL_DATE | string | varchar(30) | yes | |
| 9 | CLM_GROUP_ID | string | varchar(30) | yes | |
| 10 | CLM_LOCATOR_CODE | string | varchar(30) | yes | |
| 11 | CLM_SPECIALTY | string | varchar(30) | yes | |
| 12 | CLM_CAT_SERVICE | string | varchar(30) | yes | |
| 13 | CLM_MEDICAID_ID | string | varchar(30) | yes | |
| 14 | CLM_DOB | string | varchar(30) | yes | |
| 15 | CLM_SEX | string | varchar(30) | yes | |
| 16 | CLM_PRIMARY_DIAG | string | varchar(30) | yes | |
| 17 | CLM_SECONDARY_DIAG | string | varchar(30) | yes | |
| 18 | CLM_EMERGENCY | string | varchar(30) | yes | |
| 19 | CLM_HCAPPD_CHILD | string | varchar(30) | yes | |
| 20 | CLM_POSS_DISAB | string | varchar(30) | yes | |
| 21 | CLM_FAM_PLAN | string | varchar(30) | yes | |
| 22 | CLM_ACCIDENT | string | varchar(30) | yes | |
| 23 | CLM_PAT_STATUS | string | varchar(30) | yes | |
| 24 | CLM_CHAP_REF | string | varchar(30) | yes | |
| 25 | CLM_OTHER_INS | string | varchar(30) | yes | |
| 26 | CLM_ABORT_STERIL | string | varchar(30) | yes | |
| 27 | CLM_PRIOR_APPROVAL | string | varchar(30) | yes | |
| 28 | CLM_PLACE_SERVICE | string | varchar(30) | yes | |
| 29 | CLM_SVC_PROV_ID | string | varchar(30) | yes | |
| 30 | CLM_SVC_PROV_TYPE | string | varchar(30) | yes | |
| 31 | CLM_ORD_PROV_ID | string | varchar(30) | yes | |
| 32 | CLM_ORD_PROV_TYPE | string | varchar(30) | yes | |
| 33 | CLM_ADJUST_VOID | string | varchar(30) | yes | |
| 34 | CLM_REF_NUMBER | string | varchar(30) | yes | |
| 35 | CLM_OCRN_DECADE | string | varchar(30) | yes | |
| 36 | CLM_PROC1 | string | varchar(30) | yes | |
| 37 | CLM_PROC2 | string | varchar(30) | yes | |
| 38 | CLM_PROC3 | string | varchar(30) | yes | |
| 39 | CLM_PROC4 | string | varchar(30) | yes | |
| 40 | CLM_PROC5 | string | varchar(30) | yes | |
| 41 | CLM_PROC6 | string | varchar(30) | yes | |
| 42 | CLM_XPERF1 | string | varchar(30) | yes | |
| 43 | CLM_XPERF2 | string | varchar(30) | yes | |
| 44 | CLM_XPERF3 | string | varchar(30) | yes | |
| 45 | CLM_XPERF4 | string | varchar(30) | yes | |
| 46 | CLM_XPERF5 | string | varchar(30) | yes | |
| 47 | CLM_XPERF6 | string | varchar(30) | yes | |
| 48 | CLM_AMT1 | string | varchar(30) | yes | |
| 49 | CLM_AMT2 | string | varchar(30) | yes | |
| 50 | CLM_AMT3 | string | varchar(30) | yes | |
| 51 | CLM_AMT4 | string | varchar(30) | yes | |
| 52 | CLM_AMT5 | string | varchar(30) | yes | |
| 53 | CLM_AMT6 | string | varchar(30) | yes | |
| 54 | CLM_MA_AMT1 | string | varchar(30) | yes | |
| 55 | CLM_MA_AMT2 | string | varchar(30) | yes | |
| 56 | CLM_MA_AMT3 | string | varchar(30) | yes | |
| 57 | CLM_MA_AMT4 | string | varchar(30) | yes | |
| 58 | CLM_MA_AMT5 | string | varchar(30) | yes | |
| 59 | CLM_MA_AMT6 | string | varchar(30) | yes | |
| 60 | CLM_MP_AMT1 | string | varchar(30) | yes | |
| 61 | CLM_MP_AMT2 | string | varchar(30) | yes | |
| 62 | CLM_MP_AMT3 | string | varchar(30) | yes | |
| 63 | CLM_MP_AMT4 | string | varchar(30) | yes | |
| 64 | CLM_MP_AMT5 | string | varchar(30) | yes | |
| 65 | CLM_MP_AMT6 | string | varchar(30) | yes | |
| 66 | CLM_OP_AMT1 | string | varchar(30) | yes | |
| 67 | CLM_OP_AMT2 | string | varchar(30) | yes | |
| 68 | CLM_OP_AMT3 | string | varchar(30) | yes | |
| 69 | CLM_OP_AMT4 | string | varchar(30) | yes | |
| 70 | CLM_OP_AMT5 | string | varchar(30) | yes | |
| 71 | CLM_OP_AMT6 | string | varchar(30) | yes | |
| 72 | CLM_TQ1 | string | varchar(30) | yes | |
| 73 | CLM_SF1 | string | varchar(30) | yes | |
| 74 | CLM_TQ2 | string | varchar(30) | yes | |
| 75 | CLM_SF2 | string | varchar(30) | yes | |
| 76 | CLM_TQ3 | string | varchar(30) | yes | |
| 77 | CLM_SF3 | string | varchar(30) | yes | |
| 78 | CLM_TQ4 | string | varchar(30) | yes | |
| 79 | CLM_SF4 | string | varchar(30) | yes | |
| 80 | CLM_TQ5 | string | varchar(30) | yes | |
| 81 | CLM_SF5 | string | varchar(30) | yes | |
| 82 | CLM_TQ6 | string | varchar(30) | yes | |
| 83 | CLM_SF6 | string | varchar(30) | yes | |
| 84 | CLM_STAT | string | varchar(30) | yes | |
| 85 | CLM_BAL_DUE | string | varchar(30) | yes |