CP_TREE_DETL (SQL Table)	Index Back
CP Tree Table CP Tree Table

CP_TREE_DETL

(SQL Table)

CP Tree Table

# 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.
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 CP_AREA Character(1) VARCHAR2(1) NOT NULL Functional Area Field
0=Distribution
1=Production

3 CP_TREE Character(18) VARCHAR2(18) NOT NULL Model Field

4 CP_NODE Number(5,0) INTEGER NOT NULL Node Number Field
Default Value: 1

5 CP_TREE_SEQ Number(5,0) INTEGER NOT NULL Model Sequence Field
Default Value: 1

6 CP_NODE_TYPE Character(1) VARCHAR2(1) NOT NULL Node Type Field
0=Rule
1=Submodel
Default Value: 0

7 RULE_NUMBER Character(10) VARCHAR2(10) NOT NULL Rule
Prompt Table: CP_RULE_VW

8 CP_SUBTREE Character(18) VARCHAR2(18) NOT NULL Submodel Field

9 CP_NODE_GOTO_TRUE Number(5,0) INTEGER NOT NULL Go to True Node Field

10 CP_NODE_GOTO_FALSE Number(5,0) INTEGER NOT NULL Go to False Node Field

11 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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. Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	CP_AREA	Character(1)	VARCHAR2(1) NOT NULL	Functional Area Field 0=Distribution 1=Production
3	CP_TREE	Character(18)	VARCHAR2(18) NOT NULL	Model Field
4	CP_NODE	Number(5,0)	INTEGER NOT NULL	Node Number Field Default Value: 1
5	CP_TREE_SEQ	Number(5,0)	INTEGER NOT NULL	Model Sequence Field Default Value: 1
6	CP_NODE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Node Type Field 0=Rule 1=Submodel Default Value: 0
7	RULE_NUMBER	Character(10)	VARCHAR2(10) NOT NULL	Rule Prompt Table: CP_RULE_VW
8	CP_SUBTREE	Character(18)	VARCHAR2(18) NOT NULL	Submodel Field
9	CP_NODE_GOTO_TRUE	Number(5,0)	INTEGER NOT NULL	Go to True Node Field
10	CP_NODE_GOTO_FALSE	Number(5,0)	INTEGER NOT NULL	Go to False Node Field
11	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.