List of PeopleSoft SES Tables

There are certain scenarios in which you’d like to have a list of PeopleSoft SES tables handy. Some of these scenarios include:

1. PeopleSoft instance/database refresh – When copying a PeopleSoft instance or database, for example – production to test, you may want to exclude the SES tables so that SES server details and index definitions etc do not get overwritten.
2. To debug an issue, you may need to lookup a table for certain rows.

Anyway, here is the list of SES tables used in PeopleTools 8.53:

PSPTSFATTRDEL
PSPTSFCATDEL
PSPTSFSDDEL
PSPTSF_ATT_PROP
PSPTSF_CATPTSD
PSPTSF_CATPTSFL
PSPTSF_CATSESSD
PSPTSF_CAT_LANG
PSPTSF_CAT_SDL
PSPTSF_SD_SRACL
PSPTSF_ADD_PRMS
PSPTSF_ATTRS
PSPTSF_CATADVFD
PSPTSF_CATDSPFD
PSPTSF_CATFACET
PSPTSF_SD
PSPTSF_SD_ATTR
PSPTSF_SD_ATTRH
PSPTSF_SD_DCACL
PSPTSF_SD_DCATR
PSPTSF_SD_LANG
PSPTSF_SD_PNLGP
PSPTSF_SRCCAT
PSPTSF_SRCCATAT
PS_PTSF_AUDIT_SRCE
PS_PTSF_SBO
PS_PTSF_SBO_LANG
PS_PTSF_SRCH_ENGN
PS_PTSF_ATTRS
PS_PTSF_AUDIT_DEPO
PS_PTSF_CAT_ADVFLD
PS_PTSF_CAT_ATTRS
PS_PTSF_CAT_DSPFLD
PS_PTSF_CAT_FACETS
PS_PTSF_CAT_LANG
PS_PTSF_CAT_PSFTSD
PS_PTSF_CAT_SES_SD
PS_PTSF_CAT_SESSDL
PS_PTSF_CATCHLDFCT
PS_PTSF_CATPSFTSDL
PS_PTSF_DEPLOY_OBJ
PS_PTSF_DOC_TYPES
PS_PTSF_FEED_DATA
PS_PTSF_LOG_SDATA
PS_PTSF_NODE_ATR_L
PS_PTSF_NODE_ATTRS
PS_PTSF_PSFT_SDATR
PS_PTSF_SBO_ATTR
PS_PTSF_SBO_ATTR_H
PS_PTSF_SBO_DOCACL
PS_PTSF_SBO_DOCATR
PS_PTSF_SBO_PNLGRP
PS_PTSF_SBO_SCRACL
PS_PTSF_SCHED_STAT
PS_PTSF_SCHEDU_AET
PS_PTSF_SCHEDULE
PS_PTSF_SES_ATTR_L
PS_PTSF_SES_ATTRS
PS_PTSF_SES_FACTS
PS_PTSF_SES_SD_ATR
PS_PTSF_SRCHCAT
PS_PTSF_SRCHCATATR
PS_PTSF_STAT_ARCH
PS_PTSF_URLDEFN

If you see any missing or have any suggestions, do let us know in the comments section below.