PSPGDTYPE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTPG_DSTYPE	Character(30)	VARCHAR2(30) NOT NULL	Data Source Type
2	PTPG_PGRIDTITLE	Character(30)	VARCHAR2(30) NOT NULL	Pivot Grid Title
3	DESCRLONG	Long Character	CLOB	Long Description
4	PTPG_USESQLTYPE	Number(1,0)	SMALLINT NOT NULL	Use SQL Type Default Value: 1
5	APPCLASSID	Character(30)	VARCHAR2(30) NOT NULL	Application Class ID
6	PACKAGEID	Character(30)	VARCHAR2(30) NOT NULL	Package Name (see PSDIAGREG).
7	QUALIFYPATH	Character(127)	VARCHAR2(127) NOT NULL	Qualified Package/Class Path
8	ACTIVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Active Flag A=Active I=Inactive Default Value: A
9	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
10	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier
11	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
12	CREATEOPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
13	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.
14	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.