PTIASPTLSRELVW

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 Field Type Column Type Description
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
PTIASPTOOLSMAJOR Number(8,2) DECIMAL(7,2) NOT NULL PeopleTools Major Release
PTIASPTOOLSMINOR Number(5,0) INTEGER NOT NULL PeopleTools Minor Release
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19