Issue: Orphaned Medical Claims - 67369

Number

0071

Submitting Entity (SE)

67369

Add Date

Feb 19, 2021

Update Date

Jul 12, 2024 Aug 7, 2024

Update

Data resubmitted. Issue resolved. Included in August 2024 data tips email.

Description

RESOLVED. Some member and medical claims don’t match because of inconsistent leading zeros in the Person Code (ME010 or MC009) that Cigna uses to create the member ID. For example, the Person Code is 3, MC137 = ‘866101693’ and ME107 = ‘8661016903’. The workaround is to join using the following: (LEFT(mc141, LEN(MC141)-2) = LEFT(ME117, LEN(ME117)-2)) and MC009 = ME010 and MC001 = ME001.

Active/Resolved

Data resubmitted. Issue resolved.

Action / Resolution

There is no resolution.

Category 1

Orphaned Claims

Category 2

Data Quality

Tip / Issue

Issue