PV_WF_RULE_STEP(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 | STEP |
Number(2,0) | SMALLINT NOT NULL | Step |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | PV_ROLETYPE | Character(1) | VARCHAR2(1) NOT NULL |
Role Type
A=Added Q=Query R=Reviewer U=User List Default Value: U |
| 5 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL |
The name of a Role in the Role Definition Table (see PSROLEDEFN).
Prompt Table: PSROLEDEFN_VW |
| 6 | PV_QRY_ROLENAME | Character(30) | VARCHAR2(30) NOT NULL |
Query Role Name
Prompt Table: PV_PSSQLDEFN_VW |
| 7 | PV_QRY_AMOUNT | Character(30) | VARCHAR2(30) NOT NULL |
Amount Query Name
Prompt Table: PV_PSSQLDEFN_VW |
| 8 | PV_APPROVERTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Approver Type
A=Approver R=Reviewer Default Value: A |
| 9 | PV_SKIPSTEP | Character(1) | VARCHAR2(1) NOT NULL |
Skip Step
Y/N Table Edit Default Value: N |
| 10 | PV_STOPRULE | Character(1) | VARCHAR2(1) NOT NULL |
Stop Rule
Y/N Table Edit Default Value: N |
| 11 | PV_CRITERIA_REQD | Character(1) | VARCHAR2(1) NOT NULL |
Fulfill Criteria
A=All N=Any Default Value: A |
| 12 | PV_SELF_APPROVAL | Character(1) | VARCHAR2(1) NOT NULL |
Allow Self Approval
Y/N Table Edit Default Value: N |
| 13 | PV_APPR_AMOUNT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Self Approval Amount |