PSCOMPDEFN

index back

PeopleSoft Field NameField TypeColumn TypeDescription
PROJECTNAMECharacter(30)VARCHAR2(30) NOT NULLProject Name (see PSPROJECTDEFN).
PROJECTDESCRCharacter(30)VARCHAR2(30) NOT NULLProject Description
TGTSERVERNAMECharacter(48)VARCHAR2(48) NOT NULLTarget Server Name
TGTDBNAMECharacter(8)VARCHAR2(8) NOT NULLTarget Database Name
TGTOPRIDCharacter(30)VARCHAR2(30) NOT NULLTarget User ID
COMPRELEASECharacter(50)VARCHAR2(50) NOT NULLComparison Release
SRCCOMPRELDTTMDateTime(26)TIMESTAMPSource Comparison DtTm
TGTCOMPRELDTTMDateTime(26)TIMESTAMPTarget Comparison DtTm
COMPRELDTTMDateTime(26)TIMESTAMPComparison Date/Time
KEEPTGTNumber(5,0)INTEGER NOT NULLKeep Target Audits Indicator
TGTORIENTATIONNumber(5,0)INTEGER NOT NULLTarget Orientation
COMPARETYPENumber(5,0)INTEGER NOT NULLCompare Type
COMMITLIMITNumber(10,0)DECIMAL(10) NOT NULLUpgrade Project Commit Limit
REPORTFILTERNumber(10,0)DECIMAL(10) NOT NULLReport Filter
MAINTPROJNumber(3,0)SMALLINT NOT NULLMaintenance Project
SRCSERVERNAMECharacter(48)VARCHAR2(48) NOT NULLSource Server Name
SRCDBNAMECharacter(8)VARCHAR2(8) NOT NULLSource DB Name
SRCOPRIDCharacter(30)VARCHAR2(30) NOT NULLSource User ID
RUNDTTMDateTime(26)TIMESTAMPRun Date/Time
GUIDCharacter(36)VARCHAR2(36) NOT NULLUnique Identifier
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19