-
2
- #1
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
PeopleSoft data model 2
- Thread starter k2b
- Start date
Guest_imported
New member
- Jan 1, 1970
- 0
The Select SE PeopleSoft models are based on the individual applications within the ERP software (ie, GL, AP, etc). The models are delivered with the PeopleSoft install.
In my workings with PeopleSoft data models, I've found better tools than the Select SE version provided with the PS install.
It's easier to use a good program and perform reverse engineering based on values in PSRECDEFN than use the old version of Select.
Most of the requests I receive, for reporting on data models, involve the population (migration of historic data) of PS tables with flat-file data, and managing data integrity. I reverse engineered the entire ERP package to create the default table loading sequence prior to PS making default table loading sequences available for 7.5.
They are a tremendous advantage in planning and creating a customized training database that can be used in a SU atmosphere on a desktop. Creating the customized database allows the client to train with their own (limited) data.
The models are also very helpful in determining the effects of any record customizations on related records.
dan
dchapp@nc.rr.com
In my workings with PeopleSoft data models, I've found better tools than the Select SE version provided with the PS install.
It's easier to use a good program and perform reverse engineering based on values in PSRECDEFN than use the old version of Select.
Most of the requests I receive, for reporting on data models, involve the population (migration of historic data) of PS tables with flat-file data, and managing data integrity. I reverse engineered the entire ERP package to create the default table loading sequence prior to PS making default table loading sequences available for 7.5.
They are a tremendous advantage in planning and creating a customized training database that can be used in a SU atmosphere on a desktop. Creating the customized database allows the client to train with their own (limited) data.
The models are also very helpful in determining the effects of any record customizations on related records.
dan
dchapp@nc.rr.com
Try Axiom is a great tool for viewing and searching the ERD.
- Status
Similar threads
- Locked
- Question
- Locked
- Question