EOEP_APRLKV_VW (SQL View)	Index Back
Price Rule Key Value by App Cd Price Rule Key Value by EOEP_APP_CD. This view only selects Deployed and Ready to test rules.

EOEP_APRLKV_VW

(SQL View)

Price Rule Key Value by App Cd

Price Rule Key Value by EOEP_APP_CD. This view only selects Deployed and Ready to test rules.

SELECT rkv.setid , rkv.eoep_rule_id , rkv.pprc_key_value1 , r.eoep_app_cd , r.eoep_rule_status FROM PS_EOEP_RULEKEYVAL rkv , ps_eoep_rule r WHERE rkv.setid = r.setid AND rkv.eoep_rule_id = r.eoep_rule_id AND r.eoep_rule_status IN ('D','R')

# 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.

2 EOEP_RULE_ID Character(30) VARCHAR2(30) NOT NULL Price Rule ID

3 PPRC_KEY_VALUE1 Character(60) VARCHAR2(60) NOT NULL Generic field used by the pricing

4 EOEP_APP_CD Character(4) VARCHAR2(4) NOT NULL Transaction Code

5 EOEP_RULE_STATUS Character(1) VARCHAR2(1) NOT NULL Rule Status
D=Deployed
I=Inactive
P=Pending
R=Ready To Test

#	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.
2	EOEP_RULE_ID	Character(30)	VARCHAR2(30) NOT NULL	Price Rule ID
3	PPRC_KEY_VALUE1	Character(60)	VARCHAR2(60) NOT NULL	Generic field used by the pricing
4	EOEP_APP_CD	Character(4)	VARCHAR2(4) NOT NULL	Transaction Code
5	EOEP_RULE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Rule Status D=Deployed I=Inactive P=Pending R=Ready To Test