Scribd Logo
Upload

Welcome to Scribd!

  • 52 views

    Projects: Record Types

    Uploaded by

    ealondono
    This document lists the main PeopleTools tables used to define and store various PeopleSoft application configuration objects including projects, records, pages, components, security definitions, and more. It also includes tables for process scheduler, portal, change control, workflow, application engine, SQL definitions, file layouts, and timings. There are over 50 tables referenced overall that cover the different configuration areas within PeopleSoft applications.

    Copyright:

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

    Projects: Record Types

    Uploaded by

    ealondono
    52 views3 pages
    This document lists the main PeopleTools tables used to define and store various PeopleSoft application configuration objects including projects, records, pages, components, security definitions, and more. It also includes tables for process scheduler, portal, change control, workflow, application engine, SQL definitions, file layouts, and timings. There are over 50 tables referenced overall that cover the different configuration areas within PeopleSoft applications.

    Original Description:

    Tablas peopletools

    Original Title

    PeopleTools Tables

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document lists the main PeopleTools tables used to define and store various PeopleSoft application configuration objects including projects, records, pages, components, security definitions, and more. It also includes tables for process scheduler, portal, change control, workflow, application engine, SQL definitions, file layouts, and timings. There are over 50 tables referenced overall that cover the different configuration areas within PeopleSoft applications.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    52 views3 pages

    Projects: Record Types

    Uploaded by

    ealondono
    This document lists the main PeopleTools tables used to define and store various PeopleSoft application configuration objects including projects, records, pages, components, security definitions, and more. It also includes tables for process scheduler, portal, change control, workflow, application engine, SQL definitions, file layouts, and timings. There are over 50 tables referenced overall that cover the different configuration areas within PeopleSoft applications.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 3

    Projects

    PSPROJECTDEFN Project header table

    PSPROJECTITEM Definitions in the project

    Fields

    PSDBFIELD Fields in the system

    PSXLATITEM Translate Values

    Records

    PSRECDEFN Record header table (record types)

    PSRECFIELD Fields in the record (subrecords not expanded)

    PSRECFIELDALL Fields in the record (subrecords expanded)

    PSKEYDEFN Indexes

    PSTBLSPCCAT Tablespaces

    PSRECTBLSPC Records tablespace assignments

    Pages
    (Note: Pages still have the name panels in the PeopleTools table names)

    PSPNLDEFN Page header table

    PSPNLFIELD Page controls (field types/FIELDTYPE)

    PSPNLHTMLAREA Static HTML Areas on Pages

    PSPNLCNTRLDATA stores additional attributes for Page controls

    PSPNLFIELDEXT stores additional attributes for Page controls

    PSPTPNLRTEDITOR new PeopleTools 8.50 table that stores attributes relating to the
    rich-text editor for long character fields.

    Components
    (Note: Components still have the name panel group in the PeopleTools table names)

    PSPNLGRPDEFN Component header table

    PSPNLGROUP Pages in the components

    Component Interface

    PSBCDEFN header record; one row for each component interface

    PSBCITEM one row for each property

    Menus

    PSMENUDEFN Menu header table

    PSMENUITEM Items (components) on the menu

    Security

    PSCLASSDEFN Permission List header table

    PSAUTHITEM Menu items granted security by permission lists

    PSROLEDEFN Role header table

    PSROLECLASS Permission Lists in roles

    PSOPRDEFN User ID header table

    PSROLEUSER Roles granted to users

    PSAUTHBUSCOMP Access to Component Interfaces

    Process Scheduler

    PS_PRCSDEFN Process Definition Header

    PS_PRCSDEFNGRP Process Group

    PS_PRCSDEFNPNL Component

    PS_PRCSJOBDEFN Job Header

    PSPRCSRQST Process Request Instances

    PS_PRCSJOBITEM Job Processes

    Portal

    PSPRSMDEFN Content References and Folders

    PSPRUHTABPGLT Portal User HP Tab Pagelet

    PSPRUHDEFN Homepage definition (from here)

    PSPRUHTAB Homepage Tab (from here)

    PSWEBPROFNVP Web Profile Settings

    Change Control

    PSCHGCTLHIST shows history of locked definitions with project name, incident, and
    description
    PSCHGCTLLOCK shows definitions that are currently locked

    Application Engine

    PSAEAPPLDEFN header record; 1 row per app engine

    PSAEAPPLSTATE state records assigned to app engines

    PSAEAPPLTEMPTBL temp tables assigned to app engines

    PSAESECTDEFN sections

    PSAESTEPDEFN steps

    PSAESTEPMSGDEFN

    PSAESTMTDEFN actions (action types)

    List Log Messages


    HTML Definitions

    PSCONTDEFN header record; last update time, etc.

    PSCONTENT stores actual text in the HTML definition

    SQL Definitions

    PSSQLDEFN header record; last update time, etc.

    PSSQLTEXTDEFN stores actual text in the SQL definition

    File Layout Definitions

    PSFLDDEFN header record; last update time, etc.

    PSFLDSEGDEFN stores the segments for each layout

    PSFLDFIELDDEFN stores the fields for each layout

    Workflow
    (thanks to jaspersee the comments)

    APPR_RULE_DETL Approval Rule Defn Details

    APPR_RULE_FIELD Approval Rule Defn Route Cntl

    APPR_RULE_AMT Approval Rule Amounts

    RTE_CNTL_LN Route Control Profile Line

    RTE_CNTL_RUSER RoleUser Route Cntl Profiles

    RTE_CNTL_TYPE Route Control Type

    RTE_CNTL_HDR Routing Control Type

    PSWORKLIST list of work items for each user

    PS_WF_INSTSTATUS description of the status

    Timings
    (thanks to PeopleSoft Tipster see his blog)

    BAT_TIMINGS_LOG

    BAT_TIMINGS_DTL

    BAT_TIMINGS_FN

    You might also like