| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EONC_NOTIF_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Notification Name
|
| 2 |
DESCR100 |
Character(100) |
VARCHAR2(100) NOT NULL |
Length 100 Description
|
| 3 |
EONC_NOTIF_CAT |
Character(4) |
VARCHAR2(4) NOT NULL |
Notification Event Source (source of the notification):
APPL - Application Code (default)
AWE - Approvals Framework
EOEN - Enterprise Objects Events and Notifications Framework
AGC - Activity Guide Composer
EOQF - Questionnaire Framework
AGC=Activity Guide Composer
APPL=Applications Notification
AWE=Approval Workflow
EOEN=EO Events & Notifications
EOQF=Questionnaire Framework
Default Value: APPL
|
| 4 |
EONC_PTNOTIF_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
PeopleTools Notification Name
Prompt Table:
%EDITTABLE
|
| 5 |
EONC_PROCESS_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Business Process Name
Prompt Table:
EONC_PROC_TBL
|
| 6 |
OBJECTOWNERID |
Character(4) |
VARCHAR2(4) NOT NULL |
Object owner identifier
|
| 7 |
EONC_NOTIF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Notification Status: A - Active, I - Inactive, D - Draft.
A=Active
D=Draft
I=Inactive
Default Value: A
|
| 8 |
EONC_DRAFT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Draft Status
Y/N Table Edit
Default Value: N
|
| 9 |
PACKAGEROOT |
Character(30) |
VARCHAR2(30) NOT NULL |
Package Name
Default Value: EONC_NOTIFICATIONS
Prompt Table:
PSPACKAGROOT_VW
|
| 10 |
APPCLASS_PATH |
Character(254) |
VARCHAR2(254) NOT NULL |
Application Class Full Path
Default Value: :
Prompt Table:
EONC_PATH_VW
|
| 11 |
APP_CLASS |
Character(254) |
VARCHAR2(254) NOT NULL |
Implementation App Class
Default Value: Notification
Prompt Table:
EONC_CLASS_VW
|
| 12 |
EONC_USER_LIST_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Identifies the user list to be used when creating the notification.
Prompt Table:
EONC_ULST_PR_VW
|
| 13 |
PORTAL_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Portal Name (see PSPRDMDEFN).
Prompt Table:
EONC_PTL_LKP_VW
|
| 14 |
MENUNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Menu Name (see PSMENUDEFN).
Prompt Table:
EONC_MNU_LKP_VW
|
| 15 |
PNLGRPNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Component Name
Prompt Table:
EONC_CMP_LKP_VW
|
| 16 |
MARKET |
Character(3) |
VARCHAR2(3) NOT NULL |
Market
Prompt Table:
EONC_MKT_LKP_VW
|
| 17 |
PAGE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Page Name
Prompt Table:
EONC_PGE_LKP_VW
|
| 18 |
EONC_AGC_CATEGORY |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity Guide Category
Prompt Table:
%EDITTABLE2
|
| 19 |
EONC_ACCESS_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Component access mode.
A=Add
C=Correction
E=Data Entry
L=Update/Display All
U=Update/Display
|
| 20 |
EONC_PRIORITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Notification priority.
0=Medium
1=High
2=Low
Default Value: 0
|
| 21 |
EONC_NOTTYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Notification Type
A - Actionable
I - Alert
A=Actionable
I=Alert
Default Value: I
|
| 22 |
EONC_LOGGING_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable notification logging flag.
Y/N Table Edit
Default Value: N
|
| 23 |
EONC_MARK_WRK_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Marked Work checkbox for actionable notifications
Y/N Table Edit
Default Value: N
|
| 24 |
EONC_EMAIL_SRC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Source for email message content: message catalog or custom text.
C=Custom Text
M=Message Catalog
T=Email Template
Default Value: M
|
| 25 |
EONC_EMAIL_MSG |
Long Character |
CLOB |
Message Text
|
| 26 |
EONC_EMAIL_MSGSET |
Number(5,0) |
INTEGER NOT NULL |
Email Body Message Set Number
Prompt Table:
EONC_MSGSET_VW
|
| 27 |
EONC_EMAIL_MSGNBR |
Number(5,0) |
INTEGER NOT NULL |
Notification email content message catalog number.
Prompt Table:
EONC_EML_MSGVW
|
| 28 |
EONC_EMAIL_MSG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use message catalog text or explain for email message content.
E=Description
T=Message Text
Default Value: T
|
| 29 |
EONC_EMAIL_SUBJ |
Character(254) |
VARCHAR2(254) NOT NULL |
Notification email subject content.
|
| 30 |
EONC_EMSBJ_MSGSET |
Number(5,0) |
INTEGER NOT NULL |
Email Body Message Set Number
Prompt Table:
EONC_MSGSET_VW
|
| 31 |
EONC_EMSBJ_MSGNBR |
Number(5,0) |
INTEGER NOT NULL |
Notification email subject message catalog number.
Prompt Table:
EONC_EMLS_MSGVW
|
| 32 |
EONC_EMSBJ_MSG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use message catalog text or explain for email subject content.
E=Description
T=Message Text
Default Value: T
|
| 33 |
EONC_PUSH_SRC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Source for in-app message content: message catalog or custom text.
C=Custom Text
M=Message Catalog
Default Value: M
|
| 34 |
EONC_PUSH_MSG |
Character(254) |
VARCHAR2(254) NOT NULL |
Notification push message content.
|
| 35 |
EONC_PUSH_MSGSET |
Number(5,0) |
INTEGER NOT NULL |
In-App Messaeg Set Number
Prompt Table:
EONC_MSGSET_VW
|
| 36 |
EONC_PUSH_MSGNBR |
Number(5,0) |
INTEGER NOT NULL |
Notification push content message catalog number.
Prompt Table:
EONC_PUSH_MSGVW
|
| 37 |
EONC_PUSH_MSG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use message text or explain.
E=Description
T=Message Text
Default Value: T
|
| 38 |
EONC_TEXT_SRC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Source for text message content: message catalog or custom text.
C=Custom Text
M=Message Catalog
Default Value: M
|
| 39 |
EONC_TEXT_MSG |
Character(254) |
VARCHAR2(254) NOT NULL |
Notification text message content.
|
| 40 |
EONC_TEXT_MSGSET |
Number(5,0) |
INTEGER NOT NULL |
Text Message Set Number
Prompt Table:
EONC_MSGSET_VW
|
| 41 |
EONC_TEXT_MSGNBR |
Number(5,0) |
INTEGER NOT NULL |
Notification text content message catalog number.
Prompt Table:
EONC_TEXT_MSGVW
|
| 42 |
EONC_TEXT_MSG_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Use message catalog text or explain for text message content.
E=Description
T=Message Text
Default Value: T
|
| 43 |
EONC_EMFRM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Sender flag:
C - Specify
L - Dynamic
S - System Default (%SMTPSender)
U - User (%EmailAddress)
C=Specify
L=Dynamic
S=System Default
U=User
Default Value: U
|
| 44 |
EONC_EMFRM_UL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Identifies the user list to be used for the From email.
Prompt Table:
EONC_ULST_PR_VW
|
| 45 |
EONC_EMAIL_FROM |
Character(254) |
VARCHAR2(254) NOT NULL |
Email From
|
| 46 |
EONC_EMRPL_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Reply-to flag:
C - Specify
L - User List
S - Sender
C=Specify
L=Dynamic
S=Sender
Default Value: S
|
| 47 |
EONC_EMRPL_UL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Identifies the user list to be used for the Reply-to email.
Prompt Table:
EONC_ULST_PR_VW
|
| 48 |
EONC_EMAIL_REPLYTO |
Character(254) |
VARCHAR2(254) NOT NULL |
Reply To
|
| 49 |
WL_TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Template Name
Prompt Table:
WL_TEMPLATE_GEN
|
| 50 |
EONC_ITEM_ID |
Character(31) |
VARCHAR2(31) NOT NULL |
Action Items - Action Item ID
|
| 51 |
DATA_TYPE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Type Code
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N
|
| 52 |
LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 53 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|