EOEW_OBJ_OWNER

(SQL Table)
Index Back

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.