PSTREESTRCTDFVW

index back

Tree Struct Detail FieldName


SELECT A.DTL_FIELDNAME , LABL.LONGNAME ,LABL.SHORTNAME FROM PSTREESTRCT A , PSDBFLDLABL_VW LABL WHERE A.DTL_FIELDNAME = LABL.FIELDNAME AND A.DTL_FIELDNAME <> ' '

PeopleSoft Field Name Field Type Column Type Description
DTL_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Tree Structure Detail Record 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