APPR_RULE_VW(SQL View) |
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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  APPR_RULE_SET |
Character(30) | VARCHAR2(30) NOT NULL | Approval Rule Set |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | 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 |
| 4 | 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 |
| 5 | APPR_SKIP_SW | Character(1) | VARCHAR2(1) NOT NULL |
Approval Skip Switch
Y/N Table Edit Default Value: N |
| 6 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 7 | APPR_WF_ERR_SW | Character(1) | VARCHAR2(1) NOT NULL |
Workflow/Error Switch
B=Both E=Error Message M=Message Only W=Workflow |
| 8 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 9 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 10 | EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL | Defines a routing event for PS Workflow |
| 11 | DENY_EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL | Deny Event |
| 12 | RECYCLE_EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL | Recyle Event Name |
| 13 | ACTIVITYNAME | Character(30) | VARCHAR2(30) NOT NULL | Name of a Business Process Activity (see PSACTIVITYDEFN). |
| 14 | DENY_ACTIVITYNAME | Character(30) | VARCHAR2(30) NOT NULL | Deny Activity Name |
| 15 | RECYCLE_ACTIVITY | Character(30) | VARCHAR2(30) NOT NULL | Recycle Activity Name |
| 16 | APPR_ACTIVE_SW | Character(1) | VARCHAR2(1) NOT NULL | Approval Check Active |
| 17 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 18 | CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Currency Rate Type |
| 19 | RECNAME_CUR | Character(15) | VARCHAR2(15) NOT NULL | Currency Record |
| 20 | FIELDNAME_CUR | Character(18) | VARCHAR2(18) NOT NULL | Currency Field |
| 21 | APPR_ACTIVITYNAME | Character(30) | VARCHAR2(30) NOT NULL | Approval Activity Name |
| 22 | APPR_EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL | Approval Event Name |
| 23 | SELF_APPROVAL | Number(3,0) | SMALLINT NOT NULL | Can Self Approve |
| 24 | BUSPROCNAME | Character(30) | VARCHAR2(30) NOT NULL | Business Process Name (see PSBUSPROCDEFN). |