| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 QRYNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Query Name
Prompt Table:
EOEN_QRYDEFN_VW
|
| 2 |
EOEN_PRCS_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
EOEN Process Name
Prompt Table:
EOEN_PRCS_VW
|
| 3 |
EOEN_CATEGORY |
Character(30) |
VARCHAR2(30) NOT NULL |
EOEN Category
Prompt Table:
EOEN_REG
|
| 4 |
EOEN_PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
Prompt Table:
EOEN_AL_PROD_VW
|
| 5 |
EOEN_AL_INTERVAL |
Number(3,0) |
SMALLINT NOT NULL |
Notification Interval (hours)
|
| 6 |
EOEN_LAST_DTTIME |
DateTime(26) |
TIMESTAMP |
Last Date Time
|
| 7 |
EOEN_ACTIVE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Event Status
N=Inactive
Y=Active
Y/N Table Edit
Default Value: Y
|
| 8 |
MENUNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Menu Name (see PSMENUDEFN).
Prompt Table:
EOEN_AL_MENU_VW
|
| 9 |
PNLGRPNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Component Name
Prompt Table:
PSMENUCOMP_VW
|
| 10 |
PANELNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Panelname
Prompt Table:
EOEN_AL_PAGE_VW
|
| 11 |
MESSAGE_SET_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table:
PSMSGSETDEFN
|
| 12 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table:
PSMSGCATDEFN
|
| 13 |
EOEN_EMAIL_FIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
Email Field Name
Prompt Table:
EOEN_AL_QRYFLD
|
| 14 |
QRYFLDNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Source Field
Prompt Table:
EOEN_QRY_FIELD
|
| 15 |
EOEN_BU_FIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
Business Unit Field Name
Prompt Table:
EOEN_AL_QRYFLD
|
| 16 |
EOEN_SRCH_KEY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Search Record Fields
Y/N Table Edit
Default Value: Y
|
| 17 |
CONSOLIDATE_EOEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Consolidate Email
Y/N Table Edit
|
| 18 |
EOEN_CTX_RECNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
EOEN Context Record Name
Prompt Table:
EOEN_AL_CTX_VW
|
| 19 |
EOEN_DFLT_CTX_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Context Record
Y/N Table Edit
Default Value: Y
|
| 20 |
URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Internet URL (Universal Resource Locator)
|
| 21 |
EOEN_URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Internet URL (Universal Resource Locator)
|
| 22 |
PORTAL_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Portal Name (see PSPRDMDEFN).
|
| 23 |
PORTAL_OBJNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Portal Object Name
Prompt Table:
EOEN_PORTAL_VW
|
| 24 |
PORTAL_CREF_URLT |
Character(4) |
VARCHAR2(4) NOT NULL |
URL Type
NONE=None
UEXT=Non-PeopleSoft URL
UGEN=PeopleSoft Generic URL
UMPG=PeopleSoft Mobile Page
UPGE=PeopleSoft Component
UPHP=PeopleSoft Portal Homepage Tab
UPTM=PeopleSoft Portal Template
USCR=PeopleSoft Script
WRKL=PeopleSoft Worklist URL
|
| 25 |
EOEN_SUBJ_MSG_SET |
Number(5,0) |
INTEGER NOT NULL |
EOEN Email subject message catalog set number
Default Value: 18111
Prompt Table:
EOEN_SUBJ_SETVW
|
| 26 |
EOEN_SUBJ_MSG_NBR |
Number(5,0) |
INTEGER NOT NULL |
EOEN Email subject message catalog number
Default Value: 17245
Prompt Table:
EOEN_SUBJ_MSGVW
|
| 27 |
EOEC_UL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Identifies the user list to be used when creating the approval process.
Prompt Table:
EOEC_UL_DEFN
|
| 28 |
EOEN_ENABLE_UL |
Character(1) |
VARCHAR2(1) NOT NULL |
EOEN enable user list flag
N=User ID
Y=User List
Default Value: N
|
| 29 |
EOEN_PUSH_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
EOEN Push Category Type
A=Actions
F=Alerts
Default Value: F
|
| 30 |
EOEN_PUSH_URL_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
EOEN Push Notification URL Type
A=None
N=Notification
T=Transaction
Default Value: N
|
| 31 |
EOEN_PUSH_EVTNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Event Name
Default Value: EOEN
Prompt Table:
EOEN_SERVER_EVT
|