You
cannot directly create tables using SQL when you’re on a PeopleSoft system.
PeopleSoft tables must be created using the create script generated by App
Designer.
If you try and do it manually, the table is assigned a different
schema.
Schema’s limit your results to only one user instead of all users.