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 NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
OBJECTTYPENumber(5,0)INTEGER NOT NULLObject Type
OBJECTID1Number(5,0)INTEGER NOT NULLObject 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
OBJECTVALUE1Character(100)VARCHAR2(100) NOT NULLObject Value 1
OBJECTID2Number(5,0)INTEGER NOT NULLObject Id 2, as OBJECTID1
OBJECTVALUE2Character(100)VARCHAR2(100) NOT NULLObject Value 2
OBJECTID3Number(5,0)INTEGER NOT NULLObject Id 3, as OBJECTID1
OBJECTVALUE3Character(30)VARCHAR2(30) NOT NULLObject Value 3
OBJECTID4Number(5,0)INTEGER NOT NULLObject Id 4, as OBJECTID1
OBJECTVALUE4Character(30)VARCHAR2(30) NOT NULLObject Value 4
DTTM_STAMPDateTime(26)TIMESTAMPSpecifies 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_ACTIONCharacter(1)VARCHAR2(1) NOT NULLChange Control Action
A=Add
C=Upgrade Copy
D=Delete
I=Informational
L=Lock
R=Rename
U=Unlock
PROJECTNAMECharacter(30)VARCHAR2(30) NOT NULLProject Name (see PSPROJECTDEFN).
INCIDENT_IDCharacter(18)VARCHAR2(18) NOT NULLIncident ID
DESCRLONGLong CharacterCLOBLong Description
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19