PSCOMPDEFN

index back

PeopleSoft Field Name Field Type Column Type Description
PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
PROJECTDESCR Character(30) VARCHAR2(30) NOT NULL Project Description
TGTSERVERNAME Character(48) VARCHAR2(48) NOT NULL Target Server Name
TGTDBNAME Character(8) VARCHAR2(8) NOT NULL Target Database Name
TGTOPRID Character(30) VARCHAR2(30) NOT NULL Target User ID
COMPRELEASE Character(50) VARCHAR2(50) NOT NULL Comparison Release
SRCCOMPRELDTTM DateTime(26) TIMESTAMP Source Comparison DtTm
TGTCOMPRELDTTM DateTime(26) TIMESTAMP Target Comparison DtTm
COMPRELDTTM DateTime(26) TIMESTAMP Comparison Date/Time
KEEPTGT Number(5,0) INTEGER NOT NULL Keep Target Audits Indicator
TGTORIENTATION Number(5,0) INTEGER NOT NULL Target Orientation
COMPARETYPE Number(5,0) INTEGER NOT NULL Compare Type
COMMITLIMIT Number(10,0) DECIMAL(10) NOT NULL Upgrade Project Commit Limit
REPORTFILTER Number(10,0) DECIMAL(10) NOT NULL Report Filter
MAINTPROJ Number(3,0) SMALLINT NOT NULL Maintenance Project
SRCSERVERNAME Character(48) VARCHAR2(48) NOT NULL Source Server Name
SRCDBNAME Character(8) VARCHAR2(8) NOT NULL Source DB Name
SRCOPRID Character(30) VARCHAR2(30) NOT NULL Source User ID
RUNDTTM DateTime(26) TIMESTAMP Run Date/Time
GUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19