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 NameField TypeColumn TypeDescription
OBJ_RECNAMECharacter(15)VARCHAR2(15) NOT NULLObject Recname
RECTYPENumber(1,0)SMALLINT NOT NULLRecord Type
VIEWTEXTLong Character(8192)CLOBSQL View Text
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19