Change Control Supported Definition Types

These are the supported definition types for change control:

  • Activity

  • Application Engine Program

  • Application Package

  • Approval Rule Set

  • Business Interlink

  • Business Process

  • Component

  • Component Interface

  • Field

  • File Layout

  • HTML

  • Image

  • Menu

  • Message

  • Message Channel

  • Problem Type

  • Page

  • Project

  • Record

  • SQL

  • Style Sheet

When reporting on Change Control history, consider one other field: CHGCTRL_ACTION. This field stores the one-letter code for the various actions that Change Control history tracks:

  • A (Add)

  • C (Copy)

  • D (Delete)

  • I (Informational)

  • L (Lock)

  • R (Rename)

  • U (Unlock)

Here's an example of a SQL query to report on all deleted definitions:

select oprid, definitionvalue1, definitionvalue2, 
definitionvalue3, definitionvalue4, dttm­_stamp, projectname, 
incident_id, descrlong 
from pschgctlhist
  where chgctrl_action = 'D'
  order by oprid, definitionvalue1

Note:

Full history tracking is supported only for PeopleSoft Application Designer definitions: business processes, business process maps, fields, menus, panels, panel groups, projects, and records. Other definition types have history entries only when the CHGCTL_ACTION field value is C, and only if they have been upgraded.