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 NameField TypeColumn TypeDescription
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
PTIASPTOOLSMAJORNumber(8,2)DECIMAL(7,2) NOT NULLPeopleTools Major Release
PTIASPTOOLSMINORNumber(5,0)INTEGER NOT NULLPeopleTools Minor Release
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19