OPRIDCPQNAMECRTNUMPSCPQCRITERIAVW |
index back |
|---|
| SELECT OPRID ,CPQNAME ,CRTNUM ,COMBTYPE ,NEGATION ,LPARENLVL ,RPARENLVL ,CPQQRYALIAS ,QRYFLDNAME ,CPQLCRTEXPNUM ,CONDTYPE , ' ' , ' ' ,EXPRTYPE , ' ' , CPQR1CRTQRYALIAS , CPQR1CRTFLDNAME , CPQR1CRTEXPNUM , CPQR2CRTQRYALIAS , CPQR2CRTFLDNAME , CPQR2CRTEXPNUM FROM PSCPQCRITERIA 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 |
| CRTNUM |
Number(3,0) | SMALLINT NOT NULL | Criteria Number |
| COMBTYPE | Number(1,0) | SMALLINT NOT NULL | Combination Type |
| NEGATION | Character(1) | VARCHAR2(1) NOT NULL | Negation |
| LPARENLVL | Number(2,0) | SMALLINT NOT NULL | Left Paren Level |
| RPARENLVL | Number(2,0) | SMALLINT NOT NULL | Right Paren Level |
| CPQQRYALIAS | Character(30) | VARCHAR2(30) NOT NULL | Child Query Alias |
| QRYFLDNAME | Character(30) | VARCHAR2(30) NOT NULL | Source Field |
| CPQLCRTEXPNUM | Number(3,0) | SMALLINT NOT NULL | Left Criteria Expressio |
| CONDTYPE | Number(2,0) | SMALLINT NOT NULL | Condition Type |
| CPQQRYALIASRIGHT | Character(30) | VARCHAR2(30) NOT NULL | Query Alias |
| CPQQRYFIELDRIGHT | Character(30) | VARCHAR2(30) NOT NULL | Query Field |
| EXPRTYPE | Number(2,0) | SMALLINT NOT NULL | Expression Type |
| EXPRESSIONTEXT | Long Character | CLOB | Expression Text |
| CPQR1CRTQRYALIAS | Character(30) | VARCHAR2(30) NOT NULL | Query Alias |
| CPQR1CRTFLDNAME | Character(30) | VARCHAR2(30) NOT NULL | Query Field |
| CPQR1CRTEXPNUM | Number(3,0) | SMALLINT NOT NULL | Right1 Criteria Expression No. |
| CPQR2CRTQRYALIAS | Character(30) | VARCHAR2(30) NOT NULL | Query Alias |
| CPQR2CRTFLDNAME | Character(30) | VARCHAR2(30) NOT NULL | Query Field |
| CPQR2CRTEXPNUM | Number(3,0) | SMALLINT NOT NULL | Right1 Criteria Expression No. |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |