VARDR Program Review
Missouri

Synthetic data. Practice names are invented. Several practices carry planted billing patterns, and several benign look-alikes are planted to show what the analysis declines to flag. Cases, people and outcomes are invented too.

Program integrity · Medicaid · Missouri

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.

Quarters that ended too recently before this date are held back as still filling in.

What the sender said about the file (optional, checked if given)
Checking stores nothing. Synthetic files only: a file with real provider numbers or direct identifiers is refused.

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 columnFilled from
    claim_idclaim_id
    line_noline_no
    billing_npibilling_npi
    rendering_npirendering_npi
    taxonomytaxonomy
    countycounty
    dosdos
    proc_codeproc_code
    modifiersmodifiers
    unitsunits
    billed_amtbilled_amt
    paid_amtpaid_amt
    pospos
    bene_age_bandbene_age_band
    bene_pidbene_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 columnFilled from
    claim_idICN-ORIG
    line_noLINE-NUM-ORIG
    medicaid_idMSIS-IDENTIFICATION-NUM
    bene_age_bandAGE-AT-SERVICE, an age in years, banded
    billing_npiBILLING-PROV-NPI-NUM
    rendering_npiSERVICING-PROV-NPI-NUM
    taxonomyBILLING-PROV-TAXONOMY
    countyPROVIDER-COUNTY-NAME
    dosBEGINNING-DATE-OF-SERVICE, a date written YYYYMMDD
    proc_codePROCEDURE-CODE
    modifiersPROCEDURE-CODE-MOD-1 + PROCEDURE-CODE-MOD-2 + PROCEDURE-CODE-MOD-3 + PROCEDURE-CODE-MOD-4, joined
    unitsSERVICE-QUANTITY-ACTUAL
    billed_amtBILLED-AMT, as dollars
    paid_amtMEDICAID-PAID-AMT, as dollars
    posPLACE-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 columnFilled from
    claim_idICN-ORIG
    line_noLINE-NUM-ORIG
    medicaid_idMSIS-IDENTIFICATION-NUM
    bene_age_bandAGE-AT-SERVICE, an age in years, banded
    billing_npiBILLING-PROV-NPI-NUM
    rendering_npiSERVICING-PROV-NPI-NUM
    taxonomyBILLING-PROV-TAXONOMY
    countyPROVIDER-COUNTY-NAME
    dosBEGINNING-DATE-OF-SERVICE, a date written YYYYMMDD
    proc_codePROCEDURE-CODE
    modifiersPROCEDURE-CODE-MOD-1 + PROCEDURE-CODE-MOD-2 + PROCEDURE-CODE-MOD-3 + PROCEDURE-CODE-MOD-4, joined
    unitsSERVICE-QUANTITY-ACTUAL
    billed_amtBILLED-AMT, as dollars
    paid_amtMEDICAID-PAID-AMT, as dollars
    posPLACE-OF-SERVICE
    claim_actionADJUSTMENT-IND, through a lookup of 3 values
    adjudicated_onADJUDICATION-DATE, a date written YYYYMMDD
    claim_versionICN-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.

ColumnMeaningFormatT-MSIS baseline
claim_idClaim identifierText, unique with line_noICN-ORIG
line_noLine number within the claimIntegerLINE-NUM-ORIG
bene_pidBeneficiary, as a keyed pseudonym. Send bene_id or medicaid_id instead to have it hashed on arrival64 hex charactersMSIS-IDENTIFICATION-NUM (hashed)
bene_age_bandBeneficiary age on the date of service, banded0-5, 6-18, 19-34, 35-54, 55-64, 65+From eligibility (age at service)
billing_npiBilling provider10-digit NPIBILLING-PROV-NPI-NUM
rendering_npiClinician who rendered the service10-digit NPI; empty means the billing providerSERVICING-PROV-NPI-NUM
taxonomyBilling provider's specialty; sets the peer groupTaxonomy codeBILLING-PROV-TAXONOMY
countyCounty the provider servesCounty nameFrom provider enrollment
dosDate of serviceYYYY-MM-DDBEGINNING-DATE-OF-SERVICE
proc_codeProcedure code5 characters, CPT or HCPCSPROCEDURE-CODE
modifiersoptionalUp to four procedure modifiersSeparated by |PROCEDURE-CODE-MOD-1 to -4
unitsUnits of servicePositive numberSERVICE-QUANTITY-ACTUAL
billed_amtAmount billedDollarsBILLED-AMT
paid_amtAmount Medicaid paidDollars, not negativeMEDICAID-PAID-AMT
posPlace of service2-digit codePLACE-OF-SERVICE
claim_actionoptionalWhat this version of the claim isoriginal, replacement or void (map the sender's codes onto these)ADJUSTMENT-IND
adjudicated_onoptionalDate this version was adjudicated; the latest version of a claim is its final stateYYYY-MM-DDADJUDICATION-DATE
claim_versionoptionalIdentifier of this version, where the sender has one; empty for the originalTextICN-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.