PSCONQRSMAP

#	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	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
4	QRYNAMEPARENT	Character(30)	VARCHAR2(30) NOT NULL	Connected Queries Parent Query Name
5	QRYNAMECHILD	Character(30)	VARCHAR2(30) NOT NULL	Child Query Name
6	EFFDTCONDTYPE	Character(4)	VARCHAR2(4) NOT NULL	Eff Date Operator. Used in Connected Query EDGE=Eff Date >= EDGT=Eff Date > EDLE=Eff Date <= EDLT=Eff Date < EQU=Eff Date = Default Value: EQU
7	CQ_SUPPORTSORDERBY	Number(1,0)	SMALLINT NOT NULL	Supports Order By
8	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).