PSCONQRSDEFN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	CONQRSNAME	Character(30)	VARCHAR2(30) NOT NULL	Connected Queries object name
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	PT_REPORT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Report Status A=Active I=Inactive P=In Progress
5	AE_APPLID	Character(12)	VARCHAR2(12) NOT NULL	Program Name (see PSAEAPPLDEFN).
6	TEMPTBLINSTANCES	Number(4,0)	SMALLINT NOT NULL	Temp Table Instances (Total)
7	AE_ACTIVE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status A=Active I=Inactive Default Value: I
8	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier
9	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
10	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.
11	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.
12	REGISTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Registered By
13	REGISTERED_DTTM	DateTime(26)	TIMESTAMP	Registered Date/Time
14	DESCRLONG	Long Character	CLOB	Long Description