PSCPQSELECTVW

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 NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
CPQNAMECharacter(30)VARCHAR2(30) NOT NULLComposite Query
CPQQRYALIASCharacter(30)VARCHAR2(30) NOT NULLChild Query Alias
QRYFLDNAMECharacter(30)VARCHAR2(30) NOT NULLSource Field
COLUMNNUMNumber(3,0)SMALLINT NOT NULLColumn Number
ORDERBYNUMNumber(3,0)SMALLINT NOT NULLOrder-By Number
GROUPBYNUMNumber(3,0)SMALLINT NOT NULLGroup-By Number
ORDERBYDIRCharacter(1)VARCHAR2(1) NOT NULLOrder-By Direction
A=Ascending
D=Descending

Default: A

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