MAINTLOGREL_VW

(SQL View)

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

# 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 RELEASEDTTM DateTime(26) TIMESTAMP Release Date/Time

3 UPDATE_ID Character(30) VARCHAR2(30) NOT NULL Update ID

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 DTTM_IMPORTED DateTime(26) TIMESTAMP Imported Date Time

6 FIXOPRID Character(30) VARCHAR2(30) NOT NULL User that Created Update

7 APPLYOPRID Character(30) VARCHAR2(30) NOT NULL User that Applied Update

8 PRODUCT_LINE Character(10) VARCHAR2(10) NOT NULL Product Line

9 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

10 DESCRLONG Long Character CLOB Long Description

#	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	RELEASEDTTM	DateTime(26)	TIMESTAMP	Release Date/Time
3	UPDATE_ID	Character(30)	VARCHAR2(30) NOT NULL	Update ID
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DTTM_IMPORTED	DateTime(26)	TIMESTAMP	Imported Date Time
6	FIXOPRID	Character(30)	VARCHAR2(30) NOT NULL	User that Created Update
7	APPLYOPRID	Character(30)	VARCHAR2(30) NOT NULL	User that Applied Update
8	PRODUCT_LINE	Character(10)	VARCHAR2(10) NOT NULL	Product Line
9	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
10	DESCRLONG	Long Character	CLOB	Long Description