PTIASPBUGBTAGVW

index back

Bug Product Tag View

Bugs by Tags
SELECT S.USERID , T.DBNAME , H.PTIASPRPTNO , H.PTIASPRPTNOBASE , H.PTIASPSPVERS , H.PTIASPRPTSUBJECT , H.PTIASPPRDID , H.PTIASPPRDCMP , H.PTIASPPRDSUBCMP , M.PTIASPPRDCMPNM , M.PTIASPPRDSUBCMPNM , H.PTIASPRPTCREATEDT , H.PTIASPRPTFIXDT , H.PTIASPCLSDDT , H.PTIASPRPTPOSTDT , H.PTIASPRPTTYPECODE , H.PTIASPRPTTYPE , H.PTIASPRPTSEVCODE , H.PTIASPRPTSEVERITY , H.RELEASELABEL , NVL2(L.PTIASPRPTNO , 'P' , 'N') AS PTIASPAPPLIED , L.PTIASPPKGAPPLYDT , P.PTIASPPRDGRPCD , P.PTIASPPRDCD , CASE WHEN SUBSTR(P.PTIASPPRDNAME , 1 , 22) = 'PeopleSoft Enterprise ' THEN SUBSTR(P.PTIASPPRDNAME , 23) ELSE P.PTIASPPRDNAME END , NVL2(I.PTIASPPRDCD , 'Y' , 'N') AS INSTALLEDCD , NVL(S.PTIASPRPTTAGNAME , ' ') , NVL(S.PTIASPRPTTAGVALUE , ' ') , NVL2(G.PTIASPRPTNO , 'E' , 'B') AS ENHANCEMENT FROM PS_PTIASPRPTHEAD H JOIN PS_PTIAUSERTGTSELS S ON H.PTIASPRPTNO >1000 AND H.PTIASPRPTNO <600000000 AND NOT EXISTS ( SELECT 'X' FROM PS_PTIASPRPTTAGS A WHERE A.PTIASPRPTNO=H.PTIASPRPTNO AND A.PTIASPRPTTAGNAME='Standard' AND A.PTIASPRPTTAGVALUE='Required At Upgrade') JOIN PS_PTIASPTARGETS T ON S.DBNAME =T.DBNAME LEFT JOIN PS_PTIASPLOGTGT L ON T.DBNAME=L.DBNAME AND H.PTIASPRPTNO=L.PTIASPRPTNO JOIN PS_PTIASPPRD P ON H.PTIASPPRDID=P.PTIASPPRDID LEFT JOIN PS_PTIASPINSTPRD I ON T.DBNAME =I.DBNAME AND P.PTIASPPRDGRPCD=I.PTIASPPRDGRPCD AND P.PTIASPPRDCD =I.PTIASPPRDCD LEFT JOIN ( SELECT PTIASPRPTNO FROM PS_PTIASPRPTTAGS WHERE PTIASPRPTTAGNAME='Enhancement' AND PTIASPRPTTAGVALUE='Enhancement') G ON H.PTIASPRPTNO=G.PTIASPRPTNO LEFT JOIN PS_PTIASP_SCOMP_VW M ON H.PTIASPPRDID=M.PTIASPPRDID AND H.PTIASPPRDCMP=M.PTIASPPRDCMP AND H.PTIASPPRDSUBCMP=M.PTIASPPRDSUBCMP JOIN PS_PTIASPRPTTAGS S ON H.PTIASPRPTNO = S.PTIASPRPTNO

PeopleSoft Field Name Field Type Column Type Description
USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number

Prompt Table: PTIASPRPTHEAD

PTIASPRPTNOBASE Number(10,0) DECIMAL(10) NOT NULL Base BUG Number
PTIASPSPVERS Number(5,0) INTEGER NOT NULL Numeric value for Patch Database Version Number
PTIASPRPTSUBJECT Character(240) VARCHAR2(240) NOT NULL Bug Subject
PTIASPPRDID Number(8,0) INTEGER NOT NULL Product ID
PTIASPPRDCMP Character(10) VARCHAR2(10) NOT NULL Product Component
PTIASPPRDSUBCMP Character(14) VARCHAR2(14) NOT NULL Product Sub Component
PTIASPPRDCMPNM Character(30) VARCHAR2(30) NOT NULL Product Component Name
PTIASPPRDSUBCMPNM Character(40) VARCHAR2(40) NOT NULL Product Sub Component
PTIASPRPTCREATEDT DateTime(26) TIMESTAMP Date this Bug was Created
PTIASPRPTFIXDT DateTime(26) TIMESTAMP Date this Bug was Fixed
PTIASPCLSDDT DateTime(26) TIMESTAMP Date this Bug was Closed
PTIASPRPTPOSTDT DateTime(26) TIMESTAMP Date this Bug was Posted
PTIASPRPTTYPECODE Character(1) VARCHAR2(1) NOT NULL Bug Types
B=Bug
E=Enhancement
PTIASPRPTTYPE Character(30) VARCHAR2(30) NOT NULL BUG Type
PTIASPRPTSEVCODE Number(3,0) SMALLINT NOT NULL BUG Severity
PTIASPRPTSEVERITY Character(45) VARCHAR2(45) NOT NULL BUG Severity 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
PTIASPAPPLIED Character(1) VARCHAR2(1) NOT NULL Apply Info
N=Unapplied
O=Other Products
P=Applied
PTIASPPKGAPPLYDT Date(10) DATE Apply Date
PTIASPPRDGRPCD Character(12) VARCHAR2(12) NOT NULL Product Group
PTIASPPRDCD Character(8) VARCHAR2(8) NOT NULL Product
PTIASPPRDNAME Character(240) VARCHAR2(240) NOT NULL Product Name
PTIASPPRDINSTCD Character(1) VARCHAR2(1) NOT NULL This field indicates whether a product is installed or not
N=Uninstalled
Y=Installed
PTIASPRPTTAGNAME Character(30) VARCHAR2(30) NOT NULL TAG Name
PTIASPRPTTAGVALUE Character(254) VARCHAR2(254) NOT NULL TAG Value
PTIASPENHFLAGCD Character(1) VARCHAR2(1) NOT NULL Enhancement Flag
B=Bugs
E=Enhancements
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20