WORKTERRAProject Type: software

WORKTERRA

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

Analysis report contains the Code summary [distinct code and months wise]

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Module:
      ACA - 2017
    • Reported by:
      Support
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have

      Attachments

      1. 1095CAnalytics.doc
        23 kB
      2. ACA1095C_Sample.xls
        497 kB
      3. Jira-2617.xls
        19 kB

        Issue Links

        relates to

        Enhancement - An improvement or enhancement to an existing feature or task. WT-2607 Analysis report with review or invalid code check automated.

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

          Activity

          Ascending order - Click to sort in descending order
          Hide
          Permalink
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Nandkumar Prabhakar Karlekar
          Sachin Hingole
          Smita Pawar

          Please review the attached doc and let me know additional points that need to be considered.

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Nandkumar Prabhakar Karlekar Sachin Hingole Smita Pawar Please review the attached doc and let me know additional points that need to be considered.
          Hide
          Permalink
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Nandkumar Prabhakar Karlekar
          Sachin Hingole
          Smita Pawar

          Please verify the attached excel sheet [ACA1095C_Sample.xls]. ACA1095C_Sample.xls
          The analysis data is in 2nd sheet.
          Please review and let me know additional points that need to be considered.

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Nandkumar Prabhakar Karlekar Sachin Hingole Smita Pawar Please verify the attached excel sheet [ACA1095C_Sample.xls] . ACA1095C_Sample.xls The analysis data is in 2nd sheet. Please review and let me know additional points that need to be considered.
          Hide
          Permalink
          ramya.tantry Ramya Tantry (Inactive) added a comment - - edited

          Files Affected

          MasterCompanyDB/01_DDL/254_WT2617_WTB_ACA_NewTable_ACA_1095CCodesValidity.sql
          MasterCompanyDB/04_Stored Procedures/OES_SP_Get_1095CollectiveData.sql
          MasterCompanyDB/07_Data/073_WT2617_WTB_ACA_NewData_ACA_1095CCodesValidity.sql
          OnlineEnrollment/04_Stored Procedures/dbo.OES_SP_GetDetalisForReports.StoredProcedure.sql
          \RDL\ACA1095C.rdl
          \RDL\ACA1095CCodeAnalysis.rdl
          \RDL\ACA1095CCostAnalysis.rdl
          \RDL\ACA1095CEECount.rdl
          \RDL\ACA1095CLine22.rdl
          \RDL\ACA1095CMECIndicator.rdl

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - - edited Files Affected MasterCompanyDB/01_DDL/254_WT2617_WTB_ACA_NewTable_ACA_1095CCodesValidity.sql MasterCompanyDB/04_Stored Procedures/OES_SP_Get_1095CollectiveData.sql MasterCompanyDB/07_Data/073_WT2617_WTB_ACA_NewData_ACA_1095CCodesValidity.sql OnlineEnrollment/04_Stored Procedures/dbo.OES_SP_GetDetalisForReports.StoredProcedure.sql \RDL\ACA1095C.rdl \RDL\ACA1095CCodeAnalysis.rdl \RDL\ACA1095CCostAnalysis.rdl \RDL\ACA1095CEECount.rdl \RDL\ACA1095CLine22.rdl \RDL\ACA1095CMECIndicator.rdl
          Hide
          Permalink
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Sachin Hingole

          Please verify the enhancement.

          Analysis report need to be exported to excel. Two sheets will be seen in this excel.
          1st sheet contains code analysis and 2nd contains code summary.

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Sachin Hingole Please verify the enhancement. Analysis report need to be exported to excel. Two sheets will be seen in this excel. 1st sheet contains code analysis and 2nd contains code summary.
          Hide
          Permalink
          smita.pawar Smita Pawar (Inactive) added a comment -

          We have verified above mentioned change on LB. [ACA Automation ]

          Main Scenarios verified are as follows.

          1.New Hire employee count through back end.
          2.Checked percentage addition is not grater than 100.
          3.Checked Line 22 Certifications of Eligibility is showing correctly on 1095-C report

          Its working as expected.
          Note: We will regress valid and invalid code combinations while regressing 1095-C report.

          This enhancement is ready for Stage

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - We have verified above mentioned change on LB. [ACA Automation ] Main Scenarios verified are as follows. 1.New Hire employee count through back end. 2.Checked percentage addition is not grater than 100. 3.Checked Line 22 Certifications of Eligibility is showing correctly on 1095-C report Its working as expected. Note: We will regress valid and invalid code combinations while regressing 1095-C report. This enhancement is ready for Stage
          Hide
          Permalink
          smita.pawar Smita Pawar (Inactive) added a comment -

          Query executed for new hire
          select distinct EmployeeID from aca_1095cdatabackup where ReportRunID=195 and Line16Code='2D'

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - Query executed for new hire select distinct EmployeeID from aca_1095cdatabackup where ReportRunID=195 and Line16Code='2D'
          Hide
          Permalink
          smita.pawar Smita Pawar (Inactive) added a comment - - edited

          We have verified above mentioned change on Stage.[ACA Automation ]
          Main Scenarios verified are as follows.

          1.New Hire employee count..
          2.Checked percentage addition is not grater than 100.
          3.Checked Line 22 Certifications of Eligibility is showing correctly on 1095-C report
          Its working as expected.

          This enhancement is ready for Production.

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - - edited We have verified above mentioned change on Stage. [ACA Automation ] Main Scenarios verified are as follows. 1.New Hire employee count.. 2.Checked percentage addition is not grater than 100. 3.Checked Line 22 Certifications of Eligibility is showing correctly on 1095-C report Its working as expected. This enhancement is ready for Production.
          Hide
          Permalink
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          Verified on production, working fine.

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - Verified on production, working fine.
          Hide
          Permalink
          smita.pawar Smita Pawar (Inactive) added a comment -

          Attaching test cases for enhancement Jira-2617.xls

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - Attaching test cases for enhancement Jira-2617.xls

            People

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

              Dates

              Created:
              Updated:
              Resolved: