TS_RECORD_VW

index back

Base and Non-Base Records

Base and Non-Base Searchable Records
SELECT A.RECNAME, B.RECDESCR, A.RELLANGRECNAME, C.RECDESCR, A.TS_OBJECT_TYPE FROM PS_TS_RECORDS A, PSRECDEFN B, PSRECDEFN C WHERE A.RECNAME = B.RECNAME AND A.RELLANGRECNAME = C.RECNAME

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
DESCR Character(30) VARCHAR2(30) NOT NULL Description
TS_OBJECT_TYPE Character(3) VARCHAR2(3) NOT NULL Object Type
APP=Application Objects
BPS=Business Processes
MEN=Menu
MSG=Messages
OTH=Other
PNL=Panel
QRY=Queries and Strings
REC=Records, Fields, Xlats
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19