PSXPDATASRC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Data Source Type CPQ=Composite Query CQR=Connected Query QRY=Query RST=Rowset XMD=XMLDoc Object XML=XML File Default Value: QRY
2	DS_ID	Character(30)	VARCHAR2(30) NOT NULL	Data Source ID Prompt Table: %EDITTABLE
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	ACTIVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Active Flag A=Active I=Inactive
6	SCHEMAFILE	Character(128)	VARCHAR2(128) NOT NULL	Schema File
7	SAMPLEDATFILE	Character(128)	VARCHAR2(128) NOT NULL	Sample Data File
8	REGISTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Registered By
9	REGISTERED_DTTM	DateTime(26)	TIMESTAMP	Registered Date/Time
10	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier
11	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
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.
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.