PTIASPPKGCALCVW

(SQL View)
 Index Back

Apply Calculation Table

This table stores the calculated pre and post requisite BUGS for a given list of selected BUGS.

SELECT CALC.PTIASPPKGGUID , CALC.PTIASPRPTNO , CALC.PTIASPRPTNOUSEL , CALC.PTIASPRPTNOAPLD , RPT.PTIASPRPTSUBJECT , RPT.PTIASPRPTNOBASE , RPT.PTIASPRPTPOSTDT , RPT.PTIASPSPVERS , RPT.PTIASPRPTTYPE , RPT.PTIASPRPTSEVCODE , CALC.PTIASPTLSIMPCTFLG , CALC.RELEASELABEL , PRD.PTIASPPRDCD , ( CASE WHEN PTIASPSEARCHSCOPE ='S' AND EXISTS ( SELECT 'X' FROM PS_PTIASPRPTREQS , PS_PTIASPPKGS WHERE PS_PTIASPRPTREQS.PTIASPRPTNO=CALC.PTIASPRPTNO AND CALC.PTIASPPKGGUID = PS_PTIASPPKGS.PTIASPPKGGUID AND PTIASPREQTYPE ='True Requisite' AND EXISTS ( SELECT 'X' FROM PS_PTIASPLOGTGT WHERE PS_PTIASPRPTREQS.PTIASPRPTNOPRE = PS_PTIASPLOGTGT.PTIASPRPTNO AND PS_PTIASPPKGS.DBNAME =PS_PTIASPLOGTGT.DBNAME ) AND NOT EXISTS ( SELECT 'X' FROM PS_PTIASPLOGTGT WHERE PS_PTIASPRPTREQS.PTIASPRPTNO = PS_PTIASPLOGTGT.PTIASPRPTNO AND PS_PTIASPPKGS.DBNAME =PS_PTIASPLOGTGT.DBNAME ) ) THEN 'Y' ELSE '' END ) AS PTIASPCRITICALFLAG , CALC.PTIASPRPTREQUPG , CALC.PTIASPRPTCUSTFLAG , CALC.PTIASPRPTTESTFLAG , CALC.PTIASPRPTUSEREXCL FROM PS_PTIASPPKGCALC CALC , PS_PTIASPRPTHEAD RPT , PS_PTIASPPRD PRD , PS_PTIASPPKGOPTS WHERE CALC.PTIASPRPTNO = RPT.PTIASPRPTNO AND RPT.PTIASPPRDID = PRD.PTIASPPRDID AND CALC.PTIASPPKGGUID = PS_PTIASPPKGOPTS.PTIASPPKGGUID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTIASPPKGGUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
2 PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number
3 PTIASPRPTNOUSEL Character(1) VARCHAR2(1) NOT NULL Indicates that this BUG was user selected and formed the basis of the requisite calculation
4 PTIASPRPTNOAPLD Character(1) VARCHAR2(1) NOT NULL This flag indicates a BUG has already been applied
5 PTIASPRPTSUBJECT Character(240) VARCHAR2(240) NOT NULL Bug Subject
6 PTIASPRPTNOBASE Number(10,0) DECIMAL(10) NOT NULL Base BUG Number
7 PTIASPRPTPOSTDT DateTime(26) TIMESTAMP Date this Bug was Posted
8 PTIASPSPVERS Number(5,0) INTEGER NOT NULL Numeric value for Patch Database Version Number
9 PTIASPRPTTYPE Character(30) VARCHAR2(30) NOT NULL BUG Type
10 PTIASPRPTSEVCODE Number(3,0) SMALLINT NOT NULL BUG Severity
11 PTIASPTLSIMPCTFLG Character(1) VARCHAR2(1) NOT NULL Tools Impact
12 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
13 PTIASPPRDCD Character(8) VARCHAR2(8) NOT NULL Product
14 PTIASPCRITICALFLAG Character(1) VARCHAR2(1) NOT NULL True Post Req
15 PTIASPRPTREQUPG Character(1) VARCHAR2(1) NOT NULL Required For Upgrade
16 PTIASPRPTCUSTFLAG Character(1) VARCHAR2(1) NOT NULL Custom Impact
A=Excluded
B=Included
D=Run Calc
N=No Impact
R=Requisite
17 PTIASPRPTTESTFLAG Character(1) VARCHAR2(1) NOT NULL Test Exists
A=Above Threshold
B=Below Threshod
D=Dirty Value
N=No Customization
R=Requisite
18 PTIASPRPTUSEREXCL Character(1) VARCHAR2(1) NOT NULL User Excluded