TR_DATA_REC_VW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description
3 RELLANGRECNAME Character(15) VARCHAR2(15) NOT NULL Related Language Record Name