Number
0070
Submitting Entity (SE)
67369
Add Date
19 Feb 2021
Update Date
14 Jul 2023
Update
Included in July 2023 Data Tips Email
Description
67369 has orphaned pharmacy claims. Some member IDs in member data have trailing zeros. Use the following suggested code to join 67369 pharmacy and member: PC001 = ME001 and (PC107 = left(ME107,10) or PC107 = ME107).
Active/Resolved
Active
Action / Resolution
This will not be resolved.
Category 1
Orphaned Claims
Category 2
Data Quality
Tip / Issue
Tip