Scribd Logo
Upload

Welcome to Scribd!

  • 81 views

    Peoplesoft TablesList

    Uploaded by

    nikhitha
    The document lists various PeopleSoft tables and their purposes. It describes tables for object definitions, security, login details, auditing, versions, languages, modules, processes, reports, servers, and translating. Key tables include PSROLECLASS and PSROLEUSER for security roles and users, PSACCESSLOG for login auditing, PSAUDIT for changes, PSRELEASE for versions, and PSXLATDEFN and PSXLATITEM for translating values. The tables store configuration details for PeopleSoft applications and enable functions like security, auditing, processing, reporting and internationalization.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Peoplesoft TablesList

    Uploaded by

    nikhitha
    81 views6 pages
    The document lists various PeopleSoft tables and their purposes. It describes tables for object definitions, security, login details, auditing, versions, languages, modules, processes, reports, servers, and translating. Key tables include PSROLECLASS and PSROLEUSER for security roles and users, PSACCESSLOG for login auditing, PSAUDIT for changes, PSRELEASE for versions, and PSXLATDEFN and PSXLATITEM for translating values. The tables store configuration details for PeopleSoft applications and enable functions like security, auditing, processing, reporting and internationalization.

    Original Description:

    List of Peoplesoft tables

    Original Title

    Peoplesoft_TablesList

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document lists various PeopleSoft tables and their purposes. It describes tables for object definitions, security, login details, auditing, versions, languages, modules, processes, reports, servers, and translating. Key tables include PSROLECLASS and PSROLEUSER for security roles and users, PSACCESSLOG for login auditing, PSAUDIT for changes, PSRELEASE for versions, and PSXLATDEFN and PSXLATITEM for translating values. The tables store configuration details for PeopleSoft applications and enable functions like security, auditing, processing, reporting and internationalization.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    81 views6 pages

    Peoplesoft TablesList

    Uploaded by

    nikhitha
    The document lists various PeopleSoft tables and their purposes. It describes tables for object definitions, security, login details, auditing, versions, languages, modules, processes, reports, servers, and translating. Key tables include PSROLECLASS and PSROLEUSER for security roles and users, PSACCESSLOG for login auditing, PSAUDIT for changes, PSRELEASE for versions, and PSXLATDEFN and PSXLATITEM for translating values. The tables store configuration details for PeopleSoft applications and enable functions like security, auditing, processing, reporting and internationalization.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 6

    PeopleSoft Object Definition Tables

    PSACTIVITYDEFN
    PSAESECTDEFN
    PSAESTEPDEFN
    PSAESTEPMSGDEFN
    PSPCMPROG
    PSSQLTEXTDEFN
    PSAEAPPLDEFN
    PSMENUDEFN
    PSPNLDEFN
    PSPNLGROUP
    PSBCDEFN
    PSBUSPROCDEFN
    PS_APPR_RULE_HDR
    PSCHNLDEFN
    PSEVENTDEFN
    PSFLDFIELDDEFN
    PSFILEREDEFN
    PSINDEXDEFN
    PSIODEFN
    PSKEYDEFN
    PSMPDEFN
    PSMSGAGTDEFN
    PSMSGCATDEFN
    PSMSGDEFN
    PSDBFIELD
    PSDDLDEFPARMS
    PSGATEWAY
    PSIDXDDLPARM
    PSRECDEFN
    PSPACKAGEDEFN
    PSPNLGRPDEFN
    PSPRDMDEFN
    PSPROJECTDEFN
    PSPRSMDEFN
    PSPRUFDEFN
    PSPRUHDEFN
    PSQRYDEFN
    PSROLEDEFN
    PSSQLDEFN
    PSSQLTEXTDEFN
    PSSTEPDEFN
    PSSTYLEDEFN
    PSSTYLSHEETDEFN
    PSSUBDEFN
    PSTOOLBARDEFN
    PSTREEDEFN
    PSCLASSDEFN
    PSURLDEFN
    PS_AE_TEMPREC_VW
    PS_AE_TEMPLOCK_VW
    PS_DATA_FIND_BASE
    PS_MSG_CATLG_VW

    PeopleSoft Security Tables


    PSROLECLASS
    PSROLEUSER

    PeopleSoft Login Details and Authorization


    PSACCESSLOG

    PSACCESSPRFL
    PSCLOCK
    PSOPRDEFN

    PeopleSoft Audit Tables


    PSAUDIT
    PeopleSoft Version Details
    PSRELEASE
    PSSTATUS

    PeopleSoft Language Details


    PSLANGUAGES

    PeopleSoft Modules Listed


    PS_INSTALLATION
    PeopleSoft Process Type Details
    PS_PRCSDEFN
    PSPRCSLOCK
    PeopleSoft Process Status
    PSPRCSQUE
    PSPRCSRQST
    PS_CDM_LIST
    PS_CDM_AUTH
    PeopleSoft Report Node Details
    PS_CDM_DIST_NODE
    PS_CDM_DISTSTATUS
    PeopleSoft Batch Server Details
    PS_SERVERDEFN
    PSSERVERSTAT

    PeopleSoft RenServer Details


    PSREN
    PeopleSoft Translate Value Details
    PSXLATDEFN
    PSXLATITEM

    PeopleSoft Object Versions


    PSLOCK
    PSOPTIONS
    PSVERSION
     Activity definitions are stored
     Stores the application engine section definitions
     Stores the application engine step definitions
     Stores the messages of the AE programs
     Peoplecode programs stored
     Application engine sql
     Application engine program name
     Menu names
     Page names
     Stores Component definitions
     Stores component interface names
     Stores Business process definitions
     Stores Approval rule set definitions
     Stores channel definitions
     Changing the column value of active to 0 leads to disabling activities
     Filelayout stored
     File reference stored
     Index information stored
     Stores business interlink information
     Stores the index key information
     Contains info about mobilepages
     Refers to the activity object
     Related to Messages –  Message catalogs
     Stores Application Message definitions
     Contains field definitions
     This table holds the storage structure of the tables for db platforms
     This table hold the gateway url.
     This table holds the storage structure of the indexes for db platforms
     This table holds the information of all the peoplesoft records.
     This table holds the application packages definitions
     Contains Panel group definitions
     Contains the portal information
     Contains project definitions
     Detailed information of the portal objects
     Information about portal objects
     Information about portal objects
     Holds the query definitions
     Role definitions
     SQL object definitions are stored
     SQL object’s text are stored
     Contains stepnames with reference to the activity
     Contains the styles definitions
     Contains the stylesheet definitions
     Conatins Message subscription definitions
     Holds a single row provided by PS, which helps to view the toolbar
     Contains the treename
     Gives info abt the peoplesoft permission lists
     To see which URL’s are used as fileservers for the file attachments
     Tracks all temporary tablenames and their descriptions
     Tracks how many locks are currently in effect for a particulartemporary table
     Used as search record for the panel.  SHould always be empty.
     Contains text for all error messages and warnings.

     Provides the permission lists associated to each role


     Gives info abt the roles assigned to the Oprid’s

    Authorization
     Login and logout information of the users

     Contains the symbolic id,accessid/password details.


     Login fails if the table is empty
     This table holds the peoplesoft Oprid’s/passwords info with symbolic id.

     This table holds all the changes for panel/record modifications

     This table holds the application release details


     This table gives the peopletools information

     Contains 1 for the column INSTALLED against the columnLANGUAGE_CD.

     List the modules in the database

     Contains process type and process names


     Contains a single record, this gets updated when a process is submitted

     Holds the process rqst details should be in synch with psprcsrqst.Should be in synch with PSPRCSRQST
     This table holds the process submitted details
    Contains the process instance details.Should be in synch withPS_CDM_AUTH
     Contains the process instance details

     This table holds the report node information which contains the reportrepository details
     Contains the definition of report status

     Contains the server definitions


    Gives information about the batch server status

     Holds the portnumber details of a renserver configured domain

     Holds the translate fieldname and version number for caching


     Holds the translate fieldname and their values

     This table is used for version control


     This table is used to turn off or on the change control enabling feature
     This table holds the version number details

    You might also like