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 EOAW_EMAIL Character(1) VARCHAR2(1) NOT NULL Email Notification flag

Default Value: N

4 EOAW_WORKLIST Character(1) VARCHAR2(1) NOT NULL Worklist notification flag

Default Value: N

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

Prompt Table: PSMENUDEFN_VW

6 EOAWAPPR_COMPONENT Character(18) VARCHAR2(18) NOT NULL Approval Component

Prompt Table: EOAWMENU_PNL_VW

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

Prompt Table: EOAW_PNL_VW

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

Default Value: U

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