PS Refresh Tables - rough list

refreshtables.sql

-- System Base Tables
ps.psdbowner
sysadm.psstatus
sysadm.psstatus
sysadm.psoprdefn
sysadm.psaccessprfl
sysadm.psaccessprofile
sysadm.psoptions

-- Branding
sysadm.psoptions
sysadm.psoptionsaddl
sysadm.ps_ptbr_lteltat
sysadm.ps_ptbr_ltattr_cla

-- Portal Options
sysadm.psprdmdefn

-- Trusted Nodes
sysadm.pstrustnodes

-- User Account Maintenance
sysadm.psoprdefn

-- Favorites
sysadm.psprufdefn
sysadm.ps_pt_portal_mru
sysadm.ps_pt_portal_pinto
sysadm.psprufdefn
sysadm.ps_pt_portal_mru
sysadm.ps_pt_portal_pinto

-- Nodes
sysadm.psmsgnodedefn
sysadm.psnodeuritext
sysadm.psibrtngdefn
sysadm.psibrtngsubdefn
sysadm.psrtngdfnparm

-- Node URI
sysadm.psnodeuritext

-- Scheduler
sysadm.ps_cdm_file_ext
sysadm.psserverstat
sysadm.psprcsrqst
sysadm.psprcsque
sysadm.psprcsruncntls

-- Report Node
sysadm.ps_cdm_dist_node
sysadm.ps_serverdefn

-- IB Gateways
sysadm.psgateway
sysadm.psiblburls
sysadm.psibgatewayurls
sysadm.psibsvcsetup
sysadm.psapmsgdspstat

-- Web Profile
sysadm.pswebprofnvp
sysadm.pswebprofprop

-- Workflow Configuration
sysadm.psoprdefn
sysadm.ps_rolexlatopr

-- URL definitions
sysadm.psurldefn

-- Search Framework
sysadm.ps_ptsf_optn_saved

-- DMW File Locations
sysadm.psprjrepository

-- Scramble Data
-- This is app specific PII, emails, etc

-- Truncates
-- $PS_HOME\scripts\appmsgpurgeall.dms
sysadm.psibfclock
sysadm.psibadslock
sysadm.pspmsysdefn
sysadm.pspmagent
sysadm.PSPTPNEVTCLT