Wednesday, May 5, 2010

Difference between Transcation Tables and Control Tables

Difference between Transcation Tables and Control Tables

Transaction tables store data about day-to-day activities. Because of this, these tables are updated frequently and can be quite large. The type of transaction varies, such as invoices, paychecks, employee names and addresses, job history, benefits data.

Information in transaction tables is organized and stored by Business Unit.

Control tables store information that define the accounting structure and processing rules that are used when transactions are entered into your PeopleSoft applications. Control tables include master lists such as customers, vendors, products, country and location tables. It is important to note that Control tables are static, meaning they only change when you perform specific maintenance on them.

Control table information is organized and stored by a set identifier, commonly called a SetID.

2 comments:

  1. listout for control tables in HRMS

    ReplyDelete
  2. Can you please tell how to find out all the setup tables of a particular module in HRMS ? Can it be done through query or is there any other way? Please let me know. I'm new to peoplesoft.

    ReplyDelete