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 fill paid date (PC032PC017) >= 2023-01-01 are corrupted and 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 4% of pharmacy claims do not match member data . Use with caution. The Arkansas APCD team is working with the submitter to resolve the issueon member ID therefore orphaned pharmacy claims exist. Issues exist with both the member and subscriber IDs (PC107 and PC108).
99MDI2 - approximately 56% of pharmacy claims do not match member data on member ID therefore orphaned pharmacy claims exist. Issues exist with both the member and subscriber IDs (PC107 and PC108).
99MDI3 - approximately 7% of pharmacy claims do not match member data on member ID therefore orphaned pharmacy claims exist. Issues exist with both the member and subscriber IDs (PC107 and PC108).
