Issues with 99MDI1, 99MDI3, 99MDI4, and 99MDI5 have been resolved. Issues still exist with 99MDI2, but should be resolved in the next build (24C).
Included in December 2024 data tips email.
Description
99MDI4 and 99MDI5:
Member IDs (PC107) and Subscriber ID (PC108) on MedImpact pharmacy claims for 99MDI4 and 99MDI5 where paid date (PC017) >= 2023-01-01 are incorrectly formatted. The MedImpact ID length should be 8 characters. The IDs present on the pharmacy claims in this date range are 10 characters - the last 2 characters were incorrectly appended.
Workaround: Use the first 8 bytes of the member ID for these claims
Code Block
substring(PC107,1,8)
substring(PC108,1,8)
This issue will be resolved in the next APCD release.
99MDI1, 99MDI2, 99MDI3
Member IDs (ME107) and Subscriber IDs (ME117) on MedImpact member data and Member IDs (PC107) and Subscriber IDs (PC108) on MedImpact Pharmacy claims ( for 99MDI1, 99MDI2 and 99MDI3) have formatting issues. These data will be resubmitted once resolution has been found. These issues create orphaned claims.
99MDI1 - approximately 18% 4% of member records pharmacy claims do not match pharmacy claims member data on member ID therefore orphaned pharmacy claims exist. Issues exist with both the member and subscriber IDs (PC107 and PC108).
99MDI2 - approximately 30% 56% of member records pharmacy claims do not match pharmacy claims member data on member ID therefore orphaned pharmacy claims exist. Issues exist with both the member and subscriber IDs (PC107 and PC108).
99MDI3 - approximately 50% 7% of member records pharmacy claims do not match pharmacy claims member data on member ID therefore orphaned pharmacy claims exist. Issues exist with both the member and subscriber IDs (PC107 and PC108).
