EOEW_TRN_ITEM

(SQL Table)
Index Back

Transformation Definition

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOEW_TRN_OBJ Character(50) VARCHAR2(50) NOT NULL Transformation Object
2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
3 EOEW_TRN_INPT_TYP Character(2) VARCHAR2(2) NOT NULL Source object type.
00=Source
01=Transformation

Default Value: 00

4 EOEW_TRN_INPT_VAL Character(254) VARCHAR2(254) NOT NULL Source Input Value
5 EOEW_OPER_TYP Character(3) VARCHAR2(3) NOT NULL Operator
<=<
<==<=
<>=<>
===
>=>
>==>=
IN=IN
L=Like
NL=Not Like
6 EOEW_FLDVALUE Character(120) VARCHAR2(120) NOT NULL Field Value
7 EOEW_LU_OPER_TYP Character(3) VARCHAR2(3) NOT NULL Operator
<=<
<==<=
<>=<>
===
>=>
>==>=
IN=In List
L=Like
NL=Not Like
NN=Not In List

Default Value: =

8 EOEW_LU_FLDNAME Character(18) VARCHAR2(18) NOT NULL Look Up Field Name
9 EOEW_CODE_OBJ Character(50) VARCHAR2(50) NOT NULL Translation Set
10 EOEW_SYSMAINT_FLG Character(1) VARCHAR2(1) NOT NULL System Maintained
11 CREATEDTTM DateTime(26) TIMESTAMP NOT NULL DateTime of Query Creation

Default Value: %datetime

12 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

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