FLD_REQ_TREE_VW (SQL View)	Index Back
Field Request Tree View Field Request Tree View Use TREE_SETID instead of SETID in this tree prompting view, to avoid the PeopleTools' auto SetID indirect prompting. A work record field, FLD_REQ_OTH_WRK.TREE_SETID, has to be added to the page and assigned value for the direct prompting.

FLD_REQ_TREE_VW

(SQL View)

Field Request Tree View

Field Request Tree View Use TREE_SETID instead of SETID in this tree prompting view, to avoid the PeopleTools' auto SetID indirect prompting. A work record field, FLD_REQ_OTH_WRK.TREE_SETID, has to be added to the page and assigned value for the direct prompting.

SELECT A.SETID , B.DTL_FIELDNAME , A.TREE_NAME , A.EFFDT , A.DESCR FROM PSTREEDEFN A , PSTREESTRCT B WHERE A.TREE_STRCT_ID=B.TREE_STRCT_ID AND A.SETID<>' ' AND B.DTL_FIELDNAME<>' ' UNION SELECT A1.SETID , B1.NODE_FIELDNAME , A1.TREE_NAME , A1.EFFDT , A1.DESCR FROM PSTREEDEFN A1 , PSTREESTRCT B1 WHERE A1.TREE_STRCT_ID=B1.TREE_STRCT_ID AND A1.SETID<>' ' AND B1.DTL_FIELDNAME=' ' AND B1.NODE_FIELDNAME<>' '

Related Language Record: FLDRQTREELNG_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TREE_SETID Character(5) VARCHAR2(5) NOT NULL Tree SetID

2 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1

3 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

4 TREE_EFFDT Date(10) DATE Effective date of the Tree

5 TREE_DESCR Character(30) VARCHAR2(30) NOT NULL Tree Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TREE_SETID	Character(5)	VARCHAR2(5) NOT NULL	Tree SetID
2	FIELDNAME1	Character(18)	VARCHAR2(18) NOT NULL	Field Name 1
3	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
4	TREE_EFFDT	Date(10)	DATE	Effective date of the Tree
5	TREE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Tree Description