WORKTERRAProject Type: software

WORKTERRA

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

Remove CDC dependency from Export

    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:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have
    • Sprint:
      WT Sprint 34 - Enhancements
    • Severity:
      Complex

      Description

      For Cobra Data template type we currently use CDC feature of Microsoft to gather and track data changes.

      Now a days, CDC services are failing frequently and using more resources which in turn making system slow.

      We need to find out a way to handle this internally and removed CDC dependency.

        Attachments

        1. AffectedFiles.txt
          0.1 kB
          Rakesh Shahane
        2. WT-7076_COBRA_TC_.xls
          16 kB
          Aniruddha Dev

          Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. WT-10687 Export > Incorrect COBRA Reason populating on file.

          • High - Serious problem that could block progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-10688 Export > COBRA Participants dependents not exporting on file

          • High - Serious problem that could block progress.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. WT-10774 Export / EDS > No records exported for Divorce event created using Divorce QE

          • High - Serious problem that could block progress.
          • Closed
          is duplicated by

          Enhancement - An improvement or enhancement to an existing feature or task. WT-9141 Remove CDC dependency from Employee Data Screens

          • High - Serious problem that could block progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            10 older comments
            Hide
            Permalink
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Verified all scenarios again on 2017 Prime Healthcare for HSPL company on stage by creating new event builders for

            1) termination
            2) retirement
            3) Ineligible Dependent
            4) Death
            5) divorce
            6) Class Change

            and observed all the New HR simplified COBRA files on company. Records exported on all files are proper.

            Note: Overage Dependent scenarios are created for tomorrow . Will update the status once these are verified .

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified all scenarios again on 2017 Prime Healthcare for HSPL company on stage by creating new event builders for 1) termination 2) retirement 3) Ineligible Dependent 4) Death 5) divorce 6) Class Change and observed all the New HR simplified COBRA files on company. Records exported on all files are proper. Note : Overage Dependent scenarios are created for tomorrow . Will update the status once these are verified .
            Hide
            Permalink
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Verified remaining OAD scenarios along with Divorce followed by Termination scenario on New HR simplified files on 2017 Prime HealthCare for HSPL company on stage .

            Scenarios working as expected . Ready for Production

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified remaining OAD scenarios along with Divorce followed by Termination scenario on New HR simplified files on 2017 Prime HealthCare for HSPL company on stage . Scenarios working as expected . Ready for Production
            Hide
            Permalink
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Keeping this on hold for Production . As we will be deploying Export enhancement after around a week of WT-9141 EDS deployement.

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Keeping this on hold for Production . As we will be deploying Export enhancement after around a week of WT-9141 EDS deployement.
            Hide
            Permalink
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Verified its impact on ongoing COBRA feeds on production like Discovery COBRA feed on JE Dunn company and New HR Simplified feeds on Prime Healthcare. No impact observed. Ready for Production

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified its impact on ongoing COBRA feeds on production like Discovery COBRA feed on JE Dunn company and New HR Simplified feeds on Prime Healthcare. No impact observed. Ready for Production
            Hide
            Permalink
            aniruddha.dev Aniruddha Dev (Inactive) added a comment -

            Verified this Enhancement on Production for COBRA data template with following scenarios without enabling CDC

            1) Termination
            2) retirement
            3) Death
            4) Divorce

            Scenarios worked as expected.

            Show
            aniruddha.dev Aniruddha Dev (Inactive) added a comment - Verified this Enhancement on Production for COBRA data template with following scenarios without enabling CDC 1) Termination 2) retirement 3) Death 4) Divorce Scenarios worked as expected.

              People

              Assignee:
              aniruddha.dev Aniruddha Dev (Inactive)
              Reporter:
              Vinayak.Kulkarni Vinayak Kulkarni (Inactive)
              Account Executive:
              Vinayak Kulkarni (Inactive)
              Developer:
              Rakesh Shahane (Inactive)
              QA:
              Aniruddha Dev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Dev Due Date:
                Pre-Prod Due Date:
                Code Review Date:

                  Time Tracking

                  Estimated:
                  Original Estimate - 35h Original Estimate - 35h
                  35h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 86h 32m
                  86h 32m