OBJECTOWNERIDPTGP_TILEOWN_VW(SQL View) |
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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OBJECTOWNERID |
Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 2 | PTGP_OWNER_LGNAME | Character(30) | VARCHAR2(30) NOT NULL | Owner Description |
| 3 | PTGP_OWNER_STNAME | Character(10) | VARCHAR2(10) NOT NULL | Owner Description |
| 4 | PTGP_COUNT | Number(7,0) | INTEGER NOT NULL | Count |