EOEW_OBJ_OWNERPrompt Table: EOEW_OBJ_OWNER
EOEW_MAP_OBJLANGUAGE_CDEOEW_MPDFVW_LNG(SQL View) |
Index Back |
|---|---|
DT Maps for Subject ViewThe 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 , C.LANGUAGE_CD , C.DESCR FROM PS_EOEW_MAP_DFN A , PS_EOEW_OBJOWN_VW B , PS_EOEW_MAP_DFNLNG C WHERE A.EOEW_MAP_OBJ = C.EOEW_MAP_OBJ AND A.EOEW_OBJ_OWNER = B.EOEW_OBJ2_OWNER |
| # | 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |