You are here:

Peoplesoft/PeopleSoft Question


What is the diffrence between Transaction table and setup tables?

Hi Ramu,

In PeopleSoft (and in many Enterprise Resource Planning applications), a setup table is a table where configurable values are stored. The setup table serves as a reference table used by the application. The Key(s) in a setup table often serve as foreign keys to transaction tables. A characteristic of a setup table is that is is stable and is slowly changing, that is it does not change very often.

An example of some setup tables:
- Salary Table (Salary, classification, effective date period, etc.)
- Gender Table (Male, Female, etc.)
- Country Table (Brazil, India, China, Canada, United States etc.)
- Department Table (CEO, CFO, COO, Human Resources, Finance, Procurement, Operations, etc.)
- Vendors (Vendor name, Vendor address, Contact, etc.)

Transactions table are volatile, it can grow at a much faster rate than a setup table. Transactions tables are is support of core buisness lines. An example of a transaction table:

- Employees (Employee ID, First Name, Last Name, Date of Birth, gender, etc.)
- Position (Position ID, Position title, Salary, Department, etc.)
- Employee Performance (Employee ID, Appraisal Period, Rating, Review Date, Comments, etc.)
- Accounts Receivable and Accounts Payable (Transactions of receivables and payables ...)

I hope this helps



All Answers

Answers by Expert:

Ask Experts


Peter Choi


I am a senior Oracle DBA, PeopleSoft HCM specialist and Project Manager with 15+ years experience. I have been working with PeopleSoft (HRMS/HCM 5, 7, 7.x and 8.9, 9.x), Oracle RDBMS (7.3 - 11gR2) on various Unix and MS-Windows platforms, and some Oracle Application Server (9i - 11gR1). I also have experience with the configuration and administration of PeopleSoft's Internet Architecture (PIA) and the Oracle 11g Fusion Middleware and Oracle Business Intelligence (OBI).

©2016 All rights reserved.