Whitelist Tables
psLens controls which PeopleSoft tables can be queried through a whitelist table (CHG_PSLENS_WL). You need to whitelist every table that psLens reads.
Categories:
Whitelist Tables
psLens controls which PeopleSoft tables can be queried through a global whitelist table (CHG_PSLENS_WL). You need to whitelist every table that psLens reads. The full list of tables (organized by feature area) is documented in the Reference section.
This page contains the SQL inserts you run once during installation. After running them, restart psLens (or wait for the next whitelist cache refresh) and confirm the Settings > Database Connections page shows the database as fully connected with no missing-table warnings.
PeopleTools Tables Common to All Features
Run all of the inserts below. Each block matches a category in the Reference page. If you add new functionality to psLens that queries a new record, add it here too.
-- Whitelist record itself
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('CHG_PSLENS_WL');
-- Security tables
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSAUTHAS');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSAUTHBUSCOMP');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSAUTHITEM');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSAUTHPRCS');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSAUTHWS');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSCLASSDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSMENUITEM');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSOBJGROUP');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSOPRDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSOPROBJ');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSROLECLASS');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSROLEDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSROLEUSER');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SCRTY_ACC_GRP');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SCRTY_QUERY');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PTACM_ACCESSTBL');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPTSCRTY_ADS_A');
-- Metadata tables
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSBCDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSBCITEM');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSDBFIELD');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSDBFLDLABL');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSKEYDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSMENUDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSXFERITEM');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPNLDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPNLFIELD');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPNLGROUP');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPNLGRPDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPROJECTDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPROJECTITEM');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPRSMATTRVAL');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPRSMDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPRSMPERM');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPRSMSYSATTR');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPRSMSYSATTRVL');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSRECDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSRECFIELD');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPTSF_SD');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPTSF_SD_ATTR');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPTSF_SD_DCATR');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPTSF_SRCCAT');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPTSF_SRCCATAT');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSRECDDLPARM');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSIDXDDLPARM');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSSPCDDLPARM');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSDDLMODEL');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSDDLDEFPARMS');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSOPTIONSADDL');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSTBLSPCCAT');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSRECTBLSPC');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSFLDDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSFLDSEGDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSFLDFIELDDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSXLATITEM');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SQLSTMT_TBL');
-- Integration Broker tables
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSAPMSGPUBCON');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSAPMSGPUBHDR');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSAPMSGSUBCON');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSAPMSGDOMSTAT');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSAPMSGDSPSTAT');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSIBLOGHDR');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSIBRTNGDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSIBAPPLDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSIBAPPLOPR');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSIBAPPURI');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSIBAPPMETHOD');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSIBPARAM');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSIBBASEPARAM');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSIBTEMPLPARAM');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSIBBASETMPLPRM');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSIBAPPLSTATES');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSIBAPPLHDRPROP');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSMSGNODEDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSNODECONPROP');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSNODEURITEXT');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSNODESDOWN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSOPERATION');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSOPERATIONAC');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSOPERATIONURI');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSOPRHDLR');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSOPRVERDFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSOPRVERDFNPARM');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSQUEUEDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSQUEUEPART');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSRTNGDFNPARM');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSRTNGDFNPROP');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSSERVICE');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSSERVICEOPR');
-- Process Scheduler tables
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PRCSDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PRCSDEFNGRP');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PRCSDEFNPNL');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PRCSJOBDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PRCSJOBGRP');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PRCSJOBITEM');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PRCSJOBPNL');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PRCSJOBMESSAGE');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PRCSMUTUALEXCL');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PRCSRECUR');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PRCSRECURDATE');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PRCSRECUREXEMPT');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPRCSRQST');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PRCSDEFNNOTIFY');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PRCSDEFNCNTDIST');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PRCSJOBNOTIFY');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PRCSJOBCNTDIST');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SERVERDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSSERVERSTAT');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SERVERCATEGORY');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SERVERCLASS');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SERVERNOTIFY');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SERVEROPRTN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('DAEMONGROUP');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('DAEMONGROUP_VW');
-- Developer tables
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSAEAPPLDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSAEAPPLSTATE');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSAEAPPLTEMPTBL');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSAESECTDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSAESTEPDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSAESTMTDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSCONTDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSCONTENT');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSMSGATTR');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSMSGCATDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSMSGDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSMSGFLDOVR');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSMSGPARTS');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSMSGREC');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSMSGSETDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSMSGVER');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPACKAGEDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPCMNAME');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPCMPROG');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPCMTXT');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSQRYDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSQRYFIELD');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSQRYRECORD');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSQRYSTATS');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSQRYEXECLOG');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSQRYSELECT');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSQRYCRITERIA');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSQRYEXPR');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSQRYBIND');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSSQLDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSSQLTEXTDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSTREEDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSTREENODE');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSURLDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PT_URL_PROPS');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSXPRPTDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSXPDATASRC');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSXPTMPLDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSXPTMPLFILEDEF');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSXPRPTVIEWER');
-- Audit & user profile tables
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPTLOGINAUDIT');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPRUFDEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSUSEREMAIL');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSOPTIONS');
Campus Solutions Specific Tables
Only run these in a Campus Solutions database. If you run them in a non-CS database, you will get errors about missing tables.
-- Campus Solutions row-level security tables
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('ES_SECURITY_DTL');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('ES_SECURITY_TBL');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('OPER_ROLE_DEFN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('OPR_DEFAULT_TBL');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('OPR_DEF_TBL_CS');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('OPR_GRP_3C_TBL');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('RUNCNT_USERPROF');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('RUN_CNTL_HR');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('RUN_CNTL_SECVWU');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SAA_SCRTY_AARPT');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SAD_TEST_SCTY');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SCCPU_SRTY_TBL');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SCC_GE_SCRTY');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SCC_NTF_OPR_CON');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SCC_SCRTY_RLCAT');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SCC_SCRT_RUNCTL');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SCC_SL_TRN_SCTY');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SCC_STY_TBL_CMP');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SCC_VLTCNV_RCTL');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SCRTY_ADM_ACTN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SCRTY_APPL_CTR');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SCRTY_PROG_ACTN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SCRTY_RECR_CTR');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SCRTY_TBL_ACAD');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SCRTY_TBL_CAR');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SCRTY_TBL_INST');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SCRTY_TBL_MLSTN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SCRTY_TBL_PLAN');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SCRTY_TBL_PROG');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SCRTY_TBL_SRVC');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SCRTY_TBL_STGP');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SCRTY_TSCRPT');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SEV_PRG_SP_SCTY');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SEV_SCHLCD_SCTY');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SSR_AIR_OPRSCTY');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SSR_ANID_SCRTY');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SSR_APT_ACT_SCR');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SSR_SCRTY_EXAM');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SSR_SCRTY_GRSTA');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('SSR_SCRTY_TSRPT');