PSCOMPITEMDATA(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 | RPTKEY1 | Character(100) | VARCHAR2(100) NOT NULL | Report Key 1 |
| 5 | RPTKEY2 | Character(100) | VARCHAR2(100) NOT NULL | Report Key 2 |
| 6 | RPTKEY3 | Character(100) | VARCHAR2(100) NOT NULL | Report Key 3 |
| 7 | RPTKEY4 | Character(100) | VARCHAR2(100) NOT NULL | Report Key 4 |
| 8 | RPTKEY5 | Character(100) | VARCHAR2(100) NOT NULL | Report Key 5 |
| 9 | RPTKEY6 | Character(30) | VARCHAR2(30) NOT NULL | Report Key 6 |
| 10 | RPTKEY7 | Character(30) | VARCHAR2(30) NOT NULL | Report Key 7 |
| 11 | RPTKEY8 | Character(30) | VARCHAR2(30) NOT NULL | Report Key 8 |
| 12 | RPTKEY9 | Character(30) | VARCHAR2(30) NOT NULL | Report Key 9 |
| 13 | RPTKEY10 | Character(30) | VARCHAR2(30) NOT NULL | Report Key 10 |
| 14 | ATTRIBUTE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Attribute Name |
| 15 | LINENUM | Number(3,0) | SMALLINT NOT NULL | Line Number |
| 16 | SRCOBJVALUE | Character(254) | VARCHAR2(254) NOT NULL | Source Object Value |
| 17 | TGTOBJVALUE | Character(254) | VARCHAR2(254) NOT NULL | Target Object Value |
| 18 | DIFFVALUE | Character(30) | VARCHAR2(30) NOT NULL | Difference Value |
| 19 | GUID | Character(36) | VARCHAR2(36) NOT NULL | Unique Identifier |