PTSESSIONIDPTSESSIONTYPEADS=Data Set Session
MO=Managed Object Session
SRCDBNAMETGTDBNAMERUNDTTMPSCOMPSESSION |
index back |
|---|
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| PTSESSIONID |
Character(36) | VARCHAR2(36) NOT NULL | Compare Session Id |
| PROJECTNAME | Character(30) | VARCHAR2(30) NOT NULL | Project Name (see PSPROJECTDEFN). |
| PTSESSIONTYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Compare Session type
ADS=Data Set Session MO=Managed Object Session |
| SRCDBNAME |
Character(8) | VARCHAR2(8) NOT NULL | Source DB Name |
| TGTDBNAME |
Character(8) | VARCHAR2(8) NOT NULL | Target Database Name |
| RUNDTTM |
DateTime(26) | TIMESTAMP | Run Date/Time |
| PTLASTACTDTTM | DateTime(26) | TIMESTAMP | Last Action Dt Tm |
| PTREPNAME | Character(30) | VARCHAR2(30) NOT NULL | Repository Name |
| PTAREANAME | Character(254) | VARCHAR2(254) NOT NULL | File Name |
| DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| SRCOPRID | Character(30) | VARCHAR2(30) NOT NULL | Source User ID |
| TGTOPRID | Character(30) | VARCHAR2(30) NOT NULL | Target User ID |
| SRCSERVERNAME | Character(48) | VARCHAR2(48) NOT NULL | Source Server Name |
| TGTSERVERNAME | Character(48) | VARCHAR2(48) NOT NULL | Target Server Name |
| PTPRJSTATE | Character(4) | VARCHAR2(4) NOT NULL | Project State translate values |
| PTPRJTOTALCOUNT | Number(5,0) | INTEGER NOT NULL | Total Count of objects |
| PTPRJCURCOUNT | Number(5,0) | INTEGER NOT NULL | Current count of objects |
| PTPRJFILEDTTM | DateTime(26) | TIMESTAMP | File Last modified time |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |