EOEC_MP_RULCOND

(SQL Table)
Index Back

Datset Rule Condition

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOEC_DATASETNAME Character(30) VARCHAR2(30) NOT NULL The name of one or more rules that will be used to filter a rowset.
2 EOEC_RULENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table
3 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
4 EOEC_AND_OR Character(1) VARCHAR2(1) NOT NULL Used to define if the sql condition should be an AND or a OR condition.
1=AND
2=OR
5 EOEC_MP_LEFT_PAREN Character(2) VARCHAR2(2) NOT NULL Left Parentheses Level
1=(
2=((
3=(((
4=((((
5=(((((
6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: EOEC_MP_DFLD_VW

7 EOEC_MP_OPERATOR Character(4) VARCHAR2(4) NOT NULL the conditional operator of the sql condition (<,<=,>,>=,=,<>, LIKE,...)
EAR=Earlier Than
EQT=Equal To
GTE=Greater Than or Equal To
GTN=Greater Than
LAT=Later Than
LIK=Like
LTE=Less Than or Equal To
LTN=Less Than
NEQ=Not Equal To

Prompt Table: %EDITTABLE

8 EOEC_COND_VALUE Character(254) VARCHAR2(254) NOT NULL the value of the sql condition to test for.

Prompt Table: %EDITTABLE2

9 EOEC_MP_PASTFUTURE Character(1) VARCHAR2(1) NOT NULL came with the crm import.
F=Days Ahead
P=Days Ago
10 EOEC_MP_RGHT_PAREN Character(2) VARCHAR2(2) NOT NULL Right Parentheses Level
1=)
2=))
3=)))
4=))))
5=)))))
11 EOEC_RW_LTSV_DTTM DateTime(26) TIMESTAMP came with the crm import.
12 EOEC_ACTION_DT Date(10) DATE The rule condition action date.