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

ACA 2017 Provision to overwrite the values on 1094C of Part III Column(a),Column(b) and Column(c).

    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:
      Must Have
    • Feature Category:
      Integration
    • Severity:
      Medium

      Description

      Provision to overwrite the values on 1094C of Part III Column(a),Column(b) and Column(c) as we had many such request which we furnished this from back-end.

        Attachments

        1. 1094-C PDF corrected.png
          1094-C PDF corrected.png
          109 kB
        2. Customization.png
          Customization.png
          124 kB
        3. FilesAffected.txt
          6 kB
        4. WT-9196_Functionality_Updated - 7-26-2017.doc
          17 kB
        5. WT-9196_Functionality.doc
          17 kB
        6. WT-9196TestCases.xls
          19 kB

          Issue Links

            Activity

            kumar.chhajed Kumar Chhajed (Inactive) logged work - 14/Apr/17 01:28 PM
            • Time Spent:
              1h
               

              Internal discussion with Umesh

            kumar.chhajed Kumar Chhajed (Inactive) logged work - 17/Apr/17 01:15 PM
            • Time Spent:
              1h
               

              discussion with Umesh

            umesh.kolhe Umesh Kolhe (Inactive) logged work - 17/Apr/17 01:21 PM
            • Time Spent:
              7h
               

              Column Added and insert data into ACA_InEligibleEmployeeCount table
              modify and Resource file string values

            kumar.chhajed Kumar Chhajed (Inactive) logged work - 18/Apr/17 01:31 PM
            • Time Spent:
              0.5h
               

              Discussion with Umesh

            umesh.kolhe Umesh Kolhe (Inactive) logged work - 18/Apr/17 02:06 PM
            • Time Spent:
              7h
               

              Column Added into ACA_InEligibleEmployeeCount for selecting Yes or no option
              Override values for Full Time Employee count and Total Employee count
              Added String Values into resource file
              Research on how to Partition of column into two column

            kumar.chhajed Kumar Chhajed (Inactive) logged work - 19/Apr/17 01:19 PM
            • Time Spent:
              1h
               

              Internal discussion with Umesh

            umesh.kolhe Umesh Kolhe (Inactive) logged work - 19/Apr/17 01:41 PM
            • Time Spent:
              8h
               

              -Remove Minimum Essential Coverage Offer Indicator column from UI
              -Set initials zero to Section 4980H Full-Time Employee Count for ALE Member and Total Employee Count for ALE Member column

              • Override 4980H Full-Time Employee Count for ALE Member on pdf report
              • Research on Validation on Yes No checkbox
              • Add MinEssentialCoverageOfferIndicator column into ACA_1094CCertificationsOfEligibility table
              • Insert data into ACA_1094CCertificationsOfEligibility table
              • Add Minimum Essential Coverage Offer Indicator dropdown
              • check Minimum Essential Coverage Offer Indicator is Yes then print override data into pdf
                else print default data
            umesh.kolhe Umesh Kolhe (Inactive) logged work - 20/Apr/17 01:10 PM
            • Time Spent:
              8h
               
              • Check Yes or No checkbox validation - only on checkbox checked at a time or disable both
                by default
              • validation on Section 4980H Full-Time Employee Count for ALE Member and Total Employee
                Count for ALE Member; Only accept -1 and other positive integer values.
              • Auto populate -1 value on VIew and store the value into database
              • Handle -1 condition on pdf report generation into store procedure
            umesh.kolhe Umesh Kolhe (Inactive) logged work - 21/Apr/17 12:56 PM
            • Time Spent:
              8h
               
              • Change store procedure as per enhancement like if Section 4980H Full-Time Employee
                Count for ALE Member and Total Employee Count for ALE Member is zero then on pdf
                report print zero
              • Set Css for the Grid
              • Make column name is same as pdf report
              • Added new dropdown (Tax Year) on view
              • Added column into ACA_InEligibleEmployeeCount and ACA_1094CCertificationsOfEligibility
                table for storing Tax Year values
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 21/Apr/17 01:16 PM - edited
            • Time Spent:
              1.5h
               

              Discussion with umesh and nandu

            umesh.kolhe Umesh Kolhe (Inactive) logged work - 24/Apr/17 01:48 PM
            • Time Spent:
              8h
               
              • Added TaxYear drop down selected Year into database
              • change on store procedure for display selected from and To year date recored
              • Insert and delete must be on selected tax year criteria
            umesh.kolhe Umesh Kolhe (Inactive) logged work - 25/Apr/17 01:05 PM
            • Time Spent:
              8h
               

              -Change Store procedure for Part4 print pdf report, Tax Year wise report generate

              • validation on Event for change in Tax year dropdown
              • Change business logic for display and insert Selected Tax Year
              • Add Tax Year column into 1904CALEMemberData table
              • Unit Test
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 25/Apr/17 01:26 PM
            • Time Spent:
              0.5h
               

              Discussion with Umesh

            umesh.kolhe Umesh Kolhe (Inactive) logged work - 26/Apr/17 01:02 PM
            • Time Spent:
              8h
               
              • Send Review To Kumar
              • Change code as per review comment
              • Create script for Data and store procedure
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 26/Apr/17 01:57 PM
            • Time Spent:
              1.5h
               

              Code review

            umesh.kolhe Umesh Kolhe (Inactive) logged work - 27/Apr/17 01:14 PM
            • Time Spent:
              6h
               
              • Solve the issue of tax Year
              • Solve the issue of MEC offer indicator by default taken as No value.
              • Compare store procedure [OES_SP_Get_ACAIRS1094CData]
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 28/Apr/17 07:18 AM
            • Time Spent:
              1h
               

              Code Review

            umesh.kolhe Umesh Kolhe (Inactive) logged work - 28/Apr/17 01:00 PM
            • Time Spent:
              8h
               
              • Code analysis
              • Analysis on Store procedure for printing vslues on PDF
              • Discussion with Kumar
            umesh.kolhe Umesh Kolhe (Inactive) logged work - 02/May/17 01:13 PM
            • Time Spent:
              8h
               
              • Note Added over the MEC offer Indicator dropdown
              • Added string into resource file
              • Change into Store procedure (OES_SP_Get_ACAIRS1094CData & OES_SP_ACA_InsertUpdateACA1094CALEMembersData)
              • Merge Store procedure
              • Unit Test
              • Code review sent to Kumar
            umesh.kolhe Umesh Kolhe (Inactive) logged work - 01/Jun/17 01:34 PM
            • Time Spent:
              2h
               
              <No comment>
            umesh.kolhe Umesh Kolhe (Inactive) logged work - 02/Jun/17 11:41 AM - edited
            • Time Spent:
              4h
               
              • Merge code
              • fix bug
            umesh.kolhe Umesh Kolhe (Inactive) logged work - 12/Jun/17 01:13 PM
            • Time Spent:
              4h
               
              • Make changes in Ui Refresh
            umesh.kolhe Umesh Kolhe (Inactive) logged work - 13/Jun/17 01:06 PM
            • Time Spent:
              1h
               
              <No comment>
            umesh.kolhe Umesh Kolhe (Inactive) logged work - 22/Jun/17 12:55 PM
            • Time Spent:
              1h
               
              • Discussion with kumar
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 22/Jun/17 01:09 PM
            • Time Spent:
              0.5h
               

              Discussion with Umesh

            nandkumar Nandkumar Prabhakar Karlekar (Inactive) logged work - 23/Jun/17 12:24 PM
            • Time Spent:
              2h
               
              <No comment>
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 23/Jun/17 12:25 PM
            • Time Spent:
              2h
               

              Meeting with team
              Internal discussion with Umesh

            ramya.tantry Ramya Tantry (Inactive) logged work - 23/Jun/17 12:55 PM
            • Time Spent:
              0.5h
               

              Discussion with ACA Team

            umesh.kolhe Umesh Kolhe (Inactive) logged work - 23/Jun/17 01:09 PM
            • Time Spent:
              8h
               
              • Change the name of ACA 1094C Parameters to ACA 1094C Corrections
              • Change the name of existing tables as follows-
                ACA_1094CCertificationsOfEligibility rename to ACA_1094CPartIICorrectionData
                ACA_InEligibleEmployeeCount rename to ACA_1094CPartIIICorrectionData
                ACA_1094CALEMembersData rename to ACA_1094CPartIVCorrectionData
              • Overwrite all the values provided.
              • Remove drop down of MEC Indicator
              • Add Apply User Correction Drop down for 1094C Report
                -Create new tables to dump 1094C Data -
                ACA_1094CPartIIData
                ACA_1094CPartIIIData
                ACA_1094CPartIVData
            umesh.kolhe Umesh Kolhe (Inactive) logged work - 27/Jun/17 01:19 PM
            • Time Spent:
              8h
               
              • Change in store procedure (OES_SP_Get_ACAIRS1094CData)
                Dump System populated data in to data tables
              • Add the column into ACA_1094CReportRun for storing IsUsercorrection
              • Debugging the Functionality for 1094C Report
            umesh.kolhe Umesh Kolhe (Inactive) logged work - 28/Jun/17 02:16 PM
            • Time Spent:
              8h
               
              • Change Sp: OES_ACA_SP_Save_1094CReportRun
              • Create Sp : OES_ACA_SP_Get_1094CReportRun
              • Code Analysis
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 28/Jun/17 02:17 PM
            • Time Spent:
              2h
               

              Discussion with Umesh

            umesh.kolhe Umesh Kolhe (Inactive) logged work - 29/Jun/17 01:31 PM
            • Time Spent:
              8h
               
              • Understand Functionality
              • Make changes into stored Procedure
              • Added AggregatedGroupIndicator into StaticReportControls
              • Code Analysis
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 29/Jun/17 03:21 PM
            • Time Spent:
              1.5h
               

              Discussion with Umesh

            umesh.kolhe Umesh Kolhe (Inactive) logged work - 30/Jun/17 01:09 PM
            • Time Spent:
              8h
               
              • Add Listbox for All month for Selecting Group indicator
              • change Store procedure (OES_SP_Report_InsertUpdateStaticReport)
              • Added column into ReportDetailsStatic for storing Selected Group indicator
              • Code Analysis
            umesh.kolhe Umesh Kolhe (Inactive) logged work - 05/Jul/17 12:57 PM
            • Time Spent:
              1h
               
              <No comment>
            kumar.chhajed Kumar Chhajed (Inactive) logged work - 11/Jul/17 01:13 PM
            • Time Spent:
              3h
               

              Documentation

            kumar.chhajed Kumar Chhajed (Inactive) logged work - 12/Jul/17 01:10 PM
            • Time Spent:
              1.5h
               

              Coding

            kumar.chhajed Kumar Chhajed (Inactive) logged work - 19/Jul/17 01:02 PM
            • Time Spent:
              5.5h
               

              Coding
              Unit testing
              Internal discussion

            kumar.chhajed Kumar Chhajed (Inactive) logged work - 20/Jul/17 01:09 PM
            • Time Spent:
              7h
               

              Coding
              Unit testing
              Internal discussion

            kumar.chhajed Kumar Chhajed (Inactive) logged work - 24/Jul/17 01:56 PM
            • Time Spent:
              8h
               

              Coding
              Unit testing
              Internal discussion

            kumar.chhajed Kumar Chhajed (Inactive) logged work - 25/Jul/17 02:26 PM
            • Time Spent:
              8h
               

              Coding
              Unit testng
              Internal discussion

            kumar.chhajed Kumar Chhajed (Inactive) logged work - 26/Jul/17 02:08 PM
            • Time Spent:
              6h
               

              Coding
              Unit testing
              Internal discussion

            kumar.chhajed Kumar Chhajed (Inactive) logged work - 27/Jul/17 12:56 PM
            • Time Spent:
              8h
               

              Coding
              Unit testing
              Internal discussion

            kumar.chhajed Kumar Chhajed (Inactive) logged work - 28/Jul/17 01:29 PM
            • Time Spent:
              6h
               

              Coding
              Unit testing
              Internal discussion

            ramya.tantry Ramya Tantry (Inactive) logged work - 31/Jul/17 12:04 PM
            • Time Spent:
              0.5h
               

              Discussion with Kumar on 1094C correction functionality

            kumar.chhajed Kumar Chhajed (Inactive) logged work - 31/Jul/17 12:12 PM
            • Time Spent:
              7h
               

              Coding
              UNit testing
              Internal discussion with Ramya
              Code Review Request

            kumar.chhajed Kumar Chhajed (Inactive) logged work - 01/Aug/17 01:37 PM
            • Time Spent:
              6h
               

              Coding
              Unit testing
              Internal discussion
              Code Review
              Code Review Changes

            ramya.tantry Ramya Tantry (Inactive) logged work - 01/Aug/17 03:39 PM
            • Time Spent:
              1.5h
               

              Discussion with Kumar and Nandu and Code review

            kumar.chhajed Kumar Chhajed (Inactive) logged work - 02/Aug/17 01:30 PM
            • Time Spent:
              4h
               

              Code commit to UI Refresh branch
              Discussion with Build engineer

            kumar.chhajed Kumar Chhajed (Inactive) logged work - 16/Aug/17 01:14 PM
            • Time Spent:
              6.5h
               

              Coding
              Unit testing
              Internal discussion

            kumar.chhajed Kumar Chhajed (Inactive) logged work - 17/Aug/17 01:32 PM
            • Time Spent:
              4h
               

              Coding
              Unit testing

            kumar.chhajed Kumar Chhajed (Inactive) logged work - 18/Aug/17 01:58 PM
            • Time Spent:
              2h
               

              Code Check-ins

            kumar.chhajed Kumar Chhajed (Inactive) logged work - 21/Aug/17 12:51 PM
            • Time Spent:
              2h
               

              Code Checkins to LB

            smita.pawar Smita Pawar (Inactive) logged work - 15/Sep/17 08:43 AM
            • Time Spent:
              1h
               

              Initial analysis & internal discussion

            sachin.hingole Sachin Hingole (Inactive) logged work - 18/Sep/17 09:58 AM
            • Time Spent:
              0.5h
               

              Verification of 1094C and internal discussion about ALE group flag.

            smita.pawar Smita Pawar (Inactive) logged work - 18/Sep/17 12:58 PM
            • Time Spent:
              4h
               

              Analysis
              Internal discussion
              Test cases

            smita.pawar Smita Pawar (Inactive) logged work - 28/Sep/17 01:46 PM
            • Time Spent:
              0.25h
               

              Internal discussion

            smita.pawar Smita Pawar (Inactive) logged work - 03/Oct/17 01:51 PM
            • Time Spent:
              1.25h
               

              Updating test cases

            smita.pawar Smita Pawar (Inactive) logged work - 09/Oct/17 12:36 PM - edited
            • Time Spent:
              4.5h
               

              LB testing

            smita.pawar Smita Pawar (Inactive) logged work - 10/Oct/17 10:07 AM
            • Time Spent:
              2.5h
               

              LB testing

            smita.pawar Smita Pawar (Inactive) logged work - 11/Oct/17 09:07 AM - edited
            • Time Spent:
              3h
               

              Azure testing

            kumar.chhajed Kumar Chhajed (Inactive) logged work - 12/Oct/17 12:57 PM
            • Time Spent:
              2.5h
               

              Check-ins to Stage
              Internal Discussion with Build Engineer

            smita.pawar Smita Pawar (Inactive) logged work - 13/Oct/17 10:32 AM
            • Time Spent:
              1.5h
               

              Stage testing

            rutuja.chilwar Rutuja Chilwar (Inactive) logged work - 17/Oct/17 12:50 PM
            • Time Spent:
              2h
               
              <No comment>
            rutuja.chilwar Rutuja Chilwar (Inactive) logged work - 10/Nov/17 12:24 PM
            • Time Spent:
              2h
               
              <No comment>
            mahendra.mungase Mahendra Mungase (Inactive) logged work - 26/Nov/17 04:05 AM
            • Time Spent:
              0.5h
               

              Enhancement verification on Production

            smita.pawar Smita Pawar (Inactive) logged work - 29/Nov/17 10:10 AM
            • Time Spent:
              0.75h
               

              Production testing

              People

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

                Dates

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

                  Time Tracking

                  Estimated:
                  Original Estimate - 24h Original Estimate - 24h
                  24h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 266.25h
                  266.25h