TS_RECORD_VW

(SQL View)
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 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
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 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