PTIASPTLSRELVW

(SQL View)
 Index Back

Tools Release

This view queries the maintenance log to determine the currect tools patch level

SELECT DISTINCT %Substring(releaselabel,-12) ,CAST (%Substring(releaselabel,-12,5) AS NUMBER) ,CAST (%Substring(releaselabel,-6,2) AS NUMBER) FROM PS_MAINTENANCE_LOG a ,( SELECT MAX(releasedttm) AS releasedttm FROM PS_MAINTENANCE_LOG WHERE releaselabel LIKE 'PeopleTools %' ) b WHERE a.releasedttm = b.releasedttm

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 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
2 PTIASPTOOLSMAJOR Number(8,2) DECIMAL(7,2) NOT NULL PeopleTools Major Release
3 PTIASPTOOLSMINOR Number(5,0) INTEGER NOT NULL PeopleTools Minor Release