List of Delivered PeopleTools Table Names

-- RECORDS AND INDEXES
PSRECDEFN;
PSRECDEFNLANG;
PSRECFIELD;
PSINDEXDEFN;
PSKEYDEFN;
PSDDLMODEL;
PSDDLDEFPARMS;
PSSPCDDLPARM;
PSRECDDLPARM;
PSIDXDDLPARM;
PSRECFIELDDB;
PSRECTBLSPC;

-- FIELDS

PSDBFIELD;
PSDBFIELDLANG;
PSDBFLDLABL;
PSDBFLDLABLLANG;


-- FIELD FORMATS

PSFMTDEFN;
PSFMTITEM;
-- TRANSLATES

PSXLATDEFN;
PSXLATITEM;
PSXLATITEMLANG;
-- PAGES
PSPNLDEFN;
PSPNLFIELD;
PSPNLTREECTRL;
PSPNLHTMLAREA;
PSPNLCNTRLDATA;
PSPNLBTNDATA;
PSPNLDEFNLANG;
PSPNLFIELDLANG;
PSPNLHTMLLANG;
PSPNLBTNLANG;
PSPNLACTIVEX;

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

-- PANEL GROUPS
PSPNLGRPDEFN;
PSPNLGDEFNLANG;
PSPNLGROUP;
PSPNLGROUPLANG;

-- PEOPLECODE
PSPCMPROG;
PSPCMNAME;

-- QUERIES
PSQRYDEFN;
PSQRYDEFNLANG;
PSQRYBIND;
PSQRYBINDLANG;
PSQRYCRITERIA;
PSQRYEXPR;
PSQRYFIELD;
PSQRYFIELDLANG;
PSQRYFLAGS;
PSQRYLINK;
PSQRYRECORD;
PSQRYSELECT;
-- TREE STRUCTURES

PSTREESTRCT;
PSTREESTRCTLANG;

-- TREES
PSTREEDEFN;
PSTREEDEFNLANG;
PSTREEBRANCH;
PSTREELEAF;
PSTREELEVEL
PSTREENODE;
PSTREEPROMPT;

PSTREESELCTL;

PSTREESELNUM;

PSTREESELECT01;

PSTREESELECT02;

PSTREESELECT03;

PSTREESELECT04;

PSTREESELECT05;

PSTREESELECT06;

PSTREESELECT07;

PSTREESELECT08;

PSTREESELECT09;

PSTREESELECT10;

PSTREESELECT11;

PSTREESELECT12;

PSTREESELECT13;

PSTREESELECT14;

PSTREESELECT15;

PSTREESELECT16;

PSTREESELECT17;

PSTREESELECT18;

PSTREESELECT19;

PSTREESELECT20;

PSTREESELECT21;

PSTREESELECT22;

PSTREESELECT23;

PSTREESELECT24;

PSTREESELECT25;

PSTREESELECT26;

PSTREESELECT27;

PSTREESELECT28;

PSTREESELECT29;

PSTREESELECT30;



-- ACCESS GROUPS

ACCESS_GRP_TBL;

ACCESS_GRP_LANG;



-- COLORS

PSCOLORDEFN;



-- STYLES

PSSTYLEDEFN;

PSSTYLEDEFNLANG;



-- BUSINESS PROCESSES

PSBUSPROCDEFN;

PSBUSPROCITEM;

PSBUSPROCLANG;

PSBUSPROCSEC;

PSBUSPRIMG;

PSBUSPITEMIMG;

PSBUSPITEMLANG;

PSBUSPRIMGLANG;



-- ACTIVITIES

PSACTIVITYDEFN;

PSACTIVITYLANG;

PSACTIVIMG;

PSACTIVIMGLANG;

PSSTEPDEFN;

PSEVENTDEFN;

PSEVENTROUTE;

PSMSGAGTDEFN;

PSMAPEXPR;

PSMAPFIELD;

PSMAPLEVEL;

PSMAPRECFIELD;

PSMAPROLEBIND;

PSMAPROLENAME;



-- PROCESS DEFINITIONS

PRCSDEFN;

PRCSDEFNLANG;

PRCSDEFNGRP;

PRCSDEFNPNL;

PRCSDEFNXFER;

PRCSDEFNNOTIFY;

PRCSDEFNCNTDIST;

PRCSDEFNMESSAGE;

PRCSDEFNMETA;

PS_PRCSDEFNURL;

PS_PRCSDEFNURL_LNG;

PS_PRCSDEFNURLKEY;

-- PROCESS TYPES

PS_PRCSTYPEDEFN;

PS_PRCSTYPEDEFNLNG;

PS_PRCSTYPEMETA;



-- PROCESS JOBS

PRCSJOBDEFN;

PRCSJOBDEFNLANG;

PRCSJOBGRP;

PRCSJOBITEM;

PRCSJOBPNL;

PS_PRCSJOBNOTIFY;

PS_PRCSJOBCNTDIST;

PS_PRCSJOBMESSAGE;

PS_PRCSSEQUENCE;

PS_PRCSOUTPUTLIST;

PS_PRCSOUTDESTTYPE;

PS_PRCSSYSTEM;

PS_PRCSPURGELIST;

PS_PRCS_CAT_TBL;

PS_PRCS_CAT_LG_TBL;





-- SQL

PSSQLDEFN;

PSSQLDESCR;

PSSQLLANG;

PSSQLTEXTDEFN;



-- FILE LAYOUT DEFINITIONS

PSFLDDEFN;

PSFLDFIELDDEFN;

PSFLDSEGDEFN;





-- APP ENGINE PROGRAMS

PSAEAPPLDEFN;

PSAEAPPLLANG;

PSAEAPPLSTATE;

PSAEAPPLTEMPTBL;



-- APP ENGINE SECTIONS

PSAESECTDEFN;

PSAESECTDTLDEFN;

PSAESTEPDEFN;

PSAESTEPMSGDEFN;

PSAESTMTDEFN;

PS_AEINSTANCENBR;

PS_AELOCKMGR;



-- MESSAGE NODES

PSMSGNODEDEFN;

PSNODEDEFNLANG;

PSCONNECTSTRING;

PSNODEURITEXT;

PSNODECONPROP;

PSNODCONPRPLANG;

PSNODEPROP;

PSNODEPROPLANG;

PSNODESDOWN;

PSTRUSTNODES;





-- MESSAGE CHANNELS

PSCHNLDEFN;

PSCHNLDEFNLANG;

PSCHNLNODE;

PSSUBCHNL;



-- MESSAGE DEFINITIONS

PSMSGDEFN;

PSMSGDEFNLANG;

PSMSGFLDOVR;

PSMSGREC;

PSMSGVER;



-- APPROVAL RULE SETS

APPR_HDR_LNG;

APPR_RULE_AMT;

APPR_RULE_DETL;

APPR_RULE_FIELD;

APPR_RULE_HDR;

APPR_RULE_LN;

APPR_RULE_QTY;

APPR_RULE_ROLE;

PSVAITEM;

PSVAITEMIMG;

PSVAITEMLANG;



-- IMAGE AND HTMLCATALOG-- CONTENT

PSCONTDEFN;

PSCONTDEFNLANG;

PSCONTENT;
PSCONTENTLANG;

Comments

Post a Comment

Popular posts from this blog

Peoplesoft SFTP

How to find the Java Version being used by WebLogic

Peoplesoft Error: All Processing Suspended: Restart OPRID=PS, RUNID=RUN01, PI=5000(108,503)