OBJECTOWNERIDPTGP_TILEOWN_VW |
index back |
|---|
| 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_PTPPB_GROUPLET A LEFT OUTER JOIN PS_PTGP_XLAT_VW B ON A.objectownerid = b.fieldvalue AND B.fieldname='OBJECTOWNERID' GROUP BY A.objectownerid , B.XLATLONGNAME , B.XLATSHORTNAME |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| OBJECTOWNERID |
Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier translate values |
| PTGP_OWNER_LGNAME | Character(30) | VARCHAR2(30) NOT NULL | Owner Description |
| PTGP_OWNER_STNAME | Character(10) | VARCHAR2(10) NOT NULL | Owner Description |
| PTGP_COUNT | Number(7,0) | INTEGER NOT NULL | Count |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |