EOEW_SRCFILTER(SQL Table) | 
Index Back | 
|---|---|
EOEW SDO Filter metadata | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL | Source Data Object | |
| 2 | Number(3,0) | SMALLINT NOT NULL | Sequence | |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description | 
| 4 | EOEW_SRCTABLE | Character(80) | VARCHAR2(80) NOT NULL | Source Record Name | 
| 5 | EOEW_SRCCOL | Character(80) | VARCHAR2(80) NOT NULL | Source Field Name | 
| 6 | EOEW_SRC_OPERATOR | Character(4) | VARCHAR2(4) NOT NULL | 
Comparison Operator
 10=Between 11=Not Between 12=Exists 13=Not Exists 14=Like 15=Not Like 2=Equals 3=Not Equal To 4=Greater Than 5=Less Than Or Equal To 6=Less Than 7=Greater Than Or Equal To 8=In 9=Not In  | 
| 7 | EOEW_SRC_OPLOGICAL | Character(4) | VARCHAR2(4) NOT NULL | 
Logical Operator
 1=And 2=Or  | 
| 8 | NEGATION | Character(1) | VARCHAR2(1) NOT NULL | Negation | 
| 9 | EO_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Value | 
| 10 | EOEW_SRCTABLEQUAL | Character(80) | VARCHAR2(80) NOT NULL | Source Record Name | 
| 11 | EOEW_SRCCOLQUAL | Character(80) | VARCHAR2(80) NOT NULL | Source Field Name | 
| 12 | EOEW_SRC_GRPSTART | Character(1) | VARCHAR2(1) NOT NULL | Group Starter | 
| 13 | EOEW_SRC_INDENTLVL | Number(3,0) | SMALLINT NOT NULL | Indent Level | 
| 14 | EOEW_SRC_ENDPARENS | Number(1,0) | SMALLINT NOT NULL | End Parens | 
| 15 | EOEW_SYSMAINT_FLG | Character(1) | VARCHAR2(1) NOT NULL | 
System Maintained
 Y/N Table Edit Default Value: N  | 
| 16 | CREATEDTTM | DateTime(26) | TIMESTAMP | DateTime of Query Creation | 
| 17 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. | 
| 18 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |