PSCPQFIELDVW

index back

Composite Query

View for Composite Query - no data fetched from PSCPQSELECT
SELECT OPRID ,CPQNAME , SELNUM ,CPQQRYALIAS ,QRYFLDNAME ,COLUMNNUM ,ORDERBYNUM ,ORDERBYDIR ,GROUPBYNUM FROM pscpqfield WHERE 1=0

PeopleSoft Field Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
CPQNAME Character(30) VARCHAR2(30) NOT NULL Composite Query
SELNUM Number(2,0) SMALLINT NOT NULL Select Number
CPQQRYALIAS Character(30) VARCHAR2(30) NOT NULL Child Query Alias
QRYFLDNAME Character(30) VARCHAR2(30) NOT NULL Source Field
COLUMNNUM Number(3,0) SMALLINT NOT NULL Column Number
ORDERBYNUM Number(3,0) SMALLINT NOT NULL Order-By Number
GROUPBYNUM Number(3,0) SMALLINT NOT NULL Group-By Number
ORDERBYDIR Character(1) VARCHAR2(1) NOT NULL Order-By Direction
A=Ascending
D=Descending

Default: A

index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19