[WT-6760] ACA_New Changes_1H & 2D code not reflecting on 1095-C report.[Rule of Parity] - Workterra Jira

Details

Type: Bug
Status: Closed
Priority: High
Resolution: Done
Affects Version/s: None
Fix Version/s: None
Component/s: ACA
Labels:
None

Environment:

QA
Module:
ACA - Reports
Reported by:
Harbinger
Item State:
Production Complete - Closed

Description

1.Login to LB with partner.
2.Edit company say 'ACA Automation'.
3.Add employee.
4.Import a time sheet of an employee.
January- Part time
February to August - No Data
September to December-Full time
5.Create 1095-C report
6.Run the report
7.Verify report.

Actual: 1B & 2F code not reflected for the month of September
Expected: 1H & 2D code should get reflected for the month of September

[Please refer test employee having SSN 011111120, Screenshot is added for additional information]

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

011111120.png
72 kB
30/Nov/16 10:33 AM
011111120-Verified.png
106 kB
02/Dec/16 01:58 PM
011111150.png
124 kB
21/Dec/16 11:26 AM

Issue Links

relates to

WT-2629 ACA-2017 Providing limited assessment period scenario when Employees status is changed from part time to full time.

Closed

Activity

Ascending order - Click to sort in descending order

Smita Pawar (Inactive) created issue - 30/Nov/16 10:32 AM

Smita Pawar (Inactive) made changes - 30/Nov/16 10:33 AM

Field	Original Value	New Value
Attachment		011111120.png [ 33905 ]

Smita Pawar (Inactive) made changes - 30/Nov/16 10:38 AM

Link

This issue relates to ~~WT-2629~~ [ ~~WT-2629~~ ]

Ramya Tantry (Inactive) made changes - 01/Dec/16 05:44 AM

Assignee

Nandkumar [ satyap ]

Ramya Tantry [ ramya.tantry ]

Ramya Tantry (Inactive) made changes - 01/Dec/16 06:07 AM

Remaining Estimate		7h [ 25200 ]
Original Estimate		7h [ 25200 ]

Ramya Tantry (Inactive) made changes - 01/Dec/16 06:10 AM

Status

Open [ 1 ]

In Development [ 10007 ]

Permalink

Ramya Tantry (Inactive) logged work - 01/Dec/16 01:04 PM

Time Spent:

2h

Analysis
Discussion
code fix

Ramya Tantry (Inactive) made changes - 01/Dec/16 01:05 PM

Remaining Estimate	7h [ 25200 ]	5h [ 18000 ]
Time Spent		2h [ 7200 ]
Worklog Id	11159 [ 11159 ]

Hide

Permalink

Ramya Tantry (Inactive) added a comment - 02/Dec/16 04:05 AM

Files Affected:

Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_ACA_InsertEmployeeData.StoredProcedure.sql
Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Get_ACAIRS1095CData.StoredProcedure.sql

Show

Ramya Tantry (Inactive) added a comment - 02/Dec/16 04:05 AM Files Affected: Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_ACA_InsertEmployeeData.StoredProcedure.sql Database Objects/MasterCompanyDB/04_Stored Procedures/dbo.OES_SP_Get_ACAIRS1095CData.StoredProcedure.sql

Hide

Permalink

Ramya Tantry (Inactive) added a comment - 02/Dec/16 04:16 AM

Smita Pawar,Sachin Hingole

This is just for your information that we were not considering rule of parity hire date in the last execution of 1095/4 reports. We had commented that code. So above issue occurred.
However,after discussion with Nandkumar, we are going to keep the code commented on all companies. We will un-comment the code only in those companies where timesheet is proper and are using timesheet to determine eligibility status.

If the timesheet is not proper, rule of parity will make employees new hire and un-expected codes may come up on reports.

So,in case of testing,first let us know the companies so that we can un comment the code.

Show

Ramya Tantry (Inactive) added a comment - 02/Dec/16 04:16 AM Smita Pawar , Sachin Hingole This is just for your information that we were not considering rule of parity hire date in the last execution of 1095/4 reports. We had commented that code. So above issue occurred. However,after discussion with Nandkumar, we are going to keep the code commented on all companies. We will un-comment the code only in those companies where timesheet is proper and are using timesheet to determine eligibility status. If the timesheet is not proper, rule of parity will make employees new hire and un-expected codes may come up on reports. So,in case of testing,first let us know the companies so that we can un comment the code.

Hide

Permalink

Ramya Tantry (Inactive) added a comment - 02/Dec/16 04:18 AM

Concern: 1H & 2D code not reflecting on 1095-C report.[Rule of Parity]
Cause: Rule of parity code was commented.Refer above comment for more justification
Correction: We will un-comment the code from backend of some selected companies where timesheet is proper and are using timesheet to determine eligibility status.

Show

Ramya Tantry (Inactive) added a comment - 02/Dec/16 04:18 AM Concern : 1H & 2D code not reflecting on 1095-C report. [Rule of Parity] Cause : Rule of parity code was commented.Refer above comment for more justification Correction : We will un-comment the code from backend of some selected companies where timesheet is proper and are using timesheet to determine eligibility status.

Ramya Tantry (Inactive) made changes - 02/Dec/16 04:18 AM

Item State

Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)

Ramya Tantry (Inactive) made changes - 02/Dec/16 04:19 AM

Remaining Estimate	5h [ 18000 ]	4.5h [ 16200 ]
Time Spent	2h [ 7200 ]	2.5h [ 9000 ]
Worklog Id	11203 [ 11203 ]

Ramya Tantry (Inactive) made changes - 02/Dec/16 04:19 AM

Worklog Id

11203 [ 11203 ]

Ramya Tantry (Inactive) made changes - 02/Dec/16 07:00 AM

Assignee

Ramya Tantry [ ramya.tantry ]

Smita Pawar [ smita.pawar ]

Khandu Kshirsagar (Inactive) made changes - 02/Dec/16 07:01 AM

Item State

Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Smita Pawar (Inactive) made changes - 02/Dec/16 12:50 PM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Smita Pawar (Inactive) made changes - 02/Dec/16 12:57 PM

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 (Inactive) added a comment - 02/Dec/16 01:52 PM

We have verified above mentioned issue on LB [ACA Automation] company and checked 1H and 2D code is displaying for the month of September. Its working fine.

We have observed that time sheet report is displaying stable working hours as 40.
PFA screen shot for additional information.

Show

Smita Pawar (Inactive) added a comment - 02/Dec/16 01:52 PM We have verified above mentioned issue on LB [ACA Automation] company and checked 1H and 2D code is displaying for the month of September. Its working fine. We have observed that time sheet report is displaying stable working hours as 40. PFA screen shot for additional information.

Smita Pawar (Inactive) made changes - 02/Dec/16 01:58 PM

Attachment

011111120-Verified.png [ 34319 ]

Permalink

Smita Pawar (Inactive) logged work - 02/Dec/16 01:59 PM

Time Spent:

1.5h

<No comment>

Smita Pawar (Inactive) made changes - 02/Dec/16 01:59 PM

Remaining Estimate	4.5h [ 16200 ]	3h [ 10800 ]
Time Spent	2.5h [ 9000 ]	4h [ 14400 ]
Worklog Id	11355 [ 11355 ]

Permalink

Ramya Tantry (Inactive) logged work - 02/Dec/16 05:49 PM - edited

Time Spent:

0.5h

<No comment>

Permalink

Ramya Tantry (Inactive) logged work - 05/Dec/16 10:14 AM

Time Spent:

1h

timesheet query analysis

Ramya Tantry (Inactive) made changes - 05/Dec/16 10:14 AM

Remaining Estimate	3h [ 10800 ]	2h [ 7200 ]
Time Spent	4h [ 14400 ]	5h [ 18000 ]
Worklog Id	11532 [ 11532 ]

Hide

Permalink

Ramya Tantry (Inactive) added a comment - 05/Dec/16 10:17 AM

Smita Pawar

Timesheet will be displaying 40 as stable working hours because as per data in system,employee is full time.He was neither terminated nor his leave was imported.

Show

Ramya Tantry (Inactive) added a comment - 05/Dec/16 10:17 AM Smita Pawar Timesheet will be displaying 40 as stable working hours because as per data in system,employee is full time.He was neither terminated nor his leave was imported.

Smita Pawar (Inactive) made changes - 05/Dec/16 12:53 PM

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)

Rakesh Roy (Inactive) made changes - 08/Dec/16 04:40 AM

Developer

Ramya Tantry [ ramya.tantry ]

Khandu Kshirsagar (Inactive) made changes - 12/Dec/16 07:05 AM

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)

Rakesh Roy (Inactive) made changes - 12/Dec/16 08:47 AM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Smita Pawar (Inactive) made changes - 14/Dec/16 05:09 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Permalink

Smita Pawar (Inactive) logged work - 15/Dec/16 01:33 PM

Time Spent:

1h

Testing and Test data creation

Smita Pawar (Inactive) made changes - 15/Dec/16 01:33 PM

Original Estimate

7h [ 25200 ]

16h [ 57600 ]

Smita Pawar (Inactive) made changes - 15/Dec/16 01:33 PM

Remaining Estimate	2h [ 7200 ]	1h [ 3600 ]
Time Spent	5h [ 18000 ]	6h [ 21600 ]
Worklog Id	13527 [ 13527 ]

Permalink

Smita Pawar (Inactive) logged work - 19/Dec/16 11:59 AM

Time Spent:

1h

Stage testing

Smita Pawar (Inactive) made changes - 19/Dec/16 11:59 AM

Remaining Estimate	1h [ 3600 ]	0h [ 0 ]
Time Spent	6h [ 21600 ]	7h [ 25200 ]
Worklog Id	14223 [ 14223 ]

Permalink

Ramya Tantry (Inactive) logged work - 20/Dec/16 12:29 PM

Time Spent:

0.5h

analysis of QA queries

Ramya Tantry (Inactive) made changes - 20/Dec/16 12:29 PM

Time Spent	7h [ 25200 ]	7.5h [ 27000 ]
Worklog Id	14509 [ 14509 ]

Permalink

Smita Pawar (Inactive) logged work - 20/Dec/16 12:49 PM

Time Spent:

0.5h

Discussion

Smita Pawar (Inactive) made changes - 20/Dec/16 12:50 PM

Time Spent	7.5h [ 27000 ]	8h [ 28800 ]
Worklog Id	14521 [ 14521 ]

Ramya Tantry (Inactive) made changes - 21/Dec/16 06:19 AM

Time Spent	8h [ 28800 ]	8.5h [ 30600 ]
Worklog Id	14667 [ 14667 ]

Permalink

Smita Pawar (Inactive) logged work - 21/Dec/16 11:26 AM

Time Spent:

0.75h

Stage testting

Hide

Permalink

Smita Pawar (Inactive) added a comment - 21/Dec/16 11:26 AM

We have verified above mentioned issue on Stage [ACA Automation] company and checked 1H and 2D code is displaying for the month of September. Its working fine.
PFA screen shot for additional information.

This fix is ready for Production but we will move to production with enhancement ~~WT-2629~~.

Show

Smita Pawar (Inactive) added a comment - 21/Dec/16 11:26 AM We have verified above mentioned issue on Stage [ACA Automation] company and checked 1H and 2D code is displaying for the month of September. Its working fine. PFA screen shot for additional information. This fix is ready for Production but we will move to production with enhancement WT-2629 .

Smita Pawar (Inactive) made changes - 21/Dec/16 11:26 AM

Attachment

011111150.png [ 35607 ]

Smita Pawar (Inactive) made changes - 21/Dec/16 11:27 AM

Time Spent	8.5h [ 30600 ]	9.25h [ 33300 ]
Worklog Id	14718 [ 14718 ]

Smita Pawar (Inactive) made changes - 21/Dec/16 12:41 PM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Smita Pawar (Inactive) made changes - 21/Dec/16 12:42 PM

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)

Permalink

Ramya Tantry (Inactive) logged work - 21/Dec/16 06:19 PM

Time Spent:

0.5h

Analysis of QA queries

Ashwin Wankhede (Inactive) made changes - 27/Dec/16 06:22 AM

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)

Ramya Tantry (Inactive) made changes - 27/Dec/16 06:22 AM

Code Reviewed By

Nandkumar Karlekar [ 11904 ]

Rakesh Roy (Inactive) made changes - 27/Dec/16 06:23 AM

Resolution		Fixed [ 1 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Rakesh Roy (Inactive) made changes - 27/Dec/16 06:23 AM

Item State

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

Parent values: Production Complete(10222)Level 1 values: Closed(10223)

Mahendra Mungase (Inactive) made changes - 21/Feb/17 05:04 AM

Status

Production Complete [ 10028 ]

Closed [ 6 ]

Satya made changes - 04/Nov/17 06:19 AM

Environment_New

LB [ 18444 ]

Transition	Time In Source Status	Execution Times

Ramya Tantry (Inactive) made transition - 01/Dec/16 06:10 AM

Open

In Development

19h 37m

Smita Pawar (Inactive) made transition - 02/Dec/16 12:50 PM

In Development

In LB Testing

1d 6h 40m

Rakesh Roy (Inactive) made transition - 12/Dec/16 08:47 AM

In LB Testing

Stage Testing

9d 19h 56m

Smita Pawar (Inactive) made transition - 21/Dec/16 12:41 PM

Stage Testing

In Production Testing

9d 3h 54m

Rakesh Roy (Inactive) made transition - 27/Dec/16 06:23 AM

In Production Testing

Production Complete

5d 17h 41m

Mahendra Mungase (Inactive) made transition - 21/Feb/17 05:04 AM

Production Complete

Closed

55d 22h 40m

People

Assignee:: Smita Pawar (Inactive)

Reporter:: Smita Pawar (Inactive)

Developer:: Ramya Tantry (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 30/Nov/16 10:32 AM

Updated:: 04/Nov/17 06:19 AM

Resolved:: 27/Dec/16 06:23 AM

Time Tracking

Estimated:

16h

Remaining:

Logged:

9.25h