# Whitelist Tables

LLMS index: [llms.txt](/llms.txt)

---

## 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](/docs/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.

```sql
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](/docs/reference/) page. If you add new functionality to psLens that queries a new record, add it here too.

```sql
-- 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](/docs/reference/) page so the broader documentation stays in sync.