PTIASPRPTHEADVW

(SQL View)
 Index Back

BUG List

This table holds information about all BUGS fixed since GA

SELECT A.PTIASPRPTNO , A.PTIASPRPTNOBASE , A.PTIASPSPVERS , A.PTIASPRPTSUBJECT , A.PTIASPPRDID , A.PTIASPPRDCMP , A.PTIASPPRDSUBCMP , A.PTIASPRPTCREATEDT , A.PTIASPRPTFIXDT , A.PTIASPRPTPOSTDT , A.PTIASPRPTTYPECODE , A.PTIASPRPTTYPE , A.PTIASPRPTSEVCODE , A.PTIASPRPTSEVERITY , A.RELEASELABEL , B.PTIASPPRDGRPCD , B.PTIASPPRDCD , B.PTIASPPRDNAME , CASE D.PTIADIRTYFLAG WHEN 'Y' THEN 'D' ELSE NVL(C.PTIASPRPTCUSTFLAG , 'D') END , CASE E.PTIADIRTYFLAG WHEN 'Y' THEN 'D' ELSE NVL(C.PTIASPRPTTESTFLAG , 'D') END FROM PS_PTIASPRPTHEAD A , PS_PTIASPPRD B , PS_PTIARPTIMPTREPO C , PS_PTIACUSTCALCOPT D , PS_PTIATESTCALCOPT E WHERE A.PTIASPPRDID = B.PTIASPPRDID AND A.PTIASPRPTNO = C.PTIASPRPTNO (+) AND A.PTIASPRPTNO>1000 AND A.PTIASPRPTNO<600000000

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number

Prompt Table: PTIASPRPTHEADVW

2 PTIASPRPTNOBASE Number(10,0) DECIMAL(10) NOT NULL Base BUG Number
3 PTIASPSPVERS Number(5,0) INTEGER NOT NULL Numeric value for Patch Database Version Number
4 PTIASPRPTSUBJECT Character(240) VARCHAR2(240) NOT NULL Bug Subject
5 PTIASPPRDID Number(8,0) INTEGER NOT NULL Product ID
6 PTIASPPRDCMP Character(10) VARCHAR2(10) NOT NULL Product Component
7 PTIASPPRDSUBCMP Character(14) VARCHAR2(14) NOT NULL Product Sub Component
8 PTIASPRPTCREATEDT DateTime(26) TIMESTAMP Date this Bug was Created
9 PTIASPRPTFIXDT DateTime(26) TIMESTAMP Date this Bug was Fixed
10 PTIASPRPTPOSTDT DateTime(26) TIMESTAMP Date this Bug was Posted
11 PTIASPRPTTYPECODE Character(1) VARCHAR2(1) NOT NULL Bug Types
B=Bug
E=Enhancement
12 PTIASPRPTTYPE Character(30) VARCHAR2(30) NOT NULL BUG Type
13 PTIASPRPTSEVCODE Number(3,0) SMALLINT NOT NULL BUG Severity
14 PTIASPRPTSEVERITY Character(45) VARCHAR2(45) NOT NULL BUG Severity Description
15 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
16 PTIASPPRDGRPCD Character(12) VARCHAR2(12) NOT NULL Product Group
17 PTIASPPRDCD Character(8) VARCHAR2(8) NOT NULL Product
18 PTIASPPRDNAME Character(240) VARCHAR2(240) NOT NULL Product Name
19 PTIASPRPTCUSTFLAG Character(1) VARCHAR2(1) NOT NULL Custom Impact
A=Excluded
B=Included
D=Run Calc
N=No Impact
R=Requisite
20 PTIASPRPTTESTFLAG Character(1) VARCHAR2(1) NOT NULL Test Exists
A=Above Threshold
B=Below Threshod
D=Dirty Value
N=No Customization
R=Requisite