Peoplesoft 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
