mcaid_claim_f: Medicaid member claim summary

In PHSKC-APDE/Medicaid: Query and analyze WA State Medicaid, Medicare, and APCD data

Medicaid member claim summary

Description

mcaid_claim_f queries a SQL server to return Medicaid member eligibility, demographic and claim summary information.

Usage

mcaid_claim_f(
  server,
  from_date = Sys.Date() - months(12),
  to_date = Sys.Date() - months(6),
  covmin = 0,
  ccov_min = 1,
  covgap_max = "null",
  dualmax = 100,
  agemin = 0,
  agemax = 200,
  female = "null",
  male = "null",
  aian = "null",
  asian = "null",
  black = "null",
  nhpi = "null",
  white = "null",
  latino = "null",
  zip = "null",
  region = "null",
  english = "null",
  spanish = "null",
  vietnamese = "null",
  chinese = "null",
  somali = "null",
  russian = "null",
  arabic = "null",
  korean = "null",
  ukrainian = "null",
  amharic = "null",
  maxlang = "null",
  id = "null",
  detailed_claims = FALSE
)

Arguments

server	SQL server connection created using odbc package
from_date	Begin date for Medicaid coverage period, "YYYY-MM-DD", defaults to 12 months prior to today's date
to_date	End date for Medicaid coverage period, "YYYY-MM-DD", defaults to 6 months prior to today's date
covmin	Minimum coverage required during requested date range (percent scale), defaults to 0
ccov_min	Minimum continuous coverage required during requested date range (days), defaults to 1
covgap_max	Maximum gap in continuous coverage allowed during requested date range (days), defaults to null
dualmax	Maximum Medicare-Medicaid dual eligibility coverage allowed during requested date range (percent scale), defaults to 100
agemin	Minimum age for cohort (integer), age is calculated as of last day of requested date range, defaults to 0
agemax	Maximum age for cohort (integer), age is calculated as of last day of requested date range, defaults to 200
female	Alone or in combination female gender over entire member history, defaults to null
male	Alone or in combination female gender over entire member history, defaults to null
aian	Alone or in combination American Indian/Alaska Native race over entire member history, defaults to null
asian	Alone or in combination Asian race over entire member history, defaults to null
black	Alone or in combination Black race over entire member history, defaults to null
nhpi	Alone or in combination Native Hawaiian/Pacific Islander race over entire member history, defaults to null
white	Alone or in combination white race over entire member history, defaults to null
latino	Alone or in combination Latino race over entire member history, defaults to null
zip	Most frequently reported ZIP code during requested date range, eg. "98103,98105", defaults to null
region	Most frequently mapped HRA based region during requested date range, e.g, "east,north,seattle,south", defaults to null
english	Alone or in combination English written or spoken language over entire member history, defaults to null
spanish	Alone or in combination Spanish written or spoken language over entire member history, defaults to null
vietnamese	Alone or in combination Vietnamese written or spoken language over entire member history, defaults to null
chinese	Alone or in combination Chinese written or spoken language over entire member history, defaults to null
somali	Alone or in combination Somali written or spoken language over entire member history, defaults to null
russian	Alone or in combination Russian written or spoken language over entire member history, defaults to null
arabic	Alone or in combination Arabic written or spoken language over entire member history, defaults to null
korean	Alone or in combination Korean written or spoken language over entire member history, defaults to null
ukrainian	Alone or in combination Ukrainian written or spoken language over entire member history, defaults to null
amharic	Alone or in combination Amharic written or spoken language over entire member history, defaults to null
maxlang	Most frequently reported spoken/written language, e.g. "SOMALI,ARABIC", defaults to null
id	List of requested Medicaid ProviderOne IDs, defaults to null
detailed_claims	Request detailed claim summary information (takes longer to run), defaults to FALSE

Details

LARGELY FOR INTERNAL USE This function builds and sends a SQL query to return a data set of Medicaid member and claim information using specified parameters, including coverage time period, coverage characteristics (e.g. Medicare dual eligibility), and member demographics. mcaid_Claim_f is a wrapper for mcaid_elig_f

Examples

## Not run: 
mcaid_claim_f(server = db.claims51, from_date = "2017-01-01", to_date = "2017-06-30")
mcaid_claim_f(server = db.claims51, from_date = "2017-01-01", to_date = "2017-06-30", agemin = 18, 
agemax = 64, maxlang = "ARABIC,SOMALI", zip = "98103,98105")  

## End(Not run)

PHSKC-APDE/Medicaid documentation built on April 19, 2024, 11:18 a.m.