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