FLD_REQ_NODE_VW (SQL View)	Index Back
Field Request Tree Node View Field Request Tree Node 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_NODE_VW

(SQL View)

Field Request Tree Node View

Field Request Tree Node 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.TREE_SETID , A.FIELDNAME1 , A.TREE_NAME , A.TREE_EFFDT , B.TREE_NODE FROM PS_FLD_REQ_TREE_VW A , PSTREENODE B WHERE A.TREE_SETID=B.SETID AND A.TREE_NAME=B.TREE_NAME AND A.TREE_EFFDT=B.EFFDT

# 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_NODE Character(20) VARCHAR2(20) NOT NULL Node name

#	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_NODE	Character(20)	VARCHAR2(20) NOT NULL	Node name