PSTREESTRCTNFVW

index back

Tree Struct Node Field Name


SELECT A.NODE_FIELDNAME , LABL.LONGNAME ,LABL.SHORTNAME FROM PSTREESTRCT A , PSDBFLDLABL_VW LABL WHERE A.NODE_FIELDNAME = LABL.FIELDNAME

PeopleSoft Field Name Field Type Column Type Description
NODE_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Tree Structure Node Field name
LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19