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

City of Bellevue - PRE and regular RETRO report exporting different number of records

    Details

    • Type: Bug
    • Status: Rejected
    • Priority: High
    • Resolution: System Behaviour
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Production
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Module:
      BenAdmin - Export
    • Reported by:
      Client
    • Company:
      City of Bellevue
    • Item State:
      Development - In Analysis

      Description

      We have PRE and regular RETRO reports scheduled for City of Bellevue with 2 days gap in between the 2 reports. On the last run the PRE report exported 56 records and regular report exported 246 records. The setup of both the feeds is exactly same then why there is so much difference in the number of records?

      Template Names:
      Payroll_Retro_Report_Without_Life_2018
      Payroll_Retro_Report_PRE without Life

        Attachments

          Activity

          amitthorve Amit Thorve (Inactive) created issue -
          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Field Original Value New Value
          Assignee Vinayak Kulkarni [ vinayak.kulkarni ] Rajendra Pawar [ rajendra.pawar ]
          rajendra.pawar Rajendra Pawar (Inactive) made changes -
          Assignee Rajendra Pawar [ rajendra.pawar ] Rakesh Shahane [ rakesh.shahane ]
          rakesh.shahane Rakesh Shahane (Inactive) logged work - 08/Feb/18 10:19 AM
          • Time Spent:
            5h
             
            <No comment>
          rakesh.shahane Rakesh Shahane (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          rakesh.shahane Rakesh Shahane (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 08/Feb/18 01:39 PM
          • Time Spent:
            3h
             
            <No comment>
          Hide
          rakesh.shahane Rakesh Shahane (Inactive) added a comment -

          Hi Amit Thorve,

          We have checked both the templates and found that on the regular template i.e Payroll_Retro_Report_Without_Life_2018, Rundate has been set from EDI utility as 01/02/2018, Then that file got exported on 02/01/2018 by scheduler, Also Current year election flag is No, So because of this the record count has difference.

          Please let us know if you require more details on this.

          CC-Vinayak Kulkarni

          Show
          rakesh.shahane Rakesh Shahane (Inactive) added a comment - Hi Amit Thorve , We have checked both the templates and found that on the regular template i.e Payroll_Retro_Report_Without_Life_2018 , Rundate has been set from EDI utility as 01/02/2018, Then that file got exported on 02/01/2018 by scheduler, Also Current year election flag is No, So because of this the record count has difference. Please let us know if you require more details on this. CC- Vinayak Kulkarni
          rakesh.shahane Rakesh Shahane (Inactive) made changes -
          Assignee Rakesh Shahane [ rakesh.shahane ] Amit Thorve [ amitthorve ]
          rakesh.shahane Rakesh Shahane (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 5h [ 18000 ]
          Worklog Id 103998 [ 103998 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Time Spent 5h [ 18000 ] 8h [ 28800 ]
          Worklog Id 104220 [ 104220 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Resolution System Behaviour [ 10100 ]
          Status In Development [ 10007 ] Rejected [ 10004 ]
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) logged work - 15/Feb/18 10:54 AM
          • Time Spent:
            8h
             
            <No comment>
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) made changes -
          Time Spent 8h [ 28800 ] 16h [ 57600 ]
          Worklog Id 105773 [ 105773 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Original Estimate 0h [ 0 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Root Cause System Behavior [ 18446 ]
          Transition Time In Source Status Execution Times
          Rakesh Shahane (Inactive) made transition -
          Open In Development
          17h 26m 1
          Vinayak Kulkarni (Inactive) made transition -
          In Development Rejected
          4d 19h 47m 1

            People

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

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

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