WORKTERRAProject Type: software

WORKTERRA

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

CVHP- Would like to know how FT employees in Dec were calculated

    Details

    • Type: Support Activity
    • Status: Closed
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Support Task Type:
      ACA Data Audit
    • Reported by:
      Support
    • Company:
      CVHP
    • Module:
      BenAdmin

      Description

      Hi Team,

      CVHP would like to know how FT December employees were calculated. Can you send me that logic used to get to that number?

      Thanks,

      Kari

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          Hide
          Permalink
          sonali.punse Sonali Punse (Inactive) added a comment -

          Nandkumar Prabhakar Karlekar Can you please take this on priority, Client is expecting this by coming Friday. Thanks!

          Show
          sonali.punse Sonali Punse (Inactive) added a comment - Nandkumar Prabhakar Karlekar Can you please take this on priority, Client is expecting this by coming Friday. Thanks!
          Hide
          Permalink
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

          Hi Sonali Punse,

          As per the bandwidth this is not possible in this week if it is urgent then please take the Dave's approval.

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hi Sonali Punse , As per the bandwidth this is not possible in this week if it is urgent then please take the Dave's approval.
          Hide
          Permalink
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment -

          Hi Sachin Hingole,

          Can you able to provide this logic with data.

          Show
          nandkumar Nandkumar Prabhakar Karlekar (Inactive) added a comment - Hi Sachin Hingole , Can you able to provide this logic with data.
          Hide
          Permalink
          sonali.punse Sonali Punse (Inactive) added a comment -

          Kari mejia There is no bandwidth to work on this now. If this is really required on high priority can you please take Dave's approval. Thanks!

          Show
          sonali.punse Sonali Punse (Inactive) added a comment - Kari mejia There is no bandwidth to work on this now. If this is really required on high priority can you please take Dave's approval. Thanks!
          Hide
          Permalink
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          We have attached image for employee showing stable working hours.
          Below are calculations for full time employee. If stable working hours for employee are equal to or greater than 30 then employee is full time.

          1. Number of Days: Days in the range, refer image "LookBackAndTimeSheet.png"
          2. Total Hours worked: Sum of All loaded worked hours
          3. Number of weeks: Number of Days/7.0

          From Start date 11/22/2015 to 12/05/2015 has 14 days and the total hours are 80, refer image
          Daily Average = 80/14 = 5.7143

          The total Number of days in Dec =31

          So Number of week in the month = 31/7 =4.428

          Stable working Hours = (Daily Average * total Number of days)/ Number of week
          = (5.7143*31)/ 4.428 = 40.0005
          = 40.00

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - We have attached image for employee showing stable working hours. Below are calculations for full time employee. If stable working hours for employee are equal to or greater than 30 then employee is full time. 1. Number of Days: Days in the range, refer image "LookBackAndTimeSheet.png" 2. Total Hours worked : Sum of All loaded worked hours 3. Number of weeks: Number of Days/7.0 From Start date 11/22/2015 to 12/05/2015 has 14 days and the total hours are 80, refer image Daily Average = 80/14 = 5.7143 The total Number of days in Dec =31 So Number of week in the month = 31/7 =4.428 Stable working Hours = (Daily Average * total Number of days)/ Number of week = (5.7143*31)/ 4.428 = 40.0005 = 40.00

            People

            Assignee:
            karimejia@ebsbenefits.com Kari mejia (Inactive)
            Reporter:
            karimejia@ebsbenefits.com Kari mejia (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: