PTIASPPKGCALCVW

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 ='C' AND PTIASPSELECTPSTREQ ='Y' 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 FROM PS_PTIASPPKGCALC CALC , PS_PTIASPRPTHEAD RPT , PS_PTIASPPRD PRD , PS_PTIASPPKGOPTS LEFT JOIN PS_PTIASPPKGCATS ON PS_PTIASPPKGOPTS.PTIASPPKGGUID = PS_PTIASPPKGCATS.PTIASPPKGGUID WHERE CALC.PTIASPRPTNO = RPT.PTIASPRPTNO AND RPT.PTIASPPRDID = PRD.PTIASPPRDID AND CALC.PTIASPPKGGUID = PS_PTIASPPKGOPTS.PTIASPPKGGUID

PeopleSoft Field NameField TypeColumn TypeDescription
PTIASPPKGGUIDCharacter(36)VARCHAR2(36) NOT NULLUnique Identifier
PTIASPRPTNONumber(10,0)DECIMAL(10) NOT NULLBUG Number
PTIASPRPTNOUSELCharacter(1)VARCHAR2(1) NOT NULLIndicates that this BUG was user selected and formed the basis of the requisite calculation
PTIASPRPTNOAPLDCharacter(1)VARCHAR2(1) NOT NULLThis flag indicates a BUG has already been applied
PTIASPRPTSUBJECTCharacter(80)VARCHAR2(80) NOT NULLBug Subject
PTIASPRPTNOBASENumber(10,0)DECIMAL(10) NOT NULLBase BUG Number
PTIASPRPTPOSTDTDateTime(26)TIMESTAMPDate this Bug was Posted
PTIASPSPVERSNumber(5,0)INTEGER NOT NULLNumeric value for Patch Database Version Number
PTIASPRPTTYPECharacter(30)VARCHAR2(30) NOT NULLBUG Type
PTIASPRPTSEVCODENumber(3,0)SMALLINT NOT NULLBUG Severity
PTIASPTLSIMPCTFLGCharacter(1)VARCHAR2(1) NOT NULLTools Impact
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
PTIASPPRDCDCharacter(8)VARCHAR2(8) NOT NULLProduct
PTIASPCRITICALFLAGCharacter(1)VARCHAR2(1) NOT NULLTrue Post Req
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19