PV_WF_RULE(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PV_RULEID |
Character(12) | VARCHAR2(12) NOT NULL | Rule Id |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | PV_WF_RULE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Rule Type
O=On Behalf Q=Dynamic S=Static U=Upgrade Default Value: S |
| 4 | SEQUENCE_NBR | Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | PV_ESCALATE | Character(1) | VARCHAR2(1) NOT NULL |
Check box on eProcurement Workflow Rule Page.
Y/N Table Edit Default Value: N |
| 6 | PV_NUMBER_DAYS | Number(3,0) | SMALLINT NOT NULL | Number of Days |
| 7 | PV_NUMBER_HOURS | Number(2,0) | SMALLINT NOT NULL | Number of Hours |
| 8 | PV_EMAIL_USER | Character(1) | VARCHAR2(1) NOT NULL |
Check box on eProcurement Workflow Rule page.
Y/N Table Edit Default Value: N |
| 9 | PV_EMAIL_SUPR | Character(1) | VARCHAR2(1) NOT NULL |
Check box on eProcurement Workflow Rule page.
Y/N Table Edit Default Value: N |
| 10 | PV_ROUTE_NEXT_STEP | Character(1) | VARCHAR2(1) NOT NULL |
Route to Next Step
Y/N Table Edit Default Value: N |
| 11 | PV_WF_SUPPRESS_DIS | Character(1) | VARCHAR2(1) NOT NULL |
Suppress Unrouted Rows
D=Display All Rows S=Suppress Unrouted Rows Default Value: D |
| 12 | DESCRLONG | Long Character | CLOB | Long Description |