EOEW_GRP_FLTR (SQL Table)	Index Back
Map Group filter details

EOEW_GRP_FLTR

(SQL Table)

Map Group filter details

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOEW_GRP_OBJ Character(15) VARCHAR2(15) NOT NULL Map Group

2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

3 EOEW_ROWNUM Number(3,0) SMALLINT NOT NULL Row Number

4 EOEW_MAP_OBJ Character(15) VARCHAR2(15) NOT NULL Map Object
Prompt Table: EOEW_MAP_DFN

5 EOEW_SRCCOLALIAS Character(30) VARCHAR2(30) NOT NULL Column Alias
Prompt Table: EOEW_SFIELD_VW

6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

7 EOEW_FLDVALUE Character(120) VARCHAR2(120) NOT NULL Field Value

8 EOEW_OPER_TYP Character(3) VARCHAR2(3) NOT NULL Operator
<=<
<==<=
<>=<>
===
>=>
>==>=
IN=IN
L=Like
NL=Not Like

9 EOEW_ANDOR_SW Character(1) VARCHAR2(1) NOT NULL And/Or Switch
A=And
O=Or

10 EOEW_SYSMAINT_FLG Character(1) VARCHAR2(1) NOT NULL System Maintained
Y/N Table Edit

11 CREATEDTTM DateTime(26) TIMESTAMP NOT NULL DateTime of Query Creation
Default Value: %datetime

12 LASTUPDDTTM DateTime(26) TIMESTAMP NOT NULL 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.
Default Value: %datetime

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOEW_GRP_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Map Group
2	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
3	EOEW_ROWNUM	Number(3,0)	SMALLINT NOT NULL	Row Number
4	EOEW_MAP_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Map Object Prompt Table: EOEW_MAP_DFN
5	EOEW_SRCCOLALIAS	Character(30)	VARCHAR2(30) NOT NULL	Column Alias Prompt Table: EOEW_SFIELD_VW
6	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
7	EOEW_FLDVALUE	Character(120)	VARCHAR2(120) NOT NULL	Field Value
8	EOEW_OPER_TYP	Character(3)	VARCHAR2(3) NOT NULL	Operator <=< <==<= <>=<> === >=> >==>= IN=IN L=Like NL=Not Like
9	EOEW_ANDOR_SW	Character(1)	VARCHAR2(1) NOT NULL	And/Or Switch A=And O=Or
10	EOEW_SYSMAINT_FLG	Character(1)	VARCHAR2(1) NOT NULL	System Maintained Y/N Table Edit
11	CREATEDTTM	DateTime(26)	TIMESTAMP NOT NULL	DateTime of Query Creation Default Value: %datetime
12	LASTUPDDTTM	DateTime(26)	TIMESTAMP NOT NULL	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. Default Value: %datetime
13	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.