Useful Stuff for PeopleSoft Upgrade (PSPROJECTITEM)

Useful Stuff for PeopleSoft Upgrade:
*******************************

Projects

• PSPROJECTDEFN — Project header table
• PSPROJECTITEM — Definitions in the project

Fields

• PSDBFIELD — Fields in the system
• PSXLATITEM — Translate Values

Records

• PSRECDEFN — Record header table (record types)
• PSRECFIELD — Fields in the record (subrecords not expanded)
• PSRECFIELDALL — Fields in the record (subrecords expanded)
• PSKEYDEFN — Indexes
• PSTBLSPCCAT — Tablespaces
• PSRECTBLSPC — Records’ tablespace assignments

Pages

(Note: Pages still have the name panels in the PeopleTools table names)

• PSPNLDEFN — Page header table
• PSPNLFIELD — Page controls (field types/FIELDTYPE)
• PSPNLHTMLAREA — Static HTML Areas on Pages
• PSPNLCNTRLDATA — stores additional attributes for Page controls
• PSPNLFIELDEXT — stores additional attributes for Page controls
• PSPTPNLRTEDITOR — new PeopleTools 8.50 table that stores attributes relating to the rich-text editor for long character fields.

Components

(Note: Components still have the name panel group in the PeopleTools table names)

• PSPNLGRPDEFN — Component header table
• PSPNLGROUP — Pages in the components

Component Interface

• PSBCDEFN — header record; one row for each component interface
• PSBCITEM — one row for each property

Menus

• PSMENUDEFN — Menu header table
• PSMENUITEM — Items (components) on the menu

Security

• PSCLASSDEFN — Permission List header table
• PSAUTHITEM — Menu items granted security by permission lists
• PSROLEDEFN — Role header table
• PSROLECLASS — Permission Lists in roles
• PSOPRDEFN — User ID header table
• PSROLEUSER — Roles granted to users
• PSAUTHBUSCOMP — Access to Component Interfaces

Process Scheduler

• PS_PRCSDEFN — Process Definition Header
• PS_PRCSDEFNGRP — Process Group
• PS_PRCSDEFNPNL — Component
• PS_PRCSJOBDEFN — Job Header
• PSPRCSRQST — Process Request Instances
• PS_PRCSJOBITEM — Job Processes

Portal

• PSPRSMDEFN — Content References and Folders
• PSPRUHTABPGLT — Portal User HP Tab Pagelet
• PSPRUHDEFN — Homepage definition (from here)
• PSPRUHTAB — Homepage Tab (from here)
• PSWEBPROFNVP — Web Profile Settings

Change Control

• PSCHGCTLHIST — shows history of locked definitions with project name, incident, and description
• PSCHGCTLLOCK — shows definitions that are currently locked

Application Engine

• PSAEAPPLDEFN — header record; 1 row per app engine
• PSAEAPPLSTATE — state records assigned to app engines
• PSAEAPPLTEMPTBL — temp tables assigned to app engines
• PSAESECTDEFN — sections
• PSAESTEPDEFN — steps
• PSAESTEPMSGDEFN
• PSAESTMTDEFN — actions (action types)

List Log Messages

HTML Definitions

• PSCONTDEFN — header record; last update time, etc.
• PSCONTENT — stores actual text in the HTML definition

SQL Definitions

• PSSQLDEFN — header record; last update time, etc.
• PSSQLTEXTDEFN — stores actual text in the SQL definition

File Layout Definitions

• PSFLDDEFN — header record; last update time, etc.
• PSFLDSEGDEFN — stores the segments for each layout
• PSFLDFIELDDEFN — stores the fields for each layout

Workflow

• APPR_RULE_DETL – Approval Rule Defn Details
• APPR_RULE_FIELD – Approval Rule Defn Route Cntl
• APPR_RULE_AMT – Approval Rule Amounts
• RTE_CNTL_LN – Route Control Profile Line
• RTE_CNTL_RUSER – RoleUser Route Cntl Profiles
• RTE_CNTL_TYPE – Route Control Type
• RTE_CNTL_HDR – Routing Control Type
• PSWORKLIST — list of work items for each user
• PS_WF_INSTSTATUS — description of the status

Timings

• BAT_TIMINGS_LOG
• BAT_TIMINGS_DTL
• BAT_TIMINGS_FN

Thanks to Shyam:

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