PTIASPCALCEXCVW

index back

SELECT PTIASPPKGGUID , PTIASPRPTNO , PTIASPRPTNOUSEL , PTIASPRPTNOAPLD , PTIASPRPTSUBJECT , PTIASPRPTNOBASE , PTIASPRPTPOSTDT , PTIASPSPVERS , PTIASPRPTTYPE , PTIASPRPTSEVCODE , PTIASPTLSIMPCTFLG , RELEASELABEL , PTIASPPRDCD , PTIASPRPTREQUPG , PTIASPRPTCUSTFLAG , PTIASPRPTTESTFLAG , PTIASPRPTUSEREXCL , CASE WHEN PTIASPTLSIMPCTFLG = 'X' OR PTIASPRPTUSEREXCL = 'X' OR PTIASPRPTCUSTFLAG = 'R' OR PTIASPRPTTESTFLAG = 'R' THEN 'Y' ELSE ' ' END AS PTIASPREQEXCLUDE FROM PS_PTIASPPKGCALCVW WHERE PTIASPTLSIMPCTFLG = 'Y' OR PTIASPTLSIMPCTFLG = 'X' OR PTIASPRPTUSEREXCL = 'Y' OR PTIASPRPTUSEREXCL = 'X' OR PTIASPRPTREQUPG = 'Y' OR PTIASPRPTNOAPLD = 'Y' OR PTIASPRPTCUSTFLAG = 'R' OR PTIASPRPTCUSTFLAG = 'A' AND PTIASPRPTNOUSEL IN (' ', 'N') OR PTIASPRPTTESTFLAG = 'R' OR PTIASPRPTTESTFLAG = 'A' AND PTIASPRPTNOUSEL IN (' ', 'N')

PeopleSoft Field Name Field Type Column Type Description
PTIASPPKGGUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number
PTIASPRPTNOUSEL Character(1) VARCHAR2(1) NOT NULL Indicates that this BUG was user selected and formed the basis of the requisite calculation
PTIASPRPTNOAPLD Character(1) VARCHAR2(1) NOT NULL This flag indicates a BUG has already been applied
PTIASPRPTSUBJECT Character(240) VARCHAR2(240) NOT NULL Bug Subject
PTIASPRPTNOBASE Number(10,0) DECIMAL(10) NOT NULL Base BUG Number
PTIASPRPTPOSTDT DateTime(26) TIMESTAMP Date this Bug was Posted
PTIASPSPVERS Number(5,0) INTEGER NOT NULL Numeric value for Patch Database Version Number
PTIASPRPTTYPE Character(30) VARCHAR2(30) NOT NULL BUG Type
PTIASPRPTSEVCODE Number(3,0) SMALLINT NOT NULL BUG Severity
PTIASPTLSIMPCTFLG Character(1) VARCHAR2(1) NOT NULL Tools Impact
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
PTIASPPRDCD Character(8) VARCHAR2(8) NOT NULL Product
PTIASPRPTREQUPG Character(1) VARCHAR2(1) NOT NULL Required For Upgrade
PTIASPRPTCUSTFLAG Character(1) VARCHAR2(1) NOT NULL Custom Impact
A=Above Threshold
B=Below Threshod
D=Dirty Value
N=No Customization
R=Requisite
PTIASPRPTTESTFLAG Character(1) VARCHAR2(1) NOT NULL Test Exists
A=Above Threshold
B=Below Threshod
D=Dirty Value
N=No Customization
R=Requisite
PTIASPRPTUSEREXCL Character(1) VARCHAR2(1) NOT NULL User Excluded
PTIASPREQEXCLUDE Character(1) VARCHAR2(1) NOT NULL Requisite
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20