EOEW_MAP_DFN (SQL Table)	Index Back
ETL Client Map Definition The Map Definition is used to capture the map information and details used to run the ETL Engine. The user has the ability to define the map name, short description, subject area/object owner, source data object, target object, error handling options and any additional comments regarding the use of the specific map. The map options will be enabled for an advanced user or system administrator. The user has two alternatives for mapping the fields. 1.Generate the map field details by using Auto-Mapper. 2.Manually map the source to target fields. The user navigates to the Map Field Detail page where they are presented with the target table field list.

EOEW_MAP_DFN

(SQL Table)

ETL Client Map Definition

The Map Definition is used to capture the map information and details used to run the ETL Engine. The user has the ability to define the map name, short description, subject area/object owner, source data object, target object, error handling options and any additional comments regarding the use of the specific map. The map options will be enabled for an advanced user or system administrator. The user has two alternatives for mapping the fields. 1.Generate the map field details by using Auto-Mapper. 2.Manually map the source to target fields. The user navigates to the Map Field Detail page where they are presented with the target table field list.

Related Language Record: EOEW_MAP_DFNLNG

Parent Record Of EOEW_MAPEDIT_VW EOEW_MAPTFLD_VW EOEW_MAP_FLD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOEW_MAP_OBJ Character(15) VARCHAR2(15) NOT NULL Map Object

2 EOEW_SRC_OBJ Character(30) VARCHAR2(30) NOT NULL Source Object
Prompt Table: %EDITTABLE

3 EOEW_TAR_OBJ Character(15) VARCHAR2(15) NOT NULL Target Object
Prompt Table: %EDITTABLE2

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

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

6 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

7 EOEW_OBJ_OWNER Character(15) VARCHAR2(15) NOT NULL Subject Area
Prompt Table: EOEW_OBJ_OWNER

8 EOEW_ERR_OBJ Character(15) VARCHAR2(15) NOT NULL Error Object
Prompt Table: PSRECDEFN

9 EOEW_ERR_FLD Character(18) VARCHAR2(18) NOT NULL Error Fieldname
Prompt Table: EOEW_TFLDLST_VW

10 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
Default Value: 0

11 EOEW_LOADDTTM_FLD Character(30) VARCHAR2(30) NOT NULL Load Date Time Fieldname
Prompt Table: EOEW_SFLDTTM_VW

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

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

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

15 EOEW_MAP_STATUS Character(1) VARCHAR2(1) NOT NULL Used to identify the current map lifecycle stage.
0=Initial
1=Auto-mapper Run
2=Valid
3=Invalid
4=Published
5=Un-Published
6=Locked
Default Value: 0

16 DDLSPACENAME Character(30) VARCHAR2(30) NOT NULL Tablespace Name
Prompt Table: EOEW_TBLSPCATVW

17 EOEW_CREATETBL Character(1) VARCHAR2(1) NOT NULL Create Table Dynamically
Y/N Table Edit
Default Value: Y

18 EOEW_RECNAME_TMP Character(15) VARCHAR2(15) NOT NULL Temporary Record (Table)
Prompt Table: PSRECDEFN

19 EOEW_ROW_SOURCE Character(1) VARCHAR2(1) NOT NULL Use row processing for source
Y/N Table Edit
Default Value: N

20 EOEW_ROW_TARGET Character(1) VARCHAR2(1) NOT NULL Use row processing for target
Y/N Table Edit
Default Value: N

21 EOEW_FREEZE_MAP Character(1) VARCHAR2(1) NOT NULL Lock map definition
Y/N Table Edit
Default Value: N

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

23 EOEW_RESTORE_SW Character(1) VARCHAR2(1) NOT NULL Restore Archive
Y/N Table Edit
Default Value: N

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

25 EOEW_SYSMAINT_FLG Character(1) VARCHAR2(1) NOT NULL System Maintained
Y/N Table Edit
Default Value: N

26 EOEW_OBJORIGINATOR Character(1) VARCHAR2(1) NOT NULL Originator
1=User Interface Created
2=API created
Default Value: 1

27 EOEW_TAR_INDEXID Character(1) VARCHAR2(1) NOT NULL Target Index ID
Default Value: _
Prompt Table: PSINDEXDEFN

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

29 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

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

31 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOEW_MAP_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Map Object
2	EOEW_SRC_OBJ	Character(30)	VARCHAR2(30) NOT NULL	Source Object Prompt Table: %EDITTABLE
3	EOEW_TAR_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Target Object Prompt Table: %EDITTABLE2
4	EOEW_SRC_TYP	Character(1)	VARCHAR2(1) NOT NULL	Source Type 0=Reserved 1=Record 2=Data Object Default Value: 2
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	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
7	EOEW_OBJ_OWNER	Character(15)	VARCHAR2(15) NOT NULL	Subject Area Prompt Table: EOEW_OBJ_OWNER
8	EOEW_ERR_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Error Object Prompt Table: PSRECDEFN
9	EOEW_ERR_FLD	Character(18)	VARCHAR2(18) NOT NULL	Error Fieldname Prompt Table: EOEW_TFLDLST_VW
10	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 Default Value: 0
11	EOEW_LOADDTTM_FLD	Character(30)	VARCHAR2(30) NOT NULL	Load Date Time Fieldname Prompt Table: EOEW_SFLDTTM_VW
12	EOEW_AUTOMAP_SW	Character(1)	VARCHAR2(1) NOT NULL	AutoMap Y/N Table Edit Default Value: N
13	EOEW_NO_TEMP_SW	Character(1)	VARCHAR2(1) NOT NULL	Direct to Target Y/N Table Edit Default Value: N
14	EOEW_KEEP_TMP	Character(1)	VARCHAR2(1) NOT NULL	Retain Temporary Table Y/N Table Edit Default Value: N
15	EOEW_MAP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Used to identify the current map lifecycle stage. 0=Initial 1=Auto-mapper Run 2=Valid 3=Invalid 4=Published 5=Un-Published 6=Locked Default Value: 0
16	DDLSPACENAME	Character(30)	VARCHAR2(30) NOT NULL	Tablespace Name Prompt Table: EOEW_TBLSPCATVW
17	EOEW_CREATETBL	Character(1)	VARCHAR2(1) NOT NULL	Create Table Dynamically Y/N Table Edit Default Value: Y
18	EOEW_RECNAME_TMP	Character(15)	VARCHAR2(15) NOT NULL	Temporary Record (Table) Prompt Table: PSRECDEFN
19	EOEW_ROW_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Use row processing for source Y/N Table Edit Default Value: N
20	EOEW_ROW_TARGET	Character(1)	VARCHAR2(1) NOT NULL	Use row processing for target Y/N Table Edit Default Value: N
21	EOEW_FREEZE_MAP	Character(1)	VARCHAR2(1) NOT NULL	Lock map definition Y/N Table Edit Default Value: N
22	EOEW_ARCHIVE_SW	Character(1)	VARCHAR2(1) NOT NULL	Archive Y/N Table Edit Default Value: N
23	EOEW_RESTORE_SW	Character(1)	VARCHAR2(1) NOT NULL	Restore Archive Y/N Table Edit Default Value: N
24	EOEW_TRUNCATE_SW	Character(1)	VARCHAR2(1) NOT NULL	Destructive Load
25	EOEW_SYSMAINT_FLG	Character(1)	VARCHAR2(1) NOT NULL	System Maintained Y/N Table Edit Default Value: N
26	EOEW_OBJORIGINATOR	Character(1)	VARCHAR2(1) NOT NULL	Originator 1=User Interface Created 2=API created Default Value: 1
27	EOEW_TAR_INDEXID	Character(1)	VARCHAR2(1) NOT NULL	Target Index ID Default Value: _ Prompt Table: PSINDEXDEFN
28	CREATEDTTM	DateTime(26)	TIMESTAMP NOT NULL	DateTime of Query Creation Default Value: %datetime
29	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
30	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.
31	DESCRLONG	Long Character	CLOB	Long Description