PSCOMPSESSION

index back

PeopleSoft Field NameField TypeColumn TypeDescription
PTSESSIONIDCharacter(36)VARCHAR2(36) NOT NULLCompare Session Id
PROJECTNAMECharacter(30)VARCHAR2(30) NOT NULLProject Name (see PSPROJECTDEFN).
PTSESSIONTYPECharacter(4)VARCHAR2(4) NOT NULLCompare Session type
ADS=Data Set Session
MO=Managed Object Session
SRCDBNAMECharacter(8)VARCHAR2(8) NOT NULLSource DB Name
TGTDBNAMECharacter(8)VARCHAR2(8) NOT NULLTarget Database Name
RUNDTTMDateTime(26)TIMESTAMPRun Date/Time
PTLASTACTDTTMDateTime(26)TIMESTAMPLast Action Dt Tm
PTREPNAMECharacter(30)VARCHAR2(30) NOT NULLRepository Name
PTAREANAMECharacter(254)VARCHAR2(254) NOT NULLFile Name
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
SRCOPRIDCharacter(30)VARCHAR2(30) NOT NULLSource User ID
TGTOPRIDCharacter(30)VARCHAR2(30) NOT NULLTarget User ID
SRCSERVERNAMECharacter(48)VARCHAR2(48) NOT NULLSource Server Name
TGTSERVERNAMECharacter(48)VARCHAR2(48) NOT NULLTarget Server Name
PTPRJSTATECharacter(4)VARCHAR2(4) NOT NULLProject State translate values
PTPRJTOTALCOUNTNumber(5,0)INTEGER NOT NULLTotal Count of objects
PTPRJCURCOUNTNumber(5,0)INTEGER NOT NULLCurrent count of objects
PTPRJFILEDTTMDateTime(26)TIMESTAMPFile Last modified time
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19