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

ACA imports - Negative hours not loading

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Support Task Type:
      Data Load
    • Reported by:
      Support
    • Company:
      JE Dunn
    • Module:
      ACA

      Description

      Hi,

      Do we have a fix for negative hours sent on an ACA hours import. This creates kickouts and these hours do not end up getting loaded.

      Please advise.
      Thanks!
      Cindy

        Attachments

          Activity

          Cindy.Wibbing Cindy Wibbing (Inactive) created issue -
          nwalker Nathaniel Cornejo-Walker (Inactive) made changes -
          Field Original Value New Value
          Attachment Bad_WT_HOURS-01-11-201701_19_2017 12_44_26 PM.zip [ 38239 ]
          Hide
          nwalker Nathaniel Cornejo-Walker (Inactive) added a comment -

          i have attached the error for the negative hours. i will email the password for the file.
          Vijay Siddha

          Show
          nwalker Nathaniel Cornejo-Walker (Inactive) added a comment - i have attached the error for the negative hours. i will email the password for the file. Vijay Siddha
          Hide
          Tkot Tracy Kot (Inactive) added a comment -
          Show
          Tkot Tracy Kot (Inactive) added a comment - CC Jennifer Leugers
          Hide
          jennifer.leugers Jennifer Leugers added a comment -

          Hi all - please also refer to CT-17. Assigning to Smita as they were on that ticket. Also tagging Nandkumar Prabhakar Karlekar.

          Show
          jennifer.leugers Jennifer Leugers added a comment - Hi all - please also refer to CT-17. Assigning to Smita as they were on that ticket. Also tagging Nandkumar Prabhakar Karlekar .
          jennifer.leugers Jennifer Leugers made changes -
          Assignee Vijay Siddha [ vijays ] Smita Pawar [ smita.pawar ]
          smita.pawar Smita Pawar (Inactive) logged work - 27/Jan/17 02:01 PM
          • Time Spent:
            1h
             

            Analysis

          smita.pawar Smita Pawar (Inactive) made changes -
          Remaining Estimate 5h [ 18000 ]
          Original Estimate 5h [ 18000 ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Remaining Estimate 5h [ 18000 ] 4h [ 14400 ]
          Time Spent 1h [ 3600 ]
          Worklog Id 21391 [ 21391 ]
          Hide
          smita.pawar Smita Pawar (Inactive) added a comment -

          Hi Jennifer,

          We are working on this ticket. We will update you on 30 Jan 2017 [EOD].

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - Hi Jennifer, We are working on this ticket. We will update you on 30 Jan 2017 [EOD] .
          Hide
          smita.pawar Smita Pawar (Inactive) added a comment -

          Hi Jennifer,

          Currently "William F Etheredge" employee is having '0' hrs as PTO hours.
          So workterra system can not minus PTO hrs from 0 PTO hrs.
          PFA screen shot for additional information.

          Second employee mentioned in the bad file is not existing in the JE Dunn.
          Hence workterra system will not accept -ve PTO hours for this employee also.

          Let us know if you need any additional information for same

          Thanks,
          Smita

          FYI Sachin Hingole,Nandkumar Prabhakar Karlekar

          Show
          smita.pawar Smita Pawar (Inactive) added a comment - Hi Jennifer, Currently "William F Etheredge" employee is having '0' hrs as PTO hours. So workterra system can not minus PTO hrs from 0 PTO hrs. PFA screen shot for additional information. Second employee mentioned in the bad file is not existing in the JE Dunn. Hence workterra system will not accept -ve PTO hours for this employee also. Let us know if you need any additional information for same Thanks, Smita FYI Sachin Hingole , Nandkumar Prabhakar Karlekar
          smita.pawar Smita Pawar (Inactive) made changes -
          Attachment William F Etheredge.png [ 38600 ]
          satyap Satya made changes -
          Module Parent values: BenAdmin(10100) Parent values: ACA(10104)
          satyap Satya made changes -
          Component/s ACA [ 10004 ]
          smita.pawar Smita Pawar (Inactive) logged work - 31/Jan/17 04:54 AM
          • Time Spent:
            2h
             
            <No comment>
          Hide
          smita.pawar Smita Pawar (Inactive) added a comment -
          Show
          smita.pawar Smita Pawar (Inactive) added a comment - CC: Cindy Wibbing
          smita.pawar Smita Pawar (Inactive) made changes -
          Assignee Smita Pawar [ smita.pawar ] Jennifer Leugers [ jennifer.leugers ]
          smita.pawar Smita Pawar (Inactive) made changes -
          Remaining Estimate 4h [ 14400 ] 2h [ 7200 ]
          Time Spent 1h [ 3600 ] 3h [ 10800 ]
          Worklog Id 21754 [ 21754 ]
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Open [ 1 ] Resolved [ 5 ]
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Transition Time In Source Status Execution Times
          Nandkumar Prabhakar Karlekar (Inactive) made transition -
          Open Resolved
          250d 16h 51m 1
          Nandkumar Prabhakar Karlekar (Inactive) made transition -
          Resolved Closed
          3m 52s 1

            People

            Assignee:
            jennifer.leugers Jennifer Leugers
            Reporter:
            Cindy.Wibbing Cindy Wibbing (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 5h
                5h
                Remaining:
                Time Spent - 3h Remaining Estimate - 2h
                2h
                Logged:
                Time Spent - 3h Remaining Estimate - 2h
                3h