CP_RULE_VW (SQL View)	Index Back
CP Rule Number View View of CP_RULE_HDR for Prompt

CP_RULE_VW

(SQL View)

CP Rule Number View

View of CP_RULE_HDR for Prompt

SELECT SETID , CP_AREA , RULE_NUMBER , ACTION_INTL_CD , RULE_DESCRIPTION , RULE_SRCH_1 , RULE_SRCH_2 , RULE_SRCH_3 , RULE_SRCH_4 , RULE_SRCH_5 , RULE_ACTIVE_FLAG , DATE_IN_EFFECT , DATE_OBSOLETE FROM PS_CP_RULE_HDR

Parent record: CP_RULE_HDR

# 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_AREA Character(1) VARCHAR2(1) NOT NULL Functional Area Field
0=Distribution
1=Production

3 RULE_NUMBER Character(10) VARCHAR2(10) NOT NULL Rule

4 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

5 RULE_DESCRIPTION Character(50) VARCHAR2(50) NOT NULL Field used for storing Rule Description

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

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

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

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

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

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

12 DATE_IN_EFFECT Date(10) DATE 01/27/2000 RML Added "As of date" label

13 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	This field is used to store the value of SetID on various setup tables. Prompt Table: SP_SETID_NONVW
2	CP_AREA	Character(1)	VARCHAR2(1) NOT NULL	Functional Area Field 0=Distribution 1=Production
3	RULE_NUMBER	Character(10)	VARCHAR2(10) NOT NULL	Rule
4	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
5	RULE_DESCRIPTION	Character(50)	VARCHAR2(50) NOT NULL	Field used for storing Rule Description
6	RULE_SRCH_1	Character(18)	VARCHAR2(18) NOT NULL	Rule Keyword 1
7	RULE_SRCH_2	Character(18)	VARCHAR2(18) NOT NULL	Rule Keyword 2
8	RULE_SRCH_3	Character(18)	VARCHAR2(18) NOT NULL	Rule Keyword 3
9	RULE_SRCH_4	Character(18)	VARCHAR2(18) NOT NULL	Rule Keyword 4
10	RULE_SRCH_5	Character(18)	VARCHAR2(18) NOT NULL	Rule Keyword 5
11	RULE_ACTIVE	Character(1)	VARCHAR2(1) NOT NULL	Active
12	DATE_IN_EFFECT	Date(10)	DATE	01/27/2000 RML Added "As of date" label
13	DATE_OBSOLETE	Date(10)	DATE	Obsolete Date