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 NameField TypeColumn TypeDescription
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
RECDESCRCharacter(30)VARCHAR2(30) NOT NULLRecord Description
RELLANGRECNAMECharacter(15)VARCHAR2(15) NOT NULLRelated Language Record Name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19