So far I have only added descriptions to a few tables (marked with an asterisk).
I have started to manually add my own annotation to the generated pages. Reference to other objects appear as link to those pages. 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. Nevertheless, I do want a complete reference. Tackling all of them manually would be a monumental task. There are over 3000 PeopleTools tables and view (as defined by PSOBJGROUP). However, I want to tackle the problem in a slightly different way. 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. 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 included the tables that correspond to the database catalogue, and that are used during the PeopleSoft login procedure. In PeopleSoft for the Oracle DBA I discussed some tables that are of regular interest. Thus, it is very helpful to be able to understand what is in these tables. Many of my utility scripts reference the PeopleTools tables. Some provide information about the Data Model.
Much of the application is stored in PeopleTools tables. In general, they contain meta-data about the PeopleSoft application. In the course of my work on PeopleSoft, I spend a lot of time look at the PeopleTools tables.
0 kommentar(er)
