-
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
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
Field | Original Value | New Value |
---|---|---|
Assignee | Satya [ ID10004 ] | Rajendra Pawar [ rajendra.pawar ] |
Assignee | Rajendra Pawar [ rajendra.pawar ] | Ganesh Sadawarte [ ganesh.sadawarte ] |
Assignee | Ganesh Sadawarte [ ganesh.sadawarte ] | Jennifer Leugers [ jennifer.leugers ] |
Assignee | Jennifer Leugers [ jennifer.leugers ] | Rakesh Roy [ rakeshr ] |
Status | Open [ 1 ] | In Progress [ 3 ] |
Assignee | Rakesh Roy [ rakeshr ] | Jennifer Leugers [ jennifer.leugers ] |
Assignee | Jennifer Leugers [ jennifer.leugers ] | Ganesh Sadawarte [ ganesh.sadawarte ] |
Assignee | Ganesh Sadawarte [ ganesh.sadawarte ] | Jennifer Leugers [ jennifer.leugers ] |
Resolution | Done [ 10000 ] | |
Status | In Progress [ 3 ] | Resolved [ 5 ] |
Resolution | Done [ 10000 ] | |
Status | Resolved [ 5 ] | Reopened [ 4 ] |
Attachment | FDU medical payroll Data_Needed_Format.xlsx [ 13333 ] |
Attachment | FDU medical payroll Data_Needed_Format.xls [ 13850 ] |
Assignee | Jennifer Leugers [ jennifer.leugers ] | Ganesh Sadawarte [ ganesh.sadawarte ] |
Status | Reopened [ 4 ] | In Progress [ 3 ] |
Attachment | Benefit Salary Eligibilty.png [ 14206 ] |
Assignee | Ganesh Sadawarte [ ganesh.sadawarte ] | Jennifer Leugers [ jennifer.leugers ] |
Resolution | Fixed [ 1 ] | |
Status | In Progress [ 3 ] | Resolved [ 5 ] |
Resolution | Fixed [ 1 ] | |
Status | Resolved [ 5 ] | Reopened [ 4 ] |
Assignee | Jennifer Leugers [ jennifer.leugers ] | Ganesh Sadawarte [ ganesh.sadawarte ] |
Assignee | Ganesh Sadawarte [ ganesh.sadawarte ] | Hanmant Shinde [ hanmant.shinde ] |
Assignee | Hanmant Shinde [ hanmant.shinde ] | Prashant Samal [ prashant.samal ] |
Assignee | Prashant Samal [ prashant.samal ] | Ganesh Sadawarte [ ganesh.sadawarte ] |
Assignee | Ganesh Sadawarte [ ganesh.sadawarte ] | Jennifer Leugers [ jennifer.leugers ] |
Assignee | Jennifer Leugers [ jennifer.leugers ] | Ganesh Sadawarte [ ganesh.sadawarte ] |
Status | Reopened [ 4 ] | In Progress [ 3 ] |
Resolution | Fixed [ 1 ] | |
Status | In Progress [ 3 ] | Resolved [ 5 ] |
Assignee | Ganesh Sadawarte [ ganesh.sadawarte ] | Jennifer Leugers [ jennifer.leugers ] |
Resolution | Fixed [ 1 ] | |
Status | Resolved [ 5 ] | Reopened [ 4 ] |
Assignee | Jennifer Leugers [ jennifer.leugers ] | Ganesh Sadawarte [ ganesh.sadawarte ] |
Assignee | Ganesh Sadawarte [ ganesh.sadawarte ] | Rajendra Pawar [ rajendra.pawar ] |
Assignee | Rajendra Pawar [ rajendra.pawar ] | Jennifer Leugers [ jennifer.leugers ] |
Assignee | Jennifer Leugers [ jennifer.leugers ] | Rajendra Pawar [ rajendra.pawar ] |
Status | Reopened [ 4 ] | In Progress [ 3 ] |
Assignee | Rajendra Pawar [ rajendra.pawar ] | Jennifer Leugers [ jennifer.leugers ] |
Assignee | Jennifer Leugers [ jennifer.leugers ] | Rohan Khandave [ rohan.khandave ] |
Assignee | Rohan Khandave [ rohan.khandave ] | Ganesh Sadawarte [ ganesh.sadawarte ] |
Assignee | Ganesh Sadawarte [ ganesh.sadawarte ] | Jennifer Leugers [ jennifer.leugers ] |
Resolution | Fixed [ 1 ] | |
Status | In Progress [ 3 ] | Resolved [ 5 ] |
Resolution | Fixed [ 1 ] | |
Status | Resolved [ 5 ] | Reopened [ 4 ] |
Assignee | Jennifer Leugers [ jennifer.leugers ] | Rajendra Pawar [ rajendra.pawar ] |
Status | Reopened [ 4 ] | In Progress [ 3 ] |
Attachment | Randy Test_DP.JPG [ 32710 ] |
Attachment | Randy Test_Enrollment.JPG [ 32711 ] |
Assignee | Rajendra Pawar [ rajendra.pawar ] | Jennifer Leugers [ jennifer.leugers ] |
Attachment | Code_sheet_snap.png [ 33300 ] |
Resolution | Done [ 10000 ] | |
Status | In Progress [ 3 ] | Resolved [ 5 ] |
Item State | Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) |
Resolution | Done [ 10000 ] | |
Status | Resolved [ 5 ] | Reopened [ 4 ] |
Attachment | screenshot-1.png [ 34728 ] |
Assignee | Jennifer Leugers [ jennifer.leugers ] | Vinayak Kulkarni [ vinayak.kulkarni ] |
Status | Reopened [ 4 ] | In Progress [ 3 ] |
Attachment | Employees_payrollschedule.PNG [ 34803 ] |
Attachment | Company_Payrollschedules.png [ 34804 ] |
Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | Jennifer Leugers [ jennifer.leugers ] |
Resolution | Done [ 10000 ] | |
Status | In Progress [ 3 ] | Resolved [ 5 ] |
Support Task Type | Customization [ 11204 ] | |
Remaining Estimate | 7h [ 25200 ] | |
Original Estimate | 7h [ 25200 ] |
Remaining Estimate | 7h [ 25200 ] | 5h [ 18000 ] |
Time Spent | 2h [ 7200 ] | |
Worklog Id | 12373 [ 12373 ] |
Resolution | Done [ 10000 ] | |
Status | Resolved [ 5 ] | Reopened [ 4 ] |
Assignee | Jennifer Leugers [ jennifer.leugers ] | Vinayak Kulkarni [ vinayak.kulkarni ] |
Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | Ashwin Wankhede [ ashwin.wankhede ] |
Remaining Estimate | 5h [ 18000 ] | 4.5h [ 16200 ] |
Time Spent | 2h [ 7200 ] | 2.5h [ 9000 ] |
Worklog Id | 13303 [ 13303 ] |
Assignee | Ashwin Wankhede [ ashwin.wankhede ] | Khandu Kshirsagar [ khandu.kshirsagar ] |
Remaining Estimate | 4.5h [ 16200 ] | 4h [ 14400 ] |
Time Spent | 2.5h [ 9000 ] | 3h [ 10800 ] |
Worklog Id | 13304 [ 13304 ] |
Remaining Estimate | 4h [ 14400 ] | 0h [ 0 ] |
Time Spent | 3h [ 10800 ] | 7h [ 25200 ] |
Worklog Id | 13566 [ 13566 ] |
Assignee | Khandu Kshirsagar [ khandu.kshirsagar ] | Vinayak Kulkarni [ vinayak.kulkarni ] |
Status | Reopened [ 4 ] | In Progress [ 3 ] |
Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | Jennifer Leugers [ jennifer.leugers ] |
Resolution | Done [ 10000 ] | |
Status | In Progress [ 3 ] | Resolved [ 5 ] |
Time Spent | 7h [ 25200 ] | 11h [ 39600 ] |
Worklog Id | 14338 [ 14338 ] |
Resolution | Done [ 10000 ] | |
Status | Resolved [ 5 ] | Reopened [ 4 ] |
Attachment | screenshot-2.png [ 35461 ] |
Assignee | Jennifer Leugers [ jennifer.leugers ] | Vinayak Kulkarni [ vinayak.kulkarni ] |
Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | Jennifer Leugers [ jennifer.leugers ] |
Resolution | Done [ 10000 ] | |
Status | Reopened [ 4 ] | Resolved [ 5 ] |
Time Spent | 11h [ 39600 ] | 12h [ 43200 ] |
Worklog Id | 14828 [ 14828 ] |
Resolution | Done [ 10000 ] | |
Status | Resolved [ 5 ] | Reopened [ 4 ] |
Attachment | FDU Medical payroll structure 111616.xlsx [ 36302 ] |
Assignee | Jennifer Leugers [ jennifer.leugers ] | Vinayak Kulkarni [ vinayak.kulkarni ] |
Status | Reopened [ 4 ] | In Progress [ 3 ] |
Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | Jennifer Leugers [ jennifer.leugers ] |
Resolution | Done [ 10000 ] | |
Status | In Progress [ 3 ] | Resolved [ 5 ] |
Time Spent | 12h [ 43200 ] | 16h [ 57600 ] |
Worklog Id | 16794 [ 16794 ] |
Attachment | FDU_Backend - Plan Class Tier Codes.xls [ 36419 ] | |
Attachment | Old and New Codes Comparison.xls [ 36420 ] |
-
- Time Spent:
- 2h
-
Discussion and explanation to Yogita.
Checking up new codes:
FDU Payroll - Codes verification - 30 min
Payroll codes code matrix explanation - 1 hr
Code matrix to Code ID 's converstion explanation and verification - 30 min
-
- Time Spent:
- 5.5h
-
Discussion with prashant.
Compared FDU new codes with old one.
Payroll code matrix generation according to new codes.
Verification.
Attachment | FDU - Codes ID'S Sheet_Effective_16.xls [ 36607 ] |
Time Spent | 16h [ 57600 ] | 18h [ 64800 ] |
Worklog Id | 17153 [ 17153 ] |
Time Spent | 18h [ 64800 ] | 21.5h [ 77400 ] |
Worklog Id | 17256 [ 17256 ] |
-
- Time Spent:
- 1.7h
-
FDU Payroll Code matix generation
Verfication of the complete codes created by Yogita and assigning the task to Rakesh S
-
- Time Spent:
- 3.5h
-
Discussion with prashant.
Code matrix to Code ID 's converstion.
Verification.
Time Spent | 21.5h [ 77400 ] | 27h [ 97200 ] |
Worklog Id | 17270 [ 17270 ] |
Time Spent | 27h [ 97200 ] | 30.5h [ 109800 ] |
Worklog Id | 17272 [ 17272 ] |
Time Spent | 30.5h [ 109800 ] | 32.2h [ 115920 ] |
Worklog Id | 17689 [ 17689 ] |
Resolution | Done [ 10000 ] | |
Status | Resolved [ 5 ] | Reopened [ 4 ] |
Attachment | screenshot-3.png [ 38304 ] |
Assignee | Jennifer Leugers [ jennifer.leugers ] | Rajendra Pawar [ rajendra.pawar ] |
Priority | Medium [ 3 ] | High [ 2 ] |
Status | Reopened [ 4 ] | In Progress [ 3 ] |
Time Spent | 32.2h [ 115920 ] | 34.2h [ 123120 ] |
Worklog Id | 21212 [ 21212 ] |
Assignee | Rajendra Pawar [ rajendra.pawar ] | Jennifer Leugers [ jennifer.leugers ] |
Resolution | Done [ 10000 ] | |
Status | In Progress [ 3 ] | Resolved [ 5 ] |
-
- Time Spent:
- 2h
-
Discussion and code changes analysis
Time Spent | 34.2h [ 123120 ] | 36.2h [ 130320 ] |
Worklog Id | 21422 [ 21422 ] |
Attachment | screenshot-4.png [ 39925 ] |
Resolution | Done [ 10000 ] | |
Status | Resolved [ 5 ] | Reopened [ 4 ] |
Assignee | Jennifer Leugers [ jennifer.leugers ] | Rajendra Pawar [ rajendra.pawar ] |
Assignee | Rajendra Pawar [ rajendra.pawar ] | Khandu Kshirsagar [ khandu.kshirsagar ] |
Status | Reopened [ 4 ] | In Progress [ 3 ] |
Time Spent | 36.2h [ 130320 ] | 38.2h [ 137520 ] |
Worklog Id | 26086 [ 26086 ] |
Attachment | WT-895_Company Migration Production To Stage.xls [ 40217 ] |
Assignee | Khandu Kshirsagar [ khandu.kshirsagar ] | Prasad Pise [ prasadp ] |
Time Spent | 38.2h [ 137520 ] | 40.2h [ 144720 ] |
Worklog Id | 26142 [ 26142 ] |
Time Spent | 40.2h [ 144720 ] | 41.7h [ 150120 ] |
Worklog Id | 26204 [ 26204 ] |
Assignee | Prasad Pise [ prasadp ] | Rajendra Pawar [ rajendra.pawar ] |
-
- Time Spent:
- 0.5h
-
Comparison of templates and modifications according to changes.
-
- Time Spent:
- 3h
-
File changes
Group Template creation
Testing
Assignee | Rajendra Pawar [ rajendra.pawar ] | Jennifer Leugers [ jennifer.leugers ] |
Resolution | Done [ 10000 ] | |
Status | In Progress [ 3 ] | Resolved [ 5 ] |
Time Spent | 41.7h [ 150120 ] | 42.2h [ 151920 ] |
Worklog Id | 27201 [ 27201 ] |
Time Spent | 42.2h [ 151920 ] | 45.2h [ 162720 ] |
Worklog Id | 27542 [ 27542 ] |
Time Spent | 45.2h [ 162720 ] | 46.7h [ 168120 ] |
Worklog Id | 28813 [ 28813 ] |
Time Spent | 46.7h [ 168120 ] | 48.2h [ 173520 ] |
Worklog Id | 29003 [ 29003 ] |
Environment_New | Stage [ 18443 ] |
Transition | Time In Source Status | Execution Times |
---|
|
3d 17h 32m | 1 |
|
13h 59m | 1 |
|
231d 11h 18m | 10 |
|
37d 17h 34m | 9 |
|
92d 2h 11m | 10 |
Hi Jennifer,
Vinayak Kulkarni,Rohan J Khandave
We have updated templates to solve below issue but codes are still pulling from PDHT mappings. We have not moved PDHT mapping to new positions. If we need to move benefit plan codes from PDHT mapping to somewhere else then we need Deduction codes list with all variations. It must contain all things that trigger code, like Plan Name, Class1, Healthtier, etc.
Please let us know below issue are solved? and provide details code list for PDHT mappings so we can move them.
Thanks ,
Ganesh