Description | Several Qualchoice plans have been acquired by Celtic (80799). Qualchoice data quantities will reduce over time as Celtic takes over the plan management The last eligibility, medical and pharmacy claim files for 95448B were through Q4 2019. Provider is the only file with data up to Q2 2020. However, their provider data is repeated and there is no date in PRV to determine the period ending 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. |
---|