State level travel metrics calculation

[adrita13]

Summary

• What data will be added?
  • Answer: Pharmacy, Hospital, FQHC, HIV, HCV, Mental Health Facility
• What years and geographic units will be added?
  • Answer: 2025, State
• Is this a new variable, or one that already exists in the registry? If existing, what is the variable's id?
  • Check here to see all existing variables.
  • Answer:
    Existing Measure Updates:
    Mental Health—MhTmDrP, MhAvTmDr, MhCtTmDr
    Hospital—HospTmDrP, HospAvTmDr, HospCtTmDr
    Pharmacy—RxTmDrP, RxAvTmDr, RxCtTmDr
    HIV Testing—HivTmDrP, HivAvTmDr, HivCtTmDr
    HCV Testing—HcvTmDrP, HcvAvTmDr, HcvCtTmDr
    FQHC—FqhcTmDrP, FqhcAvTmDr, FqhcCtTmDr

New Measures
Mental Health—MhTmDrP2, MhAvTmDr2, MhCtTmDr2
Hospital—HospTmDrP2, HospAvTmDr2, HospCtTmDr2
Pharmacy—RxTmDrP2, RxAvTmDr2, RxCtTmDr2
HIV Testing—HivTmDrP2, HivAvTmDr2, HivCtTmDr2
HCV Testing—HcvTmDrP2, HcvAvTmDr2, HcvCtTmDr2
FQHC—FqhcTmDrP2, FqhcAvTmDr2, FqhcCtTmDr2

Task completion checklist

• Create ticket for progress tracking, add the dataset name to the ticket title (this ticket!)
• Create a new branch that starts with the number of this ticket, and includes the name of the data to be added
  • Example: 244_fqhc_data_update
• Perform all processing on your source data and added content to all fo the sections below (Da
• Place any R or Python scripts you create during the process in the /scripts folder (use your new branch)
• Update the metadata document for your new data (use your new branch)
  • Or, if this new data needs its own metadata document, created one using the metadata template (use your new branch)
• Update the variables and metadata registry entries in the CMS (use your new branch)
• Create a new pull request from your new branch into the main branch, and tag @makosak as a reviewer

Data Sources

Remove this text and add the following to this section throughout the course of your work:

• Substance Abuse and Mental Health Services Administration (SAMHSA)
• 2025 State Level

Processing Notes

Remove this text and add 1-3 images of to this section around these topics:

• Recommended measures to use
• Potential issues

Data Limitations

Remove this text and add the following to this section throughout the course of your work:

• Specific comments on missing data in the source content
• Any other notes on data issues
• Potential issues