EOEW_ETL_STEP (SQL Table)	Index Back
ETL Map Library - Step 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_STEP

(SQL Table)

ETL Map Library - Step

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_STPLNG

# 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 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

4 EOEW_ISVALID_SW Character(1) VARCHAR2(1) NOT NULL Valid
Default Value: N

5 EOEW_STEP_TYPE Character(1) VARCHAR2(1) NOT NULL Step Type
1=Copy Source to Temp
2=Recycle Errors
3=Transformation
6=Delete from Target
7=Copy Temp to Target

6 EOEW_SQL_MODE Character(1) VARCHAR2(1) NOT NULL SQL Mode (Set or (C)ursor
C=Cursor Mode
S=Set Mode
Default Value: S

7 EOEW_TIMING Character(1) VARCHAR2(1) NOT NULL Timing
A=After Last Chunk
B=Before First Chunk
N=Normal
Default Value: N

8 EOEW_COMMIT_AFTER Character(1) VARCHAR2(1) NOT NULL Commit After
Y/N Table Edit
Default Value: N

9 DESCR Character(30) VARCHAR2(30) NOT NULL Description

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

11 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

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

13 SQLTEXT Long Character(14000) CLOB SQL Statement Text

#	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	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
4	EOEW_ISVALID_SW	Character(1)	VARCHAR2(1) NOT NULL	Valid Default Value: N
5	EOEW_STEP_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Step Type 1=Copy Source to Temp 2=Recycle Errors 3=Transformation 6=Delete from Target 7=Copy Temp to Target
6	EOEW_SQL_MODE	Character(1)	VARCHAR2(1) NOT NULL	SQL Mode (Set or (C)ursor C=Cursor Mode S=Set Mode Default Value: S
7	EOEW_TIMING	Character(1)	VARCHAR2(1) NOT NULL	Timing A=After Last Chunk B=Before First Chunk N=Normal Default Value: N
8	EOEW_COMMIT_AFTER	Character(1)	VARCHAR2(1) NOT NULL	Commit After Y/N Table Edit Default Value: N
9	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
10	CREATEDTTM	DateTime(26)	TIMESTAMP NOT NULL	DateTime of Query Creation Default Value: %datetime
11	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
12	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.
13	SQLTEXT	Long Character(14000)	CLOB	SQL Statement Text