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.