EC_TILEOWNER_VW

(SQL View)
 Index Back

Objectowner View


SELECT 'All' , 'All' , 'All' , 1 FROM PS_INSTALLATION UNION ALL SELECT A.objectownerid , CASE WHEN A.objectownerid = ' ' THEN ' ' ELSE B.XLATLONGNAME END , CASE WHEN A.objectownerid = ' ' THEN ' ' ELSE B.XLATSHORTNAME END , COUNT(*) FROM ps_ec_tile_setup A LEFT OUTER JOIN PS_WM_XLATTABLE_VW B ON A.objectownerid = b.fieldvalue AND B.fieldname='OBJECTOWNERID' GROUP BY A.objectownerid , B.XLATLONGNAME , B.XLATSHORTNAME

  • Related Language Record: EC_TILEOWNR_VWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    2 EC_OWNER_LONGNAME Character(30) VARCHAR2(30) NOT NULL Owner Description
    3 EC_OWNER_SHORTNAME Character(10) VARCHAR2(10) NOT NULL Owner Short Description
    4 EC_COUNT Number(7,0) INTEGER NOT NULL Count