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 NameField TypeColumn TypeDescription
APPR_RULE_SETCharacter(30)VARCHAR2(30) NOT NULLApproval Rule Set
EFFDTDate(10)DATEEffective Date
APPR_STEPCharacter(3)VARCHAR2(3) NOT NULLApproval 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_PATHCharacter(3)VARCHAR2(3) NOT NULLApproval Path
A=Approval Path A
B=Approval Path B
C=Approval Path C
D=Approval Path D
E=Approval Path E
APPR_SKIP_SWCharacter(1)VARCHAR2(1) NOT NULLApproval Skip Switch

Y/N Table Edit

Default: N

ROLENAMECharacter(30)VARCHAR2(30) NOT NULLThe name of a Role in the Role Definition Table (see PSROLEDEFN).
APPR_WF_ERR_SWCharacter(1)VARCHAR2(1) NOT NULLWorkflow/Error Switch
E=Error Message
M=Message Only
MESSAGE_SET_NBRNumber(5,0)INTEGER NOT NULLMessage Set Number. This field refers to the Message Set Number in the Message Catalog.
MESSAGE_NBRNumber(5,0)INTEGER NOT NULLMessage Number. This field refers to the Message Number in the Message Catalog.
EVENTNAMECharacter(30)VARCHAR2(30) NOT NULLDefines a routing event for PS Workflow
RECYCLE_EVENTNAMECharacter(30)VARCHAR2(30) NOT NULLRecyle Event Name
ACTIVITYNAMECharacter(30)VARCHAR2(30) NOT NULLName of a Business Process Activity (see PSACTIVITYDEFN).
DENY_ACTIVITYNAMECharacter(30)VARCHAR2(30) NOT NULLDeny Activity Name
RECYCLE_ACTIVITYCharacter(30)VARCHAR2(30) NOT NULLRecycle Activity Name
APPR_ACTIVE_SWCharacter(1)VARCHAR2(1) NOT NULLApproval Check Active
CURRENCY_CDCharacter(3)VARCHAR2(3) NOT NULLCurrency Code
CUR_RT_TYPECharacter(5)VARCHAR2(5) NOT NULLCurrency Rate Type
RECNAME_CURCharacter(15)VARCHAR2(15) NOT NULLCurrency Record
FIELDNAME_CURCharacter(18)VARCHAR2(18) NOT NULLCurrency Field
APPR_ACTIVITYNAMECharacter(30)VARCHAR2(30) NOT NULLApproval Activity Name
APPR_EVENTNAMECharacter(30)VARCHAR2(30) NOT NULLApproval Event Name
BUSPROCNAMECharacter(30)VARCHAR2(30) NOT NULLBusiness Process Name (see PSBUSPROCDEFN).
index back(c)David Kurtz 2019, 8.54
PTRef generated on 09-JUN-19