Monthly APCD User Workgroup Webinar May 27 th
Monthly APCD User Workgroup Webinar May 27 th, 2014
Agenda I. III. IV. V. Release 2. 1: Patch Available for 2. 0 Users Release 2. 1: New Application Documents Questions from Users Polls: Documentation Assessment Summer Workgroup Topics
Release 2. 1 Features • Same data as in Release 2. 0 • Dates of service (2009 -12 paid thru June 13) • No new data submissions • Important data enhancements • Highest version flags for three more payers • Master Patient Index on CY 2011 and 2012* data * Including 6 months of run out.
Master Patient Index - Summary • Custom probabilistic matching algorithm based on MA APCD data submissions • IBM Initiate Software • Refined by 12, 000+ manual reviews of proposed matches by CHIA staff • Resulting data elements • Member Link EID (Member. Link. EID) • Member Link MCL (Member. Link. MCL) • Available for 2011 and 2012 data only
Release 2. 1 Patch • Users of MA APCD Release 2. 0 may request a patch containing Release 2. 1 enhancements • Data will be provided as separate delimited files which can be imported to a database and merged (joined) with existing Release 2. 0 data using the Release ID key provided on each of the 4 file types • Contains all the same data as Release 2. 0 • Depending on your data request and approval, you may not receive ALL filing types with your Release 2. 1 Patch data extract • Example: if you did not originally request the Dental Claims file, you won’t receive Dental data in your patch extract
Requesting the Release 2. 1 Patch • Send an email to apcd. data@state. ma. us and we will send you the required amendment form
Release 2. 1 – New Application Forms • New application forms are now posted to the MA APCD website and the IRBNet document library • Updates: • • Minor tweaks to the main application form Data specification worksheet updated to include Release 2. 1 data elements • All new applications must be submitted using these forms
User Questions – Patient Death Indicator Question: Is there a way to identify if a patient died during an admission?
How to Determine if a Patient died using Case Mix Data Outpatient Hospital Emergency Department Data Deaths Departure Status Code 9 0 Description Dead on Arrival (with or without resuscitative efforts in the ED) Died during ED Visit Outpatient Hospital Observation Stay Data Deaths Departure Status Code 5 Description Expired Inpatient Hospital Discharge Data Deaths Discharge Status Code 20 Description Expired
How to Determine if a Patient died using APCD Discharge Status (MC 023) Description 20 20 20 20 20 20 40 40 40 41 41 42 Expired Expired Expired Expired Expired Expired at Home Expired in a Medical Facility Expired Place Unknown Type of Bill on Facility Code (MC 036) Description 11 12 13 14 18 21 22 23 32 33 66 72 81 82 83 85 86 89 Site of Service on NSF/CMS 1500 Claims (MC 037) Description Hospital Inpatient (Medicare Part B Only) Hospital Outpatient Diagnostic Facility Hospital Swing Bed Skilled Nursing (Medicare Part B Only) Skilled Nursing Outpatient Home Health Inpatient Coordinated Home Care (Medicare Part A) Discontinued 10/2013 Intermediate Care - Religious Non-Medical Outpatient Health Care Hospital Based or Independent Renal Dialysis Non-Hospital Based Hospice Facility Ambulatory Surgery Critical Access Hospital Residential Facility Other Outpatient Facility 21 23 31 99 81 82 33 Non-Hospital Based Hospice Facility Coordinated Home Care (Medicare Part A) Discontinued October 2013 81 Non-Hospital Based Hospice Facility 82 81 Hospital Based Hospice Facility Non-Hospital Based Hospice Facility Hospital Inpatient Emergency Dept. Skilled Nursing Facility Other Service Place
User Questions – Gender Information Question: There are 982449 members with an ‘Unknown’ gender and another 60255 members with a null gender. Is there any way to get more complete Gender information?
In the Eligibility File there are Members with ‘Unknown’ Gender (ME 013) and Members with a null Gender. Is more complete Gender Information available? While Gender* has a high rate of completeness, in instances where data is missing in the eligibility file, the information might be available on the medical claim. Gender (ME 013) in Eligibility File QA Metric Description Blank Values Data Format Errors Invalid Values Use of Valid Values QA Metric Justification Percent of records where no data is entered in the field Values that are submitted as a lowercase letter need to be converted to an uppercase letter Values are invalid if not within the lookup table Values are within the lookup table. Metric Results 3% Less than 0. 001% 96. 99% Gender (MC 012) in Medical Claims File QA Metric Description Blank Values Data Format Errors Use of Valid Values QA Metric Justification Percent of records where no data is entered in the field Values that are submitted as a lowercase letter need to be converted to an uppercase letter Values are within the lookup table. Metric Results Less than 0. 001% Less than 0. 01% 99. 99% *Member Gender can also be found in the Dental and Pharmacy Claim Files.
User Questions – Public Insurance Indicator Question: Is using the Medicaid indicator the best way to identify whether a member has public/private insurance? If so, then should we use the Medicaid indicator field from the Eligibility file or from the medical/pharmacy claims file?
Is using the Medicaid indicator the best way to identify whether a member has public/private insurance? If so, then should we use the Medicaid indicator field from the Eligibility file or from the medical/pharmacy claims file? Insurance Type Product Code Medical Claims (MC 003) 92% Threshold 0. 17% Missing Data Insurance Type Product Code Member Eligibility (ME 003) 96% Threshold Less than 0. 0005% Missing Data
Polls: User Documentation [Poll questions should pop-up on your webinar interface] Question #1: What kind of data reference tool would you prefer? Question #2: What kinds of documentation are helpful to you” (choose all that apply)
Summer Workgroup Topics • CHIA will be publishing data profiles this summer • Frequencies on common fields for the top 7 payers • Lessons learned from CHIA’s analysis of the Member Eligibility file • Additional Suggestions?
June Dates • 6/10 – Monthly APCD Technical Assistance Group Meeting • 6/24 – Monthly APCD User Workgroup Webinar • 6/26 – Data Release Committee (DRC) Meeting
Questions? • General questions about the APCD: (CHIA-APCD@state. ma. us) • Questions related to APCD applications: (apcd. data@state. ma. us) • Questions related to Casemix: (casemix. data@state. ma. us)
- Slides: 18