Peoplesoft HRMS Foundation tables

Peoplesoft Foundation tables can be broadly categorized into

1. Organizational tables

2. Personal Information tables

3. Job Tables

1. Organizational Tables

a. Enter company information.

Use the Company component to enter information about a single company or multiple companies in your organization, from the corporate address to general ledger accounts, tax information, and payroll processing information.

Table names: LEGAL_TYPE_TBL

COMPANY_TABLE1

COMPANY_TABLE2_GBL

COMPANY_TABLE3_GB

COMPANY_TABLE4_GBL

b. Define business units.

Table names: a. BUS_UNIT_TBL_HR

b. BUS_UNIT_TBL_HR2

c. BUS_UNIT_OPT_HR

d. BUS_UNIT_TBL_GL

Description: a. Add or update business b. Identify business units in other PeopleSoft applications that are related to a business unit. c. Set system defaults such as Company, Country, and Currency for a specific SetID. d. Review GL business units.

c. Enter agency information.

Use the Agency component (AGENCY_TABLE) to enter information about a single agency or sub-agencies in your organization, from the central agency address to general ledger accounts, tax information, and payroll processing information.

Table names: GVT_COMPANY_TBL7

GVT_COMPANY_TBL8

GVT_COMPANY_TBL9

d. Establish locations.

Use the Locations component to establish physical locations in your organization, such as corporate headquarters, branch offices, remote sales offices, and so forth.

Table names: LOCATION_TABLE1

LOC_BU_SEC

BUS_PHONE_SEC

LOCATION_TBL2_GBL

e. Maintain departments.

After you define company and location data for your enterprise, use the Departments component to define business entities in your organization.

Table names: DEPARTMENT_TBL_GBL

DEPARTMENT_TBL_CA

f. Define establishments.

You use the Establishment component to define distinct physical places of business (establishments) within your company, to enter address information, and to enter regulatory reporting information

Table names: ESTAB_TBL1_GBL

ESTAB_TBL2_GBL

CONTROLLED_ESTABS

g. Set up company locations.

Table names: COMP_LOC_TBL

h. Set up primary permission list preferences

Set predefined TableSet sharing and system-wide defaults for each of your primary permission lists and Set Payroll System and system-wide defaults for each of your permission lists.

Table names: OPR_DEF_TBL_HR

OPR_DEF_TBL_HR2

i. Set up person of interest types

Table Name: POI_TYPE_TBL

Description: This is about tracking Non-employees in an organization.

j. Set up holiday schedules

Table Name: HOLIDAY_SCHED_TBL

Description: Designate holidays for payroll processing.

2. Personal Information Tables

a. Define national ID types.

Table name: NID_TYPE_TABLE

Description: Assign a national ID type to a country code and provide a default or a dummy national ID for a country to use when a person or applicant ID is unavailable.

b. Define address types.

Table name: ADDR_TYPE_TBL

Description: Enter address types and the order in which they are available.

c. Set up additional name information.

Table name: a. NAME_FORMAT_TBL

b. NAME_TYPE_TBL

c. NAME_PREFIX_TABLE

d. NAME_SUFFIX_TABLE

e. TITLE_TBL

Description: a. Define name format types to use on name pages throughout HRMS.

b. Define name types and the order in which they are available.

c. Enter name prefixes that you’ll use when you record name information.

d. Enter name suffixes to use to record name information.

e. Enter titles for use with names.

d. Define citizen status codes.

Table name: CITIZEN_STATUS

Description: Define the citizenship statuses you’ll need to track for various countries. For example, you may need to distinguish between a native, a naturalized citizen, or a permanent resident of a particular country.

3. Job Tables

a. Define job families.

Create job families to group similar jobs.

Table name: JOB_FAMILY_TABLE

b. Classify jobs.

In HRMS, you identify jobs by job codes, and you maintain information about jobs independent of the person or group performing that job.

Table name: JOBCODE_TBL1_GBL

JOBCODE_TBL2_GBL

JOBCODE_BU

JOBCD_COMP_RATE

JOBCD_NON_BASE

c. Define job tasks.

Define job task codes, such as Data Entry, and assign it to a Job Code on the Job Code Task Table. On the Job Code Task Table, indicate the importance and frequency of the task.

Table name: JOB_TASK_TABLE

JOBCODE_TASK_TABLE

d. Set up pay groups.

When implementing a payroll system for use with HRMS, one of your major tasks is to set up pay groups. For example, you might create different pay groups for employees with different sets of benefits or earnings.

While pay groups may seem specific to payroll processing, you also need this information for Human Resources, to set up job records and benefit programs.

Table name: PAYGROUP_TABLE1

PAYGROUP_TABLE2

PAYGROUP_TBL3