PeopleSoft HCM Warehouse

When people are the cornerstone of your business, making the right strategic decisions about staffing, hiring, and workforce deployment is critical to your competitive advantage. Yet, making the right decisions requires more than just operational data; you need to view patterns and trends in order to truly maximize your workforce. Are your managers, executives, and human resource personnel getting the detailed analytics and reports they need to make decisions that improve both employee and bottom-line performance?

Oracle's PeopleSoft Human Capital Management (HCM) Warehouse (formerly PeopleSoft HRMS Warehouse) captures detailed workforce-related information into a single environment, and combines it with complex analysis of your recruiting, compensation, benefits, and training initiatives. With this level of insight, you can make the right strategic decisions to maximize your workforce and improve HR performance.


  • A Powerful Foundation for Workforce Decisions: The PeopleSoft HCM Warehouse offers four seamlessly integrated but stand-alone data marts that deliver the maps, measures, and models required for making better, more strategic decisions about your workforce. Deployed together, the marts provide a single source of workforce data for complete reporting and analysis. Deployed independently, the marts provide best practice analysis in a single discipline without requiring a complete warehouse implementation. Each of the data marts has been rationalized to accept and store content from PeopleSoft Enterprise, JD Edwards EnterpriseOne, and JD Edwards World product families, allowing you to bring data together from these source systems into one place for reporting and analysis.
  • Compensation Mart: Compensation Mart provides information about your benefit and compensation programs to help you effectively increase retention and curb absentee problems before they impact organizational performance.
  • Learning and Development Mart: Learning and Development Mart provides information about your workforce skills and competencies, training programs, and performance, helping you to assess the effectiveness of your learning and development initiatives.
  • Recruiting Mart: Recruiting Mart provides deeper insight into your recruiting process such as whether you are filling positions in a timely manner, which recruiting methods are the most effective, and which candidate sources provide the best talent.
  • Workforce Profile Mart: PeopleSoft Workforce Profile Mart turns workforce data into actionable intelligence allowing you to determine where you are over- or understaffed, examine workforce churn across various business units, and assess injury or illness levels on a per location basis.
  • Flexible Information Access: PeopleSoft HCM Warehouse delivers packaged reports for Oracle BI Standard Edition (Discoverer). PeopleSoft HCM Warehouse also supports third party BI tools, including those from Cognos, MicroStrategy, and Business Objects. With these flexible information access tools and PeopleSoft HCM Warehouse, knowledge workers, business analysts, and managers can perform sophisticated business analysis with ad-hoc querying and reporting, personalized scorecards and dashboards, multidimensional analysis and exploration, and formatted production-style reports.
  • Single, Analytics Framework: PeopleSoft HCM Warehouse is built on Oracle's PeopleSoft EPM Foundation, a single analytics framework that provides IT organizations with one platform and toolset from which to manage and support the warehouse. PeopleSoft EPM Foundation includes best-in-class extract, transform, and load (ETL) tools, powerful metadata management tools, multi-currency and multi-language support, and built-in security features that enable unparalleled flexibility, openness, and modularity.