Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Experiment Videos

Creating a computerized database from administrative claims data.

L T Piecoro1, L S Wang, W S Dixon

  • 1Pharmacy Practice and Science, College of Pharmacy, University of Kentucky, Lexington 40536-0082, USA. ltpiec00@pop.uky.edu

American Journal of Health-System Pharmacy : AJHP : Official Journal of the American Society of Health-System Pharmacists
|February 22, 2000
PubMed
Summary
This summary is machine-generated.

Related Concept Videos

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by
Same author

[CHK1 attenuates cardiac senescence of mice through activating Rap1/Nox4 mediated oxidative stress homeostasis].

Zhonghua xin xue guan bing za zhi·2025
Same author

[The clinical and imaging presentations of the pontine tegmental cap dysplasia].

Zhonghua er bi yan hou tou jing wai ke za zhi = Chinese journal of otorhinolaryngology head and neck surgery·2025
Same author

[Research progress on the imaging diagnostic criteria of enlarged vestibular aqueduct].

Zhonghua er bi yan hou tou jing wai ke za zhi = Chinese journal of otorhinolaryngology head and neck surgery·2025
Same author

[Effect and mechanism of DDX21 on improving myocardial ischemia-reperfusion injury by regulating ATP5J alternative splicing].

Zhonghua xin xue guan bing za zhi·2025
Same author

[Study on the mediating and moderating effects of food intake on blood glucose levels].

Zhonghua liu xing bing xue za zhi = Zhonghua liuxingbingxue zazhi·2024
Same author

[The imaging appearances of stapical footplate fistula related to inner ear malformation].

Zhonghua er bi yan hou tou jing wai ke za zhi = Chinese journal of otorhinolaryngology head and neck surgery·2024
Same journal

Impact of pharmacist involvement on hospital sepsis response teams.

American journal of health-system pharmacy : AJHP : official journal of the American Society of Health-System Pharmacists·2026
Same journal

Attributes of centralized health-system specialty pharmacy clinics: A scoping review using the Donabedian model.

American journal of health-system pharmacy : AJHP : official journal of the American Society of Health-System Pharmacists·2026
Same journal

Zoliflodacin: A novel single-dose oral antibiotic for uncomplicated urogenital gonorrhea.

American journal of health-system pharmacy : AJHP : official journal of the American Society of Health-System Pharmacists·2026
Same journal

Implementation of a paid apprenticeship-model pharmacy technician training program.

American journal of health-system pharmacy : AJHP : official journal of the American Society of Health-System Pharmacists·2026
Same journal

Iodixanol-induced acute generalized exanthematous pustulosis: Cross-reactivity to other iodinated contrast media.

American journal of health-system pharmacy : AJHP : official journal of the American Society of Health-System Pharmacists·2026
Same journal

Sonrotoclax.

American journal of health-system pharmacy : AJHP : official journal of the American Society of Health-System Pharmacists·2026
See all related articles

Creating a research database from Medicaid administrative claims data requires careful planning. Accurate file record layouts and data element dictionaries are essential for successful data conversion and analysis.

Area of Science:

  • Health Informatics
  • Health Services Research
  • Data Management

Background:

  • Medicaid administrative claims data offer a valuable resource for health services research.
  • Converting raw claims data into a usable research database presents significant technical challenges.
  • Standardized methods are needed to ensure the integrity and accuracy of converted data.

Purpose of the Study:

  • To describe the process of creating a computerized database from Medicaid administrative claims data for research.
  • To highlight critical considerations for researchers undertaking data conversion and analysis.
  • To emphasize the importance of accurate data documentation and cleaning.

Main Methods:

  • Consultation with computer experts for software selection in data manipulation and conversion.

Related Experiment Videos

  • Establishing an accurate file record layout to define data element locations and formats (including COBOL notation).
  • Development of a data element dictionary for translating coded information into usable data.
  • Data cleaning to remove denied, reversed, incomplete, or erroneous claims.

    • Main Results:

    • The location and format of data elements vary significantly across different claim types (provider, institution, pharmacy).
    • Identifying the start of the claim detail section is crucial for analyzing specific data elements.
    • Eliminating unnecessary data elements reduces database complexity and improves efficiency.
    • Data cleaning is vital for ensuring the accuracy and reliability of the final research database.

    Conclusions:

    • Accurate file record layouts and data element dictionaries are indispensable for converting administrative claims data into a research-ready computerized database.
    • Successful data conversion relies on meticulous planning, expert consultation, and rigorous data cleaning protocols.
    • The described methodology facilitates the effective utilization of Medicaid claims data for research purposes.