PSDEFNCACHE

index back

PeopleTools Table for Cache

PeopleTools-owned table for storing Metadata objects in cache

PeopleSoft Field Name Field Type Column Type Description
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
OBJECTID5 Number(5,0) INTEGER NOT NULL Object Id 5, as OBJECTID1
OBJECTVALUE5 Character(30) VARCHAR2(30) NOT NULL Object Value 5
OBJECTID6 Number(5,0) INTEGER NOT NULL Object Id 6, as OBJECTID1
OBJECTVALUE6 Character(30) VARCHAR2(30) NOT NULL Object Value 6
OBJECTID7 Number(5,0) INTEGER NOT NULL Object Id 7, as OBJECTID1
OBJECTVALUE7 Character(30) VARCHAR2(30) NOT NULL Object Value 7
OBJECTTYPENAME Character(8) VARCHAR2(8) NOT NULL Object Type Name- Version/Table reference
PTCHANNELID Character(15) VARCHAR2(15) NOT NULL PeopleTools field for Metadata cache
VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
LASTUPDDTTM 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.
PTCACHEOBJECT Long Character CLOB PeopleTools field for storing Metadata objects in cache
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19