PSCPQMAPVW

index back

SELECT OPRID ,CPQNAME ,CPQQRYALIAS ,QRYNAMECHILD ,CPQQRYALIASPAR ,QRYNAMEPARENT ,JOINTYPE FROM PSCPQMAP 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
CPQQRYALIAS Character(30) VARCHAR2(30) NOT NULL Child Query Alias
QRYNAMECHILD Character(30) VARCHAR2(30) NOT NULL Child Query Name
CPQQRYALIASPAR Character(30) VARCHAR2(30) NOT NULL Parent Query Alias
QRYNAMEPARENT Character(30) VARCHAR2(30) NOT NULL Connected Queries Parent Query Name
JOINTYPE Number(1,0) SMALLINT NOT NULL Join Type
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19