APPR_RULE_DETL

index back

Approval Rule Defn Details


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

Default: 1

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

Default: A

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

Prompt Table: ROLE_USRLST_VW

APPR_WF_ERR_SWCharacter(1)VARCHAR2(1) NOT NULLWorkflow/Error Switch
B=Both
E=Error Message
M=Message Only
W=Workflow

Default: W

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

Prompt Table: PSMSGSETDEFN

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

Prompt Table: PSMSGCATDEFN

SQLIDCharacter(30)VARCHAR2(30) NOT NULLSQL 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)
  • EVENTNAMECharacter(30)VARCHAR2(30) NOT NULLDefines a routing event for PS Workflow

    Prompt Table: WF_ACT_EVT_VW

    DENY_EVENTNAMECharacter(30)VARCHAR2(30) NOT NULLDeny Event

    Prompt Table: WF_ACT_EVT_VW2

    RECYCLE_EVENTNAMECharacter(30)VARCHAR2(30) NOT NULLRecyle Event Name

    Prompt Table: WF_ACT_EVT_VW3

    ACTIVITYNAMECharacter(30)VARCHAR2(30) NOT NULLName of a Business Process Activity (see PSACTIVITYDEFN).

    Prompt Table: WF_BP_ACT_VW

    DENY_ACTIVITYNAMECharacter(30)VARCHAR2(30) NOT NULLDeny Activity Name

    Prompt Table: WF_BP_ACT_VW

    RECYCLE_ACTIVITYCharacter(30)VARCHAR2(30) NOT NULLRecycle Activity Name

    Prompt Table: WF_BP_ACT_VW

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