Source, Staging, and Target Tables for Human Resource Data
This section lists the source PeopleSoft Human Resource Management System (HRMS) tables and Enterprise Performance Management staging (OWS) and target (OWE) tables for human resource-related data. The use of target tables here refers to the records and tables that are used by the Planning and Budgeting application. In some cases, you might use online maintenance pages to access and update the data. The list is organized by:
Job and Compensation.
Jobcodes and Position.
Salary Plan.
Other Human Resource.
Job and Compensation Records
|
HRMS Source Table |
Description |
Staging (OWS) Table |
Target (OWE) Table |
|---|---|---|---|
|
PS_TC_EE_DETAIL |
Benefit and additional pay (earnings) compensation |
PS_TC_EE_DETAIL |
PS_BP_COMP_F00 |
|
PS_BP_JOB |
Job data |
PS_S_BP_JOB |
PS_BP_JOB_F00 |
|
PS_JOB |
Job data |
PS_JOB |
PS_BP_JOB_F00 |
Jobcodes and Position Records
|
HRMS Source Table |
Description |
Staging (OWS) Table |
Target (OWE) Table |
|---|---|---|---|
|
PS_JOBCODE_TBL |
Job code |
PS_JOBCODE_TBL |
PS_JOBCODE_D00 |
|
PS_POSITION_DATA |
Position data |
PS_S_POSITION_DATA |
PS_BP_POSITION_D00 |
|
PS_POSITION_DATA |
Position data |
PS_S_POSITION_DATA |
PS_POSITION_DATA |
Salary Plan Records
|
HRMS Source Table |
Description |
Staging (OWS) Table |
Target (OWE) Table |
|---|---|---|---|
|
PS_SAL_PLAN_TBL |
Salary plan |
PS_SAL_PLAN_TBL |
PS_SAL_PLAN_R00 |
|
PS_SAL_GRADE_TBL |
Salary grade |
PS_SAL_GRADE_TBL |
PS_SAL_GRADE_D00 |
|
PS_SAL_STEP_TBL |
Salary step |
PS_SAL_STEP_TBL |
PS_SAL_STEP_D00 |
Other Human Resource Records
|
HRMS Source Table |
Description |
Staging (OWS) Table |
Target (OWE) Table |
|---|---|---|---|
|
PS_ACCT_CD_TBL |
Account code |
PS_ACCT_CD_TBL |
PS_ACCT_CD_D00 |
|
PS_BUS_UNIT_TBL_HR |
Business unit |
PS_S_BUS_UNIT_HR |
PS_PS_BUS_UNIT_TBL_HR |
|
PS_DEPT_BUDGET_DED |
Department deduction |
PS_S_DEPT_BDGT_DED |
PS_DEPT_BUDGET_DED |
|
PS_DEPT_BUDGET_ERN |
Department earning |
PS_DEPT_BUDGET_ERN |
PS_DEPT_BUDERN_D00 |
|
PS_DEPT_TBL |
Department |
PS_DEPT_TBL |
PS_DEPARTMENT_TBL |
|
PS_EARNINGS_TBL |
Earnings |
PS_S_EARNINGS_TBL |
PS_EARNINGS_TBL |
|
PS_JOB_EARNS_DIST |
Job earning |
PS_JOB_EARNS_DIST |
PS_JOB_EARNDST_D00 |
|
PS_PERS_DATA_EFFDT PS_NAMES PS_PERSON |
Employee personal data |
PS_PERS_DATA_EFFDT PS_S_NAMES PS_PERSON |
PS_PERSONAL_D00 |
|
PS_RTRMNT_PLAN |
Retirement plan |
PS_S_RTRMNT_PLAN |
PS_RTRMNT_PLAN |
|
PS_RTRMNT_PLAN_TBL |
Retirement plan |
PS_S_RTMNT_PLN_TBL |
PS_RTRMNT_PLAN_TBL |
|
PS_UNION_TBL |
Union code |
PS_S_UNION_TBL |
PS_UNION_TBL |
|
PS_ACTN_REASON_TBL |
Action reason |
PS_S_ACTN_RSN_TBL |
PS_ACTN_REASON_TBL |
|
PS_PAYGROUP_TBL |
Payroll group |
PS_S_PAYGROUP_TBL |
PS_PAYGROUP_TBL |
Note: You must ensure that the department data you load into the OWE target table (PS_DEPARTMENT_TBL) in the EPM database is the data that you want to use for planning and budgeting purposes. The ETL map you use to populate the PS_DEPARTMENT_TBL table with HRMS department data is the same one used to populate the table with FMS department data. This is because the respective ETL jobs for source HRMS and FMS department data store data in the same OWS staging table.
When the departments are the same in your HRMS and FMS source, choose one source to run your ETL job.
When the departments are unique for your HRMS and FMS source, run the ETL jobs from each source. Since the departments are unique, you will not be required to use Dimension Mapper.