Tip: Orphaned Medical Claims - 60054A
Number | 0073 |
|---|---|
Submitting Entity (SE) | 60054 |
Add Date | Feb 19, 2021 |
Update Date | May 18, 2023 |
Update | Included in June 2023 data tips email |
Description | Orphaned medical claims exist because the leading zeros in person code (ME010, MC009) that Aetna uses to construct the member ID are not present. For example, MC137 = ‘2115075451’ and ME107 = ‘211507545001’. Use this join A.MC141 = B.ME117 and A.MC009 = B.ME010 and A.MC001 = B.ME001 to resolve most orphans. |
Active/Resolved | Resolved |
Action / Resolution | Corrected in build 22D |
Category 1 | Orphaned claims |
Category 2 | Data Quality |
Tip / Issue | Tip |