SQL script to copy user profile in PeopleSoft application

User profile creation is mostly automated in stable PeopleSoft applications.

Sometimes we may get lots of request to create user profiles in PeopleSoft Applications manually, it may not be feasible to create all profiles from PIA.
Sometimes PIA is down due to issues or slowness in PIA, we may not be able to login in PIA using our user profile.

Simplest way to copy user profile : use navigation PeopleTools -> security -> user profile -> Copy User profile.

Here is a way to skip PIA login to copy user profile and do it from SQL plus manually.

Below SQL script runs fine in Peopletools 8.53 to copy user profile. For lower PeopleTools version ( PT version < 8.53), we need to edit script ( remove "OPERPSWDSALT," text from script  ) and script can be executed successfully in lower versions.

The script create a new user profile KETAN (ID: KETAN, Description : Ketan Pitroda, Email ID : ketan.pitroda@abc.com) from profile (ID : DHARA)

Once profile is created, we can login with new profile KETAN using password of user profile "DHARA" in PIA. We will discuss about a way to change password of user profile using SQL plus in new Post.


set echo on
whenever sqlerror exit rollback

SET DEFINE OFF;
Insert into PSOPRDEFN
   (OPRID, VERSION, OPRDEFNDESC, OPERPSWDSALT, EMPLID, EMAILID, OPRCLASS, ROWSECCLASS, OPERPSWD, ENCRYPTED, SYMBOLICID, LANGUAGE_CD, MULTILANG, CURRENCY_CD, LASTPSWDCHANGE, ACCTLOCK, PRCSPRFLCLS, DEFAULTNAVHP, FAILEDLOGINS, EXPENT, OPRTYPE, USERIDALIAS, LASTSIGNONDTTM, LASTUPDDTTM, LASTUPDOPRID, PTALLOWSWITCHUSER)
 (select 'KETAN', VERSION, 'Ketan Pitroda', OPERPSWDSALT, EMPLID, EMAILID, OPRCLASS, ROWSECCLASS, OPERPSWD,  ENCRYPTED, SYMBOLICID, LANGUAGE_CD, MULTILANG, CURRENCY_CD, LASTPSWDCHANGE, ACCTLOCK, PRCSPRFLCLS, DEFAULTNAVHP, FAILEDLOGINS, EXPENT, OPRTYPE, USERIDALIAS, LASTSIGNONDTTM, LASTUPDDTTM, LASTUPDOPRID, PTALLOWSWITCHUSER
from psoprdefn where oprid = 'DHARA');

Insert into PSOPRALIAS
   (OPRID, OPRALIASTYPE, OPRALIASVALUE, SETID, EMPLID, CUST_ID, VENDOR_ID, APPLID, CONTACT_ID, PERSON_ID, EXT_ORG_ID, BIDDER_ID, EOTP_PARTNERID)
( select
   'KETAN',OPRALIASTYPE, OPRALIASVALUE, SETID, EMPLID, CUST_ID, VENDOR_ID, APPLID, CONTACT_ID, PERSON_ID, EXT_ORG_ID, BIDDER_ID, EOTP_PARTNERID
from psopralias where oprid = 'DHARA');

Insert into PSROLEUSER (select 'KETAN', rolename, dynamic_sw from psroleuser where roleuser = 'DHARA');

Insert into PSUSERATTR
   (OPRID, HINT_QUESTION, HINT_RESPONSE, NO_SYMBID_WARN, LASTUPDOPRID, MPDEFAULMP)
 (select
   'KETAN', HINT_QUESTION, HINT_RESPONSE, NO_SYMBID_WARN, LASTUPDOPRID, MPDEFAULMP from psuserattr where oprid = 'DHARA');



Insert into PSUSEREMAIL
   (OPRID, EMAILTYPE, EMAILID, PRIMARY_EMAIL)
( select
   'KETAN', EMAILTYPE, 'ketan.pitroda@abc.com', PRIMARY_EMAIL from psuseremail where oprid = 'DHARA');

Insert into PSUSERPRSNLOPTN
   (OPRID, OPTN_CATEGORY_LVL, USEROPTN, USER_OPTION_CNTL, USER_OPTION_VALUE)
( select 'KETAN', OPTN_CATEGORY_LVL, USEROPTN, USER_OPTION_CNTL, USER_OPTION_VALUE from PSUSERPRSNLOPTN where oprid = 'DHARA');


Insert into PS_ROLEXLATOPR
   (ROLEUSER, DESCR, OPRID, EMAILID, FORMID, WORKLIST_USER_SW, EMAIL_USER_SW, FORMS_USER_SW, EMPLID, ROLEUSER_ALT, ROLEUSER_SUPR)
 (select
   'KETAN', 'Ketan Pitroda', 'KETAN', 'ketan.pitroda@abc.com', FORMID, WORKLIST_USER_SW, EMAIL_USER_SW, FORMS_USER_SW, EMPLID, ROLEUSER_ALT, ROLEUSER_SUPR from PS_ROLEXLATOPR where roleuser = 'DHARA');
COMMIT;

PeopleSoft Tables

PeopleSoft Projects

PSPROJECTDEFN table stores information about projects created in Application Designer.
Try it out:

SELECT * FROM PSPROJECTDEFN
WHERE PROJECTNAME = 'Your_Project_name';

PSPROJECTITEM table stores objects inserted into your Application Designer project.
Try it out:

SELECT * FROM PSPROJECTITEM
WHERE PROJECTNAME = 'Your_Project_name';

Portal Structure

PSPRSMDEFN is a Portal Structure Definition table. A good example is to use this table to find portal path for a specific component. Take a closer look on how this is done!.

PSPRSMPERM: Shows the permission lists that are assigned to a portal registry structure (content reference). The permission list name is under field PORTAL_PERMNAME.

XLAT Tables

XLATTABLE: Stores translate values (PeopleSoft version prior to 8.4).
PSXLATDEFN: Stores all fields that have Xlat values. This table does not store any Xlat values.
PSXLATITEM: Stores fields with their actual translate values (PeopleSoft version 8.4 and above).

Record & Field Tables

PSRECDEFN: Stores informations about tables. One row for each table. Field count and record type are two fields that are stored on this table.

CASE RECTYPE
        WHEN 0 THEN 'Table'
        WHEN 1 THEN 'View'
        WHEN 2 THEN 'Derived'
        WHEN 3 THEN 'Sub Record'
        WHEN 5 THEN 'Dynamic View'
        WHEN 6 THEN 'Query View'
        WHEN 7 THEN 'Temporary Table'
        ELSE TO_CHAR(RECTYPE)
END CASE

PSRECFIELD: Stores records with all their fields (sub-records are not expanded)

PSRECFIELDALL: Stores records with all their fields (sub-records are expanded)

PSINDEXDEFN: Contains 1 row per index defined for a table.

PSKEYDEFN: Containes 1 row per key field defined for an index.

PSDBFIELD: You got it, stores information about fields.

CASE FIELDTYPE
                WHEN 0 THEN 'Character'
                WHEN 1 THEN 'Long Character'
                WHEN 2 THEN 'Number'
                WHEN 3 THEN 'Signed Number'
                WHEN 4 THEN 'Date'
                WHEN 5 THEN 'Time'
                WHEN 6 THEN 'DateTime'
                WHEN 8 THEN 'Image'
                WHEN 9 THEN 'Image Reference'
                ELSE TO_CHAR(FIELDTYPE)
        END CASE

PSDBFLDLABL: Stores field label information.

Process Definition Table(s)

PS_PRCSDEFNPNL: Stores the process definition name, process type(sqr report, application engine...), and the component name associated with the process definition.

PS_PRCSDEFN: Process definitions table. The record stores processes that can run within the Process Scheduler. Security information such as components and process groups are also stored on this table.

Message Catalog Tables

PSMSGSETDEFN: Stores information about PeopleSoft message catalog message sets (descriptions, version).

PSMSGSETLANG: Message sets language table.

PSMSGCATDEFN: Stores information about PeopleSoft message catalogs such as message set number, message number and the actual message text.

PSMSGCATLANG: Message catalogs language table.

-- Example
SELECT * FROM PSMSGCATDEFN
WHERE LAST_UPDATE_DTTM  > TO_DATE('03-DEC-07', 'DD-MON-YY')
AND LAST_UPDATE_DTTM  < TO_DATE('05-DEC-07', 'DD-MON-YY')
ORDER BY MESSAGE_SET_NBR, MESSAGE_NBR;
-- This will return messages that has been last update/added between 2 specific dates.

Previous PeopleSoft message catalog tables:
PS_MESSAGE_CATALOG: Stores information about PeopleSoft message catalogs such as message set number, message number and the actual message text.
MESSAGE_SET_TBL: Message set description table.

-- Example
SELECT * FROM PS_MESSAGE_CATALOG
WHERE LAST_UPDATE_DTTM  > TO_DATE('03-DEC-07', 'DD-MON-YY')
AND LAST_UPDATE_DTTM  < TO_DATE('05-DEC-07', 'DD-MON-YY')
ORDER BY MESSAGE_SET_NBR, MESSAGE_NBR;
-- This will return messages that has been last update/added between 2 specific dates.

Menu Tables

PSMENUDEFN: Store Menu related information. No related component info on this table.

PSMENUITEM: List the menu with all components attached to it.

Component Tables

PSPNLGRPDEFN: Stores component related information only.

PSPNLGROUP: This table will give you information regarding a specific component along with the names of pages attached to it.

Pages

PSPNLDEFN: Stores pages definitions.

CASE PNLTYPE
        WHEN 0 THEN 'Page'
        WHEN 1 THEN 'Sub page'
        WHEN 2 THEN 'Secondary page'
        ELSE TO_CHAR(PNLTYPE)
    END CASE

PSPNLFIELD: Stores all items used by each page definition.

CASE FIELDTYPE
        WHEN 0 THEN 'Static Text'
        WHEN 1 THEN 'Frame'
        WHEN 2 THEN 'Group Box'
        WHEN 3 THEN 'Statis Image'
        WHEN 4 THEN 'Edit Box'
        WHEN 5 THEN 'Dropdown List'
        WHEN 6 THEN 'Long Edit Box'
        WHEN 7 THEN 'Check Box'
        WHEN 8 THEN 'Radio Button'
        WHEN 9 THEN 'Image'
        WHEN 10 THEN 'Scroll Bar'
        WHEN 11 THEN 'Subpage'
        WHEN 12 THEN 'Peoplecode Command - (Button/Hyperlink Destination)'
        WHEN 13 THEN 'Scroll Action - (Button/Hyperlink Destination)'
        WHEN 14 THEN 'Toolbar Action - (Button/Hyperlink Destination)'
        WHEN 15 THEN 'External Link - (Button/Hyperlink Destination)'
        WHEN 16 THEN 'Internal Link - (Button/Hyperlink Destination)'
        WHEN 17 THEN 'Process - (Button/Hyperlink Destination)'
        WHEN 18 THEN 'Secondary Page'
        WHEN 19 THEN 'Grid'
        WHEN 20 THEN 'Tree'
        WHEN 21 THEN 'Secondary Page - (Button/Hyperlink Destination)'
        WHEN 23 THEN 'Horizontal Rule'
        WHEN 24 THEN 'Tab Separator'
        WHEN 25 THEN 'Html Area'
        WHEN 26 THEN 'Prompt Action - (Button/Hyperlink Destination)'
        WHEN 27 THEN 'Scroll Area'
        WHEN 29 THEN 'Page Anchor'
        WHEN 30 THEN 'Chart'
        WHEN 31 THEN 'Push Button/Link'
        WHEN 32 THEN 'Analytic Grid'
        ELSE TO_CHAR(FIELDTYPE)
    END CASE

Security

PSPRSMPERM: Portal Structure Permissions.

PSAUTHITEM: Page Permissions. This table stores the information about the page level access for a permission list.

PSAUTHPRCS Process Group Permissions. A many to many relationship table between Permission Lists and Process Groups. Setup can be found at PeopleTools > Security > Permissions & Roles > Process.

PSROLECLASS: Role Classes table. A many to many relationship table between Roles and Permission Lists.

PSROLEDEFN: This table stores information about Peoplesoft Role definitions. Users get permissions to PeopleSoft objects through Roles, which are assigned Permission Lists.

PSROLEUSER: This table stores information about the Users in Peoplesoft and the roles assigned to them.

PSCLASSDEFN: Permissions List definitions table. Permission list name can be found under Field Name CLASSID.

PSOPRDEFN: Users/Operator definition table. This table stores information about PeopleSoft users. This is the core table for User Profile Manager.

PSOPRCLS: Users/Operator and Perm list mapping Table. This table stores information about PeopleSoft users and the permission lists attached to those users.
A User gets these permission lists indirectly through the roles which are attached to the user

Here is an example query post that uses all of the above security tables!

URL Definitions

PSURLDEFN: Stores URL definitions. Here is the path to create URL definitions in PeopleSoft Root >> PeopleTools >> Utilities >> Administration >> URLs

Application Classes

PSAPPCLASSDEFN: Application Class Definitions table. You can use field PACKAGEROOT to search for a specific Application Package.

PeopleSoft Query Tables

PSQRYDEFN: Stores query related info.

PSQRYFIELD: Stores all fields used in a query (both the fields in the Select and Where clause).

PSQRYCRITERIA: Stores criteria query fields. You can get the name of the fields by joining the PSQRYFIELD table.

PSQRYEXPR: Stores query expressions.

PSQRYBIND: Stores query bind variables.

PSQRYRECORD: Stores all records used in all aspects of query creation

PSQRYSELECT: Stores all SELECT requirements by select type. Example would be sub select, join, ect.

PSQRYLINK: Stores the relationships to child queries.

PSQRYEXECLOG: Query run time log table that stores (only 8.4x and higher)

PSQRYSTATS: Query run time statistics table such as count of query execution, and date time of last execution (only in 8.4x and higher).

SQL Objects

PSSQLDEFN: Stores SQL object definitions.

PSSQLDESCR: Stores SQL objects descriptions, and description long.

PSSQLTEXTDEFN: Stores actual SQL text. You can filter by SQLTYPE field to get SQL objects of interest such as Views SQLs and Application Engine SQLs.

-- When SQL type is:
0 = Stand alone SQL objects
1 = Application engine SQL
2 = Views SQLs

Application Engines

PSAEAPPLDEFN: Table that stores Application Engine program definitions.

PSAEAPPLSTATE: Stores application engine STATE records and a flag to indicate if the record is the default STATE record.

PSAESECTDEFN: Application engine section information and also stores last user id to update a specific section.

PSAESECTDTLDEFN: AE section along with descriptions and wither the section is active or not.

PSAEAPPLTEMPTBL: If your application engine uses Temp tables it will show on this record.

PSAESTEPDEFN: Steps in application engines are stored in this table.

PSAESTMTDEFN: Stores your application engine actions and along with their types, such as "Do Select" and so on.

PSAESTEPMSGDEFN: Application engine message action definition table.

AEREQUESTTBL: Application Engine request table behind the AE run control page.

AEREQUESTPARM: Application Engine request parameters table behind the AE run control page.

PeopleCode Tables

PSPCMNAME: PeopleCode Reference table.

PSPCMPROG: Store actual PeopleCode programs (actual code behind PeopleCode events).

Process Request Tables

PSPRCSQUE: This record contains the process request information to run a process request.

PSPRCSRQST: This record contains the process request information to run a process request.

PS_PMN_PRCSLIST: A view to list all process requests in the Process Monitor except for "Delete" (runstatus = 2) process requests.

Other Useful Tables

PSSTATUS: Stores PeopleSoft information such as PS Tools release version and the UNICODE_ENABLED boolean flag where a value of 1 indicates the DB is to be treated by Tools as a UNICODE DB.

PSCHGCTLLOCK: Description as explained by PeopleSoft "This table contains a a row for every object that is currently locked by any user. When the user requests to lock an object in the Application Designer, first this table is searched to see if the object is locked by another user. If it is not found, a row is inserted into the table. When the user requests to unlock an object, the row in this table is deleted."
Visit this post to see how could you make use of this table.

PSMAPFIELD: Stores Field mapping of Activity
PS_PRCSRUNCNTL: Run Control record stores Run Control IDs created online.

Exports PeopleTools core tables

--                                                                   
--  ******************************************************************
--  ******************************************************************
--  Exports PeopleTools core tables used during the move to production
--  upgrade step
--  ******************************************************************

SET LOG MVPRDEXP1.LOG;
SET OUTPUT MVPRDP1.DAT;

EXPORT PSACCESSPRFL;
EXPORT PSOPRDEFN;
EXPORT PSOPRDEFN_LANG;
EXPORT PSSTATUS;

SET LOG MVPRDEXP2.LOG;
SET OUTPUT MVPRD2.DAT;

-- PEOPLETOOLS PROJECTS
EXPORT PSPROJECTDEFN WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%';
EXPORT PSPROJECTITEM WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%';
EXPORT PSPROJDEFNLANG WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%';
EXPORT PSPROJECTDEP WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%';
EXPORT PSPROJECTINC WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%';
EXPORT PSPROJECTMSG WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%';
EXPORT PSPROJECTSEC WHERE PROJECTNAME LIKE 'PPL%' or PROJECTNAME LIKE 'PT84%';

SET LOG MVPRDEXP3.LOG;
SET OUTPUT MVPRD3.DAT;

--  SYSTEM
EXPORT PSOPTIONS;
EXPORT PSOPTIONSADDL;
EXPORT PSPTMATVWDEP;

-- RECORDS AND INDEXES
EXPORT PSRECDEFN;
EXPORT PSRECDEFNLANG;
EXPORT PSRECFIELD;
EXPORT PSINDEXDEFN;
EXPORT PSKEYDEFN;
EXPORT PSDDLMODEL;
EXPORT PSDDLDEFPARMS;
EXPORT PSSPCDDLPARM;
EXPORT PSRECDDLPARM;
EXPORT PSIDXDDLPARM;
EXPORT PSRECFIELDDB;
EXPORT PSRECTBLSPC;
EXPORT PSRECQRYSECRECS;
EXPORT PSRECSECFLDMAPS;
EXPORT PSPTMATVWDEFN;
EXPORT PS_PTIDXPARTDDL;
EXPORT PS_PTTBLPARTDDL;

-- FIELDS
EXPORT PSPTCONTEXT;
EXPORT PSDBFIELD;
EXPORT PSDBFIELDLANG;
EXPORT PSDBFLDLABL;
EXPORT PSDBFLDLABLLANG;

-- FIELD FORMATS
EXPORT PSFMTDEFN;
EXPORT PSFMTITEM;

-- TRANSLATES
EXPORT PSXLATDEFN;
EXPORT PSXLATITEM;
EXPORT PSXLATITEMLANG;

-- PAGES
EXPORT PSPNLDEFN;
EXPORT PSPNLDEFNLANG;
EXPORT PSPNLFIELD;
EXPORT PSPNLFIELDLANG;
EXPORT PSPNLFIELDEXT;
EXPORT PSPNLACTIVEX;
EXPORT PSPNLHTMLAREA;
EXPORT PSPNLHTMLLANG;
EXPORT PSPNLCNTRLDATA;
EXPORT PSPNLCTLDATALNG;
EXPORT PSPNLBTNDATA;
EXPORT PSPNLBTNLANG;
EXPORT PSPNLTREECTRL;
EXPORT PSPTPNLRTEDITOR;
EXPORT PSPTPNLRAWIDGET;


-- MENUS
EXPORT PSMENUDEFN;
EXPORT PSMENUDEFNLANG;
EXPORT PSMENUITEM;
EXPORT PSMENUITEMLANG;
EXPORT PSXFERITEM;

-- PANEL GROUPS
EXPORT PSPNLGRPDEFN;
EXPORT PSPNLGRPDEFNEXT;
EXPORT PSPNLGDEFNLANG;
EXPORT PSPNLGROUP;
EXPORT PSPNLGROUPLANG;
EXPORT PSPNLGRPSCRIPTS;

-- PEOPLECODE
EXPORT PSPCMPROG;
EXPORT PSPCMNAME;
EXPORT PSPCMSYNCID;
EXPORT PSPCMTXT;

-- QUERIES
EXPORT PSQRYDEFN;
EXPORT PSQRYDEFNLANG;
EXPORT PSQRYBIND;
EXPORT PSQRYBINDLANG;
EXPORT PSQRYCRITERIA;
EXPORT PSQRYEXPR;
EXPORT PSQRYFIELD;
EXPORT PSQRYFIELDDEP;
EXPORT PSQRYFIELDLANG;
EXPORT PSQRYFLAGS;
EXPORT PSQRYLINK;
EXPORT PSQRYRECORD;
EXPORT PSQRYSELECT;
EXPORT PSQRYXFORM;


-- TREE STRUCTURES
EXPORT PSTREESTRCT;
EXPORT PSTREESTRCTLANG;

-- TREES
EXPORT PSTREEDEFN;
EXPORT PSTREEDEFNLANG;
EXPORT PSTREEBRANCH;
EXPORT PSTREELEAF;
EXPORT PSTREELEVEL;
EXPORT PSTREENODE;
EXPORT PSTREEPROMPT;
EXPORT PSTREESELCTL;
EXPORT PSTREESELNUM;
EXPORT PSTREESELECT01;
EXPORT PSTREESELECT02;
EXPORT PSTREESELECT03;
EXPORT PSTREESELECT04;
EXPORT PSTREESELECT05;
EXPORT PSTREESELECT06;
EXPORT PSTREESELECT07;
EXPORT PSTREESELECT08;
EXPORT PSTREESELECT09;
EXPORT PSTREESELECT10;
EXPORT PSTREESELECT11;
EXPORT PSTREESELECT12;
EXPORT PSTREESELECT13;
EXPORT PSTREESELECT14;
EXPORT PSTREESELECT15;
EXPORT PSTREESELECT16;
EXPORT PSTREESELECT17;
EXPORT PSTREESELECT18;
EXPORT PSTREESELECT19;
EXPORT PSTREESELECT20;
EXPORT PSTREESELECT21;
EXPORT PSTREESELECT22;
EXPORT PSTREESELECT23;
EXPORT PSTREESELECT24;
EXPORT PSTREESELECT25;
EXPORT PSTREESELECT26;
EXPORT PSTREESELECT27;
EXPORT PSTREESELECT28;
EXPORT PSTREESELECT29;
EXPORT PSTREESELECT30;

-- ACCESS GROUPS
EXPORT ACCESS_GRP_TBL;
EXPORT ACCESS_GRP_LANG;

-- COLORS
EXPORT PSCOLORDEFN;

-- STYLES
EXPORT PSSTYLEDEFN;
EXPORT PSSTYLEDEFNLANG;

-- BUSINESS PROCESSES
EXPORT PSBUSPROCDEFN;
EXPORT PSBUSPROCITEM;
EXPORT PSBUSPROCLANG;
EXPORT PSBUSPROCSEC;
EXPORT PSBUSPRIMG;
EXPORT PSBUSPITEMIMG;
EXPORT PSBUSPITEMLANG;
EXPORT PSBUSPRIMGLANG;

-- ACTIVITIES
EXPORT PSACTIVITYDEFN;
EXPORT PSACTIVITYLANG;
EXPORT PSACTIVIMG;
EXPORT PSACTIVIMGLANG;
EXPORT PSSTEPDEFN;
EXPORT PSEVENTDEFN;
EXPORT PSEVENTROUTE;
EXPORT PSMSGAGTDEFN;
EXPORT PSMAPEXPR;
EXPORT PSMAPFIELD;
EXPORT PSMAPLEVEL;
EXPORT PSMAPRECFIELD;
EXPORT PSMAPROLEBIND;
EXPORT PSMAPROLENAME;

-- PROCESS DEFINITIONS
EXPORT PRCSDEFN;
EXPORT PRCSDEFNLANG;
EXPORT PRCSDEFNGRP;
EXPORT PRCSDEFNPNL;
EXPORT PRCSDEFNXFER;
EXPORT PRCSDEFNNOTIFY;
EXPORT PRCSDEFNCNTDIST;
EXPORT PRCSDEFNMESSAGE;
EXPORT PRCSDEFNMETA;
EXPORT PS_PRCSDEFNURL;
EXPORT PS_PRCSDEFNURL_LNG;
EXPORT PS_PRCSDEFNURLKEY;
EXPORT PS_PRCS_RUNPARM;

-- PROCESS SERVERS
EXPORT PS_SERVERCLASS;
EXPORT PS_SERVERDEFN;
EXPORT PS_SERVERDEFN_LNG;
EXPORT PS_SERVERNOTIFY;
EXPORT PS_SERVERMESSAGE;
EXPORT PS_SERVEROPRTN;
EXPORT PS_SERVERCATEGORY;

-- PROCESS TYPES
EXPORT PS_PRCSTYPEDEFN;
EXPORT PS_PRCSTYPEDEFNLNG;
EXPORT PS_PRCSTYPEMETA;

-- PROCESS JOBS
EXPORT PRCSJOBDEFN;
EXPORT PRCSJOBDEFNLANG;
EXPORT PRCSJOBGRP;
EXPORT PRCSJOBITEM;
EXPORT PRCSJOBPNL;
EXPORT PS_PRCSJOBNOTIFY;
EXPORT PS_PRCSJOBCNTDIST;
EXPORT PS_PRCSJOBMESSAGE;
EXPORT PS_PRCSOUTPUTLIST;
EXPORT PS_PRCSOUTDESTTYPE;
EXPORT PS_PRCSSYSTEM;
EXPORT PS_PRCSPURGELIST;
EXPORT PS_PRCS_CAT_TBL;
EXPORT PS_PRCS_CAT_LG_TBL;

-- PROCESS RECURRENCE
EXPORT PRCSRECUR;
EXPORT PRCSRECURLANG;
EXPORT PRCSRECURDATE;
EXPORT PRCSRECUREXEMPT;

-- PROCESS CONTROL
EXPORT PS_SCHDLDEFN;
EXPORT PS_SCHDLDEFNLANG;
EXPORT PS_SCHDLITEM;
EXPORT PS_SCHDLMESSAGE;
EXPORT PS_SCHDLNODEPARM;
EXPORT PS_SCHDLNOTIFY;
EXPORT PS_SCHDLRPTDIST;
EXPORT PS_SCHDLTEXT;

-- DIMENSIONS
EXPORT DIMENSION;
EXPORT DIMENSION_LANG;
EXPORT DIM_CTRL_TBL;
EXPORT DIM_DATA_SRC;
EXPORT DIM_INPUT_FLD;
EXPORT DIM_ROLLUP;
EXPORT DIM_ROLLUP_LVL;

-- ANALYSIS MODELS
EXPORT ANALYSIS_MODEL;
EXPORT ANL_MOD_DAT_SRC;
EXPORT ANL_MOD_DIM;
EXPORT ANL_MOD_DIM_FLD;

-- CUBE TEMPLATES
EXPORT ANALYSIS_DB;
EXPORT ANALYSIS_DB_DIM;
EXPORT ANL_DB_LANG;
EXPORT ANL_DB_QRY_ESS;
EXPORT CUBE_AGG_DEF;
EXPORT CUBE_AGG_DIM;
EXPORT CUBE_FILTER_ITM;

-- BUSINESS INTERLINKS
EXPORT PSIODEFN;
EXPORT PSIODEFNLANG;
EXPORT PSIOINPUTS;
EXPORT PSIOOUTPUTS;
EXPORT PSIOSETTINGS;

-- SQL
EXPORT PSSQLDEFN;
EXPORT PSSQLDESCR;
EXPORT PSSQLHASH;
EXPORT PSSQLLANG;
EXPORT PSSQLTEXTDEFN;

-- FILE LAYOUT DEFINITIONS
EXPORT PSFLDDEFN;
EXPORT PSFLDFIELDDEFN;
EXPORT PSFLDSEGDEFN;

-- BUSINESS COMPONENTS
EXPORT PSBCDEFN;
EXPORT PSBCDEFNLANG;
EXPORT PSBCITEM;
EXPORT PSBCITEMLANG;

-- APP ENGINE PROGRAMS
EXPORT PSAEAPPLDEFN;
EXPORT PSAEAPPLLANG;
EXPORT PSAEAPPLSTATE;
EXPORT PSAEAPPLTEMPTBL;

-- APP ENGINE SECTIONS
EXPORT PSAESECTDEFN;
EXPORT PSAESECTDTLDEFN;
EXPORT PSAESTEPDEFN;
EXPORT PSAESTEPMSGDEFN;
EXPORT PSAESTMTDEFN;
EXPORT PS_AEINSTANCENBR;
EXPORT PS_AELOCKMGR;

-- MESSAGE NODES
EXPORT PSMSGNODEDEFN;
EXPORT PSNODEDEFNLANG;
EXPORT PSCONNECTSTRING;
EXPORT PSNODEURITEXT;
EXPORT PSNODECONPROP;
EXPORT PSNODCONPRPLANG;
EXPORT PSNODELOCKDOWN;
EXPORT PSNODEPROP;
EXPORT PSNODEPROPLANG;
EXPORT PSNODESDOWN;
EXPORT PSTRUSTNODES;

-- MESSAGE CHANNELS
EXPORT PSCHNLDEFN;
EXPORT PSCHNLDEFNLANG;
EXPORT PSCHNLNODE;
EXPORT PSSUBCHNL;

-- MESSAGE DEFINITIONS
EXPORT PSMSGATTR;
EXPORT PSMSGDEFN;
EXPORT PSMSGDEFNLANG;
EXPORT PSMSGFLDOVR;
EXPORT PSMSGPARTS;
EXPORT PSMSGREC;
EXPORT PSMSGVER;

-- APPROVAL RULE SETS
EXPORT APPR_HDR_LNG;
EXPORT APPR_RULE_AMT;
EXPORT APPR_RULE_DETL;
EXPORT APPR_RULE_FIELD;
EXPORT APPR_RULE_HDR;
EXPORT APPR_RULE_LN;
EXPORT APPR_RULE_QTY;
EXPORT APPR_RULE_ROLE;
EXPORT PSVAITEM;
EXPORT PSVAITEMIMG;
EXPORT PSVAITEMLANG;

-- IMAGE AND HTMLCATALOG-- CONTENT
EXPORT PSCONTDEFN;
EXPORT PSCONTDEFNLANG;
EXPORT PSCONTENT;
EXPORT PSCONTENTLANG;

-- STYLE SHEETS
EXPORT PSSTYLECLASS;
EXPORT PSSTYLECLASSFNT;
EXPORT PSSTYLSHEETDEFN;
EXPORT PSSTYLECLSLANG;
EXPORT PSSTYLEFNTLANG;
EXPORT PSSTYLEDFNLANG;

-- LANGUAGES
EXPORT PSLANGUAGES;
EXPORT PS_STRINGS_TBL;
EXPORT PS_STRINGS_LNG_TBL;

-- SUBSCRIPTIONS
EXPORT PSSUBDEFN;

-- RECORD GROUP
EXPORT PS_REC_GROUP_REC;
EXPORT PS_REC_GROUP_TBL;

-- CHANGE CONTROL
EXPORT PSCHGCTLHIST;
EXPORT PSCHGCTLLOCK;

-- OBJECT CHANGE (RENAMES)
EXPORT PSOBJCHNG;

-- APP MESSAGING
EXPORT PSAPMSGARCHPC;
EXPORT PSAPMSGARCHPD;
EXPORT PSAPMSGARCHPH;
EXPORT PSAPMSGARCHSC;
EXPORT PSAPMSGARCHTMP;
EXPORT PSAPMSGPUBATTR;
EXPORT PSAPMSGPUBCERR;
EXPORT PSAPMSGPUBCERRP;
EXPORT PSAPMSGPUBCLOCK;
EXPORT PSAPMSGPUBCON;
EXPORT PSAPMSGPUBCSYNC;
EXPORT PSAPMSGPUBDATA;
EXPORT PSAPMSGPUBERR;
EXPORT PSAPMSGPUBERRP;
EXPORT PSAPMSGPUBHDR;
EXPORT PSAPMSGPUBINST;
EXPORT PSAPMSGPUBLOCK;
EXPORT PSAPMSGPUBSYNC;
EXPORT PSAPMSGSUBCERR;
EXPORT PSAPMSGSUBCERRP;
EXPORT PSAPMSGSUBCLOCK;
EXPORT PSAPMSGSUBCON;
EXPORT PSAPMSGSUBCSYNC;
EXPORT PSAPMSGSUBPRCID;
EXPORT PSAPMSGXTB;

-- URL DEFINITIONS
EXPORT PSURLDEFN;
EXPORT PSURLDEFNLANG;
EXPORT PS_PT_URL_PROPS;

-- PORTAL
EXPORT PSPRSMDEFN;
EXPORT PSPRSMDEFNLANG;
EXPORT PSPRSMATTR;
EXPORT PSPRSMATTRLANG;
EXPORT PSPRSMATTRVAL;
EXPORT PSPRSMATTRVALNG;
EXPORT PSPRSMPERM;
EXPORT PSPRSMSYSATTR;
EXPORT PSPRSMSYSATTRVL;
EXPORT PSPRSMHPASGPGLT;
EXPORT PSPRSMSYNC;
EXPORT PSPRDMDEFN;
EXPORT PSPRDMDEFNLANG;
EXPORT PSPRDMCNTPRV;
EXPORT PSPRUHPERSPGLT;
EXPORT PSPRSMNUI;


-- RELATIONSHIPS
EXPORT PSRELATCONTACT;
EXPORT PSRELATIONLANG;
EXPORT PSRELATIONPROP;
EXPORT PSRELATIONSHIP;
EXPORT PSRELPROPLANG;

-- APPLICATION PACKAGES
EXPORT PSPACKAGEDEFN;
EXPORT PSPACKAGELANG;
EXPORT PSAPPCLASSDEFN;

-- ARCHIVE TEMPLATES
EXPORT PS_ARCH_PROJ;
EXPORT PS_ARCH_TBL;
EXPORT PS_ARCH_CTRL;
EXPORT PS_ARCH_OTH_CTRL;
EXPORT PS_ARCH_SQL_LNG;

-- ARCHIVE OBJECTS
EXPORT PSARCHOBJDEFN;
EXPORT PSARCHOBJLANG;
EXPORT PSARCHOBJREC;

-- ARCHIVE TEMPLATES (TYPE 2)
EXPORT PSARCHTEMPLATE;
EXPORT PSARCHTEMPLANG;
EXPORT PSARCHTEMPOBJ;
EXPORT PSARCHTEMPQRY;
EXPORT PSARCHTEMPAE;

-- DIAGNOSTIC PLUGINS
EXPORT PSDIAGREG;

-- CONNECT STRINGS
EXPORT PSCONN;
EXPORT PSCONNLANG;
EXPORT PSCONNPROP;
EXPORT PSCONNPROPLANG;

-- FORMAT DEFINITIONS
EXPORT PSCIREF;
EXPORT PSCIREFLANG;
EXPORT PSCIREFPROPERTY;
EXPORT PSCIREFENUM;
EXPORT PSCISYNCDEFN;

-- EVALUATED NODE TRANSACTION
EXPORT PSNODETRX;
EXPORT PSNODTRXCONPROP;

-- EVALUATED RELATIONSHIP TRANSACTION
EXPORT PSRELATIONTRX;

-- MOBILE PAGE
EXPORT PSMPDEFN;
EXPORT PSMPDEFNLANG;
EXPORT PSMPDEFNDEV;
EXPORT PSMPDEFNDEVLANG;
EXPORT PSMPCONTDEV;
EXPORT PSMPCONTDEVLANG;
EXPORT PSSYSTEMID;
EXPORT PSAUTHMP;

-- DICTIONARY
EXPORT PSSCDICTDEFN;

-- MESSAGES
EXPORT PSMSGSETDEFN;
EXPORT PSMSGSETLANG;
EXPORT PSMSGCATDEFN;
EXPORT PSMSGCATLANG;

-- PROBLEM DEFINITIONS
EXPORT PSOPTPRBTYPE;
EXPORT PSOPTPRBTYPELNG;
EXPORT PSOPTTRN;
EXPORT PSOPTTRNLNG;
EXPORT PSOPTTRNCTLG;
EXPORT PSOPTREC;
EXPORT PSOPTRECLNG;
EXPORT PSOPTFIELD;

-- PORTAL REGISTRY USER FAVORITES
EXPORT PSPRUFDEFN;

-- PORTAL USER REGISTRY HOMEPAGE
EXPORT PSPRUHDEFN;
EXPORT PSPRUHTAB;
EXPORT PSPRUHTABPGLT;

-- SYSTEM PAUSE TIME
EXPORT PSSPTDEFN;
EXPORT PSSPTIMES;

-- TOOLBARS
EXPORT PSTOOLBARDEFN;
EXPORT PSTOOLBARITEM;

-- MAINTENANCE LOG
EXPORT PS_MAINTENANCE_LOG;

-- HOLIDAY DEFINITIONS
EXPORT PSHOLIDAYDEFN;

-- USERS
-- Note:  PSOPRDEFN exported separately, see top of script
EXPORT PSOPRALIAS;
EXPORT PSROLEUSER;
EXPORT PSUSERATTR;
EXPORT PSUSEREMAIL;
EXPORT PSUSERPRSNLOPTN;
EXPORT PS_ROLEXLATOPR;
EXPORT PS_ROLEXLATOPR_LNG;
EXPORT PS_RTE_CNTL_RUSER;

-- ROLES
EXPORT PSROLEDEFN;
EXPORT PSROLEDEFNLANG;
EXPORT PSROLECANGRANT;
EXPORT PSROLECLASS;
EXPORT PS_PTROLENAMEALIAS;

-- PERMISSION LISTS
EXPORT PSCLASSDEFN;
EXPORT PSCLASSDEFN_LNG;
EXPORT PSAUTHBUSCOMP;
EXPORT PSAUTHCHNLMON;
EXPORT PSAUTHCUBE;
EXPORT PSAUTHITEM;
EXPORT PSAUTHOPTN;
EXPORT PSAUTHQUEUEMON;
EXPORT PSAUTHPRCS;
EXPORT PSAUTHSIGNON;
EXPORT PSAUTHWS;
EXPORT PSPRCSPRFL;
EXPORT PSPTSCRTY_ADS_A;
EXPORT PSPTSCRTY_ADS_P;
EXPORT PS_MC_OPR_SECURITY;
EXPORT PS_MC_OPRID;
EXPORT PS_SCRTY_ACC_GRP;
EXPORT PS_SCRTY_QUERY;
EXPORT PS_SCRTY_SRCHGRP;
EXPORT PS_PTCLASSIDALIAS;

-- DEFINITION SECURITY
EXPORT PSPTDEFSEC_GRPS;
EXPORT PSPTDEFSEC_GRP;
EXPORT PSPTDEFSECINRL;
EXPORT PS_APP_DES_OBJ_CST;
EXPORT PSOPROBJ;

-- PERSONALIZATIONS
EXPORT PSUSEROPTNDEFN;
EXPORT PSUSEROPTNLANG;
EXPORT PSOPTNCATGRPLNG;
EXPORT PSOPTNCATGRPTBL;
EXPORT PSOPTNCATTBL;
EXPORT PSOPTNCATLANG;


-- SECURITY OPTIONS
EXPORT PSSECOPTIONS;
EXPORT PS_PTALIASOPTIONS;

-- SECURITY LINKS
EXPORT PSUSEROTHER;
EXPORT PSUSEROTHER_L;
EXPORT PSUSERSELFOTHER;
EXPORT PSUSERSELFOTH_L;
EXPORT PSROLEOTHER;
EXPORT PSROLEOTHER_LNG;
EXPORT PSPERMLISTOTHER;
EXPORT PSPERMLISTOTH_L;

-- USER ID TYPES
EXPORT PSOPRALIASTYPE;
EXPORT PSOPRALIASFIELD;

-- DELETE USER BYPASS TABLE
EXPORT PS_BYPASS_TABLE;

-- FORGOT EMAIL TEXT
EXPORT PSPSWDEMAIL;
EXPORT PSPSWDEMAILLANG;

-- PASSWORD HINTS
EXPORT PSPSWDHINT;
EXPORT PSPSWDHINT_LANG;

-- SIGNON PEOPLECODE
EXPORT PSSIGNONPPC;

-- DIRECTORY
EXPORT PSDSDIR;
EXPORT PSDSSRVR;
EXPORT DSCONNECTID;
EXPORT PSDSEXT_INSTALL;
EXPORT PSDSSECMAPMAIN;
EXPORT PSDSSECMAPSRVR;
EXPORT DSUSRPRFLMAP;
EXPORT PSDSUSERPRFL;
EXPORT PSDSSECROLERULE;
EXPORT DSSRCH_SBR;
EXPORT DSSRCHATTR;
EXPORT DSSECFILTER;
EXPORT PT_WF_NOT_DSCFG;

-- PEOPLETOOLS SYSTEM DATA
EXPORT PSCRYPTALGCHAIN;
EXPORT PSCRYPTALGDEFN;
EXPORT PSCRYPTALGPARAM;
EXPORT PSCRYPTCHNDEFN;
EXPORT PSCRYPTDLLDEFN;
EXPORT PSCRYPTKEYSET;
EXPORT PSCRYPTPRFL;
EXPORT PSCRYPTPRFLPRM;
EXPORT PSTIMEZONEDEFN;
EXPORT PSTIMEZONEDFNLG;
EXPORT PSDSTTIME;
EXPORT PSCHARSETS;
EXPORT PS_OLAP_ATTRIB_NAM;
EXPORT PS_VERTICAL_MARKET;
EXPORT PS_APP_DES_OBJECTS;
EXPORT PS_APP_DES_OBJ_PAR;
EXPORT PSPGEACCESSDESC;
EXPORT PSOBJSECDESC;
EXPORT PSOPTPARMTYPE;
EXPORT PSLOCALEDEFN;
EXPORT PSLOCALELANG;
EXPORT PSLOCALEOPTNDFN;
EXPORT PSLOCALEORDER;
EXPORT PSCOLLATIONS;
EXPORT PS_CDM_FILE_EXT;
EXPORT PS_AEONLINEINST;
EXPORT PS_WL_TEMPLATE_GEN;
EXPORT PS_WL_TEMPLATE_GLN;
EXPORT PS_WL_TEMPL_GEN_TK;
EXPORT PSGATEWAY;
EXPORT PSRF_FLIST_TBL;
EXPORT PSRF_FLIST_LANG;
EXPORT PSRF_FVIEW_TBL;
EXPORT PSRF_FVIEW_LANG;
EXPORT PS_DECIMAL_POS_TBL;
EXPORT PS_WL_TEMPL_GNTKLN;
EXPORT PSACTIVEXLIC;
EXPORT PS_APPDES_OBJ_PERM;
EXPORT PSXMLSIGNINST;
EXPORT PS_TS_REC_KEYFLDS;
EXPORT PS_TS_REC_TXTFLDS;
EXPORT PS_TS_RECORDS;
EXPORT PS_MCF_IM_SERVERS;
EXPORT PS_MCF_INSTALL;
EXPORT PS_MCFIMNETWORKS;
EXPORT PSMCFRENPERMS;
EXPORT PSMCFSYSTEM;
EXPORT PS_MCFUQTASKCFG;
EXPORT PS_PINGOPTIONS;
EXPORT PSVERITYLOCALE;
EXPORT PS_PTP_TABLE1;
EXPORT PS_PTP_TABLE2;
EXPORT PS_PT_CTI_SWITCH;
EXPORT PS_WF_INSTSTATUS;
EXPORT PSIBWSDLADMIN;
EXPORT PSRENNAMETOPIC;
EXPORT PSTRANSFRM_TST;
EXPORT PSSHADOWSEQ;
EXPORT PS_PTEXEC2RESOURCE;
EXPORT PS_PT_ORA_RESOURCE;
EXPORT PS_PTCS_HANDLER;
EXPORT PS_PTCS_PARAMETERS;
EXPORT PS_PTCS_PARAMSLANG;
EXPORT PS_PTCSSERVICEDEFN;
EXPORT PS_PTCSSRVDEFNLANG;
EXPORT PS_PTFP_OPTIONS;
EXPORT PS_PTFP_SYSVAR;
EXPORT PSIWCEVENTS;
EXPORT PSMSGEVENTS;
EXPORT PS_PTFX_EXTLSTDEFN;
EXPORT PS_PTFX_EXTLST;
EXPORT PS_PTCAC_AUTHCONF;
EXPORT PS_PTAL_PAGE;
EXPORT PS_PTAL_PAGELET;
EXPORT PS_PTAL_PGLTGRP;
EXPORT PS_PTAL_TEMPLATE;
EXPORT PS_PTAL_UP_PAGE;
EXPORT PS_PTAL_UP_PAGELET;
EXPORT PS_PTAL_PAGE_L;
EXPORT PS_PTAL_PGLTGRP_L;
EXPORT PS_PTAL_TEMPLATE_L;
EXPORT PS_PTIA_DCAEPGMS;
EXPORT PS_PTIA_UPGPATHS;

-- WEB Data
EXPORT PSWEBPROFBROW;
EXPORT PSWEBPROFCOOK;
EXPORT PSWEBPROFDEF;
EXPORT PSWEBPROFILE;
EXPORT PSWEBPROFPROP;
EXPORT PSWEBPROFNVP;

-- XML Service Info
EXPORT PS_XMLSERVICEINFO;

-- EDI OBJECTS
EXPORT PS_ECACTIONCDS;
EXPORT PS_ECACTIONS;
EXPORT PS_ECCVTPROFILE;
EXPORT PS_ECENTITYCDS;
EXPORT PS_ECEXTPARTNER;
EXPORT PS_ECEXTTPLINK;
EXPORT PS_ECGENERAL;
EXPORT PS_ECINMAPFILE;
EXPORT PS_ECINMAPFLD;
EXPORT PS_ECINMAPFLDCVT;
EXPORT PS_ECINMAPREC;
EXPORT PS_ECINMAPRECFLD;
EXPORT PS_ECINTLINK;
EXPORT PS_ECINTPARTNER;
EXPORT PS_ECMAPDEFN;
EXPORT PS_ECMAPPROFILE;
EXPORT PS_ECNAMES;
EXPORT PS_ECOUTMAPCVT;
EXPORT PS_ECOUTMAPFLD;
EXPORT PS_ECOUTMAPREC;
EXPORT PS_ECOUTMAPWHERE;
EXPORT PS_ECPRIEVENTCDS;
EXPORT PS_ECPRODFLTS;
EXPORT PS_ECPROMAP;
EXPORT PS_ECPROTRANS;
EXPORT PS_ECSECEVENTCDS;
EXPORT PS_ECTPALIAS;
EXPORT PS_ECTPCVT;
EXPORT PS_ECTPCVT_HDR;
EXPORT PS_ECTPCVT_LN;
EXPORT PS_ECTPPROFILE;
EXPORT PS_ECTRANS;
EXPORT PS_ECTRANSOPTION;
EXPORT PS_ECTRANSOPVAL;

-- SDK Data
EXPORT PS_SDK_AMORT_PREF;
EXPORT PS_SDK_BUS_EXP_DTL;
EXPORT PS_SDK_BUS_EXP_PER;
EXPORT PS_SDK_COMPANY_TBL;
EXPORT PS_SDK_COUNTRY_TBL;
EXPORT PS_SDK_CURR_CD_TBL;
EXPORT PS_SDK_DEPT_TBL;
EXPORT PS_SDK_EM_MAILLST;
EXPORT PS_SDK_EM_RCVMSGS;
EXPORT PS_SDK_EM_SNDEMAIL;
EXPORT PS_SDK_FILEUTL_AET;
EXPORT PS_SDK_INSTALL;
EXPORT PS_SDK_INTL_FLG_CD;
EXPORT PS_SDK_JOB;
EXPORT PS_SDK_LOCH_TBL;
EXPORT PS_SDK_PERS_DATA;
EXPORT PS_SDK_POS_DATA;
EXPORT PS_SDK_PSTREENODE;
EXPORT PS_SDK_RP_INPUT;
EXPORT PS_SDK_RP_PO;
EXPORT PS_SDK_RP_POLINE;
EXPORT PS_SDK_RP_QUERYWRK;
EXPORT PS_SDK_RP_RESULT;
EXPORT PS_SDK_RP_SALORDER;
EXPORT PS_SDK_RP_SITE;
EXPORT PS_SDK_RP_SOQRY1;
EXPORT PS_SDK_RP_SOQRY2;
EXPORT PS_SDK_RT_TYPE_TBL;
EXPORT PS_SDK_RUNCNTL;
EXPORT PS_SDK_SCRTY_DEPT;
EXPORT PS_SDK_SM;
EXPORT PS_SDK_SM_CONCATE;
EXPORT PS_SDK_SRCHSPREF;
EXPORT PS_SDK_SRCH_SAVE;
EXPORT PS_SDK_STOCK;
EXPORT PS_SDK_STOCKXCHG;
EXPORT PS_SDK_STOCK_PRF;
EXPORT PS_SDK_UPS_COST;
EXPORT PS_SDK_UPS_CST_RES;
EXPORT PS_SDK_UPS_TIME;

-- Performance Monitor Data
EXPORT PSPMCONTEXTDEFN;
EXPORT PSPMEVENTDEFN;
EXPORT PSPMEVENTSET;
EXPORT PSPMMETRICDEFN;
EXPORT PSPMMETRICVALUE;
EXPORT PSPMMONITORGBL;
EXPORT PSPMSYSDEFAULTS;
EXPORT PSPMTABLEMAP;
EXPORT PSPMTRANSDEFN;
EXPORT PSPMTRANSSET;
EXPORT PSPMTRANSSET_LN;

--  Mathematical Model
EXPORT PSANALYTICREG;
EXPORT PSOPTCONARRAY;
EXPORT PSOPTCONSEXP;
EXPORT PSOPTINDEX;
EXPORT PSOPTINDEXSET;
EXPORT PSOPTLINEXP;
EXPORT PSOPTMODEL;
EXPORT PSOPTMODELLNG;
EXPORT PSOPTMDLSLVR;
EXPORT PSOPTOBJECTIVE;
EXPORT PSOPTPARARRAY;
EXPORT PSOPTPARAEXPDIM;
EXPORT PSOPTPARSDIM;
EXPORT PSOPTPRED;
EXPORT PSOPTPREDDIM;
EXPORT PSOPTPTMODEL;
EXPORT PSOPTREGION;
EXPORT PSOPTREGIONDIM;
EXPORT PSOPTSETDIM;
EXPORT PSOPTSLICEDIM;
EXPORT PSOPTSLICESET;
EXPORT PSOPTSOLVERPARA;
EXPORT PSOPTVAREXPDIM;
EXPORT PSOPTVARARRAY;
EXPORT PSOPTVARSDIM;

-- File Reference
EXPORT PSFILEREDEFN;

-- File Reference Type code
EXPORT PSTYPECODEDEFN;

-- ACE
EXPORT PSACECUBE;
EXPORT PSACECUBECOLL;
EXPORT PSACECUBECOLMAP;
EXPORT PSACECUBEDIMS;
EXPORT PSACEDIM;
EXPORT PSACEEXPDIMS;
EXPORT PSACEEXPSET;
EXPORT PSACEMDLDEFN;
EXPORT PSACEMDLDEFNLNG;
EXPORT PSACEORGANIZER;
EXPORT PSACEORGMAP;
EXPORT PSACERULE;
EXPORT PSACETREE;
EXPORT PSACEUSRFUNC;
EXPORT PSPNLACEGRDAXIS;
EXPORT PSPNLACEGRDDATA;

-- Web Services for Remote Portlets
EXPORT PSPRSMWSRPCONS;
EXPORT PSPRSMWSRPPROD;
EXPORT PSWSRPCPHDEFN;
EXPORT PSWSRPPLTDEFN;
EXPORT PSWSRPPLTGRPID;
EXPORT PSWSRPPLTKW;
EXPORT PSWSRPPLTKWLANG;
EXPORT PSWSRPPLTLANG;
EXPORT PSWSRPPRDDEFN;
EXPORT PSWSRPPRDLANG;
EXPORT PSWSRPPRDPROP;

-- Java Portlet User Preferences
EXPORT PSJPUPDEFN;
EXPORT PSJPUPPREF;
EXPORT PSJPUPPREFVAL;

-- Services
EXPORT PSSERVICE;
EXPORT PSSERVICELANG;
EXPORT PSSERVICEOPR;
EXPORT PSSERVICEUDDI;

-- Service Operation
EXPORT PSOPERATION;
EXPORT PSOPERATIONLANG;
EXPORT PSOPERATIONURI;

-- Service Operation Routings
EXPORT PSIBRTNGDEFN;
EXPORT PSRTNGDFNLANG;
EXPORT PSRTNGDFNCONPRP;
EXPORT PSRTNGDFNPROP;
EXPORT PSRTNGDFNPROPLG;
EXPORT PSIBRTNGSUBDEFN;
EXPORT PSRTNGDFNPARM;

-- Service Operation Handlers
EXPORT PSOPRHDLR;
EXPORT PSOPRHDLRLANG;
EXPORT PSOPERATIONAC;
EXPORT PSOPERATIONAE;
EXPORT PSOPERATIONCI;
EXPORT PSOPERATIONDMS;

-- Service Operation Versions
EXPORT PSOPRVERDFN;
EXPORT PSOPRVERDFNLANG;
EXPORT PSOPRVERDFNPARM;
EXPORT PSOPRVERQUEPARM;
EXPORT PSOPRGENRTGPARM;
EXPORT PSOPRVERDEPLOY;
EXPORT PSOPRVERDPLYVER;

-- Integration Broker Queues
EXPORT PSQUEUEDEFN;
EXPORT PSIBQUEUEINST;
EXPORT PSQUEUEDEFNLANG;
EXPORT PSQUEUEOVRD;
EXPORT PSQUEUEPART;

-- XML Publisher Data Source
EXPORT PSXPDATASRC;
EXPORT PSXPDATASRCLNG;
EXPORT PSXPSCHEMAFLMN;
EXPORT PSXPSMPLDTMN;

-- XML Publisher File Definition
EXPORT PSFILEDEFN;
EXPORT PSFILEDATA;

-- XML Publisher Report Definition
EXPORT PSXPRPTDEFN;
EXPORT PSXPRPTDEFNLNG;
EXPORT PSXPRPTOUTFMT;
EXPORT PSXPRPTPROP;
EXPORT PSXPRPTSCOPEFLD;
EXPORT PSXPRPTSRCHKEYS;
EXPORT PSXPRPTTMPL;
EXPORT PSXPRPTTMPLCTRL;
EXPORT PSXPRPTVIEWER;

-- XML Publisher Template Definition
EXPORT PSXPTMPLDEFN;
EXPORT PSXPTMPLDEFNLNG;
EXPORT PSXPTMPLFILEDEF;
EXPORT PSXPTMPLTRINFO;

-- Integration Broker Schema
EXPORT PSIBSCMADFN;
EXPORT PSIBSCMADATA;

-- Integration Broker WSDL
EXPORT PSIBWSDLDFN;
EXPORT PSIBWSDLDATA;

-- CONNECTED QUERY
EXPORT PSCONQRSDEFN;
EXPORT PSCONQRSDEFNLAN;
EXPORT PSCONQRSFLDREL;
EXPORT PSCONQRSMAP;
EXPORT PSCONQRSPROP;
EXPORT PSCONQRSXFORM;

-- Document Schema
EXPORT PSDOCSCMADFN;
EXPORT PSDOCSCMADATA;

-- Document Logical Schema
EXPORT PSLSDEFN;
EXPORT PSLSDEFNBODY;
EXPORT PSLSDEFNLANG;

-- Document Logical Dependency
EXPORT PSLSDEPDEFN;
EXPORT PSLSDEPDEFNLANG;
EXPORT PSLSDEPCHLDDFN;

-- Document Physical Schema
EXPORT PSPHYSSCHDEFN;
EXPORT PSPHYSSCHLANG;
EXPORT PSPHYSSCHBODY;

-- Cube Dimension
EXPORT PSCUBDIMENSION;
EXPORT PSCUBATTRIBDIM;
EXPORT PSCUBDIMENGEN;
EXPORT PSCUBDIMENLANG;
EXPORT PSCUBDIMSTRINFO;
EXPORT PSCUBDIMSTRUCT;
EXPORT PSCUBDIMSTRWIDE;

-- Cube Outline
EXPORT PSCUBOUTLINE;
EXPORT PSCUBDIMLIST;
EXPORT PSCUBOUTLINLANG;
EXPORT PSCUBOUTQRY;
EXPORT PSCUBOUTQRYCOL;
EXPORT PSCUBOUTQRYINF;

-- Cube Connection
EXPORT PSCUBCONNECTID;
EXPORT PSCUBCONNLANG;

-- Cube Template
EXPORT PSCUBTEMPL;
EXPORT PSCUBTEMPL_LNG;

-- Certificate
EXPORT PSCERTDB;
EXPORT PSCERTDEFN;
EXPORT PSCERTISSUER;

-- Key
EXPORT PSKEYDB;

-- Test
EXPORT PSPTTSTCMDDESCR;
EXPORT PSPTTSTCMDDSCIM;
EXPORT PSPTTSTDEFN;
EXPORT PSPTTSTDESCR;
EXPORT PSPTTSTDESCRIMG;
EXPORT PSPTTSTCOMMAND;
EXPORT PSPTTSTERROR;
EXPORT PSPTTSTPARAM;

-- Test Case
EXPORT PSPTTSTCASE;
EXPORT PSPTTSTCASEDSCR;
EXPORT PSPTTSTCASEVAL;

-- Application Data Set
EXPORT PSADSDEFAULTS;
EXPORT PSADSDEFN;
EXPORT PSADSDEFNITEM;
EXPORT PSADSDEFNLANG;
EXPORT PSADSEXCLUSIONS;
EXPORT PSADSRELMAP;
EXPORT PSADSSQLREF;
EXPORT PSPROJADSBIND;
EXPORT PSPROJBINDITEM;
EXPORT PSADSGROUP;
EXPORT PSADSGROUPLANG;
EXPORT PSADSGROUPMEMB;
EXPORT PSADSGROUPPROP;
EXPORT PSADSRELATION;
EXPORT PSADSRELLANG;
EXPORT PSADSRELPROP;

-- Related Content Layout
EXPORT PSPTCS_MENU_TBL;
EXPORT PSPTCS_MENULOC;
EXPORT PSPTCS_MNUFLDRS;
EXPORT PSPTCS_MNULINKS;
EXPORT PSPTCSMNUFLDRLG;

-- Related Content Service
EXPORT PSPTCS_SRVCFG;

-- Related Content Service Configuration
EXPORT PSPTCS_MAPFLDS;
EXPORT PSPTCSSRVCONF;
EXPORT PSPTCSSRVCONFLG;

-- Related Content Service Definition
EXPORT PSPTCS_PARAMS;
EXPORT PSPTCS_PARAMSLG;
EXPORT PSPTCSSRVDEFN;
EXPORT PSPTCSSRVDEFNLG;

-- Integration Group
EXPORT PSIBGROUPDEFN;
EXPORT PSIBGROUPLANG;
EXPORT PSIBSBGROUPLANG;
EXPORT PSIBSRVGROUP;
EXPORT PSIBSUBGROUP;
EXPORT PSIBSUBSRVGROUP;

-- Search Attribute
EXPORT PSPTSF_ATTRS;
EXPORT PSPTSF_ADD_PRMS;
EXPORT PSPTSF_ATT_PROP;

-- Search Definition
EXPORT PSPTSF_SD;
EXPORT PSPTSF_SD_ATTR;
EXPORT PSPTSF_SD_ATTRH;
EXPORT PSPTSF_SD_DCATR;
EXPORT PSPTSF_SD_DCACL;
EXPORT PSPTSF_SD_LANG;
EXPORT PSPTSF_SD_PNLGP;
EXPORT PSPTSF_SD_SRACL;

-- Search Category
EXPORT PSPTSF_CATADVFD;
EXPORT PSPTSF_CATDSPFD;
EXPORT PSPTSF_CATFACET;
EXPORT PSPTSF_CAT_LANG;
EXPORT PSPTSF_SRCCAT;
EXPORT PSPTSF_SRCCATAT;
EXPORT PSPTSF_CATSRTFD;
EXPORT PSPTSF_FACET_DT;

-- Search Context
EXPORT PSPTUS_CTX;
EXPORT PSPTUS_CTX_DET;

-- Feed Definition
EXPORT PSFP_ADMN_PREF;
EXPORT PSFP_USER_PREF;
EXPORT PSFP_ATTRS;
EXPORT PSFP_ATTRS_LANG;
EXPORT PSFP_FEED;
EXPORT PSFP_FEED_LANG;
EXPORT PSFP_PARMS;
EXPORT PSFP_PARMS_LANG;
EXPORT PSFP_PUB_SITES;
EXPORT PSFP_PVALS;
EXPORT PSFP_PVALS_LANG;
EXPORT PSFP_SECURITY;
EXPORT PSFP_SETTINGS;

-- Feed Category
EXPORT PSFP_CATEGORY;
EXPORT PSFP_CATG_LANG;

-- Feed Data Type
EXPORT PSFP_DATATYPE;
EXPORT PSFP_DATTR_LANG;
EXPORT PSFP_DTYPE_LANG;
EXPORT PSFP_DTYPE_IBSO;
EXPORT PSFP_DTYPE_ATTR;

-- Document Layout
EXPORT PSDOCLOBASEVENT;
EXPORT PSDOCLOCLASS;
EXPORT PSDOCLOCSS;
EXPORT PSDOCLOCTLDATA;
EXPORT PSDOCLODEFN;
EXPORT PSDOCLODEFNLANG;
EXPORT PSDOCLODFLTOPTNS;
EXPORT PSDOCLOEVENT;
EXPORT PSDOCLOFIELD;
EXPORT PSDOCLOFLDELMNT;
EXPORT PSDOCLOGRPID;
EXPORT PSDOCLOHTMLAREA;
EXPORT PSDOCLOHTMLLANG;
EXPORT PSDOCLOJS;
EXPORT PSDOCLOMULT;
EXPORT PSDOCLOMULTPROP;
EXPORT PSDOCLOPAGE;
EXPORT PSDOCLOPAGELANG;
EXPORT PSDOCLOPROPID;
EXPORT PSDOCLOREFEVENT;
EXPORT PSDOCLOROWCNTRL;
EXPORT PSDOCLOURL;
EXPORT PSDOCLOURLCNT;
EXPORT PSDOCLOURLELMNT;
EXPORT PS_PSDOCLOAPPR_WL;
EXPORT PSDOCLOJQ;
EXPORT PSDOCLOPAGEPROP;
EXPORT PSDOCLOURIPARMS;
EXPORT PSDOCLOURITMPL;
EXPORT PSDOCPCDFNLANG;
EXPORT PSDOCPCIMPORT;
EXPORT PSDOCPCPROP;
EXPORT PSIBDLLOCK;
EXPORT PSIBDOCLOSYNC;
EXPORT PSDOCLOCONTROLS;
EXPORT PSDOCLOEDITS;
EXPORT PSDOCLODFNID;
EXPORT PSDOCLOJSFLD;
EXPORT PSDOCLOCSSDATA;
EXPORT PSDOCLOJSDATA;
EXPORT PSDOCLOLBLLANG;
EXPORT PSDOCLOLBLTRANS;
EXPORT PSDOCTPLCOMLANG;
EXPORT PSDOCTPLCOMTRAN;
EXPORT PSDOCTPLCSSDATA;
EXPORT PSDOCTPLJSDATA;


-- Document PeopleCode
EXPORT PSDOCPCDATA;
EXPORT PSDOCPCDFN;
EXPORT PSDOCPCDFNDEL;
EXPORT PSDOCPCBINDS;
EXPORT PSDOCPCXML;

-- Document Template
EXPORT PSDOCTPLBINDS;
EXPORT PSDOCTPLBNDLANG;
EXPORT PSDOCTPLDEFN;
EXPORT PSDOCTPLLANG;
EXPORT PSDOCTPLMEDIA;
EXPORT PSDOCTPLMEDIACL;
EXPORT PSDOCTPLSELPROP;
EXPORT PSDOCTPLVIEW;
EXPORT PSDOCTPLZONE;
EXPORT PSDOCTPLCONSEL;
EXPORT PSDOCTPLCONT;
EXPORT PSDOCTPLCONTFLD;
EXPORT PSDOCTPLCSS;
EXPORT PSDOCTPLSELDECL;
EXPORT PSDOCTPLJS;
EXPORT PSDOCTPLSUB;

-- Composite Query
EXPORT PSCPQCRITERIA;
EXPORT PSCPQDEFN;
EXPORT PSCPQDEFN_LANG;
EXPORT PSCPQDEFNDEL;
EXPORT PSCPQFLDREL;
EXPORT PSCPQMAP;
EXPORT PSCPQPROP;
EXPORT PSCPQSELECT;
EXPORT PSCPQBIND;
EXPORT PSCPQBINDLANG;
EXPORT PSCPQEXPR;
EXPORT PSCPQFIELD;

-- Pivot Grid Data Source Type
export PSPGDTYPE;
export PSPGDTYPELANG;

-- Pivot Grid Definition
export PSPGCORE;
export PSPGCORELANG;
export PSPGDISPOPT;
export PSPGMODEL;
export PSPGMODELLANG;
export PSPGSETTINGS;

-- Pivot Grid View
export PSPGCHARTOPT;
export PSPGCHARTOPTLNG;
export PSPGCHRTFLRSOPT;
export PSPGCHTFLRSLANG;
export PSPGGRIDOPT;
export PSPGQRYPROMPLNG;
export PSPGQRYPROMPT;
export PSPGVIEWOPT;
export PSPGVIEWOPTLANG;
export PSPGAXIS;
export PSPGNUIOPT;
export PSPGCALCOPT;

-- Pivot Grid Personalization
export PSPGAXISPERS;
export PSPGAXISPERSLNG;
export PSPGCHARTOPTPER;
export PSPGCHTOPTPERLN;
export PSPGGRIDOPTPERS;
export PSPGQRYPRMPTPER;
export PSPGQRYPRMPTPLN;
export PSPGVIEWOPTPERS;
export PSPGVWOPTPERLN;

-- Activity Guide List
export PTAI_CONTEXT;
export PTAI_LIST;
export PTAI_LIST_LNG;
export PTAI_LIST_PRIV;
export PTAI_PGLT_BTN;
export PTAI_LIST_USER;

-- Activity Guide Item
export PTAI_ATTACH;
export PTAI_HIER;
export PTAI_ITEM;
export PTAI_ITEM_LNG;
export PTAI_ITEM_CNTXT;
export PTAI_OVRPGTBTLG;

-- MAP Manager
EXPORT PSMAPMDEFN;
EXPORT PSMAPMDEL;
EXPORT PSMAPMLANG;
EXPORT PSMAPMSECLANG;
EXPORT PSMAPMSECURITY;
EXPORT PSMAPMSRVRPSTRY;
EXPORT PSOPRVDCONTTYPE;
EXPORT PSOPRVDPARMTYPE;

-- Branding Framework
EXPORT PS_PTBR_THEME_CSS;
EXPORT PS_PTBR_THEME_DEL;

List of Active Users In PeopleSoft

SELECT A.OPRID, A.LOGIPADDRESS, TO_CHAR(CAST((A.LOGINDTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'), ROUND((CAST(( CAST(SYSTIMESTAMP AS TIMESTAMP)) AS DATE) - CAST((TO_TIMESTAMP(TO_CHAR(CAST((A.LOGINDTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'),'YYYY-MM-DD-HH24.MI.SS.FF')) AS DATE)) * 1440, 0)
  FROM PSACCESSLOG A
  WHERE ( A.LOGINDTTM = A.LOGOUTDTTM
     AND A.PT_SIGNON_TYPE = '1'
     AND A.LOGINDTTM >= SYSDATE - 1/24)
  GROUP BY  A.OPRID,  A.LOGIPADDRESS,  A.LOGINDTTM
  ORDER BY 3 DESC