[WT-895] FDU Payroll file testing results - Workterra Jira

Details

Type: Support Activity
Status: Resolved
Priority: High
Resolution: Done
Affects Version/s: None
Fix Version/s: None
Component/s: BenAdmin
Labels:
None

Support Task Type:
Configuration
Environment:

Stage
Reported by:
Support
Company:
FDU
Module:
BenAdmin - Export

Description

HI all – could you please tell me if we ever made the changes to the templates per the original request? If not, what do we need from UHC to get that done?

Hi Jen,
As per our call, the two file templates that I am using for the test payroll files are in Stage under the global templates named:
FDU Payroll (this is the medical payroll file)
FDU Other (this is the payroll file that contains all of the other benefits)

Please have the file updated to include the logic updates that will correct the below items. Please let me know if you need any other information.

Medical Test file
1. Domestic Partner - Thomas Test in SM 9 month with a DP
a. the DP line is pulling a DPSP12 benefit plan code and it should be DPSP09
b. the DP line is missing participation code of E
c. Coverage Code is showing 1 and should be DPS9
2. Waiver plan is termed - Joyce Skinner (Terminated status which termed the Waiver plan
a. Benefit plan should be a single ~ instead of a double ~ ~
b. The Participation Code should just be a W with no ~
3. Medical plan is termed – Rosemary Murphy (Terminated status which termed Medical plan)
a. Benefit Plan code should be ~ instead of the code (EEONLY)
b. Participation code should be a W and not E~

Other Payroll Test file:
1. Terminations – Tilde needs to be removed from the Deduction code and place by itself in the ded amount column
2. “File Number” header should be named “Employee ID”
3. The deductions should pull Per pay period, currently pulling monthly
4. Missing the following benefits from this file:
a. Child Life
b. Child AD&D
c. Met Law

Rajendra Pawar (Inactive) created issue - 23/Feb/16 02:20 PM

Rajendra Pawar (Inactive) made changes - 23/Feb/16 02:20 PM

Field	Original Value	New Value
Assignee	Satya [ ID10004 ]	Rajendra Pawar [ rajendra.pawar ]

Rajendra Pawar (Inactive) made changes - 23/Feb/16 02:20 PM

Assignee

Rajendra Pawar [ rajendra.pawar ]

Ganesh Sadawarte [ ganesh.sadawarte ]

Ganesh Sadawarte (Inactive) made changes - 23/Feb/16 02:22 PM

Assignee

Ganesh Sadawarte [ ganesh.sadawarte ]

Jennifer Leugers [ jennifer.leugers ]

Rakesh Roy (Inactive) made changes - 27/Feb/16 07:52 AM

Assignee	Jennifer Leugers [ jennifer.leugers ]	Rakesh Roy [ rakeshr ]
Status	Open [ 1 ]	In Progress [ 3 ]

Rakesh Roy (Inactive) made changes - 27/Feb/16 07:52 AM

Assignee

Rakesh Roy [ rakeshr ]

Jennifer Leugers [ jennifer.leugers ]

Vinayak Kulkarni (Inactive) made changes - 29/Feb/16 06:29 PM

Assignee

Jennifer Leugers [ jennifer.leugers ]

Ganesh Sadawarte [ ganesh.sadawarte ]

Ganesh Sadawarte (Inactive) made changes - 07/Mar/16 08:38 AM

Assignee

Ganesh Sadawarte [ ganesh.sadawarte ]

Jennifer Leugers [ jennifer.leugers ]

Rakesh Roy (Inactive) made changes - 07/Mar/16 10:25 AM

Resolution		Done [ 10000 ]
Status	In Progress [ 3 ]	Resolved [ 5 ]

Jennifer Leugers made changes - 08/Mar/16 02:50 PM

Resolution	Done [ 10000 ]
Status	Resolved [ 5 ]	Reopened [ 4 ]

Jennifer Leugers made changes - 08/Mar/16 02:50 PM

Attachment

FDU medical payroll Data_Needed_Format.xlsx [ 13333 ]

Hanmant Shinde (Inactive) made changes - 15/Mar/16 05:36 AM

Attachment

FDU medical payroll Data_Needed_Format.xls [ 13850 ]

Rakesh Roy (Inactive) made changes - 20/Mar/16 03:02 AM

Assignee

Jennifer Leugers [ jennifer.leugers ]

Ganesh Sadawarte [ ganesh.sadawarte ]

Ganesh Sadawarte (Inactive) made changes - 21/Mar/16 05:12 AM

Status

Reopened [ 4 ]

In Progress [ 3 ]

Ganesh Sadawarte (Inactive) made changes - 21/Mar/16 11:38 AM

Attachment

Benefit Salary Eligibilty.png [ 14206 ]

Ganesh Sadawarte (Inactive) made changes - 21/Mar/16 11:45 AM

Assignee	Ganesh Sadawarte [ ganesh.sadawarte ]	Jennifer Leugers [ jennifer.leugers ]
Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Resolved [ 5 ]

Jennifer Leugers made changes - 25/Mar/16 02:49 PM

Resolution	Fixed [ 1 ]
Status	Resolved [ 5 ]	Reopened [ 4 ]

Rakesh Roy (Inactive) made changes - 26/Mar/16 03:24 AM

Assignee

Jennifer Leugers [ jennifer.leugers ]

Ganesh Sadawarte [ ganesh.sadawarte ]

Ganesh Sadawarte (Inactive) made changes - 30/Mar/16 12:15 PM

Assignee

Ganesh Sadawarte [ ganesh.sadawarte ]

Hanmant Shinde [ hanmant.shinde ]

Hanmant Shinde (Inactive) made changes - 31/Mar/16 07:12 AM

Assignee

Hanmant Shinde [ hanmant.shinde ]

Prashant Samal [ prashant.samal ]

Prashant Samal (Inactive) made changes - 01/Apr/16 12:11 PM

Assignee

Prashant Samal [ prashant.samal ]

Ganesh Sadawarte [ ganesh.sadawarte ]

Ganesh Sadawarte (Inactive) made changes - 01/Apr/16 12:22 PM

Assignee

Ganesh Sadawarte [ ganesh.sadawarte ]

Jennifer Leugers [ jennifer.leugers ]

Ganesh Sadawarte (Inactive) made changes - 01/Apr/16 12:22 PM

Assignee	Jennifer Leugers [ jennifer.leugers ]	Ganesh Sadawarte [ ganesh.sadawarte ]
Status	Reopened [ 4 ]	In Progress [ 3 ]

Ganesh Sadawarte (Inactive) made changes - 01/Apr/16 12:22 PM

Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Resolved [ 5 ]

Ganesh Sadawarte (Inactive) made changes - 04/Apr/16 11:36 AM

Assignee

Ganesh Sadawarte [ ganesh.sadawarte ]

Jennifer Leugers [ jennifer.leugers ]

Jennifer Leugers made changes - 06/Apr/16 03:42 PM

Resolution	Fixed [ 1 ]
Status	Resolved [ 5 ]	Reopened [ 4 ]

Rakesh Roy (Inactive) made changes - 06/Apr/16 03:51 PM

Assignee

Jennifer Leugers [ jennifer.leugers ]

Ganesh Sadawarte [ ganesh.sadawarte ]

Ganesh Sadawarte (Inactive) made changes - 11/Apr/16 06:37 AM

Assignee

Ganesh Sadawarte [ ganesh.sadawarte ]

Rajendra Pawar [ rajendra.pawar ]

Rajendra Pawar (Inactive) made changes - 11/Apr/16 11:28 AM

Assignee

Rajendra Pawar [ rajendra.pawar ]

Jennifer Leugers [ jennifer.leugers ]

Rajendra Pawar (Inactive) made changes - 11/Apr/16 11:29 AM

Assignee	Jennifer Leugers [ jennifer.leugers ]	Rajendra Pawar [ rajendra.pawar ]
Status	Reopened [ 4 ]	In Progress [ 3 ]

Rajendra Pawar (Inactive) made changes - 11/Apr/16 11:30 AM

Assignee

Rajendra Pawar [ rajendra.pawar ]

Jennifer Leugers [ jennifer.leugers ]

Rakesh Roy (Inactive) made changes - 16/May/16 05:08 PM

Assignee

Jennifer Leugers [ jennifer.leugers ]

Rohan Khandave [ rohan.khandave ]

Rohan J Khandave (Inactive) made changes - 22/Jun/16 05:26 PM

Assignee

Rohan Khandave [ rohan.khandave ]

Ganesh Sadawarte [ ganesh.sadawarte ]

Ganesh Sadawarte (Inactive) made changes - 22/Jun/16 06:51 PM

Assignee	Ganesh Sadawarte [ ganesh.sadawarte ]	Jennifer Leugers [ jennifer.leugers ]
Resolution		Fixed [ 1 ]
Status	In Progress [ 3 ]	Resolved [ 5 ]

Jennifer Leugers made changes - 16/Nov/16 10:04 PM

Resolution	Fixed [ 1 ]
Status	Resolved [ 5 ]	Reopened [ 4 ]

Rajendra Pawar (Inactive) made changes - 17/Nov/16 11:15 AM

Assignee	Jennifer Leugers [ jennifer.leugers ]	Rajendra Pawar [ rajendra.pawar ]
Status	Reopened [ 4 ]	In Progress [ 3 ]

Rajendra Pawar (Inactive) made changes - 17/Nov/16 11:19 AM

Attachment

Randy Test_DP.JPG [ 32710 ]

Rajendra Pawar (Inactive) made changes - 17/Nov/16 11:19 AM

Attachment

Randy Test_Enrollment.JPG [ 32711 ]

Rajendra Pawar (Inactive) made changes - 17/Nov/16 12:08 PM

Assignee

Rajendra Pawar [ rajendra.pawar ]

Jennifer Leugers [ jennifer.leugers ]

Vinayak Kulkarni (Inactive) made changes - 23/Nov/16 10:08 PM

Attachment

Code_sheet_snap.png [ 33300 ]

Vinayak Kulkarni (Inactive) made changes - 23/Nov/16 10:08 PM

Resolution		Done [ 10000 ]
Status	In Progress [ 3 ]	Resolved [ 5 ]

Khandu Kshirsagar (Inactive) made changes - 24/Nov/16 06:19 AM

Item State

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

Jennifer Leugers made changes - 08/Dec/16 05:54 PM

Resolution	Done [ 10000 ]
Status	Resolved [ 5 ]	Reopened [ 4 ]

Jennifer Leugers made changes - 08/Dec/16 05:55 PM

Attachment

screenshot-1.png [ 34728 ]

Vinayak Kulkarni (Inactive) made changes - 09/Dec/16 09:26 AM

Assignee	Jennifer Leugers [ jennifer.leugers ]	Vinayak Kulkarni [ vinayak.kulkarni ]
Status	Reopened [ 4 ]	In Progress [ 3 ]

Vinayak Kulkarni (Inactive) made changes - 09/Dec/16 10:18 AM

Attachment

Employees_payrollschedule.PNG [ 34803 ]

Vinayak Kulkarni (Inactive) made changes - 09/Dec/16 10:18 AM

Attachment

Company_Payrollschedules.png [ 34804 ]

Vinayak Kulkarni (Inactive) made changes - 09/Dec/16 10:19 AM

Assignee	Vinayak Kulkarni [ vinayak.kulkarni ]	Jennifer Leugers [ jennifer.leugers ]
Resolution		Done [ 10000 ]
Status	In Progress [ 3 ]	Resolved [ 5 ]

Vinayak Kulkarni (Inactive) made changes - 09/Dec/16 01:49 PM

Support Task Type		Customization [ 11204 ]
Remaining Estimate		7h [ 25200 ]
Original Estimate		7h [ 25200 ]

Vinayak Kulkarni (Inactive) made changes - 09/Dec/16 01:49 PM

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

Jennifer Leugers made changes - 13/Dec/16 03:52 PM

Resolution	Done [ 10000 ]
Status	Resolved [ 5 ]	Reopened [ 4 ]

Rakesh Roy (Inactive) made changes - 13/Dec/16 04:50 PM

Assignee

Jennifer Leugers [ jennifer.leugers ]

Vinayak Kulkarni [ vinayak.kulkarni ]

Vinayak Kulkarni (Inactive) made changes - 14/Dec/16 11:56 AM

Assignee

Vinayak Kulkarni [ vinayak.kulkarni ]

Ashwin Wankhede [ ashwin.wankhede ]

Ashwin Wankhede (Inactive) made changes - 15/Dec/16 09:18 AM

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

Ashwin Wankhede (Inactive) made changes - 15/Dec/16 09:19 AM

Assignee

Ashwin Wankhede [ ashwin.wankhede ]

Khandu Kshirsagar [ khandu.kshirsagar ]

Ashwin Wankhede (Inactive) made changes - 15/Dec/16 09:19 AM

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

Vinayak Kulkarni (Inactive) made changes - 15/Dec/16 05:19 PM

Remaining Estimate	4h [ 14400 ]	0h [ 0 ]
Time Spent	3h [ 10800 ]	7h [ 25200 ]
Worklog Id	13566 [ 13566 ]

Khandu Kshirsagar (Inactive) made changes - 16/Dec/16 09:10 AM

Assignee

Khandu Kshirsagar [ khandu.kshirsagar ]

Vinayak Kulkarni [ vinayak.kulkarni ]

Vinayak Kulkarni (Inactive) made changes - 19/Dec/16 06:28 AM

Status

Reopened [ 4 ]

In Progress [ 3 ]

Vinayak Kulkarni (Inactive) made changes - 19/Dec/16 09:53 AM

Assignee	Vinayak Kulkarni [ vinayak.kulkarni ]	Jennifer Leugers [ jennifer.leugers ]
Resolution		Done [ 10000 ]
Status	In Progress [ 3 ]	Resolved [ 5 ]

Vinayak Kulkarni (Inactive) made changes - 19/Dec/16 03:58 PM

Time Spent	7h [ 25200 ]	11h [ 39600 ]
Worklog Id	14338 [ 14338 ]

Jennifer Leugers made changes - 20/Dec/16 04:02 PM

Resolution	Done [ 10000 ]
Status	Resolved [ 5 ]	Reopened [ 4 ]

Jennifer Leugers made changes - 20/Dec/16 04:02 PM

Attachment

screenshot-2.png [ 35461 ]

Jennifer Leugers made changes - 20/Dec/16 04:02 PM

Assignee

Jennifer Leugers [ jennifer.leugers ]

Vinayak Kulkarni [ vinayak.kulkarni ]

Vinayak Kulkarni (Inactive) made changes - 21/Dec/16 06:02 AM

Assignee	Vinayak Kulkarni [ vinayak.kulkarni ]	Jennifer Leugers [ jennifer.leugers ]
Resolution		Done [ 10000 ]
Status	Reopened [ 4 ]	Resolved [ 5 ]

Vinayak Kulkarni (Inactive) made changes - 21/Dec/16 02:38 PM

Time Spent	11h [ 39600 ]	12h [ 43200 ]
Worklog Id	14828 [ 14828 ]

Jennifer Leugers made changes - 30/Dec/16 07:50 PM

Resolution	Done [ 10000 ]
Status	Resolved [ 5 ]	Reopened [ 4 ]

Jennifer Leugers made changes - 30/Dec/16 07:51 PM

Attachment

FDU Medical payroll structure 111616.xlsx [ 36302 ]

Jennifer Leugers made changes - 30/Dec/16 07:51 PM

Assignee

Jennifer Leugers [ jennifer.leugers ]

Vinayak Kulkarni [ vinayak.kulkarni ]

Vinayak Kulkarni (Inactive) made changes - 02/Jan/17 09:32 AM

Status

Reopened [ 4 ]

In Progress [ 3 ]

Vinayak Kulkarni (Inactive) made changes - 03/Jan/17 04:57 AM

Assignee	Vinayak Kulkarni [ vinayak.kulkarni ]	Jennifer Leugers [ jennifer.leugers ]
Resolution		Done [ 10000 ]
Status	In Progress [ 3 ]	Resolved [ 5 ]

Vinayak Kulkarni (Inactive) made changes - 03/Jan/17 05:54 AM

Time Spent	12h [ 43200 ]	16h [ 57600 ]
Worklog Id	16794 [ 16794 ]

Prashant Samal (Inactive) made changes - 03/Jan/17 07:22 AM

Attachment		FDU_Backend - Plan Class Tier Codes.xls [ 36419 ]
Attachment		Old and New Codes Comparison.xls [ 36420 ]

Yogita Bhadane (Inactive) made changes - 04/Jan/17 10:28 AM

Attachment

FDU - Codes ID'S Sheet_Effective_16.xls [ 36607 ]

Prashant Samal (Inactive) made changes - 04/Jan/17 12:33 PM

Time Spent	16h [ 57600 ]	18h [ 64800 ]
Worklog Id	17153 [ 17153 ]

Rakesh Shahane (Inactive) made changes - 04/Jan/17 03:21 PM

Time Spent	18h [ 64800 ]	21.5h [ 77400 ]
Worklog Id	17256 [ 17256 ]

Yogita Bhadane (Inactive) made changes - 05/Jan/17 04:15 AM

Time Spent	21.5h [ 77400 ]	27h [ 97200 ]
Worklog Id	17270 [ 17270 ]

Yogita Bhadane (Inactive) made changes - 05/Jan/17 04:18 AM

Time Spent	27h [ 97200 ]	30.5h [ 109800 ]
Worklog Id	17272 [ 17272 ]

Prashant Samal (Inactive) made changes - 06/Jan/17 07:46 AM

Time Spent	30.5h [ 109800 ]	32.2h [ 115920 ]
Worklog Id	17689 [ 17689 ]

Jennifer Leugers made changes - 26/Jan/17 05:17 PM

Resolution	Done [ 10000 ]
Status	Resolved [ 5 ]	Reopened [ 4 ]

Jennifer Leugers made changes - 26/Jan/17 05:17 PM

Attachment

screenshot-3.png [ 38304 ]

Jennifer Leugers made changes - 26/Jan/17 05:18 PM

Assignee

Jennifer Leugers [ jennifer.leugers ]

Rajendra Pawar [ rajendra.pawar ]

Rakesh Roy (Inactive) made changes - 26/Jan/17 05:19 PM

Priority

Medium [ 3 ]

High [ 2 ]

Rajendra Pawar (Inactive) made changes - 27/Jan/17 04:34 AM

Status

Reopened [ 4 ]

In Progress [ 3 ]

Rajendra Pawar (Inactive) made changes - 27/Jan/17 07:19 AM

Time Spent	32.2h [ 115920 ]	34.2h [ 123120 ]
Worklog Id	21212 [ 21212 ]

Rajendra Pawar (Inactive) made changes - 27/Jan/17 07:20 AM

Assignee

Rajendra Pawar [ rajendra.pawar ]

Jennifer Leugers [ jennifer.leugers ]

Rajendra Pawar (Inactive) made changes - 27/Jan/17 07:20 AM

Resolution		Done [ 10000 ]
Status	In Progress [ 3 ]	Resolved [ 5 ]

Rohan J Khandave (Inactive) made changes - 27/Jan/17 02:30 PM

Time Spent	34.2h [ 123120 ]	36.2h [ 130320 ]
Worklog Id	21422 [ 21422 ]

Jennifer Leugers made changes - 16/Feb/17 05:58 PM

Attachment

screenshot-4.png [ 39925 ]

Jennifer Leugers made changes - 16/Feb/17 05:58 PM

Resolution	Done [ 10000 ]
Status	Resolved [ 5 ]	Reopened [ 4 ]

Jennifer Leugers made changes - 16/Feb/17 05:58 PM

Assignee

Jennifer Leugers [ jennifer.leugers ]

Rajendra Pawar [ rajendra.pawar ]

Vinayak Kulkarni (Inactive) made changes - 17/Feb/17 09:31 AM

Assignee

Rajendra Pawar [ rajendra.pawar ]

Khandu Kshirsagar [ khandu.kshirsagar ]

Khandu Kshirsagar (Inactive) made changes - 20/Feb/17 08:34 AM

Status

Reopened [ 4 ]

In Progress [ 3 ]

Vinayak Kulkarni (Inactive) made changes - 20/Feb/17 09:58 AM

Time Spent	36.2h [ 130320 ]	38.2h [ 137520 ]
Worklog Id	26086 [ 26086 ]

Khandu Kshirsagar (Inactive) made changes - 20/Feb/17 12:59 PM

Attachment

WT-895_Company Migration Production To Stage.xls [ 40217 ]

Khandu Kshirsagar (Inactive) made changes - 20/Feb/17 01:01 PM

Assignee

Khandu Kshirsagar [ khandu.kshirsagar ]

Prasad Pise [ prasadp ]

Khandu Kshirsagar (Inactive) made changes - 20/Feb/17 01:01 PM

Time Spent	38.2h [ 137520 ]	40.2h [ 144720 ]
Worklog Id	26142 [ 26142 ]

Ashwin Wankhede (Inactive) made changes - 20/Feb/17 03:35 PM

Time Spent	40.2h [ 144720 ]	41.7h [ 150120 ]
Worklog Id	26204 [ 26204 ]

Prasad Pise (Inactive) made changes - 22/Feb/17 11:08 AM

Assignee

Prasad Pise [ prasadp ]

Rajendra Pawar [ rajendra.pawar ]

Vinayak Kulkarni (Inactive) made changes - 23/Feb/17 04:56 AM

Assignee	Rajendra Pawar [ rajendra.pawar ]	Jennifer Leugers [ jennifer.leugers ]
Resolution		Done [ 10000 ]
Status	In Progress [ 3 ]	Resolved [ 5 ]

Yogita Bhadane (Inactive) made changes - 24/Feb/17 12:34 PM

Time Spent	41.7h [ 150120 ]	42.2h [ 151920 ]
Worklog Id	27201 [ 27201 ]

Prajakta Belhe (Inactive) made changes - 27/Feb/17 11:40 AM

Time Spent	42.2h [ 151920 ]	45.2h [ 162720 ]
Worklog Id	27542 [ 27542 ]

Vinayak Kulkarni (Inactive) made changes - 03/Mar/17 11:43 AM

Time Spent	45.2h [ 162720 ]	46.7h [ 168120 ]
Worklog Id	28813 [ 28813 ]

Vinayak Kulkarni (Inactive) made changes - 03/Mar/17 02:37 PM

Time Spent	46.7h [ 168120 ]	48.2h [ 173520 ]
Worklog Id	29003 [ 29003 ]

Satya made changes - 04/Nov/17 07:27 AM

Environment_New

Stage [ 18443 ]

People

Assignee:: Jennifer Leugers

Reporter:: Rajendra Pawar (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 10 Start watching this issue

Dates

Created:: 23/Feb/16 02:20 PM

Updated:: 04/Nov/17 07:27 AM

Resolved:: 23/Feb/17 04:56 AM

Time Tracking

Estimated:

Remaining:

Logged:

48.2h

Details

Description

Attachments

Attachments

Activity

People

Dates

Time Tracking