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
          kumar.chhajed Kumar Chhajed (Inactive) created issue -
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Field Original Value New Value
          Dev Estimates 24
          Item State Parent values: Development(10200)Level 1 values: Development Backlog(10205)
          yogesh.chaudhari Yogesh Chaudhari (Inactive) made changes -
          Status New Request [ 10029 ] Product Backlog [ 10100 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Attachment 1095CAnalytics.doc [ 19642 ]
          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.
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Attachment ACA1095C_Sample.xls [ 21461 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Attachment ACA1095C_Sample.xls [ 21461 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Attachment ACA1095C_Sample.xls [ 21463 ]
          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.
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Link This issue relates to WT-2607 [ WT-2607 ]
          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.
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Ramya Tantry [ ramya.tantry ] Sachin Hingole [ sachin.hingole ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Development Backlog(10205) Parent values: LB QA(10201)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Product Backlog [ 10100 ] Pending for Approval [ 10002 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Approved for Development [ 10003 ] In Development [ 10007 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          gokul.sonawane Gokul Sonawane (Inactive) made changes -
          Item State Parent values: LB QA(10201) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Assignee Sachin Hingole [ sachin.hingole ] Smita Pawar [ smita.pawar ]
          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 -

          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
          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)
          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'
          rakeshr Rakesh Roy (Inactive) made changes -
          Developer Ramya Tantry [ ramya.tantry ]
          QA Smita Pawar [ smita.pawar ]
          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)
          smita.pawar Smita Pawar (Inactive) made changes -
          Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
          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 - - 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.
          ashwin.wankhede Ashwin Wankhede (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
          smita.pawar Smita Pawar (Inactive) made changes -
          Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Status Approved for production [ 10034 ] Production Testing [ 10202 ]
          sachin.hingole Sachin Hingole (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)
          sachin.hingole Sachin Hingole (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
          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.
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Production Complete [ 10028 ] Closed [ 6 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Attachment Jira-2617.xls [ 33453 ]
          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
          Transition Time In Source Status Execution Times
          Yogesh Chaudhari (Inactive) made transition -
          New Request Product Backlog
          		1d 23h 29m 1
          Sachin Hingole (Inactive) made transition -
          Product Backlog Pending for Approval
          		64d 21h 9m 1
          Sachin Hingole (Inactive) made transition -
          Pending for Approval Approved for Development
          		6s 1
          Sachin Hingole (Inactive) made transition -
          Approved for Development In Development
          		3s 1
          Sachin Hingole (Inactive) made transition -
          In Development In LB Testing
          		3s 1
          Smita Pawar (Inactive) made transition -
          In LB Testing Pending for Stage Approval
          		105d 35m 1
          Smita Pawar (Inactive) made transition -
          Pending for Stage Approval Approved for Stage
          		2s 1
          Sachin Hingole (Inactive) made transition -
          Approved for Stage Stage Testing
          		5h 1
          Smita Pawar (Inactive) made transition -
          Stage Testing Pending for Production Approval
          		2d 1h 1
          Smita Pawar (Inactive) made transition -
          Pending for Production Approval Approved for production
          		3s 1
          Smita Pawar (Inactive) made transition -
          Approved for production In Production Testing
          		3s 1
          Sachin Hingole (Inactive) made transition -
          In Production Testing Production Complete
          		9d 2h 32m 1
          Sachin Hingole (Inactive) made transition -
          Production Complete Closed
          		3s 1

            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: