Issue: Orphaned Medical Claims - 67369
- Kenley Money
- Kathleen Hart (Unlicensed)
Owned by Kenley Money, created
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 |