PTAI_GP_DSTYPE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTAI_GPDS_ID	Character(30)	VARCHAR2(30) NOT NULL	Activity Guide Datasource ID
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCRLONG	Long Character	CLOB	Long Description
4	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier Default Value: PTPP_OPTIONS.OBJECTOWNERID
5	ACTIVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Active Flag A=Active I=Inactive Default Value: A
6	PACKAGEID	Character(30)	VARCHAR2(30) NOT NULL	Package Name (see PSDIAGREG). Prompt Table: PTBR_APPPKG_PVW
7	QUALIFYPATH	Character(127)	VARCHAR2(127) NOT NULL	Qualified Package/Class Path Prompt Table: PTBR_APPPATHPVW
8	APPCLASSID	Character(30)	VARCHAR2(30) NOT NULL	Application Class ID Prompt Table: PTBR_APPCLASPVW
9	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
10	CREATEOPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
11	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.
12	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.