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.

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