TR_DATA_REC_VW

index back

Tables with column

This view will select the records from the PeopleTools data dictionary that contain the column that the user is searching for
SELECT DISTINCT RECNAME ,RECDESCR , RELLANGRECNAME FROM PSRECDEFN WHERE RELLANGRECNAME <> ' ' AND RECTYPE = 0 AND RECNAME NOT IN ( SELECT RECNAME FROM PSRECDEFN WHERE RECNAME LIKE 'PS%' AND RECNAME NOT IN ('PSLOCALEDEFN','PSUSEROPTNDEFN','PSLOCALEDEFN','PSOPRALIASTYPE','PSOPTNCATGRPTBL','PSOPTNCATTBL','PSPACKAGEDEFN','PSPRSMATTR','PSRF_FLIST_TBL','PSRF_FVIEW_TBL','PSPMCONTEXTDEFN','PSPMEVENTDEFN' ,'PSPMEVENTSET','PSPMMETRICDEFN','PSPMMETRICVALUE','PSPMTRANSDEFN' ,'PSPMTRANSSET' ,'PSTIMEZONEDEFN','PSROLEDEFN','PSDSTTIME','PSXPRPTCAT','PSXPTMPLTYPE','PSCHARSETS','PSSEC_PPC_FUNC')) AND RECNAME NOT IN ('ACCESS_GRP_TBL', 'APPR_RULE_HDR','PRCSDEFN', 'PRCSJOBDEFN', 'PRCSRECUR', 'PRCSTYPEDEFN','STRINGS_TBL', 'TREE_LEVEL_TBL', 'TREE_NODE_TBL' )

PeopleSoft Field Name Field Type Column Type Description
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description
RELLANGRECNAME Character(15) VARCHAR2(15) NOT NULL Related Language Record Name
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19