PeopleSoft SQL - Standard Query Language

Did you know that SQL is the Achilles Heal of your PeopleSoft system?

Requirements Definition Database Integrity Checks / Data Validation Data Conversion Technical Analysis and Design PeopleSoft Customizations Report and Interface Development SQL Contact us for a free PeopleSoft Consultation

SQL is the language that is used to access and modify your PeopleSoft data. It is used in COBOL Processes, PeopleCode, SQR® and Crystal reports. It is the one tool that is used in every aspect of PeopleSoft. It is a very simple language and very dangerous in the wrong hands. Let us tell you why.

First, SQL is a very small language, which makes it relatively easy to learn. A novice may convince you (and maybe even themselves) that he or she is competent with the language. But, table "joins" can yield inaccurate results if the complex relationships between the PeopleSoft tables are not properly understood. And if business decisions are made based on these bad results, your business will suffer the consequences.

Additionally, from time to time your system may need extensive data changes which would be "inefficient" to perform on-line. This is commonly referred to as a Mass Change because it is a one-time change to the database. This type of change requires proper documentation, backup and "dead on" accuracy with the SQL command. An incorrect mass change can cause an irretrievable loss of your data.

SQL is the most important (and most overlooked) skill-set your development staff must possess. Now you will need to assess your SQL competence within your organization. Contact us today for free consultation on the SQL skills you need to look for.