PSCHGCTLHIST

 index back

Change Control History Table

This table contains a history of object changes with descriptive comments. A row is inserted into this table when the user requests to unlock an object in the Application Designer. Similarly, a row inserted for each object when an upgrade copy is performed.

PeopleSoft Field Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
OBJECTTYPE Number(5,0) INTEGER NOT NULL Object Type
OBJECTID1 Number(5,0) INTEGER NOT NULL Object Id 1
1=Record
2=Field
3=Menu
4=Bar Name
5=Item Name
9=Page
10=Component
12=Event
20=Database Type
21=Effective Date
39=Market
60=Message
66=Application Engine Program
74=Component Interface
77=Section
78=Step
87=Subscription
104=Application Package
105=Class
106=Class
107=Class
OBJECTVALUE1 Character(100) VARCHAR2(100) NOT NULL Object Value 1
OBJECTID2 Number(5,0) INTEGER NOT NULL Object Id 2, as OBJECTID1
OBJECTVALUE2 Character(100) VARCHAR2(100) NOT NULL Object Value 2
OBJECTID3 Number(5,0) INTEGER NOT NULL Object Id 3, as OBJECTID1
OBJECTVALUE3 Character(30) VARCHAR2(30) NOT NULL Object Value 3
OBJECTID4 Number(5,0) INTEGER NOT NULL Object Id 4, as OBJECTID1
OBJECTVALUE4 Character(30) VARCHAR2(30) NOT NULL Object Value 4
DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
CHGCTRL_ACTION Character(1) VARCHAR2(1) NOT NULL Change Control Action
A=Add
C=Upgrade Copy
D=Delete
I=Informational
L=Lock
R=Rename
U=Unlock
PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
INCIDENT_ID Character(18) VARCHAR2(18) NOT NULL Incident ID
DESCRLONG Long Character CLOB Long Description
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20