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 uses a global whitelist table (CHG_PSLENS_WL) to control which PeopleSoft tables clients can query. You must whitelist every table that psLens reads. The Reference section documents the complete table list by feature area.
This page provides the SQL insert statements to run during installation. After running the statements, restart psLens or wait for cache refresh. Check the Settings > Database Connections page. Make sure the database status shows 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 (optional: CHG_PSLENS_WL is always readable by the framework)
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 ('PSAUTHSIGNON');
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');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSCHGCTLDEF');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSCHGCTLLOCK');
-- Audit & user profile tables
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSPTLOGINAUDIT');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSACCESSLOG');
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 ('PSOPRALIAS');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSOPTIONS');
-- Applied Maintenance tables
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('MAINTENANCE_LOG');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSRELEASE');
INSERT INTO PS_CHG_PSLENS_WL (RECNAME) VALUES ('PSSTATUS');
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');