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 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
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
TS_OBJECT_TYPECharacter(3)VARCHAR2(3) NOT NULLObject 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.ukPeopleTools 8.54
PTRef generated on 09-JUN-19