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 3 weeks 2 days ago. Offline
Joined: 06/23/2008
Posts: 565
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 4 weeks 3 days ago. Offline
Joined: 03/26/2008
Posts: 208
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 1 year 10 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

Post new comment

The content of this field is kept private and will not be shown publicly.
CAPTCHA
The question below is to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.