Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-1457

MPEA Historical Data for 2015 ACA

    Details

    • Type: Support Activity
    • Status: Resolved
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Support Task Type:
      ACA Historical Data Load
    • Environment:
      Production
    • Reported by:
      Support
    • Company:
      MPEA
    • Module:
      ACA

      Description

      file available via FTP here: /users/workterraaca/MPEA

        Attachments

          Activity

          Hide
          yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

          Lena Kantemirova Nandkumar Prabhakar Karlekar Chris Finocchio Sachin Khandge

          Hi All,
          I have completed analysis of Historical data sheet provided and below are the required information is missing or need your inputs.

          1. "BCBS PPO" Plan having effective date 01/01/2016 is provided in Benefit Plan sheet. We will not import this plan in the system.

          2. Enrollment Effective Date and Enrollment Termination Date is not provided for almost all election record. we are considering
          Enrollment Effective Date = 01/01/2015
          Enrollment Termination Date = 12/31/2015
          Please confirm.

          3. Enrollment Safe Harbor is provided only for the first election record as W2 * in benefit election sheet. Can we consider Enrollment Safe Harbor as W2 for all the remaining records in the benefit election sheet? Please confirm.*

          4. Also Enrollment Employer Post-Tax and Enrollment Employee Post-Tax is provided only for the first record in the benefit election sheet.
          For the remaining election data we are considering it as zero. Please confirm.

          5. Enrollment Plan Design Identifier is not provided for some of the election data. Can we consider these employee waived their medical benefit?

          6. Employee Eligibility Cheapest Plan is not provided in Offered Benefit sheet for some employee. We will not import these or we will ignore these records. Please Confirm.

          7. Employee Eligibility Offer Start Date is not provided in Offered Benefit sheet for some employee. We will consider it as 7/1/2015.

          8. Spouse Date of Birth is not provided in the Spouse Information sheet for all the spouse. Please provide this or can we consider dummy Birth date for spouse?

          Show
          yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Lena Kantemirova Nandkumar Prabhakar Karlekar Chris Finocchio Sachin Khandge Hi All, I have completed analysis of Historical data sheet provided and below are the required information is missing or need your inputs. 1. "BCBS PPO" Plan having effective date 01/01/2016 is provided in Benefit Plan sheet. We will not import this plan in the system. 2. Enrollment Effective Date and Enrollment Termination Date is not provided for almost all election record. we are considering Enrollment Effective Date = 01/01/2015 Enrollment Termination Date = 12/31/2015 Please confirm. 3. Enrollment Safe Harbor is provided only for the first election record as W2 * in benefit election sheet. Can we consider Enrollment Safe Harbor as W2 for all the remaining records in the benefit election sheet? Please confirm.* 4. Also Enrollment Employer Post-Tax and Enrollment Employee Post-Tax is provided only for the first record in the benefit election sheet. For the remaining election data we are considering it as zero. Please confirm. 5. Enrollment Plan Design Identifier is not provided for some of the election data. Can we consider these employee waived their medical benefit? 6. Employee Eligibility Cheapest Plan is not provided in Offered Benefit sheet for some employee. We will not import these or we will ignore these records. Please Confirm. 7. Employee Eligibility Offer Start Date is not provided in Offered Benefit sheet for some employee. We will consider it as 7/1/2015. 8. Spouse Date of Birth is not provided in the Spouse Information sheet for all the spouse. Please provide this or can we consider dummy Birth date for spouse?
          Hide
          yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

          Lena Kantemirova Chris Finocchio Nandkumar Prabhakar Karlekar Sachin Khandge

          We have not received any clarification or update on above mentioned queries. Please provide your inputs on this so that we can process this asap.

          Show
          yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Lena Kantemirova Chris Finocchio Nandkumar Prabhakar Karlekar Sachin Khandge We have not received any clarification or update on above mentioned queries. Please provide your inputs on this so that we can process this asap.
          Hide
          elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive) added a comment -

          please see my answers below:
          1. please import with corrected dates: 2015
          2. confirmed - please proceed as suggested
          3. confirmed - please proceed as suggested
          4. confirmed - please proceed as suggested
          5. confirmed - please proceed as suggested
          6. confirmed - please proceed as suggested
          7. please start offer eligibility on 1.1 2015
          8. confirmed - please use dummy dates for those employees not already in WT

          Show
          elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive) added a comment - please see my answers below: 1. please import with corrected dates: 2015 2. confirmed - please proceed as suggested 3. confirmed - please proceed as suggested 4. confirmed - please proceed as suggested 5. confirmed - please proceed as suggested 6. confirmed - please proceed as suggested 7. please start offer eligibility on 1.1 2015 8. confirmed - please use dummy dates for those employees not already in WT
          Hide
          elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive) added a comment -

          answers provided in previous comment

          Show
          elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive) added a comment - answers provided in previous comment
          Hide
          yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

          Nandkumar Prabhakar Karlekar Sachin Khandge

          I have completed historical data load for MPEA on production server. You can start testing.

          Show
          yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Nandkumar Prabhakar Karlekar Sachin Khandge I have completed historical data load for MPEA on production server. You can start testing.
          Hide
          yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment -

          Lena Kantemirova Nandkumar Prabhakar Karlekar Chris Finocchio Sachin Khandge

          Abhijeet Khandagale has run the process eligibility for MPEA and also I have imported offer data for this.

          Show
          yogesh.chaudhari Yogesh Chaudhari (Inactive) added a comment - Lena Kantemirova Nandkumar Prabhakar Karlekar Chris Finocchio Sachin Khandge Abhijeet Khandagale has run the process eligibility for MPEA and also I have imported offer data for this.
          Hide
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

          Please run the report

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Please run the report
          Hide
          smita.pawar Smita Pawar (Inactive) added a comment -

          Nandkumar Prabhakar KarlekarLena Kantemirova
          We have verified historical data load on MPEA For Hspl [Production Company].

          Employees verified are as follows.

          1.Patrick Allen
          2.Aretha Glasper
          3.Zebulun Green
          4.Kinielle Johnson
          5.Michael Merchant
          6.Nancy Quoss

          There is no error in historical data load.
          We have verified this by removing additional eligibility criteria on MPEA for Hspl company.

          Note: But while testing Plan Import, we found that additional eligibility criteria is getting cloned from global plan. Request you to check whether we will require this additional eligibility criteria or not.

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - Nandkumar Prabhakar Karlekar Lena Kantemirova We have verified historical data load on MPEA For Hspl [Production Company] . Employees verified are as follows. 1.Patrick Allen 2.Aretha Glasper 3.Zebulun Green 4.Kinielle Johnson 5.Michael Merchant 6.Nancy Quoss There is no error in historical data load. We have verified this by removing additional eligibility criteria on MPEA for Hspl company. Note: But while testing Plan Import, we found that additional eligibility criteria is getting cloned from global plan. Request you to check whether we will require this additional eligibility criteria or not.
          Hide
          smita.pawar Smita Pawar (Inactive) added a comment -

          We are done with the testing

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - We are done with the testing

            People

            Assignee:
            elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive)
            Reporter:
            elena.kantemirova@ebsbenefits.com Lena Kantemirova (Inactive)
            Account Executive:
            Trisha Ponsiano (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: