PTIAPCMPROG_VW(SQL View) |
Index Back |
|---|---|
PeopleCode Program |
| SELECT PSPROJECTITEM.PROJECTNAME , PSPCMPROG.OBJECTID1 , PSPCMPROG.OBJECTVALUE1 , PSPCMPROG.OBJECTID2 , PSPCMPROG.OBJECTVALUE2 , PSPCMPROG.OBJECTID3 , PSPCMPROG.OBJECTVALUE3 , PSPCMPROG.OBJECTID4 , PSPCMPROG.OBJECTVALUE4 , PSPCMPROG.OBJECTID5 , PSPCMPROG.OBJECTVALUE5 , PSPCMPROG.OBJECTID6 , PSPCMPROG.OBJECTVALUE6 , PSPCMPROG.OBJECTID7 , PSPCMPROG.OBJECTVALUE7 , PSPCMPROG.PROGSEQ , PSPCMPROG.VERSION , PSPCMPROG.NAMECOUNT , PSPCMPROG.PROGLEN , PSPCMPROG.PROGRUNLOC , PSPCMPROG.PROGFLAGS , PSPCMPROG.LICENSE_CODE , PSPCMPROG.LASTUPDDTTM , PSPCMPROG.LASTUPDOPRID , PSPCMPROG.PROGEXTENDS , PSPCMPROG.PTTOOLSREL , PSPCMPROG.PROGTXT FROM PSPCMPROG , PSPROJECTITEM WHERE PSPCMPROG.OBJECTVALUE1 = PSPROJECTITEM.OBJECTVALUE1 AND PSPCMPROG.OBJECTVALUE2 = PSPROJECTITEM.OBJECTVALUE2 AND PSPCMPROG.OBJECTVALUE3 = PSPROJECTITEM.OBJECTVALUE3 AND PSPCMPROG.OBJECTVALUE4 = PSPROJECTITEM.OBJECTVALUE4 AND PSPROJECTITEM.OBJECTTYPE IN (8,9,39,40,41,42,44,45,46,47,66) UNION ALL SELECT PSPROJECTITEM.PROJECTNAME , PSPCMPROG.OBJECTID1 , PSPCMPROG.OBJECTVALUE1 , PSPCMPROG.OBJECTID2 , PSPCMPROG.OBJECTVALUE2 , PSPCMPROG.OBJECTID3 , PSPCMPROG.OBJECTVALUE3 , PSPCMPROG.OBJECTID4 , PSPCMPROG.OBJECTVALUE4 , PSPCMPROG.OBJECTID5 , PSPCMPROG.OBJECTVALUE5 , PSPCMPROG.OBJECTID6 , PSPCMPROG.OBJECTVALUE6 , PSPCMPROG.OBJECTID7 , PSPCMPROG.OBJECTVALUE7 , PSPCMPROG.PROGSEQ , PSPCMPROG.VERSION , PSPCMPROG.NAMECOUNT , PSPCMPROG.PROGLEN , PSPCMPROG.PROGRUNLOC , PSPCMPROG.PROGFLAGS , PSPCMPROG.LICENSE_CODE , PSPCMPROG.LASTUPDDTTM , PSPCMPROG.LASTUPDOPRID , PSPCMPROG.PROGEXTENDS , PSPCMPROG.PTTOOLSREL , PSPCMPROG.PROGTXT FROM PSPCMPROG , PSPROJECTITEM WHERE PSPCMPROG.OBJECTVALUE1 = PSPROJECTITEM.OBJECTVALUE1 AND rpad(PSPCMPROG.OBJECTVALUE2, 8, ' ')%Concat PSPCMPROG.OBJECTVALUE3 %Concat rpad(PSPCMPROG.OBJECTVALUE4, 9, ' ') %Concat PSPCMPROG.Objectvalue5 = PSPROJECTITEM.OBJECTVALUE2 AND PSPCMPROG.OBJECTVALUE6 = PSPROJECTITEM.OBJECTVALUE3 AND PSPCMPROG.OBJECTVALUE7 = PSPROJECTITEM.OBJECTVALUE4 AND PSPROJECTITEM.OBJECTTYPE IN (43) UNION ALL SELECT PSPROJECTITEM.PROJECTNAME , PSPCMPROG.OBJECTID1 , PSPCMPROG.OBJECTVALUE1 , PSPCMPROG.OBJECTID2 , PSPCMPROG.OBJECTVALUE2 , PSPCMPROG.OBJECTID3 , PSPCMPROG.OBJECTVALUE3 , PSPCMPROG.OBJECTID4 , PSPCMPROG.OBJECTVALUE4 , PSPCMPROG.OBJECTID5 , PSPCMPROG.OBJECTVALUE5 , PSPCMPROG.OBJECTID6 , PSPCMPROG.OBJECTVALUE6 , PSPCMPROG.OBJECTID7 , PSPCMPROG.OBJECTVALUE7 , PSPCMPROG.PROGSEQ , PSPCMPROG.VERSION , PSPCMPROG.NAMECOUNT , PSPCMPROG.PROGLEN , PSPCMPROG.PROGRUNLOC , PSPCMPROG.PROGFLAGS , PSPCMPROG.LICENSE_CODE , PSPCMPROG.LASTUPDDTTM , PSPCMPROG.LASTUPDOPRID , PSPCMPROG.PROGEXTENDS , PSPCMPROG.PTTOOLSREL , PSPCMPROG.PROGTXT FROM PSPCMPROG , PSPROJECTITEM WHERE PSPCMPROG.OBJECTVALUE1 = PSPROJECTITEM.OBJECTVALUE1 AND PSPCMPROG.OBJECTVALUE2 = PSPROJECTITEM.OBJECTVALUE2 AND PSPCMPROG.OBJECTVALUE3 = PSPROJECTITEM.OBJECTVALUE3 AND rpad(PSPCMPROG.OBJECTVALUE4,18,' ' ) %Concat PSPCMPROG.OBJECTVALUE5 = PSPROJECTITEM.OBJECTVALUE4 AND PSPROJECTITEM.OBJECTTYPE IN(48) UNION ALL SELECT PSPROJECTITEM.PROJECTNAME , PSPCMPROG.OBJECTID1 , PSPCMPROG.OBJECTVALUE1 , PSPCMPROG.OBJECTID2 , PSPCMPROG.OBJECTVALUE2 , PSPCMPROG.OBJECTID3 , PSPCMPROG.OBJECTVALUE3 , PSPCMPROG.OBJECTID4 , PSPCMPROG.OBJECTVALUE4 , PSPCMPROG.OBJECTID5 , PSPCMPROG.OBJECTVALUE5 , PSPCMPROG.OBJECTID6 , PSPCMPROG.OBJECTVALUE6 , PSPCMPROG.OBJECTID7 , PSPCMPROG.OBJECTVALUE7 , PSPCMPROG.PROGSEQ , PSPCMPROG.VERSION , PSPCMPROG.NAMECOUNT , PSPCMPROG.PROGLEN , PSPCMPROG.PROGRUNLOC , PSPCMPROG.PROGFLAGS , PSPCMPROG.LICENSE_CODE , PSPCMPROG.LASTUPDDTTM , PSPCMPROG.LASTUPDOPRID , PSPCMPROG.PROGEXTENDS , PSPCMPROG.PTTOOLSREL , PSPCMPROG.PROGTXT FROM PSPCMPROG , PSPROJECTITEM WHERE PSPCMPROG.OBJECTVALUE1 = PSPROJECTITEM.OBJECTVALUE1 AND PSPCMPROG.OBJECTVALUE2 = PSPROJECTITEM.OBJECTVALUE2 AND replace(PSPCMPROG.OBJECTVALUE3 , 'OnExecute', ' ') = PSPROJECTITEM.OBJECTVALUE3 AND replace(PSPCMPROG.OBJECTVALUE4 , 'OnExecute', ' ') = PSPROJECTITEM.OBJECTVALUE4 AND PSPROJECTITEM.OBJECTTYPE IN(58) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROJECTNAME | Character(30) | VARCHAR2(30) NOT NULL | Project Name (see PSPROJECTDEFN). |
| 2 |  OBJECTID1 |
Number(5,0) | INTEGER NOT NULL |
Object Id 1
1=Record 2=Field 3=Menu 4=Bar Name 5=Item Name 9=Page 10=Component 12=Event 20=Database Type 21=Effective Date 39=Market 60=Message 66=Application Engine Program 74=Component Interface 77=Section 78=Step 87=Subscription 104=Application Package 105=Class 106=Class 107=Class |
| 3 | OBJECTVALUE1 |
Character(100) | VARCHAR2(100) NOT NULL | Object Value 1 |
| 4 | OBJECTID2 |
Number(5,0) | INTEGER NOT NULL | Object Id 2, as OBJECTID1 |
| 5 | OBJECTVALUE2 |
Character(100) | VARCHAR2(100) NOT NULL | Object Value 2 |
| 6 | OBJECTID3 |
Number(5,0) | INTEGER NOT NULL | Object Id 3, as OBJECTID1 |
| 7 | OBJECTVALUE3 |
Character(30) | VARCHAR2(30) NOT NULL | Object Value 3 |
| 8 | OBJECTID4 |
Number(5,0) | INTEGER NOT NULL | Object Id 4, as OBJECTID1 |
| 9 | OBJECTVALUE4 |
Character(30) | VARCHAR2(30) NOT NULL | Object Value 4 |
| 10 | OBJECTID5 |
Number(5,0) | INTEGER NOT NULL | Object Id 5, as OBJECTID1 |
| 11 | OBJECTVALUE5 |
Character(30) | VARCHAR2(30) NOT NULL | Object Value 5 |
| 12 | OBJECTID6 |
Number(5,0) | INTEGER NOT NULL | Object Id 6, as OBJECTID1 |
| 13 | OBJECTVALUE6 |
Character(30) | VARCHAR2(30) NOT NULL | Object Value 6 |
| 14 | OBJECTID7 |
Number(5,0) | INTEGER NOT NULL | Object Id 7, as OBJECTID1 |
| 15 | OBJECTVALUE7 |
Character(30) | VARCHAR2(30) NOT NULL | Object Value 7 |
| 16 | PROGSEQ |
Number(3,0) | SMALLINT NOT NULL | Program Sequence |
| 17 | VERSION | Number(10,0) | DECIMAL(10) NOT NULL | Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference |
| 18 | NAMECOUNT | Number(4,0) | SMALLINT NOT NULL | Reference Count |
| 19 | PROGLEN | Number(10,0) | DECIMAL(10) NOT NULL | PeopleCode Program Length |
| 20 | PROGRUNLOC | Number(3,0) | SMALLINT NOT NULL | Program Run Location |
| 21 | PROGFLAGS | Number(5,0) | INTEGER NOT NULL | Program flags |
| 22 | LICENSE_CODE | Character(64) | VARCHAR2(64) NOT NULL | License Code |
| 23 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 24 | LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 25 | PROGEXTENDS | Character(124) | VARCHAR2(124) NOT NULL | Class this program extends |
| 26 | PROGTXT | Long Character(28000) | CLOB | PeopleCode Program |
| 27 | PTTOOLSREL | Character(254) | VARCHAR2(254) NOT NULL | Tools Release Field |