EC_TILEOWNR_VWL

(SQL View)
 Index Back

Objectowner view


SELECT 'All' , 'ENG' , 'All' , 'All' FROM PS_INSTALLATION UNION ALL SELECT A.objectownerid , B.LANGUAGE_CD , CASE WHEN A.objectownerid = ' ' THEN ' ' ELSE B.XLATLONGNAME END , CASE WHEN A.objectownerid = ' ' THEN ' ' ELSE B.XLATSHORTNAME END FROM ps_ec_tile_setup A LEFT OUTER JOIN ps_WM_XLATITEM_VWL B ON A.objectownerid = b.fieldvalue AND B.fieldname='OBJECTOWNERID' GROUP BY A.objectownerid , B.LANGUAGE_CD , B.XLATLONGNAME , B.XLATSHORTNAME

  • Related Language Record for EC_TILEOWNER_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EC_OWNER_LONGNAME Character(30) VARCHAR2(30) NOT NULL Owner Description
    4 EC_OWNER_SHORTNAME Character(10) VARCHAR2(10) NOT NULL Owner Short Description