EOEW_RUN_FLTR (SQL Table)	Index Back
ETL Runtime map filter

EOEW_RUN_FLTR

(SQL Table)

ETL Runtime map filter

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

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

4 EOEW_FLTR_OBJ Character(15) VARCHAR2(15) NOT NULL Filter Object Name

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

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

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

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

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

10 EOEW_FLTR_TYP Character(1) VARCHAR2(1) NOT NULL Filter Type
1=Source
2=Target
3=Source and Target

11 EOEW_LOADDTTM_FLG Character(1) VARCHAR2(1) NOT NULL Chunk Selection Indicator. Used in the Record Suite to identify if a suite is chunk suite.

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

13 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

15 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

16 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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: PSOPRDEFN
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	EOEW_MAP_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Map Object Prompt Table: EOEW_MAP_DFN
4	EOEW_FLTR_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Filter Object Name
5	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
6	EOEW_SRCCOLALIAS	Character(30)	VARCHAR2(30) NOT NULL	Column Alias Prompt Table: EOEW_SFIELD_VW
7	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
8	EOEW_OPER_TYP	Character(3)	VARCHAR2(3) NOT NULL	Operator <=< <==<= <>=<> === >=> >==>= IN=IN L=Like NL=Not Like
9	EOEW_FLDVALUE	Character(120)	VARCHAR2(120) NOT NULL	Field Value
10	EOEW_FLTR_TYP	Character(1)	VARCHAR2(1) NOT NULL	Filter Type 1=Source 2=Target 3=Source and Target
11	EOEW_LOADDTTM_FLG	Character(1)	VARCHAR2(1) NOT NULL	Chunk Selection Indicator. Used in the Record Suite to identify if a suite is chunk suite.
12	EOEW_ANDOR_SW	Character(1)	VARCHAR2(1) NOT NULL	And/Or Switch A=And O=Or
13	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
14	CREATEDTTM	DateTime(26)	TIMESTAMP NOT NULL	DateTime of Query Creation Default Value: %datetime
15	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
16	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.