EOEW_CDTBVW_LNG

(SQL View)
 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.

SELECT DISTINCT B.EOEW_OBJ_OWNER , A.EOEW_CODE_OBJ , C.LANGUAGE_CD , C.DESCR FROM PS_EOEW_CODE_TBL A , PS_EOEW_OBJOWN_VW B , PS_EOEW_CODE_T_LNG C WHERE A.EOEW_OBJ_OWNER = B.EOEW_OBJ2_OWNER AND C.EOEW_CODE_OBJ = A.EOEW_CODE_OBJ

  • Related Language Record for EOEW_CODETBL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SUBOWNER Character(30) VARCHAR2(30) NOT NULL Subscription Owner
    2 EOEW_CODE_OBJ Character(50) VARCHAR2(50) NOT NULL Translation Set
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description