PSPTTSTCMPRPT(SQL Table) |
Index Back |
|---|---|
Test Compare ReportPeopleSoft Test Compare Report |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | USERID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 2 | PTSESSIONID | Character(36) | VARCHAR2(36) NOT NULL | Compare Session Id |
| 3 | PTTST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Test Name (see PSPTTSTDEFN). |
| 4 | PTTST_CASE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Test Case Name |
| 5 | PTTST_CMD_ID_CHAR | Character(5) | VARCHAR2(5) NOT NULL | Scr Command ID |
| 6 | ATTRIBUTE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Attribute Name |
| 7 | PTTST_CMPSRCVAL | Character(254) | VARCHAR2(254) NOT NULL | Source |
| 8 | PTLOCALVALTYPE | Number(3,0) | SMALLINT NOT NULL | Source Value Type |
| 9 | PTTST_CMPTGTVAL | Character(254) | VARCHAR2(254) NOT NULL | Target |
| 10 | PTREMOTEVALTYPE | Number(3,0) | SMALLINT NOT NULL | Target Value Type |
| 11 | SEQNO | Number(5,0) | INTEGER NOT NULL | Sequence Number |