PSCHGCTLLOCK

index back

Change Control Locked Objects

This table contains a a row for every object that is currently locked by any user. When the user requests to lock an object in the Application Designer, first this table is searched to see if the object is locked by another user. If it is not found, a row is inserted into the table. When the user requests to unlock an object, the row in this table is deleted.

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