CP_TREE_DIST_VW (SQL View)	Index Back
CP Dist Rule Tree View Rule Tree View of the CP_TREE_HDR only showing the Trees in the Distribution functional area.

CP_TREE_DIST_VW

(SQL View)

CP Dist Rule Tree View

Rule Tree View of the CP_TREE_HDR only showing the Trees in the Distribution functional area.

SELECT DISTINCT SETID , CP_TREE , CP_TREE_DESCR FROM PS_CP_TREE_HDR WHERE CP_AREA = '0'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Prompt Table: SP_SETID_NONVW

2 CP_TREE_DIST Character(18) VARCHAR2(18) NOT NULL Distribution Model Field

3 CP_TREE_DESCR Character(30) VARCHAR2(30) NOT NULL Model Description Field

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Prompt Table: SP_SETID_NONVW
2	CP_TREE_DIST	Character(18)	VARCHAR2(18) NOT NULL	Distribution Model Field
3	CP_TREE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Model Description Field