CP_RULE_TREE_VW (SQL View)	Index Back
Join of CP_TREE & CP_RULE_HDR Used on Selective Rules Inquiry, selected by tree name

CP_RULE_TREE_VW

(SQL View)

Join of CP_TREE & CP_RULE_HDR

Used on Selective Rules Inquiry, selected by tree name

SELECT b.SETID , b.CP_AREA , b.CP_TREE , b.RULE_NUMBER , a.ACTION_INTL_CD , a.RULE_DESCRIPTION , a.RULE_SRCH_1 , a.RULE_SRCH_2 , a.RULE_SRCH_3 , a.RULE_SRCH_4 , a.RULE_SRCH_5 , a.RULE_ACTIVE_FLAG , a.DATE_IN_EFFECT , a.DATE_OBSOLETE FROM PS_CP_RULE_HDR a , PS_CP_TREE_DETL b WHERE a.SETID = b.SETID AND a.CP_AREA = b.CP_AREA AND a.RULE_NUMBER = b.RULE_NUMBER

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

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 RULE_NUMBER Character(10) VARCHAR2(10) NOT NULL Rule

5 ACTION_INTL_CD Character(2) VARCHAR2(2) NOT NULL CP Action International Code Field
01=Condition
02=Secondary Variable
03=Global Variable
04=Option Variable
05=Internal Variable Override
06=Create External Parameter
07=Configuration Detail
08=Start Trace
09=End Trace
20=Page Generation
21=Page Validation
22=Configured Component
23=Purchase Item
24=Finalized Price
25=Finalized Cost
26=Finalized Date
27=Availability Date
28=Workflow
29=Kit Component
30=Component List
31=Operation Sequence
32=Generate Comment
33=Product Selector
34=Kit Generation
35=Finalized Weight
36=Finalized Volume

6 RULE_DESCRIPTION Character(50) VARCHAR2(50) NOT NULL Rule Description

7 RULE_SRCH_1 Character(18) VARCHAR2(18) NOT NULL Rule Keyword 1

8 RULE_SRCH_2 Character(18) VARCHAR2(18) NOT NULL Rule Keyword 2

9 RULE_SRCH_3 Character(18) VARCHAR2(18) NOT NULL Rule Keyword 3

10 RULE_SRCH_4 Character(18) VARCHAR2(18) NOT NULL Rule Keyword 4

11 RULE_SRCH_5 Character(18) VARCHAR2(18) NOT NULL Rule Keyword 5

12 RULE_ACTIVE Character(1) VARCHAR2(1) NOT NULL Active

13 DATE_IN_EFFECT Date(10) DATE 01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label

14 DATE_OBSOLETE Date(10) DATE Obsolete Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
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	RULE_NUMBER	Character(10)	VARCHAR2(10) NOT NULL	Rule
5	ACTION_INTL_CD	Character(2)	VARCHAR2(2) NOT NULL	CP Action International Code Field 01=Condition 02=Secondary Variable 03=Global Variable 04=Option Variable 05=Internal Variable Override 06=Create External Parameter 07=Configuration Detail 08=Start Trace 09=End Trace 20=Page Generation 21=Page Validation 22=Configured Component 23=Purchase Item 24=Finalized Price 25=Finalized Cost 26=Finalized Date 27=Availability Date 28=Workflow 29=Kit Component 30=Component List 31=Operation Sequence 32=Generate Comment 33=Product Selector 34=Kit Generation 35=Finalized Weight 36=Finalized Volume
6	RULE_DESCRIPTION	Character(50)	VARCHAR2(50) NOT NULL	Rule Description
7	RULE_SRCH_1	Character(18)	VARCHAR2(18) NOT NULL	Rule Keyword 1
8	RULE_SRCH_2	Character(18)	VARCHAR2(18) NOT NULL	Rule Keyword 2
9	RULE_SRCH_3	Character(18)	VARCHAR2(18) NOT NULL	Rule Keyword 3
10	RULE_SRCH_4	Character(18)	VARCHAR2(18) NOT NULL	Rule Keyword 4
11	RULE_SRCH_5	Character(18)	VARCHAR2(18) NOT NULL	Rule Keyword 5
12	RULE_ACTIVE	Character(1)	VARCHAR2(1) NOT NULL	Active
13	DATE_IN_EFFECT	Date(10)	DATE	01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label
14	DATE_OBSOLETE	Date(10)	DATE	Obsolete Date