PTGPLT_DATATYPE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTPPB_DATATYPE_ID	Character(30)	VARCHAR2(30) NOT NULL	Data Type
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCRLONG	Long Character	CLOB	Long Description
4	APPCLASSID	Character(30)	VARCHAR2(30) NOT NULL	Application Class ID
5	PACKAGEID	Character(30)	VARCHAR2(30) NOT NULL	Package Name (see PSDIAGREG).
6	QUALIFYPATH	Character(127)	VARCHAR2(127) NOT NULL	Qualified Package/Class Path
7	PTPPB_SRCH_APCLASS	Character(30)	VARCHAR2(30) NOT NULL	Application Class ID
8	PTPPB_SRCH_AP_PKG	Character(30)	VARCHAR2(30) NOT NULL	Package Name
9	PTPPB_SRCH_AP_PATH	Character(127)	VARCHAR2(127) NOT NULL	Qualified Package/Class Path
10	PAGE_NAME	Character(18)	VARCHAR2(18) NOT NULL	Page Name Prompt Table: PTPPB_PAGE_PVW
11	ACTIVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Active Flag A=Active I=Inactive Default Value: A
12	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
13	CREATEOPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
14	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.
15	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.