PC_BU_TREE_VW (SQL View)	Index Back
Project Tree Prompt A view that selects all Project trees with the PROJECT_BU structure. Primarily used as a prompt view.

PC_BU_TREE_VW

(SQL View)

Project Tree Prompt

A view that selects all Project trees with the PROJECT_BU structure. Primarily used as a prompt view.

SELECT DISTINCT %Substring(SETCNTRLVALUE, 1, 5) , TREE_NAME , DESCR FROM PSTREEDEFN WHERE TREE_STRCT_ID = 'PROJECT_BU'

Related Language Record: PC_BU_TREE_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	TREE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Tree Name
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description