Here is another in our occasional series of data models of those common business areas in SAP and ORACLE applications for which data models are often required for Information Management projects. This time it is a set of tables in the form of a data model from a PeopleSoft Financials system, showing Customer-Contact tables and relationships. You can download it as an image here
Initially I used Safyr® to quickly extract the metadata from our own development version of PeopleSoft. We do not use this application for our own business so there are very few customisations made to the underlying metadata, however Safyr would also extract those changes and make them available. Then as usual I created the data model by performing some simple analysis in Safyr and exported the results to Safyr’s own ERDiagrammer tool. I can easily make the same set of tables available in ERwin, ER/Studio or PowerDesigner formats – please feel free to ask if you would like to see it in one of those formats. There is no obligation and I’d be happy to provide.
In building the model, a number of observations occurred to me:
Part of the answer to the point above is for you the user to make these decisions yourself – which is what Safyr is for, enabling you to scope the set of tables that are relevant to your project, including any of the customizations that have been done to your own system. As we are providing something which is usable in some contexts… here is the legal bit. In no event will Silwood Technology Ltd be liable for any indirect, special or consequential loss arising out of or in any way relating to the use or performance or the use or misuse of the information presented in this model. You can find other example models from other ERPs in earlier Blog posts. As always, I welcome any comments, criticisms or observations.
You must be registered to receive support
Please login or Register Here »
Note: The token is a unique string for each Safyr license and can be found on your product delivery instructionsAlready registered? Login here »
Enter your username
to receive your password