PROJECTNAMERUNDTTMITEMIDOBJECTTYPEDESCRGUIDPSCOMPITEM(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROJECTNAME |
Character(30) | VARCHAR2(30) NOT NULL | Project Name (see PSPROJECTDEFN). |
| 2 | RUNDTTM |
DateTime(26) | TIMESTAMP | Run Date/Time |
| 3 | ITEMID |
Character(30) | VARCHAR2(30) NOT NULL | Item ID |
| 4 | OBJECTTYPEDESCR |
Character(30) | VARCHAR2(30) NOT NULL | Object Type Descr |
| 5 | OBJECTVALUE1 | Character(100) | VARCHAR2(100) NOT NULL | Object Value 1 |
| 6 | OBJECTVALUE2 | Character(100) | VARCHAR2(100) NOT NULL | Object Value 2 |
| 7 | OBJECTVALUE3 | Character(30) | VARCHAR2(30) NOT NULL | Object Value 3 |
| 8 | OBJECTVALUE4 | Character(30) | VARCHAR2(30) NOT NULL | Object Value 4 |
| 9 | OBJECTVALUE5 | Character(30) | VARCHAR2(30) NOT NULL | Object Value 5 |
| 10 | SOURCESTATUS_TXT | Character(30) | VARCHAR2(30) NOT NULL | Source Status Text |
| 11 | TARGETSTATUS_TXT | Character(30) | VARCHAR2(30) NOT NULL | Target Status Text |
| 12 | UPGRADEACTION_TXT | Character(30) | VARCHAR2(30) NOT NULL | Upgrade Action Text |
| 13 | TAKEACTION_TXT | Character(30) | VARCHAR2(30) NOT NULL | Take Action Text |
| 14 | GUID |
Character(36) | VARCHAR2(36) NOT NULL | Unique Identifier |