Report Manager tables
PS_CDM_LIST
PS_CDM_AUTH
PS_CDM_TEXT
PS_CDM_FILE_LIST
PS_CDM_TRANSFER
PS_CDM_TRNFR_RJCT
PS_CDM_LIST_ARCH
Process Request tables
PSPRCSRQST
PSPRCSQUE
PSPRCSCHLDINFO
PSPRCSPARMS
PSPRCSRQSTTEXT
PSPRCSRQSTXFER
PS_PRCSRQSTDIST
PS_MESSAGE_LOG
PS_MESSAGE_LOGPARM
PSPRCSRQSTFILE
PSPRCSRQSTMETA
PSPRCSRQSTSTRNG
PSPRCSRQSTTIME
PS_PRCSRQSTNOTIFY
Application Messaging queue data
-- core tables:
PSAPMSGPUBHDR
PSAPMSGPUBDATA
PSAPMSGPUBCON
PSAPMSGSUBCON
PSAPMSGPUBERR
PSAPMSGPUBERRP
PSAPMSGPUBCERR
PSAPMSGPUBCERRP
PSAPMSGSUBCERR
PSAPMSGSUBCERRP
PSAPMSGPCONDATA
PSAPMSGSCONDATA
PSIBERR
PSIBERRP
PSIBDEBUGLOG
PSAPMSGIBATTR
PSIBAEATTR
PSIBRELMSGSEQ
PSIBRELMSGHDR
PSIBRELMSGDATA
PSAPMSGDOMSTAT
PSAPMSGDSPSTAT
-- synchronous core tables:
PSIBLOGHDR
PSIBLOGDATA
PSIBLOGERR
PSIBLOGERRP
PSIBLOGIBINFO
-- archive tables:
PSAPMSGARCHPH
PSAPMSGARCHPD
PSAPMSGARCHPC
PSAPMSGARCHSC
PSAPMSGARCHPT
PSAPMSGARCHST
PSIBLOGHDRARCH
PSIBLOGDATAARCH
PSIBLOGIBINFOAR
-- lock tables:
PSIBFCLOCK
PSIBADSLOCK
-- node tables:
PSNODESDOWN
PeopleTools security tables
-- ACCESS PROFILES
PSACCESSPROFILE
PSACCESSPRFL
-- USERS
PSOPRDEFN
PSOPRDEFN_LANG
PSOPRALIAS
PSROLEUSER
PSUSERATTR
PSUSEREMAIL
PSUSERPRSNLOPTN
PS_ROLEXLATOPR
PS_RTE_CNTL_RUSER
-- ROLES
PSROLEDEFN
PSROLEDEFNLANG
PSROLECANGRANT
PSROLECLASS
PS_PTROLENAMEALIAS
-- PERMISSION LISTS
PSCLASSDEFN
PSCLASSDEFN_LNG
PSAUTHSIGNON
PSAUTHITEM
PSAUTHPRCS
PSAUTHCUBE
PSAUTHMP
PSAUTHBUSCOMP
PSAUTHQUEUEMON
PSPRCSPRFL
PS_SCRTY_QUERY
PS_SCRTY_ACC_GRP
PSPTSCRTY_ADS_A
PSAUTHOPTN
PSAUTHWS
PSPTSCRTY_ADS_P
PS_SCRTY_SRCHGRP
PS_MC_OPR_SECURITY
PS_MC_OPRID
PS_PTCLASSIDALIAS
-- DEFINITION SECURITY
PSPTDEFSEC_GRPS
PSPTDEFSEC_GRP
PSPTDEFSECINRL
PS_APP_DES_OBJ_CST
PSOPROBJ
-- PERSONALIZATIONS
PSUSEROPTNDEFN
PSUSEROPTNLANG
PSOPTNCATGRPLNG
PSOPTNCATGRPTBL
PSOPTNCATTBL
PSOPTNCATLANG
-- SECURITY OPTIONS
PSSECOPTIONS
PS_PTALIASOPTIONS
-- SECURITY LINKS
PSUSEROTHER
PSUSEROTHER_L
PSUSERSELFOTHER
PSUSERSELFOTH_L
PSROLEOTHER
PSROLEOTHER_LNG
PSPERMLISTOTHER
PSPERMLISTOTH_L
-- USER ID TYPES
PSOPRALIASTYPE
PSOPRALIASFIELD
-- DELETE USER BYPASS TABLE
PS_BYPASS_TABLE
-- FORGOT EMAIL TEXT
PSPSWDEMAIL
PSPSWDEMAILLANG
-- PASSWORD HINTS
PSPSWDHINT
PSPSWDHINT_LANG
-- SIGNON PEOPLECODE
PSSIGNONPPC
-- DIRECTORY
PSDSDIR
PSDSSRVR
DSCONNECTID
PSDSEXT_INSTALL
PSDSSECMAPMAIN
PSDSSECMAPSRVR
DSUSRPRFLMAP
PSDSUSERPRFL
PSDSSECROLERULE
DSSRCH_SBR
DSSRCHATTR
DSSECFILTER
PT_WF_NOT_DSCFG
Table PSINDEXDEFN - Index Definition
Row in PSINDEXDEFN - Index Definition
RECNAME - Record (Table) Name: TL_IPT2
INDEXID - Index Identifier: Z
INDEXTYPE - Index Type: 4
UNIQUEFLAG - Index Unique: 0
CLUSTERFLAG - Index Cluster Flag: 0
ACTIVEFLAG - Index Active: 1
CUSTKEYORDER - Custom Key Order: 1
KEYCOUNT - Number of Keys: 1
DDLCOUNT - Number of DDL Override Parms: 0
PLATFORM_SBS - SQLBase: 0
PLATFORM_DB2 - DB2/MVS: 1
PLATFORM_ORA - Oracle: 1
PLATFORM_INF - Informix: 0
PLATFORM_DBX - DB2 for Unix: 0
PLATFORM_ALB - AllBase: 0
PLATFORM_SYB - Sybase Sql Server: 0
PLATFORM_MSS - MicroSoft Sql Server: 1
PLATFORM_DB4 - DB2/400: 0
IDXCOMMENTS - INDEX COMMENTS: Index on emplid
Table PSIDXDDLPARM - Index DDL Parameters
(No Rows)
Table PSKEYDEFN - Key in Index Definition
Row in PSKEYDEFN - Key in Index Definition
RECNAME - Record (Table) Name: TL_IPT2
INDEXID - Index Identifier: Z
KEYPOSN - Key Position: 1
FIELDNAME - Field Name: EMPLID
ASCDESC - Ascending/Descending: 1
Set Up HCM Common Definitions Text Catalog and Notepad > Maintain Text Catalog
select * from ps_HR_SSTEXT_MSGID order by 1,2,3,4,5,6;
OBJECTOWNERID, HR_SSTEXT_SUB_ID, TEXT_ID, HR_SSTEXT_USAGE, SYSTEM_DATA_FLG, DESCR254_MIXED
select * from ps_HR_SSTEXT_TEXT order by 1,2,3,4 desc,5,6,7,8;
select -- p1.OBJECTVALUE1, p1.OBJECTVALUE2,p1.OBJECTVALUE3, p1.OBJECTVALUE4,p1.OBJECTVALUE5,OBJECTID6, OBJECTVALUE6,'~`~`~`', PCTEXT,'~`~`~`',OBJECTID1,OBJECTID2,OBJECTID3,OBJECTID4,OBJECTID5,
msg.*,
p1.OBJECTID1, p1.OBJECTVALUE1, p1.OBJECTID2, p1.OBJECTVALUE2, p1.OBJECTID3, p1.OBJECTVALUE3, p1.OBJECTID4, p1.OBJECTVALUE4, OBJECTID5, OBJECTVALUE5, OBJECTID6, OBJECTVALUE6, OBJECTID7, OBJECTVALUE7, p1.PROGSEQ, HASH_SIGNATURE,
'~`~`~`',PCTEXT,'~`~`~`'
from PSMSGCATDEFN msg left outer join pspcmtxt p1
on p1.pctext like '%' || MESSAGE_SET_NBR || ', ' || MESSAGE_NBR || ',%'
where (MESSAGE_SET_NBR =1000 and MESSAGE_NBR in (1573,1574))
select * from PSMSGCATDEFN ;
select * from PSMSGSETDEFN where message_set_nbr in (1000,18031,18137,2000,2001,2002,2003,3000,3001,4002,6568) order by 1,2,3,4;
select * from PSMSGCATDEFN where (MESSAGE_SET_NBR =1000 and MESSAGE_NBR in (1573,1574);
select * from PSMSGCATLANG where message_set_nbr in (1000,18031,18137,2000,2001,2002,2003,3000,3001,4002,6568) order by 1,2,3,4;;
select * from PSMSGSETLANG where message_set_nbr in (1000,18031,18137,2000,2001,2002,2003,3000,3001,4002,6568) order by 1,2,3,4;;
select * from PSMGRSHADOW where message_set_nbr in (1000,18031,18137,2000,2001,2002,2003,3000,3001,4002,6568) order by 1,2,3,4;;;
select * from PSMSGCATLANG where (MESSAGE_SET_NBR =1000 and MESSAGE_NBR in (1573,1574)
