-
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
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.
- relates to
-
WT-10924 ACA 2018 : Changes to 1094C PDF
-
- Closed
-
-
- Time Spent:
- 1h
-
Internal discussion with Umesh
Field | Original Value | New Value |
---|---|---|
Remaining Estimate | 24h [ 86400 ] | 23h [ 82800 ] |
Time Spent | 1h [ 3600 ] | |
Worklog Id | 38405 [ 38405 ] |
Remaining Estimate | 23h [ 82800 ] | 22h [ 79200 ] |
Time Spent | 1h [ 3600 ] | 2h [ 7200 ] |
Worklog Id | 38763 [ 38763 ] |
-
- Time Spent:
- 7h
-
Column Added and insert data into ACA_InEligibleEmployeeCount table
modify and Resource file string values
Remaining Estimate | 22h [ 79200 ] | 15h [ 54000 ] |
Time Spent | 2h [ 7200 ] | 9h [ 32400 ] |
Worklog Id | 38775 [ 38775 ] |
Remaining Estimate | 15h [ 54000 ] | 14.5h [ 52200 ] |
Time Spent | 9h [ 32400 ] | 9.5h [ 34200 ] |
Worklog Id | 39059 [ 39059 ] |
-
- 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
Remaining Estimate | 14.5h [ 52200 ] | 7.5h [ 27000 ] |
Time Spent | 9.5h [ 34200 ] | 16.5h [ 59400 ] |
Worklog Id | 39083 [ 39083 ] |
-
- Time Spent:
- 1h
-
Internal discussion with Umesh
Remaining Estimate | 7.5h [ 27000 ] | 6.5h [ 23400 ] |
Time Spent | 16.5h [ 59400 ] | 17.5h [ 63000 ] |
Worklog Id | 39400 [ 39400 ] |
-
- 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
Remaining Estimate | 6.5h [ 23400 ] | 0h [ 0 ] |
Time Spent | 17.5h [ 63000 ] | 25.5h [ 91800 ] |
Worklog Id | 39426 [ 39426 ] |
-
- 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
- Check Yes or No checkbox validation - only on checkbox checked at a time or disable both
Time Spent | 25.5h [ 91800 ] | 33.5h [ 120600 ] |
Worklog Id | 39689 [ 39689 ] |
-
- 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
- Change store procedure as per enhancement like if Section 4980H Full-Time Employee
Time Spent | 33.5h [ 120600 ] | 41.5h [ 149400 ] |
Worklog Id | 40054 [ 40054 ] |
-
- Time Spent:
- 1.5h
-
Discussion with umesh and nandu
Time Spent | 41.5h [ 149400 ] | 42.5h [ 153000 ] |
Worklog Id | 40071 [ 40071 ] |
Time Spent | 42.5h [ 153000 ] | 43h [ 154800 ] |
Worklog Id | 40071 [ 40071 ] |
-
- 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
Time Spent | 43h [ 154800 ] | 51h [ 183600 ] |
Worklog Id | 40439 [ 40439 ] |
-
- 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
Time Spent | 51h [ 183600 ] | 51.5h [ 185400 ] |
Worklog Id | 40673 [ 40673 ] |
-
- Time Spent:
- 8h
-
- Send Review To Kumar
- Change code as per review comment
- Create script for Data and store procedure
Time Spent | 51.5h [ 185400 ] | 59.5h [ 214200 ] |
Worklog Id | 41014 [ 41014 ] |
Time Spent | 59.5h [ 214200 ] | 61h [ 219600 ] |
Worklog Id | 41034 [ 41034 ] |
-
- 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]
Time Spent | 61h [ 219600 ] | 67h [ 241200 ] |
Worklog Id | 41437 [ 41437 ] |
Time Spent | 67h [ 241200 ] | 68h [ 244800 ] |
Worklog Id | 41849 [ 41849 ] |
-
- Time Spent:
- 8h
-
- Code analysis
- Analysis on Store procedure for printing vslues on PDF
- Discussion with Kumar
Time Spent | 68h [ 244800 ] | 76h [ 273600 ] |
Worklog Id | 42405 [ 42405 ] |
Time Spent | 76h [ 273600 ] | 84h [ 302400 ] |
Worklog Id | 42412 [ 42412 ] |
-
- 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
Time Spent | 84h [ 302400 ] | 92h [ 331200 ] |
Worklog Id | 42723 [ 42723 ] |
Status | New Request [ 10029 ] | Pending for Approval [ 10002 ] |
Status | Pending for Approval [ 10002 ] | Approved for Development [ 10003 ] |
Status | Approved for Development [ 10003 ] | In Development [ 10007 ] |
Item State | Parent values: Development(10200) | Parent values: Development(10200)Level 1 values: In Progress(10206) |
Time Spent | 92h [ 331200 ] | 94h [ 338400 ] |
Worklog Id | 51748 [ 51748 ] |
Time Spent | 94h [ 338400 ] | 97h [ 349200 ] |
Worklog Id | 51874 [ 51874 ] |
Time Spent | 97h [ 349200 ] | 101h [ 363600 ] |
Worklog Id | 54160 [ 54160 ] |
Time Spent | 101h [ 363600 ] | 102h [ 367200 ] |
Worklog Id | 54645 [ 54645 ] |
Time Spent | 102h [ 367200 ] | 103h [ 370800 ] |
Worklog Id | 57512 [ 57512 ] |
Time Spent | 103h [ 370800 ] | 103.5h [ 372600 ] |
Worklog Id | 57536 [ 57536 ] |
-
- Time Spent:
- 2h
- <No comment>
Time Spent | 103.5h [ 372600 ] | 105.5h [ 379800 ] |
Worklog Id | 57928 [ 57928 ] |
-
- Time Spent:
- 2h
-
Meeting with team
Internal discussion with Umesh
Time Spent | 105.5h [ 379800 ] | 107.5h [ 387000 ] |
Worklog Id | 57933 [ 57933 ] |
Time Spent | 107.5h [ 387000 ] | 108h [ 388800 ] |
Worklog Id | 57974 [ 57974 ] |
-
- 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
Time Spent | 108h [ 388800 ] | 116h [ 417600 ] |
Worklog Id | 57996 [ 57996 ] |
-
- 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
- Change in store procedure (OES_SP_Get_ACAIRS1094CData)
Time Spent | 116h [ 417600 ] | 124h [ 446400 ] |
Worklog Id | 58326 [ 58326 ] |
-
- Time Spent:
- 8h
-
- Change Sp: OES_ACA_SP_Save_1094CReportRun
- Create Sp : OES_ACA_SP_Get_1094CReportRun
- Code Analysis
Time Spent | 124h [ 446400 ] | 126h [ 453600 ] |
Worklog Id | 58904 [ 58904 ] |
Time Spent | 126h [ 453600 ] | 134h [ 482400 ] |
Worklog Id | 58905 [ 58905 ] |
-
- Time Spent:
- 8h
-
- Understand Functionality
- Make changes into stored Procedure
- Added AggregatedGroupIndicator into StaticReportControls
- Code Analysis
Time Spent | 134h [ 482400 ] | 142h [ 511200 ] |
Worklog Id | 59484 [ 59484 ] |
Time Spent | 142h [ 511200 ] | 143.5h [ 516600 ] |
Worklog Id | 59549 [ 59549 ] |
Time Spent | 143.5h [ 516600 ] | 144.5h [ 520200 ] |
Worklog Id | 51874 [ 51874 ] |
-
- 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
Time Spent | 144.5h [ 520200 ] | 152.5h [ 549000 ] |
Worklog Id | 60408 [ 60408 ] |
Time Spent | 152.5h [ 549000 ] | 153.5h [ 552600 ] |
Worklog Id | 60906 [ 60906 ] |
Attachment | WT-9196.doc [ 54917 ] |
Attachment |
|
Attachment | WT-9196_Functionality.doc [ 54918 ] |
Assignee | Umesh Kolhe [ umesh.kolhe ] | Nandkumar [ satyap ] |
Time Spent | 153.5h [ 552600 ] | 156.5h [ 563400 ] |
Worklog Id | 62436 [ 62436 ] |
Time Spent | 156.5h [ 563400 ] | 158h [ 568800 ] |
Worklog Id | 62715 [ 62715 ] |
Assignee | Nandkumar [ satyap ] | Kumar Chhajed [ kumar.chhajed ] |
-
- Time Spent:
- 5.5h
-
Coding
Unit testing
Internal discussion
Time Spent | 158h [ 568800 ] | 163.5h [ 588600 ] |
Worklog Id | 64730 [ 64730 ] |
Time Spent | 163.5h [ 588600 ] | 170.5h [ 613800 ] |
Worklog Id | 64992 [ 64992 ] |
-
- Time Spent:
- 7h
-
Coding
Unit testing
Internal discussion
-
- Time Spent:
- 8h
-
Coding
Unit testing
Internal discussion
Time Spent | 170.5h [ 613800 ] | 178.5h [ 642600 ] |
Worklog Id | 65811 [ 65811 ] |
-
- Time Spent:
- 8h
-
Coding
Unit testng
Internal discussion
Time Spent | 178.5h [ 642600 ] | 186.5h [ 671400 ] |
Worklog Id | 66298 [ 66298 ] |
Attachment | WT-9196_Functionality_Updated - 7-26-2017.doc [ 56751 ] |
-
- Time Spent:
- 6h
-
Coding
Unit testing
Internal discussion
Time Spent | 186.5h [ 671400 ] | 192.5h [ 693000 ] |
Worklog Id | 66636 [ 66636 ] |
-
- Time Spent:
- 8h
-
Coding
Unit testing
Internal discussion
Time Spent | 192.5h [ 693000 ] | 200.5h [ 721800 ] |
Worklog Id | 67322 [ 67322 ] |
-
- Time Spent:
- 6h
-
Coding
Unit testing
Internal discussion
Time Spent | 200.5h [ 721800 ] | 206.5h [ 743400 ] |
Worklog Id | 67768 [ 67768 ] |
-
- Time Spent:
- 0.5h
-
Discussion with Kumar on 1094C correction functionality
Developer | Umesh Kolhe [ umesh.kolhe ] | Kumar Chhajed [ kumar.chhajed ] |
Code Reviewed By | Ramya Tantry [ 13001 ] |
Item State | Parent values: Development(10200)Level 1 values: In Progress(10206) | Parent values: Development(10200)Level 1 values: Ready for Review(10208) |
-
- Time Spent:
- 7h
-
Coding
UNit testing
Internal discussion with Ramya
Code Review Request
Time Spent | 206.5h [ 743400 ] | 213.5h [ 768600 ] |
Worklog Id | 68410 [ 68410 ] |
Time Spent | 213.5h [ 768600 ] | 214h [ 770400 ] |
Worklog Id | 68468 [ 68468 ] |
-
- Time Spent:
- 6h
-
Coding
Unit testing
Internal discussion
Code Review
Code Review Changes
Time Spent | 214h [ 770400 ] | 220h [ 792000 ] |
Worklog Id | 68705 [ 68705 ] |
-
- Time Spent:
- 1.5h
-
Discussion with Kumar and Nandu and Code review
Time Spent | 220h [ 792000 ] | 221.5h [ 797400 ] |
Worklog Id | 68734 [ 68734 ] |
Code Review Date | 01/Aug/2017 |
Time Spent | 221.5h [ 797400 ] | 225.5h [ 811800 ] |
Worklog Id | 69001 [ 69001 ] |
-
- Time Spent:
- 4h
-
Code commit to UI Refresh branch
Discussion with Build engineer
Item State | Parent values: Development(10200)Level 1 values: Ready for Review(10208) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Comment | [ A comment with security level 'Developers' was removed. ] |
Attachment | FilesAffected.txt [ 57482 ] |
Assignee | Kumar Chhajed [ kumar.chhajed ] | Smita Pawar [ smita.pawar ] |
Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
Production Due Date | 07/Sep/2017 | |
Stage Due Date | 30/Aug/17 [ 2017-08-30 ] |
-
- Time Spent:
- 6.5h
-
Coding
Unit testing
Internal discussion
Time Spent | 225.5h [ 811800 ] | 232h [ 835200 ] |
Worklog Id | 71785 [ 71785 ] |
Time Spent | 232h [ 835200 ] | 236h [ 849600 ] |
Worklog Id | 72227 [ 72227 ] |
Time Spent | 236h [ 849600 ] | 238h [ 856800 ] |
Worklog Id | 72778 [ 72778 ] |
Item State | Parent values: LB QA(10201)Level 1 values: In Testing(10210) | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) |
Time Spent | 238h [ 856800 ] | 240h [ 864000 ] |
Worklog Id | 73107 [ 73107 ] |
Time Spent | 240h [ 864000 ] | 242h [ 871200 ] |
Worklog Id | 75656 [ 75656 ] |
Remaining Estimate | 0h [ 0 ] | 2h [ 7200 ] |
Time Spent | 242h [ 871200 ] | 240h [ 864000 ] |
Worklog Id | 75656 [ 75656 ] | |
Worklog Time Spent | 2h [ 7200 ] |
Item State | Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
-
- Time Spent:
- 1h
-
Initial analysis & internal discussion
Stage Due Date | 30/Aug/17 [ 2017-08-30 ] | 24/Sep/18 [ 2018-09-24 ] |
Production Due Date | 07/Sep/2017 | 27/Sep/2017 |
-
- Time Spent:
- 0.5h
-
Verification of 1094C and internal discussion about ALE group flag.
Remaining Estimate | 2h [ 7200 ] | 1.5h [ 5400 ] |
Time Spent | 240h [ 864000 ] | 240.5h [ 865800 ] |
Worklog Id | 79209 [ 79209 ] |
-
- Time Spent:
- 4h
-
Analysis
Internal discussion
Test cases
Remaining Estimate | 1.5h [ 5400 ] | 0h [ 0 ] |
Time Spent | 240.5h [ 865800 ] | 244.5h [ 880200 ] |
Worklog Id | 79300 [ 79300 ] |
Stage Due Date | 24/Sep/18 [ 2018-09-24 ] | 10/Oct/18 [ 2018-10-10 ] |
Production Due Date | 27/Sep/2017 | 27/Oct/2017 |
Production Due Date | 27/Oct/2017 | 19/Oct/2017 |
Time Spent | 244.5h [ 880200 ] | 245.5h [ 883800 ] |
Worklog Id | 82584 [ 82584 ] |
Time Spent | 245.5h [ 883800 ] | 245.75h [ 884700 ] |
Worklog Id | 82865 [ 82865 ] |
Time Spent | 245.75h [ 884700 ] | 247h [ 889200 ] |
Worklog Id | 83036 [ 83036 ] |
Time Spent | 247h [ 889200 ] | 251h [ 903600 ] |
Worklog Id | 83916 [ 83916 ] |
Time Spent | 251h [ 903600 ] | 251.5h [ 905400 ] |
Worklog Id | 83916 [ 83916 ] |
Attachment | WT-9196TestCases.xls [ 64059 ] |
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) |
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) |
-
- Time Spent:
- 2.5h
-
Check-ins to Stage
Internal Discussion with Build Engineer
Time Spent | 251.5h [ 905400 ] | 254h [ 914400 ] |
Worklog Id | 84589 [ 84589 ] |
Status | Local Testing [ 10200 ] | Pending for Stage Approval [ 10300 ] |
Status | Pending for Stage Approval [ 10300 ] | Approved for Stage [ 10030 ] |
Status | Approved for Stage [ 10030 ] | Stage Testing [ 10201 ] |
Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
Time Spent | 254h [ 914400 ] | 255.5h [ 919800 ] |
Worklog Id | 84823 [ 84823 ] |
Time Spent | 255.5h [ 919800 ] | 257.5h [ 927000 ] |
Worklog Id | 85443 [ 85443 ] |
Time Spent | 257.5h [ 927000 ] | 259.5h [ 934200 ] |
Worklog Id | 87502 [ 87502 ] |
Time Spent | 259.5h [ 934200 ] | 260.5h [ 937800 ] |
Worklog Id | 87502 [ 87502 ] |
Time Spent | 260.5h [ 937800 ] | 263h [ 946800 ] |
Worklog Id | 87556 [ 87556 ] |
Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) |
Time Spent | 263h [ 946800 ] | 265h [ 954000 ] |
Worklog Id | 90153 [ 90153 ] |
-
- Time Spent:
- 0.5h
-
Enhancement verification on Production
Item State | Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) | Parent values: Production QA(10203)Level 1 values: In Testing(10218) |
Status | Stage Testing [ 10201 ] | Pending for Production Approval [ 10301 ] |
Status | Pending for Production Approval [ 10301 ] | Approved for production [ 10034 ] |
Status | Approved for production [ 10034 ] | Production Testing [ 10202 ] |
Attachment | Customization.png [ 68774 ] |
Attachment | 1094-C PDF corrected.png [ 68777 ] |
Time Spent | 265h [ 954000 ] | 265.75h [ 956700 ] |
Worklog Id | 93423 [ 93423 ] |
Item State | Parent values: Production QA(10203)Level 1 values: In Testing(10218) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
Resolution | Done [ 10000 ] | |
Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
Resolution | Done [ 10000 ] | Fixed [ 1 ] |
Status | Production Complete [ 10028 ] | Closed [ 6 ] |
Time Spent | 265.75h [ 956700 ] | 266.25h [ 958500 ] |
Worklog Id | 93774 [ 93774 ] |
Transition | Time In Source Status | Execution Times |
---|
|
20d 3h 12m | 1 |
|
3s | 1 |
|
3s | 1 |
|
90d 23h 48m | 1 |
|
70d 20h 51m | 1 |
|
5s | 1 |
|
5s | 1 |
|
47d 5h 33m | 1 |
|
9s | 1 |
|
5s | 1 |
|
11m 3s | 1 |
|
4s | 1 |
Hi Nandkumar Prabhakar Karlekar,
Please review the document WT-9196_Functionality.doc
and let me know if any points we discussed are missing from my side or need to be considered.
Smita Pawar FYI, We are in-progress of this enhancement and will let you when it will get deployed on LB.
Thanks,
Kumar Chhajed.