XREF_PSRECDEFN

index back

Records


Select a.recname, a.rectype, b.sqltext From PSRECDEFN a, PSSQLTEXTDEFN b where a.recname = b.sqlid and b.sqltype='2'

PeopleSoft Field Name Field Type Column Type Description
OBJ_RECNAME Character(15) VARCHAR2(15) NOT NULL Object Recname
RECTYPE Number(1,0) SMALLINT NOT NULL Record Type
VIEWTEXT Long Character(8192) CLOB SQL View Text
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19