You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

what are the different types of tables available in peoplesoft HRMS

5 replies [Last post]
Guest's picture
Guest

Hi all;

can anybody tell me what is control table and transaction table in peoplesoft HRMS?
I want to know few table names which comes under control and transaction table types

Thanks in advance
sudha

Lepa's picture
User offline. Last seen 2 years 20 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: what are the different types of tables available in ...

Transaction tables store data about day-to-day business activities. Transaction tables are normally keyed in 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. Transaction tables on the other hand change frequently as they are in constant use to perform the day to day transactions in your company. Most control tables are keyed by Table Set Identifier, rather than by Business Unit (transaction tables).

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

sudha's picture
sudha (not verified)
Re: what are the different types of tables available in ...

Thanks for your quick reply

Ashar's picture
User offline. Last seen 5 years 1 week ago. Offline
Joined: 03/26/2008
Posts: 227
Re: what are the different types of tables available in ...

Eg:
One of the important Transaction table in HRMS is PS_JOB and PS_DEPT_TBL, PS_COMPANY_TBL, PS_LOCATION_TBL etc are some of the control tables.

Most of the times Control Table names ends with _TBL.

Thanks,

Ashar

sweety's picture
User offline. Last seen 10 years 14 weeks ago. Offline
Joined: 01/16/2009
Posts: 15
Re: what are the different types of tables available in ...

Information in transaction tables is organized and stored by Business Unit.
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.

Control table information is organized and stored by a set identifier, commonly called a SetID.
Control tables defines the accounting structure and business rules that are used to process transactions in PeopleSoft. Control tables are generally static; they change only when you perform specific maintenance, appropriate to your business processes, organization structure or processing rules.

Guest's picture
Guest (not verified)
Re: what are the different types of tables available in ...

To be very specific all type of Setup Tables are Control Tables.
Setup Tables can be differentiated because it always get suffixed by _TBL