Header Ads

  • Recent Posts

    PSPROJECTITEM Explained - Part 1

    The definition table for PeopleSoft Project is PSPROJECTDEFN. PSPROJECTITEM table holds all the objects included in a PeopleSoft object.
    1. PSPROJECTDEFN - Project Definition Table
    2. PSPROJECTITEM - Project Item table with PSPROJECTDEFN as Parent record.
    In order to analyze a project from backend during upgrades, applying patches or during major application releases it would be much easier if we could analyze from the project details from the database directly. Sometimes, we may have to even insert multiple definitions into a project and doing that manually would be painsome. Understanding both PSPROJECTDEFN and PSPROJECTITEM tables will help us to play around.

    PeopleSoft project creation in Application Designer is a simple activity which inserts corresponding project row in PSPROJECTDEFN. So I would prefer creating a PeopleSoft project in Application Designer rather than through database using SQL queries.

    But doing something with PSPROJECTITEM, understanding the data stored in PSPROJECTITEM looks rather difficult until you do it atleast once. Since the fields in PSPROJECTITEM does not have translate values we need to know the description of values stored in the fields - OBJECTTYPE, SOURCESTATUS, TARGETSTATUS, UPGRADEACTION, TAKEACTION and COPYDONE.

    Below is the PSPROJECTITEM table and the various field values it can hold along with the descriptions. Once we understand this table, then we can play around and accomplish a lot of activities related to PS projects.
    Field Name
    Values
    PROJECTNAME
    Name of the Project in Upper case
    OBJECTTYPE
    0=Record
    1=Index
    2=Field
    3=Field Format
    4=Translate Values
    5=Page
    6=Menu
    7=Component
    8=Record PC
    9=Menu PC
    10=Query View
    11=Tree Structures
    12=Trees
    13=Access Group
    14=Colors
    15=Styles
    16=Business Pro Map
    17=Business Process
    18=Activity
    19=Roles
    20=Process Definitions
    21=Server Definitions
    22=Process Type Definitions
    23=Job Definitions
    24=Recurrence Definitions
    25=Message Catalog Entry
    26=Dimensions
    27=Analysis Model
    28=Cube Template
    29=Business Interlink
    30=SQL
    31=File Layout Definitions
    32=Component Interface
    33=App Engine Programs
    34=App Engine Sections
    35=Message Nodes
    36=Message Channels
    37=Messages
    38=Approval Rule Sets
    39=Message PC
    40=Subscription PC
    41=Not Used
    42=Componenten Interface PC
    43=Application Engine PC
    44=Page PC
    45=Page Field PC
    46=Component PC
    47=Component Record PC
    48=Component Record Field PC
    49=Image
    50=Style Sheet
    51=HTML
    52=File Reference Objects
    53=Permission List
    54=Portal Registry Definitions
    55=Portal Registry Structure
    56=URL Definitions
    57=Application Package
    58=Application Package PC
    59=Portal Registry User Homepages
    60=Analytic Types
    61=Archive Templates
    62=XSLT
    63=Portal Reg User Favorites
    64=Mobile Page
    65=Relationships
    66=Component Interface Property PC
    67=Optimization Model
    68=File Reference
    69=File Type Codes
    70=Archive Object Definitions
    71=Archive Templates
    72=Diagnostic Plug-In
    73=Analytic Models
    74=Not Used
    75=Java Portlet User Preferences
    76=WSRP Remote Producer
    77=WSRP Remote Portlet
    78=WSRP Cloned Portlet Handle
    79=Services
    80=Service Operations
    81=Service Operation Handlers
    82=Service Operation Versions
    83=Routing Defnitions
    84=IB Queues
    85=XMLP Template Defn
    86=XMLP Report Defn
    87=XMLP File Defn
    88=XMLP Data Src Defn
    OBJECTID1
    OBJECTID1
    OBJECTVALUE1
    Object Value 1
    OBJECTID2
    OBJECTID2
    OBJECTVALUE2
    Object Value 2
    OBJECTID3
    OBJECTID3
    OBJECTVALUE3
    Object Value 3
    OBJECTID4
    OBJECTID4
    OBJECTVALUE4
    Object Value 4
    NODETYPE
    Node Type
    SOURCESTATUS
    0=Unknown 
    1=Absent 
    2=Changed 
    3=Unchanged 
    4=*Changed 
    5=*Unchanged 
    6=Same
    TARGETSTATUS
    0=Unknown 
    1=Absent 
    2=Changed 
    3=Unchanged 
    4=*Changed 
    5=*Unchanged 
    6=Same
    UPGRADEACTION
    0=Copy
    1=Delete
    2=None
    3=Copy Properties
    TAKEACTION
    0=No
    1=Yes
    COPYDONE
    0=No
    1=Yes


    There are several sources through which we can get these values in a search engine however one would like to know where we can find these values rather than relying on a web source.

    Where to find values and description of OBJECTTYPE in PSPROJECTITEM Record?
    1. From PeopleTools 8.50, the values of OBJECTTYPE field can be retrieved from the table - PS_WHEREOBJUSEDTBL(not sure if available in People Tools 8.49).
    2. UPG.SQC has the values for all these fields - OBJECTTYPE, SOURCESTATUS, TARGETSTATUS, UPGRADEACTION, TAKEACTION and COPYDONE.

    5 comments:

    1. Hi,

      Please let me know how to check if a project objects are in upgrade tab.

      Need to check it in record is there any field for that.?

      ReplyDelete
    2. This is very helpful. Thank you!

      ReplyDelete
    3. This is AWESOME!! Very helpful. Thank you.

      ReplyDelete
    4. '89','WSDL' ,'90','MessageSchemas','91','ConnectedQueryDefinition','92','LogicalSchemas','93','XMLSchemas','94','RelationalSchemas','95','DependencyDocuments','96','DocumentSchema','97','EssbaseCubeDimensions','98','EssbaseCubeOutlines','99','EssbaseCubeConnections'
      ,'100','EssbaseCubeTemplates','101','DelimitedSchemas','102','PositionalSchemas','103','ApplicationDataSetDefinitions','104','TestDefinitions','105','TestFrameworkTestCases','106','ApplicationDataSetBindings','107','FeedDefinitions','108','FeedCategories','109','FeedDataType'
      ,'110','JSONDocuments','111','RelatedContentDefinition','112','RelatedContentServices','113','RelatedContentConfigurations','114','RelatedContentLayouts','115','SearchAttributes','116','SearchDefinitions','117','SearchCategories','118','SearchContexts','119','IntegrationGroups'
      ,'120','HtmlSchema','121','DocumentLayoutManager','122','DocumentTemplateManager','123','CompositeQueryManager','124','DocumentPeopleCodeManager','125','MAPAdminManager'

      Bruce

      ReplyDelete

    Please refrain for marketing messages and unnecessary back links.

    Post Top Ad

    Post Bottom Ad