EOEW_ETL_MAP (SQL Table)	Index Back
ETL Map Library When a map is compiled, the results are stored in the ETL Map Library which consists of EOEW_ETL_MAP and EOEW_ETL_STEP. When a map is published, the map is compiled and the EOEW_PUBLISHED_SW = 'Y'. When a map is executed, the program looks for a published map and uses the compiled version. If the map is not published, the map will be compiled at run time. When a group is executed, all of the underlying maps are either compiled or copied from the ETL Library into a run time version before any actual processing occurs. This reduces the risk of encountering problems late in a multi-map process, guarantees that each parallel process is executing the same version and insulates a currently running job from any changes to the actual map definition. The compiler inserts the output to the library (EOEW_ETL_MAP and EOEW_ETL_STEP). Before executing the map, the data is copied to the run time copy (EOEW_EXE_MAP and EOEW_EXE_STEP). These tables are identical to the ETL version with the exception of the key RUN__CNTL_ID and discarded at the end of each run.

EOEW_ETL_MAP

(SQL Table)

ETL Map Library

When a map is compiled, the results are stored in the ETL Map Library which consists of EOEW_ETL_MAP and EOEW_ETL_STEP. When a map is published, the map is compiled and the EOEW_PUBLISHED_SW = 'Y'. When a map is executed, the program looks for a published map and uses the compiled version. If the map is not published, the map will be compiled at run time. When a group is executed, all of the underlying maps are either compiled or copied from the ETL Library into a run time version before any actual processing occurs. This reduces the risk of encountering problems late in a multi-map process, guarantees that each parallel process is executing the same version and insulates a currently running job from any changes to the actual map definition. The compiler inserts the output to the library (EOEW_ETL_MAP and EOEW_ETL_STEP). Before executing the map, the data is copied to the run time copy (EOEW_EXE_MAP and EOEW_EXE_STEP). These tables are identical to the ETL version with the exception of the key RUN__CNTL_ID and discarded at the end of each run.

Related Language Record: EOEW_ETL_MAPLNG

# 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 EOEW_RECNAME_TMP Character(15) VARCHAR2(15) NOT NULL Temporary Record (Table)

5 EOEW_OBJ_OWNER Character(15) VARCHAR2(15) NOT NULL Subject Area

6 LASTCOMPILEDTTM 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.

7 EOEW_UPD_METHOD Character(1) VARCHAR2(1) NOT NULL Update Method
0=Delete via WHERE EXISTS 1
1=Update Flag in Temp Table
Default Value: 0

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

9 EOEW_SRC_TYP Character(1) VARCHAR2(1) NOT NULL Source Type
0=Reserved
1=Record
2=Data Object
Default Value: 1

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

11 EOEW_ERR_OBJ Character(15) VARCHAR2(15) NOT NULL Error Object

12 EOEW_ROW_PROC_FLG Character(1) VARCHAR2(1) NOT NULL Row Process Flag
Y/N Table Edit
Default Value: N

13 EOEW_ERR_OPT Character(1) VARCHAR2(1) NOT NULL Error Handling Options
0=No Error Handling Needed
1=Identify Error Row
2=Correct data error & reprocess
Default Value: 0

14 EOEW_ERR_RECNAME Character(15) VARCHAR2(15) NOT NULL Error Record Name

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

16 EOEW_DUP_OPT Character(1) VARCHAR2(1) NOT NULL Handling of duplicate rows If no error option EOEW_ERR_OPT="0", by defaults, then all duplicates will go to the target, EOEW_DUP_OPT ="0". If error option EOEW_ERR_OPT="1", (identify error), then EOEW_DUP_OPT may be "1" or "6" 1 - Identify duplicates as error rows (go to target table) 6 - Delete all duplicates If error option ="2", (error table provided), then EOEW_DUP_OPT can may be "1","2","3" or "6" 1 - Identify duplicates as error rows (go to error table) 2 - Select first duplicate row from each group (order by not implemented yet) 3 - Select last duplicate row from each group (order by not implemented yet) 6 - Delete all duplicates
0=Copy duplicate rows to target
1=Copy Duplicates to Error Table
2=Copy first row to Target
3=Copy last row to Target
4=Aggregate duplicate row
5=User Defined Function
6=Reject all duplicate rows

17 EOEW_LOADDTTM_FLD Character(30) VARCHAR2(30) NOT NULL Load Date Time Fieldname

18 EOEW_CHK_FLG Character(1) VARCHAR2(1) NOT NULL Chunk Selection Indicator. Used in the Record Suite to identify if a suite is chunk suite.
Y/N Table Edit
Default Value: N

19 EOEW_LOAD_OPT Character(1) VARCHAR2(1) NOT NULL Target Load Option
0=Full Load
1=Incremental Update
2=Error Recycle Only

20 EOEW_PREVIEW_SW Character(1) VARCHAR2(1) NOT NULL Execute for Preview

21 EOEW_ERR_RETRY_SW Character(1) VARCHAR2(1) NOT NULL Error Retry Switch
N=Exclude Errors
Y=Include Errors

22 EOEW_AUTOMAP_SW Character(1) VARCHAR2(1) NOT NULL AutoMap
Y/N Table Edit
Default Value: N

23 EOEW_KEEP_TMP Character(1) VARCHAR2(1) NOT NULL Retain Temporary Table
Y/N Table Edit
Default Value: N

24 EOEW_NO_TEMP_SW Character(1) VARCHAR2(1) NOT NULL Direct to Target
Y/N Table Edit
Default Value: N

25 EOEW_CREATETBL Character(1) VARCHAR2(1) NOT NULL Create Table Dynamically

26 EOEW_ROW_SOURCE Character(1) VARCHAR2(1) NOT NULL Use row processing for source

27 EOEW_ROW_TARGET Character(1) VARCHAR2(1) NOT NULL Use row processing for target

28 EOEW_FREEZE_MAP Character(1) VARCHAR2(1) NOT NULL Freeze Map
Y/N Table Edit
Default Value: N

29 EOEW_ARCHIVE_SW Character(1) VARCHAR2(1) NOT NULL Archive

30 EOEW_RESTORE_SW Character(1) VARCHAR2(1) NOT NULL Restore Archive

31 EOEW_TRUNCATE_SW Character(1) VARCHAR2(1) NOT NULL Destructive Load

32 DDLSPACENAME Character(30) VARCHAR2(30) NOT NULL Tablespace Name

33 EOEW_PUBLISHED_SW Character(1) VARCHAR2(1) NOT NULL Published Map

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

35 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

36 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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	EOEW_RECNAME_TMP	Character(15)	VARCHAR2(15) NOT NULL	Temporary Record (Table)
5	EOEW_OBJ_OWNER	Character(15)	VARCHAR2(15) NOT NULL	Subject Area
6	LASTCOMPILEDTTM	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.
7	EOEW_UPD_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Update Method 0=Delete via WHERE EXISTS 1 1=Update Flag in Temp Table Default Value: 0
8	EOEW_SRC_OBJ	Character(30)	VARCHAR2(30) NOT NULL	Source Object
9	EOEW_SRC_TYP	Character(1)	VARCHAR2(1) NOT NULL	Source Type 0=Reserved 1=Record 2=Data Object Default Value: 1
10	EOEW_TAR_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Target Object
11	EOEW_ERR_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Error Object
12	EOEW_ROW_PROC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Row Process Flag Y/N Table Edit Default Value: N
13	EOEW_ERR_OPT	Character(1)	VARCHAR2(1) NOT NULL	Error Handling Options 0=No Error Handling Needed 1=Identify Error Row 2=Correct data error & reprocess Default Value: 0
14	EOEW_ERR_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Error Record Name
15	EOEW_ERR_FLD	Character(18)	VARCHAR2(18) NOT NULL	Error Fieldname
16	EOEW_DUP_OPT	Character(1)	VARCHAR2(1) NOT NULL	Handling of duplicate rows If no error option EOEW_ERR_OPT="0", by defaults, then all duplicates will go to the target, EOEW_DUP_OPT ="0". If error option EOEW_ERR_OPT="1", (identify error), then EOEW_DUP_OPT may be "1" or "6" 1 - Identify duplicates as error rows (go to target table) 6 - Delete all duplicates If error option ="2", (error table provided), then EOEW_DUP_OPT can may be "1","2","3" or "6" 1 - Identify duplicates as error rows (go to error table) 2 - Select first duplicate row from each group (order by not implemented yet) 3 - Select last duplicate row from each group (order by not implemented yet) 6 - Delete all duplicates 0=Copy duplicate rows to target 1=Copy Duplicates to Error Table 2=Copy first row to Target 3=Copy last row to Target 4=Aggregate duplicate row 5=User Defined Function 6=Reject all duplicate rows
17	EOEW_LOADDTTM_FLD	Character(30)	VARCHAR2(30) NOT NULL	Load Date Time Fieldname
18	EOEW_CHK_FLG	Character(1)	VARCHAR2(1) NOT NULL	Chunk Selection Indicator. Used in the Record Suite to identify if a suite is chunk suite. Y/N Table Edit Default Value: N
19	EOEW_LOAD_OPT	Character(1)	VARCHAR2(1) NOT NULL	Target Load Option 0=Full Load 1=Incremental Update 2=Error Recycle Only
20	EOEW_PREVIEW_SW	Character(1)	VARCHAR2(1) NOT NULL	Execute for Preview
21	EOEW_ERR_RETRY_SW	Character(1)	VARCHAR2(1) NOT NULL	Error Retry Switch N=Exclude Errors Y=Include Errors
22	EOEW_AUTOMAP_SW	Character(1)	VARCHAR2(1) NOT NULL	AutoMap Y/N Table Edit Default Value: N
23	EOEW_KEEP_TMP	Character(1)	VARCHAR2(1) NOT NULL	Retain Temporary Table Y/N Table Edit Default Value: N
24	EOEW_NO_TEMP_SW	Character(1)	VARCHAR2(1) NOT NULL	Direct to Target Y/N Table Edit Default Value: N
25	EOEW_CREATETBL	Character(1)	VARCHAR2(1) NOT NULL	Create Table Dynamically
26	EOEW_ROW_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Use row processing for source
27	EOEW_ROW_TARGET	Character(1)	VARCHAR2(1) NOT NULL	Use row processing for target
28	EOEW_FREEZE_MAP	Character(1)	VARCHAR2(1) NOT NULL	Freeze Map Y/N Table Edit Default Value: N
29	EOEW_ARCHIVE_SW	Character(1)	VARCHAR2(1) NOT NULL	Archive
30	EOEW_RESTORE_SW	Character(1)	VARCHAR2(1) NOT NULL	Restore Archive
31	EOEW_TRUNCATE_SW	Character(1)	VARCHAR2(1) NOT NULL	Destructive Load
32	DDLSPACENAME	Character(30)	VARCHAR2(30) NOT NULL	Tablespace Name
33	EOEW_PUBLISHED_SW	Character(1)	VARCHAR2(1) NOT NULL	Published Map
34	CREATEDTTM	DateTime(26)	TIMESTAMP NOT NULL	DateTime of Query Creation Default Value: %datetime
35	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
36	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.