OPRIDCPQNAMECRTNUMPSCPQCRITERIAVW(SQL View) |
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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | CPQNAME |
Character(30) | VARCHAR2(30) NOT NULL | Composite Query |
| 3 | CRTNUM |
Number(3,0) | SMALLINT NOT NULL | Criteria Number |
| 4 | COMBTYPE | Number(1,0) | SMALLINT NOT NULL | Combination Type |
| 5 | NEGATION | Character(1) | VARCHAR2(1) NOT NULL | Negation |
| 6 | LPARENLVL | Number(2,0) | SMALLINT NOT NULL | Left Paren Level |
| 7 | RPARENLVL | Number(2,0) | SMALLINT NOT NULL | Right Paren Level |
| 8 | CPQQRYALIAS | Character(30) | VARCHAR2(30) NOT NULL | Child Query Alias |
| 9 | QRYFLDNAME | Character(30) | VARCHAR2(30) NOT NULL | Source Field |
| 10 | CPQLCRTEXPNUM | Number(3,0) | SMALLINT NOT NULL | Left Criteria Expressio |
| 11 | CONDTYPE | Number(2,0) | SMALLINT NOT NULL | Condition Type |
| 12 | CPQQRYALIASRIGHT | Character(30) | VARCHAR2(30) NOT NULL | Query Alias |
| 13 | CPQQRYFIELDRIGHT | Character(30) | VARCHAR2(30) NOT NULL | Query Field |
| 14 | EXPRTYPE | Number(2,0) | SMALLINT NOT NULL | Expression Type |
| 15 | EXPRESSIONTEXT | Long Character | CLOB | Expression Text |
| 16 | CPQR1CRTQRYALIAS | Character(30) | VARCHAR2(30) NOT NULL | Query Alias |
| 17 | CPQR1CRTFLDNAME | Character(30) | VARCHAR2(30) NOT NULL | Query Field |
| 18 | CPQR1CRTEXPNUM | Number(3,0) | SMALLINT NOT NULL | Right1 Criteria Expression No. |
| 19 | CPQR2CRTQRYALIAS | Character(30) | VARCHAR2(30) NOT NULL | Query Alias |
| 20 | CPQR2CRTFLDNAME | Character(30) | VARCHAR2(30) NOT NULL | Query Field |
| 21 | CPQR2CRTEXPNUM | Number(3,0) | SMALLINT NOT NULL | Right1 Criteria Expression No. |