Data
The claim extracts this program has received and the one it is running on. A file is accepted, quarantined or refused, with the reason recorded. Nothing here shows a claim line.
What the program is running on
Every screen analyses this extract. Changing it is recorded, and creates a new analysis run rather than altering an old one.
The built-in synthetic extract. Complete by construction, so no quarter is held back.
Load a claim extract
One row per paid claim line. To try this end to end, download the synthetic extract and load it with the Canonical profile.
Batches received: 0
Newest first. A refused file keeps its reason and none of its lines. A quarantined batch is stored and cannot be analysed until someone releases it.
Nothing has been loaded yet.
Reference data
What the program checks its practices against and divides by. Each kind uses the file someone loaded or, until then, synthetic data built in. Loading a file puts it in use and is recorded; an uploaded extract is analysed again as a new run.
- Federal exclusion list
Practices are compared with it by NPI and by business name. A match stays unverified until a person decides.
The published file as downloaded (LASTNAME, FIRSTNAME, BUSNAME, NPI, STATE, EXCLTYPE, EXCLDATE, REINDATE and the rest). Dates of birth and addresses are not read, and an individual with no NPI is not kept.
In use: synthetic data, built in. Download it to try loading a file.
- National provider registry
Names providers in an uploaded extract, and notes a practice that is not listed, is shown deactivated, or has a different primary taxonomy.
The published file's columns, cut down to this State. Addresses and telephone numbers are not read, and rows for other States are not kept.
In use: synthetic data, built in. Download it to try loading a file.
- County denominators
Resident population and eligible member-months by county and quarter: what a rate divides by. Used with an uploaded extract; the built-in extract carries its own.
One row per county and quarter: county, quarter, population, mm_0_5, mm_6_18, mm_19_34, mm_35_54, mm_55_64, mm_65_plus.
In use: synthetic data, built in. Download it to try loading a file.
Mapping profiles
How an agency's columns become the canonical ones. A profile is data: a rename, a date format, columns joined, a lookup, a constant, an age banded. A file with direct identifiers is refused whole, whether or not the profile reads them. A profile also says how the file carries adjusted and voided claims: each claim once in its final state, or every version for this product to net.
Canonical canonical@1 Built incomma-delimitedFinal-action claims onlyThe file already uses the canonical column names. This is what the synthetic extract downloads as.
Canonical column Filled from claim_id claim_id line_no line_no billing_npi billing_npi rendering_npi rendering_npi taxonomy taxonomy county county dos dos proc_code proc_code modifiers modifiers units units billed_amt billed_amt paid_amt paid_amt pos pos bene_age_band bene_age_band bene_pid bene_pid T-MSIS other-services claim lines (baseline) tmsis-ot-baseline@2 Built inpipe-delimitedFinal-action claims onlyColumns named after the T-MSIS OT claim-line file, with county and age at service joined in by the sender from enrollment and eligibility. Element names follow the T-MSIS data guide, version 4. The billing provider's NPI and taxonomy are on the claim header there, so the sender joins header to line. A starting point for an agency's own profile.
Canonical column Filled from claim_id ICN-ORIG line_no LINE-NUM-ORIG medicaid_id MSIS-IDENTIFICATION-NUM bene_age_band AGE-AT-SERVICE, an age in years, banded billing_npi BILLING-PROV-NPI-NUM rendering_npi SERVICING-PROV-NPI-NUM taxonomy BILLING-PROV-TAXONOMY county PROVIDER-COUNTY-NAME dos BEGINNING-DATE-OF-SERVICE, a date written YYYYMMDD proc_code PROCEDURE-CODE modifiers PROCEDURE-CODE-MOD-1 + PROCEDURE-CODE-MOD-2 + PROCEDURE-CODE-MOD-3 + PROCEDURE-CODE-MOD-4, joined units SERVICE-QUANTITY-ACTUAL billed_amt BILLED-AMT, as dollars paid_amt MEDICAID-PAID-AMT, as dollars pos PLACE-OF-SERVICE T-MSIS other-services claim lines, every version (netted here) tmsis-ot-all-versions@1 Built inpipe-delimitedEvery version, netted hereAs the baseline, for a file that carries originals, replacements and voids. Each claim is reduced to the version adjudicated last, and a claim whose last version is a void is dropped. The adjustment codes mapped here (0 original, 4 replacement, 1 void) are as recalled from the T-MSIS data guide and were not checked against it; a file with any other code is refused, not guessed at. A starting point for an agency's own profile.
Canonical column Filled from claim_id ICN-ORIG line_no LINE-NUM-ORIG medicaid_id MSIS-IDENTIFICATION-NUM bene_age_band AGE-AT-SERVICE, an age in years, banded billing_npi BILLING-PROV-NPI-NUM rendering_npi SERVICING-PROV-NPI-NUM taxonomy BILLING-PROV-TAXONOMY county PROVIDER-COUNTY-NAME dos BEGINNING-DATE-OF-SERVICE, a date written YYYYMMDD proc_code PROCEDURE-CODE modifiers PROCEDURE-CODE-MOD-1 + PROCEDURE-CODE-MOD-2 + PROCEDURE-CODE-MOD-3 + PROCEDURE-CODE-MOD-4, joined units SERVICE-QUANTITY-ACTUAL billed_amt BILLED-AMT, as dollars paid_amt MEDICAID-PAID-AMT, as dollars pos PLACE-OF-SERVICE claim_action ADJUSTMENT-IND, through a lookup of 3 values adjudicated_on ADJUDICATION-DATE, a date written YYYYMMDD claim_version ICN-ADJ
Defining a profile is program configuration and belongs to a program administrator.
The canonical claim line
What every extract is mapped to. The T-MSIS element beside each column is where an agency would usually find the value; the names follow the T-MSIS data guide, version 4.
| Column | Meaning | Format | T-MSIS baseline |
|---|---|---|---|
| claim_id | Claim identifier | Text, unique with line_no | ICN-ORIG |
| line_no | Line number within the claim | Integer | LINE-NUM-ORIG |
| bene_pid | Beneficiary, as a keyed pseudonym. Send bene_id or medicaid_id instead to have it hashed on arrival | 64 hex characters | MSIS-IDENTIFICATION-NUM (hashed) |
| bene_age_band | Beneficiary age on the date of service, banded | 0-5, 6-18, 19-34, 35-54, 55-64, 65+ | From eligibility (age at service) |
| billing_npi | Billing provider | 10-digit NPI | BILLING-PROV-NPI-NUM |
| rendering_npi | Clinician who rendered the service | 10-digit NPI; empty means the billing provider | SERVICING-PROV-NPI-NUM |
| taxonomy | Billing provider's specialty; sets the peer group | Taxonomy code | BILLING-PROV-TAXONOMY |
| county | County the provider serves | County name | From provider enrollment |
| dos | Date of service | YYYY-MM-DD | BEGINNING-DATE-OF-SERVICE |
| proc_code | Procedure code | 5 characters, CPT or HCPCS | PROCEDURE-CODE |
| modifiersoptional | Up to four procedure modifiers | Separated by | | PROCEDURE-CODE-MOD-1 to -4 |
| units | Units of service | Positive number | SERVICE-QUANTITY-ACTUAL |
| billed_amt | Amount billed | Dollars | BILLED-AMT |
| paid_amt | Amount Medicaid paid | Dollars, not negative | MEDICAID-PAID-AMT |
| pos | Place of service | 2-digit code | PLACE-OF-SERVICE |
| claim_actionoptional | What this version of the claim is | original, replacement or void (map the sender's codes onto these) | ADJUSTMENT-IND |
| adjudicated_onoptional | Date this version was adjudicated; the latest version of a claim is its final state | YYYY-MM-DD | ADJUDICATION-DATE |
| claim_versionoptional | Identifier of this version, where the sender has one; empty for the original | Text | ICN-ADJ |
The last three columns describe versions of a claim. A profile set to "claimVersions": "net" keeps, for each claim, the version adjudicated last and drops a claim that ends as a void. Set to "final-action", which is the default, a file that carries a claim twice or carries a void is refused. Versions are matched within one file.
A quarter is analysed once the extract date is at least 90 days past the quarter’s last day.