EOEW_MAP_DFN_VW (SQL View)	Index Back
DT Maps for Subject View 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_VW

(SQL View)

DT Maps for Subject View

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.

SELECT DISTINCT B.EOEW_OBJ_OWNER , A.EOEW_MAP_OBJ , A.DESCR , A.EOEW_SRC_OBJ , A.EOEW_TAR_OBJ FROM PS_EOEW_MAP_DFN A , PS_EOEW_OBJOWN_VW B WHERE A.EOEW_OBJ_OWNER = B.EOEW_OBJ2_OWNER

Related Language Record: EOEW_MPDFVW_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOEW_OBJ_OWNER	Character(15)	VARCHAR2(15) NOT NULL	Subject Area Prompt Table: EOEW_OBJ_OWNER
2	EOEW_MAP_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Map Object
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	EOEW_SRC_OBJ	Character(30)	VARCHAR2(30) NOT NULL	Source Object Prompt Table: %EDITTABLE
5	EOEW_TAR_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Target Object Prompt Table: %EDITTABLE2