EOEW_CVT_DFN (SQL Table)	Index Back
Conversion Definition Define valid from and to datatypes used by the ETL Engine. The table will be delivered with system data.

EOEW_CVT_DFN

(SQL Table)

Conversion Definition

Define valid from and to datatypes used by the ETL Engine. The table will be delivered with system data.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOEW_CVT_FROM_TYP Number(3,0) SMALLINT NOT NULL Convert From Field Type

2 EOEW_CVT_TO_TYP Number(3,0) SMALLINT NOT NULL Convert To Field Type

3 PLATFORMID Number(2,0) SMALLINT NOT NULL Platform ID
0=SQLBase
1=DB2
2=Oracle
3=Informix
4=DB2/Unix
5=ALLBASE
6=Sybase
7=Microsoft
8=DB2/400

4 EOEW_CVT_VALID Character(1) VARCHAR2(1) NOT NULL Valid Conversion Switch
0=Valid
1=Warning
2=Error
Default Value: 0

5 EOEW_ROW_PROC_FLG Character(1) VARCHAR2(1) NOT NULL Row Process Flag
Y/N Table Edit
Default Value: N

6 EOEW_CVT_EXPR Character(254) VARCHAR2(254) NOT NULL Conversion Expression

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

8 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

9 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_CVT_FROM_TYP	Number(3,0)	SMALLINT NOT NULL	Convert From Field Type
2	EOEW_CVT_TO_TYP	Number(3,0)	SMALLINT NOT NULL	Convert To Field Type
3	PLATFORMID	Number(2,0)	SMALLINT NOT NULL	Platform ID 0=SQLBase 1=DB2 2=Oracle 3=Informix 4=DB2/Unix 5=ALLBASE 6=Sybase 7=Microsoft 8=DB2/400
4	EOEW_CVT_VALID	Character(1)	VARCHAR2(1) NOT NULL	Valid Conversion Switch 0=Valid 1=Warning 2=Error Default Value: 0
5	EOEW_ROW_PROC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Row Process Flag Y/N Table Edit Default Value: N
6	EOEW_CVT_EXPR	Character(254)	VARCHAR2(254) NOT NULL	Conversion Expression
7	CREATEDTTM	DateTime(26)	TIMESTAMP NOT NULL	DateTime of Query Creation Default Value: %datetime
8	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
9	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.