12-18-2014 10:38 AM
I am working with raw Medicaid data, and I cannot find any documentation for the many datasets that I have access to. A variable dictionary or codebook with actual variable descriptions would be ideal but also anything high-level that explains the difference between the various files would be helpful as well.
So this is not really a SAS question but I am hoping that someone out there who also works with this type of data might be able to point me in the right direction. Thanks in advance.
12-18-2014 11:05 AM
When you say "raw" Medicaid data, do you mean MSIS? MAX? Files from a particular state's program? Medicaid data exists in a lot of different forms.
Link to high level info about Medicaid data from CMS:
Medicaid Data Sources - General Information - Centers for Medicare & Medicaid Services
Link to Medicaid Analytic Extract (MAX) data dictionaries:
12-18-2014 11:12 AM
I think I am talking about MSIS. Provider files, Encounter files, Enrollment, UB92 claims, etc. Not High-level. And yes, it is specific to a certain state but I am hoping that there must be similarities to the data structure across states.
12-18-2014 12:01 PM
Usually the State IT people are the best source. However, Old_Buccaneer has given you the best sources publically available. If you have the data under a DUA, I would go back to the State.
12-18-2014 12:13 PM
Our data warehouse doesn't deal with MSIS -- we have been using MAX data as produced by Mathematica since it started being available -- so I don't have a lot of ready info off the top of my head. However, I did find a reference to this in some of our QA documentation:
It might give you a start on the claims and eligibility files. Provider files that have not been through the MAX process are state-specific and I don't really know anything about them; I would think the best course would be to approach the source of the files for whatever info they might have. TelligenOne is right -- for MSIS you need to talk to the people who are responsible for preparing the data for transmission to HHS. I sympathize because I know it's often difficult to locate the right person to talk to but once you find him or her they will steer you straight a lot faster than any of us will.
12-18-2014 01:25 PM
We just won a contract to manage the Mass P4P state program. I am told it is mostly based on Medicaid. I guess I will find out. I have been working with OK Medicaid data and the State people were necessary and helpful. Have you tried the State websites? Usually in the health dept.
12-18-2014 03:09 PM
So you're a contractor working with Medicaid data? And you're looking for a physical data model for the warehouse that you're working in? In my experience (all in NC), you should just ask everybody you can think of until you find something. Don't be bashful. Be direct and respectful, and people will help if they can has been my experience.
One thing to do is find out who the fiscal agent (they may call it a third party administrator) is for the state, they're the folks that will be sending the data feeds that populate the warehouse. If you can get in touch with them they might be able to get you some documentation. It will depend also on how much ETL the state does when they get the data from the fiscal agent. They may do a lot, which will make it harder to rely on the fiscal agent (although you said raw claims, so maybe not).
12-18-2014 03:13 PM
Also, I know a guy who used to work at MassHealth (I think, he definitely worked with medicaid, I just don't know if he was employed by them). He didn't do data stuff, but he might know somebody good to talk to. Want me to ask him?
12-18-2014 04:02 PM
My guy used to work at Commonwealth too it turns out. He asked what center you work with. You can email me at will dot funk at nctreasurer dot com if you want.