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 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
RELEASEDTTMDateTime(26)TIMESTAMPRelease Date/Time
UPDATE_IDCharacter(30)VARCHAR2(30) NOT NULLUpdate ID
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
DTTM_IMPORTEDDateTime(26)TIMESTAMPImported Date Time
FIXOPRIDCharacter(30)VARCHAR2(30) NOT NULLUser that Created Update
APPLYOPRIDCharacter(30)VARCHAR2(30) NOT NULLUser that Applied Update
PRODUCT_LINECharacter(10)VARCHAR2(10) NOT NULLProduct Line
MAINTLOGTYPECharacter(4)VARCHAR2(4) NOT NULLLog 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
DESCRLONGLong CharacterCLOBLong Description
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19