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
b. Define business units.
Table names: a. BUS_UNIT_TBL_HR
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
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
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
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
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
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
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
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
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