PTUNIRVWMOLSTVW(SQL View) |
Index Back |
|---|---|
MO project list view |
| SELECT PROJECTNAME , OBJECTTYPE , OBJECTVALUE1 , OBJECTVALUE2 , OBJECTVALUE3 , OBJECTVALUE4 , UPGRADEACTION , TAKEACTION , SOURCESTATUS , TARGETSTATUS , COPYDONE FROM PSPROJECTITEM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROJECTNAME | Character(30) | VARCHAR2(30) NOT NULL | Project Name (see PSPROJECTDEFN). |
| 2 | OBJECTTYPE | Number(5,0) | INTEGER NOT NULL | Object Type |
| 3 | OBJECTVALUE1 | Character(100) | VARCHAR2(100) NOT NULL | Object Value 1 |
| 4 | OBJECTVALUE2 | Character(100) | VARCHAR2(100) NOT NULL | Object Value 2 |
| 5 | OBJECTVALUE3 | Character(30) | VARCHAR2(30) NOT NULL | Object Value 3 |
| 6 | OBJECTVALUE4 | Character(30) | VARCHAR2(30) NOT NULL | Object Value 4 |
| 7 | UPGRADEACTION | Number(1,0) | SMALLINT NOT NULL | Upgrade Action |
| 8 | TAKEACTION | Number(1,0) | SMALLINT NOT NULL | Take Action |
| 9 | SOURCESTATUS | Number(1,0) | SMALLINT NOT NULL | Source Status |
| 10 | TARGETSTATUS | Number(1,0) | SMALLINT NOT NULL | Target Status |
| 11 | COPYDONE | Number(1,0) | SMALLINT NOT NULL | Copy Done |