TR_DATA_REC_VW

Platform

View Text

Default

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','P SPACKAGEDEFN','PSPRSMATTR','PSRF_FLIST_TBL','PSRF_FVIEW_TBL','PSPMCONTEXTDEFN','PSPMEVENTDEFN' ,'PSPMEVENTSET','PSPMMETRICDEFN','PSPMMETRICVALUE','PSPMTRANSDEFN' ,'PSPMTRANSSET' ,'PSTIMEZONE','PSROLEDEFN','PSDSTTIME','PSXPRPTCAT','PSXPTMPLTYPE')) 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	Description
RECNAME	Record (Table) Name
RECDESCR	Record Description
RELLANGRECNAME	Related Language Record Name

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010