List of PUM Tables | PeopleSoft Tutorial
1

List of PUM Tables

PeopleSoft Update Manager or PUM has become part of daily life of PeopleSoft consultants and so has the task of troubleshooting issues related to PUM. While troubleshooting an issue related to PUM, I had the need to look at some PUM tables and felt that you may also have a need for the same. Hence, here is the list of tables for PUM in alphabetical order with a brief description of each.

List of Tables for PeopleSoft Update Manager or PUM

PTIAADSCUSCNTVW –
PTIAADSCUSTREPO –
PTIAADSPRJCALC – This table describes the records and key values that form the ADS dataset
PTIAADSPRJCALVW – This table describes the records and key values that form the ADS dataset
PTIAADSREFREPO –
PTIACLLNG_AET – CleanLang State Record
PTIACPCHPTR – This reference table stores the super set of all possible Chapters that be used to construct a CA Template. The Chapters have a sequence associated with them and this is used to determine the order the Chapters will appear in the CA Template.
PTIACPCLASSES – This tables stores a list of Classes associated to various parts of the CA Template
PTIACPNOTETEXT – This table stores the text of each Note
PTIACPPRP – This table stores the superset of Template Step Properties
PTIACPPRPDFLT – This table stores the default property value for each step type
PTIACPSTEP – This reference table stores the super set of possible Steps that be used to construct a CA Template. The Steps have a sequence associated with them and this is used to determine the order the Steps will appear in the CA Template.
PTIACPSTEPPRP – This tables is a child of the Step List table. For each Step, this table holds the associated properties
PTIACPTASK – This reference table stores the super set of all possible Tasks that be used to construct a CA Template. The Tasks have a sequence associated with them and this is used to determine the order the Tasks will appear in the CA Template.
PTIACPTMPLSTPVW –
PTIACPTMPLTDEFN –
PTIACPTMPLTFQ1V – This view selects information about filter queries defined for a given template
PTIACPTMPLTFQ2V – This view selects information about filter queries defined for each template
PTIACPTMPLTFQDF – This table stores metadata about which filter queries are used by CA template steps
PTIACPTMPLTFQUS – This table stores metadata about filter queries are referenced by CA template steps
PTIACPTMPLTSTEP –
PTIACUSTCALCOPT –
PTIACUSTREPO – Customization Repository table
PTIAINTCALCAET –
PTIAMATVW_AET – PUM Materialized View State Record
PTIAMOCUSTCNTVW –
PTIAMOCUSTREPO –
PTIAMOCUST_VW –
PTIAMOREFREPO –
PTIAMOTESTREPO –
PTIAMOTEST_VW –
PTIAPRJITEMCALC – This table is used to calculate MOs in the project
PTIAPUMSTEPPARM –
PTIARPTCUST_VW – Customization Repository table
PTIARPTHEADA_VW – This table holds information about all BUGS fixed since GA
PTIARPTIMPTREPO –
PTIARPTTEST_VW – Test Repository view for bugs.
PTIARPTTSTMO_VW –
PTIASPADSCATS –
PTIASPADSDEPINF – This table stores ADS object dependency metadata information
PTIASPADSDPENDS – This table describes Bug dependencies based on common ADS DataSet record and key data
PTIASPAVDCATVW –
PTIASPBUGBTAGVW – Bugs by Tags
PTIASPBUGPRD_VW – Joins Bug and Product views
PTIASPBUGS4CPVW – Bugs allowed for PUM change packages
PTIASPBUGSLAGVW – Bugs with with image lag information
PTIASPBUGSTATVW – Union to find the status of the bugs
PTIASPBUGSTSVW2 – BUG Status by database view.
PTIASPCALCEXCVW –
PTIASPCFG –
PTIASPCHARCODES – This table stores a list of Char code values used by PTIASP
PTIASPCHART1VW – Updates applied by Product, relative to Total Updates in Image for that Product
PTIASPCHART2VW – Updates applied for All Products, relative to Total Updates in Image for that Product
PTIASPCHART3VW – Updates applied relative to when Updates in Image were first delivered
PTIASPCOMPREL – This table stores the relationships between products and other products, components and sub components
PTIASPDLTPKGADS – This table is used for ADS soft dependency calculation
PTIASPDLTPKGMO – This table is used for Managed Object soft dependency calculation
PTIASPDLTPKGREL – This table stores “From Tools Release” & “To Tools Release” information when defining change package.
PTIASPDMPARAM –
PTIASPEDITPKGVW – This view is used as prompt table for package name. It filters out the packages that have been crated in Change Assistant.
PTIASPEDTPKGDVW – This dynamic view is used as prompt table for package name..
PTIASPENHBUGVW – Enhancement bugs view
PTIASPINSTPRD – A List of Installed Products
PTIASPINSTPRDVW –
PTIASPINTCODES – This table stores a list of Integer code values used by PTIASP
PTIASPINTPKGMOL – This contains additional objects to include in an INT change package
PTIASPLANG_VW –
PTIASPLOGTGT – In order to exclude already applied BUGS from calculated apply list, a copy of the target database apply log is copied to the patch source database and stored in this table.
PTIASPLOGTGTVW – This view is used to show applied bugs along with their subject & product information.
PTIASPMAXSTEPVW – This view derives the maximum step versions for all steps being applied for a group of BUGS

PTIASPMLLDAET –
PTIASPMODEPINF – This table stores Managed Object dependency metadata information
PTIASPNUI_WRK –
PTIASPOBJDIFF – This tables stores the object differences as a result of patching
PTIASPOBJDIFRVW –
PTIASPOBJDPENDS –
PTIASPOBJDSEQVW –
PTIASPOBJTYPEVW – A view of the list of object types for peopletools objects
PTIASPPKGALL – Options chosen by the user to create specific change packages
PTIASPPKGBUGS – Bugs included in specific change packages
PTIASPPKGBUGSVW –
PTIASPPKGCALC – This table stores the calculated pre and post requisite BUGS for a given list of selected BUGS.
PTIASPPKGCALCVW – This table stores the calculated pre and post requisite BUGS for a given list of selected BUGS.
PTIASPPKGCATAVD – Advanced Search Criteria chosen by the user to create specific change packages
PTIASPPKGCATFML – Product Family chosen by the user to create specific change packages
PTIASPPKGCATPDT – Posted To and Posted From dates chosen by the user to create specific change packages
PTIASPPKGCATPI –
PTIASPPKGCATPRD – Products chosen by the user to create specific change packages
PTIASPPKGCATS – Criterias chosen by the user to create specific change packages
PTIASPPKGCATSEV – Severity Code chosen by the user to create specific change packages
PTIASPPKGCATSTD – Standard Search Criteria chosen by the user to create specific change packages
PTIASPPKGCATTRA – Languages chosen by the user to create specific change packages
PTIASPPKGCCL – PTIA ClearCase Listing
PTIASPPKGCUST – Customization Repository table
PTIASPPKGCUSTVW –
PTIASPPKGDOCVW – This view is used for CA Template doc generation
PTIASPPKGDUPVW – This view displays the package names which include non-applied BUG in the creating package.
PTIASPPKGOBJS – Objects chosen by the user to create specific change packages
PTIASPPKGOPTS – Options chosen by the user to create specific change packages
PTIASPPKGPRJS –
PTIASPPKGPSTREQ – Options chosen by the user to create specific change packages
PTIASPPKGS – change packages created for a specific target database
PTIASPPKGSTRH – This tables stores the Chapter, Task and Step combinations of actions required to patch a caclulated Apply Set.
PTIASPPKGSTRP – This tables stores the Chapter, Task and Step properties of actions required to patch a caclulated Apply Set.
PTIASPPKGS_VW – change packages created for a specific target database
PTIASPPKGTEST – Customization Repository table
PTIASPPKGTESTVW –
PTIASPPKGTPFQ1V – This view selects information about filter queries defined for a generated package
PTIASPPKGTPFQ2V – This view selects information about filter queries defined for for a generated package
PTIASPPKGTSTOBJ –
PTIASPPKGTSTOVW –
PTIASPPRD – Table of Products
PTIASPPRDCOMP – Product component code and name
PTIASPPRDFMLY – This table groups together products into related product families
PTIASPPRDFMLYVW – This view gives a list of product families for the licence group
PTIASPPRDGRP – Reference table of product groups
PTIASPPRDSTATVW – Union of products and installed products
PTIASPPRDVW – BUG Percent Applied / Unapplied by Product
PTIASPPRJADSOBJ –
PTIASPPRJITEM –
PTIASPPRJITEMVW – This is the modified object list for all bugs in PACKAGE
PTIASPRPTADSDAT – This table describes the records and key values that form the ADS dataset
PTIASPRPTADSNVP –
PTIASPRPTADSOVW –
PTIASPRPTADSVW –
PTIASPRPTBODY – Holds Text associated with the BUG Body
PTIASPRPTCVW1 – BUG view that includes BUG resolution text and tags.
PTIASPRPTDAT –
PTIASPRPTEXP –
PTIASPRPTHEAD – This table holds information about all BUGS fixed since GA
PTIASPRPTHEADVW – This table holds information about all BUGS fixed since GA
PTIASPRPTMOL – This is the modified object list for each BUG
PTIASPRPTMOLVW – This is the modified object list for each BUG
PTIASPRPTPMOLVW – This is the modified object list for all bugs in PACKAGE
PTIASPRPTQRYVW –
PTIASPRPTRECVW – Recommended Bug List
PTIASPRPTREQS – This table stores a list of BUG Dependencies. It is used to derived the pre and post requisite BUG calculation.
PTIASPRPTRESTXT – This view combines the BUG resolution text entries into a single field.
PTIASPRPTRQPOVW –
PTIASPRPTRQPRVW –
PTIASPRPTSELDVW –
PTIASPRPTTAGS – This table stores a list of BUG tags which can be used to derive a list of BUGS to apply to a target database
PTIASPRPTTAGSVW – Concantenated list by BUG of Tag Name/Value pairs.
PTIASPRPTTLSDEP – This table stores information relating to Bug Tools dependencies
PTIASPRPTTYPEVW –
PTIASPSEARCH –
PTIASPSEVCD_VW – A view listing Bug Severity Codes
PTIASPSPVERSVW –
PTIASPSRCHCAT – This table stores search category information
PTIASPSRCHDEFN – This table stores detailed search criteria
PTIASPSRCINFO – This is a one row table with basic information about this patching source database
PTIASPSTDCATVW –
PTIASPSUBCOMP – product subcomponent code and name
PTIASPSUM_VW –
PTIASPTAGLISTVW –
PTIASPTAGVALS –
PTIASPTAGVW – BUG Percentage Applied / Unapplied by TAGs
PTIASPTARGETLNG – Installed languages on Selective Patching Target databases.
PTIASPTARGETS –
PTIASPTFPBUGSVW –
PTIASPTFPCALC –
PTIASPTGTDBVW – This view queries the Target database list.
PTIASPTGTIMGVW – BUG Applied / Unapplied Percentages by Image for Installed / Not Installed products view.
PTIASPTLSRELVW – This view queries the maintenance log to determine the currect tools patch level
PTIASPTRANOLYVW –
PTIASPUPGFROMVW –
PTIASPUPGPATH –
PTIASPUPGTOVW –
PTIASPUSERTGTS – User Selected Target Databases for Selective Patching
PTIASP_CPWF_WRK – Addtional Change Package Wizard Fields
PTIASP_RUNCNTL –
PTIASP_SCOMP_VW –
PTIASP_SORT_WRK –
PTIATESTCALCOPT –
PTIATESTOBJN_VW –
PTIATESTOBJREPO –
PTIATESTOBJY_VW –
PTIATESTREFREPO –
PTIATESTREPO – Customization Repository table
PTIAUSERTGTSELS – User Selected Target Databases for Selective Patching
PTIA_AEPGMS_VW – Search Record for the PTIA_DCAEPGMS Component and a Prompt Table for the PTIA_DCAEPGMS Page.
PTIA_AESECTS_VW – Used by the PTIA_DC_AE_LIBS_SP Secondary Page to get the description for the data conversion Application Engine Sections.
PTIA_ANALYSIS –
PTIA_ANALYSISTX –
PTIA_DATACONV – Used for dynamic section call of all the AE sections used in the Upgrade Data Conversion.
PTIA_DATNAV_WRK –
PTIA_DBTYPE_CDS –
PTIA_DCAEPGMS – Contains the names and grouping of the data conversion Application Engine programs to be called.
PTIA_DCAERUNCTL –
PTIA_DERIVED – Derived/Work Record for PTIA
PTIA_DTLIDBINDS – This table contains bind variables that are used in the upgrade process. This is analyzed data from the PTIA_ANALYSIS table.

Master PeopleSoft Update 
Manager [PUM]

Apurva Tripathi
 

  • anamika mukherjee says:

    Very helpful information

  • >