EOEW_MAPEDIT_VW (SQL View)	Index Back
EW Map Field Definition Used to capture detailed

EOEW_MAPEDIT_VW

(SQL View)

EW Map Field Definition

Used to capture detailed

SELECT EOEW_MAP_OBJ , EOEW_SRC_OBJ , EOEW_TAR_OBJ , EOEW_TAR_FLD , EOEW_SRC_FLD , EOEW_SRCCOLALIAS , EOEW_INPUT_TYP , EOEW_INPUT_VAL , EOEW_ALLOW_OVR , MESSAGE_NBR , EOEW_SYSMAINT_FLG , CREATEDTTM , LASTUPDDTTM , LASTUPDOPRID FROM PS_EOEW_MAP_FLD WHERE EOEW_TAR_FLD = ' ' AND EOEW_INPUT_TYP = '01'

Parent record: EOEW_MAP_DFN

# 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

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

4 EOEW_TAR_FLD Character(18) VARCHAR2(18) NOT NULL Target Field

5 EOEW_SRC_FLD Character(18) VARCHAR2(18) NOT NULL Source Field

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
Default Value: 01

8 EOEW_INPUT_VAL Character(120) VARCHAR2(120) NOT NULL Source Input Value
Prompt Table: EOEW_EDT_TRN_VW

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

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
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
5	EOEW_SRC_FLD	Character(18)	VARCHAR2(18) NOT NULL	Source Field
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 Default Value: 01
8	EOEW_INPUT_VAL	Character(120)	VARCHAR2(120) NOT NULL	Source Input Value Prompt Table: EOEW_EDT_TRN_VW
9	EOEW_ALLOW_OVR	Character(1)	VARCHAR2(1) NOT NULL	Allow Map Override N=No Y=Yes
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.