PSPGCORE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTPG_PGRIDNAME	Character(30)	VARCHAR2(30) NOT NULL	Pivot Grid Name
2	PTPG_PGRIDTITLE	Character(30)	VARCHAR2(30) NOT NULL	Pivot Grid Title
3	DESCRLONG	Long Character	CLOB	Long Description
4	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
5	PTPG_ISSIMPL_WIZ	Character(1)	VARCHAR2(1) NOT NULL	Simple Analytics Model Default Value: N
6	PTPG_PGRIDNAMEBASE	Character(30)	VARCHAR2(30) NOT NULL	Pivot Grid Name
7	PTPG_DSTYPE	Character(30)	VARCHAR2(30) NOT NULL	Data Source Type (see PSPGDTYPE). Prompt Table: PSPGDTYPE
8	PTPG_DSINFO	Character(1)	VARCHAR2(1) NOT NULL	DataSource Information
9	PTPG_PGRIDTYPE	Character(4)	VARCHAR2(4) NOT NULL	Pivot Grid Type PUB=Public PVT=Private
10	PTPG_ISVALIDMODEL	Character(1)	VARCHAR2(1) NOT NULL	Valid Model N=No Y=Yes Default Value: Y
11	PTPG_USESQLTYPE	Number(1,0)	SMALLINT NOT NULL	Use SQL Type Default Value: 1
12	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
13	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier
14	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
15	CREATEOPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
16	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.
17	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.