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

CVHP > EEID 104741 > Waive Dollars Credit Not Appearing on Payroll File

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Support Task Type:
      Query Resolution
    • Environment:
      Production
    • Reported by:
      Client
    • Company:
      CVHP
    • Module:
      BenAdmin - Export
    • Severity:
      Simple

      Description

      Hi Vinayak Kulkarni,

      Client just informed us that EEID 104741 did not appear with deduction code WV-BNFT$ on any payroll file ran from template named _Payroll Export_2018.

      Can you please research why this occurred and if there are any other employees impacted?

      I checked files and indeed this person does not have a record for that deduction.

      The employee enrolled on 10/30/2017 effective 1/1/2018 in the "Waive Dollars" plan under Waive Dollars provided by CVHP benefit type.

      Thanks,
      Chris

        Attachments

        1. Credit_Pool_CVHP_1.PNG
          Credit_Pool_CVHP_1.PNG
          41 kB
        2. Credit_Pool_CVHP.PNG
          Credit_Pool_CVHP.PNG
          24 kB
        3. CVHP_missed_waive_Dollars_deduction.xls
          28 kB
        4. screenshot-1.png
          screenshot-1.png
          96 kB
        5. Waive_Dollars.png
          Waive_Dollars.png
          8 kB

          Activity

          Chris.ellenberger Chris Ellenberger created issue -
          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Field Original Value New Value
          Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Rakesh Shahane [ rakesh.shahane ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Assignee Rakesh Shahane [ rakesh.shahane ] Ganesh Sadawarte [ ganesh.sadawarte ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Attachment Waive_Dollars.png [ 71552 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 10/Jan/18 09:10 AM
          • Time Spent:
            3h
             
            <No comment>
          Hide
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

          Hi Chris Ellenberger,

          Please find below details.

          Concern: Client just informed us that EEID 104741 did not appear with deduction code WV-BNFT$ on any payroll file ran from template named _Payroll Export_2018.

          Cause: We have checked and found that 104741 employee Waive Dollars provided by CVHP benefit type enrollment employee cost zero and template has mapping of Enrollment Employee Cost and Enrollment Send Records Without Zero Cost. As employee cost zero the indicator would not write on file, due to this enrollment were not exported on file. Please find below snap.

          CC-Vinayak Kulkarni,Rajendra Pawar

          Thanks,
          Ganesh

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Hi Chris Ellenberger , Please find below details. Concern : Client just informed us that EEID 104741 did not appear with deduction code WV-BNFT$ on any payroll file ran from template named _Payroll Export_2018. Cause : We have checked and found that 104741 employee Waive Dollars provided by CVHP benefit type enrollment employee cost zero and template has mapping of Enrollment Employee Cost and Enrollment Send Records Without Zero Cost . As employee cost zero the indicator would not write on file, due to this enrollment were not exported on file. Please find below snap. CC- Vinayak Kulkarni , Rajendra Pawar Thanks, Ganesh
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 3h [ 10800 ]
          Worklog Id 99848 [ 99848 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Assignee Ganesh Sadawarte [ ganesh.sadawarte ] Chris Ellenberger [ chris.ellenberger ]
          Resolution Done [ 10000 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          Chris.ellenberger Chris Ellenberger made changes -
          Attachment screenshot-1.png [ 71583 ]
          Hide
          Chris.ellenberger Chris Ellenberger added a comment -

          Hi Ganesh Sadawarte,

          There is no cost on the benefit in WT, a value must be coming from the backend.

          I have an example of another employee EEID103146 is on the file with a value, but if you look at their employee screen the cost is zero.

          Thanks,
          Chris

          cc Vinayak Kulkarni Cindy Wibbing

          Show
          Chris.ellenberger Chris Ellenberger added a comment - Hi Ganesh Sadawarte , There is no cost on the benefit in WT, a value must be coming from the backend. I have an example of another employee EEID103146 is on the file with a value, but if you look at their employee screen the cost is zero. Thanks, Chris cc Vinayak Kulkarni Cindy Wibbing
          Chris.ellenberger Chris Ellenberger made changes -
          Resolution Done [ 10000 ]
          Status Resolved [ 5 ] Reopen [ 4 ]
          Chris.ellenberger Chris Ellenberger made changes -
          Assignee Chris Ellenberger [ chris.ellenberger ] Ganesh Sadawarte [ ganesh.sadawarte ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Assignee Ganesh Sadawarte [ ganesh.sadawarte ] Vinayak Kulkarni [ vinayak.kulkarni ]
          Status Reopen [ 4 ] In Progress [ 3 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Attachment Credit_Pool_CVHP.PNG [ 71586 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Attachment Credit_Pool_CVHP_1.PNG [ 71587 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Hi Chris Ellenberger

          Here are the details of issue.

          Amount for waive dollar is getting fetched from credit pool configured in system, which is 30$ bi-weekly. ( $65 monthly)

          As this credit pool has ended on 12/13/2017, there is no credit pool allocated for year 2018.

          For employee 104741, when we pulled file on 29th December, credit pool was ended on 07/31. due to which no cost found and it was eliminated from file.

          there are total 30 employees who have election on waive dollar but do not have credit pool allocated, find them CVHP_missed_waive_Dollars_deduction.xls here.

          Correction: We have to updated end date of credit pool to 12/31/2018 and recalculate credit pool.
          And then either we can run a full file or if we need change file then we have to force these missed employees on next change file. Let me know. Thanks.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Chris Ellenberger Here are the details of issue. Amount for waive dollar is getting fetched from credit pool configured in system, which is 30$ bi-weekly. ( $65 monthly) As this credit pool has ended on 12/13/2017, there is no credit pool allocated for year 2018. For employee 104741, when we pulled file on 29th December, credit pool was ended on 07/31. due to which no cost found and it was eliminated from file. there are total 30 employees who have election on waive dollar but do not have credit pool allocated, find them CVHP_missed_waive_Dollars_deduction.xls here. Correction: We have to updated end date of credit pool to 12/31/2018 and recalculate credit pool. And then either we can run a full file or if we need change file then we have to force these missed employees on next change file. Let me know. Thanks.
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Chris Ellenberger [ chris.ellenberger ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Status In Progress [ 3 ] Waiting for Customer Input [ 10500 ]
          Hide
          Chris.ellenberger Chris Ellenberger added a comment -

          Thanks lisa davison for extending the credit pool to 12/31/2018.

          Thank you Vinayak Kulkarni for taking this up and re-calc'ing the credit pool.

          Show
          Chris.ellenberger Chris Ellenberger added a comment - Thanks lisa davison for extending the credit pool to 12/31/2018. Thank you Vinayak Kulkarni for taking this up and re-calc'ing the credit pool.
          Chris.ellenberger Chris Ellenberger made changes -
          Status Waiting for Customer Input [ 10500 ] In Progress [ 3 ]
          Chris.ellenberger Chris Ellenberger made changes -
          Resolution Done [ 10000 ]
          Status In Progress [ 3 ] Resolved [ 5 ]
          Chris.ellenberger Chris Ellenberger made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Chris.ellenberger Chris Ellenberger made changes -
          Link This issue relates to EDI-2879 [ EDI-2879 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 11/Jan/18 08:41 AM
          • Time Spent:
            5h
             
            <No comment>
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Closed [ 6 ] Reopen [ 4 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Time Spent 3h [ 10800 ] 8h [ 28800 ]
          Worklog Id 102515 [ 102515 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Reopen [ 4 ] Resolved [ 5 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Hide
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Reopening to add work-log.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Reopening to add work-log.
          Transition Time In Source Status Execution Times
          Ganesh Sadawarte (Inactive) made transition -
          Open In Progress
          8h 15m 1
          Chris Ellenberger made transition -
          Resolved Reopen
          8h 18m 1
          Vinayak Kulkarni (Inactive) made transition -
          Reopen In Progress
          6m 52s 1
          Vinayak Kulkarni (Inactive) made transition -
          In Progress Waiting for Customer Input
          2h 15m 1
          Chris Ellenberger made transition -
          Waiting for Customer Input In Progress
          3h 6m 1
          Chris Ellenberger made transition -
          In Progress Resolved
          26s 2
          Vinayak Kulkarni (Inactive) made transition -
          Closed Reopen
          19d 9h 42m 1
          Vinayak Kulkarni (Inactive) made transition -
          Reopen Resolved
          33s 1
          Vinayak Kulkarni (Inactive) made transition -
          Resolved Closed
          11s 2

            People

            Assignee:
            Chris.ellenberger Chris Ellenberger
            Reporter:
            Chris.ellenberger Chris Ellenberger
            Account Executive:
            lisa davison
            EDI Analyst 1:
            Chris Ellenberger
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 8h
                8h