SQL

All content within the SQL category.

• Get PeopleSoft Record Structure via SQL

This SQL query retrieves the structure of a PeopleSoft record, including field names, types, lengths, default labels, and additional attributes such as whether fields are required or have prompt tables.

• SQL Generator To Delete EMPLIDs

An Example of a SQL that generates a series of delete statements for every PeopleSoft table that contains the EMPLID field.