EOEW_EXE_FLD (SQL Table)	Index Back
ETL Engine Map Field Details Used to capture map field details to support the ETL Engine.

EOEW_EXE_FLD

(SQL Table)

ETL Engine Map Field Details

Used to capture map field details to support the ETL Engine.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EOEW_MAP_OBJ Character(15) VARCHAR2(15) NOT NULL Map Object

3 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

4 EOEW_TMP_FLD Character(18) VARCHAR2(18) NOT NULL Temp Field

5 EOEW_SRC_OBJ Character(30) VARCHAR2(30) NOT NULL Source Object

6 EOEW_TAR_OBJ Character(15) VARCHAR2(15) NOT NULL Target Object

7 EOEW_SRC_FLD Character(18) VARCHAR2(18) NOT NULL Source Field

8 EOEW_SRCCOLALIAS Character(30) VARCHAR2(30) NOT NULL Column Alias

9 EOEW_TAR_FLD Character(18) VARCHAR2(18) NOT NULL Target Field

10 EOEW_TAR_FIELDNUM Number(4,0) SMALLINT NOT NULL Target Object Field Number

11 EOEW_ERR_FLD Character(18) VARCHAR2(18) NOT NULL Error Fieldname

12 EOEW_SRC_KEY Character(1) VARCHAR2(1) NOT NULL Source Key Indicator
Y/N Table Edit
Default Value: N

13 EOEW_TAR_KEY Character(1) VARCHAR2(1) NOT NULL Target Key Indicator
Y/N Table Edit
Default Value: N

14 EOEW_INPUT_TYP Character(2) VARCHAR2(2) NOT NULL Source object type.
00=Source
01=Transformation
02=Constant
03=Default
04=SQL Object
05=Built-In Function
06=Translation Set

15 EOEW_INPUT_VAL Character(120) VARCHAR2(120) NOT NULL Source Input Value

16 VALIDATE_FLG Character(1) VARCHAR2(1) NOT NULL Validate Flag
Y/N Table Edit
Default Value: N

17 EOEW_DEF_VALUE Character(254) VARCHAR2(254) NOT NULL Default Value

18 EOEW_TRN_FLG Character(1) VARCHAR2(1) NOT NULL Transformation Field Indicator

19 EOEW_TRN_TYP Character(2) VARCHAR2(2) NOT NULL Transformation Type
00=Look up
01=Edit
02=Translation Set
03=Filter
04=Expression
05=SQL
06=Application Engine Program
07=PeopleCode

20 EOEW_ISLONG Character(1) VARCHAR2(1) NOT NULL Is Long Field

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

22 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

23 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	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
2	EOEW_MAP_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Map Object
3	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
4	EOEW_TMP_FLD	Character(18)	VARCHAR2(18) NOT NULL	Temp Field
5	EOEW_SRC_OBJ	Character(30)	VARCHAR2(30) NOT NULL	Source Object
6	EOEW_TAR_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Target Object
7	EOEW_SRC_FLD	Character(18)	VARCHAR2(18) NOT NULL	Source Field
8	EOEW_SRCCOLALIAS	Character(30)	VARCHAR2(30) NOT NULL	Column Alias
9	EOEW_TAR_FLD	Character(18)	VARCHAR2(18) NOT NULL	Target Field
10	EOEW_TAR_FIELDNUM	Number(4,0)	SMALLINT NOT NULL	Target Object Field Number
11	EOEW_ERR_FLD	Character(18)	VARCHAR2(18) NOT NULL	Error Fieldname
12	EOEW_SRC_KEY	Character(1)	VARCHAR2(1) NOT NULL	Source Key Indicator Y/N Table Edit Default Value: N
13	EOEW_TAR_KEY	Character(1)	VARCHAR2(1) NOT NULL	Target Key Indicator Y/N Table Edit Default Value: N
14	EOEW_INPUT_TYP	Character(2)	VARCHAR2(2) NOT NULL	Source object type. 00=Source 01=Transformation 02=Constant 03=Default 04=SQL Object 05=Built-In Function 06=Translation Set
15	EOEW_INPUT_VAL	Character(120)	VARCHAR2(120) NOT NULL	Source Input Value
16	VALIDATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Validate Flag Y/N Table Edit Default Value: N
17	EOEW_DEF_VALUE	Character(254)	VARCHAR2(254) NOT NULL	Default Value
18	EOEW_TRN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Transformation Field Indicator
19	EOEW_TRN_TYP	Character(2)	VARCHAR2(2) NOT NULL	Transformation Type 00=Look up 01=Edit 02=Translation Set 03=Filter 04=Expression 05=SQL 06=Application Engine Program 07=PeopleCode
20	EOEW_ISLONG	Character(1)	VARCHAR2(1) NOT NULL	Is Long Field
21	CREATEDTTM	DateTime(26)	TIMESTAMP NOT NULL	DateTime of Query Creation Default Value: %datetime
22	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
23	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.