EOEW_CODE_TBL

(SQL Table)
 Index Back

Translation Set table

Used to capture translation set or equivalent code values. Example for unit of measure - EA = Each, IN = Inch, GAL = Gallons.

  • Related Language Record: EOEW_CODE_T_LNG

  • Parent Record Of EOEW_CODE_ITEM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOEW_CODE_OBJ Character(50) VARCHAR2(50) NOT NULL Translation Set
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 EOEW_FAIL_TYP Character(1) VARCHAR2(1) NOT NULL Undefined Value Options
    0=Retain undefined data values
    1=Default for undefined values
    2=Do not load undefined values

    Default Value: 0

    4 EOEW_FAIL_VAL Character(254) VARCHAR2(254) NOT NULL Look up failure
    5 EOEW_SYSMAINT_FLG Character(1) VARCHAR2(1) NOT NULL System Maintained

    Y/N Table Edit

    Default Value: N

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

    Default Value: EOEW_OBJ_OWNER.EOEW_OBJ_OWNER

    Prompt Table: EOEW_OBJ_OWNER

    7 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

    8 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.
    9 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation

    Default Value: %DateTime

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

    Default Value: 1