EOEW_SRCFIELD

(SQL Table)
Index Back

EOEW SDO Field metadata

  • Related Language Record: EOEW_SRCFLD_LNG
  • Parent record: EOEW_SRCTABLE
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOEW_SRCDONAME Character(30) VARCHAR2(30) NOT NULL Source Data Object
    2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 EOEW_SRC_WHEREUSED Number(1,0) SMALLINT NOT NULL Used in SELECT List
    5 EOEW_SRCTABLE Character(80) VARCHAR2(80) NOT NULL Source Record Name
    6 EOEW_SRCCOL Character(80) VARCHAR2(80) NOT NULL Source Field Name
    7 EOEW_SRCCOLALIAS Character(30) VARCHAR2(30) NOT NULL Column Alias
    8 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
    9 LENGTH Number(5,0) INTEGER NOT NULL Length
    10 DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions
    11 EOEW_EXPR_FLG Character(1) VARCHAR2(1) NOT NULL Expression
    12 EOEW_AGGREGATE_IND Character(1) VARCHAR2(1) NOT NULL Aggregate Function Indicator Flag
    13 EOEW_EXPR_STMT Character(254) VARCHAR2(254) NOT NULL Expression Statement
    14 EOEW_SYSMAINT_FLG Character(1) VARCHAR2(1) NOT NULL System Maintained

    Y/N Table Edit

    Default Value: N

    15 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
    16 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.
    17 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.