EOEW_EXPR_VW (SQL View)	Index Back
ETL Source Expression view Used to support the ETL source data object field expression.

EOEW_EXPR_VW

(SQL View)

ETL Source Expression view

Used to support the ETL source data object field expression.

SELECT EOEW_SRCDONAME , SEQ_NUM , EOEW_SRC_WHEREUSED , EOEW_SRCTABLE , EOEW_SRCCOL , EOEW_SRCCOLALIAS , DESCR , FIELDTYPE , LENGTH , DECIMALPOS , EOEW_EXPR_FLG , EOEW_AGGREGATE_IND , EOEW_EXPR_STMT , LASTUPDOPRID , LASTUPDDTTM , EOEW_SYSMAINT_FLG , CREATEDTTM FROM PS_EOEW_SRCFIELD WHERE EOEW_EXPR_FLG = 'Y'

Related Language Record: EOEW_EXPRVWLNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOEW_SRCDONAME Character(30) VARCHAR2(30) NOT NULL Source Data Object
Prompt Table: EOEW_SRCDO

2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
Default Value: 0

3 EOEW_SRC_WHEREUSED Number(1,0) SMALLINT NOT NULL Used in SELECT List
Default Value: 1

4 EOEW_SRCTABLE Character(80) VARCHAR2(80) NOT NULL Source Record Name

5 EOEW_SRCCOL Character(80) VARCHAR2(80) NOT NULL Source Field Name

6 EOEW_SRCCOLALIAS Character(30) VARCHAR2(30) NOT NULL Column Alias

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description

8 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
Default Value: 0

9 LENGTH Number(5,0) INTEGER NOT NULL Length

10 DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions
Default Value: 0

11 EOEW_EXPR_FLG Character(1) VARCHAR2(1) NOT NULL Expression
Default Value: Y

12 EOEW_AGGREGATE_IND Character(1) VARCHAR2(1) NOT NULL Aggregate Function Indicator Flag
Y/N Table Edit

13 EOEW_EXPR_STMT Character(254) VARCHAR2(254) NOT NULL Expression Statement

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.

15 LASTUPDDTTM DateTime(26) TIMESTAMP 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.

16 EOEW_SYSMAINT_FLG Character(1) VARCHAR2(1) NOT NULL System Maintained
Default Value: N

17 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
Default Value: %datetime

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOEW_SRCDONAME	Character(30)	VARCHAR2(30) NOT NULL	Source Data Object Prompt Table: EOEW_SRCDO
2	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Default Value: 0
3	EOEW_SRC_WHEREUSED	Number(1,0)	SMALLINT NOT NULL	Used in SELECT List Default Value: 1
4	EOEW_SRCTABLE	Character(80)	VARCHAR2(80) NOT NULL	Source Record Name
5	EOEW_SRCCOL	Character(80)	VARCHAR2(80) NOT NULL	Source Field Name
6	EOEW_SRCCOLALIAS	Character(30)	VARCHAR2(30) NOT NULL	Column Alias
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	FIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type (from PSST0101 Ref.) Default Value: 0
9	LENGTH	Number(5,0)	INTEGER NOT NULL	Length
10	DECIMALPOS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions Default Value: 0
11	EOEW_EXPR_FLG	Character(1)	VARCHAR2(1) NOT NULL	Expression Default Value: Y
12	EOEW_AGGREGATE_IND	Character(1)	VARCHAR2(1) NOT NULL	Aggregate Function Indicator Flag Y/N Table Edit
13	EOEW_EXPR_STMT	Character(254)	VARCHAR2(254) NOT NULL	Expression Statement
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.
15	LASTUPDDTTM	DateTime(26)	TIMESTAMP	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.
16	EOEW_SYSMAINT_FLG	Character(1)	VARCHAR2(1) NOT NULL	System Maintained Default Value: N
17	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation Default Value: %datetime