| Title | Under | Posted on |
|---|---|---|
| MD5 - SHA checksum of a file. | PeopleSoft Technical | 02/07/2012 - 5:29am |
| nVision Tabular Report through PIA with prompts | PeopleSoft Technical | 02/02/2012 - 10:07pm |
| Can we create an AE to mass update Position - Jobcode data? | PeopleSoft Technical | 01/18/2012 - 3:11am |
| Pay Components on job data can be defaulted and setup based on the rules? | PeopleSoft Functional | 01/05/2012 - 4:58am |
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
Thanks for your quick reply
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
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.
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