7 Subject Areas
Subject Areas
This section contains information about Transactional Business Intelligence subject areas, their associated job and duty roles, and the business questions that they provide answers to.
For your reference:
- Subject areas are the building blocks of your analytics and reports based upon them. Analytics are built by choosing an appropriate subject area that has information that answers the business question you’re analyzing. Technically, subject areas are a grouping of information pieces called data objects that relate to each other in a particular context.
- Job roles are associated with duty roles, and together control access to subject areas.
Overview
This section details subject area information for Human Capital Management data using Oracle Fusion HCM Analytics.
Download this ZIP file that contains available subject areas that apply to the current version of Oracle Fusion HCM Analytics. Once the file downloads, extract the file, open the folder, and then open the release-specific HTML file. For example, click 25R1_Fusion_HCM_Analytics_SubjectAreas.html.
These subject areas, with their corresponding data, are available for you to use when creating and editing analyses and reports. The information for each subject area includes:
-
Description of the subject area.
-
Business questions that can be answered by data in the subject area, with a link to more detailed information about each business question.
-
Job-specific groups and duty roles that can be used to secure access to the subject area, with a link to more detailed information about each job role and duty role.
-
Primary navigation to the work area that is represented by the subject area.
-
Time reporting considerations in using the subject area, such as whether the subject area reports historical data or only the current data. Historical reporting refers to reporting on historical transactional data in a subject area. With a few exceptions, all dimensional data are current as of the primary transaction dates or system date.
-
The lowest grain of transactional data in a subject area. The lowest transactional data grain determines how data are joined in a report.
-
Special considerations, tips, and things to look out for in using the subject area to create analyses and reports.
Note:
Job roles are the same as job-specific groups.Data Validation
Description
As a functional administrator, you can validate a library of metrics between your Oracle Fusion Data Intelligence instance and the Oracle Transactional Business Intelligence instance. The library of metrics is part of Oracle Fusion Data Intelligence. You can validate the data after loading the source data in to your data warehouse. You can schedule the validation of your data using the prebuilt validation sets or custom validation sets that you create. You can create a validation set and define the subject area, metrics, and columns that you want to validate and schedule the validation frequency and date. You see the validation sets that you create under Custom Validation Sets in the Scheduled Validation tab. Based on the schedule and the validation set, Oracle Fusion Data Intelligence validates the data and stores the details in the Data Validation workbook available in the Common folder in Oracle Analytics Cloud. Use the report tabs such as Validate data for ERP Analytics and Validate data for HCM Analytics available in this workbook to view the data validation details.
Business Questions
This subject area can answer the following business questions:
- Did my data get loaded into Oracle Autonomous Data Warehouse accurately?
- Can I schedule a regular data validation on a periodic basis?
- If there is a variance between my Oracle Transactional Business Intelligence source and Oracle Fusion Data Intelligence destination data, then how can I pinpoint which data is different?
- Are there built-in metrics for this data validation?
- Can I create my own (custom) metrics for specific data to validate?
Duty Roles
The System Administration duty role secures access to this subject area. See Common Duty Roles.
Primary Navigation
Data Validation tile under Application Administration on the Console
Folder: /Shared Folders/Common/Data Validation
Special Considerations
None.
Security Assignment
Description
Using the Security Assignment subject area, you can create reports about the current security assignments. These reports enable you to track the security contexts and the users who have access to the security contexts.
Business Questions
This subject area can answer the following business questions:
- What is the total number of security contexts?
- What is the number of users by security context?
- Which user is assigned to which security context and when was the assignment done?
Duty Roles
The Security Reporting Duty role secures access to this subject area. See Common Duty Roles.
Primary Navigation
Folder: /Shared Folders/Common/Security Assignment
Workbook: Security Audit
Special Considerations
None.
Security Audit History
This section is applicable for CX Subscription Management Analytics only.
Description
Using the data in the Security Audit History subject area, you can create reports to track assignment of users to groups, groups to roles, and security context members to users.
Business Questions
This subject area can answer the following business questions:
- When was a group created?
- When was a role created?
- When was a user assigned to or removed from a group?
- When was a user assigned to or removed from a role?
- When was a user assigned to or removed from a security context?
Duty Roles
The Security Reporting Duty role secures access to this subject area. See Common Duty Roles.
Primary Navigation
Folder: /Shared Folders/Common/Security Audit History
Workbook: Security Audit
Special Considerations
None.
Usage Tracking
Description
Usage Tracking is a powerful feature that has been available in Oracle Analytics Cloud. In Oracle Fusion Data Intelligence you can track usage to determine which user queries are creating performance bottlenecks, based on query frequency and response time. Administrators set up the criteria to track user queries and generate usage reports that you can use in a variety of ways such as reports optimization, user session strategies, or plan usage by users, and departments based on the resources that they consume. When reviewing the business metrics, it is important to keep the usability considerations in mind including trends, slice-and-dice, and drilldowns. Where applicable, benchmark information showcasing performance with the peer group is available. Companies typically set strategic quarterly goals in terms of key metrics; where applicable, the business metrics show progress towards such goals.
- While creating new custom content adhering to the recommended practices.
- When you want to provide additional data points for the prebuilt reports while reporting performance problems and want to add metrics such as row counts, compilation time, and response times.
Business Questions
This subject area can answer the following business questions:
- What are the average queries ran by the user by month?
- How many number of user sessions were created per month?
- How many distinct queries were run per month?
- How many distinct users used the system?
- How many distinct users used the system in a week?
- What are the average queries ran by the user in a week?
- How many logical queries ran by the top users?
- What are the top 10 logical and physical queries by execution time?
- Which dashboards and visualizations are the slowest performing?
Duty Roles
The Usage Tracking Analysis Duty role secures access to this subject area. See Common Duty Roles.
Primary Navigation
Folder: /Shared Folders/Common/Usage Tracking
Workbook: Usage Tracking
Special Considerations
None.
Warehouse Refresh Statistics
Description
The Warehouse Refresh Statistics subject area provides valuable information on pipeline activity and performance. You can use this subject area to create analytics on data refreshes, pipeline jobs, job failures, and details on rejected records. Together with data validation, this subject area helps reconcile data between the Oracle Fusion Cloud Applications source module and Oracle Fusion Data Intelligence, and improve data quality over time.
Business Questions
This subject area can answer the following business questions:
- When was the warehouse last refreshed, by each module?
- Which modules have high percentage of rejected records?
- What are the specific records that have been rejected for a certain module?
- What errors did the pipeline encounter, by specific jobs?
- Which jobs fail most frequently?
- What are the cascading effects, for example what other related records also fail due to a certain failure of a job?
Duty Roles
The Data Warehouse Refresh Analysis Duty role secures access to this subject area. See Common Duty Roles.
Primary Navigation
Folder: /Shared Folders/Common/Warehouse Refresh Statistics
Workbook: Warehouse Refresh Statistics
Special Considerations
None.
Business Questions
Overview
For each business question in this chapter, links are provided for more detailed information about the subject areas, job-specific groups, and duty roles associated with the business question.
Download this ZIP file that contains available business questions that apply to the current version of Oracle Fusion HCM Analytics. Once the file downloads, extract the file, open the folder, and then open the release-specific HTML file. For example, click 25R1_Fusion_HCM_Analytics_BusinessQuestions.html.
Note:
Job roles are the same as job-specific groups.Job-specific Groups
Overview
For each job-specific group in this chapter, links are provided for more detailed information about the duty roles, subject areas, and business questions associated with the job-specific group.
Note:
Job roles are the same as job-specific groups.Job-Specific Group Code | Job-Specific Group Name | Description | Associated Application Roles | Functional Area |
---|---|---|---|---|
ORA_CMP_COMPENSATION_MANAGER_JOB | Compensation Manager | Gets access to workforce compensation subject area. |
Workforce Compensation Analysis Duty Workforce Compensation Diversity Analysis Duty Compensation Worksheet Manager Data Security Workforce Compensation Diversity Analysis Duty Compensation Worksheet Manager Data Security |
HCM - Workforce Rewards- Workforce Compensation |
ORA_HXT_TIME_AND_LABOR_ADMINISTRATOR_JOB | Time And Labor Administrator | Gets Access to Time and Labor Subject Area | Time and Labor Analysis Duty | HCM - Workforce Time And Labor Management (Preview) |
ORA_PER_HUMAN_RESOURCE_ANALYST_JOB | Human Resource Analyst | Human Resource Analyst | Absence Management Analysis Duty | HCM - Workforce Absence Management |
Check Ins Analysis Duty | HCM - Check-Ins | |||
Goal Management Analysis Duty | HCM - Goals and Career Development | |||
Journeys Analysis Duty | HCM - Journeys | |||
Performance Management Analysis Duty | HCM - Performance Management | |||
Profile Management Analysis Duty | HCM - Talent Profile | |||
Salary Basis Analysis Duty | HCM - Workforce Rewards - Salary Basis (Preview) | |||
Succession Management Analysis Duty | HCM - Succession Management | |||
Talent Review Management Analysis Duty | HCM - Talent Review Meetings | |||
Time and Labor Management Analysis Duty | HCM - Workforce Time and Labor Management | |||
Workforce Core Analysis Duty | HCM - Workforce Core | |||
Workforce Gains and Losses Transaction Analysis Duty | HCM - Workforce Gains and Losses | |||
Position Analysis Duty | HCM - Positions | |||
Gets access to Opportunity Marketplace - Gigs Subject Area | Opportunity Marketplace Gig Analysis Duty | HCM - Opportunity Marketplace Gigs | ||
ORA_PER_HUMAN_RESOURCE_MANAGER_JOB | Human Resource Manager | Human Resource Manager | Absence Management Analysis Duty | HCM - Workforce Absence Management |
Check Ins Analysis Duty | HCM - Check-Ins | |||
Goal Management Analysis Duty | HCM - Goals and Career Development | |||
Journeys Analysis Duty | HCM - Journeys | |||
Performance Management Analysis Duty | HCM - Performance Management | |||
Profile Management Analysis Duty | HCM - Talent Profile | |||
Salary Basis Analysis Duty | HCM - Workforce Rewards - Salary Basis (Preview) | |||
Succession Management Analysis Duty | HCM - Succession Management | |||
Talent Review Management Analysis Duty | HCM - Talent Review Meetings | |||
Time and Labor Management Analysis Duty | HCM - Workforce Time and Labor Management | |||
Workforce Core Analysis Duty | HCM - Workforce Core | |||
Workforce Gains and Losses Transaction Analysis Duty | HCM - Workforce Gains and Losses | |||
Position Analysis Duty | HCM - Positions | |||
Gets access to Opportunity Marketplace - Gigs Subject Area | Opportunity Marketplace Gig Analysis Duty | HCM - Opportunity Marketplace Gigs | ||
ORA_IRC_RECRUITER_JOB | Recruiter | Recruiter | Recruitment Analysis Duty Role | HCM - Talent Acquisition |
ORA_IRC_RECRUITING_MANAGER_JOB | Recruiting Manager | Recruiting Manager | Recruitment Analysis Duty Role | HCM - Talent Acquisition |
ORA_IRC_HIRING_MANAGER_ABSTRACT | Hiring Manager | Hiring Manager | Recruitment Analysis Duty Role | HCM - Talent Acquisition |
ORA_HNS_ENVIRONMENT_HEALTH_AND_SAFETY_MANAGER_JOB | Environment, Health and Safety Manager | Environment, Health and Safety Manager | Worker Health and Safety Analysis Duty | HCM - Health and Safety Incidents |
ORA_PER_HUMAN_RESOURCE_SPECIALIST_JOB | Human Resource Specialist | Human Resource Specialist | Position Analysis Duty | HCM - Positions |
Gets access to Opportunity Marketplace - Gigs Subject Area | Opportunity Marketplace Gig Analysis Duty | HCM - Opportunity Marketplace Gigs | ||
ORA_PAY_PAYROLL_ADMINISTRATION_JOB | Payroll Administrator | Gets access to Payroll Management Subject Area | Payroll Analysis Duty | HCM - Workforce Rewards - Payroll Balances |
Payroll Costing Analysis Duty | HCM - Workforce Rewards - Payroll Costing | |||
ORA_SVC_HUMAN_RESOURCE_HELP_DESK_ADMINISTRATOR_NG_JOB | Next Gen Human Resource Help Desk Administrator | Next Gen Human Resource Help Desk Administrator | HR Help Desk Analysis Duty | HCM - HR Helpdesk Requests Overview (Preview) |
ORA_SVC_HUMAN_RESOURCE_HELP_DESK_ADMINISTRATOR_NG_JOB | Next Gen Human Resource Help Desk Administrator | Next Gen Human Resource Help Desk Administrator | HR Help Desk Analysis Duty | HCM - HR Helpdesk Requests Overview (Preview) |
Gets access to Payroll Management Subject Area | Payroll Analysis Duty | HCM - Workforce Rewards - Payroll Balances (Monthly) | ||
Gets access to Payroll Management Subject Area | Payroll Analysis Duty | HCM - Workforce Rewards - Payroll Balances (Monthly) | ||
ORA_PAY_PAYROLL_MANAGER_JOB | Payroll Manager | Gets access to Payroll Management Subject Area | Payroll Analysis Duty | HCM - Workforce Rewards - Payroll Balances |
Payroll Costing Analysis Duty | HCM - Workforce Rewards - Payroll Costing | |||
ORA_PER_LINE_MANAGER_ABSTRACT | Line Manager | Gets access to Opportunity Marketplace - Gigs Subject Area | Opportunity Marketplace Gig Analysis Duty | HCM - Opportunity Marketplace Gigs |
Common Job-Specific Groups
The common job-specific groups are applicable across the analytics applications that are part of Oracle Fusion Data Intelligence such as Oracle Fusion HCM Analytics and Oracle Fusion ERP Analytics.
Job-Specific Group Code | Job-Specific Group Name | Description | Associated Application Roles | Associated Application Role Names | Functional Area |
---|---|---|---|---|---|
ORA_FND_INTEGRATION_SPECIALIST_JOB | Integration Specialist | Individual responsible for planning, coordinating, and supervising all activities related to the integration of enterprise information systems. Has author privileges. |
Author OA4F_COMMON_DATA_ADMIN_ANALYSIS_DUTY |
Not applicable | Common |
Data Roles
Overview
For each data role in this section, links are provided for more detailed information about the job-specific groups, subject areas, and business questions associated with the data role.
Table 7-1 Data Roles
Data Role Name | Data Role Name | Description | Functional Area |
---|---|---|---|
OA4F_HCM_BUSINESS_UNIT_DATA | Oracle Fusion Analytics Warehouse HCM Business Unit Data Role | Human Capital Management data security policy for the business unit data security context. |
|
OA4F_HCM_COMPENSATION_WORKSHEET_MANAGER_DATA | Compensation Worksheet Manager Data Security | Compensation worksheet manager data security. | Workforce Compensation |
OA4F_HCM_COUNTRY_DATA | Oracle Fusion Analytics Warehouse HCM Country Data Security | Human Capital Management data security policy for the country data security context. |
|
OA4F_HCM_DEPARTMENT_DATA | Oracle Fusion Analytics Warehouse HCM Department Data Role | Human Capital Management data security policy for the department data security context. |
|
OA4F_HCM_HR_ANALYST_VIEW_ALL_DATA | Oracle Fusion Analytics Warehouse HR Analyst View All Data Role | Human Capital Management data security policy to view all data. | Workforce |
OA4F_HCM_HRHD_VIEW_ALL_DATA | HRHD Admin View All Data Role | HRHD Admin View All Data Role | HR Help Desk |
OA4F_HCM_LEGAL_EMPLOYER_DATA | Oracle Fusion Analytics Warehouse HCM Legal Employer Data Role | Human Capital Management data security policy for the legal employer data security context. |
|
OA4F_HCM_LINE_MANAGER_DATA | Oracle Fusion Analytics Warehouse HR Line Manager Data Role | Human Capital Management data security policy for the supervisor hierarchy. |
|
OA4F_HCM_OM_GIG_CREATOR_DATA | Opportunity Marketplace Gig Creator Data Security | Data security role to access Opportunity Marketplace Gig data by Gig Creator. | Talent |
OA4F_HCM_REC_ALL_APP_DATA | Recruitment Job Application View All Data Security | Recruitment data role to report on all job applications. | Talent |
OA4F_HCM_REC_ALL_REQ_DATA | Recruitment Job Requisition View All Data Security | Recruitment job requisition to view all data security. | Talent |
OA4F_HCM_REC_NON_RESTRICTED_APP_DATA | Recruitment Non Restricted Job Application Data Security | Recruitment data role to report on non restricted job applications. | Talent |
OA4F_HCM_REC_REQ_DATA | Recruitment Job Requisition Data Security | Recruitment job requisition data security. | Talent |
OA4F_HCM_VIEW_ALL_DATA | Oracle Fusion Analytics Warehouse View All Data Role | Human Capital Management data security policy to view
all data.
Grants all Talent Acquisition related data access. |
|
Duty Roles
Overview
This section provides subject area and content-related duty roles that you can use to secure access to the subject areas and specific content. For each duty role in this section, links are provided for detailed information about the job-specific groups, subject areas, and business questions associated with the duty role.
Table 7-2 HCM Duty Roles
Duty Role Code | Duty Role Name | Details | Functional Area | Gets access to Subject Area Display Name OR Associated Role |
---|---|---|---|---|
OA4F_HCM_ABSENCE_ANALYSIS_CONTENT_DUTY | Absence Management Analysis Content Duty | Controls presentation catalog access to Workforce Absence Management subject area based DV projects. | Absence Management | HCM - Workforce Absence Management |
OA4F_HCM_ABSENCE_ANALYSIS_DUTY | Absence Management Analysis Duty | Controls presentation catalog access to Workforce Absence Management subject area. | Absence Management | HCM - Workforce Absence Management |
OA4F_HCM_ABSENCE_DIV_ANALYSIS_DUTY | Absence Management Diversity Analysis Duty | Prevents access to Diversity related folders from Workforce Absence Management subject area. It can't be used in conjunction with Absence Management Analysis Duty. | Absence Management | HCM - Workforce Absence Management |
OA4F_HCM_CHECK_INS_ANALYSIS_CONTENT_DUTY | Checkins Management Analysis Content Duty | Controls presentation catalog access to Check-Ins subject area based DV projects. | Talent | HCM - Check-Ins |
OA4F_HCM_CHECK_INS_ANALYSIS_DIV_DUTY | Checkins Diversity Analysis Duty | Prevents access to Diversity related folders from Check-Ins subject area. It can't be used in conjunction with Checkins Analysis Duty. | Talent | HCM - Check-Ins |
OA4F_HCM_CHECK_INS_ANALYSIS_DUTY | Checkins Management Analysis Duty | Controls presentation catalog access to Check-Ins subject area. | Talent | HCM - Check-Ins |
OA4F_HCM_COMPENSATION_ANALYSIS_CONTENT_DUTY | Workforce Compensation Analysis Content Duty | Controls presentation catalog access to Compensation subject area based DV projects. | Workforce Compensation | HCM- Workforce Rewards- Workforce Compensation |
OA4F_HCM_COMPENSATION_ANALYSIS_DUTY | Workforce Compensation Analysis Duty | Controls presentation catalog access to Workforce Rewards - Workforce Compensation subject area. | Workforce Compensation | HCM- Workforce Rewards - Workforce Compensation |
OA4F_HCM_COMPENSATION_DIV_ANALYSIS_DUTY | Workforce Compensation Diversity Analysis Duty | Prevents access to Diversity related folders from Workforce Rewards - Workforce Compensation subject area. It can't be used in conjunction with Workforce Compensation Analysis Duty. | Workforce Compensation | HCM - Workforce Rewards - Workforce Compensation |
OA4F_HCM_DIVERSITY_ANALYSIS_DUTY | Diversity Analysis Duty | Controls presentation catalog access to HCM - Diversity Analysis (Preview) subject area. | Talent | HCM - Diversity Analysis (Preview) |
OA4F_HCM_EHS_ANALYSIS_DUTY | Worker Health and Safety Analysis Duty | Provides access to all objects of the HCM - Health and Safety Incidents subject area. | EHS | HCM - Health and Safety Incidents (Preview) |
OA4F_HCM_EHS_DIV_ANALYSIS_DUTY | Worker Health and Safety Diversity Analysis Duty | Provides access to all objects of the HCM - Health and Safety Incidents subject area except the folders related to diversity data. | EHS | HCM - Health and Safety Incidents (Preview) |
OA4F_HCM_GAINS_LOSS_TRANSACTION_DIV_ANALYSIS_DUTY | Workforce Gains and Losses Diversity Transaction Analysis Duty | Provides access to all objects of the HCM - Workforce Gains and Losses subject area except the folders related to diversity data. | Global HCM | HCM - Workforce Gains and Losses |
OA4F_HCM_GOALS_ANALYSIS_CONTENT_DUTY | Goal Management Analysis Content Duty | Controls presentation catalog access to Goals and Career Development subject area based DV projects. | Talent | HCM - Goals and Career Development |
OA4F_HCM_GOALS_ANALYSIS_DIV_DUTY | Goal Management Diversity Analysis Duty | Prevents access to Diversity related folders from Goals and Career Development subject area. It can't be used in conjunction with Goal Management Analysis Duty. | Talent | HCM - Goals and Career Development |
OA4F_HCM_GOALS_ANALYSIS_DUTY | Goal Management Analysis Duty | Controls presentation catalog access to Goals and Career Development subject area. | Talent | HCM - Goals and Career Development |
OA4F_HCM_HRHD_ANALYSIS_DUTY | HR Help Desk Analysis Duty | Controls presentation catalog access to HCM - HR Helpdesk Requests Overview subject area. | HR Help Desk | HCM - HR Helpdesk Requests Overview (Preview) |
OA4F_HCM_HRHD_DIV_ANALYSIS_DUTY | HR Help Desk Diversity Analysis Duty | Controls presentation catalog access to HCM - HR Helpdesk Requests Overview subject area without the diversity related information. | HR Help Desk | HCM - HR Helpdesk Requests Overview (Preview) |
OA4F_HCM_JOURNEYS_ANALYSIS_DUTY | Journeys Analysis Duty | Controls presentation catalog access to HCM-Journeys subject area. | Global HCM | HCM - Journeys |
OA4F_HCM_JOURNEYS_DIV_ANALYSIS_DUTY | Journeys Diversity Analysis Duty | Prevents access to Diversity related folders from HCM-Journeys subject area. It can't be used in conjunction with Journeys Analysis Duty. | Global HCM | HCM - Journeys |
OA4F_HCM_LEARNING_ANALYSIS_CONTENT_DUTY | Learning Analysis Content Duty | Controls presentation catalog access to Learning subject area based DV projects. | Talent | HCM - Learning (Preview) |
OA4F_HCM_LEARNING_ANALYSIS_DUTY | Learning Analysis Duty | Controls presentation catalog access to HCM - Learning (Preview) subject area. | Talent | HCM - Learning (Preview) |
OA4F_HCM_LEARNING_DIV_ANALYSIS_DUTY | Learning Diversity Analysis Duty | Prevents access to Diversity related folders from HCM - Learning (Preview) subject area. It can't be used in conjunction with Learning Analysis Duty. | Talent | HCM - Learning (Preview) |
OA4F_HCM_OM_GIG_ANALYSIS_DUTY | Opportunity Marketplace Gig Analysis Duty | Object security role to control presentation catalog access to Opportunity Marketplace Gigs subject area. | Talent | HCM - Opportunity Marketplace Gigs |
OA4F_HCM_PAYROLL_ANALYSIS_DUTY | Payroll Analysis Duty | Controls presentation catalog access to HCM - Workforce Rewards - Payroll Balances subject area. | Payroll | HCM - Workforce Rewards - Payrolll Balances (Monthly) |
OA4F_HCM_PAYROLL_COSTING_ANALYSIS_DUTY | Payroll Costing Analysis Duty | Controls presentation catalog access to HCM - Workforce Rewards - Payroll Costing subject area. | Payroll | HCM - Workforce Rewards - Payroll Costing |
OA4F_HCM_PERFORMANCE_ANALYSIS_CONTENT_DUTY | Performance Management Analysis Content Duty | Controls presentation catalog access to Performance Management subject area based DV projects. | Talent | HCM - Performance Management |
OA4F_HCM_PERFORMANCE_ANALYSIS_DIV_DUTY | Performance Management Diversity Analysis Duty | Prevents access to Diversity related folders from Performance Management subject area. It can't be used in conjunction with Performance Management Analysis Duty. | Talent | HCM - Performance Management |
OA4F_HCM_PERFORMANCE_ANALYSIS_DUTY | Performance Management Analysis Duty | Controls presentation catalog access to Performance Management subject area. | Talent | HCM - Performance Management |
OA4F_HCM_POSITION_ANALYSIS_DUTY | Position Analysis Duty | Provides access to all objects of the HCM - Positions subject area. | Global HCM | HCM - Positions |
OA4F_HCM_PROFILE_ANALYSIS_CONTENT_DUTY | Profile Management Analysis Content Duty | Controls presentation catalog access to Talent Profile subject area based DV projects. | Profile Management | HCM - Talent Profile |
OA4F_HCM_PROFILE_ANALYSIS_DUTY | Profile Management Analysis Duty | Controls presentation catalog access to Talent Profile subject area. | Profile Management | HCM - Talent Profile |
OA4F_HCM_PROFILE_DIV_ANALYSIS_DUTY | Profile Management Diversity Analysis Duty | Prevents access to Diversity related folders from Talent Profile subject area. It can't be used in conjunction with Profile Management Analysis Duty. | Profile Management | HCM - Talent Profile |
OA4F_HCM_PROFILE_MATCHING_ANALYSIS_DUTY | Profile Matching Analysis Duty | Controls presentation catalog access to HCM-Profile Matching (Preview) subject area. | Talent | HCM-Profile Matching (Preview) |
OA4F_HCM_PROFILE_MATCHING_DIV_ANALYSIS_DUTY | Profile Matching Diversity Analysis Duty | Prevents access to Diversity related folders from HCM-Profile Matching (Preview) subject area. It can't be used in conjunction with Profile Matching Analysis Duty. | Talent | HCM-Profile Matching (Preview) |
OA4F_HCM_REC_ANALYSIS_CONTENT_DUTY | Recruitment Analysis Content Duty | Controls presentation catalog access to Talent Acquisition subject area based DV projects. | Talent | HCM - Talent Acquisition |
OA4F_HCM_REC_ANALYSIS_DUTY | Recruitment Analysis Duty | Controls presentation catalog access to HCM - Talent Acquisition subject area. | Talent | HCM - Talent Acquisition |
OA4F_HCM_SALARY_BASIS_ANALYSIS_CONTENT_DUTY | Salary Basis Analysis Content Duty | Controls presentation catalog access to Workforce Rewards - Salary Basis subject area based DV projects. | Workforce Compensation | HCM - Workforce Rewards - Salary Basis |
OA4F_HCM_SALARY_BASIS_ANALYSIS_DUTY | Salary Basis Analysis Duty | Controls presentation catalog access to Workforce Rewards - Salary Basis subject area. | Workforce Compensation | HCM - Workforce Rewards - Salary Basis |
OA4F_HCM_SALARY_BASIS_DIV_ANALYSIS_DUTY | Salary Basis Diversity Analysis Duty | Prevents access to Diversity related folders from Workforce Rewards - Salary Basis subject area. It can't be used in conjunction with Salary Basis Analysis Duty. | Workforce Compensation | HCM - Workforce Rewards - Salary Basis |
OA4F_HCM_SUCCESSION_ANALYSIS_CONTENT_DUTY | Succession Management Analysis Content Duty | Controls presentation catalog access to Succession Management subject area based DV projects. | Talent | HCM - Succession Management |
OA4F_HCM_SUCCESSION_ANALYSIS_DUTY | Succession Management Analysis Duty | Controls presentation catalog access to HCM-Succession Management subject area. | Talent | HCM - Succession Management |
OA4F_HCM_SUCCESSION_DIV_ANALYSIS_DUTY | Succession Management Diversity Analysis Duty | Prevents access to Diversity related folders from HCM-Succession Management subject area. It can't be used in conjunction with Succession Management Analysis Duty. | Talent | HCM - Succession Management |
OA4F_HCM_TALENT_REVIEW_ANALYSIS_CONTENT_DUTY | Talent Review Management Analysis Content Duty | Controls presentation catalog access to Talent Review Meetings subject area based DV projects. | Talent | HCM - Succession Management |
OA4F_HCM_TALENT_REVIEW_ANALYSIS_DUTY | Talent Review Management Analysis Duty | Controls presentation catalog access to HCM - Talent Review Meetings subject area. | Talent | HCM - Talent Review Meetings |
OA4F_HCM_TALENT_REVIEW_DIV_ANALYSIS_DUTY | Talent Review Management Diversity Analysis Duty | Prevents access to Diversity related folders from HCM - Talent Review Meetings subject area. It can't be used in conjunction with Talent Review Management Analysis Duty. | Talent | HCM - Talent Review Meetings |
OA4F_HCM_TL_ANALYSIS_DUTY | Time And Labor Analysis Duty | Controls presentation catalog access to HCM - Workforce Time and Labor Management (Preview) Subject area. | Time And Labor | HCM - Workforce Time and Labor Management (Preview) |
OA4F_HCM_WORKER_SENIORITY_ANALYSIS_DUTY | Worker Seniority Analysis Duty | Controls presentation catalog access to HCM - Worker Seniority (Preview) subject area. | Global HCM | HCM - Worker Seniority (Preview) |
OA4F_HCM_WORKER_SENIORITY_DIV_ANALYSIS_DUTY | Worker Seniority Diversity Analysis Duty | Prevents access to Diversity related folders from HCM - Worker Seniority (Preview) subject area. It can't be used in conjunction with Worker Seniority Analysis Duty. | Global HCM | HCM - Worker Seniority (Preview) |
OA4F_HCM_WORKFORCE_CORE_ANALYSIS_CONTENT_DUTY | Workforce Core Analysis Content Duty | Controls presentation catalog access to workforce core subject area based DV projects . | Global HCM | HCM - Workforce Core |
OA4F_HCM_WORKFORCE_CORE_ANALYSIS_DUTY | Workforce Core Analysis Duty | Controls presentation catalog access to Workforce Core subject area. | Global HCM | HCM - Workforce Core |
OA4F_HCM_WORKFORCE_CORE_DIV_ANALYSIS_CONTENT_DUTY | Workforce Core Diversity Analysis Content Duty | Controls presentation catalog access to workforce core subject area based DV projects without the diversity related information. | Global HCM | HCM - Workforce Core |
OA4F_HCM_WORKFORCE_CORE_DIV_ANALYSIS_DUTY | Workforce Core Diversity Analysis Duty | Provides access to all objects of the workforce core subject area except the folders related to diversity data. | Global HCM | HCM - Workforce Core |
OAF_HCM_GAINS_LOSS_TRANSACTION_ANALYSIS_CONTENT_DUTY | Workforce Gains and Losses Transaction Analysis Content Duty | Controls presentation catalog access to Gains and Losses subject area based DV projects. | Global HCM | HCM - Workforce Gains and Losses |
OAF_HCM_GAINS_LOSS_TRANSACTION_ANALYSIS_DUTY | Workforce Gains and Losses Transaction Analysis Duty | Controls presentation catalog access to HCM - Workforce Gains and Losses subject area. | Global HCM | HCM - Workforce Gains and Losses |
OAF_HCM_GAINS_LOSS_TRANSACTION_DIV_ANALYSIS_CONTENT_DUTY | Workforce Gains and Losses Transaction Diversity Analysis Content Duty | Controls presentation catalog access to Gains and Losses subject area based DV projects without the diversity related information. | Global HCM | HCM - Workforce Gains and Losses |
Common Duty Roles
The common duty roles are applicable across the analytics applications that are part of the application such as Oracle Fusion CX Analytics, Oracle Fusion HCM Analytics, and Oracle Fusion ERP Analytics.
Duty Role Code | Duty Role Name | Details | Functional Area | Gets access to Subject Area Display Name OR Associated Role |
---|---|---|---|---|
OA4F_COMMON_DATA_ADMIN_ANALYSIS_DUTY | Data Warehouse Refresh and Usage Tracking Analysis Duty | Object security role to control access to Common - Warehouse Refresh Statistics subject area. | Common | Common - Warehouse Refresh Statistics |
OA4F_COMMON_DATA_ADMIN_ANALYSIS_CONTENT_DUTY | Data Warehouse Refresh and Usage Tracking Analysis Content Duty | Object security role to control access to Warehouse Refresh Statistics and Data Validation workbooks. | Common | |
OA4F_COMMON_USAGE_TRACKING_DUTY | Usage Tracking Analysis Duty | Object security role to control presentation catalog access to Common - Usage Tracking subject area. | Common | Common - Usage Tracking |
OA4F_COMMON_USAGE_TRACKING_CONTENT_DUTY | Usage Tracking Analysis Content Duty | Object security role to control presentation catalog access to Usage Tracking workbook |
Common |
|
OA4F_SECURITY_REPORTING_DUTY | Security Reporting Duty | Object security role to control access to Security Assignment and Security Audit History subject areas. | Common |
Security Assignment Security Audit History |
OA4F_SECURITY_REPORTING_CONTENT_DUTY | Security Reporting Analysis Content Duty | Object security role to control presentation catalog access to Security Audit workbook | ||
OA4F_STORAGE_USAGE_TRACKING_ANALYSIS_DUTY | Storage Usage Tracking Analysis Duty | Object security role to control access to the Tenant Metrics subject area | Common | |
OA4F_STORAGE_USAGE_TRACKING_ANALYSIS_CONTENT_DUTY | Storage Usage Tracking Analysis Content Duty | Object security role to control presentation catalog access to Custom Data Usage workbook | Common | |
OA4F_CONTENT_EXPLORER_ANALYSIS_DUTY | Content Explorer Analysis Duty | Object security role to control access to the Content Explorer subject areas |
Common |
|
OA4F_CONTENT_EXPLORER_ANALYSIS_CONTENT_DUTY | Content Explorer Content Duty | Object security role to control presentation catalog access to the Content Explorer - Fusion Data Intelligence workbook | Common |
Subject Area Metrics Details
Overview
Metric details provide a brief description about metrics in a user-friendly way and contains formula wherever needed.
HCM—Check-Ins
This tables describes Check-Ins metrics.
Metric | Metric Definition |
---|---|
Total Check-Ins | Total Number of Check-Ins created. |
Workers with Check-ins | Number of workers that have one or more Check-In. |
Managers with Check-ins | Number of managers that have at least one Check-In. |
Count of Check-Ins with Performance Goals | Count of Check-Ins that have at least one performance goal topic added. |
Percentage of Check-ins with Performance Goals | Percentage of Check-Ins that have the topic type of performance goals. |
Count of Check-Ins with Development Goals | Count of Check-Ins that have at least one development goal topic added. |
Percentage of Check-ins with Development Goals | Percentage of Check-Ins that have the topic type of development goals. |
Count of Check-Ins with General Topic | Count of Check-Ins that have at least one general topic added. |
Percentage of Check-ins with General Topics | Percentage of Check-Ins that have the general topic type. |
Terminated Workers with Check-ins | Number of workers that are terminated during the time period that have had Check-Ins. |
HCM—Diversity Analysis (Preview)
This tables describes Check-Ins metrics.
Metric | Metric Definition |
---|---|
Hire Count | Count of all workers hired during the year |
Applicant Count | Count of job applicants during the year |
Not Hired Count | Provides the count of applicants that were not hired during the year |
Promotion Headcount | Sum of headcount of all workers with promotions during the year |
Promotion FTE | Sum of fte of all workers with promotions during the year |
Primary Assignment Promotion Count | Sum of primary assignment count of all workers with promotions during the year |
Period Start Headcount | Sum of headcount of all workers at the year start |
Period Start FTE | Sum of fte of all workers at the year start |
Period Start Primary Assignment Count | Sum of primary assignment count of all workers at the year start |
Termination Headcount | Sum of headcount of all workers terminated during the year |
Termination FTE | Sum of fte of all workers terminated during the year |
Primary Assignment Termination Count | Sum of primary assignment count of all workers terminated during the year |
Period Start Headcount | Sum of headcount of all workers at the year start |
Period Start FTE | Sum of fte of all workers at the year start |
Period Start Primary Assignment Count | Sum of primary assignment count of all workers at the year start |
Voluntary Termination Headcount | Sum of headcount of all workers terminated voluntarily during the year |
Voluntary Termination FTE | Sum of fte of all workers terminated voluntarily during the year |
Primary Assignment Voluntary Termination Count | Sum of primary assignment count of all workers terminated voluntarily during the year |
Involuntary Termination Headcount | Sum of headcount of all workers terminated involuntarily during the year |
Involuntary Termination FTE | Sum of fte of all workers terminated involuntarily during the year |
Primary Assignment Involuntary Termination Count | Sum of primary assignment count of all workers terminated involuntarily during the year |
Period End Headcount | Sum of headcount of all workers with salary during the year end |
Period End FTE | Sum of fte of all workers with salary during the year end |
Period End Primary Assignment Count | Sum of primary assignment count of all workers with salary during the year end |
Headcount with Global Annual Salary above Median | Sum of headcount of all workers with Global Annual Salary above Median during the year |
Headcount with Global Annual Salary below Median | Sum of headcount of all workers with Global Annual Salary below Median during the year |
FTE with Global Annual Salary above Median | Sum of fte of all workers with Global Annual Salary above Median during the year |
FTE with Global Annual Salary below Median | Sum of fte of all workers with Global Annual Salary below Median during the year |
Primary Assignment Count with Global Annual Salary above Median | Sum of primary assignment count of all workers in the age with Global Annual Salary above Median of the Employees in the Legislative_Job_Category_Code at the end of the year |
Primary Assignment Count with Global Annual Salary below Median | Sum of primary assignment count of all workers in the age with Global Annual Salary below Median of the Employees in the Legislative_Job_Category_Code at the end of the year |
HCM—Goals and Career Development
This tables describes Goals and Career Development metrics.
Metric | Metric Definition |
---|---|
Number of Performance Goals | Number of performance goals. |
Workers with Performance Goals | Distinct count of workers with performance goals. |
Workers with Goals Completed | Distinct count of workers that have all their goals in completed status. |
Percentage of Workers with Complete Goals | Percentage of workers that have all their performance goals in completed status. |
Workers with Incomplete Goals | Distinct count of employees that have at least one incomplete performance goal. |
Percentage of Workers with Incomplete Goals | Percentage of employees that have at least one incomplete performance goal. |
Managers with Incomplete Goals | Distinct count of line managers that have not completed the performance goals. |
Workers with Incomplete Goals Beyond Target Completion Date | Distinct count of workers that have not completed the performance goals beyond the target completion date. |
Workers with Goals Not Started Beyond Target Completion Date | Distinct count of workers that have not started the performance goals beyond the target completion date. |
Number of Development Goals | Total number of Development Goals. |
Number of Development Goals In Progress | Number of Development Goals created but yet to complete. |
Number of Development Goals Completed | Number of Development Goals completed. |
Workers with Development Goals | Count of workers that have created development goals. |
Workers with Incomplete Development Goals | Distinct count of workers that have at least one of their development goals incomplete. |
Workers with Complete Development Goals | Distinct count of workers that have at least one of their development goals in completed status. |
Workers with Incomplete Development Goals after Target Date | Count of workers that have not completed their development goals beyond the target completion date. |
Percentage of Workers with Incomplete Development Goals after Target Date | Percentage of workers that have not completed their development goals beyond the target completion date. |
Workers with Complete Development Goals after Target Date | Count of workers that have completed their development goals beyond the target completion date. |
Number of Unique Goal Plans Assigned | Provides the count of unique goal plans assigned to the workers |
Number of Goal Plans Assigned | Provides the count of goal plans assigned to the workers |
Goal Plan Assignments without Goals | Provides the count of goal plans assigned without goals |
Goal Plan Assignments with Goals | Provides the unique count of goal plans assigned with goals. |
Number of Goal Plans Approved | Provides the count of assigned goal plans approved, excluding goal plan approvals initiated through Auto Approval or Bypass Approval. |
Number of Goal Plans Pending Approval | Provides the count of assigned goal plans submitted for approval, excluding goal plan approvals initiated through Auto Approval or Bypass Approval. |
Number of Goal Plans Rejected | Provides the count of assigned goal plans rejected by the approver, excluding goal plan approvals initiated through Auto Approval or Bypass Approval. |
Number of Goal Plans in Draft | Provides the count of assigned goal plans which contains goals yet to be submitted for approval, excluding goal plan approvals initiated through Auto Approval or Bypass Approval. |
Count of Aligned Goals | Count of goals aligned with other goals |
Count of Aligned Workers | Count of workers whose goals are aligned with other goals |
Count of Aligned Assignments | Count of workers whose assignments are aligned with other goals |
Count of Completed Aligned Goals | Count of completed goals that are aligned to another goal |
Workers with Performance Goals Aligned to Organization Goals | Distinct Count of workers that have their performance goals aligned to an organization goal. |
Workers Goal Aligned to Managers Goals | Distinct Count of workers that have their performance goals aligned to line manager goals. |
HCM—Health and Safety Incidents (Preview)
This tables describes Health and Safety Incident metrics.
Metric | Metric Definition |
---|---|
Number of Incidents | Number of Safety Incidents |
Number of Open Incidents | Number of Open Safety Incidents |
Number of Closed Incidents | Number of Closed Safety Incidents |
Number of Due Incidents | Number of Safety Incidents Due |
Number of Overdue Incidents | Number of Overdue Safety Incidents |
MTD Incidents | Month to Date Incidents |
QTD Incidents | Quarter to Date Incidents |
YTD Incidents | Year to Date Incidents |
Incident - Time to Close(days) | Time taken to close an incident |
Incident - Time Since Open(days) | Time since the incident is open |
Number of Incident Events | Number of Safety Incident Events |
Number of Open Incident Events | Number of Open Safety Incident Events |
Number of Closed Incident Events | Number of Closed Safety Incident Events |
Number of Due Incident Events | Number of Safety Incident Events Due |
Number of Overdue Incident Events | Number of Overdue Safety Incident Events |
MTD Incident Events | Month to Date Incident Events |
QTD Incident Events | Quarter to Date Incident Events |
YTD Incident Events | Year to Date Incident Events |
Incident Event - Time to Close(days) | Time taken to close an incident event |
Incident Event - Time Since Open(days) | Time since the incident event is open |
Number of Incident Actions | Number of Incident Actions |
Number of Open Incident Actions | Number of Open Incident Actions |
Number of Closed Incident Actions | Number of Closed Incident Actions |
MTD Incident Actions | Month to Date Incident Actions |
QTD Incident Actions | Quarter to Date Incident Actions |
YTD Incident Actions | Year to Date Incident Actions |
Incident Action - Time Since Open(days) | Time since the incident action is open |
Number of Incident Investigations | Number of Incident Investigations |
Number of Open Incident Investigations | Number of Open Incident Investigations |
Number of Closed Incident Investigations | Number of Closed Incident Investigations |
Number of Due Incident Investigations | Number of Incident Investigations Due |
Number of Overdue Incident Investigations | Number of Overdue Incident Investigations |
MTD Incident Investigations | Month to Date Incident Investigations |
QTD Incident Investigations | Quarter to Date Incident Investigations |
YTD Incident Investigations | Year to Date Incident Investigations |
Number of Low Incident Investigations | Number of Low Incident Investigations |
Number of Medium Incident Investigations | Number of Medium Incident Investigations |
Number of High Incident Investigations | Number of High Incident Investigations |
Incident Investigation - Time to Close(days) | Time taken to close an incident investigation |
Incident Investigation - Time Since Open(days) | Time since the incident investigation is open |
Number of Workers Absent | Number of Workers that have an absence record |
Number of Absent Days | Number of Absence Days |
Days Away from Work | Number of Absence Days |
Number of Absences | Number of distinct absences of a worker |
HCM—HR Helpdesk Requests Overview (Preview)
This tables describes HR Helpdesk Requests metrics.
Metric | Metric Definition |
---|---|
Number of Requests | Number of Help Desk Requests created. Includes active and closed requests, excludes deleted requests. |
Number of Deleted Requests | Number of Help Desk Requests that are deleted |
Number of Active Requests | Number of Help Desk Requests that are not closed |
Number of New Requests | Number of Help Desk Requests in New Status |
Number of In-Progress Requests | Number of Help Desk Requests that are In-Progress Status |
Number of Resolved Requests | Number of Help Desk Requests in Resolved status |
Number of Unresolved Requests | Number of Help Desk Requests not in Resolved or Closed status |
Number of Waiting Requests | Number of Help Desk Requests where status is Waiting |
Number of Re-Opened Requests | Number of Help Desk Requests Which are re-opened at least once |
Percentage of Re-Opened Requests | Percentage of Help Desk Requests Which are re-opened at least once |
Number of Unassigned Requests | Number of Help Desk Requests Which are not assigned to any agent |
Number of Critical Requests | Number of Help Desk Requests which are flagged as critical |
Percentage of Critical Requests | Percenatge of Help Desk Requests which are flagged as critical |
Number of Requests without Milestones | Number of Help Desk Requests with no milestone |
Number of Requests Resolved within 6 Hours | Number of Help Desk Requests that got resolved within 6 hours of first assigning to the resource |
Number of Requests Resolved within 12 Hours | Number of Help Desk Requests that got resolved within 12 hours of first assigning to the resource |
Number of Requests Resolved within 24 Hours | Number of Help Desk Requests that got resolved within 24 hours of first assigning to the resource |
Number of Requests - Processed by multiple Agents | Number of Requests that have been with more than one agent at various point in time |
Number of Compliant Requests - Active | Number of Help Desk Requests which are compliant |
Percentage of Compliant Requests - Active | Percentage of Help Desk Requests which are compliant |
Number of Non-Compliant Requests - Active | Number of Help Desk Requests which are not compliant |
Percentage of Non-Compliant Requests - Active | Percentage of Help Desk Requests which are not compliant |
Number of Requests with Milestones | Number of Help Desk Requests with milestones |
Number of Compliant Requests - Closed | Number of Help Desk Requests that were compliant and closed |
Percentage of Compliant Requests -Closed | Percentage of Help Desk Requests that were compliant |
Number of Non-Compliant Requests - Closed | Number of Help Desk Requests that were not compliant |
Percentage of Non-Compliant Requests - Closed | Percentage of Help Desk Requests that were not compliant |
Effectivity Rate of Closed Requests | Percentage of closed compliant requests measured against the total requests |
Average Time to Assign to Resource(Minutes) | Average Time to Assign the HR Help Desk Request to a Resource in minutes |
Average Time to Assign to Resource(Hours) | Average Time to Assign the HR Help Desk Request to a Resource in hours |
Average Time to Assign to Resource(Days) | Average Time to Assign the HR Help Desk Request to a Resource in days |
Average Time to Resolve(Minutes) | Average Time to resolve the request in minutes |
Average Time to Resolve(Hours) | Average Time to resolve the request in hours |
Average Time to Resolve(Days) | Average Time to resolve the request in days |
Average Time to Close(Minutes) | Average Time to close the request in minutes |
Average Time to Close(Hours) | Average Time to close the request in hours |
Average Time to Close(Days) | Average Time to close the request in days |
Unassigned Requests - Open Since (Hours) | Average time since the active request is opened and is not assigned to an agent |
Number of Closed Requests | Number of Help Desk Requests that are Closed |
Percentage of Closed Requests | Percentage of Help Desk Requests where status is Closed |
Number of Re-Opened Requests - Closed | Number of Help Desk Requests Which are re-opened at least once and are closed currently |
Percentage of Re-Opened Requests - Closed | Percentage of Help Desk Requests Which are re-opened at least once and are closed currently |
Number of Critical Requests - Closed | Number of Help Desk Requests which are flagged as critical and are closed currently |
Number of Requests - Processed by multiple Agents - Closed | Number of Requests that have been with more than one agent at various point in time and currently closed. |
Number of Requests with Linked Articles | Number of Help Desk Requests with one or more Linked Articles |
Percentage of Requests with Linked Articles | Percentage of Help Desk Requests with one or more Linked Articles |
Number of Requests with Linked Articles - Resolved | Number of Help Desk Requests with one or more Linked Articles and is resolved |
Percentage of Requests with Linked Articles - Resolved | Percentage of Help Desk Requests with one or more Linked Articles and is resolved |
Number of Requests with Linked Articles - Reopened | Number of Help Desk Requests with one or more Linked Articles and re-opened at least once |
Percentage of Requests with Linked Articles - Reopened | Percentage of Help Desk Requests with one or more Linked Articles and re-opened at least once |
Number of Requests - Employee Abandoned | Number of Help Desk Requests that are Abandoned by Employees |
Percentage of Requests - Employee Abandoned | Percentage of Help Desk Requests that are Abandoned by Employees |
Number of Requests - Issue Resolved | Number of Help Desk Requests where Outcome = Issue Resolved |
Percentage of Requests - Issue Resolved | Percentage of Help Desk Requests where Outcome = Issue Resolved |
Number of Requests - Question Answered | Number of Help Desk Requests where Outcome = Question Answered |
Percentage of Requests - Question Answered | Percentage of Help Desk Requests where Outcome = Question Answered |
Number of Requests - Unable to Solve | Number of Help Desk Requests where Outcome = Unable to Solve |
Percentage of Requests - Unable to Solve | Percentage of Help Desk Requests where Outcome = Unable to Solve |
Number of Assignees | Number of distinct agents to which the request was assigned |
Average Number of Assignee Transfers | Average Number of times the request has been transferred to various agents |
Number of Deleted Requests (Lifecycle) | Number of deleted requests with lifecycle changes |
Number of Requests (Lifecycle) | Number of Requests with Lifecycle changes |
Requests - Reopen Since (Hours) | Average time since the active request is re-opened. |
HCM—Journeys
This tables describes Journeys metrics.
Metric | Metric Definition |
---|---|
Number of Workers with Journeys | Number of workers with allocated journeys. |
Number of Workers with Journeys - Active | Number of workers with allocated journeys that are active currently. |
Number of Workers with Incomplete Journeys - Overdue | Number of workers with allocated journeys that are incomplete and overdue currently. |
Number of Workers with Incomplete Journeys - Not Overdue | Number of workers with allocated journeys that are incomplete but not overdue currently. |
Number of Journeys | Number of distinct allocated journeys . |
Number of Journeys - Completed | Total number of allocated journeys that are completed. |
Number of Journeys - Overdue | Total number of allocated journeys that are overdue. |
Time to Complete the Journey (Days) | Number of days to complete a journey. |
Number of Tasks | Total number of tasks in the allocated journey. |
Number of Mandatory Tasks | Total number of mandatory tasks in allocated journey. |
Number of Completed Tasks | Total number of tasks completed in allocated journey. |
Number of Mandatory Tasks Completed | Total number of mandatory tasks completed in allocated journey. |
Days to Complete the Task - Planned | Estimated number of days to complete the task. |
Days to Complete the Task - Actual | Actual number of days to complete the task. |
Tasks - Not AppLicable | Tasks that are marked as not applicable . |
Overdue Tasks | Active tasks where the target end date is in the past. |
Number of Tasks Completed Beyond Due Date | Total number of tasks completed in allocated journey after the target completion date. |
HCM—Learning (Preview)
This tables describes Journeys metrics.
Metric | Metric Definition |
---|---|
Number of Enrollments Requested | Provides the count of enrollments that are in requested status |
Number of Enrollments Request Rejected | Provides the count of enrollments requests that are in rejected status |
Number of Enrollments Pending Fulfilment | Provides the count of enrollments that are in pending fulfillment status |
Number of Enrollments Pending Prerequisite | Provides the count of enrollments that are pending due to missing pre-requisite by the learner |
Number of Non-Catalog Items Enrollment | Provides the count of enrollments by learners to non-catalog items |
Number of Learners Enrolled to non-catalog items | Provides the count of Learners enrolled to non-catalog items |
Number of Learners - Active | Provides the count of all learners |
Number of Enrollments - Active | Provides the count of enrollments across all learning items by workers |
Number of Course Enrollments - Active | Provides the count of courses enrolled by the learner |
Number of Specialization Enrollments - Active | Provides the count of specializations enrolled by the learner |
Number of e-learning Enrollments - Active | Provides the count of e-learnings enrolled by the learner |
Average Learning Items per learner - Active | Provides the average number of learning item enrolled by all learners |
Number of Voluntary Enrollments - Active | Provides the count of voluntary learning enrollments |
Number of Required Enrollments - Active | Provides the count of required learning enrollments |
Number of Overdue Enrollments | Provides the count of learning enrollments that are past the due date |
Number of Not Started Enrollments | Provides the count of learning enrollments that have been assigned but not started |
Number of In-Progress Enrollments | Provides the count of learning enrollments that are started but not yet completed |
Number of Renewed Learning Assignments - Active | Provides the count of enrollments that are renewed |
Number of Learners - Post Active | Provides the count of all learners |
Number of Enrollments - Post Active | Provides the count of enrollments across all learning items by workers |
Number of Courses Enrollment - Post Active | Provides the count of courses enrolled by the learner |
Number of Specializations Enrollment - Post Active | Provides the count of specializations enrolled by the learner |
Number of e-learning Enrollment - Post Active | Provides the count of e-learnings enrolled by the learner |
Number of Non-Catalog Items Enrollment - Post Active | Provides the count of enrollments by learners to non-catalog items |
Number of Learners enrolled to non-catalog items - Post Active | Provides the count of Learners enrolled to non-catalog items |
Average Learning Items per learner Enrollment - Post Active | Provides the average number of learning item enrolled by all learners |
Number of Voluntary Enrollments - Post Active | Provides the count of voluntary learning enrollments |
Number of Required enrollments Enrollment - Post Active | Provides the count of required learning enrollments |
Number of Completed Enrollments | Provides the count of learning enrollments that are completed |
Number of Withdrawn Enrollments | Provides the count of learning enrollments that are withdrawn by the learner |
Voluntary Learning Completion count | Provides the count of voluntary learning enrollments that are completed |
Voluntary Learning Enrollments Completion Rate | Provides the percentage of completed voluntary enrollments against the total voluntary enrollments |
Required Learning Completion count | Provides the count of required learning enrollments that are completed |
Required Learning Enrollments Completion Rate | Provides the percentage of completed required assignments against the total required enrollments |
Content Completion Count | Provides the count of enrollments that have completed the learning content but the learning status is not yet completed |
Number of Workers with New Competency | Provides the count of Workers who added new competencies to their profile |
Number of Workers with Improved Competency Ratings | Provides the count of Workers whose competency ratings Improved after completing the learning assignment |
Number of Workers with New language | Provides the count of Workers who added new languages to their profile after completing the learning assignment |
Number of Workers with new license and certification | Provides the count of Workers who added additional license and certification to their talent profile after completing the learning assignment |
Number of Workers with new honors and awards | Provides the count of Workers who added additional honors and awards to their talent profile after completing the learning assignment |
Number of Workers with new memberships | Provides the count of Workers who added additional memberships to their talent profile after completing the learning assignment |
Total Cost | Provides the cost of all trainings enrolled by the learners |
Cost - Withdrawn Enrollments | Provides the cost incurred on learning assignments that were withdrawn |
Cost - Completed Enrollments | Provides the cost incurred on learning assignments that were completed |
Cost - Bypass Completed Enrollments | Provides the cost incurred on learning assignments that were bypass completed |
Cost - Not Passed Enrollments | Provides the cost incurred on learning assignments that were completed but not passed |
Cost - Deleted Enrollments | Provides the cost incurred on learning assignments that were deleted |
Average Cost per learner | Provides the cost per person incurred across all learnings |
Cost - Terminated Learners | Provides the cost of learning incurred by the workers that are currently terminated |
Cost - enrolled but not completed | Provides the cost of incomplete learning incurred by workers |
Overall Learning Item Rating | Provides the average overall rating of a learning item |
Average Learning Item Rating - Workforce Structures | Provides the average rating of a learning item by various dimensions |
High Satisfaction Learners | Provides the count of learners that rated a learning item with score = 5 |
Low Satisfaction Learners | Provides the count of learners that rated a learning item with score = 1 |
Top Rated Courses | Provides the count of courses that have ratings >= 4 |
HCM— Opportunity Marketplace Gigs
This tables describes Opportunity Marketplace Gig metrics.
Metric | Metric Definition |
---|---|
Number of Gigs | Provides count of Gigs |
Number of Published Gigs | Provides count of published Gigs |
Total Openings | Provides number of openings in published Gigs |
Total Filled Openings | Provides number of filled openings in published Gigs |
Total Time Commitment (in hours) | Provides Total commitment time in hours for published Gigs. |
Total Gig Duration | Provides Gig duration in number of days between the start and end date of published Gig. |
Number of Gigs Open | Provides count of Gigs in Open status |
Number of Gigs Completed | Provides count of Gigs in Completed status |
Number of Gigs Filled | Provides count of Gigs in Filled status |
Number of Gigs Canceled | Provides count of Gigs in Canceled status |
Number of Creators | Provides count of Gig creators |
Number of Unique Creators | Provides count of unique Gig creators |
Number of Unique Seekers | Provides count of unique seekers |
Seekers - Male | Provides count of unique seekers with gender Male |
Seekers - Female | Provides count of unique seekers with gender Female |
Seekers - Disability | Provides count of unique seekers with Disability flag enabled |
Number of Gig Applications | Provides count of applications submitted for the Gigs |
Applications Applied | Provides count of applications submitted for the Gigs with Applied status |
Applications Assigned | Provides count of applications submitted for the Gigs with Assigned status |
Applications Completed | Provides count of applications submitted for the Gigs with Completed status |
Applications Withdrawn | Provides count of applications submitted for the Gigs with Withdrawn status |
Applications Not Selected | Provides count of applications submitted for the Gigs with Not selected status |
Applications Canceled | Provides count of applications submitted for the Gigs with Canceled status |
Applications Released | Provides count of applications submitted for the Gigs with Released status |
Applications - Female | Provides count of applications submitted by Female |
Applications - Male | Provides count of applications submitted by Male |
Applications - Disability | Provides count of applications submitted by applicants with Disability flag enabled |
Application Conversion Rate | Provides the percentage of applications converted to assigned status |
Percentage of Applications Willing in Remote Gig | Provides the percentage of applications willing to work in remote Gig |
Favored Gigs | Provides count of Gigs marked as favorite |
Favored Persons | Provides count of persons who marked the Gig as favorite |
Unique Favored Persons | Provides unique count of persons marked Gig as favorite |
Number of Teammates | Provides count of teammates, including the Gig creator as teammate |
HCM—Performance Management
This tables describes Performance Management metrics.
Metric | Metric Definition |
---|---|
Number of Performance Documents Created | Number of performance documents created. |
Number of Workers with Performance documents | Count (distinct workers) with performance document created. |
Performance Document In-ProgRess | Count (performance documents) where performance document status = in progress. |
Performance Document Completed | Count (performance documents) where performance document status = completed. |
Performance Document Submitted | Count (performance documents) where performance document status = submitted. |
Workers with Incomplete Appraisal | Count of workers that have created but not completed the performance appraisal. |
Managers with Incomplete Appraisal | Count (managers) with performance document status <> completed. |
Managers with Pending Appraisals of Workers | Count (managers) where workers with performance document status <> completed. |
Pending Document with an Inactive Manager | Count of performance document in-progress and assigned to an inactive manager. |
High Potential Count | Count of workers with potential category = high. |
Medium Potential Count | Count of workers with potential category = medium. |
Low Potential Count | Count of workers with potential category = low. |
Pending Tasks | Count (performance tasks) where status <> completed. |
Completed Tasks | Count (performance tasks) where status = completed. |
Tasks Completed Beyond Due Date | Count (performance tasks) where status = completed and due date < completion date. |
Pending Tasks Beyond Due Date | Count (performance tasks) where status <> completed and due date < completion date. |
Overall Manager Rating | Overall rating provided by the manager for the performance document. |
Overall Worker Rating | Overall rating provided by the worker for the performance document. |
Overall Participant Rating | Overall rating provided by participants other than manager and worker. |
Calculated Overall Rating | Average of the overall ratings provided by all participants. |
Workers with Performance Rating | Count (workers) where overall manager rating is not null. |
Percentage of Workers with Performance Rating | 100 * (count of workers with overall manager rating) /number of workers with performance documents. |
Performance Appraisal - High Performers Count | Count of workers with performance category = high. |
Performance Appraisal - Medium Performers Count | Count of workers with performance category = medium. |
Performance Appraisal - Low Performers Count | Count of workers with performance category = low. |
Performance Appraisal - Percentage of High Performers | 100 * (count of workers with performance category = high) /workers with performance rating. |
Performance Appraisal - Percentage of Medium Performers | 100 * (count of workers with performance category = medium) / workers with performance rating. |
Performance Appraisal - Percentage of Low Performers | 100 * (count of workers with performance category = low) / workers with performance rating. |
Manager Section Rating | Manager section rating - to be used with the attributes section type and section name. |
Worker Section Rating | Worker section rating - to be used with the attributes section type and section name. |
Calculated Section Rating | Average of the overall ratings provided by all participants - to be used with the attributes section type and section name. |
Manager Item Rating | Item ratings provided by the manager - to be used with the attributes Item type and Item name. |
Worker Item Rating | Item ratings provided by the worker - to be used with the attributes Item type and Item name. |
Manager Rated Proficiency Level | Proficiency rating provided by the manager - to be used with the attributes Item type and Item name. |
Worker Rated Proficiency Level | Proficiency rating provided by the worker - to be used with the attributes Item type and Item name. |
Manager Goals Rating | Manager rating where performance document section = goals. |
Worker Goals Rating | Worker rating where performance document section = goals. |
HCM—Positions
This tables describes Positions metrics.
Metric | Metric Definition |
---|---|
Position Headcount | Provides the budgeted headcount of the position |
Position FTE | Provides the budgeted FTE of the position |
Position Count | Provides the count of distinct positions |
Number of Positions without Incumbents | Provides the count of distinct active positions that have no incumbents on them |
Position Incumbent Headcount | Provides the incumbent headcount of the position |
Position Incumbent FTE | Provides the incumbent FTE of the position |
Position Incumbent Count | Provides the incumbent count of the position |
HCM—Profile Matching (Preview)
This tables describes Profile Matching metrics.
Metric | Metric Definition |
---|---|
Number of Active Person Profiles | Number of active person profiles. |
HCM—Succession Management
This tables describes Succession Management metrics.
Metric | Metric Definition |
---|---|
Number of Succession Plans | Count (distinct succession plan). |
Active Plan Count | Count (distinct succession plan) where status = active. |
Inactive Plan Count | Count (distinct succession plan) = inactive. |
Incumbent Plan Count | Count (distinct succession plan) where plan type = incumbent. |
Job Plan Count | Count (distinct succession plan) where plan type = job. |
Position Plan Count | Count (distinct succession plan) where plan type = position. |
Number of Private Plans | Count (distinct succession plan) where plan privacy = private. |
Succession Plans with Candidates | Count (distinct succession plan) where candidate count > zero. |
Succession Plans without Candidates | Count (distinct succession plan) where candidate count = zero. |
Active Plans without Candidate | Count (distinct succession plan) where status = active and candidate count = zero. |
Jobs with Plan without Incumbents | Count (distinct succession plan) where plan type = job and inferred incumbent count = zero. |
Position with Plan without Incumbents | Count (distinct succession plan) where plan type = position and inferred incumbent count = zero. |
Plans with Single Owner | Count (distinct succession plan) where count (distinct owner id) = one. |
Plans with Inactive Owner | Count (distinct succession plan) where owners assignment status = inactive. |
Successful Plans with High Risk Candidate | Count (distinct succession plan) where candidate succession status = ORA_HRM_SUCCESSOR and candidate risk of loss = high. |
Incumbent Count - Incumbent Plan | Count (distinct incumbent) from all active incumbent plans. |
InferRed Incumbent Count | Count (distinct incumbent) from all active succession plans where plan type in (job, position). |
Total Incumbents | (incumbent count - incumbent plan + inferred incumbent count). |
Incumbent Departed Count | Count (distinct incumbent) who are terminated. |
Incumbent with High Risk of Loss | Count (distinct incumbent) where risk of loss category = high. |
Percentage of Incumbents with High Risk of Loss | (Count (distinct incumbent) where risk of loss category = high * one00) /incumbent count - incumbent plan. |
Incumbent with High Impact of Loss | Count (distinct incumbent) where impact of loss category = high. |
Percentage of Incumbents with High Impact of Loss | (Count (distinct incumbent) where impact of loss category = high * one00) /incumbent count - incumbent plan. |
High Risk of Loss Incumbents without Candidates | Count (distinct incumbent) where risk of loss category = high and candidate count is zero. |
High Impact of Loss Incumbents without Candidates | Count (distinct incumbent) where impact of loss category = high and candidate count is zero. |
Plans with High Risk Incumbents and No Candidates | Count (distinct succession plan) where candidate count = zero and incumbent risk of loss = high. |
Plans with High Risk Incumbents and No Ready Now Candidates | Count (distinct succession plan) where ready now candidate count = zero and incumbent risk of loss = high. |
Successful Plans with High Risk Incumbents | Count (distinct succession plan) where candidate succession status = ORA_HRM_SUCCESSOR and incumbent risk of loss = high. |
Number of Candidates | Count (distinct internal candidates + external candidate). |
Active Candidate Count | Count (distinct candidates) where candidates current status on the succession plan = active. |
Inactive Candidate Count | Count (distinct candidates) where candidates current status on the succession plan= inactive. |
Interim Candidates | Count (distinct candidates) where interim flag = Y. |
Candidates with Succession Plans | Count (distinct candidates) where candidate IN (Select incumbent from active succession plans). Note: The candidate could be a direct incumbent or an inferred incumbent in any other plan. |
Candidates without Succession Plans | Count (distinct candidates) where candidate NOT IN (select incumbent from active succession plans). |
Candidate Active Plan Count | Count (distinct plan) where plan status = active . |
Ready Now Count | Count (distinct candidates) where readiness band = ready now. |
Ready in 1 Year Count | Count (distinct candidates) where readiness band = ready in < one year. |
Ready in 2 Years Count | Count (distinct candidates) where readiness band = ready in one - 2 years. |
Ready in 3 Years Count | Count (distinct candidates) where readiness band = ready in 3 - 4 years. |
High Risk of Loss Candidates | Count (distinct candidates) where risk of loss band = high. |
High Impact of Loss Candidates | Count (distinct candidates) where impact of loss band = high. |
Willing to Relocate Candidates | Count (distinct candidates) where willing to relocate flag = Y. |
Candidates Success Count - Incumbent Plan | Count (distinct candidates) where candidate succession status = ORA_HRM_SUCCESSOR for the plan. |
Candidates Success Count - Job Plan | Count (distinct candidates) where candidate succession status = ORA_HRM_SUCCESSOR for the plan. |
Candidates Success Count - Position Plan | Count (distinct candidates) where candidate succession status = ORA_HRM_SUCCESSOR for the plan. |
Internal Candidate Count | Count (distinct candidates) where candidate <> external candidate. |
External Candidate Count | Count (distinct external candidate ID) where candidate = external candidate. |
Candidate Since (Days) | Time (in days) between the date candidate added to a plan till current date . |
New Role Candidates - Incumbent Plan | Count (distinct candidates) where candidate succession status = ORA_HRM_MOVED_TO_DIFF_ROLE . |
New Role Candidates - Job Plan | Count (distinct candidates) where candidate succession status = ORA_HRM_MOVED_TO_DIFF_ROLE . |
New Role Candidates - Position Plan | Count (distinct candidates) where candidate succession status = ORA_HRM_MOVED_TO_DIFF_ROLE . |
High Performance Candidates | Count (distinct candidates) where performance category band = high. |
Medium Performance Candidates | Count (distinct candidates) where performance category band = medium. |
Low Performance Candidates | Count (distinct candidates) where performance category band = low. |
High Potential Candidates | Count (distinct candidates) where potential category band = high. |
Medium Potential Candidates | Count (distinct candidates) where potential category band = medium. |
Low Potential Candidates | Count (distinct candidates) where potential category band= low. |
High Performance High Risk of Loss Candidates | Count (distinct candidates) where performance category band= high and risk of loss band= high. |
High Potential High Risk of Loss Candidates | Count (distinct candidates) where potential category band = high and risk of loss band = high. |
Percentage of External Candidates | (Number of external candidates/Total candidates) * one00. |
Percentage of Internal Candidates | (Number of internal candidates/Total candidates) * one00. |
Candidate Matching - Succession Plan Job | Count (distinct candidates) where candidate job ID = plan job id. |
Candidate Matching - Succession Plan Position | Count (distinct candidates) where candidate position ID = plan position ID AND business unit ID = plan business unit ID. |
Succession Plan - Matching Candidate Job | Count (distinct plan_ID) where candidate job ID = plan job id. |
Succession Plan - Matching Candidate Position | Count (distinct plan_ID) where candidate position ID = plan position ID AND business unit ID = plan business unit ID. |
Successful Plans | Count (distinct succession plans) where candidate succession status = ORA_HRM_SUCCESSOR for the plan. |
Candidate Matching - Incumbent Job | Count (distinct candidates) where candidate job ID = incumbent job id. |
Succession Plan - Candidate Matching Incumbent Job | Count (distinct plan_ID) where candidate job ID = incumbent job id. |
HCM—Talent Acquisition
This table describes Talent Acquisition metrics.
Metric | Metric Definition |
---|---|
Job Requisitions by Recruiter | Average number of job requisitions by recruiters. |
Job Requisitions in Approval Phase (Period End) | Number of distinct active job requisitions that are in approval phase at the end of the given time period. |
Job Requisitions in Draft Phase (Period End) | Number of distinct active job requisitions that are in draft phase at the end of the given time period. |
Job Requisitions in Formatting Phase (Period End) | Number of distinct active job requisitions that are in job formatting phase at the end of the given time period. |
Job Requisitions in Posting Phase (Period End) | Number of distinct active job requisitions that are in posting phase at the end of the given time period. |
Job Requisitions Not in Open Phase (Period End) | Number of distinct active job requisitions that are not in open phase at the end of the given time period. |
Job Requisitions in Open Phase (Period Begin) | Number of distinct active job requisitions in open phase at the end of the given time period. |
Job Requisitions in Open Phase (Period Begin) | Number of distinct active job requisitions in open phase at the beginning of the given time period. |
Percentage of Job Requisitions Not Open | Percentage of job requisitions created but not yet open. |
Recruiter Count | Distinct count of workers identified as recruiters. |
Total Job Requisitions | Total number of requisitions in all phases and states except Cancelled, Deleted, Filled state. |
Total Openings | Number of total openings specified for a job requisition. |
Vacancy Fill Rate | Percentage of open requisitions that have been filled in a time period. |
Number of Job Requisition Events | Number of Job Requisition Events that have happened. |
Number of Job Requisitions Moved to Approval Phase | Number of job requisitions that have moved to approval phase. |
Number of Job Requisitions Moved to Cancelled State | Number of job requisitions that moved to Cancelled State across any of the phases like 'Approval'; 'Job Formatting'; 'Posting'; or 'Open' Phase |
Number of Job Requisitions Moved to Draft Phase | Number of job requisitions that have moved to draft phase. |
Number of Job Requisitions Moved to Filled State | Number of job requisitions that moved to Filled State. |
Number of Job Requisitions Moved to Job Formatting Phase | Number of job requisitions that have moved to Job Formatting phase. |
Number of Job Requisitions Moved to Open Phase | Number of job requisitions that have moved to open phase. |
Number of Job Requisitions Moved to Rejected State | Number of job requisitions that moved to Rejected State. |
Number of Job Requisitions Moved to Suspended State | Number of job requisitions that moved to Suspended State in Open Phase. |
Total Job Requisitions (on Event) | Number of job requisitions across all phases and states. |
Time To Fill | Number of days between job requisition opened to when it is filled. |
Number of Job Requisitions Moved to Posting Phase | Number of job requisitions that have moved to Job Posting phase. |
Number of Job Requisitions Moved to Deleted State | Number of job requisitions that moved to Deleted State. |
Time Elapsed (Days) From Draft Phase to Approval Phase | Time duration between the earliest start of the draft phase and the latest start of the approval phase. |
Time Elapsed (Days) From Approval Phase to Job Formatting Phase | Time duration between the earliest start of the approval phase and the latest start of the job Formatting phase. |
Time Elapsed (Days) From Job Formatting Phase to Posting Phase | Time duration between the earliest start of the job Formatting phase and the latest start of the posting phase. |
Time Elapsed (Days) From Posting Phase to Open Phase | Time duration between the earliest start of the posting phase and the latest start of the open phase. |
Total Job Applications (on Event) | Number of distinct job applications across all phases and states at the time of the application event. |
Job Applications Rejected | Number of applications rejected by the employer. |
Job Applications Withdrawn | Number of applications withdrawn by the applicant. |
Number of Job Applications in Offer Phase Moved to Draft State | Number of job applications in offer phase that are moved to draft state. |
Number of Job Applications in Offer Phase Moved to Approved State | Number of job applications in offer phase that are moved to approved state. |
Number of Job Applications in Offer Phase Moved to Extended State | Number of job applications in offer phase that are moved to extended state. |
Number of Job Applications in Offer Phase Moved to Rejected State | Number of job applications in offer phase that are moved to rejected state. |
Number of Job Applications in Offer Phase Moved to Accepted State | Number of job applications in offer phase that are moved to accepted state. |
Number of Job Applications in Offer Phase Moved to Withdrawn State | Number of job applications in offer phase that are moved to withdrawn state. |
Number of Job Applications Moved to HR Phase | Number of job applications that are moved to HR phase. |
New Hires | Number of candidates that have been hired for the first time in the organization. |
Employee Hires | Number of hires that are already employees in the organization with a different job. |
Contingent Worker Hires | Number of hires that are already contingent workers in the organization with a different job. |
Internal Hires | Number of hires that already have an active work relationship in the organization. |
External Hires | Number of hires that were external candidates. |
Referral Hires | Number of hires that were referral candidates. |
Number of Referred Applications | Number of job applications that came as referrals. |
Total Requisitions with Applicants | Number of job requisitions that have applicants on them. |
Requisition with No Internal Applicants | Number of job requisitions that do not have any internal applicants on them. |
Hire Rate | The percentage of candidates that have been hired including internal and external candidates based on the job application. |
External Hire Rate | The percentage of external candidates that have been hired. |
Internal Hire Rate | The percentage of internal candidates that have been hired. |
Job Applications - Offer Acceptance Rate | Job offers accepted as a percentage of offers extended. |
Referral Hire Rate | The percentage of referral candidates that have been hired. |
Referral Success rate | The percentage of candidate referrals that resulted as hires. |
Rehires | Number of hires where the candidate was an ex worker of the organization. |
Rehire Rate | Number of rehires as a percentage of total hires. |
Drop Off Rate | Percentage of applications that were either withdrawn or rejected out of the total applications. |
Job Requisitions with No Internal Applicant Percentage | Percentage of job requisitions that have no internal applicants. |
Job Offer Extended to Hired Percentage | Percentage of candidates that moved to HR phase of the total offers extended. |
Job Offers to openings Percentage | Percentage of offers extended against total job openings. |
Hires to Goal Rate | Percentage of hires against total job openings. |
Total Job Applications | Number of Job Applications that are in non-terminal states. |
Applicant Count | Count of distinct Applicants with Job Applications that are in non-terminal states. |
Employee Job Applications | Number of Job Applications by employees that are in non-terminal states. |
Contingent Job Applications | Number of Job Applications by contingent workers that are in non-terminal states. |
External Job Applications | Number of Job Applications by external candidates that are in non-terminal states. |
Job Applications in Offer - Pending Approval | Number of Job Applications that are in non-terminal Offer pending approval state. |
Job Applications in HR - Pending Processing | Number of Job Applications that are in non-terminal HR - Pending Manual Processing and HR - Pending Automated Processing states. |
Job Applications - Willing to Domestic Travel | Number of Job Applications that are in non-terminal states and have domestic travel flag = Y. |
Job Applications - Willing to International Travel | Number of Job Applications that are in non-terminal states and have international travel flag = Y. |
Job Applications - Willing to Relocate | Number of Job Applications that are in non-terminal states and have relocate flag = Y. |
Job Applications - Female | Number of Job Applications created by female and are in non-terminal states. |
Job Applications - Male | Number of Job Applications created by male and are in non-terminal states. |
Job Applications - Gender undisclosed | Number of Job Applications with gender not disclosed and are in non-terminal states. |
Job Applications - Veterans | Number of Job Applications created by veterans and are in non-terminal states. |
Job Applications - Non Veterans | Number of Job Applications created by non veterans and are in non-terminal states. |
Job Applications - Disability | Number of Job Applications created by candidates with disability and are in non-terminal states. |
Hires | Total hires. |
Time Elapsed (Days) From Submission Confirmed Date to Offer Extended State | Number of days taken for the job application from the confirmation date till it entered the offer extended state. |
Time Elapsed (Days) From Submission Confirmed Date to Offer Accepted State | Number of days taken for the job application from the confirmation date till it entered the offer accepted state. |
Time Elapsed (Days) From Submission Confirmed Date to Offer Rejected State | Number of days taken for the job application from the confirmation date till it entered the offer rejected state. |
Time Elapsed (Days) From Submission Confirmed Date to Offer Withdrawn State | Number of days taken for the job application from the confirmation date till it entered the offer withdrawn state. |
Time Elapsed (Days) From Submission Confirmed Date to Hire Processed State | Number of days taken for the job application from the confirmation date till it entered the hire (HR) processed state. |
Time to Hire (Days) | Number of days taken from the job requisition open date till the latest date when an application entered the hire (HR) processed state as part of this requisition. |
Number of Referral Applications | Number of applications referred by internal workers. |
Number of Campaign Applications | Number of applications through campaigns. |
Nunber of Career Sites Applications | Number of applications through career sites. |
Number of Applications added to Job Requisition | Number of applications added to job requisitions by recruiters. |
Number of Applications from Intelligent matching | Number of applications created as a result of the intelligent matching feature. |
Number of Applications from Referral Websites | Number of applications through referral websites. |
Number of Social Media Applications | Number of applications through social media. |
Number of Search Engine Applications | Number of applications created as a result of search engine findings. |
Number of Job Board Applications | Number of applications through job boards. |
Number of Job Aggregator Applications | Number of applications through job aggregators. |
Number of Applications Created manually | Number of applications created by recruiters manually. |
Number of Third Party Applications | Number of applications through third party codes. |
Number of Applications through Shared Job Postings | Number of applications through shared job postings. |
Number of Job Applications moved to Offer Phase | Number of Job Applications that are moved to Offer Phase |
Number of Job Applications in Offer Phase moved to Pending Approval State | Number of Job Applications in Offer Phase that are moved to Pending Approval State |
Number of Job Applications in Offer Phase moved to Approval Rejected State | Number of Job Applications in Offer Phase that are moved to Approval Rejected State |
Number of Job Applications in HR Phase moved to Processed State | Number of Job Applications in HR Phase that are moved to Processed State |
Number of Job Applications in HR Phase moved to Rejected by Employer State | Number of Job Applications in HR Phase that are moved to Rejected by Employer State |
Number of Job Applications in HR Phase moved to Withdrawn by Candidate State | Number of Job Applications in HR Phase that are moved to Withdrawn by Candidate State |
Number of Job Applications with Active Job Offers (On Event) | Number of Job Applications with Active Job Offers (On Event) at the time of the application event. |
Number of Job Applications with Active Job Offers | Number of Job Applications with Active Job Offers |
Suspended Duration (Seconds) | Duration of the Suspended state completion step in seconds. |
Suspended Duration (Hours) | Duration of the Suspended state completion step in hours. |
Suspended Duration (Days) | Duration of the Suspended state completion step in days. |
Latest Time to Fill (Days) | Number of days between opened date to latest filled date for the currently filled job requisitions. |
Latest Time to Fill (Minus Suspended Duration (Days) | Number of days between opened date to latest filled date for the currently filled job requisitions. Suspended duration is excluded. |
Total Openings (on Event) | Total number of Job Openings. |
Applicant Average Time to Hire (Days) | Number of days between job application submitted to when a candidate is moved to HR phase. |
Applications Withdrawn Rate | Percentage of applications that were withdrawn out of the total applications. |
Facts - Job Requisition Progress - Phase Completion Duration (in Seconds) | Provides the time taken in seconds to complete a requisition phase. |
Facts - Job Requisition Progress - Phase Completion Duration (in Hours) | Provides the time taken in Hours to complete a requisition phase. |
Facts - Job Requisition Progress - Phase Completion Duration (in Days) | Provides the time taken in days to complete a requisition phase. |
Facts - Job Requisition Progress - State Completion Duration (in Seconds) | Provides the time taken in seconds to complete a requisition state. |
Facts - Job Requisition Progress - State Completion Duration (in Hours) | Provides the time taken in Hours to complete a requisition state. |
Facts - Job Requisition Progress - State Completion Duration (in Days) | Provides the time taken in days to complete a requisition state. |
Facts - Job Application Progress - Phase Completion Duration (in Seconds) | Provides the time taken in seconds to complete a job application phase. |
Facts - Job Application Progress - Phase Completion Duration (in Hours) | Provides the time taken in Hours to complete a job application phase. |
Facts - Job Application Progress - Phase Completion Duration (in Days) | Provides the time taken in days to complete a job application phase. |
Facts - Job Application Progress - State Completion Duration (in Seconds) | Provides the time taken in seconds to complete a job application state. |
Facts - Job Application Progress - State Completion Duration (in Hours) | Provides the time taken in Hours to complete a job application state. |
Facts - Job Application Progress - State Completion Duration (in Days) | Provides the time taken in days to complete a job application state. |
HCM—Talent Profile
This table describes Talent Profile metrics.
Metric | Metric Definition |
---|---|
Number of Job Model Profiles | Total number of active model profiles of type Job |
Number of Jobs With Profiles | Number of jobs that have active model profile attached to them. |
Number of Competencies | Number of competencies attached for a job. |
Number of Degrees | Number of degrees attached for a job. |
Number of Honors and Awards | Number of honors and awards attached for a job. |
Number of Languages | Number of languages attached for a job. |
Number of License and Certifications | Number of license and certifications attached for a job. |
Number of Memberships | Number of memberships attached for a job. |
Number of Profiles that Requires Travel | Number of job model profiles that has travel requirement as Yes. |
Number of Profiles that Requires Relocation | Number of job model profiles that has relocation requirement as Yes. |
Number of Position Model Profiles | Total number of active model profiles of type Position. |
Number of Positions With Profiles | Number of positions that have active model profile attached to them. |
Number of Competencies | Number of competencies attached for a position. |
Number of Degrees | Number of degrees attached for a position. |
Number of Honors and Awards | Number of honors and awards attached for a position. |
Number of Languages | Number of languages attached for a position. |
Number of License and Certifications | Number of license and certifications attached for a position. |
Number of Memberships | Number of memberships attached for a position. |
Number of Profiles that Requires Travel | Number of job position profiles that has travel requirement as Yes. |
Number of Profiles that Requires Relocation | Number of position model profiles that has relocation requirement as Yes. |
Number of Profiles | Number of Profiles. |
Number of Workers with Profiles | Number of Workers with Profiles |
Number of Active Profiles | Number of profiles with Profile status is Active. |
Number of Workers with Active Profiles | Number of workers with profiles status is active. |
Percentage of Active Profiles | Percentage of workers that have an active profile as against the total workers. |
Number of Competencies | Number of competencies possessed by the worker. |
Number of Degrees | Number of degrees possessed by the worker. |
Number of Honors and Awards | Number of honors and awards possessed by the worker. |
Number of Languages | Number of languages possessed by the worker. |
Number of License and Certifications | Number of licenses and certifications possessed by the worker. |
Number of Workers Willing to Relocate | Number of workers willing to re-locate. |
Number of Workers Ready for Domestic Travel | Number of workers ready for domestic travel. |
Number of Workers Ready for International Travel | Number of workers ready for international travel. |
Number of Workers Ready Now for Career Move | Number of workers ready now for career move. |
Number of Workers with Performance Rating | Number of Workers with Performance Rating. |
Number of High Performers | Number of Workers rated as high performers. |
Number of Medium Performers | Number of Workers rated as medium performers. |
Number of Low Performers | Number of Workers rated as low performers. |
Number of Workers with Potential Rating | Number of Workers with potential rating. |
Number of High Potential | No of Workers rated as high potential. |
Number of Medium Potential | No of Workers rated as medium potential. |
Number of Low Potential | No of Workers rated as low potential. |
Number of Workers with Risk of Loss | Number of workers that are at risk of loss. |
Number of Workers with Impact of Loss | Number of workers with impact of loss. |
Number of Skills | Number of skills |
Number of Workers with Skills | Number of workers with one or more skills |
Number of Unique Skills | Number of unique skills |
Number of Skills Awaiting Endorsement | Number of skills without any endorsement |
Number of Skills Endorsed | Number of skills with one or more endorsements |
Average Skill Rating | Average skill rating rounded to map configured rating levels |
Number of Developing Skills | Number of skill in developing status |
Number of Developed Skills | Number of skill in developed status |
Number of Skill Endorsements Requested | Number of skill endorsements requested |
Number of Skill Endorsements Completed | Number of skill endorsements in completed status |
Number of Skill Endorsement Requestors | Number of skill endorsement requestors |
Number of Skill Endorsers | Number of skill endorsers |
HCM—Talent Profile Trends (Preview)
This table describes Talent Profile Trends metrics.
Metric | Metric Definition |
---|---|
Number of active profiles | Number of profiles with active flag = 'Y' |
Number of Workers with active profiles | Number of workers with profiles and profile active flag = 'Y' |
Number of Competencies | Number of competencies possessed by the worker |
Number of Degrees | Number of degrees possessed by the worker |
Number of Licenses and certifications | Number of licenses and certifications possessed by the worker |
Number of Honours and awards | Number of honours and awards possessed by the worker |
Number of Languages | Number of languages possessed by the worker |
Number of Memberships | Number of memberships possessed by the worker |
Number of Workers with Performance Rating | Number of Workers with performance rating |
Number of High Performers | Workers rated as high performers |
Number of Medium Performers | Workers rated as medium performers |
Number of Low Performers | Workers rated as low performers |
Number of Workers with Potential Rating | Number of Workers with potential rating |
Number of High Potential | Workers rated as high potential |
Number of Medium Potential | Workers rated as medium potential |
Number of Low Potential | Workers rated as low potential |
Number of Workers with Risk of Loss | Number of workers that are at risk of loss |
Number of High Risk of Loss | Workers with high risk of loss |
Number of Medium Risk of Loss | Workers with medium risk of loss |
Number of Low Risk of Loss | Workers with low risk of loss |
Number of Workers with Impact of Loss | Number of Workers with impact of loss |
Number of High Impact of Loss | Workers with high impact of loss |
Number of Medium Impact of Loss | Workers with medium impact of loss |
Number of Low Impact of Loss | Workers with low impact of loss |
HCM—Talent Review Meetings
This table describes Talent Review Meetings metrics.
Metric | Metric Definition |
---|---|
Number of Facilitators | Number of facilitators in the talent review meeting. |
Number of Participants | Number of participants in the talent review meeting. |
Number of Reviewees | Number of reviewees in the talent review meeting. |
Number of Meetings | Number of talent review meetings. |
Number of High Performers | Number of workers rated as high performers . |
Number of Medium Performers | Number of workers rated as medium performers. |
Number of Low Performers | Number of workers rated as low performers. |
Number of High Potential | Number of workers rated as high potential. |
Number of Medium Potential | Number of workers rated as medium potential. |
Number of Low Potential | Number of workers rated as low potential. |
Number of High Risk of Loss | Number of workers rated as high risk of loss. |
Number of Medium Risk of Loss | Number of workers rated as medium risk of loss. |
Number of Low Risk of Loss | Number of workers rated as low risk of loss. |
Number of High Impact of Loss | Number of workers rated as high impact of loss. |
Number of Medium Impact of Loss | Number of workers rated as medium impact of loss. |
Number of Low Impact of Loss | Number of workers rated as low impact of loss. |
Number of Top Talent | Number of workers rated as high performers and high potential. |
Number of Low Talent | Number of workers rated as low performers and low potential. |
Number of Top Talent at High Risk of Loss | Provides the count of workers rated high in performance and potential that are rated high risk of loss. |
Number of High Performers at High Risk of Loss | Provides the count of workers rated high in performance and potential that are rated high risk of loss. |
Number of High Potential at High Risk of Loss | Provides the count of workers rated high in potential and potential that are rated high risk of loss. |
Number of Top Talent at High Impact of Loss | Provides the count of workers rated high in performance and potential that are rated high impact of loss. |
Number of Top Talent at Low Impact of Loss | Provides the count of workers rated high in performance and potential that are rated low impact of loss. |
Number of High Performers at High Impact of Loss | Provides the count of workers rated high in performance and potential that are rated high impact of loss. |
Number of High Potential at High Impact of Loss | Provides the count of workers rated high in potential that are rated high impact of loss. |
Number of High Performers at Low Impact of Loss | Provides the count of workers rated high in performance that are rated low impact of loss. |
Number of High Risk of Loss Terminated within 1 Year | Provides the count of workers that got terminated within one year of being rated high risk of loss. |
Number of Low Risk of Loss Terminated within 1 Year | Provides the count of workers that got terminated within one year of being rated low risk of loss. |
Number of High Risk of Loss Active Workers after a Year | Provides the count of workers that are rated high risk of loss for more than a year but still not terminated. |
Number of Workers - Improved Performance Rating | Provides the count of workers whose performance band changed from low to medium, high or medium to high. |
Number of Workers - Improved Potential Rating | Provides the count of workers whose potential band changed from low to medium, high or medium to high. |
Number of Workers - Decreased Performance Rating | Provides the count of workers whose performance band changed from high to medium, low or medium to low. |
Number of Workers - Decreased Potential Rating | Provides the count of workers whose potential band changed from high to medium, low or medium to low. |
Number of Workers - Increased Risk of Loss | Provides the count of workers whose risk of loss band changed from low to medium, high or medium to high. |
Number of Workers - Decreased Risk of Loss | Provides the count of workers whose risk of loss band changed from high to medium, low or medium to low. |
Number of Workers - Increased Impact of Loss | Provides the count of workers whose impact of loss band changed from low to medium, high or medium to high. |
Number of Workers - Decreased Impact of Loss | Provides the count of workers whose impact of loss band changed from high to medium, low or medium to low. |
Number of High Performers Terminated within 1 Year | Provides the count of workers that got terminated within one year of being rated as high performers in the talent review meeting. |
Number of Low Performers Terminated within 1 Year | Provides the count of workers that got terminated within one year of being rated as low performers in the talent review meeting. |
Number of High Performers | Number of workers rated as high performers . |
Number of Medium Performers | Number of workers rated as medium performers. |
Number of Low Performers | Number of workers rated as low performers. |
Number of High Potential | Number of workers rated as high potential. |
Number of Medium Potential | Number of workers rated as medium potential. |
Number of Low Potential | Number of workers rated as low potential. |
Number of High Risk of Loss | Number of workers rated as high risk of loss. |
Number of Medium Risk of Loss | Number of workers rated as medium risk of loss. |
Number of Low Risk of Loss | Number of workers rated as low risk of loss. |
Number of High Impact of Loss | Number of workers rated as high impact of loss. |
Number of Medium Impact of Loss | Number of workers rated as medium impact of loss. |
Number of Low Impact of Loss | Number of workers rated as low impact of loss. |
Number of Top Talent | Number of workers rated as high performers and high potential. |
Number of Low Talent | Number of workers rated as low performers and low potential. |
HCM—Worker Seniority (Preview)
This table describes Worker Seniority metrics.
Metric | Metric Definition |
---|---|
Person Count(P) | Number of Workers with the seniority data, can include active and inactive |
Seniority Years(P) | Number of years of seniority, does not consider the seniority months and days (This leverages the existing seniority years column from the db without using the months and days columns) |
Seniority Months(P) | Number of months of seniority, does not consider the seniority days. (This leverages the existing seniority years and months column from the db without using the days columns) |
Seniority Days(P) | seniority days This leverages the existing total seniority days column from the db |
Person Count(A) | Number of Workers with the seniority data, can include active and inactive |
Seniority Years(A) | Number of years of seniority, does not consider the seniority months and days (This leverages the existing seniority years column from the db without using the months and days columns) |
Seniority Months(A) | Number of months of seniority, does not consider the seniority days. (This leverages the existing seniority years and months column from the db without using the days columns) |
Seniority Days(A) | seniority days This leverages the existing total seniority days column from the db |
Person Count(WR) | Number of Workers with the seniority data, can include active and inactive |
Seniority Years(WR) | Number of years of seniority, does not consider the seniority months and days (This leverages the existing seniority years column from the db without using the months and days columns) |
Seniority Months(WR) | Number of months of seniority, does not consider the seniority days. (This leverages the existing seniority years and months column from the db without using the days columns) |
Seniority Days(WR) | seniority days This leverages the existing total seniority days column from the db |
HCM—Workforce Absence Management
This table describes Workforce Absence Management metrics.
Metric | Metric Definition |
---|---|
Total Duration of Absences (Days) | Sum of duration of all absences. |
Total Duration of Absences (Hours) | Sum of duration of all absences, for absence type with UOM=Hours. |
QuaLification Plan Absences Duration | Sum of duration of approved absences of qualification plans. |
Number of QuaLification Plan Absences | Count of distinct approved absences of qualification plans. |
Accrual Plan Absences Duration | Sum of duration of approved absences of accrual plans. |
Number of Accrual Plan Absences | Count of distinct approved absences of accrual plan . |
Compensatory Plan Absences Duration | Sum of duration of approved absences of compensatory plans. |
Number of Compensatory Plan Absences | Count of distinct approved absences of compensatory plans. |
NoEntitlement Plan Absences Duration | Sum of duration of approved absences of NoEntitlement plans. |
Number of NoEntitlement Plan Absences | Count of distinct approved absences of NoEntitlement plans. |
Approved Absence Transactions | Count of distinct absences transaction with approval status as approved. |
Completed Absence Transactions | Count of distinct approved absence transactions with past dated absence end date. |
Pending Approval Absences Transactions | Count of distinct absences transaction with approval status as awaiting approval. |
Scheduled Absence Transactions | Count of distinct approved absence transactions with future absence start date. |
Worker Count (Approved Absences) | Count distinct worker with absences transactions with approval status as approved. |
Worker Count (Pending Absences) | Count distinct worker with absence transactions with approval status as awaiting approval. |
Female Gender Ratio (Approved Absences) | Female gender ratio with approved absences. |
Male Gender Ratio (Approved Absences) | Male gender ratio with approved absences. |
Late Notified Absences | Count of late notified absences. |
Withdrawn Absence Transactions | Count of distinct absences transaction with absence status as withdrawn. |
Rejected Absence Transactions | Count of distinct absences transaction with approval status as denied. |
Draft Absence Transactions | Count of distinct absences transaction with absence status as saved. |
Worker Count (Rejected Absences) | Count distinct worker with absences transactions with approval status as denied. |
Worker Count (Withdrawn Absences) | Count distinct worker with absences transactions with absence status as withdrawn. |
Worker Count (Draft Absences) | Count distinct worker with absences transactions with absence status as saved. |
Female Gender Ratio (Rejected Absences) | Female gender ratio with rejected absences. |
Male Gender Ratio (Rejected Absences) | Female gender ratio with rejected absences. |
Absence Approval Rate for High Performer Worker | Ratio of approved absence to total absence of a worker with performance rating=high. |
Absence Approval Rate for Low Performer Worker | Ratio of approved absence to total absence of a worker with performance rating=Low. |
Absence Rejection Rate for High Performer Worker | Ratio of rejected absence to total absence of a worker with performance rating=high. |
Absence Rejection Rate for Low Performer Worker | Ratio of rejected absence to total absence of a worker with performance rating=Low. |
Worker Count (Enrolled in a Plan) | Count of workers enrolled in an absence plan. |
Accrual Balance | End accrual balance as on balance run date. |
Prior Accrual Balance | Begin accrual balance as on balance run date. |
Compensatory Plan Balance | Begin compensatory plan balance as on last balance run date. |
Prior Compensatory Plan Balance | End compensatory plan balance as on last balance run date. |
Accrual Value | Plan accrual value. |
Annual Accrual | Front Loaded calculated accrual. |
Periodic Accrual | Calculated incremental accrual plan value, as of the last accrual run date. |
Carryover | Balance value that is carry over as of latest balance calculation date. |
Carryover Expiration | Carry over balance value that will expire as of latest balance calculation date. |
Carryover Forfeiture | Carry over balance value to forfeiture due to carryover limits set. |
Vested Accrual | Accrued balance value subject to a waiting period that has subsequently passed. |
Unvested Accrual | Accrued balance value but subject to a waiting period set. |
Other Adjustments | Other balance adjustment transactions. |
Unprocessed Adjustments | Total of all unprocessed adjustments for the latest balance calculation date. |
Transferred Balance | Balance value transferred to and from other accrual plans. |
Processed Absences | Total processed absences as of latest balance calculation date. |
Unprocessed Absences | Balance value used by absences scheduled. |
Compensatory Time | Compensatory time accrued. |
Expiration Disbursement (Compensatory Plan) | Disbursement of balance to payroll upon expiration. |
Other Adjustments (Compensatory Plan) | Other balance adjustment transactions. |
Unprocessed Adjustment (Compensatory Plan) | Total of all unprocessed adjustments for the latest balance calculation date. |
Transferred Balance (Compensatory Plan) | Balance value transferred to and from other accrual plans. |
Donations | Donations. |
In-progress Absence Transactions | Count of distinct absences transaction with Approval status as in-progress |
Number of Absences | Count of distinct absence transaction |
Absence Duration | Absence duration, non-agreegable at absences plan level |
Absence Plan Duration | Absences duration, agreegable at absence plan level |
HCM—Workforce Core
This table describes Workforce Core metrics.
Metric | Metric Definition |
---|---|
Average Headcount | Average of headCount between period start date and period end date |
Average FTE | Average FTE between period start date and period end date |
Worker Count | Count of unique person numbers for all assignment types (Employee, Pending Worker, Contingent Workers, Non-Workers) |
Employee Headcount Ratio | Ratio of the employee headcount to total headcount. |
Contingent Headcount Ratio | Ratio of the contingent headcount to total headcount. |
Employee FTE Ratio | Ratio of the employee FTE to total FTE. |
Contingent Worker FTE Ratio | Ratio of the contingent FTE to total FTE. |
Span of Control Workforce Structure | Average nunber of reportees for a manager by workforce structures like business unit, location, job family and so on. |
Average Worker Age | Average age of the worker based on their date of birth. |
Headcount Turnover | Ratio of Termination Headcount to average headcount. |
FTE Turnover | Ratio of FTE terminations to average FTE. |
Voluntary FTE Turnover | Ratio of voluntary FTE terminations to average FTE. |
Involuntary FTE Turnover | Ratio of Involuntary FTE terminations to average FTE. |
Voluntary Headcount Turnover | Ratio of Voluntary terminations headcount to average headcount. |
Involuntary Headcount Turnover | Ratio of Inoluntary terminations headcount to average headcount. |
New Hire Headcount Turnover | Percentage of Headcount terminations of workers with years of service <= 1 Year |
Headcount Retention | Headcount Retention percentage for the time period. |
New Hire Headcount Retention | Percentage of Headcount Retention of workers with years of service <= 1 Year. |
FTE Retention | FTE Retention percentage for the time period |
New Hire FTE Retention | Percentage of FTE retention where years of service <= 1Year |
Assignment Event Headcount | Headcount of all assignment events during the period. |
Hire Headcount | Headcount of all assignment hire events, Action type in (Add Employee Work Relationship, Hire an Employee, Rehire an Employee, Add Contingent Worker, Add Contingent Worker Relationship, Add Nonworker, Add Pending Worker, Add Nonworker Relationship) |
Rehire Headcount | Headcount of all assignment rehire events, Action type in (Rehire an Employee, Renew Placement) |
Pending Hire Headcount | Sum of headcount of pending hire worker type |
Promotion Headcount | Headcount of all assignment promotion events, Action Type in (Promote) |
Transfer Headcount | Headcount of all assignment transfer events, Action Type in (Transfer) |
Termination Headcount | Headcount of all assignment termination, Action Type in (Terminate Work Relationship) |
Inactive Headcount | Headcount of all workers with 'Inactive' assignment status |
Inactive Employee Headcount | Headcount of all Employee with 'Inactive' assignment status |
Inactive Contingent Headcount | Headcount of all Contingent Workers with 'Inactive' assignment status |
Assignment Event FTE | FTE value of all HR events during the period. |
Hire FTE | FTE of all assignment hire events, Action type in (Add Employee Work Relationship, Hire an Employee, Rehire an Employee, Add Contingent Worker, Add Contingent Worker Relationship, Add Nonworker, Add Pending Worker, Add Nonworker Relationship) |
Rehire FTE | FTE of all assignment rehire events, Action type in (Rehire an Employee, Renew Placement) |
Pending Hire FTE | FTE of pending hire worker type |
Promotion FTE | FTE of worker assignment promotion events. |
Transfer FTE | FTE of worker assignment transfer events. |
Termination FTE | FTE of worker assignment terminations. |
Inactive FTE | FTE of inactive worker assignments for all types of worker. |
Inactive Employee FTE | FTE of inactive employees. |
Inactive Contingent FTE | FTE of inactive contingent workers. |
Hire Count | Count of worker assignment hire events. |
Rehire Count | Count of rehires. |
Pending Hire Count | Count of pending hires. |
Promotion Count | Count of worker assignment promotion events during the period. |
Termination Count | Count of worker assignment terminations. |
Voluntary Termination Headcount | Headcount of all Voluntary Terminations. |
Involuntary Termination Headcount | Headcount of all Inoluntary Terminations. |
New Hire Termination Headcount | Headcount of Terminations of workers with Years Service is <- 1 year |
High Performer Headcount Turnover | Percentage of headcount terminations of workers that are rated as high performers. |
Voluntary Termination FTE | FTE of all Voluntary Terminations. |
Involuntary Termination FTE | FTE of all Inoluntary Terminations. |
New Hire Termination FTE | FTE of Terminations of workers with Years Service is <= 1 year |
Voluntary Termination Count | Count of worker assignment terminations with an action category of voluntary. |
Involuntary Termination Count | Count of worker assignment terminations with an action category of inoluntary. |
New Hire Termination Count | Count of worker assignment terminations whose years service is <= one year on their termination date. |
Time Between Promotion | Average number of months between promotions for a worker. |
Time Between Promotion on Event | Average number of months between promotions for a worker. . |
Promotion Headcount Rate | Percentage of headcount promotion for the time period. |
Promotion FTE Rate | Percentage of FTE promotion for the time period. |
Worker Male Gender Ratio | Percentage of male workers. |
Worker Female Gender Ratio | Percentage of female workers. |
Worker Non Gender Ratio | Percentage of workers with no gender specified. |
Years Service | Number of years worker is in service from the legal employer seniority date (or legal employer hire date if the seniority date is null) to the termination date (or current date if the termination date is null). |
Average Service Years | Average of years of service. |
Incumbent Headcount | Headcount of Position Incumbents. |
Incumbent FTE | FTE of Position Incumbents. |
Salary | Annualised salary for the worker assignment in the enterprise currency. |
Calculated Compa Ratio | Ratio of the worker salary to the salary mid point defined for the grade. |
Salary on Event | Annualised salary for the worker assignment in the enterprise currency on the date of any assignment event. |
Calculated Compa Ratio on Event | Ratio of the worker salary to the salary mid point defined for the grade on the date of any assignment event. |
Performance Rating | Average of the numeric value of the manager performance rating. |
Performance Rating (on Assignment Event) | Average of the numeric value of the manager performance rating on the date of any assignment event. |
Potential Rating | Average of the numeric value of the potential rating. |
Potential Rating (on Assignment Event) | Average of the numeric value of the potential rating on the date of any assignment event. |
Headcount (Period Start) | Total headcount at the start of the period, such as year, quarter, month, or week. |
Headcount (Period End) | Total headcount at the end of the period, such as year, quarter, month, or week. |
FTE (Period Start) | Total FTE at the Start of the period, such as year, quarter, month, or week. |
FTE (Period End) | Total FTE at the end of the period, such as year, quarter, month, or week. |
Person Count (Period Start) | Total person count at the start of the period, such as year, quarter, month, or week. |
Person Count (Period End) | Total person count at the end of the period, such as year, quarter, month, or week. |
Headcount | Headcount of active and suspended worker assignments for all types of worker. |
Employee Headcount | Headcount of active and suspended employees. |
Contingent Headcount | Headcount of active and suspended contingent workers. |
Active Headcount | Active worker headcount as of the time period. |
FTE | FTE of active and suspended worker assignments for all types of worker. |
Employee FTE | FTE of active and suspended employees. |
Contingent Worker FTE | FTE of active and suspended contingent workers. |
Assignment Count | Assignment count as of the time period (1 for each assignment) |
Assignment Event Count | Assignment event count as of the time period. one for each assignment. |
Top Talent Headcount Turnover | Percentage of headcount terminations of workers whose performance rating and potential rating is high. |
High Performer Headcount Retention | Percentage of headcount retention of workers that are rated as high performers. |
Talent Retention Percentage | Percentage of workers retained by each combination of performance and potential band ratings related to the 9 box. |
New Hire FTE Turnover | Percentage of FTE terminations where years of service < 1 year. |
High Performer FTE Turnover | Percentage of FTE terminations of workers whose performance rating = high. |
High Performer FTE Retention | Percentage of FTE retention of workers whose performance rating = high. |
Retention Voluntary | Percentage of voluntary retention of workers. |
Top Performer Headcount | Sum (headcount) of workers whose performance rating = high. |
High Potential Headcount | Percentage of headcount of workers with potential rating as 'High'. |
Manager Count | Count of all workers with at least one direct report. |
Active Headcount Ratio | Headcount ratio of active against all workers. |
Top Talent Ratio | Ratio of workers with performance = high and potential rating = high to the total headcount. |
Low Talent Ratio | Ratio of workers with performance = high and potential rating = low to the total headcount. |
Top Talent Headcount | Headcount of workers with performance = high and potential rating = high. |
Top Talent Retention Percentage | Percentage of workers retained by various combinations of performance and potential ratings. |
High Performer Retention Percentage | Percentage of Workers retained with Performance Rating as 'High' |
High Potential Retention Percentage | Percentage of Workers Retained with potential rating as 'High' |
New Hire Headcount | Headcount for all workers with years of service <= 1 |
Transfer Count | Count of worker assignment transfers. |
Percentage of Workers Hired Above 60 | Percentage of hires where worker age >= 60 years. |
High Performer Termination Headcount | Headcount of worker assignment terminations with performance rating as 'High' |
Top Talent Termination Headcount | Headcount of terminated workers with performance and potential rating = high. |
High Performer Termination FTE | FTE of worker assignment Terminations with performance rating as 'High' |
High Performer Termination Count | Count of worker assignment terminations where the workers latest performance rating based on the date for both performance and potential prior to the termination was in the high performance band. |
Annualized Voluntary Retention | Percentage of worker annual voluntary retention by Gregorian calendar. |
YTD Voluntary Termination Count | Year-to-date voluntary termination count. |
QTD Voluntary Termination Count | Quarter-to-date voluntary termination count. |
Distinct Worker Nationalities | Count of distinct worker nationalities. |
Distinct Worker Ethnicities | Count of distinct worker ethnicities. |
Months Service | Number of months the worker is in service from the legal employer seniority date (or legal employer hire date if the seniority date is null) to the termination date (or current date if the termination date is null). |
Average Service Months | Average of months service. |
Currency Code | Currency code. |
Percentage Compa Ratio Change | Percentage of change in compa ratio of the worker. |
Assignment Count (Period Start) | Assignment count at the period start (year, month, quarter and week). |
Assignment Count (Period End) | Assignment count at the period end (year, month, quarter and week). |
Employee Count | Count of active and suspended employees. |
Contingent Count | Count of active and suspended contingent workers. |
Active Worker Count | Count of active workers for all type of worker |
Active Worker Ratio | Ratio of active workers against total workers. |
Average Worker Count | Average Worker Count for the time period |
Employee Ratio | Ratio of employees against total workers |
Contingent Ratio | Ratio of contingent workers against total workers |
Worker Turnover | Provides the percentage of terminations |
Voluntary Turnover | Provides the percentage of the voluntary terminations. |
Involuntary Turnover | Provides the percentage of the involuntary terminations. |
New Hire Turnover | Provides the percentage of terminations of workers whose years of service less than 1 year |
High Performer Turnover | Provides the percentage of terminations of workers that are rated as high performers |
Top Talent Turnover | Provides the percentage of terminations of workers that are rated as high performers and also high potential. |
Worker Retention | Provides the percentage of worker retention |
New Hire Retention | Provides the percentage of new hire worker retention |
Retention Voluntary (Worker Count) | Provides the count of voluntary retention of workers. |
High Performer Retention | Provides the count of high performers retention |
Talent Retention Percentage (Worker Count) | Percentage of workers retained by each combination of performance and potential band ratings related to the 9 box. |
Top Talent Worker Count | Provides the count of workers with performance = high and potential rating = high. |
Top Talent Ratio (Worker Count) | Provides the ratio of top talent workers against total workers |
Low Talent Ratio (Worker Count) | Provides the ratio of low talent workers against total workers |
High Performer Retention Percentage (Worker Count) | Provides the percentage of high performers workers retention |
High Potential Retention Percentage (Worker Count) | Provides the percentage of high potential workers retention. |
Top Talent Retention Percentage (Worker Count) | Provides the percentage of top talent workers retention |
Voluntary Termination Person Count | Provides the count of voluntary worker termination. |
Involuntary Termination Person Count | Provides the count of involuntary worker termination. |
New Hire Termination Person Count | Provides the count of terminated workers whose years of service is less than an year. |
High Performer Termination Person Count | Provides the count of terminated workers whose performance rating = High |
Top Talent Termination Person Count | Count of terminated workers whose performance rating = High and potential rating = high. |
YTD Voluntary Termination Person Count | Year-to-date Voluntary Termination Count. |
QTD Voluntary Termination Person Count | Quarter-to-date Voluntary Termination Count. |
Termination Count (Termination Date) | Count of worker terminations as of the actual termination date |
Voluntary Termination Count (Termination Date) | Count of worker voluntary terminations as of the actual termination |
Involuntary Termination Count (Termination Date) | Count of worker involuntary terminations as of the actual termination date |
Rolling 12 Months Termination Headcount | Provides the Rolling 12 Months Termination Headcount. |
Rolling 12 Months Termination Count | Provides the Rolling 12 Months count of terminations. |
Years of Service(V1 Enterprise Seniority) | Provides the years of service for the worker based on the V1 Enterprise seniority date |
Years of Service (Person Seniority) | Provides the years of service for the worker based on the Person seniority date. |
Global Transfer Count -Out | Provides the distinct count of global transfers that happened out of a legal employer |
Global Transfer Count - In | Provides the distinct count of global transfers that happened into a legal employer |
Months of Service(V1 Enterprise Seniority) | Provides the months of service for the worker based on the V1 Enterprise seniority date |
Years of Service(V1 LE Seniority) | Provides the years of service for the worker based on the V1 Legal Employer seniority date |
Months of Service(V1 LE Seniority) | Provides the months of service for the worker based on the V1 Legal Employer seniority date |
Computed Headcount | Computed Headcount based on worker's primary assignment of the primary work relationship. It will be 1 based on primary assignment of the worker's primary work relationship, if not it will be null. Note: This will help if the headcount column is not updated by the customers |
Distinct Worker Ethnicities - All | Provides the count of distinct ethnicities of a worker. |
High Potential | Provides the count of workers with potential rating = high |
Top Performer | Provides the count of workers with performance rating = high |
Current Headcount | Headcount of Active and Suspended worker assignments for all types of worker as of latest successful pipeline run date. |
Current FTE | FTE of Active and Suspended worker assignments for all types of worker as of latest successful pipeline run date. |
Current Worker Count | Worker count as of latest successful pipeline run date. |
Average Promotion Time (Days) | Number of Days between promotion event of a worker. |
Time Since Promotion (Days) | Number of Days since last promotion of a worker. |
Gender - Male Count | Count of distinct male workers. |
Gender - Female Count | Count of distinct female workers. |
Gender - Not Disclosed Count | Count of distinct non gender workers. |
Gender - Others Count | Count of distinct other gender workers. |
HCM—Workforce Gains and Losses
This table describes Workforce Gains and Losses metrics.
Metric | Metric Definition |
---|---|
Headcount Gain | Headcount gain. |
Headcount Gain Hire | Gain of Headcount due to hires. |
Headcount Gain Reorganisation Reason | Gain of Headcount due to reorganisations. |
Headcount Gain Reorganisation Action | Headcount increase due to the action types specified as reorganisations. |
Headcount Gain Global Transfer | Gain of Headcount due to Global Transfers. |
Headcount Gain Transfer | Gain of Headcount due to Transfers. |
Headcount Gain Promotion | Gain of Headcount due to Promotion. |
Headcount Gain Others | Gain of Headcount due to reasons other than hire, transfers, reorganisations and global transfers. |
Implicit Headcount Gain | Gain of headcount due to a manager which results in entire organization being transferred to a new manager. |
Headcount Movement | Headcount movement within the managers organization that results in no gain or loss for the respective manager. |
Headcount Loss | Headcount Loss. |
Headcount Loss Termination | Loss of Headcount due to Terminations. |
Headcount Loss Reorganisation Reason | Loss of Headcount due to reorganisations. |
Headcount Loss Reorganisation Action | Loss of Headcount due to the action types specified as reorganisations. |
Headcount Loss Global Transfer | Loss of Headcount due to Global Transfers. |
Headcount Loss Transfer | Loss of Headcount due to Transfers. |
Headcount Loss Promotion | Loss of Headcount due to Promotion. |
Headcount Loss Others | Loss of Headcount due to reasons other than terminations, transfers, reorganisations anf global transfers. |
Implicit Headcount Loss | Loss of headcount due to a manager which results in entire organization being transferred to a new manager. |
FTE Gain | Full-time equivalent Gain. |
FTE Gain Hire | Gain of full-time equivalency due to hires. |
FTE Gain Reorganisation Reason | Gain of full-time equivalency due to organisations. |
FTE Gain Reorganisation Action | Gain of full-time equivalency due to action types specified as organisations. |
FTE Gain Global Transfer | Gain of full-time equivalency due to Global Transfers. |
FTE Gain Transfer | Gain of full-time equivalency due to Transfers. |
FTE Gain Promotion | Gain of full-time equivalency due to Promotions. |
FTE Gain Others | Gain of full-time equivalency due to reasons other than hire, transfers, reorganisations and global transfers. |
Implicit FTE Gain | Gain of FTE due to change in manager which results in entire organization being transferred to a new manager. |
FTE Movement | FTE movement within the managers organization that results in no gain or loss for the manager. |
FTE Loss | Loss of full-time equivalency. |
FTE Loss Termination | Loss of full-time equivalency due to Terminations. |
FTE Loss Reorganisation Reason | Loss of full-time equivalency due to reorganisations. |
FTE Loss Reorganisation Action | Loss of full-time equivalency due to action types specified as organisations. |
FTE Loss Global Transfer | Loss of full-time equivalency due to Global Transfers. |
FTE Loss Transfer | Loss of full-time equivalency due to Transfers. |
FTE Loss Promotion | Loss of full-time equivalency due to Promotions. |
FTE Loss Others | Loss of full-time equivalency due to reasons other than terminations, transfers, reorganisations and global transfers. |
Implicit FTE Loss | Loss of FTE due to change in manager which results in entire organization being transferred to a new manager. |
Assignment Count Gain | Assignment Count Gain |
Assignment Count Gain Hire | Gain of Assignment Count due to hires. |
Assignment Count Gain Reorganisation Reason | Gain of Assignment Count due to reorganisations. |
Assignment Count Gain Reorganisation Action | Gain of Assignment Count due to action types specified as organisations. |
Assignment Count Gain Global Transfer | Gain of Assignment Count due to Global Transfers. |
Assignment Count Gain Transfer | Gain of Assignment Count due to Transfers. |
Assignment Count Gain Promotion | Gain of Assignment Count due to Promotions. |
Assignment Count Gain Others | Gain of Assignment Count due to reasons other than hire, transfers, reorganisations and global transfers. |
Implicit Assignent Count Gain | Gain of Assignment due to change in manager which results in entire organization being transferred to a new manager. |
Assignment Count Movement | Assignment movement within the manager's organization that results in no gain or loss for the manager. |
Assignment Count Loss | Loss of Assignment Count. |
Assignment Count Loss Termination | Loss of Assignment Count due to Terminations. |
Assignment Count Loss Reorganisation Reason | Loss of Assignment Count due to reorganisations. |
Assignment Count Loss Reorganisation Action | Loss of Assignment Count due to action types specified as organisations. |
Assignment Count Loss Global Transfer | Loss of Assignment Count due to Global Transfers. |
Assignment Count Loss Transfer | Loss of Assignment Count due to Transfers. |
Assignment Count Loss Promotion | Loss of Assignment Count due to Promotions. |
Assignment Count Loss Others | Loss of Assignment Count due to reasons other than terminations, transfers, reorganisations and global transfers. |
Implicit Assignment Count Loss | Loss of Assignment due to change in manager which results in entire organization being transferred to a new manager. |
Person Count Gain | Person Count Gain. |
Person Count Gain Hire | Gain of Person Count due to hires. |
Person Count Gain Reorganisation Reason | Gain of Person Count due to reorganisations. |
Person Count Gain Reorganisation Action | Gain of Person Count due to action types specified as organisations. |
Person Count Gain Global Transfer | Gain of Person Count due to Global Transfers. |
Person Count Gain Transfer | Gain of Person Count due to Transfers. |
Person Count Gain Promotion | Gain of Person Count due to Promotion . |
Person Count Gain Others | Gain of Person Count due to reasons other than hire, transfers, reorganisations and global transfers. |
Implicit Person Count Gain | Gain of Person due to change in manager which results in entire organization being transferred to a new manager. |
Person Count Movement | Person movement within the manager's organization that results in no gain or loss for the manager. |
Person Count Loss | Loss of Person Count. |
Person Count Loss Termination | Loss of Person Count due to Terminations . |
Person Count Loss Reorganisation Reason | Loss of Person Count due to reorganisations. |
Person Count Loss Reorganisation Action | Loss of Person Count due to action types specified as organisations. |
Person Count Loss Global Transfer | Loss of Person Count due to Global Transfers. |
Person Count Loss Transfer | Loss of Person Count due to Transfers. |
Person Count Loss Promotion | Loss of Person Count due to Promotion . |
Person Count Loss Others | Loss of Person Count due to reasons other than terminations, transfers, reorganisations and global transfers. |
Implicit Person Count Loss | Loss of Person Count due to change in manager which results in entire organization being transferred to a new manager. |
HCM - Workforce Rewards - Payroll Balances
This table describes HCM - Workforce Rewards - Payroll Balances metrics.
Metric | Metric Definition |
---|---|
Balance Value | Balance Value |
Supplemental Earnings | Sum( Balance Value) where Base Category Name=‘Supplemental Earnings’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and UOM='Money' |
Standard Earnings | Sum( Balance Value) where Base Category Name=‘Earnings’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and UOM='Money' |
Pre-statutory Deductions | Sum ( Balance Value) Where Base Category=‘Pre-Statutory Deductions’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and UOM='Money' |
Voluntary Deductions | Sum ( Balance Value) Where Base Category=‘Voluntary Deductions’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and UOM='Money' |
Employee Tax Credit | Sum ( Balance Value) Where Base Category=‘Employee Tax Credits’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and UOM='Money' |
Miscellaneous | Sum ( Balance Value) Where Base Category=‘Miscellaneous’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and UOM='Money' |
Involuntary Deductions | Sum ( Balance Value) Where Base Category=‘Involuntary Deductions’ and UOM='Money' and Base Dimension Name= (‘Core Relationship Reference Code Run’,‘Core Relationship Tax Unit, Reference Code Run’,‘Core Relationship Tax Unit, Third Party Payee, Reference Code Run’,‘Core Relationship Tax Unit, Third Party Payee Run’,‘Core Relationship Tax Unit, Area1, Reference Code Run’,‘Core Relationship Tax Unit, Reference Code1,2 Run’,‘Core Relationship Tax Unit, Third Party Payee, Reference Code1,2 Run’,‘Core Relationship Third Party Payee, Reference Code Run’,‘Core Relationship Reference Code1,2 Run’,‘Core Relationship Area1, Reference Code Run’,‘Core Relationship Third Party Payee, Reference Code1,2 Run’,‘Core Relationship Tax Unit Run’) and Country Code='US' |
Tax Deductions | Sum ( Balance Value) Where Base Category=‘Tax Deductions’ and UOM='Money' and Base Dimension Name In (‘Core Relationship Tax Unit,Area1 Run’,‘Core Relationship Tax Unit,Area1,2 Run’,‘Core Relationship Tax Unit,Area1,2,3 Run’,‘Core Relationship Tax Unit Run’,‘Core Relationship Tax Unit,Area1,4 Run’) and Country Code='US' |
Employer Charges | Sum ( Balance Value) Where Base Category=‘Employer Charges’ and UOM='Money' and Base Dimension Name In (‘Core Relationship Tax Unit,Area1 Run’, ‘Core Relationship Tax Unit,Area1,2 Run’, ‘Core Relationship Tax Unit,Area1,2,3 Run’, ‘Core Relationship Tax Unit Run’, ‘Core Relationship Tax Unit,Area1,4 Run’) and Country Code='US' |
Employer Taxes | Sum ( Balance Value) Where Base Category=Employer Taxes’ and and UOM='Money' and Base Dimension Name In (‘Core Relationship Tax Unit,Area1 Run’,‘Core Relationship Tax Unit,Area1,2 Run’,‘Core Relationship Tax Unit,Area1,2,3 Run’,‘Core Relationship Tax Unit Run’,‘Core Relationship Tax Unit,Area1,4 Run’) and Country Code='US' |
Direct Payments | Sum ( Balance Value) Where Base Category=‘Direct Payments’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and and UOM='Money' |
Standard Earning (YTD) | Year to Date Value of Standard Earning |
Supplemental Earnings (YTD) | Year to Date Value of Supplemental Earnings |
Pre-statutory Deductions (YTD) | Year to Date Value of Pre-statutory Deductions |
Voluntary Deductions (YTD) | Year to Date Value of Voluntary Deductions |
Employee Tax Credit (YTD ) | Year to Date Value of Employee Tax Credit |
Miscellaneous (YTD ) | Year to Date Value of Miscellaneous |
Involuntary Deductions ( YTD) | Year to Date Value of Involuntary Deductions |
Tax Deductions ( YTD) | Year to Date Value of Tax Deductions |
Employer Charges(YTD) | Year to Date Value of Employer Charges |
Direct Payments (YTD) | Year to Date Value of Direct Payments |
Standard Earning (QTD) | Quarter to Date Value of Standard Earning |
Supplemental Earnings (QTD) | Quarter to Date Value of Supplemental Earnings |
Pre-statutory Deductions (QTD) | Quarter to Date Value of Pre-statutory Deductions |
Voluntary Deductions (QTD) | Quarter to Date Value of Voluntary Deductions |
Employee Tax Credit (QTD) | Quarter to Date Value of Employee Tax Credit |
Miscellaneous (QTD) | Quarter to Date Value of Miscellaneous |
Involuntary Deductions (QTD) | Quarter to Date Value of Involuntary Deductions |
Tax Deductions (QTD) | Quarter to Date Value of Tax Deductions |
Employer Charges(QTD) | Quarter to Date Value of Employer Charges |
Direct Payments (QTD) | Quarter to Date Value of Direct Payments |
Standard Earning (MTD) | Month To Date Value of Standard Earning |
Supplemental Earnings (MTD) | Month To Date Value of Supplemental Earning |
Pre-statutory Deductions (MTD) | Month To Date Value of Pre-statutory Deductions |
Voluntary Deductions (MTD) | Month To Date Value of Voluntary Deductions |
Employee Tax Credit (MTD) | Month To Date Value of Employee Tax Credit |
Miscellaneous (MTD) | Month To Date Value of Miscellaneous |
Involuntary Deductions (MTD) | Month To Date Value of Involuntary Deductions |
Tax Deductions (MTD) | Month To Date Value of Tax Deductions |
Employer Charges(MTD) | Month To Date Value of Employer Charges |
Direct Payments (MTD) | Month To Date Value of Direct Payments |
Balance Value (MTD) | Month to Date Balance Value |
Balance Value ( QTD) | Quarter to Date Balance Value |
Balance Value ( YTD) | Year to Date Balance Value |
Balance Value Period Ago | Balance Value Period Ago |
Balance Value Variance | Balance Value Variance |
Balance Value Growth Rate | Balance Value Growth Rate |
Employer Taxes ( YTD) | Year to Date Employer Taxes |
Employer Taxes ( QTD) | Quarter to Date Employer Taxes |
Employer Taxes ( MTD) | Month to Date Employer Taxes |
Standard Earnings Period Ago | Standard Earnings Period Ago |
Supplemental Earnings Period Ago | Supplemental Earnings Period Ago |
Miscellaneous Period Ago | Miscellaneous Period Ago |
Pre-Statutory Deductions Period Ago | Pre-Statutory Deductions Period Ago |
Involuntary Deductions Period Ago | Involuntary Deductions Period Ago |
Voluntary Deductions Period Ago | Voluntary Deductions Period Ago |
Tax Deductions Period Ago | Tax Deductions Period Ago |
Employer Taxes Period Ago | Employer Taxes Period Ago |
Direct Payment Period Ago | Direct Payment Period Ago |
Employer Charges Period Ago | Employer Charges Period Ago |
Employee Tax Credits Period Ago | Employee Tax Credits Period Ago |
Standard Earnings Variance | Standard Earnings Variance |
Supplemental Earnings Variance | Supplemental Earnings Variance |
Miscellaneous Variance | Miscellaneous Variance |
Pre-Statutory Deductions Variance | Pre-Statutory Deductions Variance |
Involuntary Deductions Variance | Involuntary Deductions Variance |
Voluntary Deductions Variance | Voluntary Deductions Variance |
Tax Deductions Variance | Tax Deductions Variance |
Employer Taxes Variance | Employer Taxes Variance |
Direct Payment Variance | Direct Payment Variance |
Employer Charges Variance | Employer Charges Variance |
Employee Tax Credits Variance | Employee Tax Credits Variance |
Standard Earnings Growth Rate | Standard Earnings Growth Rate |
Supplemental Earnings Growth Rate | Supplemental Earnings Growth Rate |
Miscellaneous Growth Rate | Miscellaneous Growth Rate |
Pre-Statutory Deductions Growth Rate | Pre-Statutory Deductions Growth Rate |
Involuntary Deductions Growth Rate | Involuntary Deductions Growth Rate |
Voluntary Deductions Growth Rate | Voluntary Deductions Growth Rate |
Tax Deductions Growth Rate | Tax Deductions Growth Rate |
Employer Taxes Growth Rate | Employer Taxes Growth Rate |
Direct Payment Growth Rate | Direct Payment Growth Rate |
Employer Charges Growth Rate | Employer Charges Growth Rate |
Employee Tax Credits Growth Rate | Employee Tax Credits Growth Rate |
Total Earning | Sum of Standard And Supplemental Earning balances |
Total Earning Variance | Total Earning Variance |
Total Earning Growth Rate | Total Earning Growth Rate |
Worker Count | Count of workers processed |
Worker Count Variance | Variance of worker processed |
Worker Count Period Ago | Worker count processed (Period Ago) |
Worker Count Growth Rate | Worker Count Processed (Growth Rate) |
Analytical Currency- Supplemental Earnings | Sum( Balance Value) where Base Category Name=‘Supplemental Earnings’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and UOM='Money' |
Analytical Currency- Standard Earnings | Sum( Balance Value) where Base Category Name=‘Earnings’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and UOM='Money' |
Analytical Currency- Analytical Currency- Pre-statutory Deductions | Sum ( Balance Value) Where Base Category=‘Pre-Statutory Deductions’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and UOM='Money' |
Analytical Currency- Analytical Currency- Voluntary Deductions | Sum ( Balance Value) Where Base Category=‘Voluntary Deductions’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and UOM='Money' |
Analytical Currency- Employee Tax Credit | Sum ( Balance Value) Where Base Category=‘Employee Tax Credits’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and UOM='Money' |
Analytical Currency- Miscellaneous | Sum ( Balance Value) Where Base Category=‘Miscellaneous’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and UOM='Money' |
Analytical Currency- Involuntary Deductions | Sum ( Balance Value) Where Base Category=‘Involuntary Deductions’ and UOM='Money' and Base Dimension Name= (‘Core Relationship Reference Code Run’,‘Core Relationship Tax Unit, Reference Code Run’,‘Core Relationship Tax Unit, Third Party Payee, Reference Code Run’,‘Core Relationship Tax Unit, Third Party Payee Run’,‘Core Relationship Tax Unit, Area1, Reference Code Run’,‘Core Relationship Tax Unit, Reference Code1,2 Run’,‘Core Relationship Tax Unit, Third Party Payee, Reference Code1,2 Run’,‘Core Relationship Third Party Payee, Reference Code Run’,‘Core Relationship Reference Code1,2 Run’,‘Core Relationship Area1, Reference Code Run’,‘Core Relationship Third Party Payee, Reference Code1,2 Run’,‘Core Relationship Tax Unit Run’) and Country Code='US' |
Analytical Currency- Tax Deductions | Sum ( Balance Value) Where Base Category=‘Tax Deductions’ and UOM='Money' and Base Dimension Name In (‘Core Relationship Tax Unit,Area1 Run’,‘Core Relationship Tax Unit,Area1,2 Run’,‘Core Relationship Tax Unit,Area1,2,3 Run’,‘Core Relationship Tax Unit Run’,‘Core Relationship Tax Unit,Area1,4 Run’) and Country Code='US' |
Analytical Currency- Employer Charges | Sum ( Balance Value) Where Base Category=‘Employer Charges’ and UOM='Money' and Base Dimension Name In (‘Core Relationship Tax Unit,Area1 Run’, ‘Core Relationship Tax Unit,Area1,2 Run’, ‘Core Relationship Tax Unit,Area1,2,3 Run’, ‘Core Relationship Tax Unit Run’, ‘Core Relationship Tax Unit,Area1,4 Run’) and Country Code='US' |
Analytical Currency- Employer Taxes | Sum ( Balance Value) Where Base Category=Employer Taxes’ and and UOM='Money' and Base Dimension Name In (‘Core Relationship Tax Unit,Area1 Run’,‘Core Relationship Tax Unit,Area1,2 Run’,‘Core Relationship Tax Unit,Area1,2,3 Run’,‘Core Relationship Tax Unit Run’,‘Core Relationship Tax Unit,Area1,4 Run’) and Country Code='US' |
Analytical Currency- Direct Payments | Sum ( Balance Value) Where Base Category=‘Direct Payments’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and and UOM='Money' |
Analytical Currency- Standard Earning (YTD) | Year to Date Value of Standard Earning |
Analytical Currency- Supplemental Earnings (YTD) | Year to Date Value of Supplemental Earnings |
Analytical Currency- Pre-statutory Deductions (YTD) | Year to Date Value of Pre-statutory Deductions |
Analytical Currency- Voluntary Deductions (YTD) | Year to Date Value of Voluntary Deductions |
Analytical Currency- Employee Tax Credit (YTD ) | Year to Date Value of Employee Tax Credit |
Analytical Currency- Miscellaneous (YTD ) | Year to Date Value of Miscellaneous |
Analytical Currency- Involuntary Deductions ( YTD) | Year to Date Value of Involuntary Deductions |
Analytical Currency- Tax Deductions ( YTD) | Year to Date Value of Tax Deductions |
Analytical Currency- Employer Charges(YTD) | Year to Date Value of Employer Charges |
Analytical Currency- Direct Payments (YTD) | Year to Date Value of Direct Payments |
Analytical Currency- Standard Earning (QTD) | Quarter to Date Value of Standard Earning |
Analytical Currency- Supplemental Earnings (QTD) | Quarter to Date Value of Supplemental Earnings |
Analytical Currency- Pre-statutory Deductions (QTD) | Quarter to Date Value of Pre-statutory Deductions |
Analytical Currency- Voluntary Deductions (QTD) | Quarter to Date Value of Voluntary Deductions |
Analytical Currency- Employee Tax Credit (QTD) | Quarter to Date Value of Employee Tax Credit |
Analytical Currency- Miscellaneous (QTD) | Quarter to Date Value of Miscellaneous |
Analytical Currency- Involuntary Deductions (QTD) | Quarter to Date Value of Involuntary Deductions |
Analytical Currency- Tax Deductions (QTD) | Quarter to Date Value of Tax Deductions |
Analytical Currency- Employer Charges(QTD) | Quarter to Date Value of Employer Charges |
Analytical Currency- Direct Payments (QTD) | Quarter to Date Value of Direct Payments |
Analytical Currency- Standard Earning (MTD) | Month To Date Value of Standard Earning |
Analytical Currency- Supplemental Earnings (MTD) | Month To Date Value of Supplemental Earning |
Analytical Currency- Pre-statutory Deductions (MTD) | Month To Date Value of Pre-statutory Deductions |
Analytical Currency- Voluntary Deductions (MTD) | Month To Date Value of Voluntary Deductions |
Analytical Currency- Employee Tax Credit (MTD) | Month To Date Value of Employee Tax Credit |
Analytical Currency- Miscellaneous (MTD) | Month To Date Value of Miscellaneous |
Analytical Currency- Involuntary Deductions (MTD) | Month To Date Value of Involuntary Deductions |
Analytical Currency- Tax Deductions (MTD) | Month To Date Value of Tax Deductions |
Analytical Currency- Employer Charges(MTD) | Month To Date Value of Employer Charges |
Analytical Currency- Direct Payments (MTD) | Month To Date Value of Direct Payments |
Analytical Currency- Balance Value (MTD) | Month to Date Balance Value |
Analytical Currency- Balance Value ( QTD) | Quarter to Date Balance Value |
Analytical Currency- Balance Value ( YTD) | Year to Date Balance Value |
Analytical Currency- Balance Value Period Ago | Balance Value Period Ago |
Analytical Currency- Balance Value Variance | Balance Value Variance |
Analytical Currency- Balance Value Growth Rate | Balance Value Growth Rate |
Analytical Currency- Employer Taxes ( YTD) | Year to Date Employer Taxes |
Analytical Currency- Employer Taxes ( QTD) | Quarter to Date Employer Taxes |
Analytical Currency- Employer Taxes ( MTD) | Month to Date Employer Taxes |
Analytical Currency- Standard Earnings Period Ago | Standard Earnings Period Ago |
Analytical Currency- Supplemental Earnings Period Ago | Supplemental Earnings Period Ago |
Analytical Currency- Miscellaneous Period Ago | Miscellaneous Period Ago |
Analytical Currency- Pre-Statutory Deductions Period Ago | Pre-Statutory Deductions Period Ago |
Analytical Currency- Involuntary Deductions Period Ago | Involuntary Deductions Period Ago |
Analytical Currency- Voluntary Deductions Period Ago | Voluntary Deductions Period Ago |
Analytical Currency- Tax Deductions Period Ago | Tax Deductions Period Ago |
Analytical Currency- Employer Taxes Period Ago | Employer Taxes Period Ago |
Analytical Currency- Direct Payment Period Ago | Direct Payment Period Ago |
Analytical Currency- Employer Charges Period Ago | Employer Charges Period Ago |
Analytical Currency- Employee Tax Credits Period Ago | Employee Tax Credits Period Ago |
Analytical Currency- Standard Earnings Variance | Standard Earnings Variance |
Analytical Currency- Supplemental Earnings Variance | Supplemental Earnings Variance |
Analytical Currency- Miscellaneous Variance | Miscellaneous Variance |
Analytical Currency- Pre-Statutory Deductions Variance | Pre-Statutory Deductions Variance |
Analytical Currency- Involuntary Deductions Variance | Involuntary Deductions Variance |
Analytical Currency- Voluntary Deductions Variance | Voluntary Deductions Variance |
Analytical Currency- Tax Deductions Variance | Tax Deductions Variance |
Analytical Currency- Employer Taxes Variance | Employer Taxes Variance |
Analytical Currency- Direct Payment Variance | Direct Payment Variance |
Analytical Currency- Employer Charges Variance | Employer Charges Variance |
Analytical Currency- Employee Tax Credits Variance | Employee Tax Credits Variance |
Analytical Currency- Standard Earnings Growth Rate | Standard Earnings Growth Rate |
Analytical Currency- Supplemental Earnings Growth Rate | Supplemental Earnings Growth Rate |
Analytical Currency- Miscellaneous Growth Rate | Miscellaneous Growth Rate |
Analytical Currency- Pre-Statutory Deductions Growth Rate | Pre-Statutory Deductions Growth Rate |
Analytical Currency- Involuntary Deductions Growth Rate | Involuntary Deductions Growth Rate |
Analytical Currency- Voluntary Deductions Growth Rate | Voluntary Deductions Growth Rate |
Analytical Currency- Tax Deductions Growth Rate | Tax Deductions Growth Rate |
Analytical Currency- Employer Taxes Growth Rate | Employer Taxes Growth Rate |
Analytical Currency- Direct Payment Growth Rate | Direct Payment Growth Rate |
Analytical Currency- Employer Charges Growth Rate | Employer Charges Growth Rate |
Analytical Currency- Employee Tax Credits Growth Rate | Employee Tax Credits Growth Rate |
Analytical Currency- Total Earning | Sum of Standard And Supplemental Earning balances |
Analytical Currency- Total Earning Variance | Total Earning Variance |
Analytical Currency- Total Earning Growth Rate | Total Earning Growth Rate |
HCM - Workforce Rewards - Payroll Balances (Monthly)
This table describes HCM - Workforce Rewards - Payroll Balances metrics.
Metric | Metric Definition |
---|---|
Balance Value | Balance Value |
Supplemental Earnings | Sum( Balance Value) where Base Category Name=‘Supplemental Earnings’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and UOM='Money' |
Standard Earnings | Sum( Balance Value) where Base Category Name=‘Earnings’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and UOM='Money' |
Pre-statutory Deductions | Sum ( Balance Value) Where Base Category=‘Pre-Statutory Deductions’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and UOM='Money' |
Voluntary Deductions | Sum ( Balance Value) Where Base Category=‘Voluntary Deductions’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and UOM='Money' |
Employee Tax Credit | Sum ( Balance Value) Where Base Category=‘Employee Tax Credits’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and UOM='Money' |
Miscellaneous | Sum ( Balance Value) Where Base Category=‘Miscellaneous’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and UOM='Money' |
Involuntary Deductions | Sum ( Balance Value) Where Base Category=‘Involuntary Deductions’ and UOM='Money' and Base Dimension Name= (‘Core Relationship Reference Code Run’,‘Core Relationship Tax Unit, Reference Code Run’,‘Core Relationship Tax Unit, Third Party Payee, Reference Code Run’,‘Core Relationship Tax Unit, Third Party Payee Run’,‘Core Relationship Tax Unit, Area1, Reference Code Run’,‘Core Relationship Tax Unit, Reference Code1,2 Run’,‘Core Relationship Tax Unit, Third Party Payee, Reference Code1,2 Run’,‘Core Relationship Third Party Payee, Reference Code Run’,‘Core Relationship Reference Code1,2 Run’,‘Core Relationship Area1, Reference Code Run’,‘Core Relationship Third Party Payee, Reference Code1,2 Run’,‘Core Relationship Tax Unit Run’) and Country Code='US' |
Tax Deductions | Sum ( Balance Value) Where Base Category=‘Tax Deductions’ and UOM='Money' and Base Dimension Name In (‘Core Relationship Tax Unit,Area1 Run’,‘Core Relationship Tax Unit,Area1,2 Run’,‘Core Relationship Tax Unit,Area1,2,3 Run’,‘Core Relationship Tax Unit Run’,‘Core Relationship Tax Unit,Area1,4 Run’) and Country Code='US' |
Employer Charges | Sum ( Balance Value) Where Base Category=‘Employer Charges’ and UOM='Money' and Base Dimension Name In (‘Core Relationship Tax Unit,Area1 Run’, ‘Core Relationship Tax Unit,Area1,2 Run’, ‘Core Relationship Tax Unit,Area1,2,3 Run’, ‘Core Relationship Tax Unit Run’, ‘Core Relationship Tax Unit,Area1,4 Run’) and Country Code='US' |
Employer Taxes | Sum ( Balance Value) Where Base Category=Employer Taxes’ and and UOM='Money' and Base Dimension Name In (‘Core Relationship Tax Unit,Area1 Run’,‘Core Relationship Tax Unit,Area1,2 Run’,‘Core Relationship Tax Unit,Area1,2,3 Run’,‘Core Relationship Tax Unit Run’,‘Core Relationship Tax Unit,Area1,4 Run’) and Country Code='US' |
Direct Payments | Sum ( Balance Value) Where Base Category=‘Direct Payments’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and and UOM='Money' |
Standard Earning (YTD) | Year to Date Value of Standard Earning |
Supplemental Earnings (YTD) | Year to Date Value of Supplemental Earnings |
Pre-statutory Deductions (YTD) | Year to Date Value of Pre-statutory Deductions |
Voluntary Deductions (YTD) | Year to Date Value of Voluntary Deductions |
Employee Tax Credit (YTD ) | Year to Date Value of Employee Tax Credit |
Miscellaneous (YTD ) | Year to Date Value of Miscellaneous |
Involuntary Deductions ( YTD) | Year to Date Value of Involuntary Deductions |
Tax Deductions ( YTD) | Year to Date Value of Tax Deductions |
Employer Charges(YTD) | Year to Date Value of Employer Charges |
Direct Payments (YTD) | Year to Date Value of Direct Payments |
Standard Earning (QTD) | Quarter to Date Value of Standard Earning |
Supplemental Earnings (QTD) | Quarter to Date Value of Supplemental Earnings |
Pre-statutory Deductions (QTD) | Quarter to Date Value of Pre-statutory Deductions |
Voluntary Deductions (QTD) | Quarter to Date Value of Voluntary Deductions |
Employee Tax Credit (QTD) | Quarter to Date Value of Employee Tax Credit |
Miscellaneous (QTD) | Quarter to Date Value of Miscellaneous |
Involuntary Deductions (QTD) | Quarter to Date Value of Involuntary Deductions |
Tax Deductions (QTD) | Quarter to Date Value of Tax Deductions |
Employer Charges(QTD) | Quarter to Date Value of Employer Charges |
Direct Payments (QTD) | Quarter to Date Value of Direct Payments |
Standard Earning (MTD) | Month To Date Value of Standard Earning |
Supplemental Earnings (MTD) | Month To Date Value of Supplemental Earning |
Pre-statutory Deductions (MTD) | Month To Date Value of Pre-statutory Deductions |
Voluntary Deductions (MTD) | Month To Date Value of Voluntary Deductions |
Employee Tax Credit (MTD) | Month To Date Value of Employee Tax Credit |
Miscellaneous (MTD) | Month To Date Value of Miscellaneous |
Involuntary Deductions (MTD) | Month To Date Value of Involuntary Deductions |
Tax Deductions (MTD) | Month To Date Value of Tax Deductions |
Employer Charges(MTD) | Month To Date Value of Employer Charges |
Direct Payments (MTD) | Month To Date Value of Direct Payments |
Balance Value (MTD) | Month to Date Balance Value |
Balance Value ( QTD) | Quarter to Date Balance Value |
Balance Value ( YTD) | Year to Date Balance Value |
Balance Value Period Ago | Balance Value Period Ago |
Balance Value Variance | Balance Value Variance |
Balance Value Growth Rate | Balance Value Growth Rate |
Employer Taxes ( YTD) | Year to Date Employer Taxes |
Employer Taxes ( QTD) | Quarter to Date Employer Taxes |
Employer Taxes ( MTD) | Month to Date Employer Taxes |
Standard Earnings Period Ago | Standard Earnings Period Ago |
Supplemental Earnings Period Ago | Supplemental Earnings Period Ago |
Miscellaneous Period Ago | Miscellaneous Period Ago |
Pre-Statutory Deductions Period Ago | Pre-Statutory Deductions Period Ago |
Involuntary Deductions Period Ago | Involuntary Deductions Period Ago |
Voluntary Deductions Period Ago | Voluntary Deductions Period Ago |
Tax Deductions Period Ago | Tax Deductions Period Ago |
Employer Taxes Period Ago | Employer Taxes Period Ago |
Direct Payment Period Ago | Direct Payment Period Ago |
Employer Charges Period Ago | Employer Charges Period Ago |
Employee Tax Credits Period Ago | Employee Tax Credits Period Ago |
Standard Earnings Variance | Standard Earnings Variance |
Supplemental Earnings Variance | Supplemental Earnings Variance |
Miscellaneous Variance | Miscellaneous Variance |
Pre-Statutory Deductions Variance | Pre-Statutory Deductions Variance |
Involuntary Deductions Variance | Involuntary Deductions Variance |
Voluntary Deductions Variance | Voluntary Deductions Variance |
Tax Deductions Variance | Tax Deductions Variance |
Employer Taxes Variance | Employer Taxes Variance |
Direct Payment Variance | Direct Payment Variance |
Employer Charges Variance | Employer Charges Variance |
Employee Tax Credits Variance | Employee Tax Credits Variance |
Standard Earnings Growth Rate | Standard Earnings Growth Rate |
Supplemental Earnings Growth Rate | Supplemental Earnings Growth Rate |
Miscellaneous Growth Rate | Miscellaneous Growth Rate |
Pre-Statutory Deductions Growth Rate | Pre-Statutory Deductions Growth Rate |
Involuntary Deductions Growth Rate | Involuntary Deductions Growth Rate |
Voluntary Deductions Growth Rate | Voluntary Deductions Growth Rate |
Tax Deductions Growth Rate | Tax Deductions Growth Rate |
Employer Taxes Growth Rate | Employer Taxes Growth Rate |
Direct Payment Growth Rate | Direct Payment Growth Rate |
Employer Charges Growth Rate | Employer Charges Growth Rate |
Employee Tax Credits Growth Rate | Employee Tax Credits Growth Rate |
Total Earning | Sum of Standard And Supplemental Earning balances |
Total Earning Variance | Total Earning Variance |
Total Earning Growth Rate | Total Earning Growth Rate |
Worker Count | Count of workers processed |
Worker Count Variance | Variance of worker processed |
Worker Count Period Ago | Worker count processed (Period Ago) |
Worker Count Growth Rate | Worker Count Processed (Growth Rate) |
Analytical Currency- Supplemental Earnings | Sum( Balance Value) where Base Category Name=‘Supplemental Earnings’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and UOM='Money' |
Analytical Currency- Standard Earnings | Sum( Balance Value) where Base Category Name=‘Earnings’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and UOM='Money' |
Analytical Currency- Analytical Currency- Pre-statutory Deductions | Sum ( Balance Value) Where Base Category=‘Pre-Statutory Deductions’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and UOM='Money' |
Analytical Currency- Analytical Currency- Voluntary Deductions | Sum ( Balance Value) Where Base Category=‘Voluntary Deductions’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and UOM='Money' |
Analytical Currency- Employee Tax Credit | Sum ( Balance Value) Where Base Category=‘Employee Tax Credits’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and UOM='Money' |
Analytical Currency- Miscellaneous | Sum ( Balance Value) Where Base Category=‘Miscellaneous’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and UOM='Money' |
Analytical Currency- Involuntary Deductions | Sum ( Balance Value) Where Base Category=‘Involuntary Deductions’ and UOM='Money' and Base Dimension Name= (‘Core Relationship Reference Code Run’,‘Core Relationship Tax Unit, Reference Code Run’,‘Core Relationship Tax Unit, Third Party Payee, Reference Code Run’,‘Core Relationship Tax Unit, Third Party Payee Run’,‘Core Relationship Tax Unit, Area1, Reference Code Run’,‘Core Relationship Tax Unit, Reference Code1,2 Run’,‘Core Relationship Tax Unit, Third Party Payee, Reference Code1,2 Run’,‘Core Relationship Third Party Payee, Reference Code Run’,‘Core Relationship Reference Code1,2 Run’,‘Core Relationship Area1, Reference Code Run’,‘Core Relationship Third Party Payee, Reference Code1,2 Run’,‘Core Relationship Tax Unit Run’) and Country Code='US' |
Analytical Currency- Tax Deductions | Sum ( Balance Value) Where Base Category=‘Tax Deductions’ and UOM='Money' and Base Dimension Name In (‘Core Relationship Tax Unit,Area1 Run’,‘Core Relationship Tax Unit,Area1,2 Run’,‘Core Relationship Tax Unit,Area1,2,3 Run’,‘Core Relationship Tax Unit Run’,‘Core Relationship Tax Unit,Area1,4 Run’) and Country Code='US' |
Analytical Currency- Employer Charges | Sum ( Balance Value) Where Base Category=‘Employer Charges’ and UOM='Money' and Base Dimension Name In (‘Core Relationship Tax Unit,Area1 Run’, ‘Core Relationship Tax Unit,Area1,2 Run’, ‘Core Relationship Tax Unit,Area1,2,3 Run’, ‘Core Relationship Tax Unit Run’, ‘Core Relationship Tax Unit,Area1,4 Run’) and Country Code='US' |
Analytical Currency- Employer Taxes | Sum ( Balance Value) Where Base Category=Employer Taxes’ and and UOM='Money' and Base Dimension Name In (‘Core Relationship Tax Unit,Area1 Run’,‘Core Relationship Tax Unit,Area1,2 Run’,‘Core Relationship Tax Unit,Area1,2,3 Run’,‘Core Relationship Tax Unit Run’,‘Core Relationship Tax Unit,Area1,4 Run’) and Country Code='US' |
Analytical Currency- Direct Payments | Sum ( Balance Value) Where Base Category=‘Direct Payments’ and Base Dimension Name='Core Relationship Tax Unit Run' and Country Code='US' and and UOM='Money' |
Analytical Currency- Standard Earning (YTD) | Year to Date Value of Standard Earning |
Analytical Currency- Supplemental Earnings (YTD) | Year to Date Value of Supplemental Earnings |
Analytical Currency- Pre-statutory Deductions (YTD) | Year to Date Value of Pre-statutory Deductions |
Analytical Currency- Voluntary Deductions (YTD) | Year to Date Value of Voluntary Deductions |
Analytical Currency- Employee Tax Credit (YTD ) | Year to Date Value of Employee Tax Credit |
Analytical Currency- Miscellaneous (YTD ) | Year to Date Value of Miscellaneous |
Analytical Currency- Involuntary Deductions ( YTD) | Year to Date Value of Involuntary Deductions |
Analytical Currency- Tax Deductions ( YTD) | Year to Date Value of Tax Deductions |
Analytical Currency- Employer Charges(YTD) | Year to Date Value of Employer Charges |
Analytical Currency- Direct Payments (YTD) | Year to Date Value of Direct Payments |
Analytical Currency- Standard Earning (QTD) | Quarter to Date Value of Standard Earning |
Analytical Currency- Supplemental Earnings (QTD) | Quarter to Date Value of Supplemental Earnings |
Analytical Currency- Pre-statutory Deductions (QTD) | Quarter to Date Value of Pre-statutory Deductions |
Analytical Currency- Voluntary Deductions (QTD) | Quarter to Date Value of Voluntary Deductions |
Analytical Currency- Employee Tax Credit (QTD) | Quarter to Date Value of Employee Tax Credit |
Analytical Currency- Miscellaneous (QTD) | Quarter to Date Value of Miscellaneous |
Analytical Currency- Involuntary Deductions (QTD) | Quarter to Date Value of Involuntary Deductions |
Analytical Currency- Tax Deductions (QTD) | Quarter to Date Value of Tax Deductions |
Analytical Currency- Employer Charges(QTD) | Quarter to Date Value of Employer Charges |
Analytical Currency- Direct Payments (QTD) | Quarter to Date Value of Direct Payments |
Analytical Currency- Standard Earning (MTD) | Month To Date Value of Standard Earning |
Analytical Currency- Supplemental Earnings (MTD) | Month To Date Value of Supplemental Earning |
Analytical Currency- Pre-statutory Deductions (MTD) | Month To Date Value of Pre-statutory Deductions |
Analytical Currency- Voluntary Deductions (MTD) | Month To Date Value of Voluntary Deductions |
Analytical Currency- Employee Tax Credit (MTD) | Month To Date Value of Employee Tax Credit |
Analytical Currency- Miscellaneous (MTD) | Month To Date Value of Miscellaneous |
Analytical Currency- Involuntary Deductions (MTD) | Month To Date Value of Involuntary Deductions |
Analytical Currency- Tax Deductions (MTD) | Month To Date Value of Tax Deductions |
Analytical Currency- Employer Charges(MTD) | Month To Date Value of Employer Charges |
Analytical Currency- Direct Payments (MTD) | Month To Date Value of Direct Payments |
Analytical Currency- Balance Value (MTD) | Month to Date Balance Value |
Analytical Currency- Balance Value ( QTD) | Quarter to Date Balance Value |
Analytical Currency- Balance Value ( YTD) | Year to Date Balance Value |
Analytical Currency- Balance Value Period Ago | Balance Value Period Ago |
Analytical Currency- Balance Value Variance | Balance Value Variance |
Analytical Currency- Balance Value Growth Rate | Balance Value Growth Rate |
Analytical Currency- Employer Taxes ( YTD) | Year to Date Employer Taxes |
Analytical Currency- Employer Taxes ( QTD) | Quarter to Date Employer Taxes |
Analytical Currency- Employer Taxes ( MTD) | Month to Date Employer Taxes |
Analytical Currency- Standard Earnings Period Ago | Standard Earnings Period Ago |
Analytical Currency- Supplemental Earnings Period Ago | Supplemental Earnings Period Ago |
Analytical Currency- Miscellaneous Period Ago | Miscellaneous Period Ago |
Analytical Currency- Pre-Statutory Deductions Period Ago | Pre-Statutory Deductions Period Ago |
Analytical Currency- Involuntary Deductions Period Ago | Involuntary Deductions Period Ago |
Analytical Currency- Voluntary Deductions Period Ago | Voluntary Deductions Period Ago |
Analytical Currency- Tax Deductions Period Ago | Tax Deductions Period Ago |
Analytical Currency- Employer Taxes Period Ago | Employer Taxes Period Ago |
Analytical Currency- Direct Payment Period Ago | Direct Payment Period Ago |
Analytical Currency- Employer Charges Period Ago | Employer Charges Period Ago |
Analytical Currency- Employee Tax Credits Period Ago | Employee Tax Credits Period Ago |
Analytical Currency- Standard Earnings Variance | Standard Earnings Variance |
Analytical Currency- Supplemental Earnings Variance | Supplemental Earnings Variance |
Analytical Currency- Miscellaneous Variance | Miscellaneous Variance |
Analytical Currency- Pre-Statutory Deductions Variance | Pre-Statutory Deductions Variance |
Analytical Currency- Involuntary Deductions Variance | Involuntary Deductions Variance |
Analytical Currency- Voluntary Deductions Variance | Voluntary Deductions Variance |
Analytical Currency- Tax Deductions Variance | Tax Deductions Variance |
Analytical Currency- Employer Taxes Variance | Employer Taxes Variance |
Analytical Currency- Direct Payment Variance | Direct Payment Variance |
Analytical Currency- Employer Charges Variance | Employer Charges Variance |
Analytical Currency- Employee Tax Credits Variance | Employee Tax Credits Variance |
Analytical Currency- Standard Earnings Growth Rate | Standard Earnings Growth Rate |
Analytical Currency- Supplemental Earnings Growth Rate | Supplemental Earnings Growth Rate |
Analytical Currency- Miscellaneous Growth Rate | Miscellaneous Growth Rate |
Analytical Currency- Pre-Statutory Deductions Growth Rate | Pre-Statutory Deductions Growth Rate |
Analytical Currency- Involuntary Deductions Growth Rate | Involuntary Deductions Growth Rate |
Analytical Currency- Voluntary Deductions Growth Rate | Voluntary Deductions Growth Rate |
Analytical Currency- Tax Deductions Growth Rate | Tax Deductions Growth Rate |
Analytical Currency- Employer Taxes Growth Rate | Employer Taxes Growth Rate |
Analytical Currency- Direct Payment Growth Rate | Direct Payment Growth Rate |
Analytical Currency- Employer Charges Growth Rate | Employer Charges Growth Rate |
Analytical Currency- Employee Tax Credits Growth Rate | Employee Tax Credits Growth Rate |
Analytical Currency- Total Earning | Sum of Standard And Supplemental Earning balances |
Analytical Currency- Total Earning Variance | Total Earning Variance |
Analytical Currency- Total Earning Growth Rate | Total Earning Growth Rate |
HCM - Workforce Rewards - Payroll Costing
This table describes HCM - Workforce Rewards - Payroll Costing metrics.
Metric | Metric Definition |
---|---|
Worker Count Costing | Count of workers processed in costing process |
Credit | Credit Value |
Debit | Debit Value |
Credit Amount | Credit Amount |
Debit Amount | Debit Amount |
Credit Variance | Credit Variance |
Debit Variance | Debit Variance |
Credit Period Ago | Period Ago Value for Credit Amount |
Debit Period Ago | Period Ago Value for Debit Amount |
Credit ( MTD ) | Month To Date Accumulation for credit Amount |
Debit ( MTD ) | Month To Date Accumulation for debit Amount |
Credit ( QTD ) | Quarter To Date Accumulation for credit Amount |
Debit (QTD) | Quarter To Date Accumulation for debit Amount |
Credit ( YTD) | Year To Date Accumulation for credit Amount |
Debit ( YTD) | Year To Date Accumulation for debit Amount |
Payment Cost Credit Amount | Payment Cost Credit Amount |
Payment Cost Debit Amount | Payment Cost Debit amount |
Payment Cost Credit Variance | Payment Cost Credit Variance |
Payment Cost Debit Variance | Payment Cost Debit Variance |
Payment Cost Credit Period Ago | Payment Cost Credit Period Ago |
Payment Cost Debit Period Ago | Payment Cost Debit Period Ago |
Payment Cost Credit ( MTD ) | Month To Date Accumulation for credit Amount |
Payment Cost Debit ( MTD ) | Month To Date Accumulation for debit Amount |
Payment Cost Credit ( QTD ) | Quarter To Date Accumulation for credit Amount |
Payment Cost Debit (QTD) | Quarter To Date Accumulation for debit Amount |
Payment Cost Credit ( YTD) | Year To Date Accumulation for credit Amount |
Payment Cost Debit ( YTD) | Year To Date Accumulation for debit Amount |
Net | Net Value |
Net Amount | Net Amount |
HCM—Workforce Rewards - Salary Basis
This table describes Workforce Rewards Salary Basis metrics.
Metric | Metric Definition |
---|---|
Salary Adjustment Percentage | Salary Adjustment Percentage |
High Performer Salary Change Rate | Salary Change Rate for High Performer Workers |
Low Performer Salary Change Rate | Salary Change Rate for Low Performer Workers |
Medium Performer salary Changes | Salary Change Rate for Medium Performer Workers |
New Hire Salary | Sum of salary basis amount of a new hire ( Workers with less than or equal to 12 months of service period ) in analytics currency |
Salary Adjustment (Off Cycle Changes) | Sum of Salary basis adjustment amount for all action codes except " Allocate Workforce Compensation" in analytics currency |
Salary Adjustment ( From Compensation Plan) | Sum of Salary basis adjustment amount action codes =" Allocate Workforce Compensation" in analytics currency |
Salary Amount | Worker's Salary Amount ( Base Pay) in analytics currency |
Prior Salary | Prior Salary Amount Of Worker in analytics currency |
Salary Adjustment Amount | Salary Adjustment Amount in analytics currency |
Average Annualized Salary | Average Annualized Salary in analytics currency |
Annual Salary | Annual Salary Amount in analytics currency |
Annualized Salary ( FTE) | Full Time Annualized Salary Amount in analytics currency |
Worker Count ( Below Range) | Distinct Worker count Quartile='Below Range' |
Worker Count ( Above Range) | Distinct Worker count with Quartile='Above Range' |
Headcount (Below Range ) | Sum of Headcount with Quartile='Below Range' |
Headcount ( Above Range ) | Sum of Headcount with with Quartile='Above Range' |
Worker Count (Quartile=1) | Count Of Worker with quartile value=1 |
Worker Count ( Quartile=2) | Count Of Worker with quartile value=2 |
Worker Count ( Quartile=3) | Count Of Worker with quartile value=3 |
Worker Count ( Quartile =4) | Count Of Worker with quartile value=4 |
Component Adjustment Percentage | Salary component percentage |
Component Adjustment Amount | Salary Component Adjustment Amount |
Warehouse Currency | Warehouse currency for Salary Amount |
Warehouse Currency Code | Warehouse currency code for Salary Amount |
Worker Count (Quintile=1) | Count of workers with Quintile=1 |
Worker Count (Quintile=2) | Count of workers with Quintile=2 |
Worker Count (Quintile=3) | Count of workers with Quintile=3 |
Worker Count (Quintile=4) | Count of workers with Quintile=4 |
Worker Count (Quintile=5) | Count of workers with Quintile=5 |
Worker Count (With Salary Basis) | Workers with Salary Count |
Time Since Last Salary Change | Time elapsed since last salary change (in Years) |
Average Compa Ratio | Average of the compa ratio |
Warehouse Currency | Warehouse currency for Salary Component Amount |
Warehouse Currency Code | Warehouse currency code for Salary Component Amount |
Warehouse Currency - New Hire Salary | Sum of salary basis amount of a new hire ( Workers with less than or equal to 12 months of service period ) in warehouse currency |
Warehouse Currency - Salary Adjustment (Off Cycle Changes) | Sum of Salary basis adjustment amount for all action codes except " Allocate Workforce Compensation" in warehouse currency |
Warehouse Currency - Salary Adjustment ( From Compensation Plan) | Sum of Salary basis adjustment amount action codes =" Allocate Workforce Compensation" in warehouse currency |
Warehouse Currency - Salary Amount | Worker's Salary Amount ( Base Pay) in warehouse currency |
Warehouse Currency - Prior Salary | Prior Salary Amount Of Worker in warehouse currency |
Warehouse Currency - Salary Adjustment Amount | Salary Adjustment Amount in warehouse currency |
Warehouse Currency - Average Annualized Salary | Average Annualized Salary in warehouse currency |
Warehouse Currency - Annual Salary | Annual Salary Amount in warehouse currency |
Warehouse Currency - Annualized Salary ( FTE) | Full Time Annualized Salary Amount in warehouse currency |
Warehouse Currency - Component Adjustment Amount | Component adjustment amount in warehouse currency |
HCM—Workforce Rewards - Workforce Compensation
This table describes Workforce Rewards - Workforce Compensation metrics.
Metric | Metric Definition |
---|---|
Warehouse Currency - Overall Budget Amount (Allocated) | Total budget amount allocated to a worksheet manager |
Warehouse Currency - Overall Budget Amount (Available) | Budget amount left to be utilized by worksheet managers |
Warehouse Currency - Overall Budget Amount (Used) | Budget amount used by worksheet managers |
Warehouse Currency - Total Eligible Salaries | Sum of eligible salaries of workers |
Warehouse Currency | Currency of the worker's pay amount (in analytics currency) |
Warehouse Currency Code | Currency code of the worker's pay amount (in analytics currency) |
Exchange Rate Date | Date of the exchange rate (in analytics currency) |
Warehouse Currency - Base Salary | Worker's base pay amount, expressed in worker's base pay frequency |
Warehouse Currency - Base Salary Adjustment Amount | Worker's base pay amount, expressed in plan frequency |
Warehouse Currency - Proposed Salary | New base pay salary of a worker, expressed in worker's base pay frequency |
Warehouse Currency - New Adjusted Salary Amount | Proposed Salary, expressed in plan frequency |
Warehouse Currency - Proposed Salary (Average) | Average of Proposed Salary |
Warehouse Currency - Base Salary Change Value | Salary Change value |
Average Allocation Percentage | |
Warehouse Currency | Currency of the worker's pay amount (in Warehouse currency) |
Warehouse Currency Code | Currency code of the worker's pay amount (in Warehouse currency) |
Exchange Rate Date | Date of the exchange rate (in Warehouse currency) |
Warehouse Currency - Eligible Salary | Amount calculated to determine workers allocation amount. |
Warehouse Currency - Compensation Amount | Amount allocated to a worker. |
Warehouse Currency - Compensation Amount (Minimum) | Minimum amount that can be allocated to a worker. |
Warehouse Currency - Compensation Amount (Maximum) | Maximum amount that can be allocated to a worker. |
Warehouse Currency - Target Compensation Amount | Recommended compensation amount. |
Warehouse Currency - Target Compensation Amount (Minimum) | Minimum recommended allocation amount. |
Warehouse Currency - Target Compensation Amount (Maximum) | Maximum recommended allocation amount. |
Warehouse Currency - Compensation Variance | Variance between target compensation and actual compensation amount. |
Warehouse Currency - Average Compensation Amount | Average amount allocated to a worker. |
Warehouse Currency - Worker Budget Amount | Amount budgeted for a worker |
Warehouse Currency Code | Currency code of the worker's pay amount budget |
Warehouse Currency | Currency of the worker's pay amount budget |
Exchange Rate Date | Date of the exchange rate |
HCM—Workforce Time and Labor Management
This table describes Workforce Time and Labor Management metrics.
Metric | Metric Definition |
---|---|
Worker Count ( Saved Time Cards) | Count Of Workers with Time Card Status As 'SAVED' |
Worker Count ( Entered Time Cards) | Count of Workers with Time Card Status As 'ENTERED' |
Worker Count ( Submitted Time Cards) | Count of Workers with Time Card Status As 'SUBMITTED' |
Worker Count ( Approved Time Cards) | Count of Workers with Time Card Status As 'APPROVED' |
Number Of Time Cards | Total Time Cards |
Time Cards (Approved) | Count Of Time Cards With Status As 'APPROVED' |
Time Cards ( Entered) | Count Of Time Cards With Status As 'ENTERED' |
Time Cards (Incomplete) | Count Of Time Cards With Status as 'INCOMPLETE' |
Time Cards (In Error) | Count Of Time Cards With Status as 'IN_ERROR' |
Time Cards ( Rejected ) | Count Of Time Cards With Status as 'REJECTED' |
Time Cards (Saved) | Count Of Time Cards With Status as 'SAVED' |
Time Cards (Submitted) | Count Of Time Cards With Status as 'SUBMITTED' |
No. Of Reported Time Entries | Total Reported Time Entries |
Reported Hours | Total Reported Hours |
Labor Hours | Total Labor Hours |
Reported Hours Approved | Total Reported Hours Approved |
Labor Hours Approved | Total Labor Hours Approved , |
Reported Hours Rejected | Total Reported Hours Rejected |
Labor Hours Rejected | Total Labor Hours Rejected |
No. Of Absence Time Entries | Total Number of Absence Time Entries |
Absence Hours | Total Absence Hours |
Absence Hours Approved | Total Absence Hours Approved |
Absence Hours Rejected | Total Absence Hours Rejected |
Processed Hours | Total Processed Hours |
Processed Units | Total Processed Units |
Descriptive Flexfield Details
Overview
Descriptive Flexfields (DFFs) allow you to capture additional information on the Fusion application transactional UI. DFFs provide you the flexibility to configure data that is not available prebuilt in the application. You can report on the configured DFFs through Fusion Data Intelligence for HCM.
Absence
Descriptive Flexfield (DFF)
Subject Area Name | Descriptive Flexfield (DFF) Supported |
---|---|
HCM - Workforce Absence Management | Absence Categories |
HCM - Workforce Absence Management | Absence Plan |
HCM - Workforce Absence Management | Absence Reasons |
HCM - Workforce Absence Management | Absence Recordings |
HCM - Workforce Absence Management | Absence Type |
Global Human Resources
Descriptive Flexfield (DFF)
Subject Area Name | Descriptive Flexfield (DFF) Supported |
---|---|
HCM-Workforce Core | Additional HR Action Attributes |
HCM-Workforce Core | Legislative Action Attributes |
HCM-Workforce Core | Additional Action Reason Attributes |
HCM-Workforce Core | Person Additional Attributes |
HCM-Workforce Core | Assignment Attributes |
HCM-Workforce Core | Legislative Assignment Attributes |
HCM-Workforce Core | Citizenship Attributes |
HCM-Workforce Core | Ethnicity Attributes |
HCM-Workforce Core | Person Disability Information |
HCM-Workforce Core | Person Disability Legislative Information |
HCM-Workforce Core | Person Name Attributes |
HCM-Workforce Core | Person Type Attributes |
HCM-Workforce Core | Persons Attributes |
HCM-Workforce Core | Position Attributes |
HCM-Workforce Core | Work Relationship Attributes |
HCM-Workforce Core | Work Relationship Legislative Information |
HCM-Workforce Core | Department Attributes |
HCM-Workforce Core | Person Legislative Attributes |
HCM-Workforce Core | Job Attributes |
HCM-Workforce Core | Grade Attributes |
HCM-Workforce Core | Location Attributes |
Talent
Descriptive Flexfield (DFF)
Subject Area Name | Descriptive Flexfield (DFF) Supported |
---|---|
HCM - Talent Acquisition | Requisition DFF |
HCM - Talent Acquisition | Offer DFF |
HCM - Talent Acquisition | Offer Assignment DFF |
HCM - Talent Acquisition | Job Attributes |
HCM - Talent Acquisition | Grade Attributes |
HCM - Talent Acquisition | Location Attributes |
HCM - Talent Acquisition | Position Attributes |
HCM - Talent Acquisition | Department Attributes |