Tuesday, November 15, 2011

Oracle HR Analytics: Workforce Profile

The Workforce Profile subject area contains data that describes the employees in your company. It is important to understand the sensitive nature of some of the data included in these tables. The sensitive data stored includes, but is not limited to, age, ethnicity, and performance ratings. The sensitive nature of this data means that care should be taken when determining which users get access to parts of the data. While some of the data contains private information, there is also other non-sensitive data as well. Employee job titles, work location, and organization are some of the non-sensitive data available. The data contained in this subject area is used in analyses to track headcount across the company. The default Oracle Workforce Profile dashboards include ways to analyze headcount by metrics including age, organization, and education level.

The following data warehouse tables are referenced by the Workforce Profile subject area in the OBIA 7.9.6.3 RPD:

  • W_AGE_BAND_D
  • W_BUSN_LOCATION_D
  • W_DAY_D
  • W_EMP_DEMOGRAPHICS_D
  • W_EMPLOYEE_D
  • W_EMPLOYMENT_D
  • W_EMPLOYMENT_STAT_CAT_D
  • W_GEO_COUNTRY_D
  • W_HR_POSITION_D
  • W_INT_ORG_D
  • W_INT_ORG_DH
  • W_INT_INTL_ASSGN_D
  • W_JOB_D
  • W_MONTH_D
  • W_PAY_GRADE_D
  • W_PERFORMANCE_BAND_D
  • W_POSITION_DH
  • W_PRD_OF_WRK_BAND_D
  • W_QTR_D
  • W_WRKFC_BAL_A
  • W_WRKFC_EVENT_GROUP_D
  • W_WRKFC_EVENT_TYPE_D
  • W_WRKFC_EVT_A
  • W_WRKFC_EVT_MONTH_F
  • W_YEAR_D

No comments:

Post a Comment