Whitelist Tables

Categories:
Tags:

Whitelist Tables

SWS controls which PeopleSoft tables can be queried through a whitelist. 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.

Note: You may have configured the SWS client to use a different Permission List (CLASSID) other than CHG_PSOFTLENS_API_USER. If so, replace that value in every statement below.

Note: The LASTUPDDTTM column uses Oracle’s SYSDATE function. On SQL Server, replace SYSDATE with GETDATE().

Allow access to the whitelist record itself

C_SWS_REC_WL is the SWS-provided record psLens reads to discover the active whitelist. Granting access to it is required before any other whitelisted table can be queried.

INSERT INTO PS_C_SWS_COMP_WL (COMPNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID)
VALUES ('C_SWS_REC_WL', 'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');

Whitelist every PeopleSoft table psLens queries

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.

-- Security tables

INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSAUTHAS',         'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSAUTHBUSCOMP',    'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSAUTHITEM',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSAUTHPRCS',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSAUTHWS',         'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSCLASSDEFN',      'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSMENUITEM',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSOPRDEFN',        'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSROLECLASS',      'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSROLEDEFN',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSROLEUSER',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('SCRTY_ACC_GRP',    'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('SCRTY_QUERY',      'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PTACM_ACCESSTBL',  'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSPTSCRTY_ADS_A',  'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');

-- Metadata tables
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSBCDEFN',         'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSBCITEM',         'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSDBFIELD',        'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSDBFLDLABL',      'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSKEYDEFN',        'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSMENUDEFN',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSXFERITEM',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSPNLDEFN',        'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSPNLFIELD',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSPNLGROUP',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSPNLGRPDEFN',     'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSPROJECTDEFN',    'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSPROJECTITEM',    'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSPRSMATTRVAL',    'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSPRSMDEFN',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSPRSMPERM',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSPRSMSYSATTR',    'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSPRSMSYSATTRVL',  'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSRECDEFN',        'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSRECFIELD',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSXLATITEM',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');

-- Integration Broker tables
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSAPMSGPUBCON',    'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSAPMSGPUBHDR',    'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSAPMSGSUBCON',    'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSAPMSGDOMSTAT',   'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSAPMSGDSPSTAT',   'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSIBLOGHDR',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSIBRTNGDEFN',     'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSMSGNODEDEFN',    'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSNODECONPROP',    'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSNODEURITEXT',    'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSNODESDOWN',      'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSOPERATION',      'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSOPERATIONAC',    'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSOPERATIONURI',   'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSOPRHDLR',        'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSOPRVERDFN',      'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSOPRVERDFNPARM',  'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSQUEUEDEFN',      'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSQUEUEPART',      'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSRTNGDFNPARM',    'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSRTNGDFNPROP',    'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSSERVICE',        'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSSERVICEOPR',     'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');

-- Process Scheduler tables
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PRCSDEFN',         'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PRCSDEFNGRP',      'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PRCSDEFNPNL',      'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PRCSJOBDEFN',      'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PRCSJOBGRP',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PRCSJOBITEM',      'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PRCSJOBPNL',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PRCSMUTUALEXCL',   'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PRCSRECUR',        'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PRCSRECURDATE',    'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PRCSRECUREXEMPT',  'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSPRCSRQST',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PRCSDEFNNOTIFY',  'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PRCSDEFNCNTDIST', 'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PRCSJOBNOTIFY',   'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PRCSJOBCNTDIST',  'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('SERVERDEFN',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSSERVERSTAT',     'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('SERVERCATEGORY',   'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('SERVERCLASS',      'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('SERVERNOTIFY',     'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('SERVEROPRTN',      'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('DAEMONGROUP',      'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('DAEMONGROUP_VW',   'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');

-- Developer tables
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSAEAPPLDEFN',     'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSAEAPPLSTATE',    'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSAEAPPLTEMPTBL',  'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSAESECTDEFN',     'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSAESTEPDEFN',     'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSAESTMTDEFN',     'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSCONTDEFN',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSCONTENT',        'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSMSGATTR',        'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSMSGCATDEFN',     'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSMSGDEFN',        'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSMSGFLDOVR',      'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSMSGPARTS',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSMSGREC',         'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSMSGSETDEFN',     'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSMSGVER',         'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSPACKAGEDEFN',    'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSPCMNAME',        'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSPCMPROG',        'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSPCMTXT',         'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSQRYDEFN',        'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSQRYFIELD',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSQRYRECORD',      'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSQRYSTATS',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSQRYEXECLOG',     'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSSQLDEFN',        'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSSQLTEXTDEFN',    'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSTREEDEFN',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSTREENODE',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSURLDEFN',        'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PT_URL_PROPS',     'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');

-- Audit & user profile tables
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSPTLOGINAUDIT',   'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSPRUFDEFN',       'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSUSEREMAIL',      'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');
INSERT INTO PS_C_SWS_REC_WL (RECNAME, CLASSID, LASTUPDDTTM, LASTUPDOPRID) VALUES ('PSOPTIONS',        'CHG_PSOFTLENS_API_USER', SYSDATE, 'psLens installation');

COMMIT;

Adding new tables later

When psLens gains a feature that queries a new PeopleSoft table, two things have to happen:

  1. Add the table to the matching block above, then re-run that single INSERT against each PeopleSoft database.
  2. Document the table on the Reference page so the broader documentation stays in sync.