PRC_ORD_TMPL_IDPRC_PRI_SEQ_NOPRC_SUBPRI_SEQ_NO1=Equal
2=Not Equal
3=Greater than
4=Less than
5=Greater or Equal
6=Less or Equal
7=Begins with
PRC_ORD_TMPL_SP(SQL Table) |
Index Back |
|---|---|
Processing Order Sub PriorityProcessing Order Field's Sub Priority |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PRC_ORD_TMPL_ID |
Character(25) | VARCHAR2(25) NOT NULL | Processsing Order Template ID |
| 2 | PRC_PRI_SEQ_NO |
Number(3,0) | SMALLINT NOT NULL | Priority Sequence Number |
| 3 | PRC_SUBPRI_SEQ_NO |
Number(3,0) | SMALLINT NOT NULL | Sub Priority Sequence Number |
| 4 | PRC_ORD_PRIORITY | Number(3,0) | SMALLINT NOT NULL | Processing Order Template Field Priority |
| 5 | PRC_ORD_SUB_PRIORI | Number(3,0) | SMALLINT NOT NULL | Processing Order Template Field Sub Priority or Field Filter |
| 6 | PRC_ORD_LOGIC_OPER | Character(1) | VARCHAR2(1) NOT NULL |
Logical Operator
1=Equal 2=Not Equal 3=Greater than 4=Less than 5=Greater or Equal 6=Less or Equal 7=Begins with |
| 7 | PRC_ORD_VALTOMATCH | Character(250) | VARCHAR2(250) NOT NULL | Processing Order Template Field's Value to match |