Tip: Orphan Pharmacy Claims - 67369

Number

0070

Submitting Entity (SE)

67369

Add Date

Feb 19, 2021

Update Date

Jul 14, 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