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

EOEW_ETL_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 EOEW_MAP_OBJ Character(15) VARCHAR2(15) NOT NULL Map Object

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

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

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

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

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

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

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

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

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

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

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

13 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

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

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

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

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

18 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

19 EOEW_ISLONG Character(1) VARCHAR2(1) NOT NULL Is Long Field
Y/N Table Edit
Default Value: N

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

21 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

22 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_MAP_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Map Object
2	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
3	EOEW_TMP_FLD	Character(18)	VARCHAR2(18) NOT NULL	Temp Field
4	EOEW_SRC_OBJ	Character(30)	VARCHAR2(30) NOT NULL	Source Object
5	EOEW_TAR_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Target Object
6	EOEW_SRC_FLD	Character(18)	VARCHAR2(18) NOT NULL	Source Field
7	EOEW_SRCCOLALIAS	Character(30)	VARCHAR2(30) NOT NULL	Column Alias
8	EOEW_TAR_FLD	Character(18)	VARCHAR2(18) NOT NULL	Target Field
9	EOEW_TAR_FIELDNUM	Number(4,0)	SMALLINT NOT NULL	Target Object Field Number
10	EOEW_ERR_FLD	Character(18)	VARCHAR2(18) NOT NULL	Error Fieldname
11	EOEW_SRC_KEY	Character(1)	VARCHAR2(1) NOT NULL	Source Key Indicator Y/N Table Edit Default Value: N
12	EOEW_TAR_KEY	Character(1)	VARCHAR2(1) NOT NULL	Target Key Indicator Y/N Table Edit Default Value: N
13	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
14	EOEW_INPUT_VAL	Character(120)	VARCHAR2(120) NOT NULL	Source Input Value
15	VALIDATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Validate Flag Y/N Table Edit Default Value: N
16	EOEW_DEF_VALUE	Character(254)	VARCHAR2(254) NOT NULL	Default Value
17	EOEW_TRN_FLG	Character(1)	VARCHAR2(1) NOT NULL	Transformation Field Indicator
18	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
19	EOEW_ISLONG	Character(1)	VARCHAR2(1) NOT NULL	Is Long Field Y/N Table Edit Default Value: N
20	CREATEDTTM	DateTime(26)	TIMESTAMP NOT NULL	DateTime of Query Creation Default Value: %datetime
21	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
22	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.