APPR_RULE_DETL

index back

Approval Rule Defn Details


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

Default: 1

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

Default: A

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).

Prompt Table: ROLE_USRLST_VW

APPR_WF_ERR_SW Character(1) VARCHAR2(1) NOT NULL Workflow/Error Switch
B=Both
E=Error Message
M=Message Only
W=Workflow

Default: W

MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

Prompt Table: PSMSGSETDEFN

MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

Prompt Table: PSMSGCATDEFN

SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
  • SQLTYPE = 0: SQL object name
  • SQLTYPE = 1: Application Engine Step Identifier
  • SQLTYPE = 2: RECNAME
  • SQLTYPE = 6: Application Engine XSLT (XML definition)
  • EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow

    Prompt Table: WF_ACT_EVT_VW

    DENY_EVENTNAME Character(30) VARCHAR2(30) NOT NULL Deny Event

    Prompt Table: WF_ACT_EVT_VW2

    RECYCLE_EVENTNAME Character(30) VARCHAR2(30) NOT NULL Recyle Event Name

    Prompt Table: WF_ACT_EVT_VW3

    ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).

    Prompt Table: WF_BP_ACT_VW

    DENY_ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Deny Activity Name

    Prompt Table: WF_BP_ACT_VW

    RECYCLE_ACTIVITY Character(30) VARCHAR2(30) NOT NULL Recycle Activity Name

    Prompt Table: WF_BP_ACT_VW

    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19