PSMGRSHADOW (SQL Table)	Index Back
Managed Object Shadow Table This table is for saving the VERSION, LASTUPDOPRID, LASTUPDDTTM fields for Managers that don't have these fields in their root table. These fields are required for Copy/Compare functionality.

PSMGRSHADOW

(SQL Table)

Managed Object Shadow Table

This table is for saving the VERSION, LASTUPDOPRID, LASTUPDDTTM fields for Managers that don't have these fields in their root table. These fields are required for Copy/Compare functionality.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PTKEYVALUE1 Character(150) VARCHAR2(150) NOT NULL Object Value 1

3 PTKEYVALUE2 Character(150) VARCHAR2(150) NOT NULL Object Value 2

4 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

5 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OBJECTTYPE	Number(5,0)	INTEGER NOT NULL	Object Type
2	PTKEYVALUE1	Character(150)	VARCHAR2(150) NOT NULL	Object Value 1
3	PTKEYVALUE2	Character(150)	VARCHAR2(150) NOT NULL	Object Value 2
4	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
5	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
6	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.