PTIASPRPTHEADVW

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 FROM PS_PTIASPRPTHEAD A , PS_PTIASPPRD B WHERE A.PTIASPPRDID = B.PTIASPPRDID AND A.PTIASPRPTNO > 1000

PeopleSoft Field NameField TypeColumn TypeDescription
PTIASPRPTNONumber(10,0)DECIMAL(10) NOT NULLBUG Number

Prompt Table: PTIASPRPTHEADVW

PTIASPRPTNOBASENumber(10,0)DECIMAL(10) NOT NULLBase BUG Number
PTIASPSPVERSNumber(5,0)INTEGER NOT NULLNumeric value for Patch Database Version Number
PTIASPRPTSUBJECTCharacter(80)VARCHAR2(80) NOT NULLBug Subject
PTIASPPRDIDNumber(8,0)INTEGER NOT NULLProduct ID
PTIASPPRDCMPCharacter(10)VARCHAR2(10) NOT NULLProduct Component
PTIASPPRDSUBCMPCharacter(14)VARCHAR2(14) NOT NULLProduct Sub Component
PTIASPRPTCREATEDTDateTime(26)TIMESTAMPDate this Bug was Created
PTIASPRPTFIXDTDateTime(26)TIMESTAMPDate this Bug was Fixed
PTIASPRPTPOSTDTDateTime(26)TIMESTAMPDate this Bug was Posted
PTIASPRPTTYPECODECharacter(1)VARCHAR2(1) NOT NULLBug Types
B=Bug
E=Enhancement
PTIASPRPTTYPECharacter(30)VARCHAR2(30) NOT NULLBUG Type
PTIASPRPTSEVCODENumber(3,0)SMALLINT NOT NULLBUG Severity
PTIASPRPTSEVERITYCharacter(45)VARCHAR2(45) NOT NULLBUG Severity Description
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
PTIASPPRDGRPCDCharacter(12)VARCHAR2(12) NOT NULLProduct Group
PTIASPPRDCDCharacter(8)VARCHAR2(8) NOT NULLProduct
PTIASPPRDNAMECharacter(240)VARCHAR2(240) NOT NULLProduct Name
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19