PSCPQSELECTVW

(SQL View)
Index Back

Composite Query

View for Composite Query - no data fetched from PSCPQSELECT

SELECT OPRID ,CPQNAME ,CPQQRYALIAS ,QRYFLDNAME ,COLUMNNUM ,ORDERBYNUM ,ORDERBYDIR ,GROUPBYNUM FROM PSCPQFIELD WHERE 1=0

# 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 CPQNAME Character(30) VARCHAR2(30) NOT NULL Composite Query
3 CPQQRYALIAS Character(30) VARCHAR2(30) NOT NULL Child Query Alias
4 QRYFLDNAME Character(30) VARCHAR2(30) NOT NULL Source Field
5 COLUMNNUM Number(3,0) SMALLINT NOT NULL Column Number
6 ORDERBYNUM Number(3,0) SMALLINT NOT NULL Order-By Number
7 GROUPBYNUM Number(3,0) SMALLINT NOT NULL Group-By Number
8 ORDERBYDIR Character(1) VARCHAR2(1) NOT NULL Order-By Direction
A=Ascending
D=Descending

Default Value: A