PSPRJDEFN_VWL

(SQL View)
 Index Back

PSPROJECTDEFN Table

Tracks all Project

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

  • Related Language Record for PSPRJDEFN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    4 PROJECTDESCR Character(30) VARCHAR2(30) NOT NULL Project Description
    5 TGTSERVERNAME Character(48) VARCHAR2(48) NOT NULL Target Server Name
    6 TGTDBNAME Character(8) VARCHAR2(8) NOT NULL Target Database Name
    7 TGTOPRID Character(30) VARCHAR2(30) NOT NULL Target User ID
    8 TGTOPRACCT Character(8) VARCHAR2(8) NOT NULL Target Operator Account
    9 COMPRELEASE Character(50) VARCHAR2(50) NOT NULL Comparison Release
    10 SRCCOMPRELDTTM DateTime(26) TIMESTAMP Source Comparison DtTm
    11 TGTCOMPRELDTTM DateTime(26) TIMESTAMP Target Comparison DtTm
    12 COMPRELDTTM DateTime(26) TIMESTAMP Comparison Date/Time
    13 KEEPTGT Number(5,0) INTEGER NOT NULL Keep Target Audits Indicator
    14 TGTORIENTATION Number(5,0) INTEGER NOT NULL Target Orientation
    15 COMPARETYPE Number(5,0) INTEGER NOT NULL Compare Type
    16 COMMITLIMIT Number(10,0) DECIMAL(10) NOT NULL Upgrade Project Commit Limit
    17 REPORTFILTER Number(10,0) DECIMAL(10) NOT NULL Report Filter
    18 MAINTPROJ Number(3,0) SMALLINT NOT NULL Maintenance Project
    19 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies 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.
    20 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies 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.
    21 RELEASELABEL Character(50) VARCHAR2(50) NOT NULL Release 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
    22 RELEASEDTTM DateTime(26) TIMESTAMP Release Date/Time
    23 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    24 DESCRLONG Long Character CLOB Long Description