Co-Operative PeopleTools Reference

Co-Operative PeopleTools Reference

Go-Faster Consultancy Ltd.

Go to Index
In the course of my work on PeopleSoft, I spend a lot of time look at the PeopleTools tables.  In general, they contain meta-data about the PeopleSoft application.  Much of the application is stored in PeopleTools tables. Some provide information about the Data Model.   Many of my utility scripts reference the PeopleTools tables.  Thus, it is very helpful to be able to understand what is in these tables.

In PeopleSoft for the Oracle DBA I discussed some tables that are of regular interest.  I included the tables that correspond to the database catalogue, and that are used during the PeopleSoft login procedure.  The tables that are maintained by the process scheduler are valuable because they contain information about who ran what process when, and how long they ran.

I am not the only person to have started to document the PeopleTools tables on their website or blog, most people have picked a few tables that are of particular interest.  However, I want to tackle the problem in a slightly different way.  There are over 3000 PeopleTools tables and view (as defined by PSOBJGROUP).  Tackling all of them manually would be a monumental task. 

Nevertheless, I do want a complete reference.  So, I have written code to dynamically generate a page for each PeopleTools table and view, and I have put as much information about these records as I can find in the PeopleTools tables themselves.  Reference to other objects appear as link to those pages. 

I have started to manually add my own annotation to the generated pages.  So far I have only added descriptions to a few tables (marked with an asterisk).  I would like to make this a collaborative project, and I have already had updates to some pages.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值