EOEW_OPTIONS (SQL Table)	Index Back
ETL Installation options Set up ETL defaults for maximum number of rows used in preview (for SDO and map target results); overall default tablespace ( order of presedence as follows: 1. Map tablespace override. If not found, go to #2. 2. Subject area override. If not found, go to #3. 3. Installation option that is required so AE finds tablespace); checkbox whether dynamic table fuilding is allowed; duplicate row handling option; message set override used as default for transformation and map definition options.

EOEW_OPTIONS

(SQL Table)

ETL Installation options

Set up ETL defaults for maximum number of rows used in preview (for SDO and map target results); overall default tablespace ( order of presedence as follows: 1. Map tablespace override. If not found, go to #2. 2. Subject area override. If not found, go to #3. 3. Installation option that is required so AE finds tablespace); checkbox whether dynamic table fuilding is allowed; duplicate row handling option; message set override used as default for transformation and map definition options.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOEW_MAXROWLIMIT Number(4,0) SMALLINT NOT NULL Maximum number of rows used in preview (for SDO and map target results.

2 EOEW_CREATETBL Character(1) VARCHAR2(1) NOT NULL Create Table Dynamically
Y/N Table Edit
Default Value: Y

3 DDLSPACENAME Character(30) VARCHAR2(30) NOT NULL Tablespace Name
Prompt Table: EOEW_TBLSPCATVW

4 EOEW_DUP_OPT Character(1) VARCHAR2(1) NOT NULL Handling of duplicate rows If no error option EOEW_ERR_OPT="0", by defaults, then all duplicates will go to the target, EOEW_DUP_OPT ="0". If error option EOEW_ERR_OPT="1", (identify error), then EOEW_DUP_OPT may be "1" or "6" 1 - Identify duplicates as error rows (go to target table) 6 - Delete all duplicates If error option ="2", (error table provided), then EOEW_DUP_OPT can may be "1","2","3" or "6" 1 - Identify duplicates as error rows (go to error table) 2 - Select first duplicate row from each group (order by not implemented yet) 3 - Select last duplicate row from each group (order by not implemented yet) 6 - Delete all duplicates
0=Copy duplicate rows to target
1=Copy Duplicates to Error Table
2=Copy first row to Target
3=Copy last row to Target
4=Aggregate duplicate row
5=User Defined Function
6=Reject all duplicate rows
Default Value: 0

5 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table: EOEW_MSGSET_VW

6 EOEW_SYSMAINT_FLG Character(1) VARCHAR2(1) NOT NULL System Maintained
Y/N Table Edit
Default Value: N

7 EOEW_RUNTIME_VAL Character(1) VARCHAR2(1) NOT NULL Run-Time Validation Flag
Y/N Table Edit
Default Value: N

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_MAXROWLIMIT	Number(4,0)	SMALLINT NOT NULL	Maximum number of rows used in preview (for SDO and map target results.
2	EOEW_CREATETBL	Character(1)	VARCHAR2(1) NOT NULL	Create Table Dynamically Y/N Table Edit Default Value: Y
3	DDLSPACENAME	Character(30)	VARCHAR2(30) NOT NULL	Tablespace Name Prompt Table: EOEW_TBLSPCATVW
4	EOEW_DUP_OPT	Character(1)	VARCHAR2(1) NOT NULL	Handling of duplicate rows If no error option EOEW_ERR_OPT="0", by defaults, then all duplicates will go to the target, EOEW_DUP_OPT ="0". If error option EOEW_ERR_OPT="1", (identify error), then EOEW_DUP_OPT may be "1" or "6" 1 - Identify duplicates as error rows (go to target table) 6 - Delete all duplicates If error option ="2", (error table provided), then EOEW_DUP_OPT can may be "1","2","3" or "6" 1 - Identify duplicates as error rows (go to error table) 2 - Select first duplicate row from each group (order by not implemented yet) 3 - Select last duplicate row from each group (order by not implemented yet) 6 - Delete all duplicates 0=Copy duplicate rows to target 1=Copy Duplicates to Error Table 2=Copy first row to Target 3=Copy last row to Target 4=Aggregate duplicate row 5=User Defined Function 6=Reject all duplicate rows Default Value: 0
5	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog. Prompt Table: EOEW_MSGSET_VW
6	EOEW_SYSMAINT_FLG	Character(1)	VARCHAR2(1) NOT NULL	System Maintained Y/N Table Edit Default Value: N
7	EOEW_RUNTIME_VAL	Character(1)	VARCHAR2(1) NOT NULL	Run-Time Validation Flag Y/N Table Edit Default Value: N
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.