PSCHGCTLHIST (SQL Table)	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.

PSCHGCTLHIST

(SQL Table)

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 PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 OBJECTTYPE Number(5,0) INTEGER NOT NULL Object Type

3 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

4 OBJECTVALUE1 Character(100) VARCHAR2(100) NOT NULL Object Value 1

5 OBJECTID2 Number(5,0) INTEGER NOT NULL Object Id 2, as OBJECTID1

6 OBJECTVALUE2 Character(100) VARCHAR2(100) NOT NULL Object Value 2

7 OBJECTID3 Number(5,0) INTEGER NOT NULL Object Id 3, as OBJECTID1

8 OBJECTVALUE3 Character(30) VARCHAR2(30) NOT NULL Object Value 3

9 OBJECTID4 Number(5,0) INTEGER NOT NULL Object Id 4, as OBJECTID1

10 OBJECTVALUE4 Character(30) VARCHAR2(30) NOT NULL Object Value 4

11 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.

12 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

13 PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).

14 INCIDENT_ID Character(18) VARCHAR2(18) NOT NULL Incident ID

15 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	OBJECTTYPE	Number(5,0)	INTEGER NOT NULL	Object Type
3	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
4	OBJECTVALUE1	Character(100)	VARCHAR2(100) NOT NULL	Object Value 1
5	OBJECTID2	Number(5,0)	INTEGER NOT NULL	Object Id 2, as OBJECTID1
6	OBJECTVALUE2	Character(100)	VARCHAR2(100) NOT NULL	Object Value 2
7	OBJECTID3	Number(5,0)	INTEGER NOT NULL	Object Id 3, as OBJECTID1
8	OBJECTVALUE3	Character(30)	VARCHAR2(30) NOT NULL	Object Value 3
9	OBJECTID4	Number(5,0)	INTEGER NOT NULL	Object Id 4, as OBJECTID1
10	OBJECTVALUE4	Character(30)	VARCHAR2(30) NOT NULL	Object Value 4
11	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.
12	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
13	PROJECTNAME	Character(30)	VARCHAR2(30) NOT NULL	Project Name (see PSPROJECTDEFN).
14	INCIDENT_ID	Character(18)	VARCHAR2(18) NOT NULL	Incident ID
15	DESCRLONG	Long Character	CLOB	Long Description