EOEW_OBJ_OWNER (SQL Table)	Index Back
Subject Area Used to capture information about the Enterprise Warehouse Tools object owner.

EOEW_OBJ_OWNER

(SQL Table)

Subject Area

Used to capture information about the Enterprise Warehouse Tools object owner.

Related Language Record: EOEW_OBJOWNRLNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOEW_OBJ_OWNER Character(15) VARCHAR2(15) NOT NULL Subject Area

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

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

4 EOEW_OWNDFLT_FLG Character(1) VARCHAR2(1) NOT NULL Default Subject Area
Y/N Table Edit
Default Value: N

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

6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

7 DDLSPACENAME Character(30) VARCHAR2(30) NOT NULL Tablespace Name
Default Value: EOEW_OPTIONS.DDLSPACENAME
Prompt Table: EOEW_TBLSPCATVW

8 EOEW_OBJORIGINATOR Character(1) VARCHAR2(1) NOT NULL Originator
1=User Interface Created
2=API created
Default Value: 1

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

10 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

11 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_OBJ_OWNER	Character(15)	VARCHAR2(15) NOT NULL	Subject Area
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	EOEW_SYSMAINT_FLG	Character(1)	VARCHAR2(1) NOT NULL	System Maintained Y/N Table Edit Default Value: N
4	EOEW_OWNDFLT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Default Subject Area Y/N Table Edit Default Value: N
5	EOEW_CREATETBL	Character(1)	VARCHAR2(1) NOT NULL	Create Table Dynamically Y/N Table Edit Default Value: Y
6	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
7	DDLSPACENAME	Character(30)	VARCHAR2(30) NOT NULL	Tablespace Name Default Value: EOEW_OPTIONS.DDLSPACENAME Prompt Table: EOEW_TBLSPCATVW
8	EOEW_OBJORIGINATOR	Character(1)	VARCHAR2(1) NOT NULL	Originator 1=User Interface Created 2=API created Default Value: 1
9	CREATEDTTM	DateTime(26)	TIMESTAMP NOT NULL	DateTime of Query Creation Default Value: %datetime
10	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
11	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.