HR_USERLIST_NLD

(SQL Table)
 Index Back

HR Action Notification NLD

HR Action Notification NLD; used to map notification before sending. See: HR_ACTN_NLD app. engine process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 WL_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Template Name
3 PTAFCHANNEL Character(1) VARCHAR2(1) NOT NULL Notification Channel
0=None
1=Email
2=Worklist
3=Email and Worklist
4=User Preference
4 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).

Prompt Table: PSMENUDEFN_VW

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

Prompt Table: PTAFMENU_PNL_VW

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

Prompt Table: PTAFAW_PNL_VW

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

Default Value: U

8 WL_PRIORITY Character(1) VARCHAR2(1) NOT NULL Worklist Priority
1=1-High
2=2-Medium
3=3-Low
9 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)
    • 10 PTAFNUMBER_HOURS Number(2,0) SMALLINT NOT NULL Number of Hours
    11 PTAFNOTIFY_INTERVL Number(3,0) SMALLINT NOT NULL Notification Interval
    12 PTAFMAX_SEND Number(3,0) SMALLINT NOT NULL Max Notification
    13 DESCRLONG Long Character CLOB Long Description