DFW_PT_CBL_INFO (SQL View)	Index Back
DF_GP_CBL_CHG The purpose of this is to list all the cobols modified and delivered by PeopleSoft maintenance.

DFW_PT_CBL_INFO

(SQL View)

DF_GP_CBL_CHG

The purpose of this is to list all the cobols modified and delivered by PeopleSoft maintenance.

SELECT DISTINCT A.PROJECTNAME ,A.LASTUPDDTTM ,C.APPLYOPRID ,B.OBJECTVALUE1 ,C.RELEASELABEL FROM PSPROJECTDEFN A , PSPROJECTITEM B , PS_MAINTENANCE_LOG C WHERE A.PROJECTNAME = B.PROJECTNAME AND A.PROJECTNAME = C.UPDATE_ID AND C.RELEASELABEL LIKE 'HRMS%' AND B.OBJECTVALUE2 LIKE 'COBOL%'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).

2 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

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

4 OBJECTVALUE1 Character(100) VARCHAR2(100) NOT NULL Object Value 1

5 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROJECTNAME	Character(30)	VARCHAR2(30) NOT NULL	Project Name (see PSPROJECTDEFN).
2	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
3	APPLYOPRID	Character(30)	VARCHAR2(30) NOT NULL	User that Applied Update
4	OBJECTVALUE1	Character(100)	VARCHAR2(100) NOT NULL	Object Value 1
5	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