HCM Warehouse Structure

Data marts are logical divisions within the HCM Warehouse and are comprised of subject-specific dimensional data models designed around a specific institutional process. The HCM Warehouse includes the Compensation data mart, Learning and Development data mart, Recruiting data mart, and the Workforce Profile data mart.

Image: HCM Warehouse data marts and business processes

This example illustrates the HCM Warehouse data marts and business processes.

Each data mart is associated with a business process that helps you answer the questions you need to keep your organization robust and ahead of its competition. With each data mart, PeopleSoft presents the associated business process and the fact tables that will help you answer your critical business questions.

This section discusses:

Compensation Mart
Learning and Development Mart
Recruiting Mart
Workforce Profile Mart

Compensation Data Mart

The Compensation data mart is an integrated repository of data related to benefit enrollments; benefit expenses; absence; and payroll earnings and deductions. Compensation Mart includes both North American and global payroll records, as well as every earning and deduction record for every employee. Detailed benefit expenses include medical, dental, pension, life insurance, vacation, and flexible spending accounts. Metrics from this mart can be reported, analyzed, filtered and grouped by many attributes including dates, business unit, department, location, benefit program, benefit plan, years of service, age, gender, ethnicity, and so on.

The Compensation data mart includes data about leave and absence from three sources. The first source is Leave Accrual from the Global Payroll Absence Management module. The second source is the Monitor Absence process from PeopleSoft HRMS. Lastly, data for North American Payroll is sourced through the HRMS Leave Accrual process.

This first source, GP Absence Management, is a highly customized, rule based application. The module compiles data as a function of user defined rules and this can result in many different levels of granularity. Because the MDW tables follow and maintain a specific format, this highly variable source will be directed to two delivered OWS tables. The Global Payroll Result table (GP_RSLT_ABS) accumulates the daily leave taken. The Global Payroll Result Accumulation table (GP_RSLT_ACUM) is used for accumulated reporting, i.e. weekly, monthly or quarterly reports. There are also GP calendar and pay group tables that are delivered.

With the Compensation data mart, you can answer questions such as "How have our compensation expenses changed over the last two years?", "Which form of our compensation expenses have increased the most in the last 12 months?" and "What is a list of our business units descending by total compensation expenses?"

Compensation Data Mart Delivered Fact and Dimension Tables

This section discusses the delivered fact and dimension tables for the Compensation data mart.

Compensation Data Mart Fact Tables

The following table describes the delivered Compensation data mart fact tables.

Note: In the table, the Helps Answer column includes examples of the type of answers a fact table can provide; it does not contain the complete list of answers.

Fact Name	Fact Record Name	Description	Helps Answer
Absence Accrual	F_AB_ACRL	Stores allowable absence or vacation earned for the year based on a set time interval.	Departments with employees with an absence carryover quantity greater than 20 days. Business unit with the lowest average number of vacation carryover days last year. Region with greatest number of vacation days taken year-to-date.
Absence Event	F_AB_EVENT	Stores leave and absence event information for the PeopleSoft Global Payroll analytic application.	Departments with employee absence duration greater than ten days for a particular month. Total entitled override leave amount for the payroll department. Average number of hours worked on the absence begin date for full-time employees. Region with the highest average number of hours worked on the last partial hours date.
Absence	F_AB	Stores leave and absence occurrences.	Employees with an absence duration greater than ten days this month. Departments with the greatest number of absences in days this quarter.
Absence Request	F_AB_REQUEST	Stores absence requests for employees.	Employees with more than ten days requested absence this month.
Benefit Enrollment	F_BNF_ENRLMT	Stores benefit enrollment data for the different benefit plan, which provides the capability to calculate benefit valuations that are not processed by the payroll application.	Enrollments in a specific medical benefit plan. Employees with flexible spending account (FSA) balances in excess of $1,000. Average car allowance provided to employees below the executive level. Total FSA contribution for employees earning more than $100,000 annually. Average salary multiplier for the ADD benefit amount for executives. Average savings deduction amount for employees earning less than $50,000 annually. Total voluntary pension contribution amount for married employees.
Global Payroll	F_GBL_PAYROLL	Contains the earnings, deductions, and accumulators processed for employees on the Global Payroll system. These accumulators also include vacation accrual data that is processed in the Global Payroll analytic application.	Employees receiving additional arrears during the last payroll for the national sales office. Total calculation result value for the ESPP deduction all of the employees in the marketing department. Average base delta value for the hour salary earnings for all employees in the IT business unit. Highest bank transfer deduction value per department and per deduction. Lowest and highest percent result value for the 401(k) deduction per department.
Payroll Deduction Balance	F_PAY_DED_CUR	Contains aggregate deduction data for an employee at a month-to-date, quarter-to-date, and year-to-date level processed through the payroll application.	How year-to-date deduction balances increased during the last six months. Total deduction balance, quarter-to-date, for employees in the Sales department. Year balance amount for year for the Southern region. Quarter balance amount for Q2 for non-exempt employees.
Payroll Deductions	F_PAY_DED	Contains the detailed deductions for an employee, per employee pay period, in the payroll application. These deductions can include employer paid deductions, as well as employee paid deductions. A separate record is created for each deduction code and deduction class per employee.	Amount paid in medical deductions on a monthly basis during this fiscal year. Total deductions in Q3 for employees in the Eastern region. Amount of deductions resulting from refunds for employees who are managers. Average amount of deductions not taken for employees in North America. Average coverage amount used for deduction calculation for this month.
Payroll Earnings Balance	F_PAY_ERN_CUR	Contains the aggregate earning balance for an employee at a month-to-date, quarter-to-date, and year-to-date level in the payroll application.	Gross earnings, month-to-date, for the last 12 months. Total hours worked year-to-date in the Maintenance department. Average hours worked quarter-to-date by department. Total earnings quarter-to-date for employees in the Western region. Total earnings month-to-date for employees whose annual salary is over $100,000.
Payroll Earnings	F_PAY_ERN	Contains the detailed regular and overtime earnings and hours for an employee for a pay period in the payroll application. An employee might have more than one pay earning record depending on other payroll affecting activity during the pay period, such as change in pay rate, job, and so on. Each pay earning record may have one or more subordinate pay other earnings records.	Departments with the highest overtime hours this month. Total number of hours worked by employees in the IT department. Region with the least number of overtime hours for the holiday season. Average regular earnings amount for exempt workers for a specific month. Average compensation rate used for overtime earnings in the Southwest region.
Payroll Other Earnings	F_PAY_OTH_ERN	Stores detailed earnings data processed through the payroll application that is not part of the regular earnings process. This table contains earnings type information for earnings other than regular or overtime earnings.	Amount paid in other earnings by department, by month for this fiscal year. Average number of hours worked based on other earnings for the HR department. Total amount of other earnings for last month's payroll. Actual compensation rate used to calculate other earnings in the payroll department.

Compensation Data Mart Dimension Tables

The following table describes the delivered Compensation data mart dimension tables.

Dimension Name	Dimension Record Name	Description
Absence Event	D_AB_EVENT	Stores absence event related indicators.
Absence Miscellaneous	D_AB_JNK	Contains all absence-related indicators, including attributes to indicate whether the leave is paid, if it is a work related injury, and so on.
Absence Type	D_AB_TYPE	Contains information related to absence history and requests, including attributes such as absence type, absence class, and certification period.
Benefit Plan	D_BNF_PLN	Contains information on all the benefit plans offered by a company. It keeps track of all the offerings by an organization and third parties associated in carrying these plans.
Benefit Source	D_BNF_SRC	Contains the source of benefit enrollment data that populates the Benefit Enrollment fact.
Compensation Rates	D_COMP_RT	Stores information about the compensation rates associated with employee payroll processing.
Coverage Code	D_COVRG	Captures the coverage codes used to define the coverage level of a health benefit.
Coverage Election	D_COVRG_ELECT	Captures the types of benefit coverage elections.
Deductions	D_DED	Stores the deduction code and deduction class related information for payroll processing.
Earnings	D_ERN	Stores the earnings code related information for payroll processing. This includes attributes such as earnings budget effect and earnings payment type.
Global Payroll Pay Group	D_GP_PAYGRP	Contains information related to pay groups for Global Payroll (GP) processing, including the pay entity attribute.
Global Payroll PIN	D_GP_PIN	Contains the information related the PIN name elements, used in Global Payroll to allow for flexibility in configuration.
Health Benefit Miscellaneous	D_HLTH_BNF_JNK	Stores miscellaneous attributes related to health benefits.
Saving Plan Miscellaneous	D_SAV_PLN_JNK	Stores miscellaneous attributes related to the savings plan type of benefits.

Learning and Development Data Mart

The Learning and Development data mart provides management with information related to the performance and development of its workforce. It contains data related to competencies; accomplishments; Human Resource Management System (HRMS) training courses, enrollments and expenses; learning management courses, sessions, enrollments, outcomes and expenses; and ePerformance evaluations. The application captures detailed records from each of these subject areas for every employee and course. You can use metrics from this data mart to report, analyze, filter and group by many attributes including dates, business unit, department, location, evaluation type, learning program, certifications, training outcomes, training expense, and so on.

Use this data mart to answer questions such as "Who are our top performing employees in the Information Technology division?", "Which employees have not successfully completed the 'Introduction to Oracle' course?" and "Which employees received a 'needs improvement' assessment from the new leadership committee?"

Development Business Process

The Learning and Development data mart is related to the Development business process, which is also known as Assess, Design, Develop. People engaged in this business process are responsible for developing their workforce. They must assess workforce performance and then design and provide workforce development programs to improve workforce effectiveness. This mart enables these people to assess the skills of their workforce, design learning and performance programs, and develop their people in alignment with career paths and corporate objectives.

With this mart you can answer questions such as "Which of our learning programs has had the highest successful outcomes?", "Which has had the least?", "Which training centers are not offering our new course TA101: Surviving Meetings?," and "Which employees received the Outstanding Contributor Awards this year?"

Learning and Development Data Mart Delivered Fact and Dimension Tables

This section discusses the delivered fact and dimension tables for the Learning and Development data mart.

Learning and Development Data Mart Fact Tables

The following table describes the delivered Learning and Development data mart fact tables.

Note: In the table, the Helps Answer column includes examples of the type of answers a fact table can provide; it does not contain the complete list of answers.

Fact Name	Fact Record Name	Description	Helps Answer
Accomplishment	F_ACOMP	Contains detailed records regarding employee accomplishments including licenses, certifications, language proficiency, memberships, education, honors, and awards.	Departments with the highest accomplishment test score. Greatest total number of credit hours for a given quarter and year.
Completion	F_CMPLTN	Contains all enrollment and completion details for a given learner at the learning component level. This fact table contains data from different kinds of enrollments, such as direct, adhoc, mass, and so on. It also provides details of programs associated with the enrollment, as well as indicating whether the learner is enrolling to fulfill job role competencies or HR competencies.	Courses with the highest/lowest completion rates. Department with the lowest completion rate for a specific course.
Employee Appraisal	F_EMPL_APRSL	Contains data from the HRMS ePerformance appraisal tables and provides data regarding appraisal totals and preliminary values.	Employees who have not received a preliminary review. Average preliminary rating for employees in a specific department. Department with the highest average preliminary review points. Jobcode with the lowest appraisal review rating. Average number of appraisal review points by department.
Employee Review	F_REVW_EMPL	Contains total ratings, amounts, points, and percentages from the HRMS employee review tables. This fact table contains one row per employee per employee record number per effective date.	Employees with a total review percent greater than 90%, for a specific department or region.
Enrollment	F_ENRLMT	Contains all enrollment details for an activity for a given learner. Contains data from different kinds of enrollments such as direct, adhoc, mass, and so on. It also provides details of programs associated with the enrollment, as well as indicating whether the learner is enrolling to fulfill job role competencies or HR competencies.	Number of employees who took training courses in Q4 of last year.
Learning Activity Costs	F_LRNG_ACCST	Contains all costs associated with a learning activity.	The most costly learning activities, by organization, region, department, and so forth. Average unit cost for all introductory courses for a specific department. Number of travel cost items associated to courses in a specific month and year.
Learning Objective	F_LRNG_OBJV	Contains all objectives assigned to a learner from different sources (HR, job role competency, and so on), as well as the status of the objective.	Employees who have achieved/not achieved their required proficiency for a given competency.
Learning Resource	F_LRNG_RSRC	Contains information about the scheduled resources for the learning activity.	Classrooms scheduled for less than 100 hours.
Person Competency	F_CMPTCY_PERSON	Maintains data about competency evaluation of employees, applicants, or contractors. Competencies are given review ratings for proficiency and interest level.	Employees with more than two years experience with a specific competency.
Program Registration	F_PGM_REG	Contains program registration details for a program for a given learner. This fact also contains learner certification data.	Number of employees registered for a given course.
Training/Enrollment	F_TRNG	Contains data about training courses, both internal and external, taken by a student. A student can be an employee, an applicant, or a non-employee. Contains multiple training records for a student.	Total training duration for employees in a specific branch. Total amount of time an employee spent in training in for a specific department and quarter. Department with the lowest average number of non-duty hours spent in training. Number of non-government hours spent in training in the IRS last year.

Learning and Development Data Mart Dimension Tables

The following table describes the delivered Learning and Development data mart dimension tables.

Dimension Name	Dimension Record Name	Description
Accomplishment	D_ACOMP	Contains a list of accomplishments that an organization's employees, applicants or contractors can achieve.
Accomplishment Miscellaneous	D_ACOMP_JNK	Contains miscellaneous information that is captured with an accomplishment.
Appraisal Miscellaneous	D_APRSL_JNK	Maintains miscellaneous information that is captured during the employee appraisal.
Assignment Code	D_ASSGN_CD	Contains a list of codes that identify how a learner was assigned objectives.
Attendance	D_ATDNC	Maintains a list of attendance values that are associated with an enrollment.
Attendance Status	D_ATDNC_STAT	Maintains a list of attendance statuses that can be associated with an enrollment.
Completion Status	D_CMPLTN_STAT	Maintains a list of completion statuses that can be associated with an enrollment.
Competency	D_CMPTCY	Contains a list of competencies used for analysis of employee competency inventory or competencies as provided by training courses.
Competency Verification	D_CMPTCY_VRFY	Maintains a list of ways in which employee competencies can be verified.
Course Grade	D_CRSE_GRD	Maintains the grades that a student can obtain.
Course Session	D_CRSE_SES	Contains information about training offerings and their groupings into categories and subcategories. It also contains details on training offering instances (sessions).
Cost Item	D_CST_ITEM	Stores cost items and its categories.
Cost Unit	D_CST_UNIT	Contains a list of cost units used in a training module.
Catalog Item	D_CTLGITM	Stores a list of catalog items.
Enrollment Status	D_ENRLMT_STAT	Stores a list of statuses of the learner related to enrolling in a learning activity.
Evaluation Miscellaneous	D_EVAL_JNK	Maintains miscellaneous information that is captured during the evaluation of a competency.
French Training	D_FRA_TRNG	Contains a list of miscellaneous attributes captured by French customers regarding an enrollment.
Government Training	D_GOV_TRNG	Contains a list of miscellaneous attributes captured by government customers related to a training.
Instructor Role	D_INSTR_ROLE	Stores information about the different roles that can be played by an instructor.
Learning Activity	D_LRNG_AC	Stores information on learning activities.
Learning Components	D_LRNG_COMP	Stores learning components that are the foundational building blocks of learning activities.
Learning Cost Type	D_LRNG_CSTTYPE	Stores the frequency of cost, such as hourly.
Learning Category	D_LRNG_CTGRY	Stores categories that enable the classification of catalog items so that learners and managers can easily browse and search for appropriate activities.
Learning Environment	D_LRNG_ENV	Maintains learning environments, which provides a way to create separate domains within the learning catalog.
Learning Equipment	D_LRNG_EQP	Indicates all individual pieces of equipment in the system.
Learning Facility	D_LRNG_FCLTY	Indicates the facility in which learning takes place.
Learning Grade	D_LRNG_GRADE	Stores the grade obtained by the learner.
Learning Instructors	D_LRNG_INSTR	Maintains information on instructors, which are internal or external learners in the system, providing the ability to assign to activities, activity sessions, session patterns, and session templates.
Learning Material	D_LRNG_MTRL	Identifies the type of material (training manual, gift, compact disk, or brochure).
Learning Objective	D_LRNG_OBJV	Maintains objectives, which are a high-level abstraction of a learner's learning needs and accomplishments.
Learning Organization	D_LRNG_ORG	Maintains information on the organization that is the external customer who undergoes training.
Learning Program	D_LRNG_PGM	Maintains information on the program, which is a high-level grouping that guides the learner along a specific learning path through sections of items.
Learning Room	D_LRNG_ROOM	Stores information about the facility room associated with a session.
Learner Group	D_LRNR_GRP	Maintains information about the different learner groups to which learners can be associated. Major D_MAJOR Maintains codes and descriptions that are assigned to college-level majors.
Objective Status	D_OBJV_STAT	Contains a list of statuses that can be associated with a learner's objective.
Passing Status	D_PASS_STAT	Contains a list of passing statuses that can be associated with a learner.
Program Completion Status	D_PGMCMPLN_STAT	Contains a list of program completion statuses that can be associated with a learner.
Review Rating	D_REVW_RTNG	Contains a list of actual ratings used for performance reviews along with their associated rating models.
Review Scale	D_REVW_SCALE	Contains a list of rating scales for performance reviews.
Review Status	D_REVW_STAT	Contains various review statuses.
Review Type	D_REVW_TYPE	Maintains information about the different review document types.
School	D_SCHOOL	Maintains information about schools, colleges, and universities.
Training Expense Type	D_TRNG_EXP	Maintains various training expense types allowed.
Training Reason	D_TRNG_RSN	Maintains a list of reasons that can be associated with a training.

Recruiting Data Mart

The Recruiting data mart is an information repository of recruitment and staffing initiatives, status, expenses, and outcomes. This data mart contains detailed information and all current and historic recruitment initiatives including open positions, requisitions, applicants, applications, outcomes, and recruitment expense. You can report and analyze recruitment metrics by a wide variety of attributes, including business unit, department, job code, location, status, status reason, referral category and subcategory, and so on. The Recruiting data mart provides staff and management with information needed to make informed decisions regarding current and future recruitment initiatives.

Use this data mart to answer questions such as "Which applicants were referred to us by the new Redwood Shores recruitment center?", "For what positions have they applied and status of their applications?", "What applicants applied for our VP of HR executive search?" and "Was the applicant pool balanced and in compliance?"

Recruiting Business Process

The Recruiting data mart is related to the Recruiting business process, which is also known as Plan, Attract, Onboard. People engaged in this business process are responsible for attracting talented, skilled applicants that match business requirements, attracting the best candidates, and onboarding them efficiently. This process also includes the procurement of service or contract labor.

To support this business process, Recruiting Mart contains the information necessary to answer questions such as "Which referral sources have yielded the greatest number of hires?" and "Which business units have time to hire (hire date - open position date) less than 30 days at a cost of less than $15,000?"

Recruiting Data Mart Delivered Fact and Dimension Tables

This section discusses the delivered fact and dimension tables for the Recruiting data mart.

Recruiting Data Mart Fact Tables

The following table describes the delivered Recruiting data mart fact tables.

Note: In the table, the Helps Answer column includes examples of the type of answers a fact table can provide; it does not contain the complete list of answers.

Fact Name	Fact Record Name	Description	Helps Answer
Recruitment Expenses	F_APP_EXP	Contains information about recruitment expenses associated with a particular applicant for employment. Each row corresponds to a particular type of expense.	Total expenses for all recruitment efforts in a specific location during the last 12 months. Average travel expense for applicants for a particular position.
Recruitment Tracking	F_RCMNT	Contains recruitment data at the applicant and job opening level, as well as the different statuses of the job opening for each applicant.	Percentage of applicants failed to meet the minimum qualification score for particular job for a specific month. Average total augmentation points for eligible applicants. Average number of points added for veterans performance on a specific requisition. Average screening score for internal applicants versus external applicants. Applicant rank on the certificate of eligible applicants.

Fact Name

Fact Record Name

Description

Helps Answer

Recruitment Expenses

F_APP_EXP

Contains information about recruitment expenses associated with a particular applicant for employment. Each row corresponds to a particular type of expense.

Total expenses for all recruitment efforts in a specific location during the last 12 months.

Average travel expense for applicants for a particular position.

Recruitment Tracking

F_RCMNT

Contains recruitment data at the applicant and job opening level, as well as the different statuses of the job opening for each applicant.

Percentage of applicants failed to meet the minimum qualification score for particular job for a specific month.

Average total augmentation points for eligible applicants.

Average number of points added for veterans performance on a specific requisition.

Average screening score for internal applicants versus external applicants.

Applicant rank on the certificate of eligible applicants.

Recruiting Data Mart Dimension Tables

The following table describes the delivered Recruiting data mart dimension tables.

Dimension Name	Dimension Record Name	Description
Applicant Expense	D_APP_EXP	Maintains a list of expense codes that can be associated with applicant related expenses.
Applicant	D_APPLICANT	Stores information about a person who has applied for a position and submitted all of the required application materials, such as an application form or a resume.
Government Recruitment	D_GOV_RCMNT	Contains a list of miscellaneous attributes captured by government customers relating to any recruitment effort.
Job Opening	D_JOB_OPENING	Stores information, such as job code, department, status, and status dates, about a formal request for a job within an organization.
Recruitment Status	D_RCMNTSTAT_RSN	Maintains the various statuses that the recruitment could go through, plus the valid reasons for each status.
Referral Source Category	D_REF_SRC_CAT	Stores information on company, agency, or existing employee who referred the applicant to the organization.
Referral Source Sub Category	D_REF_SRC_SBCT	Stores additional details on the company, agency, or existing employee who referred the applicant to the organization.

Workforce Profile Data Mart

The Workforce Profile data mart helps you to transform your information on workforce assignments, turnover, jobs, health and safety, organizational effectiveness, grievances and disciplinary actions into actionable intelligence. This mart helps you optimize your global workforce by helping you to capture data regarding your workforce assignments, turnover, jobs, health and safety, organizational effectiveness, and other attributes related to work assignments. With the Workforce Profile data mart you can answer questions such as "Where is my organization overstaffed or understaffed?", "Do we have high levels of injury or illness in some locations and not others?" and "Does my organization have involuntary separation issues in any of our divisions?"

You can optimize your global workforce with analytics and reporting in Workforce Profile Mart.

Deployment Business Process

The Workforce Profile data mart is related to the Deployment business process, which is also known as Optimize, Track, and Monitor. This business process helps you to monitor your workforce's performance without getting in their way of or losing workers. The Deployment business process helps you to answer questions such as "What is our current headcount?", "How has headcount changed over the last 12 months?", "Do we have a problem with involuntary separations?" and "What were our rates of injury or illness by location, by month, for the last six months?"

Survey Data Sourced from OWE

Generally information loaded into MDW tables is sourced from the OWS. However, HCM Warehouse also incorporates workforce-related external survey information from third-party survey data providers (such as market compensation data from compensation surveys) into the MDW from the OWE.

Duration Dimensions

In some workforce fact tables, the various durations of time relating to an employee, for example age, length of service, and so on, are made available. The categorization of these durations is also available to allow for more flexible reporting. The Duration dimension table describes categories of durations, based on type and length of duration. This dimension provides an additional means for a customer to analyze workforce profile data, based on the length of time that an employee has worked for the company, the employee's age group, and so on.

The source data for the Duration dimension comes from the Workforce Duration Definition table populated by the Workforce Duration definition page. Data from this Duration Definition table is extracted into the MDW Duration dimension table, D_DURATION. Through the Workforce Duration definition page, the EPM customer can define the various types of durations within a duration group and the span of each duration group.

Because the duration group instances are used to describe a variety of duration types, we create role-playing dimensions to establish the context. PeopleSoft delivers seven role-playing dimensions as views that are built on top of the base Duration dimension table. They include Age, Service, Department, Salary Plan, JobCode, Pay Change, and Promo.

Workforce Profile Data Mart Delivered Fact and Dimension Tables

This section discusses the delivered fact and dimension tables for the Workforce Profile data mart.

Workforce Profile Data Mart Fact Tables

The following table describes the delivered Workforce Profile data mart fact tables

Note: In the table, the Helps Answer column includes examples of the type of answers a fact table can provide; it does not contain the complete list of answers.

Fact Name	Fact Record Name	Description	Helps Answer
Benchmark Survey	F_BENCHMARK	Contains external benchmark data formatted for benchmark reporting purposes to measure your organization's performance against those included in the survey.	Number of companies participating in a survey. Number of employees participating in a survey.
Injury Illness	F_INJ_ILL	Contains details on health and safety matters.	Business units with the highest number of health and safety incidents. Locations that have experienced an increase in the number of injury incidents compared to last year. Average number of days taken for illness incidents for a specific location. Employees that have taken more than 20 days for injuries or illnesses this year. Incident factor (number of incidents/headcount) for a specific location. Total number of days that employees were away from work due to injury for a specific location. Total number of days that employees were restricted from work due to illness for a specific location.
Time and Labor	F_TIME_LABOR	Contains payable time measures tracked against dimensions such as time reporting code, company, business unit, department, location, job code, position, project and various accounting chart fields.	Summary of payable time on a monthly basis for the last year. Employees with greater than 50 hours last week.
Workforce	F_WORKFORCE	Contains a monthly snapshot of the workforce profile data such as headcount, FTEs (Internal and Benchmark), durations (such as age and service) and pay rates.	Number of employees by department, geography, and so forth. Current composition of the workforce. Duration since an employee last experienced a promotion or pay change. Average annual benefit base rate for the basic life insurance plan. Average change amount or percent for nonexempt employees. The workforce's real total FTE for a given month. Number of employees promoted this month, promotion rate by department, geography, and so forth. Number of employees hired this month, by department, geography, and so forth. Number of employees terminated/leaving the company this month, by department, geography, and so forth.
Current Competencies	F_CURCOMPET	Contains a snapshot of competency profile data, such as competency experience years and review date. The snapshot data is recorded monthly. This fact table enables you to answer questions similar to those answered by Person Competency fact table, but it allows cumulative inventory of competencies of an employee rather than competencies under review during a particular period.	Employees with more than two years experience with a specific competency.
Current Accomplishments	F_CURACCOMP	Contains a snapshot of accomplishment profile data, such as number of credit hours and grade point average. The snapshot data is recorded monthly. This fact enables you to answer questions similar to those answered by the Accomplishment fact table, but it allows cumulative inventory of accomplishments of an employee rather than accomplishments under review during a particular period.	Department with the highest accomplishment test score.
Disciplinary Action	F_DISCIP_ACTION	Contains disciplinary action profile data, such as length of service duration.	Number of employees with a disciplinary action against them. Average age of employees with a disciplinary action against them. Average length of service of employees with a disciplinary action against them.
Grievance	F_GRIEVANCE	The table has information about grievances and steps taken to satisfy the grievances filed against the company by employees.	Number of employees that have filed grievances. Average age of the employees who filed grievances. Average length of service of the employees who filed grievances.

Workforce Profile Data Mart Dimension Tables

The following table describes the delivered Workforce Profile data mart dimension tables.

Dimension Name	Dimension Record Name	Description
Author	D_AUTHOR	Maintains a list of survey authors.
Financial Code	D_FINCODE	Maintains a list of financial codes.
Frequency	D_FREQ	Stores the payment and hours reporting frequency for time and payroll data. You can use a frequency to indicate Number of times per year an event occurs.
Geography	D_GEOGRAPHY	Maintains a list of geography codes.
Government Authority	D_GOV_AUTH	Stores government legal authority codes that an agency uses to grant a personnel action request. This dimension is primarily used by the Federal HCM Warehouse.
Government Nature of Action	D_GOV_NOA	Stores action and nature of action codes that are required by government agencies to grant a personnel action request.
Government Pay Plan	D_GOV_PAYPLN	Stores pay plans that identify government wage progression plans. Wage progression plans are contract driven pay increase schedules. This dimension is also used for retained pay plans for government employees.
Government Personnel Office	D_GOV_POI	Identifies US Federal government personnel offices, the Agency/Sub-Agency they belong to, their addresses, telephone numbers, and contact names.
Government Sub-Agency	D_GOV_SUBAG	Captures the bureau within an agency that a department is assigned to.
Incident	D_INCIDENT	Contains details about the health and safety incidents.
Industry	D_INDUSTRY	Maintains a list of industry codes.
Injury Illness	D_INJ_ILL_JNK	Contains miscellaneous attributes that are captured along with injury or illness data.
Regulatory Region	D_REG_RGN	Stores the codes for regulatory and regional edit purposes. A regulatory region is any region where there are specific laws and regulations that are used for transactional purposes.
Salary Plan	D_SALPLN	Stores unique salary categories that are defined in an organization. These categories are set up according to an employee's compensation structure.
Survey	D_SURVEY	Maintains reference information about each market survey instance.
Survey Metric	D_SURVEY_METRIC	Maintains information on survey metrics.
Unit Code	D_UNITCODE	Maintains a list of unit codes used in market survey analysis.

Common Dimensions in the HCM Warehouse

Dimension Name	Dimension Record Name	Description
Employee Job	D_EMPL_JOB	Maintains metrics related to an employee's current and historical jobs. Employees may have multiple jobs. It links these metrics to many job-related dimensions such as person, job, job code, department, position, corporate, status, geography, workforce action, and tenure, as well as duration group dimensions.

Shared Dimensions

Certain dimensions, such as Account or Department are used across all EPM warehouses. These dimensions are identical in structure and content across all EPM warehouses. The following table describes the delivered shared dimension tables

Dimension Name	Dimension Record Name	Description
Account	D_ACCOUNT	Stores details of an account that represents a ChartField.
AP Document Type	D_AP_DOC_TYPE	Stores details about AP document types, such as Payables Payments, Payables Adjustments, Payables Accruals, and so on.
Association Type	D_ASSOC_TYPE	Defines the association type for Case, Interaction and Order association.
Bank Account	D_BANK_ACCT	Store details about banks and bank accounts.
Book Code	D_BOOK_CODE	Stores details about book codes, which represent an account attribute and a balancing ChartField.
Budget Reference	D_BUDGET_REF	Stores budget descriptions.
Buyer	D_BUYER	Stores information on buyers, including information related to a buyer's employee ID and address.
Contract	D_CA	Stores the details of the contract information entered with customers. A contract contains the agreement information and obligations for the products and services licensed in the contract and is grouped by contract type.
Carrier	D_CARRIER	Stores information on carriers.
Certification Source	D_CERTSRC	Stores information on certification sources for suppliers.
Channel	D_CHANNEL	Stores channel information related to sales and procurement.
Chartfield1	D_CHARTFIELD1	Stores user defined ChartField details.
Chartfield2	D_CHARTFIELD	Stores user defined ChartField details.
Chartfield3	D_CHARTFIELD3	Stores user defined ChartField details.
Channel Partners	D_CHNL_PARTNER	Stores information about channel partners involved in the sales process.
Expenses Classifications	D_CLASS_FIELD	Stores expenses classification codes and descriptions, such as wages, benefits, health, and office supplies.
Company	D_CMPNY	Stores company-related information.
Credit Risk	D_CREDIT_RISK	Classifies credit risk values as High, Low, and Medium.
Customer Contact Person	D_CUST_CNTCT	Stores information about the customer contact person, which includes contacts and partners.
Customer Organization	D_CUST_ORG	Stores information related to customer organizations (companies). A customer organization is a company that purchases, leases, or contracts for products or services. The customer organization (company) is a subset of the Customer dimension.
Customer Person	D_CUST_PERSON	Stores information about individuals that purchase, lease, and contract for products or services. The Customer Person is a subset of the Customer dimension.
Customer Site	D_CUST_SITE	Stores information about organizations that purchase, lease, and contract for product or services located at a particular site or location. Sites can be an organization site or an individual site. Site is also a subset of the Customer dimension.
Customer Master	D_CUSTOMER	Stores information for entities that can participate in business relationships.
Department	D_DEPT	Stores information about the entities in an organization. This dimension includes attributes about a department, such as description, company code, location, and budget fields.
Employee Job Code	D_EMPL_JOB	Stores employee job history data, such as actions taken, department, job code, location, and salary history. Multiple records can be created for an employee.
Establishment	D_ESTAB	Stores distinct physical places of business (establishments) within a company and its address, and is used for regulatory reporting purposes.
Frequency	D_FREQ	Stores the payment and hours reporting frequency for time and payroll data. You can use a frequency to indicate how many times per year an event occurs.
Fund	D_FUND	Stores details about fund codes and their description.
GL Adjustment types	D_GL_ADJ_TYPE	Stores types of general ledger (GL) adjustments.
GL Offset	D_GL_OFFSET	Stores information on GL offset. This dimension groups billing information, such as office rent and retail rent.
Industry Group	D_INDUSTRY_GRP	Stores customer industry group information.
Inventory Item	D_INV_ITEM	Stores information about Inventory Item, which includes all attributes of item, including simple hierarchy information, such as category or group, as well as Make or Buy flag.
Inventory Location	D_INV_LOCATION	Stores information about the storage location from which goods will be moved.
Jobcode	D_JOBCODE	Stores information about the job assignments in an organization. This dimension represents the categorization of jobs into types, such as executive, technical, and administrative services.
Journal Line Source	D_JRNL_SOURCE	Stores the details about source of journal entries created in GL.
Sales Lead	D_LEAD	Stores sales leads generated by marketing campaign waves.
Ledger	D_LEDGER	Stores the ID and description of ledgers that are defined based on templates.
Line Type	D_LN_TYP	Stores information on line types.
Location	D_LOCATION	Stores a list of work sites for an organization. Location is used to establish physical locations in an organization, such as corporate headquarters, branch offices, and remote sales offices.
Lot	D_LOT	Stores information on lot (a group of items with similar characteristics).
Operating Unit	D_OPER_UNIT	Stores details about operating units, such as a plant, office, physical location, branch, and building.
Sales Opportunity	D_OPPORTUNITY	Stores information about a sales opportunity.
Order Capture	D_ORD_CAPTURE	Stores order capture information for the sales order process.
Sales Order Status	D_ORD_STAT	Stores information on order status.
Partner	D_PARTNER	Stores partner information. The dimension has the following hierarchy: Partner, Partner Status.
Pay Group	D_PAYGRP	Groups employees by how they are paid.
Person	D_PERSON	Stores the most current personal information of both employees and non-employees of an organization.
AR Specialist	D_PERSON_ARSPL	Stores details, such name and contact, about the accounts receivable (AR) specialist involved in handling the disputes and deductions in the AR module.
AR Collector	D_PERSON_COLTR	Stores details, such name and contact, about the AR collector involved in collecting the receivables amount in the AR module.
AR Credit Analyst	D_PERSON_CRNYST	Stores details, such name and details, about the AR credit analyst involved in handling the credits given to customers.
AR Deduction Manager	D_PERSON_DEDMGR	Stores AR deduction manager name and contact information.
Position	D_POS	Stores information on all job positions available, whether an employee fills the position or no, and helps with data analysis based on salary or standard hours.
Product Group	D_PROD_GROUP	Stores information on product groups.
Product	D_PRODUCT	Stores information on products.
Program	D_PROGRAM_FDM	Keeps track of programs, such as public works, social services, fire, and public safety, that are tracked in General Ledger.
Project	D_PROJECT	Stores information about projects. A project is a vehicle for identifying an initiative that has a specified start and end date.
Partner Contact	D_PRTR_CNTCT	Stores partner contact data.
Payment Method	D_PYMNT_MTHD	Stores methods of payment, such as check, cash, and credit card.
Receive Line Status	D_RECLN_STATUS	Stores information on all receive line statuses.
Regulatory Region	D_REG_RGN	Stores the codes for regulatory and regional edit purposes. A regulatory region is any region where there are specific laws and regulations that are used for transactional purposes.
Geographic Region	D_REGION	Contains geography information for customers.
Salary Plan	D_SALPLN	Stores unique salary categories that are defined in an organization. These categories are set up according to an employee's compensation structure.
Scenario	D_SCENARIO	Stores details of historical, budgeting, and forecast scenarios.
Customer Segment	D_SEGMENT	Stores customer segment information.
Statistics Code	D_STAT_CODE	Stores details about statistical information, such as floor space, full-time equivalent workdays, and shipment size.
Subledger	D_SUBLEDGER	Stores information on subledger, which groups the accounting information.
Supplier	D_SUPPLIER	Stores information on suppliers, such as remit to supplier and corporate supplier.
Sales Territory	D_TERRITORY	Stores sales territory information. Sales territories are user defined sales regions independent of geography or proximity.
Unit	D_UNIT	Stores detail information on real estate properties.
Unit of Measure	D_UOM	Indicates the quantity in which an inventory item is expressed, such as case (CS) or box (BX).