WORKTERRAProject Type: software

WORKTERRA

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

ACA_ACA1095-C Analytics report_[MEC Indicator based on this run]Data is not displaying on the report.

    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 - 2017
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed

      Description

      1.Login to LB with Partner.
      2.Edit company say "ACAautomation".
      3.Navigate to Home << Company Home << BenAdmin Home << BenAdmin Company Home << ACA << IRS Report
      4.Run already existing report "1095-C code J"
      5.Down load Data analysis report and Check 'ACA 1095-C report analytics' tab.

      Actual: MEC data based on this run displaying no data
      Expected: Data should get reflected on the file

        Attachments

          Issue Links

          relates to

          Enhancement - An improvement or enhancement to an existing feature or task. WT-5809 ACA 2017 : New changes for Tax year 2016.

          • Medium - Has the potential to affect 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 Nandkumar [ satyap ] Smita Pawar [ smita.pawar ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Assignee Smita Pawar [ smita.pawar ] Ramya Tantry [ ramya.tantry ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Attachment Data Analytics.png [ 31299 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Link This issue relates to WT-5809 [ WT-5809 ]
            Hide
            Permalink
            ramya.tantry Ramya Tantry (Inactive) added a comment - - edited

            Files Affected:

            MasterCompanyDB/04_Stored Procedures/OES_SP_Get_1095CollectiveData.sql

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - - edited Files Affected: MasterCompanyDB/04_Stored Procedures/OES_SP_Get_1095CollectiveData.sql
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            Hide
            Permalink
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Concern: ACA_ACA1095-C Analytics report_[MEC Indicator based on this run]Data is not displaying on the report.
            Cause: MEC indicator is yes/no based on if ALE Member offered minimum essential coverage to at least 95% of its full-time employees and their dependents. i.e we have checked codes for 1A,1E,1C. But the 1095C report has only 2 employee with 1J/1H codes.
            So the temp table come up with null values and Null values are not shown on report.
            Correction: Made changes to reflect '-' if Null is present.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Concern : ACA_ACA1095-C Analytics report_ [MEC Indicator based on this run] Data is not displaying on the report. Cause : MEC indicator is yes/no based on if ALE Member offered minimum essential coverage to at least 95% of its full-time employees and their dependents. i.e we have checked codes for 1A,1E,1C. But the 1095C report has only 2 employee with 1J/1H codes. So the temp table come up with null values and Null values are not shown on report. Correction : Made changes to reflect '-' if Null is present.
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            Issue 2: Similarly addition of percentages on [MEC Indicator based on this run] is greater than 100.
            Same steps to repro

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - Issue 2: Similarly addition of percentages on [MEC Indicator based on this run] is greater than 100. Same steps to repro
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Smita Pawar [ smita.pawar ]
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Hide
            Permalink
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            For Issue 2:
            Distinct Employee was getting considered for calculation of percentage,so the percentage addition was going above 100.

            This issue has been resolved and already deployed on LB and Stage.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - For Issue 2: Distinct Employee was getting considered for calculation of percentage,so the percentage addition was going above 100. This issue has been resolved and already deployed on LB and Stage.
            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: In Testing(10210)
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment - - edited

            We have verified above mentioned issue on LB company [ACA Automation].
            It working fine.

            Tested other scenarios are as follows.

            1. Changed label as "No. of records with this Combination" in ACA 1095C Employee Count.
            2. Checked whether Percentage is less than 100 for ACA 1095C Code Analysis.
            3. Total number of New Hire employees in Run.
            4.Checked whether offer methods are displaying correctly on Report or not.
            5.Points verified in "MEC Indicator based on this run".
            a.Checked whether Month names are getting displayed correctly or not.
            b.Not any column is blank or with '-'

            Note: Attached Screen shot for additional information

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - - edited We have verified above mentioned issue on LB company [ACA Automation] . It working fine. Tested other scenarios are as follows. 1. Changed label as "No. of records with this Combination" in ACA 1095C Employee Count. 2. Checked whether Percentage is less than 100 for ACA 1095C Code Analysis. 3. Total number of New Hire employees in Run. 4.Checked whether offer methods are displaying correctly on Report or not. 5.Points verified in "MEC Indicator based on this run". a.Checked whether Month names are getting displayed correctly or not. b.Not any column is blank or with '-' Note: Attached Screen shot for additional information
            smita.pawar Smita Pawar (Inactive) made changes -
            Attachment MEC indicator in this run.png [ 31892 ]
            smita.pawar Smita Pawar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned issue on Stage company [ACA Automation].
            It working fine.
            Tested other scenarios are as follows.
            1. Changed label as "No. of records with this Combination" in ACA 1095C Employee Count.
            2. Checked whether Percentage is less than 100 for ACA 1095C Code Analysis.
            3. Total number of New Hire employees in Run.
            4.Checked whether offer methods are displaying correctly on Report or not.
            5.Points verified in "MEC Indicator based on this run".
            a.Checked whether Month names are getting displayed correctly or not.
            b.Not any column is blank or with '-'
            Note: Attached Screen shot for additional information

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on Stage company [ACA Automation] . It working fine. Tested other scenarios are as follows. 1. Changed label as "No. of records with this Combination" in ACA 1095C Employee Count. 2. Checked whether Percentage is less than 100 for ACA 1095C Code Analysis. 3. Total number of New Hire employees in Run. 4.Checked whether offer methods are displaying correctly on Report or not. 5.Points verified in "MEC Indicator based on this run". a.Checked whether Month names are getting displayed correctly or not. b.Not any column is blank or with '-' Note: Attached Screen shot for additional information
            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)
            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: Ready for Production(10217)
            ashwin.wankhede Ashwin Wankhede (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: Production Deployed(10221)
            smita.pawar Smita Pawar (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            smita.pawar Smita Pawar (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
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            We have verified above mentioned issue on Production [For ACA BSGTest ACAAutomation HSPL].
            It working fine
            Attaching screen shot for additional information.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned issue on Production [For ACA BSGTest ACAAutomation HSPL] . It working fine Attaching screen shot for additional information.
            smita.pawar Smita Pawar (Inactive) made changes -
            Attachment Code analytics .png [ 32223 ]
            smita.pawar Smita Pawar (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)
            Hide
            Permalink
            smita.pawar Smita Pawar (Inactive) added a comment -

            This issue is fixed.

            Show
            smita.pawar Smita Pawar (Inactive) added a comment - This issue is fixed.
            smita.pawar Smita Pawar (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 ]
            satyap Satya made changes -
            Environment_New LB [ 18444 ]
            Transition Time In Source Status Execution Times
            Ramya Tantry (Inactive) made transition -
            Open In Development
            		3d 4h 59m 1
            Ramya Tantry (Inactive) made transition -
            In Development In LB Testing
            		2h 22m 1
            Sachin Hingole (Inactive) made transition -
            In LB Testing Stage Testing
            		3d 22h 37m 1
            Smita Pawar (Inactive) made transition -
            Stage Testing In Production Testing
            		2d 57m 1
            Smita Pawar (Inactive) made transition -
            In Production Testing Production Complete
            		1d 1h 41m 1
            Mahendra Mungase (Inactive) made transition -
            Production Complete Closed
            		98d 15h 59m 1

              People

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

                Dates

                Created:
                Updated:
                Resolved: