PROCESS_INSTANCESETIDEOEP_RULE_IDD=Deployed
I=Inactive
P=Pending
R=Ready To Test
EOEP_RULFOR_TAO(SQL Table) |
Index Back |
|---|---|
Price Rule FormattedThis temporory table will be used to format the price rule condition and then update the PW_RULE_KEYVAL. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 3 | EOEP_RULE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Price Rule ID |
| 4 | EOEP_RULE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Rule Status
D=Deployed I=Inactive P=Pending R=Ready To Test |
| 5 | EOEP_CHAR_LONG | Long Character | CLOB | Character Long Value |