EOEW_MAP_FLD (SQL Table)	Index Back
EW Map Field Definition Used to capture detailed

EOEW_MAP_FLD

(SQL Table)

EW Map Field Definition

Used to capture detailed

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOEW_MAP_OBJ Character(15) VARCHAR2(15) NOT NULL Map Object
Prompt Table: EOEW_MAP_DFN

2 EOEW_SRC_OBJ Character(30) VARCHAR2(30) NOT NULL Source Object

3 EOEW_TAR_OBJ Character(15) VARCHAR2(15) NOT NULL Target Object

4 EOEW_TAR_FLD Character(18) VARCHAR2(18) NOT NULL Target Field
Prompt Table: EOEW_FIELD_VW

5 EOEW_SRC_FLD Character(18) VARCHAR2(18) NOT NULL Source Field
Prompt Table: EOEW_FIELD_VW

6 EOEW_SRCCOLALIAS Character(30) VARCHAR2(30) NOT NULL Column Alias

7 EOEW_INPUT_TYP Character(2) VARCHAR2(2) NOT NULL Source object type.
00=Source
01=Transformation
02=Constant
03=Default
04=SQL Object
05=Built-In Function
06=Translation Set

8 EOEW_INPUT_VAL Character(120) VARCHAR2(120) NOT NULL Source Input Value

9 EOEW_ALLOW_OVR Character(1) VARCHAR2(1) NOT NULL Allow Map Override
N=No
Y=Yes
Default Value: Y

10 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

11 EOEW_SYSMAINT_FLG Character(1) VARCHAR2(1) NOT NULL System Maintained

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

13 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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOEW_MAP_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Map Object Prompt Table: EOEW_MAP_DFN
2	EOEW_SRC_OBJ	Character(30)	VARCHAR2(30) NOT NULL	Source Object
3	EOEW_TAR_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Target Object
4	EOEW_TAR_FLD	Character(18)	VARCHAR2(18) NOT NULL	Target Field Prompt Table: EOEW_FIELD_VW
5	EOEW_SRC_FLD	Character(18)	VARCHAR2(18) NOT NULL	Source Field Prompt Table: EOEW_FIELD_VW
6	EOEW_SRCCOLALIAS	Character(30)	VARCHAR2(30) NOT NULL	Column Alias
7	EOEW_INPUT_TYP	Character(2)	VARCHAR2(2) NOT NULL	Source object type. 00=Source 01=Transformation 02=Constant 03=Default 04=SQL Object 05=Built-In Function 06=Translation Set
8	EOEW_INPUT_VAL	Character(120)	VARCHAR2(120) NOT NULL	Source Input Value
9	EOEW_ALLOW_OVR	Character(1)	VARCHAR2(1) NOT NULL	Allow Map Override N=No Y=Yes Default Value: Y
10	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
11	EOEW_SYSMAINT_FLG	Character(1)	VARCHAR2(1) NOT NULL	System Maintained
12	CREATEDTTM	DateTime(26)	TIMESTAMP NOT NULL	DateTime of Query Creation Default Value: %datetime
13	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
14	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.