SETIDEOEP_RULE_IDPPRC_KEY_VALUE1D=Deployed
I=Inactive
P=Pending
R=Ready To Test
EOEP_APRLKV_VW(SQL View) |
Index Back |
|---|---|
Price Rule Key Value by App CdPrice 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 , r.eoep_child_cds 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 | SetID |
| 2 | EOEP_RULE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Price Rule ID |
| 3 | PPRC_KEY_VALUE1 |
Character(60) | VARCHAR2(60) NOT NULL | Price Key value 1 |
| 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 |
| 6 | EOEP_CHILD_CDS | Character(64) | VARCHAR2(64) NOT NULL | Child Applications |