EOEW_LU_ITEM_VW (SQL View)	Index Back
Lookup Definition

EOEW_LU_ITEM_VW

(SQL View)

Lookup Definition

SELECT EOEW_LU_OBJ , SEQ_NUM , EOEW_LU_FLDNAME , EOEW_OPER_TYP , EOEW_FLDVALUE , EOEW_LU_FLD_TYP , EOEW_SYSMAINT_FLG , CREATEDTTM , LASTUPDDTTM , LASTUPDOPRID FROM PS_EOEW_LU_ITEM

Parent record: EOEW_LU_DFN_VW

# 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
Default Value: 1

3 EOEW_LU_FLDNAME Character(18) VARCHAR2(18) NOT NULL Look Up Field Name
Prompt Table: PSRECDEFN

4 EOEW_OPER_TYP Character(3) VARCHAR2(3) NOT NULL Operator
<=<
<==<=
<>=<>
===
>=>
>==>=
IN=IN
L=Like
NL=Not Like

5 EOEW_FLDVALUE Character(120) VARCHAR2(120) NOT NULL Field Value

6 EOEW_LU_FLD_TYP Character(1) VARCHAR2(1) NOT NULL Look Up field type
1=Literal
2=SQL Object
Default Value: 1

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

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

9 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

10 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
2	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Default Value: 1
3	EOEW_LU_FLDNAME	Character(18)	VARCHAR2(18) NOT NULL	Look Up Field Name Prompt Table: PSRECDEFN
4	EOEW_OPER_TYP	Character(3)	VARCHAR2(3) NOT NULL	Operator <=< <==<= <>=<> === >=> >==>= IN=IN L=Like NL=Not Like
5	EOEW_FLDVALUE	Character(120)	VARCHAR2(120) NOT NULL	Field Value
6	EOEW_LU_FLD_TYP	Character(1)	VARCHAR2(1) NOT NULL	Look Up field type 1=Literal 2=SQL Object Default Value: 1
7	EOEW_SYSMAINT_FLG	Character(1)	VARCHAR2(1) NOT NULL	System Maintained
8	CREATEDTTM	DateTime(26)	TIMESTAMP NOT NULL	DateTime of Query Creation Default Value: %datetime
9	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
10	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.