WORKTERRAProject Type: software

WORKTERRA

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

Tierwise cost is not changing in the ELIG ELEMENT. It always displayed cost of enrolled plan.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Environment:
      QA
    • Module:
      ACA - Reports
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed

      Description

      Tier wise cost is not changing in the ELIG element on the file. It always displayed same EE cost of enrolled plan for all tiers.

      Please refer to employee 100000013 from 'ACA Automation' company.
      Template Name - BSG - S

      Steps to repro

      Env: LB
      Company: ACA Automation
      SSN:100000013
      Element: ELIG

      Step:-
      1.Login to application
      2.Navigate to Import Export > Manual Import Export >Select Export radio button>BSG-S
      3.From date -01/01/2016-01/31/2016
      4.Click on Export button
      5.Download file

      Actual:- Tier wise cost should reflect on the file.
      Expected:- Tier wise cost should reflect on the file which is not reflecting now.

      Note: Please delete run-rate maintenance as its a full file. Let us know if you need any additional information.

        Attachments

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. WT-2601 BSG ACA Reporting

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

            Activity

            Ascending order - Click to sort in descending order
            smita.pawar Smita Pawar (Inactive) created issue -
            smita.pawar Smita Pawar (Inactive) made changes -
            Field Original Value New Value
            Assignee Vijay Siddha [ vijays ] Smita Pawar [ smita.pawar ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Yogesh Chaudhari [ yogesh.chaudhari ]
            Component/s ACA [ 10004 ]
            Description Tierwise cost is not changing in the ELIG ELEMENT. It always displayed cost of enrolled plan. Tier wise cost is not changing in the ELIG element on the file. It always displayed same EE cost of enrolled plan foe all tiers.

            Please refer to employee 100000013 from 'ACA Automation' company.
            Issue Category EBS [ 10350 ] Harbinger [ 10700 ]
            Module Parent values: BenAdmin(10100) Parent values: ACA(10104)Level 1 values: Reports(12001)
            Priority Medium [ 3 ] High [ 2 ]
            QA Smita Pawar [ smita.pawar ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Description Tier wise cost is not changing in the ELIG element on the file. It always displayed same EE cost of enrolled plan foe all tiers.

            Please refer to employee 100000013 from 'ACA Automation' company.             		Tier wise cost is not changing in the ELIG element on the file. It always displayed same EE cost of enrolled plan for all tiers.

            Please refer to employee 100000013 from 'ACA Automation' company.
            Template Name - BSG - S
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Link This issue relates to WT-2601 [ WT-2601 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Environment LB [ 10800 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Description Tier wise cost is not changing in the ELIG element on the file. It always displayed same EE cost of enrolled plan for all tiers.

            Please refer to employee 100000013 from 'ACA Automation' company.
            Template Name - BSG - S
            		 Tier wise cost is not changing in the ELIG element on the file. It always displayed same EE cost of enrolled plan for all tiers.

            Please refer to employee 100000013 from 'ACA Automation' company.
            Template Name - BSG - S

            Steps to repro

            Env: LB
            Company: ACA Automation
            SSN:100000013
            Element: ELIG

            Step:-
            1.Login to application
            2.Navigate to Import Export > Manual Import Export >Select Export radio button>BSG-S
            3.From date -01/01/2016-01/31/2016
            4.Click on Export button
            5.Download file

            Actual:- Tier wise cost should reflect on the file.
            Expected:- Tier wise cost should reflect on the file which is not reflecting now.

            Note: Please delete run-rate maintenance as its a full file. Let us know if you need any additional information.
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Yogesh Chaudhari [ yogesh.chaudhari ] Ramya Tantry [ ramya.tantry ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            gokul.sonawane Gokul Sonawane (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            Hide
            Permalink
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Concern: Tierwise cost is not changing in the ELIG ELEMENT. It always displayed cost of enrolled plan.
            Cause: In Fields table,destination column name was set to a value which was getting referred for enrollment details.
            So enrolled plan cost was displayed for all.
            Correction: We have updated the destination column name.

            Files affected:
            07_Data/074_WT3955_WTB_ACA_ModData_Fields.sql
            07_data/075_WT3955_WTB_ACA_ModData_Fields.sql
            03_Views/dbo.OES_VIEW_ACA_Export_Eligibility.View.sql

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Concern : Tierwise cost is not changing in the ELIG ELEMENT. It always displayed cost of enrolled plan. Cause : In Fields table,destination column name was set to a value which was getting referred for enrollment details. So enrolled plan cost was displayed for all. Correction : We have updated the destination column name. Files affected : 07_Data/074_WT3955_WTB_ACA_ModData_Fields.sql 07_data/075_WT3955_WTB_ACA_ModData_Fields.sql 03_Views/dbo.OES_VIEW_ACA_Export_Eligibility.View.sql
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Smita Pawar [ smita.pawar ]
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned issue on LB (ACA Automation company). Its
            working fine. But we will move this Jira to stage when BSG- ACA File implementation Jira 2601.
            Hence marking this ticket as on LB-On hold.

            Attaching Screen shot for verified employee.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on LB (ACA Automation company). Its working fine. But we will move this Jira to stage when BSG- ACA File implementation Jira 2601. Hence marking this ticket as on LB-On hold. Attaching Screen shot for verified employee.
            smita.pawar Smita Pawar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: On Hold(10211)
            smita.pawar Smita Pawar (Inactive) made changes -
            Attachment 10000005.png [ 24203 ]
            gokul.sonawane Gokul Sonawane (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            gokul.sonawane Gokul Sonawane (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            smita.pawar Smita Pawar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned issue on stage company [ACA Automation].
            For below mentioned employee, we have verified tier wise cost.
            Now tier wise correct cost is displaying on the file

            OFFR|100000020|Employee Data Change|Employee Data Change|01/01/2016|01/01/2016|01/01/2016|12/31/2016|08/09/2016 03:19:57.1957 PM
            ELIG|100000020|Employee Data Change|BSGPlanTwo_OLD|BSG plan Two|EE|Employee|Y|120.00|220.00|Y|Y|YES|YES|Y|64.71|Y|
            ELIG|100000020|Employee Data Change|BSGPlanTwo_OLD|BSG plan Two|EE+Family|Employee + Family|Y|125.00|225.00|Y|Y|YES|YES|Y|64.29|Y|
            ELIG|100000020|Employee Data Change|BSGPlanTwo_OLD|BSG plan Two|EE + CH|Employee + 1|Y|125.00|225.00|Y|Y|YES|YES|Y|64.29|Y|
            ELIG|100000020|Employee Data Change|BSGPlanTwo_OLD|BSG plan Two|EE + SP|Employee + Spouse|Y|125.00|225.00|Y|Y|YES|YES|Y|64.29|Y|

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on stage company [ACA Automation] . For below mentioned employee, we have verified tier wise cost. Now tier wise correct cost is displaying on the file OFFR|100000020|Employee Data Change|Employee Data Change|01/01/2016|01/01/2016|01/01/2016|12/31/2016|08/09/2016 03:19:57.1957 PM ELIG|100000020|Employee Data Change|BSGPlanTwo_OLD|BSG plan Two|EE|Employee|Y|120.00|220.00|Y|Y|YES|YES|Y|64.71|Y| ELIG|100000020|Employee Data Change|BSGPlanTwo_OLD|BSG plan Two|EE+Family|Employee + Family|Y|125.00|225.00|Y|Y|YES|YES|Y|64.29|Y| ELIG|100000020|Employee Data Change|BSGPlanTwo_OLD|BSG plan Two|EE + CH|Employee + 1|Y|125.00|225.00|Y|Y|YES|YES|Y|64.29|Y| ELIG|100000020|Employee Data Change|BSGPlanTwo_OLD|BSG plan Two|EE + SP|Employee + Spouse|Y|125.00|225.00|Y|Y|YES|YES|Y|64.29|Y|
            smita.pawar Smita Pawar (Inactive) made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            We will move this Jira to Production with WT-2601

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We will move this Jira to Production with WT-2601
            satyap Satya made changes -
            Item State Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            Hide
            Permalink
            mahendra.mungase Mahendra Mungase (Inactive) added a comment -

            Company Name - For ACA BSGTest ACAAutomation HSPL

            We have regressed this issue on Production and observed that issue does not exist. Hence closing the same.

            Show
            mahendra.mungase Mahendra Mungase (Inactive) added a comment - Company Name - For ACA BSGTest ACAAutomation HSPL We have regressed this issue on Production and observed that issue does not exist. Hence closing the same.
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Resolution Fixed [ 1 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Status Production Complete [ 10028 ] Closed [ 6 ]
            mahendra.mungase Mahendra Mungase (Inactive) made changes -
            Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            Transition Time In Source Status Execution Times
            Ramya Tantry (Inactive) made transition -
            Open In Development
            		2d 23h 50m 1
            Ramya Tantry (Inactive) made transition -
            In Development In LB Testing
            		1h 17m 1
            Smita Pawar (Inactive) made transition -
            In LB Testing Stage Testing
            		10d 23h 44m 1
            Mahendra Mungase (Inactive) made transition -
            Stage Testing In Production Testing
            		17d 1h 21m 1
            Mahendra Mungase (Inactive) made transition -
            In Production Testing Production Complete
            		17s 1
            Mahendra Mungase (Inactive) made transition -
            Production Complete Closed
            		2s 1

              People

              Assignee:
              smita.pawar Smita Pawar (Inactive)
              Reporter:
              smita.pawar Smita Pawar (Inactive)
              QA:
              Smita Pawar (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: