EOEW_LU_DFN_VW

(SQL View)
 Index Back

Look up transformation defn

Lookup transformation record and output definition

SELECT EOEW_LU_OBJ , DESCR , EOEW_LU_RECNAME , EOEW_LU_FLDNAME , EOEW_LU_FLD_TYP , EOEW_AGG_DEF_TYP , EOEW_FAIL_VAL , EOEW_OBJREUSE_FLG , EOEW_SYSMAINT_FLG , EOEW_OBJ_OWNER , LASTUPDDTTM , LASTUPDOPRID , CREATEDTTM , EOEW_OBJORIGINATOR FROM PS_EOEW_LU_DFN

  • Related Language Record: EOEW_LUDFVW_LNG

  • Parent Record Of EOEW_LU_ITEM_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOEW_TRN_OBJ Character(50) VARCHAR2(50) NOT NULL Transformation Object
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 EOEW_LU_RECNAME Character(15) VARCHAR2(15) NOT NULL Look up record name

    Prompt Table: PSRECDEFN

    4 EOEW_LU_FLDNAME Character(18) VARCHAR2(18) NOT NULL Look Up Field Name

    Prompt Table: EOEW_LUFLST_VW

    5 EOEW_LU_FLD_TYP Character(1) VARCHAR2(1) NOT NULL Look Up field type
    1=Literal
    2=SQL Object

    Default Value: 1

    6 EOEW_AGG_DEF_TYP Character(2) VARCHAR2(2) NOT NULL Aggregation Type
    1=Distinct
    2=Minimum
    3=Maximum
    4=Count

    Default Value: 1

    7 EOEW_FAIL_VAL Character(254) VARCHAR2(254) NOT NULL Look up failure
    8 EOEW_OBJREUSE_FLG Character(1) VARCHAR2(1) NOT NULL Reuse Object

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Default Value: EOEW_OBJ_OWNER.EOEW_OBJ_OWNER

    Prompt Table: EOEW_OBJ_OWNER

    11 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.

    Default Value: %DATE

    12 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.

    Default Value: PSOPRDEFN.OPRID

    13 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation

    Default Value: %DateTime

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

    Default Value: 1