PSPRJDEFN_VW

index back

PSPROJECTDEFN Table

Tracks all Project
SELECT PROJECTNAME , VERSION , PROJECTDESCR , TGTSERVERNAME , TGTDBNAME , TGTOPRID , TGTOPRACCT , COMPRELEASE , SRCCOMPRELDTTM , TGTCOMPRELDTTM , COMPRELDTTM , KEEPTGT , TGTORIENTATION , COMPARETYPE , COMMITLIMIT , REPORTFILTER , MAINTPROJ , LASTUPDDTTM , LASTUPDOPRID , RELEASELABEL , RELEASEDTTM , OBJECTOWNERID , DESCRLONG FROM PSPROJECTDEFN WHERE PROJECTNAME IN ( SELECT DISTINCT PROJECTNAME FROM PSPROJECTITEM WHERE OBJECTTYPE = 106)

  • Related language record: PSPRJDEFN_VWL
  • Parent record of PSPRJITEM_VW PSPROJADSBIND
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PROJECTNAMECharacter(30)VARCHAR2(30) NOT NULLProject Name (see PSPROJECTDEFN).
    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    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
    TGTOPRACCTCharacter(8)VARCHAR2(8) NOT NULLTarget Operator Account
    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
    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    RELEASELABELCharacter(50)VARCHAR2(50) NOT NULLRelease Label
    00=Core
    10=Education and Government
    18=Service Industries
    19=Comm., Transportation & Util
    20=Retail
    21=Performance Measurement
    22=HealthCare
    23=Student Administration
    25=U.S. Federal Govt
    26=Canadian Govt
    30=Intl Translations
    32=Netherlands
    33=United Kingdom
    34=Espanol/Spain
    35=France
    36=Portuguese
    37=Italy
    39=German
    50=South Africa
    60=Latin America Local
    61=Mexico
    62=Argentina
    63=Brazil
    81=Japanese
    88=Asia/Pacific
    99=PeopleSoft Select
    RELEASEDTTMDateTime(26)TIMESTAMPRelease Date/Time
    OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
    DESCRLONGLong CharacterCLOBLong Description
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19