EOEW_EXE_MAP (SQL Table)	Index Back
ETL Map run time copy 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_EXE_MAP

(SQL Table)

ETL Map run time copy

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_EXE_MAPLNG

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

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

6 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier

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

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

9 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

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

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

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

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

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

15 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

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

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

18 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

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

20 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

37 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

38 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	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	EOEW_RECNAME_TMP	Character(15)	VARCHAR2(15) NOT NULL	Temporary Record (Table)
6	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier
7	EOEW_OBJ_OWNER	Character(15)	VARCHAR2(15) NOT NULL	Subject Area
8	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.
9	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
10	EOEW_SRC_OBJ	Character(30)	VARCHAR2(30) NOT NULL	Source Object
11	EOEW_SRC_TYP	Character(1)	VARCHAR2(1) NOT NULL	Source Type 0=Reserved 1=Record 2=Data Object Default Value: 1
12	EOEW_TAR_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Target Object
13	EOEW_ERR_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Error Object
14	EOEW_ROW_PROC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Row Process Flag Y/N Table Edit Default Value: N
15	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
16	EOEW_ERR_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Error Record Name
17	EOEW_ERR_FLD	Character(18)	VARCHAR2(18) NOT NULL	Error Fieldname
18	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
19	EOEW_LOADDTTM_FLD	Character(30)	VARCHAR2(30) NOT NULL	Load Date Time Fieldname
20	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
21	EOEW_LOAD_OPT	Character(1)	VARCHAR2(1) NOT NULL	Target Load Option 0=Full Load 1=Incremental Update 2=Error Recycle Only
22	EOEW_PREVIEW_SW	Character(1)	VARCHAR2(1) NOT NULL	Execute for Preview
23	EOEW_ERR_RETRY_SW	Character(1)	VARCHAR2(1) NOT NULL	Error Retry Switch N=Exclude Errors Y=Include Errors
24	EOEW_AUTOMAP_SW	Character(1)	VARCHAR2(1) NOT NULL	AutoMap Y/N Table Edit Default Value: N
25	EOEW_KEEP_TMP	Character(1)	VARCHAR2(1) NOT NULL	Retain Temporary Table Y/N Table Edit Default Value: N
26	EOEW_NO_TEMP_SW	Character(1)	VARCHAR2(1) NOT NULL	Direct to Target Y/N Table Edit Default Value: N
27	EOEW_CREATETBL	Character(1)	VARCHAR2(1) NOT NULL	Create Table Dynamically
28	EOEW_ROW_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Use row processing for source
29	EOEW_ROW_TARGET	Character(1)	VARCHAR2(1) NOT NULL	Use row processing for target
30	EOEW_FREEZE_MAP	Character(1)	VARCHAR2(1) NOT NULL	Freeze Map Y/N Table Edit Default Value: N
31	EOEW_ARCHIVE_SW	Character(1)	VARCHAR2(1) NOT NULL	Archive
32	EOEW_RESTORE_SW	Character(1)	VARCHAR2(1) NOT NULL	Restore Archive
33	EOEW_TRUNCATE_SW	Character(1)	VARCHAR2(1) NOT NULL	Destructive Load
34	DDLSPACENAME	Character(30)	VARCHAR2(30) NOT NULL	Tablespace Name
35	EOEW_PUBLISHED_SW	Character(1)	VARCHAR2(1) NOT NULL	Published Map
36	CREATEDTTM	DateTime(26)	TIMESTAMP NOT NULL	DateTime of Query Creation Default Value: %datetime
37	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
38	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.