EOEW_LU_JOIN_VW (SQL View)	Index Back
Transformation Definition

EOEW_LU_JOIN_VW

(SQL View)

Transformation Definition

SELECT EOEW_TRN_OBJ , SEQ_NUM , EOEW_TRN_INPT_TYP , EOEW_TRN_INPT_VAL , EOEW_OPER_TYP , EOEW_FLDVALUE , EOEW_LU_OPER_TYP , EOEW_LU_FLDNAME , EOEW_CODE_OBJ , EOEW_SYSMAINT_FLG , CREATEDTTM , LASTUPDDTTM , LASTUPDOPRID FROM PS_EOEW_TRN_ITEM WHERE EOEW_LU_FLDNAME <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOEW_TRN_OBJ Character(50) VARCHAR2(50) NOT NULL Transformation Object
Prompt Table: EOEW_TRN_DFN

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
Prompt Table: EOEW_SDOFLD_VW

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
Prompt Table: PSRECFIELD

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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOEW_TRN_OBJ	Character(50)	VARCHAR2(50) NOT NULL	Transformation Object Prompt Table: EOEW_TRN_DFN
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 Prompt Table: EOEW_SDOFLD_VW
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 Prompt Table: PSRECFIELD
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.