EOEW_SRCDO

(SQL Table)
 Index Back

EOEW SDO - Source Data Object

  • Related Language Record: EOEW_SRCDO_LNG

  • Parent Record Of EOEW_SRCTABLE EOEW_SRCTABL_VW EOEW_SRCTBL_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOEW_SRCDONAME Character(30) VARCHAR2(30) NOT NULL Source Data Object
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    4 EOEW_SRCDSTYPE Character(1) VARCHAR2(1) NOT NULL Data Source Type
    0=Local
    1=Database Link
    2=Remote

    Default Value: 0

    5 EOEW_SRCDSNAME Character(30) VARCHAR2(30) NOT NULL Data Source Name

    Prompt Table: PSREMOTEDBDEFN

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

    Prompt Table: EOEW_OBJ_OWNER

    7 EOEW_OBJORIGINATOR Character(1) VARCHAR2(1) NOT NULL Originator
    1=User Interface Created
    2=API created

    Default Value: 1

    8 EOEW_SYSMAINT_FLG Character(1) VARCHAR2(1) NOT NULL System Maintained

    Y/N Table Edit

    Default Value: N

    9 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation

    Default Value: %DateTime

    10 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.
    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.
    12 DESCRLONG Long Character CLOB Long Description