Dimension Author

This dimension includes a list of survey authors.

PS_D_AUTHOR

Dimension Financial Code

This dimension includes a list of financial codes.

PS_D_FINCODE

Dimension Geography

This dimension includes a list of geography codes used for the benchmark survey.

PS_D_GEOGRAPHY

Dimension Industry

This dimension includes a list of industry codes.

PS_D_INDUSTRY

Dimension Survey

This dimension includes reference information on each market survey instance.

PS_D_SURVEY

Dimension Survey Metric

This dimension includes information on the different survey metrics.

PS_D_SURVEY_METRIC

Dimension Unit Code

This dimension includes a list of unit codes used in market survey analysis.

PS_D_UNITCODE

Fact Benchmark

Contains external benchmark data formatted for reporting purposes.

PS_F_BENCHMARK

Measure Amount (Trans) (Measure Amount Transaction Currency)

Contains the metric value for the survey in transaction currency.

PS_F_BENCHMARK.MEASURE_AMT

Measure Amount

Contains the metric value for the survey in base currency.

PS_F_BENCHMARK.MEASURE_BCE_AMT

Sample Company Count

Contains the number of companies participating in the survey.

PS_F_BENCHMARK.WA_SAMPLE_CO_COUNT

Sample Employee Count

Contains the number of employees participating in the survey.

PS_F_BENCHMARK.WA_SAMPLE_EE_COUNT

Dimension Account

This dimension includes details of an account, which represents a ChartField.

PS_V_ACCOUNT

Dimension Business Unit

The business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Chartfield1

This dimension includes user defined ChartField details.

PS_D_CHARTFIELD1

Dimension Chartfield2

This dimension includes user defined ChartField details.

PS_D_CHARTFIELD2

Dimension Chartfield3

This dimension includes user defined ChartField details.

PS_D_CHARTFIELD3

Dimension Class Field

This dimension includes expense classification codes and description.

PS_D_CLASS_FIELD

Dimension Company

The company dimension includes company-related information.

PS_D_CMPNY

Dimension Company From Company

The from company role-playing dimension based on the company dimension.

PS_D_CMPNY

Dimension Company To Company

The to company role-playing dimension based on the company dimension.

PS_D_CMPNY

Dimension Day Action Date

The action date role-playing dimension based on the day dimension.

PS_D_DAY

Dimension Day Department Entry Date

The department entry date role-playing dimension based on the day dimension.

PS_D_DAY

Dimension Day End Date

The end date role-playing dimension based on the day dimension.

PS_D_DAY

Dimension Day Government Not To Exceed Date

The government not to exceed date role-playing dimension based on the day dimension.

PS_D_DAY

Dimension Day Grade Entry Date

The grade entry date role-playing dimension based on the day dimension.

PS_D_DAY

Dimension Day Hire Date

The hire date role-playing dimension based on the day dimension.

PS_D_DAY

Dimension Day Job Entry Date

The job entry date role-playing dimension based on the day dimension.

PS_D_DAY

Dimension Day Position Entry Date

The position entry date role-playing dimension based on the day dimension.

PS_D_DAY

Dimension Day Start Date

The start date role-playing dimension based on the day dimension.

PS_D_DAY

Dimension Day Step Entry Date

The step entry date role-playing dimension based on the day dimension.

PS_D_DAY

Dimension Department

The department dimension includes information about the organizational entities in an organization. The dimension includes several attributes about a department like description, company code, location, and budget.

PS_D_DEPT

Dimension Department Tree

This dimension tracks the hierarchical relationship between organizations. Currently, there are 15 levels of organization hierarchies defined.

PS_V_DEPT

Dimension Frequency

The frequency dimension includes the payment and hour reporting frequency for time and payroll data. A frequency can be used to indicate how many times per year an event occurs.

PS_D_FREQ

Dimension Frequency Compensation Frequency

The compensation frequency role-playing dimension based on the frequency dimension.

PS_D_FREQ

Dimension Fund

This dimension includes details about fund codes and their description.

PS_D_FUND

Dimension Geography Tree

This dimension tracks the hierarchical relationship between geographical locations. Currently, there are 31 levels of geographical location hierarchies defined.

PS_V_GEOGRAPHY

Dimension Government Legal Authority 1

This dimension stores various Government Legal Authority Codes that are used by the agency to grant a personnel action request.

PS_D_GOV_AUTH

Dimension Government Legal Authority 2

This dimension includes various Government Legal Authority Codes that are used by the agency to grant a personnel action request.

PS_D_GOV_AUTH

Dimension Government Nature Of Action

This government nature of action dimension.

PS_D_GOV_NOA

Dimension Government Pay Plan

This dimension includes various pay plans that identify government wage progression plans. Wage progression plans are contract driven pay increase schedules. This is also used for retained pay plans for government employees.

PS_D_GOV_PAYPLN

Dimension Government Pay Plan Retained Pay Plan

This is a role-playing dimensions based on the payplan dimension used to list retained pay plans for Government customers.

PS_D_GOV_PAYPLN

Dimension Government Personnel Office

This dimension is used to identify government personnel offices, the agency/sub-agency they belong to, their addresses, telephone numbers, and contact names.

PS_D_GOV_POI

Dimension Government Sub Agency

This dimension is used to capture the bureau within an agency to which a department is assigned.

PS_D_GOV_SUBAG

Dimension Jobcode

The Jobcode dimension includes information about the job assignments in an organization. This dimension represents the categorization of jobs into types, such as executive, technical, etc.

PS_D_JOBCODE

Dimension Location

The Location dimension includes a list of work sites for an organization. Location is used to establish physical locations in an organization such as corporate headquarters, branch offices, remote sales offices, etc.

PS_D_LOCATION

Dimension Operating Unit

This dimension includes details about operating units, for example, a plant office physical location branch building.

PS_D_OPER_UNIT

Dimension Pay Group

This dimension is used to group employees by how they are paid.

PS_D_PAYGRP

Dimension Person

This dimension represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Dimension Person Manager

The manager role-playing dimension based on the person dimension.

PS_D_PERSON

Dimension Position

This dimension includes information on all job positions available, whether an employee fills the position or not. This dimension helps in data analysis based on salary or standard hours.

PS_D_POS

Dimension Position Government Position

This a role-playing dimension based on the Position dimension to list positions for Government customers.

PS_D_POS

Dimension Product

This dimension contains information on products that are offered for sale.

PS_D_PRODUCT

Dimension Project

The dimension includes information about projects. A project is a vehicle for identifying an initiative that has a specified start and end date.

PS_D_PRJ

Dimension Regulatory Region

This dimension includes all the codes for regulatory and regional edit purposes. A regulatory region can be any region where there are specific laws and regulations that are used for transactional purposes.

PS_D_REG_RGN

Dimension Salary Plan

The salary plan dimension includes unique salary categories that are defined in an organization. These categories are setup according to employee's compensation structure.

PS_D_SALPLN

Fact Employee Job

This dimension represents employee job data such as actions taken, department, job code, location, and salary history. This is a special case because PS_D_EMPL_JOB is considered a fact-like dimension table.

PS_D_EMPL_JOB

Annual Salary Range

Contains the annual salary range for an employee in base currency.

PS_D_EMPL_JOB.ANNL_BCE_RT

Annual Rate

Contains the current annual salary rate in base currency.

PS_D_EMPL_JOB.ANNL_BCE_RT

Annual Rate (R1)

Contains the current annual salary rate in reporting 1 currency.

PS_D_EMPL_JOB.ANNL_R1_RT

Annual Rate (R2)

Contains the current annual salary rate in reporting 2 currency.

PS_D_EMPL_JOB.ANNL_R2_RT

Annual Rate (Trans) (Annual Rate Transaction Currency)

Contains the current annual salary rate in transaction currency.

PS_D_EMPL_JOB.ANNL_RT

Annuity Offset Amount (Trans) (Annuity Offset Amount Transaction Currency)

Contains the annuity offset amount in transaction currency.

PS_D_EMPL_JOB.ANTY_OFFST_AMT

Annuity Offset Amount

Contains the annuity offset amount in base currency.

PS_D_EMPL_JOB.ANTY_OFFST_BCE_AMT

Annuity Offset Amount (R1)

Contains the annuity offset amount in reporting 1 currency.

PS_D_EMPL_JOB.ANTY_OFFST_R1_AMT

Annuity Offset Amount (R2)

Contains the annuity offset amount in reporting 2 currency.

PS_D_EMPL_JOB.ANTY_OFFST_R2_AMT

Annual Benefit Rate

Contains the base compensation rate used to calculate benefits and benefit deductions for an employee.

PS_D_EMPL_JOB.BNF_BASE_BCE_RT

Annual Benefit Rate (R1)

Contains the reporting 1 compensation rate used to calculate benefits and benefit deductions for an employee.

PS_D_EMPL_JOB.BNF_BASE_R1_RT

Annual Benefit Rate (R2)

Contains the reporting 2 compensation rate used to calculate benefits and benefit deductions for an employee.

PS_D_EMPL_JOB.BNF_BASE_R2_RT

Annual Benefit Rate (Trans) (Annual Benefit Rate Transaction Currency)

Contains the transaction compensation rate used to calculate benefits and benefit deductions for an employee.

PS_D_EMPL_JOB.BNF_BASE_RT

Change Amount (Trans) (Change Amount Transaction Currency)

Contains the difference between an employee's previous annual transaction amount and the current annual transaction amount.

PS_D_EMPL_JOB.CHNG_AMT

Change Amount

Contains the difference between an employee's previous annual base amount and the current annual base amount in base currency.

PS_D_EMPL_JOB.CHNG_BCE_AMT

Change Percentage

Contains the percentage difference between an employee's previous annual base amount and the current annual base amount.

PS_D_EMPL_JOB.CHNG_PCT

Change Amount (R1)

Contains the difference between an employee's previous annual amount and the current annual amount in reporting 1 currency.

PS_D_EMPL_JOB.CHNG_R1_AMT

Change Amount (R2)

Contains the difference between an employee's previous annual amount and the current annual amount in reporting 2 currency.

PS_D_EMPL_JOB.CHNG_R2_AMT

Compensation Rate

Contains the current compensation rate in base currency.

PS_D_EMPL_JOB.COMP_BCE_RT

Compensation Rate (R1)

Contains the current compensation rate in reporting 1 currency.

PS_D_EMPL_JOB.COMP_R1_RT

Compensation Rate (R2)

Contains the current compensation rate in reporting 2 currency.

PS_D_EMPL_JOB.COMP_R2_RT

Compensation Rate (Trans) (Compensation Rate Transaction Currency)

Contains the current compensation rate in transaction currency.

PS_D_EMPL_JOB.COMP_RT

Daily Rate

Contains the current daily salary rate in base currency.

PS_D_EMPL_JOB.DLY_BCE_RT

Daily Rate (R1)

Contains the current daily salary rate in reporting 1 currency.

PS_D_EMPL_JOB.DLY_R1_RT

Daily Rate (R2)

Contains the current daily salary rate in reporting 2 currency.

PS_D_EMPL_JOB.DLY_R2_RT

Daily Rate (Trans) (Daily Rate Transaction Currency)

Contains the current daily salary rate in transaction currency.

PS_D_EMPL_JOB.DLY_RT

Full Time Equivalent Percentage

Contains the full-time employee percentage, which is the amount of time an employee works compared to a full time employee.

PS_D_EMPL_JOB.EMPL_FTE_PCT

Headcount

Contains the employee headcount based on the current status.

COUNT_DISTINCT(CASE WHEN PS_D_EMPL_JOB.EMPL_STAT_CD IN ('A','L','P','S','W') THEN PS_D_EMPL_JOB.EMPL_JOB_SID ELSE 0 END)

Government Location Annual Pay Increase Percentage

Contains the percentage of annual government locality pay.

PS_D_EMPL_JOB.GOV_ANNL_LOC_PCT

Government Biweekly Rate

Contains the government biweekly salary rate in base currency.

PS_D_EMPL_JOB.GOV_BIWKLY_BCE_RT

Government Biweekly Rate (R1)

Contains the government biweekly salary rate in reporting 1 currency.

PS_D_EMPL_JOB.GOV_BIWKLY_R1_RT

Government Biweekly Rate (R2)

Contains the government biweekly salary rate in reporting 2 currency.

PS_D_EMPL_JOB.GOV_BIWKLY_R2_RT

Government Biweekly Rate (Trans) (Government Biweekly Rate Transaction Currency)

Contains the government biweekly salary rate in transaction currency.

PS_D_EMPL_JOB.GOV_BIWKLY_RT

Government Location Biweekly Pay Increase Percentage

Contains the percentage of biweekly government locality pay.

PS_D_EMPL_JOB.GOV_BW_LOC_PCT

Government Compensation Rate

Contains the government compensation rate in base currency.

PS_D_EMPL_JOB.GOV_COMP_BCE_RT

Government Compensation Rate (R1)

Contains the government compensation rate in reporting 1 currency.

PS_D_EMPL_JOB.GOV_COMP_R1_RT

Government Compensation Rate (R2)

Contains the government compensation rate in reporting 2 currency.

PS_D_EMPL_JOB.GOV_COMP_R2_RT

Government Compensation Rate (Trans) (Government Compensation Rate Transaction Currency)

Contains the government compensation rate in transaction currency.

PS_D_EMPL_JOB.GOV_COMP_RT

Government Daily Rate

Contains the government daily salary rate in base currency.

PS_D_EMPL_JOB.GOV_DLY_BCE_RT

Government Location Daily Pay Increase Percentage

Contains the percentage of daily government locality pay.

PS_D_EMPL_JOB.GOV_DLY_LOC_PCT

Government Daily Rate (R1)

Contains the government daily salary rate in reporting 1 currency.

PS_D_EMPL_JOB.GOV_DLY_R1_RT

Government Daily Rate (R2)

Contains the government daily salary rate in reporting 2 currency.

PS_D_EMPL_JOB.GOV_DLY_R2_RT

Government Daily Rate (Trans) (Government Daily Rate Transaction Currency)

Contains the government daily salary rate in transaction currency.

PS_D_EMPL_JOB.GOV_DLY_RT

Government Location Hourly Pay Increase Percentage

Contains the percentage of hourly government locality pay.

PS_D_EMPL_JOB.GOV_HRLY_LOC_PCT

Government Location Adjustment Pay Increase Percentage

Contains the percentage of government locality pay adjustment.

PS_D_EMPL_JOB.GOV_LOC_ADJ_PCT

Government Location Monthly Pay Increase Percentage

Contains the percentage of monthly government locality pay.

PS_D_EMPL_JOB.GOV_MNLY_LOC_PCT

Hourly Rate

Contains the current hourly salary rate in base currency.

PS_D_EMPL_JOB.HRLY_BCE_RT

Hourly Rate (R1)

Contains the current hourly salary rate in reporting 1 currency.

PS_D_EMPL_JOB.HRLY_R1_RT

Hourly Rate (R2)

Contains the current hourly salary rate in reporting 2 currency.

PS_D_EMPL_JOB.HRLY_R2_RT

Hourly Rate (Trans) (Hourly Rate Transaction Currency)

Contains the current hourly salary rate in transaction currency.

PS_D_EMPL_JOB.HRLY_RT

Monthly Rate

Contains the current monthly salary rate in base currency.

PS_D_EMPL_JOB.MNTHLY_BCE_RT

Monthly Rate (R1)

Contains the current monthly salary rate in reporting 1 currency.

PS_D_EMPL_JOB.MNTHLY_R1_RT

Monthly Rate (R2)

Contains the current monthly salary rate in reporting 2 currency.

PS_D_EMPL_JOB.MNTHLY_R2_RT

Monthly Rate (Trans) (Monthly Rate Transaction Currency)

Contains the current monthly salary rate in transaction currency.

PS_D_EMPL_JOB.MNTHLY_RT

Separation Count

Contains the count of workforce with Action as Completion, Layoff, Long Term Disability, Suspension, or Termination.

COUNT_DISTINCT(CASE WHEN PS_D_EMPL_JOB.ACN_CD IN ('COM','LOF','LTD','LTO','SUS','TDL','TER','TWB','TWP') THEN PS_D_EMPL_JOB.PERSON_SID ELSE NULL END)

Hire Count

Contains the count of workforce with action as Addition of Employee, Hire, or Rehire.

COUNT_DISTINCT(CASE WHEN PS_D_EMPL_JOB.ACN_CD IN ('ADD','HIR','REH') THEN PS_D_EMPL_JOB.PERSON_SID ELSE NULL END)

Action Count

Contains the headcount of active employees by action code.

COUNT_DISTINCT(PS_D_EMPL_JOB.PERSON_SID)

Transfer Count

Contains the transfer count of workforce, which includes Returning From Leave, Disability, Temporary Assignment, or Work Break.

COUNT_DISTINCT(CASE WHEN PS_D_EMPL_JOB.ACN_CD IN ('RFA','RFD','RFL','RWB','XFR') THEN PS_D_EMPL_JOB.PERSON_SID ELSE NULL END)

Total Separation Rate

Contains the ratio of Separation Count and Headcount.

Separation Count/DECODE(Headcount,0,NULL,Headcount)

Hire To Separation Ratio

Contains the ratio of Hire Count and Separation Count.

Hire Count/DECODE(Separation Count,0,NULL,Separation Count)

Shift Rate

Contains the shift differential rate in base currency.

PS_D_EMPL_JOB.SHIFT_BCE_RT

Shift Rate (R1)

Contains the shift differential rate in reporting 1 currency.

PS_D_EMPL_JOB.SHIFT_R1_RT

Shift Rate (R2)

Contains the shift differential rate in reporting 2 currency.

PS_D_EMPL_JOB.SHIFT_R2_RT

Shift Rate (Trans) (Shift Rate Transaction Currency)

Contains the shift differential rate in transaction currency.

PS_D_EMPL_JOB.SHIFT_RT

Work Day Hours

Contains the day hours worked by an employee.

PS_D_EMPL_JOB.STD_DY_HR_QTY

Standard Weekly Hours

Contains the standard hours worked by an employee.

PS_D_EMPL_JOB.STD_WK_HR_QTY

Annual Salary Range

Contains the annual salary range for an employee in base currency.

CASE WHEN PS_D_EMPL_JOB.ANNL_BCE_RT < 20000 THEN 'BELOW 20K' WHEN PS_D_EMPL_JOB.ANNL_BCE_RT >= 20000 AND PS_D_EMPL_JOB.ANNL_BCE_RT <= 40000 THEN '20K-40K' WHEN PS_D_EMPL_JOB.ANNL_BCE_RT >= 41000 AND PS_D_EMPL_JOB.ANNL_BCE_RT <= 70000 THEN '41K-70K' WHEN PS_D_EMPL_JOB.ANNL_BCE_RT > 70000 THEN 'OVER 70K' ELSE 'N.A.' END

Turnover Status

Contains the turnover status of the employee.

CASE WHEN PS_D_EMPL_JOB.ACN_CD IN ('ADD','HIR','REH') THEN 'HIRE' WHEN PS_D_EMPL_JOB.ACN_CD IN ('RFA','RFD','RFL','RWB','XFR') THEN 'TRANSFER' WHEN PS_D_EMPL_JOB.ACN_CD IN ('COM','LOF','LTD','LTO','SUS','TDL','TER','TWB','TWP') THEN 'TERMINATED' ELSE 'N.A.' END

Number of Years Experience

Contains the years of work experience of the employee.

PS_D_PERSON.EXP_YR_NUM

Age

Contains the age of the employee.

TO_NUMBER(TO_CHAR(SYSDATE,'YYYY'))-TO_NUMBER(TO_CHAR(PS_D_PERSON.BIRTH_DT,'YYYY'))

Age Range

Contains the age classification of the employee.

CASE WHEN Age < 20 THEN 'BELOW 20' WHEN Age >= 20 AND Age <= 30 THEN '20-30' WHEN Age >= 31 AND Age <= 50 THEN '31-50' WHEN Age > 50 THEN 'OVER 50' ELSE 'N.A.' END

Job Duration

Contains the number of years of experience for the employee.

TO_NUMBER(TO_CHAR(SYSDATE,'YYYY'))-TO_NUMBER(TO_CHAR(Job Entry Day Date,'YYYY'))

Years of Service Range

Contains the experience service range for the employee.

CASE WHEN Job Duration < 1 THEN 'BELOW 1' WHEN Job Duration >= 1 AND Job Duration <= 5 THEN '1-5' WHEN Job Duration >= 6 AND Job Duration <= 10 THEN '6-10' WHEN Job Duration > 10 THEN 'OVER 10' ELSE 'N.A.' END

Salary Grade Duration

Contains the salary grade duration in years.

TO_NUMBER(TO_CHAR(SYSDATE,'YYYY'))-TO_NUMBER(TO_CHAR(Grade Entry Day Date,'YYYY'))

Department Duration

Contains the number of years of experience for the employee in a particular department.

TO_NUMBER(TO_CHAR(SYSDATE,'YYYY'))-TO_NUMBER(TO_CHAR(Department Entry Day Date,'YYYY'))

Dimension Day Ambulance Arrival Date

This dimension is role-playing for ambulance arrival date based on day dimension.

PS_D_DAY

Dimension Day Ambulance Contact Date

This dimension is role-playing for ambulance contact date based on day dimension.

PS_D_DAY

Dimension Day Filed Date

This dimension is role-playing for incident filed date based on day dimension.

PS_D_DAY

Dimension Day Incident Date

This dimension is role-playing for incident date based on day dimension.

PS_D_DAY

Dimension Day Injury Date

This dimension is role-playing for injury date based on day dimension.

PS_D_DAY

Dimension Day Last Work Date

This dimension is role-playing for last work date based on day dimension.

PS_D_DAY

Dimension Day Report Date

This dimension is role-playing for report date based on day dimension.

PS_D_DAY

Dimension Day Return Date

This dimension is role-playing for return date based on day dimension.

PS_D_DAY

Dimension Employee Job

This dimension represents an employee job history data such as actions taken, department, job code, location, and salary history. Multiple records can be created for an employee.

PS_D_EMPL_JOB

Dimension Incident

This dimension contains details about the health and safety incidents.

PS_D_INCIDENT

Dimension Injury Illness

This dimension contains miscellaneous attributes that are captured along with injury or illness data.

PS_D_INJ_ILL_JNK

Dimension Person

This dimension represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Dimension Regulatory Region

This dimension includes all the codes for regulatory and regional edit purposes. A regulatory region can be any region where there are specific laws and regulations that are used for transactional purposes.

PS_D_REG_RGN

Dimension Time Ambulance Arrival Time

This dimension is role-playing for ambulance arrival time based on time dimension.

PS_D_TIME

Dimension Time Ambulance Contact Time

This dimension is role-playing for ambulance contact time based on time dimension.

PS_D_TIME

Dimension Time Injury Time

This dimension is role-playing for injury time based on time dimension.

PS_D_TIME

Dimension Time Last Work Time

This dimension is role-playing for last work time based on time dimension.

PS_D_TIME

Dimension Time Report Time

This dimension is role-playing for report time based on time dimension.

PS_D_TIME

Dimension Time Return Time

This dimension is role-playing for return time based on time dimension.

PS_D_TIME

Fact Injury Illness Incidents

Includes details on health and safety issues specifically concerning employee injury incidents, illness incidents, or both.

PS_F_INJ_ILL

Headcount

Contains the employee headcount based on the current status.

COUNT_DISTINCT(CASE WHEN PS_D_EMPL_JOB.EMPL_STAT_CD IN ('A','L','P','S','W') THEN PS_D_EMPL_JOB.EMPL_JOB_SID ELSE NULL END)

Age

Contains the age of the employee.

TO_NUMBER(TO_CHAR(SYSDATE,'YYYY'))-TO_NUMBER(TO_CHAR(PS_D_PERSON.BIRTH_DT_SID,'YYYY'))

Birth Date

Contains the date of birth of a person.

PS_D_PERSON.BIRTH_DT_SID

Incident Count

Contains the incident count in the workforce.

COUNT_DISTINCT(PS_D_PERSON.PERSON_SID)

Days Away From Work

Contains the number of days the employee was away from work due to injury, illness, or both.

PS_F_INJ_ILL.AWAY_FROM_WDAY_NUM

Restricted Workdays

Contains the number of days the employee was restricted from work due to injury, illness, or both.

PS_F_INJ_ILL.RESTRICTD_WDAY_NUM

Unconscious Hours

Contains the number of hours the employee was unconscious due to injury, illness, or both.

PS_F_INJ_ILL.UNCNSCS_HR_NUM

Dimension Account

This dimension includes details of an account, which represents a ChartField.

PS_V_ACCOUNT

Dimension Business Unit

The business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Chartfield1

This dimension includes user defined ChartField details.

PS_D_CHARTFIELD1

Dimension Chartfield2

This dimension includes user defined ChartField details.

PS_D_CHARTFIELD2

Dimension Chartfield3

This dimension includes user defined ChartField details.

PS_D_CHARTFIELD3

Dimension Class Field

This dimension includes expense classification codes and description.

PS_D_CLASS_FIELD

Dimension Company

The company dimension includes company-related information.

PS_D_CMPNY

Dimension Customer

The customer dimension includes information for entities that can participate in business relationships.

PS_D_CUSTOMER

Dimension Day Report Date

This dimension is role-playing for report date based on day dimension.

PS_D_DAY

Dimension Department

The department dimension includes information about the organizational entities in an organization. The dimension includes several attributes about a department like description, company code, location, and budget.

PS_D_DEPT

Dimension Employee Job

This dimension represents an employee job history data such as actions taken, department, job code, location, and salary history. Multiple records can be created for an employee.

PS_D_EMPL_JOB

Dimension Fund

This dimension includes details about fund codes and their description.

PS_D_FUND

Dimension Jobcode

The Jobcode dimension includes information about the job assignments in an organization. This dimension represents the categorization of jobs into types, such as executive, technical, etc.

PS_D_JOBCODE

Dimension Location

The Location dimension includes a list of work sites for an organization. Location is used to establish physical locations in an organization such as corporate headquarters, branch offices, remote sales offices, etc.

PS_D_LOCATION

Dimension Operating Unit

This dimension includes details about operating units, for example, a plant office physical location branch building.

PS_D_OPER_UNIT

Dimension Person

This dimension represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Dimension Position

This dimension includes information on all job positions available, whether an employee fills the position or not. This dimension helps in data analysis based on salary or standard hours.

PS_D_POS

Dimension Product

This dimension contains information on products that are offered for sale.

PS_D_PRODUCT

Dimension Project Activity

The activity dimension includes information about a project's activities (tasks). This dimension rolls-up to the project dimension.

PS_D_PRJ_AC

Dimension Project Resource

The project resource dimension includes information that classifies project financial transactions.

PS_D_PRJ_RSRC

Dimension Time Reporting Code

The time reporting code (TRC) dimension represents information (for example, Contract holiday, Floating Holiday, Illness - Paid, Jury Duty, Personal - Paid, and Vacation) about TRCs.

PS_D_TRC

Fact Time and Labor

Tracks payable time by dimensions such as Time Reporting Code, Company, Business Unit, Department, Location, Job Code, Position, Project and many accounting ChartFields.

PS_F_TIME_LABOR

Number of Hours

Contains the amount of hours used to determine an employee’s base pay.

PS_F_TIME_LABOR.TL_HR_QTY

Dimension Absence Miscellaneous

This dimension contains all absence-related indicators, including attributes to indicate whether the leave is paid, if it is a work related injury, and so on.

PS_D_AB_JNK

Dimension Absence Type

This dimension contains information related to absence history and requests, including attributes such as absence type, absence class, and certification period.

PS_D_AB_TYPE

Dimension Day Approval Date

A role-playing dimension based on day dimension for the approval date.

PS_D_DAY

Dimension Day Begin Date

A role-playing dimension based on day dimension.

PS_D_DAY

Dimension Day Notified Date

A role-playing dimension based on day dimension.

PS_D_DAY

Dimension Day Return Date

This dimension is role-playing for return date based on day dimension.

PS_D_DAY

Dimension Employee Job

This dimension represents an employee job history data such as actions taken, department, job code, location, and salary history. Multiple records can be created for an employee.

PS_D_EMPL_JOB

Dimension Person

This dimension represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Dimension Person Responsible

The responsible person dimension includes the most current personal information of both employees and non-employees of an organization

PS_D_PERSON

Dimension Time Begin Time

A role-playing dimension based on time dimension.

PS_D_TIME

Dimension Time Notified Time

A role-playing dimension based on time dimension.

PS_D_TIME

Dimension Time Return Time

This dimension is role-playing for return time based on time dimension.

PS_D_TIME

Fact Absence

Includes leave and absence occurrences.

PS_F_AB

Absence Duration (in days)

This is the absence duration in number of days.

PS_F_AB.DRTN_DY_QTY

Absence Duration (in hours)

This is the absence duration in number of hours.

PS_F_AB.DRTN_HR_QTY

Absence Count

Contains the number of times absent.

COUNT(PS_F_AB.PERSON_SID)

Dimension Benefit Plan

Contains information on all of the benefit plans offered by a company. It keeps track of all of the offerings by an organization and third parties associated in carrying these plans.

PS_D_BNF_PLN

Dimension Company

Includes company-related information.

PS_D_CMPNY

Dimension Day Accrual Date

The role-playing dimension for accrual date based on the Day dimension.

PS_D_DAY

Dimension Employee Job

Represents employee job history data, such as actions taken, department, job code, location, and salary history. Multiple records can be created for an employee.

PS_D_EMPL_JOB

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Dimension Company

Includes company-related information.

PS_D_CMPNY

Dimension Day Accrual Date

The role-playing dimension for accrual date based on the Day dimension.

PS_D_DAY

Fact Absence Accrual

Includes allowable absence or vacation earned for the year based on a set time interval.

PS_F_AB_ACRL

Carryover Day YTD (Carryover Day Year to Date)

Contains the number of absence or vacation days carried over from prior year.

PS_F_AB_ACRL.CARRYOVER_QTY

Leave Earned Day YTD

Contains the number of absence or vacation days earned year-to-date.

PS_F_AB_ACRL.ERN_YTD_QTY

Leave Taken Day YTD

Contains the number of absence or vacation days used year-to-date.

PS_F_AB_ACRL.TAKEN_YTD_QTY

Leave Entitlement Balance

Contains the total number of leave days to which an employee is entitled, including days earned Year to Date (YTD), days carried over, and days taken.

Leave Earned Day YTD + Carryover Day YTD-Leave Taken Day YTD

Dimension Absence Event

Includes absence event related indicators.

PS_D_AB_EVENT

Dimension Day Action Submit Date

The role-playing dimension for the action submit date based on the Day dimension.

PS_D_DAY

Dimension Day Begin Date

The role-playing dimension for begin date based on the Day dimension.

PS_D_DAY

Dimension Day End Date

The end date role-playing dimension based on the Day dimension.

PS_D_DAY

Dimension Day Original Begin Date

The role-playing dimension for the original begin date based on the Day dimension.

PS_D_DAY

Dimension Day Process Date

A role-playing dimension based on day dimension

PS_D_DAY

Dimension Employee Job

Represents employee job history data, such as actions taken, department, job code, location, and salary history. Multiple records can be created for an employee.

PS_D_EMPL_JOB

Dimension Global Payroll PIN

Contains the information related the PIN name elements, used in global payroll to allow for flexibility in configuration.

PS_D_GP_PIN

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Fact Absence Event

Contains leave and absence information for global payroll.

PS_F_AB_EVENT

Absence Duration

Contains the duration of an employee’s absence in days

PS_F_AB_EVENT.ABSENCE_DRTN_QTY

Begin Date Partial Hours

Contains the number of hours that the payee was absent for the begin date.

PS_F_AB_EVENT.BEGIN_DAY_HR_QTY

End Date Partial Hours

Contains the number of hours that the payee was absent for the end date.

PS_F_AB_EVENT.END_DAY_HR_QTY

Override Adjustment Amount (Trans)

Contains the transaction (Trans) currency amount used to adjust the entitlement balance.

PS_F_AB_EVENT.OVRD_ADJ_AMT

Override Adjustment Amount

Contains the base currency amount used to adjust the entitlement balance.

PS_F_AB_EVENT.OVRD_ADJ_BCE_AMT

Override Adjustment Amount (R1)

Contains the reporting 1 currency amount used to adjust the entitlement balance.

PS_F_AB_EVENT.OVRD_ADJ_R1_AMT

Override Adjustment Amount (R2)

Contains the reporting 2 currency amount used to adjust the entitlement balance.

PS_F_AB_EVENT.OVRD_ADJ_R2_AMT

Override Entitlement Amount (Trans) (Override Entitlement Amount Transaction Currency)

Contains the transaction currency amount used to override the entitlement for this event.

PS_F_AB_EVENT.OVRD_ENT_AMT

Override Entitlement Amount

Contains the base currency amount used to override the entitlement for this event.

PS_F_AB_EVENT.OVRD_ENT_BCE_AMT

Override Entitlement Amount (R1)

Contains the reporting 1 currency amount used to override the entitlement for this event.

PS_F_AB_EVENT.OVRD_ENT_R1_AMT

Override Entitlement Amount (R2)

Contains the reporting 2 currency amount used to override the entitlement for this event.

PS_F_AB_EVENT.OVRD_ENT_R2_AMT

Dimension Absence Type

Contains information related to absence history and requests, including attributes such as absence type, absence class, and certification period.

PS_D_AB_TYPE

Dimension Benefit Plan

Contains information on all of the benefit plans offered by a company. It keeps track of all of the offerings by an organization and third parties associated in carrying these plans.

PS_D_BNF_PLN

Dimension Company

Includes company-related information.

PS_D_CMPNY

Dimension Day Accrual Date

The role-playing dimension for accrual date based on the Day dimension.

PS_D_DAY

Dimension Day Approval Date

The role-playing dimension for the approval date based on the Day dimension.

PS_D_DAY

Dimension Day Begin Date

The role-playing dimension for begin date based on the Day dimension.

PS_D_DAY

Dimension Day Request Date

The role-playing dimension for request date based on the Day dimension.

PS_D_DAY

Dimension Day Return Date

A role-playing for return date based on the Day dimension.

PS_D_DAY

Dimension Employee Job

Represents employee job history data, such as actions taken, department, job code, location, and salary history. Multiple records can be created for an employee.

PS_D_EMPL_JOB

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Fact Absence Request

Includes absence requests for employees.

PS_F_AB_REQUEST

Duration (in days)

Contains the duration of the absence in days.

PS_F_AB_REQUEST.DRTN_DY_QTY

Dimension Benefit Plan

Contains information on all of the benefit plans offered by a company. It keeps track of all of the offerings by an organization and third parties associated in carrying these plans.

PS_D_BNF_PLN

Dimension Benefit Plan After Tax Rollover

The role-playing dimension based on the Benefit Plan dimension that contains information on all of the after tax rollover benefit plans offered by a company.

PS_D_BNF_PLN

Dimension Benefit Plan Before Tax Rollover

The role-playing dimension based on the Benefit Plan dimension that contains information on all of the before tax rollover benefit plans offered by a company.

PS_D_BNF_PLN

Dimension Benefit Source

Contains the source of benefit enrollment data that populates the benefit enrollment fact.

PS_D_BNF_SRC

Dimension Coverage

Captures the coverage codes used to define the coverage level of a health benefit.

PS_D_COVRG

Dimension Coverage Election

Captures the available types of benefit coverage elections.

PS_D_COVRG_ELECT

Dimension Day Coverage Begin Date

The role-playing dimension for coverage begin date based on the Day dimension.

PS_D_DAY

Dimension Day Coverage Election Date

The role-playing dimension for coverage election date based on the Day dimension.

PS_D_DAY

Dimension Day Coverage End Date

The role-playing dimension for coverage end date based on the Day dimension.

PS_D_DAY

Dimension Day Deduction End Date

The role-playing dimension for deduction end date based on the Day dimension.

PS_D_DAY

Dimension Day Health HIPPA Report Date

The role-playing dimension for health report date based on the Day dimension.

PS_D_DAY

Dimension Employee Job

Represents employee job history data, such as actions taken, department, job code, location, and salary history. Multiple records can be created for an employee.

PS_D_EMPL_JOB

Dimension Health Benefit Miscellaneous

Includes miscellaneous attributes related to health benefits.

PS_D_HLTH_BNF_JNK

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Dimension Savings Plan Miscellaneous

Includes miscellaneous attributes related to health benefits.

PS_D_SAV_PLN_JNK

Dimension Benefit Plan

Contains information on all of the benefit plans offered by a company. It keeps track of all of the offerings by an organization and third parties associated in carrying these plans.

PS_D_BNF_PLN

Fact Benefit Enrollment

Provides analysis for benefit enrollment data for the different benefit plans and the capability to calculate benefit valuations that are not processed by the payroll system.

PS_F_BNF_ENRLMT

Annual Excess Credits (Trans)

Contains the annual excess credits amount in transaction (trans) currency.

PS_F_BNF_ENRLMT.AEXCRED_AMT

Annual Excess Credits

Contains the annual excess credit amount in base currency.

PS_F_BNF_ENRLMT.AEXCRED_BCE_AMT

Annual Excess Credits (R1)

Contains the annual excess credits amount in reporting 1 currency.

PS_F_BNF_ENRLMT.AEXCRED_R1_AMT

Annual Excess Credits (R2)

Contains the annual excess credits amount in reporting 2 currency.

PS_F_BNF_ENRLMT.AEXCRED_R2_AMT

Car Allowance Amount (Trans) (Car Allowance Amount Transaction Currency)

Contains the car or vehicle allowance amount in transaction currency.

PS_F_BNF_ENRLMT.ALLOW_AMT

Car Allowance Amount

Contains the car or vehicle allowance amount in base currency.

PS_F_BNF_ENRLMT.ALLOW_BCE_AMT

Car Allowance Amount (R1)

Contains the car or vehicle allowance amount in reporting 1 currency.

PS_F_BNF_ENRLMT.ALLOW_R1_AMT

Car Allowance Amount (R2)

Contains the car or vehicle allowance amount in reporting 2 currency.

PS_F_BNF_ENRLMT.ALLOW_R2_AMT

FSA Contribution Amount (Trans) (Flexible Spending Account Contribution Transaction Currency)

Contains the employee's flexible spending account (FSA) contribution in transaction currency.

PS_F_BNF_ENRLMT.ECONTRIB_AMT

FSA Contribution Amount

Contains the employee's flexible spending account contribution in base currency.

PS_F_BNF_ENRLMT.ECONTRIB_BCE_AMT

FSA Contribution Amount (R1)

Contains the employee's flexible spending account contribution in reporting 1 currency.

PS_F_BNF_ENRLMT.ECONTRIB_R1_AMT

FSA Contribution Amount (R2)

Contains the employee's flexible spending account contribution in reporting 2 currency.

PS_F_BNF_ENRLMT.ECONTRIB_R2_AMT

Life ADD Benefit Salary Multiplier (Life Accidental Death and Dismemberment Benefit Salary Multiplier)

Contains the salary multiplier for life or accidental death and dismemberment (ADD) benefit coverage.

PS_F_BNF_ENRLMT.FACTOR_XSALARY_NUM

Life ADD Flat Amount (Trans) (Life ADD Flat Amount Transaction Currency)

Contains the flat amount coverage for life or accidental death and dismemberment (ADD) benefit coverage, in transaction currency.

PS_F_BNF_ENRLMT.FLAT_AMT

Life ADD Flat Amount

Contains the flat amount coverage for life or accidental death and dismemberment (ADD) benefit coverage, in base currency.

PS_F_BNF_ENRLMT.FLAT_BCE_AMT

Life ADD Flat Amount (R1)

Contains the flat amount coverage for life or accidental death and dismemberment (ADD) benefit coverage, in reporting 1 currency.

PS_F_BNF_ENRLMT.FLAT_R1_AMT

Life ADD Flat Amount (R2)

Contains the flat amount coverage life or accidental death and dismemberment (ADD) benefit coverage, in reporting 2 currency.

PS_F_BNF_ENRLMT.FLAT_R2_AMT

Savings Flat Deduction Amount (Trans) (Savings Flat Deduction Amount Transaction Currency)

Contains the flat deduction amount for a savings plan in transaction currency.

PS_F_BNF_ENRLMT.FLDD_AMT

Savings Deduction After Tax Amount (Trans) (Savings Deduction After Tax Amount Transaction Currency)

Contains the flat deduction amount after tax for savings plan in transaction currency.

PS_F_BNF_ENRLMT.FLDD_ATAX_AMT

Savings Deduction After Tax Amount

Contains the flat deduction amount after tax for savings plan in base currency.

PS_F_BNF_ENRLMT.FLDD_ATAX_BCE_AMT

Savings Deduction Amount After Tax (R1)

Contains the flat deduction amount after tax for savings plan in reporting 1 currency.

PS_F_BNF_ENRLMT.FLDD_ATAX_R1_AMT

Savings Deduction Amount After Tax (R2)

Contains the flat deduction amount after tax for savings plan in reporting 2 currency.

PS_F_BNF_ENRLMT.FLDD_ATAX_R2_AMT

Savings Flat Deduction Amount

Contains the flat deduction amount for savings plan in base currency.

PS_F_BNF_ENRLMT.FLDD_BCE_AMT

Savings Flat Deduction Amount (R1

Contains the flat deduction amount for savings plan in reporting 1 currency.

PS_F_BNF_ENRLMT.FLDD_R1_AMT

Savings Flat Deduction Amount (R2)

Contains the flat deduction amount for savings plan in reporting 2 currency.

PS_F_BNF_ENRLMT.FLDD_R2_AMT

Vacation Goal Amount (Trans) (Vacation Goal Amount Transaction Currency)

Contains the vacation goal amount in transaction currency.

PS_F_BNF_ENRLMT.GOAL_AMT

Vacation Goal Balance Amount (Trans) (Vacation Goal Balance Amount Transaction Currency)

Contains the vacation goal balance in transaction currency.

PS_F_BNF_ENRLMT.GOAL_BAL_AMT

Vacation Goal Balance Amount

Contains the vacation goal balance in base currency.

PS_F_BNF_ENRLMT.GOAL_BAL_BCE_AMT

Vacation Goal Balance Amount (R1)

Contains the vacation goal balance in reporting 1 currency.

PS_F_BNF_ENRLMT.GOAL_BAL_R1_AMT

Vacation Goal Balance Amount (R2)

Contains the vacation goal balance in reporting 2 currency.

PS_F_BNF_ENRLMT.GOAL_BAL_R2_AMT

Vacation Goal Amount

Contains the vacation goal amount in base currency.

PS_F_BNF_ENRLMT.GOAL_BCE_AMT

Vacation Goal Amount (R1)

Contains the vacation goal amount in reporting 1 currency.

PS_F_BNF_ENRLMT.GOAL_R1_AMT

Vacation Goal Amount (R2)

Contains the vacation goal amount in reporting 2 currency.

PS_F_BNF_ENRLMT.GOAL_R2_AMT

Savings Gross After Tax Percentage

Contains the savings percentage of gross salary after tax.

PS_F_BNF_ENRLMT.GROSS_ATAX_PCT

Savings Gross Percentage

Contains the savings percentage of gross salary.

PS_F_BNF_ENRLMT.GROSS_PCT

Pension Amount

Contains the pension contribution amount in base currency.

PS_F_BNF_ENRLMT.PENSION_BCE_AMT

Pension Amount (Trans) (Pension Amount Transaction Currency)

Contains the pension contribution amount in transaction currency.

PS_F_BNF_ENRLMT.PEN_AMT

Pension Amount (R1)

Contains the pension contribution amount in reporting 1 currency.

PS_F_BNF_ENRLMT.PEN_R1_AMT

Pension Amount (R2)

Contains the pension contribution amount in reporting 2 currency.

PS_F_BNF_ENRLMT.PEN_R2_AMT

Health Premium Pre Tax Amount (Trans) (Health Premium Pre Tax Amount Transaction Currency)

Contains the pre-tax medical premium value in transaction currency.

PS_F_BNF_ENRLMT.PRETAX_AMT

Health Premium Pre Tax Amount

Contains the pre-tax medical premium value in base currency.

PS_F_BNF_ENRLMT.PRETAX_BCE_AMT

Health Premium Amount Pre Tax (R1)

Contains the pre-tax medical premium value in reporting 1 currency.

PS_F_BNF_ENRLMT.PRETAX_R1_AMT

Health Premium Amount Pre Tax (R2)

Contains the pre-tax medical premium value in reporting 2 currencies.

PS_F_BNF_ENRLMT.PRETAX_R2_AMT

Pension Voluntary Percentage

Contains the pension voluntary contribution percent of the gross salary.

PS_F_BNF_ENRLMT.VOLUNTARY_PCT

Pension Voluntary Amount (Trans) (Pension Voluntary Amount Transaction Currency)

Contains the voluntary pension contribution amount in transaction currency.

PS_F_BNF_ENRLMT.VOLUN_AMT

Pension Voluntary Amount

Contains the voluntary pension contribution amount in base currency.

PS_F_BNF_ENRLMT.VOLUN_BCE_AMT

Pension Voluntary Amount (R1)

Contains the voluntary pension contribution amount in reporting 1 currency.

PS_F_BNF_ENRLMT.VOLUN_R1_AMT

Pension Voluntary Amount (R2)

Contains the voluntary pension contribution amount in reporting 2 currency.

PS_F_BNF_ENRLMT.VOLUN_R2_AMT

Benefit Enrollment Count

This complex metric contains the count of employtees who have enrolled.

COUNT_DISTINCT(Person Sid)

Dimension Business Unit

The business unit dimension that contains a list of business units used by an organization.

PS_D_BUSINESS_UNIT

Dimension Company

Includes company-related information.

PS_D_CMPNY

Dimension Day Accumulator From Date

The role-playing dimension based on for accumulator from date based on the Day dimension.

PS_D_DAY

Dimension Day Accumulator Through Date

The role-playing dimension based on for accumulator through date based on the Day dimension.

PS_D_DAY

Dimension Day Begin Date

The role-playing dimension for begin date based on the Day dimension.

PS_D_DAY

Dimension Day End Date

The role-playing dimension for end date based on the Day dimension.

PS_D_DAY

Dimension Department

Includes information about the organizational entities in an organization. The dimension includes several attributes about a department, such as description, company code, location, and budget.

PS_D_DEPT

Dimension Employee Job

Represents employee job history data, such as actions taken, department, job code, location, and salary history. Multiple records can be created for an employee.

PS_D_EMPL_JOB

Dimension Global Payroll PIN

Contains the information related the PIN name elements, used in global payroll to allow for flexibility in configuration.

PS_D_GP_PIN

Dimension Global Payroll Pay Group

Contains information related to pay groups for Global Payroll (GP) processing, including the pay entity attribute.

PS_D_GP_PAYGRP

Dimension Location

Includes a list of work sites for an organization. Location is used to establish physical locations in an organization, such as corporate headquarters, branch offices, remote sales offices, and so on.

PS_D_LOCATION

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Fact Global 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 system.

PS_F_GBL_PAYROLL

Delta Amount (Trans) (Delta Amount Transaction Currency)

Contains the difference between the original base and calculated base value in transaction currency.

PS_F_GBL_PAYROLL.BASE_AMT

Delta Amount

Contains the difference between the original base and calculated base value in base currency.

PS_F_GBL_PAYROLL.BASE_BCE_AMT

Delta Amount (R1)

Contains the difference between the original base and calculated base value in reporting 1 currency.

PS_F_GBL_PAYROLL.BASE_R1_AMT

Delta Amount (R2)

Contains the difference between the original base and calculated base value in reporting 2 currency.

PS_F_GBL_PAYROLL.BASE_R2_AMT

Calculation Result Amount (Trans) (Calculation Result Amount Transaction Currency)

Contains the calculated result value amount in transaction currency.

PS_F_GBL_PAYROLL.CALC_AMT

Calculation Result Amount

Contains the calculated result value amount in base currency.

PS_F_GBL_PAYROLL.CALC_BCE_AMT

Calculation Result Amount (R1)

Contains the calculated result value amount in reporting 1 currency.

PS_F_GBL_PAYROLL.CALC_R1_AMT

Calculation Result Amount (R2)

Contains the calculated result value amount in reporting 2 currency.

PS_F_GBL_PAYROLL.CALC_R2_AMT

Percent Result Value

Contains the percent of the result value amount.

PS_F_GBL_PAYROLL.PCT_RSLT_VAL

Result Amount Added To Arrears (Trans) (Result Amount Added to Arrears Transaction Currency)

Contains the additional arrears added to results amount for deduction in transaction currency.

PS_F_GBL_PAYROLL.RAA_AMT

Result Amount Added To Arrears

Contains the additional arrears added to results amount for deduction in base currency.

PS_F_GBL_PAYROLL.RAA_BCE_AMT

Result Amount Added To Arrears (R1)

Contains the additional arrears added to results amount for deduction in reporting 1 currency.

PS_F_GBL_PAYROLL.RAA_R1_AMT

Result Amount Added To Arrears (R2)

Contains the additional arrears added to results amount for deduction in reporting 2 currency.

PS_F_GBL_PAYROLL.RAA_R2_AMT

Result Amount (Trans) (Result Amount Transaction Currency)

Contains the result amount in transaction currency.

PS_F_GBL_PAYROLL.RATE_AMT

Result Amount

Contains the result amount in base currency.

PS_F_GBL_PAYROLL.RATE_BCE_AMT

Result Amount (R1)

Contains the result amount in reporting 1 currency.

PS_F_GBL_PAYROLL.RATE_R1_AMT

Result Amount (R2)

Contains the result amount in reporting 2 currency.

PS_F_GBL_PAYROLL.RATE_R2_AMT

Result Amount Not Taken (Trans) (Result Amount Not Taken Transaction Currency)

Contains the result amount not taken as part of deduction amount in transaction currency.

PS_F_GBL_PAYROLL.RNT_AMT

Result Amount Not Taken

Contains the result amount not taken as part of deduction amount in base currency.

PS_F_GBL_PAYROLL.RNT_BCE_AMT

Result Amount Not Taken (R1)

Contains the result amount not taken as part of deduction amount in reporting 1 currency.

PS_F_GBL_PAYROLL.RNT_R1_AMT

Result Amount Not Taken (R2)

Contains the result amount not taken as part of deduction amount in reporting 2 currency.

PS_F_GBL_PAYROLL.RNT_R2_AMT

Payback Result Amount (Trans) (Payback Result Amount Transaction Currency)

Contains the payback result amount in transaction currency.

PS_F_GBL_PAYROLL.RPBK_AMT

Payback Result Amount

Contains the payback result amount in base currency.

PS_F_GBL_PAYROLL.RPBK_BCE_AMT

Payback Result Amount (R1)

Contains the payback result amount in reporting 1 currency.

PS_F_GBL_PAYROLL.RPBK_R1_AMT

Payback Result Amount (R2)

Contains the payback result amount in reporting 2 currency.

PS_F_GBL_PAYROLL.RPBK_R2_AMT

Bank Transfer Amount of Deduction (Trans) (Bank Transfer Amount of Deduction Transaction Currency)

Contains the bank transfer value of deduction in transaction currency.

PS_F_GBL_PAYROLL.RXV_AMT

Bank Transfer Amount of Deduction

Contains the bank transfer value of deduction in base currency.

PS_F_GBL_PAYROLL.RXV_BCE_AMT

Bank Transfer Amount of Deduction (R1)

Contains the bank transfer value of deduction in reporting 1 currency.

PS_F_GBL_PAYROLL.RXV_R1_AMT

Bank Transfer Amount of Deduction (R2)

Contains the bank transfer value of deduction in reporting 2 currency.

PS_F_GBL_PAYROLL.RXV_R2_AMT

Unit Delta Amount (Trans) (Unit Delta Amount Transaction Currency)

Contains the difference between the original unit and calculated unit value in transaction currency.

PS_F_GBL_PAYROLL.UNIT_AMT

Unit Delta Amount

Contains the difference between the original unit and calculated unit value in base currency.

PS_F_GBL_PAYROLL.UNIT_BCE_AMT

Unit Delta Amount (R1)

Contains the difference between the original unit and calculated unit value in reporting 1 currency.

PS_F_GBL_PAYROLL.UNIT_R1_AMT

Unit Delta Amount (R2)

Contains the difference between the original unit and calculated unit value in reporting 2 currency.

PS_F_GBL_PAYROLL.UNIT_R2_AMT

Dimension Benefit Plan

Contains information on all of the benefit plans offered by a company. It keeps track of all of the offerings by an organization and third parties associated in carrying these plans.

PS_D_BNF_PLN

Dimension Business Unit

The business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Company

Includes company-related information.

PS_D_CMPNY

Dimension Day Disbursement Date

The role-playing dimension for disbursement date based on the Day dimension.

PS_D_DAY

Dimension Day Pay Period End Date

The role-playing dimension for pay period end date based on the Day dimension.

PS_D_DAY

Dimension Deduction

Includes the deduction code and deduction class related information for payroll processing.

PS_D_DED

Dimension Department

Includes information about the organizational entities in an organization. The dimension includes several attributes about a department, such as description, company code, location, and budget.

PS_D_DEPT

Dimension Employee Job

Represents employee job history data, such as actions taken, department, job code, location, and salary history. Multiple records can be created for an employee.

PS_D_EMPL_JOB

Dimension Location

Includes a list of work sites for an organization. Location is used to establish physical locations in an organization, such as corporate headquarters, branch offices, remote sales offices, and so on.

PS_D_LOCATION

Dimension Pay Group

Groups employees by how they are paid.

PS_D_PAYGRP

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Fact Payroll Deduction

Contains the detailed deductions for an employee per employee pay period in the payroll system. These deductions can include employer paid deductions, as well as employee paid deductions.

PS_F_PAY_DED

Coverage Amount (Trans) (Coverage Amount Transaction Currency)

Includes the coverage amount used for deduction calculation in transaction currency.

PS_F_PAY_DED.CALC_BASE_AMT

Coverage Amount

Includes the coverage amount used for deduction calculation in base currency.

PS_F_PAY_DED.CALC_BASE_BCE_AMT

Coverage Amount (R1)

Includes the coverage amount used for deduction calculation in reporting 1 currency.

PS_F_PAY_DED.CALC_BASE_R1_AMT

Coverage Amount (R2)

Includes the coverage amount used for deduction calculation in reporting 2 currency.

PS_F_PAY_DED.CALC_BASE_R2_AMT

Deduction Amount (Trans) (Deduction Amount Transaction Currency)

Includes the total deduction amount in transaction currency.

PS_F_PAY_DED.DED_CUR_AMT

Deduction Amount

Includes the total deduction amount in base currency.

PS_F_PAY_DED.DED_CUR_BCE_AMT

Deduction Amount (R1)

Includes the total deduction amount in reporting 1 currency.

PS_F_PAY_DED.DED_CUR_R1_AMT

Deduction Amount (R2)

Includes the total deduction amount in reporting 2 currency.

PS_F_PAY_DED.DED_CUR_R2_AMT

Deduction Not Taken Amount (Trans) (Deduction Not Taken Amount Transaction Currency)

Includes the amount not taken as part of deduction in transaction currency.

PS_F_PAY_DED.DED_NT_AMT

Deduction Not Taken Amount

Includes the amount not taken as part of deduction in base currency.

PS_F_PAY_DED.DED_NT_BCE_AMT

Deduction Not Taken Amount (R1)

Includes the amount not taken as part of deduction in reporting 1 currency.

PS_F_PAY_DED.DED_NT_R1_AMT

Deduction Not Taken Amount (R2)

Includes the amount not taken as part of deduction in reporting 2 currency.

PS_F_PAY_DED.DED_NT_R2_AMT

Deduction Payback Amount (Trans) (Deduction Payback Amount Transaction Currency)

Includes the total deduction amount coming from arrears in transaction currency.

PS_F_PAY_DED.DED_PAYBK_AMT

Deduction Payback Amount

Includes the total deduction amount coming from arrears in base currency.

PS_F_PAY_DED.DED_PAYBK_BCE_AMT

Deduction Payback Amount (R1)

Includes the total deduction amount coming from arrears in reporting 1 currency.

PS_F_PAY_DED.DED_PAYBK_R1_AMT

Deduction Payback Amount (R2)

Includes the total deduction amount coming from arrears in reporting 2 currency.

PS_F_PAY_DED.DED_PAYBK_R2_AMT

Deduction Refund Amount (Trans) (Deduction Refund Amount Transaction Currency)

Includes the total deduction amount as a result of a refund in transaction currency.

PS_F_PAY_DED.DED_REFUND_AMT

Deduction Refund Amount

Includes the total deduction amount as a result of a refund in base currency.

PS_F_PAY_DED.DED_REFUND_BCE_AMT

Deduction Refund Amount (R1)

Includes the total deduction amount as a result of a refund in reporting 1 currency.

PS_F_PAY_DED.DED_REFUND_R1_AMT

Deduction Refund Amount (R2)

Includes the total deduction amount as a result of a refund in reporting 2 currency.

PS_F_PAY_DED.DED_REFUND_R2_AMT

Dimension Benefit Plan

Contains information on all of the benefit plans offered by a company. It keeps track of all of the offerings by an organization and third parties associated in carrying these plans.

PS_D_BNF_PLN

Dimension Company

Includes company-related information.

PS_D_CMPNY

Dimension Deduction

Includes the deduction code and deduction class related information for payroll processing.

PS_D_DED

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Fact Payroll Deduction Balance

Contains aggregate deduction data for an employee at a month-to-date, quarter-to-date, and year-to-date level in the payroll system.

PS_F_PAY_DED_CUR

Deduction Balance Month To Date Amount (Trans) (Deduction Balance Month to Date Amount Transaction Currency)

Contains the month to date deduction balance amount in transaction currency.

PS_F_PAY_DED_CUR.DED_MTD_AMT

Deduction Balance Month To Date Amount

Contains the month to date deduction balance amount in base currency.

PS_F_PAY_DED_CUR.DED_MTD_BCE_AMT

Deduction Balance Month To Date Amount (R1)

Contains the month to date deduction balance amount in reporting 1 currency.

PS_F_PAY_DED_CUR.DED_MTD_R1_AMT

Deduction Balance Month To Date Amount (R2)

Contains the month to date deduction balance amount in reporting 2 currency.

PS_F_PAY_DED_CUR.DED_MTD_R2_AMT

Deduction Balance Quarter To Date Amount (Trans) (Deduction Balance Quarter to Date Amount Transaction Currency)

Contains the quarter to date deduction balance amount in transaction currency.

PS_F_PAY_DED_CUR.DED_QTD_AMT

Deduction Balance Quarter To Date Amount

Contains the quarter to date deduction balance amount in base currency.

PS_F_PAY_DED_CUR.DED_QTD_BCE_AMT

Deduction Balance Quarter To Date Amount (R1)

Contains the quarter to date deduction balance amount in reporting 1 currency.

PS_F_PAY_DED_CUR.DED_QTD_R1_AMT

Deduction Balance Quarter To Date Amount (R2)

Contains the quarter to date deduction balance amount in reporting 2 currency.

PS_F_PAY_DED_CUR.DED_QTD_R2_AMT

Deduction Balance Year To Date Amount (Trans) (Deduction Balance Year to Date Amount Transaction Currency)

Contains the year to date deduction balance amount in transaction currency.

PS_F_PAY_DED_CUR.DED_YTD_AMT

Deduction Balance Year To Date Amount

Contains the year to date deduction balance amount in base currency.

PS_F_PAY_DED_CUR.DED_YTD_BCE_AMT

Deduction Balance Year To Date Amount (R1)

Contains the year to date deduction balance amount in reporting 1 currency.

PS_F_PAY_DED_CUR.DED_YTD_R1_AMT

Deduction Balance Year To Date Amount (R2)

Contains the year to date deduction balance amount in reporting 2 currency.

PS_F_PAY_DED_CUR.DED_YTD_R2_AMT

Dimension Account

Includes details of an account, which represents a ChartField.

PS_V_ACCOUNT

Dimension Business Unit

The business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Chartfield1

Includes user defined ChartField details.

PS_D_CHARTFIELD1

Dimension Chartfield2

Includes user defined ChartField details.

PS_D_CHARTFIELD2

Dimension Chartfield3

Includes user defined ChartField details.

PS_D_CHARTFIELD3

Dimension Class Field

Includes expense classification codes and descriptions.

PS_D_CLASS_FIELD

Dimension Company

Includes company-related information.

PS_D_CMPNY

Dimension Compensation Rate

Includes information about the compensation rates associated with employee payroll processing.

PS_D_COMP_RT

Dimension Compensation Rate Overtime

The role-playing dimension based on the Compensation Rate dimension. It includes information about the overtime compensation rates associated with employee payroll processing.

PS_D_COMP_RT

Dimension Day Pay Period End Date

The role-playing dimension for pay period end date based on the Day dimension.

PS_D_DAY

Dimension Department

Includes information about the organizational entities in an organization. The dimension includes several attributes about a department, such as description, company code, location, and budget.

PS_D_DEPT

Dimension Earnings

Includes the earnings code related information for payroll processing. This includes attributes such as earnings budget effect and earnings payment type.

PS_D_ERN

Dimension Earnings Overtime Hours

The role-playing dimension for overtime hours based on the Earnings dimension. It contains earnings codes associated with overtime earnings.

PS_D_ERN

Dimension Earnings Regular Hours

The role-playing dimension for regular hours based on the Earnings dimension. It contains earnings codes associated with regular earnings.

PS_D_ERN

Dimension Employee Job

Represents employee job history data, such as actions taken, department, job code, location, and salary history. Multiple records can be created for an employee.

PS_D_EMPL_JOB

Dimension Fund

Includes details about fund codes and their descriptions.

PS_D_FUND

Dimension Jobcode

Includes information about the job assignments in an organization. This dimension represents the categorization of jobs into types, such as executive, technical, and so on.

PS_D_JOBCODE

Dimension Operating Unit

Includes details about operating units, such as a plant office physical location branch building.

PS_D_OPER_UNIT

Dimension Pay Group

Groups employees by how they are paid.

PS_D_PAYGRP

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Dimension Position

Includes information on all job positions available, whether an employee fills the position or not. This dimension helps in data analysis based on salary or standard hours.

PS_D_POS

Dimension Product

Contains information on products that are offered for sale.

PS_D_PRODUCT

Dimension Project

Includes information about projects, which is a vehicle for identifying an initiative that has a specified start and end date.

PS_D_PRJ

Fact Payroll Earnings

Contains the detailed regular and overtime earnings and hours for an employee per employee pay period in the Payroll system.

PS_F_PAY_ERN

Overtime Hourly Earnings Amount (Trans) (Overtime Hourly Earnings Amount Transaction Currency)

Contains the overtime hourly earnings amount in transaction currency.

PS_F_PAY_ERN.OTH_ERN_AMT

Overtime Hourly Earnings Amount

Contains the overtime hourly earnings amount in base currency.

PS_F_PAY_ERN.OTH_ERN_BCE_AMT

Overtime Hourly Earnings Amount (R1)

Contains the overtime hourly earnings amount in reporting 1 currency.

PS_F_PAY_ERN.OTH_ERN_R1_AMT

Overtime Hourly Earnings Amount (R2)

Contains the overtime hourly earnings amount in reporting 2 currency.

PS_F_PAY_ERN.OTH_ERN_R2_AMT

Overtime Earnings Rate

Contains the compensation rate in base currency used to calculate overtime earnings.

PS_F_PAY_ERN.OT_ERN_BCE_RT

Overtime Earnings Rate (R1)

Contains the compensation rate in reporting 1 currency used to calculate overtime earnings.

PS_F_PAY_ERN.OT_ERN_R1_RT

Overtime Earnings Rate (R2)

Contains the compensation rate in reporting 2 currency used to calculate overtime earnings.

PS_F_PAY_ERN.OT_ERN_R2_RT

Overtime Earnings Rate (Trans) (Overtime Earnings Rate Transaction Currency)

Contains the compensation rate in transaction currency used to calculate overtime earnings.

PS_F_PAY_ERN.OT_ERN_RT

Overtime Hours

Contains the number of hours of overtime worked in the payroll system.

PS_F_PAY_ERN.OT_HR_QTY

Regular Hourly Earnings Amount (Trans) (Regular Hourly Earnings Amount Transaction Currency)

Contains the earnings in transaction currency for hourly employees.

PS_F_PAY_ERN.REGHR_ERN_AMT

Regular Hourly Earnings Amount

Contains the earnings in base currency for hourly employees.

PS_F_PAY_ERN.REGHR_ERN_BCE_AMT

Regular Hourly Earnings Amount (R1)

Contains the earnings in reporting 1 currency for hourly employees.

PS_F_PAY_ERN.REGHR_ERN_R1_AMT

Regular Hourly Earnings Amount (R2)

Contains the earnings in reporting 2 currency for hourly employees.

PS_F_PAY_ERN.REGHR_ERN_R2_AMT

Regular Earnings Amount (Trans) (Regular Earnings Amount Transaction Currency)

Contains the regular earnings amount in transaction currency.

PS_F_PAY_ERN.REG_ERN_AMT

Regular Earnings Amount

Contains the regular earnings amount in base currency.

PS_F_PAY_ERN.REG_ERN_BCE_AMT

Regular Earnings Hours

Contains the number of hours worked used for earnings calculation.

PS_F_PAY_ERN.REG_ERN_HR_QTY

Regular Earnings Amount (R1)

Contains the regular earnings amount in reporting 1 currency.

PS_F_PAY_ERN.REG_ERN_R1_AMT

Regular Earnings Amount (R2)

Contains the regular earnings amount in reporting 2 currency.

PS_F_PAY_ERN.REG_ERN_R2_AMT

Regular Hours

Contains the number of hours worked in the payroll system.

PS_F_PAY_ERN.REG_HR_QTY

Regular Salary Earnings Amount (Trans) (Regular Salary Earnings Amount Transaction Currency)

Contains the regular salary earnings amount in transaction currency.

PS_F_PAY_ERN.REG_PAY_AMT

Regular Salary Earnings Amount

Contains the regular salary earnings amount in base currency.

PS_F_PAY_ERN.REG_PAY_BCE_AMT

Regular Pay Hours

Contains the number of hours worked as reflected on the pay sheet.

PS_F_PAY_ERN.REG_PAY_HR_QTY

Regular Salary Earnings Amount (R1)

Contains the regular salary earnings amount in reporting 1 currency.

PS_F_PAY_ERN.REG_PAY_R1_AMT

Regular Salary Earnings Amount (R2)

Contains the regular salary earnings amount in reporting 2 currency.

PS_F_PAY_ERN.REG_PAY_R2_AMT

Regular Earnings Rate

Contains the compensation rate in base currency used for regular earnings.

PS_F_PAY_ERN.RG_ERN_BCE_RT

Regular Earnings Rate (R1)

Contains the compensation rate in reporting 1 currency used for regular earnings.

PS_F_PAY_ERN.RG_ERN_R1_RT

Regular Earnings Rate (R2)

Contains the compensation rate in reporting 2 currency used for regular earnings.

PS_F_PAY_ERN.RG_ERN_R2_RT

Regular Earnings Rate (Trans) (Regular Earnings Rate Transaction Currency)

Contains the compensation rate in transaction currency used for regular earnings.

PS_F_PAY_ERN.RG_ERN_RT

Dimension Company

Includes company-related information.

PS_D_CMPNY

Dimension Earnings

Includes the earnings code related information for payroll processing. This includes attributes such as earnings budget effect and earnings payment type.

PS_D_ERN

Dimension Employee Job

Represents employee job history data, such as actions taken, department, job code, location, and salary history. Multiple records can be created for an employee.

PS_D_EMPL_JOB

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Fact Payroll Earnings Balance

Contains the aggregate earning balance for an employee, at a month-to-date, quarter-to-date, and year-to-date level in the payroll system.

PS_F_PAY_ERN_CUR

Month To Date Gross Earnings (Trans) (Month To Date Gross Earnings Transaction Currency)

Contains the month to date gross earnings amount in transaction currency.

PS_F_PAY_ERN_CUR.GRS_MTD_AMT

Month To Date Gross Earnings

Contains the month to date gross earnings amount in base currency.

PS_F_PAY_ERN_CUR.GRS_MTD_BCE_AMT

Month To Date Gross Earnings (R1)

Contains the month to date gross earnings amount in reporting 1 currency.

PS_F_PAY_ERN_CUR.GRS_MTD_R1_AMT

Month To Date Gross Earnings (R2)

Contains the month to date gross earnings amount in reporting 2 currency.

PS_F_PAY_ERN_CUR.GRS_MTD_R2_AMT

Quarter To Date Gross Earnings (Trans) (Quarter To Date Gross Earnings Transaction Currency)

Contains the quarter to date gross earnings amount in transaction currency.

PS_F_PAY_ERN_CUR.GRS_QTD_AMT

Quarter To Date Gross Earnings

Contains the quarter to date gross earnings amount in base currency.

PS_F_PAY_ERN_CUR.GRS_QTD_BCE_AMT

Quarter To Date Gross Earnings (R1)

Contains the quarter to date gross earnings amount in reporting 1 currency.

PS_F_PAY_ERN_CUR.GRS_QTD_R1_AMT

Quarter To Date Gross Earnings (R2)

Contains the quarter to date gross earnings amount in reporting 2 currency.

PS_F_PAY_ERN_CUR.GRS_QTD_R2_AMT

Year To Date Gross Earnings (Trans) (Year To Date Gross Earnings Transaction Currency)

Contains the year to date gross earnings amount in transaction currency.

PS_F_PAY_ERN_CUR.GRS_YTD_AMT

Year To Date Gross Earnings

Contains the year to date gross earnings amount in base currency.

PS_F_PAY_ERN_CUR.GRS_YTD_BCE_AMT

Year To Date Gross Earnings (R1)

Contains the year to date gross earnings amount in reporting 1 currency.

PS_F_PAY_ERN_CUR.GRS_YTD_R1_AMT

Year To Date Gross Earnings (R2)

Contains the year to date gross earnings amount in reporting 2 currency.

PS_F_PAY_ERN_CUR.GRS_YTD_R2_AMT

Month To Date Hours

Contains the number of hours worked month to date by the employee.

PS_F_PAY_ERN_CUR.HRS_MTD

Quarter To Date Hours

Contains the number of hours worked quarter to date by the employee.

PS_F_PAY_ERN_CUR.HRS_QTD

Year To Date Hours

Contains the number of hours worked year to date by the employee.

PS_F_PAY_ERN_CUR.HRS_YTD

Dimension Absence Event

Includes absence event related indicators.

PS_D_AB_EVENT

Dimension Day Action Submit Date

The role-playing dimension for action submit date based on the Day dimension.

PS_D_DAY

Dimension Day Begin Date

The role-playing dimension for begin date based on the Day dimension.

PS_D_DAY

Dimension Day End Date

The role-playing dimension for end date based on the Day dimension.

PS_D_DAY

Dimension Day Original Begin Date

The role-playing dimension for original begin date based on the Day dimension.

PS_D_DAY

Dimension Day Process Date

The role-playing dimension for process date based on the Day dimension.

PS_D_DAY

Dimension Employee Job

Represents employee job history data, such as actions taken, department, job code, location, and salary history. Multiple records can be created for an employee.

PS_D_EMPL_JOB

Dimension Global Payroll PIN

Contains the information related the PIN name elements, used in global payroll to allow for flexibility in configuration.

PS_D_GP_PIN

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Fact Absence Event

Contains leave and absence information for global payroll.

PS_F_AB_EVENT

Absence Duration

Contains the duration of an employee’s absence in days.

PS_F_AB_EVENT.ABSENCE_DRTN_QTY

Begin Date Partial Hours

Contains the number of hours that the payee was absent for the begin date.

PS_F_AB_EVENT.BEGIN_DAY_HR_QTY

End Date Partial Hours

Contains the number of hours that the payee was absent for the end date.

PS_F_AB_EVENT.END_DAY_HR_QTY

Override Adjustment Amount (Trans)

(Override Adjustment Amount Transaction Currency)

Contains the transaction currency amount used to adjust the entitlement balance.

PS_F_AB_EVENT.OVRD_ADJ_AMT

Override Adjustment Amount

Contains the base currency amount used to adjust the entitlement balance.

PS_F_AB_EVENT.OVRD_ADJ_BCE_AMT

Override Adjustment Amount (R1)

Contains the reporting 1 currency amount used to adjust the entitlement balance.

PS_F_AB_EVENT.OVRD_ADJ_R1_AMT

Override Adjustment Amount (R2)

Contains the reporting 2-currency amount used to adjust the entitlement balance.

PS_F_AB_EVENT.OVRD_ADJ_R2_AMT

Override Entitlement Amount (Trans) (Override Entitlement Amount Transaction Currency)

Contains the transaction currency amount used to override the entitlement for this event.

PS_F_AB_EVENT.OVRD_ENT_AMT

Override Entitlement Amount

Contains the base currency amount used to override the entitlement for this event.

PS_F_AB_EVENT.OVRD_ENT_BCE_AMT

Override Entitlement Amount (R1)

Contains the reporting 1 currency amount used to override the entitlement for this event.

PS_F_AB_EVENT.OVRD_ENT_R1_AMT

Override Entitlement Amount (R2)

Contains the reporting 2-currency amount used to override the entitlement for this event.

PS_F_AB_EVENT.OVRD_ENT_R2_AMT

Dimension Accomplishment

Contains a list of accomplishments that an organization’s employees, applicants or contractors can achieve.

PS_D_ACOMP

Dimension Accomplishment Miscellaneous

Contains miscellaneous information that is captured with an accomplishment.

PS_D_ACOMP_JNK

Dimension Day Evaluation Date

The role-playing dimension for evaluation date based on the Day dimension.

PS_D_DAY

Dimension Day Expiration Date

The role-playing dimension for expiration date based on the Day dimension.

PS_D_DAY

Dimension Day Honor End Date

The role-playing dimension for honor end date based on the Day dimension.

PS_D_DAY

Dimension Day Issued Date

The role-playing dimension for issued date based on the Day dimension.

PS_D_DAY

Dimension Major

Maintains codes and descriptions that are assigned to college-level majors.

PS_D_MAJOR

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Dimension School

Includes information about schools, colleges, and universities.

PS_D_SCHOOL

Dimension Year Government Education Year Acquired

The role-playing dimension for government education year acquired based on the Year dimension.

PS_D_YEAR

Fact Accomplishment

Contains details regarding employee accomplishments including licenses, certifications, language proficiencies, memberships, education, honors and awards.

PS_F_ACOMP

Government Credit Hours

Contains the educational credit hours of governmental educational accomplishment.

PS_F_ACOMP.CRED_HR_QTY

Government Grade Point Average

Contains the grade point average of governmental educational accomplishment.

PS_F_ACOMP.GPA_QTY

Accomplishment Test Score

Contains the accomplishment test score.

PS_F_ACOMP.TEST_SCORE_NUM

Dimension Cost Item

Includes cost items and its categories.

PS_D_CST_ITEM

Dimension Learning Activity

Includes information on learning activities that are offered by an organization to their employees or customers.

PS_D_LRNG_AC

Dimension Learning Cost Type

Includes the frequency of cost, such as hourly.

PS_D_LRNG_CSTTYPE

Dimension Learning Equipment

Indicates all individual pieces of equipment in the system.

PS_D_LRNG_EQP

Dimension Learning Instructor

Includes information on instructors, who are internal or external learners in the system. This dimension provides the ability to assign to activities, activity sessions, session patterns, and session templates.

PS_D_LRNG_INSTR

Dimension Learning Material

Identifies the type of material, such as training manual, gift, compact disk, or brochure.

PS_D_LRNG_MTRL

Dimension Learning Room

Includes information about the facility room associated with a session.

PS_D_LRNG_ROOM

Fact Learning Activity Cost

Contains all costs associated with a learning activity.

PS_F_LRNG_ACCST

Cost Item Quantity

Contains the quantity associated with the cost item.

PS_F_LRNG_ACCST.CST_ITEM_QTY

Total Cost Amount (Trans) (Total Cost Amount Transaction Currency)

Contains the total cost for the item in transaction currency.

PS_F_LRNG_ACCST.TOT_CST_AMT

Total Cost Amount

Contains the total cost for the item in base currency.

PS_F_LRNG_ACCST.TOT_CST_BSE_AMT

Total Cost Amount (R1)

Contains the total cost for the item in reporting 1 currency.

PS_F_LRNG_ACCST.TOT_CST_R1_AMT

Total Cost Amount (R2)

Contains the total cost for the item in reporting 2 currency.

PS_F_LRNG_ACCST.TOT_CST_R2_AMT

Unit Cost Amount (Trans) (Total Cost Amount Transaction Currency)

Contains the total cost for the item in transaction currency.

PS_F_LRNG_ACCST.UNIT_CST_AMT

Unit Cost Amount

Contains the total cost for the item in base currency.

PS_F_LRNG_ACCST.UNIT_CST_BSE_AMT

Unit Cost Amount (R1)

Contains the total cost for the item in reporting 1 currency.

PS_F_LRNG_ACCST.UNIT_CST_R1_AMT

Unit Cost Amount (R2)

Contains the total cost for the item in reporting 2 currency.

PS_F_LRNG_ACCST.UNIT_CST_R2_AMT

Dimension Attendance Status

Includes a list of attendance statuses that can be associated with an enrollment.

PS_D_ATDNC_STAT

Dimension Business Unit

The business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Completion Status

Includes a list of completion statuses that can be associated with an enrollment.

PS_D_CMPLTN_STAT

Dimension Day Completion Date

The role-playing dimension for completion date based on the Day dimension.

PS_D_DAY

Dimension Day Enrollment Date

The role-playing dimension for enrollment date based on the Day dimension.

PS_D_DAY

Dimension Jobcode

Includes information about the job assignments in an organization. This dimension represents the categorization of jobs into types, such as executive, technical, and so on.

PS_D_JOBCODE

Dimension Learning Component

Includes learning components, which are the foundational building blocks of learning activities.

PS_D_LRNG_COMP

Dimension Learning Grade

Includes the list of grades that can be obtained by the learner.

PS_D_LRNG_GRADE

Dimension Learning Organization

Includes information on the organization that represents the external customer who undergoes training.

PS_D_LRNG_ORG

Dimension Learning Program

Includes information on the program, which is a high-level grouping that guides the learner along a specific learning path through sections of items.

PS_D_LRNG_PGM

Dimension Passing Status

Contains a list of passing statuses that can be associated with a learner.

PS_D_PASS_STAT

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Dimension Position

Includes information on all job positions available, whether an employee fills the position or not. This dimension helps in data analysis based on salary or standard hours.

PS_D_POS

Completion

Contains all enrollment and completion details for a given learner at the learning component level.

PS_F_CMPLTN

Dimension Appraisal Miscellaneous

Includes miscellaneous information that is captured during the employee appraisal.

PS_D_APRSL_JNK

Dimension Day Review Creation Date

The role-playing dimension for review creation date based on the Day dimension.

PS_D_DAY

Dimension Day Review Period Begin Date

The role-playing dimension for review period begin date based on the Day dimension.

PS_D_DAY

Dimension ay Review Period End Date

The role-playing dimension review period end date based on the Day dimension.

PS_D_DAY

Dimension Employee Job

Represents employee job history data, such as actions taken, department, job code, location, and salary history. Multiple records can be created for an employee.

PS_D_EMPL_JOB

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Dimension Review Rating

Contains a list of actual ratings used for performance reviews, along with their associated rating models.

PS_D_REVW_RTNG

Dimension Review Rating Preliminary

The role-playing dimension for rating preliminary based on Review Rating dimension.

PS_D_REVW_RTNG

Dimension Review Type

Includes information about the various review document types.

PS_D_REVW_TYPE

Fact Employee Appraisal

Contains data from the ePerformance appraisal tables and provides data regarding appraisal totals and preliminary values.

PS_F_EMPL_APRSL

Appraisal Preliminary Review Points

Contains the preliminary points assigned to an employee's appraisal.

PS_F_EMPL_APRSL.PRE_REVW_PTS

Appraisal Preliminary Review Rating

Contains the preliminary rating of appraisal.

PS_F_EMPL_APRSL.PRE_REVW_RTNG_PTS

Appraisal Review Points

A system-generated total of review rating points associated with the review ratings for an appraisal.

PS_F_EMPL_APRSL.REVW_PTS

Appraisal Review Rating

A system-generated total of numeric ratings associated with the review ratings for an appraisal.

PS_F_EMPL_APRSL.REVW_RTNG_PTS

Dimension Day Review Effective Date

The role-playing dimension for review effective date based on the Day dimension.

PS_D_DAY

Dimension Day Review From Date

The role-playing dimension for review from date based on the Day dimension.

PS_D_DAY

Dimension Day Review Next Date

The role-playing dimension review next date based on the Day dimension.

PS_D_DAY

Dimension Day Review Through Date

The role-playing dimension for review through date based on the Day dimension

PS_D_DAY

Dimension Employee Job

Represents employee job history data, such as actions taken, department, job code, location, and salary history. Multiple records can be created for an employee.

PS_D_EMPL_JOB

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Dimension Review Scale

Contains a list of rating scales for performance reviews.

PS_D_REVW_SCALE

Dimension Review Status

Contains review statuses.

PS_D_REVW_STAT

Dimension Review Type

Includes information about the different review document types.

PS_D_REVW_TYPE

Fact Employee Review

Contains total ratings, amounts, points and percentages from the HRMS Employee Review tables.

PS_F_REVW_EMPL

Total Review Amount

Contains the total review amount based on the review rating if the rating scale type is “Summation.”

PS_F_REVW_EMPL.TOT_REVW_AMT

Total Review Percentage

Contains the total review percentage based on the review rating if the rating scale type is “Summation.”

PS_F_REVW_EMPL.TOT_REVW_PCT

Total Review Points

Contains the total review points from the reviewers’ entries if the rating scale type is “Summation.”

PS_F_REVW_EMPL.TOT_REVW_PTS

Total Review Salary Points

Contains the total review salary points based on the review rating if the rating scale type is “Summation.”

PS_F_REVW_EMPL.TOT_REVW_SAL_PTS

Dimension Business Unit

The business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Day Completion Date

The role-playing dimension for completion date based on the Day dimension.

PS_D_DAY

Dimension Day Enrollment Date

The role-playing dimension for enrollment date based on the Day dimension.

PS_D_DAY

Dimension Enrollment Status

Includes a list of statuses of the learner related to enrollment in a learning activity.

PS_D_ENRLMT_STAT

Dimension Jobcode

Includes information about the job assignments in an organization. This dimension represents the categorization of jobs into types, such as executive, technical, and so on.

PS_D_JOBCODE

Dimension Learning Activity

Includes information on learning activities offered by an organization to their employees and customers.

PS_D_LRNG_AC

Dimension Learning Grade

Includes the list of grades that can be obtained by the learner.

PS_D_LRNG_GRADE

Dimension Learning Organization

Includes information on the organization that represents the external customer who undergoes training.

PS_D_LRNG_ORG

Dimension Learning Program

Includes information on the program, which is a high-level grouping that guides the learner along a specific learning path through sections of items.

PS_D_LRNG_PGM

Dimension Passing Status

Contains a list of passing statuses that can be associated with a learner.

PS_D_PASS_STAT

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Dimension Position

Includes information on all job positions available, whether an employee fills the position or not. This dimension helps in data analysis based on salary or standard hours.

PS_D_POS

Fact Enrollment

Contains enrollment details for an activity for a given learner. This includes various kinds of enrollments, such as direct, ad hoc, mass, and so on. This fact also provides details of programs associated with the enrollment.

PS_F_ENRLMT

Learner Enrollment Count

Contains the count of learners enolled in a particular learning activity

Distinct Count of Enrolled learners. [COUNT_DISTINCT (F_ENRLMT.PERSON_SID)]

Dimension Assignment Code

Contains a list of codes that identify how a learner was assigned objectives.

PS_D_ASSGN_CD

Dimension Business Unit

The business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Day

The day dimension.

PS_D_DAY

Dimension Jobcode

Includes information about the job assignments in an organization. This dimension represents the categorization of jobs into types, such as executive, technical, and so on.

PS_D_JOBCODE

Dimension Learning Activity

Includes information on learning activities.

PS_D_LRNG_AC

Dimension Learning Objective

Includes objectives, which are a high-level abstraction of a learner's learning needs and accomplishments.

PS_D_LRNG_OBJV

Dimension Learning Organization

Includes information on the organization that represents the external customer who undergoes training.

PS_D_LRNG_ORG

Dimension Learning Program

Includes information on the program, which is a high-level grouping that guides the learner along a specific learning path through sections of items.

PS_D_LRNG_PGM

Dimension Objective Status

Contains a list of statuses that can be associated with a learner's objective.

PS_D_OBJV_STAT

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Dimension Position

Includes information on all job positions available, whether an employee fills the position or not. This dimension helps in data analysis based on salary or standard hours.

PS_D_POS

Fact Learning Objective

Contains all objectives assigned to a learner from different sources, such as human resources, job role competency, and so on, as well as the status of the objective.

PS_F_LRNG_OBJV

Achieved Learner Proficiency

Indicates the proficiency achieved by the learner for the objective.

PS_F_LRNG_OBJV.ACHVD_PRFCN_NBR

Required Learner Proficiency

Indicates the proficiency required for the objective of the learner.

PS_F_LRNG_OBJV.REQD_PRFCN_NBR

Dimension Day

The day dimension.

PS_D_DAY

Dimension Instructor Role

Includes information about the different roles that can be played by an instructor.

PS_D_INSTR_ROLE

Dimension Learning Component

Includes learning components, which are the foundational building blocks of learning activities.

PS_D_LRNG_COMP

Dimension Learning Equipment

Indicates all individual pieces of equipment in the system.

PS_D_LRNG_EQP

Dimension Learning Instructor

Includes information on instructors, who are internal or external persons in the system, providing the ability to assign to activities, activity sessions, session patterns, and session templates.

PS_D_LRNG_INSTR

Dimension Learning Room

Includes information about the facility room associated with a session.

PS_D_LRNG_ROOM

Dimension Time Session End Time

The role-playing dimension for session end time based on Time dimension.

PS_D_TIME

Dimension Time Session Start Time

The role-playing dimension for session start time based on Time dimension.

PS_D_TIME

Dimension Timezone

The timezone dimension that contains a list of supported time zones.

PS_D_TIMEZONE

Fact Learning Resource

Contains information about the scheduled resources for the learning activity.

PS_F_LRNG_RSRC

Session Hour Count

Contains the count of hours scheduled for the session.

PS_F_LRNG_RSRC.SESSION_HR_CNT

Dimension Competency

Contains a list of competencies used for the analysis of employee competency inventory or competencies as provided by training courses.

PS_D_CMPTCY

Dimension Competency Verification

Includes list of various ways in which employee competencies can be verified.

PS_D_CMPTCY_VRFY

Dimension Day Competency Effective Date

The role-playing dimension for competency effective date based on the Day dimension.

PS_D_DAY

Dimension Day Review Date

The role-playing dimension for review date based on the Day dimension.

PS_D_DAY

Dimension Evaluation Miscellaneous

Includes miscellaneous information that is captured during the evaluation of a competency.

PS_D_EVAL_JNK

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Dimension Person Reviewer

The role-playing dimension for the reviewer based on the Person dimension.

PS_D_PERSON

Dimension Review Rating

Contains a list of actual ratings used for performance reviews, along with their associated rating models.

PS_D_REVW_RTNG

Dimension Review Rating Proficiency

The role-playing dimension for rating proficiency based on the Review Rating dimension.

PS_D_REVW_RTNG

Dimension Year Competency Acquired

The role-playing dimension for competency acquired based on the Year dimension.

PS_D_YEAR

Dimension Year Competency Last Used

The role-playing dimension for competency last used based on the Year dimension.

PS_D_YEAR

Fact Competency Years of Experience

Contains the total years of experience in each competency.

PS_F_CMPTCY_PERSON.CMPTCY_EXP_YR_NUM

Competency Headcount

Contains the count of employees having a particular competency.

COUNT_DISTINCT(PS_F_CMPTCY_PERSON.PERSON_SID)

Dimension Business Unit

The business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Day Certification Expiry Date

The role-playing dimension for certification expiry date based on the Day dimension.

PS_D_DAY

Dimension Day Program Completion Date

The role-playing dimension for program completion date based on the Day dimension.

PS_D_DAY

Dimension Day Program Registration Date

The role-playing dimension for program registration date based on the Day dimension.

PS_D_DAY

Dimension Day Recertification Date

The role-playing dimension for recertification date based on the Day dimension.

PS_D_DAY

Dimension Jobcode

Includes information about the job assignments in an organization. This dimension represents the categorization of jobs into types, such as executive, technical, and so on.

PS_D_JOBCODE

Dimension Learning Organization

Includes information on the organization that represents the external customer who undergoes training.

PS_D_LRNG_ORG

Dimension Learning Program

Includes information on the program, which is a high-level grouping that guides the learner along a specific learning path through sections of items.

PS_D_LRNG_PGM

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Dimension Position

Includes information on all job positions available, whether an employee fills the position or not. This dimension helps in data analysis based on salary or standard hours.

PS_D_POS

Dimension Program Completion Status

Contains a list of program completion statuses that can be associated with a learner.

PS_D_PGMCMPLN_STAT

Fact Program Registration

Contains program registration details for a program for a given learner. This fact also contains learner certification data.

PS_F_PGM_REG

Learner Registered Count

This complex metric determines the number of registered learners.

COUNT_DISTINCT (PS_F_PGM_REG.PERSON_SID)

Dimension Attendance

Includes a list of attendance values that can be associated with an enrollment.

PS_D_ATDNC

Dimension Business Unit

The business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Cost Unit

Contains a list of cost units used in the training module.

PS_D_CST_UNIT

Dimension Course Grade

Includes the different grades that can be obtained by a student.

PS_D_CRSE_GRD

Dimension Course Session

Contains information about training offerings and their groupings into categories and subcategories. It also contains details on training offering instances (sessions).

PS_D_CRSE_SES

Dimension Day Course Start Date

The role-playing dimension for course start date based on the Day dimension.

PS_D_DAY

Dimension Day Needed Date

The role-playing dimension for needed date based on the Day dimension.

PS_D_DAY

Dimension Day Status Date

The role-playing dimension for status date based on the Day dimension.

PS_D_DAY

Dimension Day Training Request Date

The role-playing dimension for training request date based on the Day dimension.

PS_D_DAY

Dimension Department

Includes information about the organizational entities in an organization. The dimension includes several attributes about a department, such as description, company code, location, and budget.

PS_D_DEPT

Dimension Department Tree

Tracks the hierarchical relationship between organizations. Currently, there are 15 levels of organization hierarchies defined.

PS_V_DEPT

Dimension Employee Job

Represents employee job history data, such as actions taken, department, job code, location, and salary history. Multiple records can be created for an employee.

PS_D_EMPL_JOB

Dimension French Training

Contains a list of miscellaneous attributes captured by French customers regarding an enrollment.

PS_D_FRA_TRNG

Dimension Geography Tree

Tracks the hierarchical relationship between geographical locations. Currently, there are 31 levels of geographical location hierarchies defined.

PS_V_GEOGRAPHY

Dimension Government Training

Contains a list of miscellaneous attributes captured by government customers regarding training.

PS_D_GOV_TRNG

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Dimension Supplier

Includes information on suppliers. Dev: need better descr.

PS_D_SUPPLIER

Dimension Training Reason

Includes a list of reasons that can be associated with training.

PS_D_TRNG_RSN

Fact Training Headcount

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.

PS_F_TRNG

Converted Duration

Contains the duration for the training converted into internal time units.

PS_F_TRNG.CONVERT_DRTN

Duty Hours

Contains the number of duty hours spent in training.

PS_F_TRNG.DUTY_HRS

Time Spent at Training

Contains the amount of time spent in training in days.

PS_F_TRNG.FRA_SPENT_TM

Training Out of Working Hours

Contains the number of out-of-working hours spent in training.

PS_F_TRNG.FRA_TRNG_HRS

Non Duty Hours

Contains the number of non-duty hours spent in training.

PS_F_TRNG.NON_DUTY_HRS

Non Government Training Days

Contains the number of non-government days spent in training.

PS_F_TRNG.NON_GOV_TRNG_DAY

Trained Headcount

Contains the headcount of the trained employees.

COUNT_DISTINCT (CASE WHEN Dimension Employee Job. Employee Status Code IN ('A','L','P','S','W') THEN Fact Training. Person Sid ELSE NULL END)

Dimension Business Unit

The business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Cost Unit

Contains a list of cost units used in the training module.

PS_D_CST_UNIT

Dimension Course Session

Contains information about training offerings and their groupings into categories and subcategories. It also contains details on training offering instances (sessions).

PS_D_CRSE_SES

Dimension Department

Includes information about the organizational entities in an organization. The dimension includes several attributes about a department, such as description, company code, location, and budget.

PS_D_DEPT

Dimension Training Expense Type

Contains various training expense types.

PS_D_TRNG_EXP

Fact Course Session Expense

Contains the detailed training cost associated with a session, categorized by the expense type.

PS_F_CRSE_SES_EXP

Cost Per Unit (Trans) (Cost Per Unit Transaction Currency)

Contains the cost associated with an individual unit of a session in transaction currency.

PS_F_CRSE_SES_EXP.UNIT_COST_AMT

Cost Per Unit

Contains the cost associated with an individual unit of a session in base currency.

PS_F_CRSE_SES_EXP.UNIT_COST_BCE_AMT

Cost Per Unit (R1)

Contains the cost associated with an individual unit of a session in reporting 1 currency.

PS_F_CRSE_SES_EXP.UNIT_COST_R1_AMT

Cost Per Unit (R2)

Contains the cost associated with an individual unit of a session in reporting 2 currency.

PS_F_CRSE_SES_EXP.UNIT_COST_R2_AMT

Count of Units

Contains the number of units associated with a course session.

PS_F_CRSE_SES_EXP.UNIT_QTY

Dimension Applicant

Includes information about a person who has applied for a position and has submitted all required application materials, such as an application form or a resume

PS_D_APPLICANT

Dimension Business Unit

The business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Day Charge Date

The role-playing dimension for charge date based on the Day dimension.

PS_D_DAY

Dimension Department

Includes information about the organizational entities in an organization. The dimension includes several attributes about a department, such as description, company code, location, and budget.

PS_D_DEPT

Dimension Expense Type

Includes a list of valid expense types associated with recruitment expenses.

PS_D_APP_EXP

Fact Recruitment Expenses

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

PS_F_APP_EXP

Expense Amount (Tran) (Expense Amount Transaction Currency)

Contains the Applicant Expense Amount in transaction currency.

PS_F_APP_EXP.APP_EXP_AMT

Expense Amount

Contains the Applicant Expense Amount in base currency.

PS_F_APP_EXP.APP_EXP_BCE_AMT

Expense Amount (R1)

Contains the Applicant Expense Amount in reporting currency 1.

PS_F_APP_EXP.APP_EXP_R1_AMT

Expense Amount (R2)

Contains the Applicant Expense Amount in reporting currency 2.

PS_F_APP_EXP.APP_EXP_R2_AMT

Dimension Applicant

Includes information about a person who has applied for a position and has submitted all required application materials, such as an application form or a resume

PS_D_APPLICANT

Dimension Business Unit

The business unit dimension.

PS_D_BUSINESS_UNIT

Dimension Day Entry Date

The role-playing dimension for entry date based on the Day dimension.

PS_D_DAY

Dimension Day Qualification Date

The role-playing dimension for qualification date based on the Day dimension.

PS_D_DAY

Dimension Day Status Date

This is a role-playing dimension for status date based on the Day dimension.

PS_D_DAY

Dimension Department

Includes information about the organizational entities in an organization. The dimension includes several attributes about a department, such as description, company code, location, and budget.

PS_D_DEPT

Dimension Establishment

Includes distinct physical places of business (establishments) within a company and its address. This dimension is used for regulatory reporting purposes.

PS_D_ESTAB

Dimension Government Recruitment

Contains a list of miscellaneous attributes captured by government customers regarding any recruitment effort.

PS_D_GOV_RCMNT

Dimension Job Opening

Includes information on a formal request for a job within an organization. This dimension also includes information about job requisitions, such as job code, department, status, and status dates.

PS_D_JOB_OPENING

Dimension Person

Represents the most current personal information of both employees and non-employees of an organization.

PS_D_PERSON

Dimension Person Manager

The role-playing dimension for manager based on the Person dimension.

PS_D_PERSON

Dimension Recruitment Status Reason

Includes the various statuses that the recruitment can go through, along with the valid reasons for each status.

PS_D_RCMNTSTAT_RSN

Dimension Referral Source Category

Includes information about a company, agency, or existing employee who referred the applicant to the organization.

PS_D_REF_SRC_CAT

Dimension Referral Source Subcategory

Includes additional details about a company, agency, or existing employee who referred the applicant to the organization.

PS_D_REF_SRC_SBCT

Fact Recruitment

Includes recruitment data at the applicant and job opening level, along with the various statuses of the job opening for each applicant.

PS_F_RCMNT

Applicant Headcount

Contains the distinct count of applicants.

COUNT_DISTINCT(Fact Recruitment Tracking.Applicant Sid)

Time To Fill

Contains the time taken in days to fill a position.

CASE WHEN Dimension Recruitment Status Reason.Recruitment Area Code = '3' AND Dimension Recruitment Status Reason.Recruitment Status Code IN ('090','100','110','120') THEN ( "Dimension Day Entry Date"."Entry Day Date"-"Dimension Day Status Date"."Status Day Date" ) ELSE

NULL END

Time to Hire

Contains the time taken in days to hire an applicant.

CASE WHEN Dimension Recruitment Status Reason.Recruitment Area Code = '3' AND Dimension Recruitment Status Reason.Recruitment Status Code IN ('090') THEN ( "Dimension Day Entry Date"."Entry Day Date"-"Dimension Day Status Date"."Status Day Date" ) ELSE NULL END

Acceptance Count

Contains the count of applicants who accepted the offer.

COUNT_DISTINCT(CASE WHEN Dimension Recruitment Status Reason.Recruitment Area Code = '3' AND Dimension Recruitment Status Reason.Recruitment Status Code IN ('071','075','076','077','078','080','090','100','110','120') THEN Fact Recruitment.Applicant Sid ELSE NULL END)

Hire Count

Contains the count of applicants who were hired.

COUNT_DISTINCT(CASE WHEN Dimension Recruitment Status Reason.Recruitment Area Code = '3' AND Dimension Recruitment Status Reason.Recruitment Status Code IN ('090','100','110','120') THEN Fact Recruitment.Applicant Sid ELSE NULL END)

Offer Count

Contains the count of applicants who received a job offer.

COUNT_DISTINCT(CASE WHEN Dimension Recruitment Status Reason.Recruitment Area Code = '3' AND Dimension Recruitment Status Reason.Recruitment Status Code IN ('070','071','075','076','077','078','080','090','100','110','120') THEN Fact Recruitment.Applicant Sid ELSE NULL END)

Augmentation Point Score Number

Contains the extra-credit points to the applicant's score, when they meet certain criteria.

PS_F_RCMNT.APP_AGPT_SCORE_NUM

Certificate Rank Number

Contains the applicant's rank on the particular educational certificate.

PS_F_RCMNT.CERT_RANK_NUM

Minimum Qualification Score Number

Contains the minimum score for an applicant who is considered well qualified.

PS_F_RCMNT.MIN_QUAL_SCORE_NUM

Priority Placement Weight

Identifies whether the applicant is entitled to automatic consideration for job openings that meet certain criteria.

PS_F_RCMNT.PRIO_PLCMNT_WT_NUM

Screening Score Number

Contains an internal score number that results from matching the requirements of a job opening with the applicant's qualifications.

PS_F_RCMNT.SCR_SCORE_NUM

Total Screening Score

Contains total screening score that results from matching the requirements of a job opening with the applicant's qualifications.

PS_F_RCMNT.SCR_TTL_SCORE_NUM

Selective Factor Points

Identifies the number points required to select the applicant for the position.

PS_F_RCMNT.SEL_FACT_PTS

Veterans Preference Points

Contains the number of points required to be considered for veteran’s preference.

PS_F_RCMNT.VET_PRFR_PTS