PSCPQMAPVW

index back

SELECT OPRID ,CPQNAME ,CPQQRYALIAS ,QRYNAMECHILD ,CPQQRYALIASPAR ,QRYNAMEPARENT ,JOINTYPE FROM PSCPQMAP 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
QRYNAMECHILDCharacter(30)VARCHAR2(30) NOT NULLChild Query Name
CPQQRYALIASPARCharacter(30)VARCHAR2(30) NOT NULLParent Query Alias
QRYNAMEPARENTCharacter(30)VARCHAR2(30) NOT NULLConnected Queries Parent Query Name
JOINTYPENumber(1,0)SMALLINT NOT NULLJoin Type
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19