Return to Navigation

Setting Up Campus Community and PeopleSoft HRMS Shared Elements

This section provides an overview of Campus Community and HRMS shared elements and references the PeopleSoft Human Resources 9.0 documentation that discuss how to:

Campus Solutions uses some functionality from PeopleSoft Human Resources Management (HRMS). If you have already licensed and implemented PeopleSoft HRMS, many of the setup tasks listed in this section might have been completed. If not, you should know that some values in Campus Community are defined using the HRMS pages, and that you should read about and set these up as described in the HRMS documentation. For example, country codes are delivered in Campus Solutions, but are set up and reside on an installation table in HRMS.

In addition, regulatory regions, job codes, job locations, job code tasks, accommodations, and disabilities are all set up on HRMS pages and appear on some pages in Campus Community. If your institution has licensed HRMS, you might require all of these fields, in which case your human resources administrators should read the HRMS documentation to set these up. Some of these fields might be optional in Campus Community. If you have licensed only Campus Solutions, you might still want to know about them and set them up.

This section lists the Campus Community and HRMS shared elements and provides cross-references to the appropriate HRMS documentation for detailed setup information.

Note: If you are implementing separate instances of PeopleSoft Campus Solutions and PeopleSoft HCM, you should read the additional documentation describing those integrations. Certain items and business processes that are detailed in this documentation may vary depending on how you configure your separated systems. The CS-HCM Integration Information Knowledge Document details the additional documents that describe the setup, functional, and technical implementation considerations.

See CS-HCM Integration Information posted in My Oracle Support.

Page Name

Definition Name

Navigation

Usage

Name Prefix Table

NAME_PREFIX_TABLE

select Set Up HRMS, then select Foundation Tables, then select Personal, then select Name Prefix

Set up or review name prefixes.

Name Suffix Table

NAME_SUFFIX_TABLE

select Set Up HRMS, then select Foundation Tables, then select Personal, then select Name Suffix

(Optional) Set up or review name suffixes for prompting pages with names data.

Alternatively, you can manually include the suffix after the individual's last name on those pages.

Royal Name Prefix

NM_ROYAL_PREFIX

select Set Up HRMS, then select Foundation Tables, then select Personal, then select Royal Name Prefix

Set up royal designations to precede a name.

Royal Name Suffix

NM_ROYAL_SUFFIX

select Set Up HRMS, then select Foundation Tables, then select Personal, then select Royal Name Suffix

Set up royal designations to follow a name.

Name Title

TITLE_TBL

select Set Up HRMS, then select Foundation Tables, then select Personal, then select Name Title

Set up titles that go with names. Titles can be royal, political, religious, and so on.

Name Type Table

NAME_TYPE_TBL

select Set Up HRMS, then select Foundation Tables, then select Personal, then select Name Type

Define name types and the order in which to use them.

Address Type Table

ADDR_TYPE_TBL

select Set Up HRMS, then select Foundation Tables, then select Personal, then select Address Type

Define address types and the order in which to use them.

Country Description

COUNTRY_DEFN

select Set Up HRMS, then select Install, then select Country Table, then select Country Description

Review or update country descriptions and codes.

Address Format

ADDR_FORMAT_TABLE

select Set Up HRMS, then select Install, then select Country Table, then select Address Format

Specify the address format for the country that is selected from the Country Table.

Valid Address page

EO_ADDR_VALIDAT

select Set Up HRMS, then select Install, then select Country Table

Specify the county, state, and city for the country that is selected from the Country Table.

Country Table Report - Run Control page

PRCSRUNCNTL

select Set Up HRMS, then select Install, then select Country Table Report

Run the Country Table report (PER708) that prints a list of all country character codes.

State or Province Table

STATE_DEFN

select Set Up HRMS, then select Install, then select State/Province

Add a state, province or equivalent entity for the country that is selected from the Country Table.

National ID Type Table

NID_TYPE_TABLE

select Set Up HRMS, then select Foundation Tables, then select Personal, then select National ID Type

Define or review default National ID values for a country.

Language Table

LANGUAGE_TABLE

select Set Up HRMS, then select Product Related, then select Profile Management, then select Content Catalog, then select Content Items

Enter Content Type LNG.

Define language codes.

Citizen Status

CITIZEN_STATUS

select Set Up HRMS, then select Foundation Tables, then select Personal, then select Citizen Status

Define codes for country citizenship.

Supporting Document Table

SUPPORT_DOC_TABLE

select Set Up HRMS, then select Common Definitions, then select Supporting Documents

Define identification codes for documents that are required to obtain I-9 verification for individuals.

Visa/Permit Table

VISA_PERMIT_TABLE

select Set Up HRMS, then select Product Related, then select Workforce Administration, then select Visas/Permits

Define codes for visas and permits required for noncitizens and their dependents.

Ethnic Groups

ETHNIC_GROUP_TBL

select Set Up HRMS, then select Product Related, then select Workforce Administration, then select Ethnic Groups

Define ethnic groups.

Name (Physician Table)

HS_PHYSICIAN_DATA1

select Set Up HRMS, then select Product Related, then select Workforce Monitoring, then select Health and Safety, then select Physician Table, then select Name

Enter or review the name of a physician or other medical professional in your database.

Address (Physician Table)

HS_PHYSICIAN_DATA2

select Set Up HRMS, then select Product Related, then select Workforce Monitoring, then select Health and Safety, then select Physician Table, then select Address

Enter or review the address of a physician or other medical professional in your database.

Phone Number (Physician Table)

NE_PERS_DTAPH_SEC

Click the Phone link at the bottom of the Address (Physician Table) page.

Enter or review the phone numbers of a physician or other medical professional in your database.

Diagnosis Table

DIAGNOSIS_TABLE

select Set Up HRMS, then select Product Related, then select Workforce Monitoring, then select Health and Safety, then select Diagnosis Table

Create or review codes for injuries and illnesses that your institution wants to track.

Accommodation Type Table

ACCOM_TYPE_TABLE

select Set Up HRMS, then select Product Related, then select Workforce Administration, then select Labor Administration, then select Accommodation Type

Set up codes for the types of accommodations that your institution makes for individuals with health restrictions and disabilities.

Regulatory Region

REG_REGION

select Set Up HRMS, then select Install, then select Regulatory Region

Define or review regulatory region descriptions and security access.

Your system is delivered with regulatory regions predefined for Canada, the United States, Canadian provinces, and other areas. Use this page to set up additional regulatory regions.

Job Code Profile

JOBCODE_TBL1_GBL

select Set Up HRMS, then select Foundation Tables, then select Job Attributes, then select Job Code Table, then select Job Code Profile

Define or review job codes.

Job codes are used on the Accommodation Job Task page within Campus Community.

Business Units by Location

LOC_BU_SEC

Click the business units that use this setID link on the Location Address page.

View a list of the business units that use this setID.

Location Address

LOCATION_TABLE1

select Set Up HRMS, then select Foundation Tables, then select Organization, then select Location Table

Identify or review physical locations such as headquarters, satellite campuses, or remote recruiting offices.

Job locations are used on the Accommodation Job Task page within Campus Community.

Note: Do not confuse this location page with the Location Addresses page on which you set up campus location addresses.

Phone Number

BUS_PHONE_SEC

Click the Phone link on the Location Address page.

Enter a phone number and fax number for a physical location.

Job Code Task Table

JOBCODE_TASK_TABLE

select Set Up HRMS, then select Foundation Tables, then select Job Attributes, then select Job Code Task Table

Define or review job tasks associated with a job code.

Job code tasks are used on the Accommodation Job Task page within Campus Community.

Department Profile

DEPARTMENT_TBL_GBL

select Set Up HRMS, then select Foundation Tables, then select Organization, then select Departments

Identify an internal business entity or department.

Departments are used on the Service Indicator Data 1 and Org Comm Recipients pages within Campus Community.

License/Certification Table

LICENSE_CERTIF_TBL

select Set Up HRMS, then select Product Related, then select Profile Management, then select Content Catalog, then select Content Items

Enter Content Type LIC.

Set up licenses and certificates of interest to your institution.

Membership Table

MEMBERSHIP_TABLE

select Set Up HRMS, then select Product Related, then select Profile Management, then select Content Catalog, then select Content Items

Enter Content Type MEM.

Create codes for the memberships that your institution wants to track.

Set up name prefixes, suffixes, titles, and types in PeopleSoft HRMS.

See PeopleSoft HRMS 9.0 Application Fundamentals, "Managing Profiles, Creating and Updating Person Profiles.”

Set up address types in PeopleSoft HRMS.

See PeopleSoft HRMS 9.0 Application Fundamentals, "Setting Up Personal Information Foundation Tables, Defining Address Types.”

Set up country codes in PeopleSoft HRMS.

See PeopleSoft HRMS 9.0 Application Fundamentals, "Setting Up and Installing PeopleSoft HRMS, Administering Country Codes.”

Add states or provinces for a country in PeopleSoft HRMS.

See PeopleSoft HRMS 9.0 Application Fundamentals, "Setting Up and Installing PeopleSoft HRMS, Administering Country Codes, Adding the State, Province, or Equivalent Entity for a Country.”

Define national ID types in PeopleSoft HRMS.

See PeopleSoft HRMS 9.0 Application Fundamentals, "Setting Up Personal Information Foundation Tables, Assigning a National ID Type to a Country Code.”

Define citizen status codes in PeopleSoft HRMS.

See PeopleSoft HRMS 9.0 Application Fundamentals, "Setting Up Personal Information Foundation Tables, Defining Citizen Status Codes.”

Define ethnic groups in PeopleSoft HRMS.

See PeopleSoft HRMS 9.0: Administer Workforce, "Setting Up the Administer Workforce Business Process, Defining Additional Employment Setup Data, Defining Ethnic Groups.”

Set up visas and permits in PeopleSoft HRMS.

See PeopleSoft HRMS 9.0: Administer Workforce, "Setting Up the Administer Workforce Business Process, Defining Employee Identification, Defining Visas and Work Permits.”

Set up physician codes in PeopleSoft HRMS.

See PeopleSoft HRMS 9.0: Monitor Health and Safety, "Setting Up Incident, Injury, and Illness Tracking, Defining Medical Services Information, Entering Physician Information.”

Set up diagnosis codes in PeopleSoft HRMS.

See PeopleSoft HRMS 9.0: Monitor Health and Safety, "Setting Up Incident, Injury, and Illness Tracking, Defining Injuries and Illnesses, Defining Medical Diagnoses.”

Set up accommodation types in PeopleSoft HRMS.

See PeopleSoft HRMS 9.0: Administer Workforce, "Entering Additional Data in Human Resources Records, Tracking Disabilities, Documenting Disability Accommodations.”

Set up regulatory regions in PeopleSoft HRMS.

See PeopleSoft HRMS 9.0 Application Fundamentals, "Setting Up and Installing PeopleSoft HRMS, Setting Up Regulatory Regions.”

Set up language codes in PeopleSoft HRMS.

See PeopleSoft HRMS 9.0: Manage Profiles, "Maintaining Profiles, Creating and Updating Person Profiles.”

Set up jobs in PeopleSoft HRMS.

See PeopleSoft HRMS 9.0 Application Fundamentals, "Setting Up Jobs.”

Define departments and locations in PeopleSoft HRMS.

See PeopleSoft HRMS 9.0 Application Fundamentals, "Setting Up Organization Foundation Tables, Maintaining Departments.”

Set up licensees and certificates in PeopleSoft HRMS.

See PeopleSoft HRMS 9.0: Manage Profiles, "Maintaining Profiles, Creating and Updating Person Profiles.”

Set up memberships in PeopleSoft HRMS.

See PeopleSoft HRMS 9.0: Manage Profiles, "Maintaining Profiles, Creating and Updating Person Profiles.”