WORKTERRAProject Type: software

WORKTERRA

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

City of Bellevue 2018 Payroll File

    Details

    • Type: Bug
    • Status: Rejected
    • Priority: Critical
    • Resolution: System Behaviour
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
    • Environment:
      Production
    • Bug Type:
      Functional
    • Bug Severity:
      Blocker
    • Module:
      BenAdmin - Export
    • Reported by:
      EDI
    • Company:
      City of Bellevue

      Description

      I created a OE file for City of Bellevue (COB_JDE_Payroll_2018) at global level. It is a FULL file and they dont want terms.

      When I ran this file twice, I am still getting terms on the file. Can you please check this ASAP? The file is due on 12/5 and I have to send them a test file ASAP.

      CC-Ganesh Sadawarte, Vinayak Kulkarni, Satya, Samir

        Attachments

        1. BackEndEffectiveDateForCOB.xls
          131 kB
        2. Stop Date MM.png
          Stop Date MM.png
          22 kB
        3. Stop Date YYYY.png
          Stop Date YYYY.png
          24 kB
        4. Template_Setting.png
          Template_Setting.png
          26 kB
        5. Template Customization.png
          Template Customization.png
          39 kB

          Activity

          Ascending order - Click to sort in descending order
          7 older comments
          Hide
          Permalink
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Hi Amit Thorve

          As discussed, we have updated leading values for monthly amount field as Space (' ') for all 2018 templates. Please check and let us know if error still persist. Thanks.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Amit Thorve As discussed, we have updated leading values for monthly amount field as Space (' ') for all 2018 templates. Please check and let us know if error still persist. Thanks.
          Hide
          Permalink
          amitthorve Amit Thorve (Inactive) added a comment -

          Vinayak Kulkarni, Ganesh Sadawarte, Rajendra Pawar

          Thanks for running the script. I am able to run the file now.

          I have few points which needs to be checked ASAP.

          1. The Start date came out as blank for 75% of the records. The start date column is mapped to “Pay period date for election effective date”.
          2. For around 22-25% records the start date is in 2016.
          3. For around 190 records the start date is in 2017.

          Show
          amitthorve Amit Thorve (Inactive) added a comment - Vinayak Kulkarni , Ganesh Sadawarte , Rajendra Pawar Thanks for running the script. I am able to run the file now. I have few points which needs to be checked ASAP. 1. The Start date came out as blank for 75% of the records. The start date column is mapped to “Pay period date for election effective date”. 2. For around 22-25% records the start date is in 2016. 3. For around 190 records the start date is in 2017.
          Hide
          Permalink
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Hi Amit,

          We have checked this, This field populates from back-end table in which there was no entry for year 2018. We have added entries for year 2018 now.
          Please check and let us know if you face any other issues with this file.

          Back-end table name: SBMPayrollDateMatrixForExport
          Attached BackEndEffectiveDateForCOB.xls file contains all entries, Entries which are highlighted yellow are added for year 2018. Please check.

          Thanks,
          Vinayak

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Hi Amit, We have checked this, This field populates from back-end table in which there was no entry for year 2018. We have added entries for year 2018 now. Please check and let us know if you face any other issues with this file. Back-end table name: SBMPayrollDateMatrixForExport Attached BackEndEffectiveDateForCOB.xls file contains all entries, Entries which are highlighted yellow are added for year 2018. Please check. Thanks, Vinayak
          Hide
          Permalink
          amitthorve Amit Thorve (Inactive) added a comment -

          Ganesh Sadawarte and Vinayak Kulkarni Thanks for updating this table.

          Can you please tell me why the 2016 effective dates and 2017 dates (other than 12/16/2017) with different values are rolling out on the file?

          Show
          amitthorve Amit Thorve (Inactive) added a comment - Ganesh Sadawarte and Vinayak Kulkarni Thanks for updating this table. Can you please tell me why the 2016 effective dates and 2017 dates (other than 12/16/2017) with different values are rolling out on the file?
          Hide
          Permalink
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment -

          Hi Amit Thorve,

          As discussed there were some enrollment effective for ex(12/01/2017, 11/01/2017) and rates also effective from same date with 12/31/2018 termination date. So as per SBM table date it populated on file.

          CC-Vinayak Kulkarni

          Thanks
          Ganesh

          Show
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) added a comment - Hi Amit Thorve , As discussed there were some enrollment effective for ex(12/01/2017, 11/01/2017) and rates also effective from same date with 12/31/2018 termination date. So as per SBM table date it populated on file. CC- Vinayak Kulkarni Thanks Ganesh

            People

            Assignee:
            amitthorve Amit Thorve (Inactive)
            Reporter:
            amitthorve Amit Thorve (Inactive)
            Account Executive:
            Debbie Kulling
            EDI Analyst 1:
            Amit Thorve (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 0h
                0h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 12.5h
                12.5h