APPR_RULE_VW |
index back |
|---|---|
Approval Rule Defn View |
| SELECT a.APPR_RULE_SET , a.EFFDT , a.APPR_STEP , a.APPR_PATH , a.APPR_SKIP_SW , a.ROLENAME , a.APPR_WF_ERR_SW , a.MESSAGE_SET_NBR , a.MESSAGE_NBR , a.EVENTNAME , a.DENY_EVENTNAME , a.RECYCLE_EVENTNAME , a.ACTIVITYNAME , a.DENY_ACTIVITYNAME , a.RECYCLE_ACTIVITY , b.appr_active_sw , b.currency_cd , b.cur_rt_type , b.recname_cur , b.fieldname_cur , b.activityname , b.eventname , b.self_approval , b.BUSPROCNAME FROM PS_APPR_RULE_DETL a , ps_appr_rule_hdr b WHERE a.appr_rule_set = b.appr_rule_set AND a.effdt = b.effdt AND a.effdt = ( SELECT MAX(c.effdt) FROM PS_APPR_RULE_DETL c WHERE a.appr_rule_set = c.appr_rule_set AND c.effdt <= %CurrentDateIn) |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
 APPR_RULE_SET |
Character(30) | VARCHAR2(30) NOT NULL | Approval Rule Set |
| EFFDT |
Date(10) | DATE | Effective Date |
| APPR_STEP |
Character(3) | VARCHAR2(3) NOT NULL |
Approval Step
1=Approval Step 1 2=Approval Step 2 3=Approval Step 3 4=Approval Step 4 5=Approval Step 5 6=Approval Step 6 7=Approval Step 7 8=Approval Step 8 9=Approval Step 9 |
| APPR_PATH |
Character(3) | VARCHAR2(3) NOT NULL |
Approval Path
A=Approval Path A B=Approval Path B C=Approval Path C D=Approval Path D E=Approval Path E |
| APPR_SKIP_SW | Character(1) | VARCHAR2(1) NOT NULL |
Approval Skip Switch
Y/N Table Edit Default: N |
| ROLENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| APPR_WF_ERR_SW | Character(1) | VARCHAR2(1) NOT NULL |
Workflow/Error Switch
B=Both E=Error Message M=Message Only W=Workflow |
| MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL | Defines a routing event for PS Workflow |
| DENY_EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL | Deny Event |
| RECYCLE_EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL | Recyle Event Name |
| ACTIVITYNAME | Character(30) | VARCHAR2(30) NOT NULL | Name of a Business Process Activity (see PSACTIVITYDEFN). |
| DENY_ACTIVITYNAME | Character(30) | VARCHAR2(30) NOT NULL | Deny Activity Name |
| RECYCLE_ACTIVITY | Character(30) | VARCHAR2(30) NOT NULL | Recycle Activity Name |
| APPR_ACTIVE_SW | Character(1) | VARCHAR2(1) NOT NULL | Approval Check Active |
| CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Currency Rate Type |
| RECNAME_CUR | Character(15) | VARCHAR2(15) NOT NULL | Currency Record |
| FIELDNAME_CUR | Character(18) | VARCHAR2(18) NOT NULL | Currency Field |
| APPR_ACTIVITYNAME | Character(30) | VARCHAR2(30) NOT NULL | Approval Activity Name |
| APPR_EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL | Approval Event Name |
| SELF_APPROVAL | Number(3,0) | SMALLINT NOT NULL | Can Self Approve |
| BUSPROCNAME | Character(30) | VARCHAR2(30) NOT NULL | Business Process Name (see PSBUSPROCDEFN). |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |