Please enable JavaScript.

Coggle requires JavaScript to display documents.

People Analytics, Open Req Report: ICIMS, Employee: Oracle Lawson Database…

- - - - Date Worked
      - FTE: Calculated Column
    - - Facility
      - Estimated Demand: Measure
      - Active Emp FTE: Calculated Column
      - Projected Terms FTE: Calculated Column
      - RR FTE: Calculated Column
      - Open Req FTE: Calculated Column
      - Prev FTE: Calculated Column
      - Resource ID
    - - Breakdown by Department: Matrix
        
        CC Short: Calculated Column
        
        Dept Name: Calculated Column
        
        Prev FTE: Calculated Column
        
        Projected Terms Q4: Calculated Column
        
        RR Q4 FTE: Calculated Column
        
        Active Emp FTE: Calculated Column
        
        Open Job Cat Dept: Calculated Column
        
        Terms Q4: Calculated Column
        
        RR Q1 FTE: Calculated Column
        
        RR Q2 FTE: Calculated Column
        
        RR Q3 FTE: Calculated Column
        
        Projected Terms Q1: Calculated Column
        
        Projected Terms Q2: Calculated Column
        
        Projected Terms Q3: Calculated Column
      - Projected Terms By Job Category: Bar Graph
        
        Job Category: Calculated Column
        
        Projected Terms Q4: Calculated Column
      - Talent Acquisition Pipeline last 30 Days: Funnel
        
        Interview: Calculated Column
        
        Ever in Status Hiring Manager Review ;
        Submitted for Hiring Manager Review
        
        Ever in Status Offer ; Written Offer Extended
        
        Ever in Bin New Submission
      - All Hires Time To Fill: Tile
        
        Time-To-Fill Since Creation (AVG)
      - New Hire Time To Fill: Tile
        
        Time-To-Fill Since Creation (AVG)
        Filter Requisition Status = New Hire
      - Fiscal Year To Date spent on Contract Labor: Tile
        
        Invoice Amount Due
  - - - Lawson Req ID
      - Lawson Position Title
      - FTE
      - Department Name
      - Hiring Manager
      - Recruiter
    - - Currently in Bin Candidate Withdrew
      - Currently in Bin Hired
      - Currently in Bin Hiring Manager Review
      - Currently in Bin Talent Acquisition Review
      - Currently in Bin Offer
      - Currently in Bin Incomplete
      - Currently in Bin New Submissions
    - - Job Category
      - Requisition ID
    - - Created Date
      - Lawson Req ID
    - - Lawson Req ID
      - FTE
      - Days Open: Calculated Column
    - - Facility
  - - - Facility
      - MGMT
      - MGMT(FTE)
      - Contract(FTE): Calculated Column
      - Non-MGMT Final: Measure
      - Non-MGMT Final(FTE): Measure
      - MGMT Final: Measure
      - MGMT Final(FTE): Measure
      - SoC: Measure
      - SoC(FTE): Measure
    - - Employee
      - FIRST_NAME
      - LAST_NAME
      - Job Title