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
            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
            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
            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.
            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
            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
            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.
            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.

              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: