What is the diffrence between Transaction table and setup tables?
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