PeopleSoft Tables Used by TA

TA reads from these PeopleSoft tables but only updates those tables indicated by **.

Note: Ensure that the user specified in the connection definition can read from all of the following PeopleSoft data tables. Only the tables marked with a ** require write access. For Oracle database, make sure that the DB Access Id defined in the connection definition is the owner of the Peoplesoft Schema, which is usually SYSADM. If not, create synonyms for all the tables listed below (e.g., CREATE SYNONYM PSSTATUS for SYSADM.PSSTATUS) for the DB Access Id.

  • PSAUTHITEM: Used to get menu items accessible to the operator.

  • PSAUTHPRCS: Used to get process groups (and hence processes and jobs) accessible to the operator.

  • PS_CDM_AUTH**: TA inserts into this table. This table is used to authorize user access to content. (output, logs, etc.)

  • PS_CDM_DIST_NODE: Used to get the posting directory.

  • PS_CDM_FILE_LIST: Used to determine output filenames generated by a process.

  • PS_CDM_LIST**: TA inserts into this table. Creates row in distribution table. The field PRCSOUTPUTDIR contains a generated directory name.

  • PSCLOCK: A one-row, dummy table used to select the date and time.

  • PSMENUITEM: Used to get the panel groups associated with menu items.

  • PSMSGCATDEFN: Used to get text of messages generated by the Process Scheduler.

  • PSOPRCLS: Used to determine which operator classes an operator is a member of, to determine which processes the operator can run.

  • PSOPRDEFN: Retrieves the process profile class for an operator (used to enforce override security).

  • PS_OUTDESTFORMAT: Used to obtain the list of output destination formats for each process. The primary key of this table has a foreign key in PSPRCSRQST and PSPRCSQUE.

  • PS_OUTDESTTYPE: Used to obtain a list of appropriate output types and descriptions for a particular process.

  • PSPNLFIELD: Used to get information about Run Control parameters.

  • PSPNLGROUP: Used to get the panels that comprise a panel group.

  • PSPNLGRPDEFN: Used to get the search records (and hence the run control records) associated with a panel group.

  • PS_PRCSDEFNCNTDIST: Used to get overrides to distribution defaults.

  • PS_PRCSDEFN: Used to get basic information about each process defined in the PeopleSoft system. This includes overrides to standard command line parameters, and to input and output locations, etc.

  • PS_PRCSDEFNGRP: Used to determine the process groups that a process is assigned to. This is used in conjunction with PSAUTHPRCS to determine which processes an operator can run.

  • PS_PRCSDEFNPNL: Used to get the panel group associated with a process definition, in order to access that process’s run control.

  • PS_PRCSJOBDEFN Used to generate list of jobs (groups of processes). This is the parent of PS_PRCSJOBITEM (see below).

  • PS_PRCSJOBGRP: Used to determine the process groups that a job is assigned to. This is used in conjunction with PSAUTHPRCS to determine which jobs an operator can run.

  • PS_PRCSJOBITEM: Used to get the individual processes that comprise a job. (See entry for PS_PRCSJOBDEFN.)

  • PS_PRCSJOBPNL: Used to get the panel group associated with a process job to access that job’s run control.

  • PSPRCSJOBSTATUS: Used to get all jobs status based on the process instance ID.

  • PSPRCSPARMS**: Used to schedule processes. TA selects from, inserts into, and updates this table.

  • PSPRCSPRFL: Used to get the security settings for an operator governing what the operator can access and/or modify when using the Process Scheduler and Process Monitor.

  • PSPRCSRQST**: Used to schedule processes. TA selects from, inserts into, and updates this table.

  • PSPRCSQUE**: Used to queue scheduled processes. TA selects from, inserts into, and updates this table.

  • PS_PRCSRQSTDIST**: TA inserts into this table. It is used to specify the target of report distribution.

  • PSPRCSRQSTTEXT**: TA inserts into this table. This table contains all long text fields associated with a process request. It is used primarily to specify the needed information for email distribution.

  • PSPRCSRUNCNTL: Used to get the last settings selected by an operator for a particular run ID concerning run location, output destination, etc.

  • PS_PRCSRUNCNTLDIST: Used to get report run time based on the process instance and stores distribution list.

  • PS_PRCSRUNCNTLEOPT: Used while running the Peoplesoft job to fetch request type and text.

  • PS_PRCSTYPEDEFN: Used to generate a list of process types, and to get the default command line parameters for each process type.

  • PSQRYDEFN: Used to get all query name list.

  • PSQRYXFORM: Used to get xslt name list based on the query name.

  • PSQUERY_RUN_CNTRL: Used to get query name based run control ID.

  • PSROLECLASS: Used to authorize classes of roles.

  • PSROLEDEFN: Used to get role related information.

  • PSROLEUSER: Used to authorize users with defined roles.

  • PS_SERVERCLASS: Used to get the process types that may be run on a particular Process Scheduler server.

  • PS_SERVERDEFN: Used to get basic information about the Process Scheduler server, including how many processes can run concurrently.

  • PSSERVERSTAT: Used to get the status of a process server.

  • PSSQLTEXTDEFN: Used while fetching the run control parameters to fetch the actual select query based on the run control table.

  • PSSTATUS (PeopleTools 8+): Used to get the PeopleSoft Tools version number.

  • PS_PRCSSEQUENCE** (PeopleTools 8+): Used to get and increment the process instance number and the distribution content ID.

  • PS_PRCSRUNCNTL: Demonstrates how run control values are passed to processes that run within the Process Scheduler.

  • ALL_TAB_COLUMNS: Used to check the existence of a table with the column name RUN_CNTL_ID.

  • PSDBFIELD: Used to fetch the data type of a field.

  • PSUSERPRSNLOPTN: Used to get the date format from regional settings of a user.

  • PSLOCALEOPTNDFN: Used to fetch the locale date format.

  • PSUSEROPTNDEFN: Used to get the system-wide date format.

  • PSXLATITEM**: Used to fetch the actual date format string. Additionally, used to fetch the description for the drop-down field values.

  • PSRECDEFN Used to get the sub-records while fetching the Run control parameters for 8.54 and above.

  • PSRECFIELD: Used to get the table name corresponding to a drop-down.

  • PS_SCHDLITEM: Used to get the run control and output details of a Peoplesoft job.