SE 12567 was merged with SE 79413D and stopped submitting member and claims data at the end of 2015. Claims for members previously covered by SE 12567 are now in SE 79413D. During the merger, some claim records could be reported under 12567 while the member records had been moved to 79413D, hence, creating orphaned claims in 12567. Use PC107 from those orphaned claims to find ME107 in 79413D. Find the SE 79413D member records related to the SE 12567 member records by grouping on Hash Study ID (created by concatenating APCD Unique ID (ME998) and member gender (ME013)). After grouping, retrieve for SE 79413D claims using member ID (ME107). |