OPRIDRUN_CNTL_IDSELNUMCRTNUMQRY_RUN_TREEPRM | index back |
|---|---|
Rcd for Treeprmpt params |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| QRYNAME | Character(30) | VARCHAR2(30) NOT NULL | Query Name |
| SELNUM | Number(2,0) | SMALLINT NOT NULL | Select Number |
| CRTNUM | Number(3,0) | SMALLINT NOT NULL | Criteria Number |
| FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| EXPRESSIONTEXT | Long Character | CLOB | Expression Text |
| index back | (c)David Kurtz 2019, www.go-faster.co.uk | PeopleTools 8.54 PTRef generated on 09-JUN-19 |