MAINTLOGREL_VW

index back

SELECT RELEASELABEL , RELEASEDTTM , UPDATE_ID , DESCR , DTTM_IMPORTED , FIXOPRID , APPLYOPRID , PRODUCT_LINE , MAINTLOGTYPE , %TextIn(DESCRLONG) FROM PS_MAINTENANCE_LOG

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
RELEASEDTTM DateTime(26) TIMESTAMP Release Date/Time
UPDATE_ID Character(30) VARCHAR2(30) NOT NULL Update ID
DESCR Character(30) VARCHAR2(30) NOT NULL Description
DTTM_IMPORTED DateTime(26) TIMESTAMP Imported Date Time
FIXOPRID Character(30) VARCHAR2(30) NOT NULL User that Created Update
APPLYOPRID Character(30) VARCHAR2(30) NOT NULL User that Applied Update
PRODUCT_LINE Character(10) VARCHAR2(10) NOT NULL Product Line
MAINTLOGTYPE Character(4) VARCHAR2(4) NOT NULL Log Type
CAIP=CA Job Started
CAOK=CA Job Successful
CAOV=Override Requisite
IDEC=IDE Project Copy
NPID=Non-Primary Update
NPIP=Non-Primary Update IP
USR1=User Applied
DESCRLONG Long Character CLOB Long Description
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19