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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19