PTUNIRVWMOLSTVW |
index back |
|---|---|
MO project list view |
| SELECT PROJECTNAME , OBJECTTYPE , OBJECTVALUE1 , OBJECTVALUE2 , OBJECTVALUE3 , OBJECTVALUE4 , UPGRADEACTION , TAKEACTION , SOURCESTATUS , TARGETSTATUS , COPYDONE FROM PSPROJECTITEM |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| PROJECTNAME | Character(30) | VARCHAR2(30) NOT NULL | Project Name (see PSPROJECTDEFN). |
| OBJECTTYPE | Number(5,0) | INTEGER NOT NULL | Object Type |
| OBJECTVALUE1 | Character(100) | VARCHAR2(100) NOT NULL | Object Value 1 |
| OBJECTVALUE2 | Character(100) | VARCHAR2(100) NOT NULL | Object Value 2 |
| OBJECTVALUE3 | Character(30) | VARCHAR2(30) NOT NULL | Object Value 3 |
| OBJECTVALUE4 | Character(30) | VARCHAR2(30) NOT NULL | Object Value 4 |
| UPGRADEACTION | Number(1,0) | SMALLINT NOT NULL | Upgrade Action |
| TAKEACTION | Number(1,0) | SMALLINT NOT NULL | Take Action |
| SOURCESTATUS | Number(1,0) | SMALLINT NOT NULL | Source Status |
| TARGETSTATUS | Number(1,0) | SMALLINT NOT NULL | Target Status |
| COPYDONE | Number(1,0) | SMALLINT NOT NULL | Copy Done |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |