WORKTERRAProject Type: software

WORKTERRA

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

1095C : Add new tab in Analysis report for displaying covered individual part.

    Details

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

      Description

      Add new tab in Analysis report for displaying covered individual part of each employee in each run.
      Also add Date of hire and plan start month in Code analysis tab.

      Analysis :

      1. New Tab to be added in Analysis report for displaying covered individual.
      2. The report fields be as follows:
      EE Name,EE SSN,Member Type,Member SSN, DOB, Class1, Class2, Class3, Class4, Jan,Feb,March,Apr,May,Jun,Jul,Aug,Sept,Oct,Nov,Dec

      All dependents of that employee as shown on report will be listed with months marked.

      Also,New columns to be added in Tab 1 of analysis report are Hire date and plan start month and Employer Cost

        Attachments

          Issue Links

          relates to

          Change Request - Change Request WT-5300 ACA - change order of tabs from downloaded excel for analysis report

          • Low - Minor problem or easily worked around.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            ramya.tantry Ramya Tantry (Inactive) created issue -
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Field Original Value New Value
            Module Parent values: ACA(10104) Parent values: ACA(10104)Level 1 values: 2017(12000)
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Description Add new tab in Analysis report for displaying covered individual part of each employee in each run.
            Also add Date of hire and plan start month in Code analysis tab.             		Add new tab in Analysis report for displaying covered individual part of each employee in each run.
            Also add Date of hire and plan start month in Code analysis tab.

            Analysis :

            1. New Tab to be added in Analysis report for displaying covered individual.
            2. The report fields be as follows:
            EE Name,EE SSN,Member Type,Member SSN, DOB, Class1, Class2, Class3, Class4, Jan,Feb,March,Apr,May,Jun,Jul,Aug,Sept,Oct,Nov,Dec

            All dependents of that employee as shown on report will be listed with months marked.

            Also,New columns to be added in Tab 1 of analysis report are Hire date and plan start month.
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Description Add new tab in Analysis report for displaying covered individual part of each employee in each run.
            Also add Date of hire and plan start month in Code analysis tab.

            Analysis :

            1. New Tab to be added in Analysis report for displaying covered individual.
            2. The report fields be as follows:
            EE Name,EE SSN,Member Type,Member SSN, DOB, Class1, Class2, Class3, Class4, Jan,Feb,March,Apr,May,Jun,Jul,Aug,Sept,Oct,Nov,Dec

            All dependents of that employee as shown on report will be listed with months marked.

            Also,New columns to be added in Tab 1 of analysis report are Hire date and plan start month.
            		 Add new tab in Analysis report for displaying covered individual part of each employee in each run.
            Also add Date of hire and plan start month in Code analysis tab.

            Analysis :

            1. New Tab to be added in Analysis report for displaying covered individual.
            2. The report fields be as follows:
            EE Name,EE SSN,Member Type,Member SSN, DOB, Class1, Class2, Class3, Class4, Jan,Feb,March,Apr,May,Jun,Jul,Aug,Sept,Oct,Nov,Dec

            All dependents of that employee as shown on report will be listed with months marked.

            Also,New columns to be added in Tab 1 of analysis report are Hire date and plan start month and Employer Cost
            ramya.tantry Ramya Tantry (Inactive) made changes -
            Assignee Ramya Tantry [ ramya.tantry ] Abhijeet Khandagale [ abhijeet.khandagale ]
            Hide
            Permalink
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

            Consider only the self insured plan coverage to export in this excel report

            Show
            nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Consider only the self insured plan coverage to export in this excel report
            Hide
            Permalink
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Abhijeet Khandagale

            New changes in this report:

            1. Report fields will be :
            EE Name,EE SSN,Member Type,Member SSN, DOB, Class1, Class2, Class3, Class4, Coverage Month,Is Corrected record.

            2. Show only covered month of the Employee and dependents.

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Abhijeet Khandagale New changes in this report: 1. Report fields will be : EE Name,EE SSN,Member Type,Member SSN, DOB, Class1, Class2, Class3, Class4, Coverage Month,Is Corrected record. 2. Show only covered month of the Employee and dependents.
            abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
            Status New Request [ 10029 ] Pending for Approval [ 10002 ]
            abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
            Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
            abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
            Status Approved for Development [ 10003 ] In Development [ 10007 ]
            Hide
            Permalink
            abhijeet.khandagale Abhijeet Khandagale (Inactive) added a comment -

            Hi Sachin Hingole,

            Please provide test cases for this JIRA.

            CC: Yogesh Chaudhari Nandkumar Prabhakar Karlekar

            Show
            abhijeet.khandagale Abhijeet Khandagale (Inactive) added a comment - Hi Sachin Hingole , Please provide test cases for this JIRA. CC: Yogesh Chaudhari Nandkumar Prabhakar Karlekar
            Hide
            Permalink
            abhijeet.khandagale Abhijeet Khandagale (Inactive) added a comment -

            Sachin Hingole

            • We have also included functionality of saving "ApplyUserCorrection" flag against each run in ACA_1095CReportRun table.
            • For existing records from ACA_1095CReportRun, we are keeping "ApplyUserCorrection" as FALSE.

            CC: Nandkumar Prabhakar Karlekar Yogesh Chaudhari Ramya Tantry

            Show
            abhijeet.khandagale Abhijeet Khandagale (Inactive) added a comment - Sachin Hingole We have also included functionality of saving "ApplyUserCorrection" flag against each run in ACA_1095CReportRun table. For existing records from ACA_1095CReportRun, we are keeping "ApplyUserCorrection" as FALSE. CC: Nandkumar Prabhakar Karlekar Yogesh Chaudhari Ramya Tantry
            abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206)
            Hide
            Permalink
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Hi Abhijeet Khandagale,

            Currently we are busy on ADP files (Multi- Employer and Non Employee), and TC writing for WT-4579.
            Once we are done with these tasks and no other support task comes in QA we will schedule TC writing for this enhancement.

            Thanks,
            Sachin Hingole

            Yogesh Chaudhari Nandkumar Prabhakar Karlekar Rakesh Roy Smita Pawar Mahendra Mungase

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Hi Abhijeet Khandagale , Currently we are busy on ADP files (Multi- Employer and Non Employee), and TC writing for WT-4579 . Once we are done with these tasks and no other support task comes in QA we will schedule TC writing for this enhancement. Thanks, Sachin Hingole Yogesh Chaudhari Nandkumar Prabhakar Karlekar Rakesh Roy Smita Pawar Mahendra Mungase
            abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Review(10208)
            Hide
            Permalink
            ramya.tantry Ramya Tantry (Inactive) added a comment -

            Abhijeet Khandagale
            Please ensure below mentioned point is also done
            Also,New columns to be added in Tab 1 of analysis report are Hire date and plan start month and Employer Cost

            Show
            ramya.tantry Ramya Tantry (Inactive) added a comment - Abhijeet Khandagale Please ensure below mentioned point is also done Also,New columns to be added in Tab 1 of analysis report are Hire date and plan start month and Employer Cost
            abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
            Code Reviewed By Ramya Tantry [ 13001 ]
            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            abhijeet.khandagale Abhijeet Khandagale (Inactive) made changes -
            Assignee Abhijeet Khandagale [ abhijeet.khandagale ] Sachin Hingole [ sachin.hingole ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Sachin Hingole [ sachin.hingole ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Link This issue relates to WT-5300 [ WT-5300 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Attachment WT-3762 CoveredIndividuals-TestCases.xls [ 29210 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Production Due Date 25/Oct/2016
            Stage Due Date 17/Oct/16 [ 2016-10-17 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
            Hide
            Permalink
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Verified on LB, Working fine.
            Executed all TCs attached with this JIRA.

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Verified on LB, Working fine. Executed all TCs attached with this JIRA.
            rakeshr Rakesh Roy (Inactive) made changes -
            Developer Abhijeet Khandagale [ abhijeet.khandagale ]
            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 -
            Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
            sachin.hingole Sachin Hingole (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 ]
            sachin.hingole Sachin Hingole (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)
            Hide
            Permalink
            sachin.hingole Sachin Hingole (Inactive) added a comment -

            Verified on Stage, Working fine.

            Show
            sachin.hingole Sachin Hingole (Inactive) added a comment - Verified on Stage, Working fine.
            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)
            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 -
            Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
            sachin.hingole Sachin Hingole (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: 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 ]
            Transition Time In Source Status Execution Times
            Abhijeet Khandagale (Inactive) made transition -
            New Request Pending for Approval
            		64d 1h 36m 1
            Abhijeet Khandagale (Inactive) made transition -
            Pending for Approval Approved for Development
            		3s 1
            Abhijeet Khandagale (Inactive) made transition -
            Approved for Development In Development
            		5s 1
            Sachin Hingole (Inactive) made transition -
            In Development In LB Testing
            		4d 23h 47m 1
            Sachin Hingole (Inactive) made transition -
            In LB Testing Pending for Stage Approval
            		12d 4h 56m 1
            Sachin Hingole (Inactive) made transition -
            Pending for Stage Approval Approved for Stage
            		4s 1
            Sachin Hingole (Inactive) made transition -
            Approved for Stage Stage Testing
            		6s 1
            Sachin Hingole (Inactive) made transition -
            Stage Testing Pending for Production Approval
            		28d 20h 41m 1
            Sachin Hingole (Inactive) made transition -
            Pending for Production Approval Approved for production
            		2s 1
            Sachin Hingole (Inactive) made transition -
            Approved for production In Production Testing
            		2s 1
            Sachin Hingole (Inactive) made transition -
            In Production Testing Production Complete
            		53m 45s 1
            Sachin Hingole (Inactive) made transition -
            Production Complete Closed
            		3s 1

              People

              Assignee:
              sachin.hingole Sachin Hingole (Inactive)
              Reporter:
              ramya.tantry Ramya Tantry (Inactive)
              Developer:
              Abhijeet Khandagale (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Pre-Prod Due Date:
                Production Due Date: