Refreshing and Auditing Human Resources Data

To refresh and audit Human Resources data, use the Refresh EMPLOYEES Table component (RUN_PER099), PERSONAL_DATA Settings component (PERSON_DT_SETUP), Refresh Personal Data component (RUN_PERS_REFRESH), Update Personal Data-Future component (RUN_PERSDATA_FUT), Copy to Primary Name Type component (RUNCTL_NAMETYP_CPY), Refresh Name Display Values component (NAME_DISPLAY_RC), and the Core HR Data Integrity Audit component (RUN_PER900).

These topics discuss how to:

  • Select refresh options for the Personal Data component.

  • Refresh name display values.

  • Audit Human Resources data for integrity.

Page Name

Definition Name

Usage

Refresh EMPLOYEES Table Page

RUNCTL_ASOF_DATE

Refresh the PS_EMPLOYEES snapshot table as of the selected date.

PERSONAL_DATA Settings Page

PERSON_DT_SETUP

Select the data that you want to include in the refresh snapshot of employee personal data. The fewer options you select, the faster the system can refresh the table. You must make these selections when you install HCM.

PeopleSoft only uses EmplID and Name data. Select the options you need to meet your ad hoc reporting and query needs.

Refresh Personal Data Page

PRCSRUNCNTL

Refresh the Personal Data component. The Refresh Personal Data component (PERS_REFRESH) loads the data types that you selected on the PERSONAL_DATA Settings page.

This process should only be run when the PERSONAL_DATA settings are changed. This program will lock the PERSONAL_DATA table for updates during processing.

Update Personal Data-Future Page

PRCSRUNCNTL

Run this process shortly after midnight to update the Personal Data component. The process will update data with future dated information that has become current.

The Update Personal Data-Future process runs the HR_PERSDATA application engine program.

Copy to Primary Name Type Page

RUNCTL_NAMETYP_CPY

Copy fields from one name type to fields in the primary name type.

Refresh Name Display Values Page

NAME_DISPLAY_RC

Refresh all records with the NAME_DISPLAY and NAME_FORMAL fields to reflect changes made to the PeopleCode definition of those fields. You can choose to update records with all name format types or just with one name format type.

Core HR Data Integrity Audit Page

HRAUDIT

Initiate the Core Human Resources Data Integrity Audit.

Use the PERSONAL_DATA Settings page (PERSON_DT_SETUP) to select the data that you want to include in the refresh snapshot of employee personal data.

The fewer options you select, the faster the system can refresh the table. You must make these selections when you install HCM.

PeopleSoft only uses EmplID and Name data. Select the options you need to meet your ad hoc reporting and query needs.

Navigation:

Set Up HCM > System Administration > Database Processes > PERSONAL_DATA Settings > PERSONAL_DATA Settings

This example illustrates the fields and controls on the PERSONAL_DATA Settings page.

PERSONAL_DATA Settings page

Field or Control

Description

Address Type

Select which address type to refresh.

Other Address Type

Select a secondary address type to refresh.

Include Installed Countries

Select to include the information in the country-specific group boxes for those countries that you've installed on the Installation Table - Country Specific page.

Include Primary Phone Data

Select to include the information in the PERSONAL_PHONE record.

Include Smoker Data

Select to include the information in the PERS_SMOKER record.

Include Campus Solutions Data

Select to include the information in the PERSON_SA record.

Update User ID Description

Select to update a person's user profile description in PeopleTools (PeopleTools > User Profiles > Security > User Profiles) from the PERSONAL_DATA table.

Note: The description that the name field in PERSONAL_DATA uses is specified on the User Profile Types page (PeopleTools > Security > Security Objects > User Profile Types) for the ID Type: EMP (Employee). Ideally, the Description Fieldname value would be set to NAME_DISPLAY, but it can also be NAME_FORMAL, NAME, or NAME_FORMAL_PSF.

Include US Federal Data

(USF) Select to include the information in the PERS_DATA_USF record.

Use the Copy to Primary Name Type page (RUNCTL_NAMETYP_CPY) to copy fields from one name type to fields in the primary name type.

You can choose to update records with all name format types or just with one name format type.

Navigation:

Set Up HCM > System Administration > Database Processes > Copy to Primary Name Type > Copy to Primary Name Type

This example illustrates the fields and controls on the Refresh Name Display Values page.

Copy to Primary Name Type page

Select which records and name field formats you want to update. The NAME_FLD_CPY application engine program converts the source name field from name type to the field name of the primary name type.

For example, when using preferred fields, you can copy the first and last name from the preferred name type to the preferred first and preferred last names on the primary name type for a specific name format type. The primary name type is what is used throughout most of the system. Hence, if employees put formal or preferred names in another name format type, you can now use that information on the primary type by running this process.

Note: The NAME_FLD_COPY (Copy to Primary Name Type) process also runs the Refresh Name Display Values process. See Refresh Name Display Values Page.

Use the Refresh Name Display Values page (NAME_DISPLAY_RC) to refresh all records with the NAME_DISPLAY and NAME_FORMAL fields to reflect changes made to the PeopleCode definition of those fields.

You can choose to update records with all name format types or just with one name format type.

Navigation:

Set Up HCM > System Administration > Database Processes > Refresh Name Display Values > Refresh Name Display Values

This example illustrates the fields and controls on the Refresh Name Display Values page.

Refresh Name Display Values page

Select which records whose name fields format you want to update.

Note: You should run this process whenever you make changes to the additional name setup tables. See Setting Up Additional Name Information.

Use the Core HR Data Integrity Audit page (HRAUDIT) to initiate the Core Human Resources Data Integrity Audit.

Navigation:

Set Up HCM > System Administration > Database Processes > Core HR Data Integrity Audit > Core HR Data Integrity Audit

This example illustrates the fields and controls on the Core HR Data Integrity Audit page.

Core HR Data Integrity Audit page

Select the HR tables you want to audit for integrity.