PSCHGCTLLOCK(SQL Table) |
Index Back |
|---|---|
Change Control Locked ObjectsThis 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 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 | PROJECTNAME | Character(30) | VARCHAR2(30) NOT NULL | Project Name (see PSPROJECTDEFN). |
| 13 | INCIDENT_ID | Character(18) | VARCHAR2(18) NOT NULL | Incident ID |
| 14 | DESCRLONG | Long Character | CLOB | Long Description |