PSCOMPSESSION

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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19