PTAFAW_NOT_USER

index back

Notification setup table

Used to store the different notification user lists. Used at the time of an approval event being fired.

PeopleSoft Field Name Field Type Column Type Description
PTAFPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
PTAFLEVEL Number(1,0) SMALLINT NOT NULL Level e.g. Header = 0, Line = 1.
0=Header
1=Line
PTAFEVENT Character(3) VARCHAR2(3) NOT NULL Approval Workflow Events for Notification
A=On Final Approval
AD=Ad Hoc Delete
AH=Ad Hoc Insert
B=Push Back
D=On Final Denial
E=On Error
ES=On Escalate
H=Hold Step
L=Locked Out
NAN=No Approver Necessary
PC=Processing Complete
PL=On Process Launch
R=On Reactivate
RA=Route for Approval
RI=Request Information
RIA=Request Information Added
RR=Route for Review
RS=On Reassign
SC=On Step Complete
T=On Terminate
PTAFPARTICIPANT Character(3) VARCHAR2(3) NOT NULL Approval Workflow Events for Notification
A=Approvers
D=Dynamic
DA=Delegate Approver
DR=Delegate Requester
PA=Proxy Approver
PR=Proxy Requester
R=Requester
S=Administrator
U=User List
V=Reviewers
PTAFUSER_LIST_ID Character(30) VARCHAR2(30) NOT NULL Identifies the user list to be used when creating the approval process.

Prompt Table: PTAFUSER_LIST

PTAFCHANNEL Character(1) VARCHAR2(1) NOT NULL Notification Channel
0=None
1=Email
2=Worklist
3=Email and Worklist
4=User Preference

Default: 3

WL_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Template Name

Prompt Table: WL_TEMPL_GEN_VW

MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

Prompt Table: PSMENUDEFN_VW

PTAFAPPR_COMPONENT Character(18) VARCHAR2(18) NOT NULL Approval Component

Prompt Table: PTAFMENU_PNL_VW

PAGE_NAME Character(18) VARCHAR2(18) NOT NULL Page Name

Prompt Table: PTAFAW_PNL_VW

PTAFMENU_ACTION Character(1) VARCHAR2(1) NOT NULL Menu Action
A=Add
C=Correction
E=Data Entry
L=Update/Display All
U=Update

Default: U

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)

    Prompt Table: SQLID_VW

  • WL_PRIORITY Character(1) VARCHAR2(1) NOT NULL Worklist Priority
    1=1-High
    2=2-Medium
    3=3-Low

    Default: 3

    PTAFNUMBER_HOURS Number(2,0) SMALLINT NOT NULL Number of Hours
    PTAFNOTIFY_INTERVL Number(3,0) SMALLINT NOT NULL Notification Interval
    PTAFMAX_SEND Number(3,0) SMALLINT NOT NULL Max Notification

    Default: 1

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