EOEW_SRCTFLD_VW

(SQL View)
 Index Back

SDO view for pg EOEW_SRCFIELD


SELECT EOEW_SRCDONAME ,EOEW_SRCTABLE ,EOEW_SRCCOL ,EOEW_SRCCOLALIAS ,SEQ_NUM ,EOEW_SRC_WHEREUSED ,FIELDTYPE ,LENGTH ,DECIMALPOS ,DESCR ,EOEW_EXPR_FLG ,EOEW_AGGREGATE_IND ,EOEW_EXPR_STMT ,EOEW_SYSMAINT_FLG ,CREATEDTTM ,LASTUPDDTTM ,LASTUPDOPRID FROM PS_EOEW_SRCFIELD WHERE EOEW_SRCTABLE <> 'EOEW_EXPR_VW'

  • Related Language Record: EOEW_SRCTFLDLNG

  • Parent record: EOEW_SRCTABL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOEW_SRCDONAME Character(30) VARCHAR2(30) NOT NULL Source Data Object
    2 EOEW_SRCTABLE Character(80) VARCHAR2(80) NOT NULL Source Record Name
    3 EOEW_SRCCOL Character(80) VARCHAR2(80) NOT NULL Source Field Name
    4 EOEW_SRCCOLALIAS Character(30) VARCHAR2(30) NOT NULL Column Alias
    5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    6 EOEW_SRC_WHEREUSED Number(1,0) SMALLINT NOT NULL Used in SELECT List
    7 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
    8 LENGTH Number(5,0) INTEGER NOT NULL Length
    9 DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    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
    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.