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

Export: Classwise OE implementation

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Module:
      BenAdmin - Export
    • Reported by:
      Client
    • Item State:
      Production Complete - Closed

      Description

      Export: Classwise OE implementation-

      [Requirement]: As per current implementation we are updating OE start date and end date of company information if company is in class wise OE. These dates we required while OE export. If we can not update these dates then this will impact OE files.
      We are doing this manually i.e. updating OE dates from back end for export. In new implementation if company is in class wise OE then we will refer class wise OE start date and end date while export.

      Note: This change we need to take on priority as we need to take a rid of manual process.

        Attachments

          Activity

          satyap Satya created issue -
          satyap Satya made changes -
          Field Original Value New Value
          Description Export: Classwise OE implementation Export: Classwise OE implementation-

          [Requirement]: As per current implementation we are updating OE start date and end date of company information if company is in class wise OE. These dates we required while OE export. If we can not update these dates then this will impact OE files.
          We are doing this manually i.e. updating OE dates from back end for export. In new implementation if company is in class wise OE then we will refer class wise OE start date and end date while export.

          Note: This change we need to take on priority as we need to take a rid of manual process.
          satyap Satya made changes -
          Status New Request [ 10029 ] Pending for Approval [ 10002 ]
          satyap Satya made changes -
          Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
          satyap Satya made changes -
          Status Approved for Development [ 10003 ] Product Backlog [ 10100 ]
          admin01 admin made changes -
          Workflow WT_Features [ 10207 ] WT_Workflow_1 [ 10467 ]
          admin01 admin made changes -
          Workflow WT_Workflow_1 [ 10467 ] WT_Features [ 10556 ]
          admin01 admin made changes -
          Workflow WT_Features [ 10556 ] WT_Workflow_1 [ 10645 ]
          admin01 admin made changes -
          Workflow WT_Workflow_1 [ 10645 ] WT_Features [ 10735 ]
          admin David Rhodes (Inactive) made changes -
          Workflow WT_Features [ 10735 ] WT_Workflow_1 [ 10824 ]
          satyap Satya made changes -
          Status Product Backlog [ 10100 ] In Development [ 10007 ]
          admin David Rhodes (Inactive) made changes -
          Workflow WT_Workflow_1 [ 10824 ] WT_Features [ 10919 ]
          admin01 admin made changes -
          Item State Parent values: Development(10200)Level 1 values: In Progress(10206)
          admin01 admin made changes -
          Issue Category Client [ 10352 ]
          satyap Satya made changes -
          Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: On Hold(10207)
          Hide
          satyap Satya added a comment -

          On Hold due to Priority task - "Payroll schedule filter on Template Information" on Export

          Show
          satyap Satya added a comment - On Hold due to Priority task - "Payroll schedule filter on Template Information" on Export
          admin01 admin made changes -
          Assignee Nandkumar [ satyap ] Satya [ ID10004 ]
          Hide
          satyap Satya added a comment -

          Design team meeting conducted for detailed analysis & approach.

          Show
          satyap Satya added a comment - Design team meeting conducted for detailed analysis & approach.
          satyap Satya made changes -
          Assignee Satya [ ID10004 ] Rohan Khandave [ rohan.khandave ]
          satyap Satya made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          satyap Satya made changes -
          Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
          satyap Satya made changes -
          Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
          satyap Satya made changes -
          Assignee Rohan Khandave [ rohan.khandave ] Ganesh Sadawarte [ ganesh.sadawarte ]
          satyap Satya made changes -
          Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
          Hide
          satyap Satya added a comment -

          Testing completed till stage. Production deployment on HOLD due to OE.

          Show
          satyap Satya added a comment - Testing completed till stage. Production deployment on HOLD due to OE.
          satyap Satya made changes -
          Developer Ganesh Sadawarte [ ganesh.sadawarte ]
          Item State Parent values: Development(10200)Level 1 values: On Hold(10207) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
          QA Aniruddha Dev [ aniruddha.dev ]
          Hide
          rakeshr Rakesh Roy (Inactive) added a comment -

          Hrishikesh DeshpandePlease update the plan for it's production deployment.

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Hrishikesh Deshpande Please update the plan for it's production deployment.
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee Ganesh Sadawarte [ ganesh.sadawarte ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
          Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Aniruddha Dev [ aniruddha.dev ]
          Hide
          aniruddha.dev Aniruddha Dev (Inactive) added a comment -

          We have decided to go with below plan for Class wise OE Enhancement testing before its deployment on Production environment.

          We will dedicate 2 hours daily starting from Friday this week i.e. 02/19/2016 to Thursday next week i.e. 02/25/2016 in the morning session for generation of OE scenarios and testing those. We will share the test scenario document after completion . We will keep two days buffer in case any urgent task. So We will plan the production deployment date after 03/01/2016.

          Note: We need these 2 hours daily for generating the scenarios before 12:00 AM (PST) and testing the OE file after 12:00 AM (PST).

          Show
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - We have decided to go with below plan for Class wise OE Enhancement testing before its deployment on Production environment. We will dedicate 2 hours daily starting from Friday this week i.e. 02/19/2016 to Thursday next week i.e. 02/25/2016 in the morning session for generation of OE scenarios and testing those. We will share the test scenario document after completion . We will keep two days buffer in case any urgent task. So We will plan the production deployment date after 03/01/2016. Note: We need these 2 hours daily for generating the scenarios before 12:00 AM (PST) and testing the OE file after 12:00 AM (PST).
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Production Due Date 19/Apr/2016
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Status Approved for production [ 10034 ] Production Testing [ 10202 ]
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
          Hide
          aniruddha.dev Aniruddha Dev (Inactive) added a comment -

          Verified below things today after patch deployment on production

          1) Class wise OE UI New Implementation - Passed (trac #13741 and trac #13740)
          2) Class wise OE Functionality - in Progress
          3) Created and Exported Payroll Data and ANSI Feeds - Passed
          4) Manually Exported some existing feeds - Passed
          5) Scheduled Feeds - Need to verify.

          No major impact found so far on production
          Testing is in progress with functional scenarios on Production

          Show
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified below things today after patch deployment on production 1) Class wise OE UI New Implementation - Passed (trac #13741 and trac #13740) 2) Class wise OE Functionality - in Progress 3) Created and Exported Payroll Data and ANSI Feeds - Passed 4) Manually Exported some existing feeds - Passed 5) Scheduled Feeds - Need to verify. No major impact found so far on production Testing is in progress with functional scenarios on Production
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
          Hide
          aniruddha.dev Aniruddha Dev (Inactive) added a comment -

          Verified below functional scenarios for Classwise OE Enhancement on Production on 'For Classwise OE Test LHP' company

          1) Started OE between 04/19/2016 to 04/20/2015 for BMC Class1 and Full Time Class2
          2) Verified that employees are able to enroll with OE Event
          3) Verified that employees are not getting any event after end of the Open Enrollment (i.e After 04/20/2016 12:00 AM PST)

          above scenarios working as expected

          Couldn't verify the scenarios on export file due to other priority tasks. will update about the scenarios on export file tomorrow

          Show
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified below functional scenarios for Classwise OE Enhancement on Production on 'For Classwise OE Test LHP' company 1) Started OE between 04/19/2016 to 04/20/2015 for BMC Class1 and Full Time Class2 2) Verified that employees are able to enroll with OE Event 3) Verified that employees are not getting any event after end of the Open Enrollment (i.e After 04/20/2016 12:00 AM PST) above scenarios working as expected Couldn't verify the scenarios on export file due to other priority tasks. will update about the scenarios on export file tomorrow
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Attachment OE Scenarios.xls [ 16100 ]
          Hide
          aniruddha.dev Aniruddha Dev (Inactive) added a comment -

          Today's verified scenarios are attached in the [^OE Scenarios.xls]

          Show
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - Today's verified scenarios are attached in the [^OE Scenarios.xls]
          Hide
          aniruddha.dev Aniruddha Dev (Inactive) added a comment -

          Can not create and verify scenarios today due to Slow Production site till 12:00 AM PST.
          Will add some scenarios today and will test it tomorrow before 12:00 AM PST

          Show
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - Can not create and verify scenarios today due to Slow Production site till 12:00 AM PST. Will add some scenarios today and will test it tomorrow before 12:00 AM PST
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Attachment OE Scenarios_26th.xls [ 16325 ]
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Attachment OE Scenarios.xls [ 16100 ]
          Hide
          aniruddha.dev Aniruddha Dev (Inactive) added a comment -

          Today Verified scenarios are attached and updated in [^OE Scenarios_26th.xls] along with old scenarios .

          Show
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - Today Verified scenarios are attached and updated in [^OE Scenarios_26th.xls] along with old scenarios .
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Attachment OE Scenarios_26th.xls [ 16325 ]
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Attachment OE Scenarios_May_4th.xls [ 16880 ]
          Hide
          aniruddha.dev Aniruddha Dev (Inactive) added a comment -

          Verified Overlapping OE for two different classes PMC and BMC . Please find attached sheet [^OE Scenarios_May_4th.xls] Updated with latest scenarios.

          Show
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified Overlapping OE for two different classes PMC and BMC . Please find attached sheet [^OE Scenarios_May_4th.xls] Updated with latest scenarios.
          Hide
          rakeshr Rakesh Roy (Inactive) added a comment -

          Aniruddha Dev Is this completed?

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Aniruddha Dev Is this completed?
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Attachment OE Scenarios_May_4th.xls [ 16880 ]
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Attachment OE Scenarios_Updated.xls [ 17404 ]
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Comment [ We have tested and verified OE scenarios with Current -Yes Future-Yes & Current-No FUTURE-Yes Flag Settings. For Two Different Classes (BMC and PMC) on LHP Copy company. Verified Intermediate as well as OE Files. Some of the scenarios are listed below.

          1) Class Change
          2) End of Year Termination
          3) Coverage ADD
          4) Coverage Drop
          5) Employee Termination
          6) Plan Changes
          7) Waive Plan
          8) New Hire Enrollment
          9) Future Dated Enrollment

          Please find attached Excel Sheet [^OE Scenarios_Updated.xls] for the Detailed scenarios and result sheet.
          All covered scenarios are working fine ]
          Hide
          aniruddha.dev Aniruddha Dev (Inactive) added a comment -

          We have tested and verified OE scenarios with Current -Yes Future-Yes & Current-No FUTURE-Yes Flag Settings. For Two Different Classes (BMC and PMC) on LHP Copy company. Verified Intermediate as well as OE Files. Some of the scenarios are listed below.

          1) Class Change
          2) End of Year Termination
          3) Coverage ADD
          4) Coverage Drop
          5) Employee Termination
          6) Plan Changes
          7) Waive Plan
          8) New Hire Enrollment
          9) Future Dated Enrollment

          Please find attached Excel Sheet OE Scenarios_Updated.xls for the Detailed scenarios and result sheet.
          All covered scenarios are working fine

          Show
          aniruddha.dev Aniruddha Dev (Inactive) added a comment - We have tested and verified OE scenarios with Current -Yes Future-Yes & Current-No FUTURE-Yes Flag Settings. For Two Different Classes (BMC and PMC) on LHP Copy company. Verified Intermediate as well as OE Files. Some of the scenarios are listed below. 1) Class Change 2) End of Year Termination 3) Coverage ADD 4) Coverage Drop 5) Employee Termination 6) Plan Changes 7) Waive Plan 8) New Hire Enrollment 9) Future Dated Enrollment Please find attached Excel Sheet OE Scenarios_Updated.xls for the Detailed scenarios and result sheet. All covered scenarios are working fine
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
          aniruddha.dev Aniruddha Dev (Inactive) made changes -
          Status Production Complete [ 10028 ] Closed [ 6 ]
          Transition Time In Source Status Execution Times
          Satya made transition -
          New Request Pending for Approval
          2h 41m 1
          Satya made transition -
          Pending for Approval Approved for Development
          2s 1
          Satya made transition -
          Approved for Development Product Backlog
          3s 1
          Satya made transition -
          Product Backlog In Development
          37d 23h 41m 1
          Satya made transition -
          In Development In LB Testing
          207d 19h 19m 1
          Satya made transition -
          In LB Testing Pending for Stage Approval
          3s 1
          Satya made transition -
          Pending for Stage Approval Approved for Stage
          2s 1
          Satya made transition -
          Approved for Stage Stage Testing
          8s 1
          Ganesh Sadawarte (Inactive) made transition -
          Stage Testing Pending for Production Approval
          76d 21h 56m 1
          Ganesh Sadawarte (Inactive) made transition -
          Pending for Production Approval Approved for production
          2s 1
          Ganesh Sadawarte (Inactive) made transition -
          Approved for production In Production Testing
          4s 1
          Aniruddha Dev (Inactive) made transition -
          In Production Testing Production Complete
          22d 7h 4m 1
          Aniruddha Dev (Inactive) made transition -
          Production Complete Closed
          412d 16h 18m 1

            People

            Assignee:
            aniruddha.dev Aniruddha Dev (Inactive)
            Reporter:
            satyap Satya
            Developer:
            Ganesh Sadawarte (Inactive)
            QA:
            Aniruddha Dev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Production Due Date: