PSCPQCRITERIAVW

index back

SELECT OPRID ,CPQNAME ,CRTNUM ,COMBTYPE ,NEGATION ,LPARENLVL ,RPARENLVL ,CPQQRYALIAS ,QRYFLDNAME ,CONDTYPE , ' ' , ' ' ,EXPRTYPE , ' ' , CPQR1CRTQRYALIAS , CPQR1CRTFLDNAME , CPQR1CRTEXPNUM , CPQR2CRTQRYALIAS , CPQR2CRTFLDNAME , CPQR2CRTEXPNUM FROM PSCPQCRITERIA 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
CRTNUMNumber(3,0)SMALLINT NOT NULLCriteria Number
COMBTYPENumber(1,0)SMALLINT NOT NULLCombination Type
NEGATIONCharacter(1)VARCHAR2(1) NOT NULLNegation
LPARENLVLNumber(2,0)SMALLINT NOT NULLLeft Paren Level
RPARENLVLNumber(2,0)SMALLINT NOT NULLRight Paren Level
CPQQRYALIASCharacter(30)VARCHAR2(30) NOT NULLChild Query Alias
QRYFLDNAMECharacter(30)VARCHAR2(30) NOT NULLSource Field
CONDTYPENumber(2,0)SMALLINT NOT NULLCondition Type
CPQQRYALIASRIGHTCharacter(30)VARCHAR2(30) NOT NULLQuery Alias
CPQQRYFIELDRIGHTCharacter(30)VARCHAR2(30) NOT NULLQuery Field
EXPRTYPENumber(2,0)SMALLINT NOT NULLExpression Type
EXPRESSIONTEXTLong CharacterCLOBExpression Text
CPQR1CRTQRYALIASCharacter(30)VARCHAR2(30) NOT NULLQuery Alias
CPQR1CRTFLDNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Field
CPQR1CRTEXPNUMNumber(3,0)SMALLINT NOT NULLRight1 Criteria Expression No.
CPQR2CRTQRYALIASCharacter(30)VARCHAR2(30) NOT NULLQuery Alias
CPQR2CRTFLDNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Field
CPQR2CRTEXPNUMNumber(3,0)SMALLINT NOT NULLRight1 Criteria Expression No.
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19