EOEW_RULE_DFN (SQL Table)	Index Back
Map Rules Used to capture high level map definition attributes such as description, object ownerid, version and last updates.

EOEW_RULE_DFN

(SQL Table)

Map Rules

Used to capture high level map definition attributes such as description, object ownerid, version and last updates.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOEW_RULE_OBJ Character(50) VARCHAR2(50) NOT NULL Map Rule

2 EOEW_TAR_FLD Character(18) VARCHAR2(18) NOT NULL Target Field
Prompt Table: EOEW_PSFIELD_VW

3 EOEW_RULE_VAL Character(254) VARCHAR2(254) NOT NULL Rule value
Prompt Table: EOEW_PSFIELD_VW

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

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

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

7 EOEW_SRCCOLALIAS Character(30) VARCHAR2(30) NOT NULL Column Alias
Prompt Table: EOEW_SDOFLDS_VW

8 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: 03

9 EOEW_INPUT_VAL Character(120) VARCHAR2(120) NOT NULL Source Input Value
Prompt Table: %EDITTABLE

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

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

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

13 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive
Y/N Table Edit
Default Value: Y

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

15 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

16 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_RULE_OBJ	Character(50)	VARCHAR2(50) NOT NULL	Map Rule
2	EOEW_TAR_FLD	Character(18)	VARCHAR2(18) NOT NULL	Target Field Prompt Table: EOEW_PSFIELD_VW
3	EOEW_RULE_VAL	Character(254)	VARCHAR2(254) NOT NULL	Rule value Prompt Table: EOEW_PSFIELD_VW
4	EOEW_OBJ_OWNER	Character(15)	VARCHAR2(15) NOT NULL	Subject Area Prompt Table: EOEW_OBJ_OWNER
5	EOEW_TAR_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Target Object Prompt Table: PSRECDEFN
6	EOEW_SRC_FLD	Character(18)	VARCHAR2(18) NOT NULL	Source Field
7	EOEW_SRCCOLALIAS	Character(30)	VARCHAR2(30) NOT NULL	Column Alias Prompt Table: EOEW_SDOFLDS_VW
8	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: 03
9	EOEW_INPUT_VAL	Character(120)	VARCHAR2(120) NOT NULL	Source Input Value Prompt Table: %EDITTABLE
10	EOEW_ALLOW_OVR	Character(1)	VARCHAR2(1) NOT NULL	Allow Map Override N=No Y=Yes Default Value: Y
11	EOEW_SYSMAINT_FLG	Character(1)	VARCHAR2(1) NOT NULL	System Maintained Y/N Table Edit Default Value: N
12	EOEW_OBJORIGINATOR	Character(1)	VARCHAR2(1) NOT NULL	Originator 1=User Interface Created 2=API created Default Value: 1
13	ACTIVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Active Flag A=Active I=Inactive Y/N Table Edit Default Value: Y
14	CREATEDTTM	DateTime(26)	TIMESTAMP NOT NULL	DateTime of Query Creation Default Value: %datetime
15	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
16	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.