| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 QRYNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Query Name
Prompt Table:
SAC_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 |
ALERT_INTERVAL |
Number(3,0) |
SMALLINT NOT NULL |
Notification Interval (hours)
|
| 5 |
LAST_DTTIME |
DateTime(26) |
TIMESTAMP |
Last Date Time
|
| 6 |
ACTIVE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Event Status
N=Inactive
Y=Active
Y/N Table Edit
Default Value: Y
|
| 7 |
MENUNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Menu Name (see PSMENUDEFN).
Prompt Table:
SAC_ALRTMENU_VW
|
| 8 |
PNLGRPNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Component Name
Prompt Table:
PSMENUCOMP_VW
|
| 9 |
PANELNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Panelname
Prompt Table:
SAC_ALRTPAGE_VW
|
| 10 |
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
|
| 11 |
MESSAGE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table:
PSMSGCATDEFN
|
| 12 |
EMAIL_FIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
Email Field Name
Prompt Table:
SAC_ALRT_QRYFLD
|
| 13 |
BU_FIELD |
Character(18) |
VARCHAR2(18) NOT NULL |
Business Unit Field Name
Prompt Table:
SAC_ALRT_QRYFLD
|
| 14 |
SRCH_REC_KEY_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Business Unit Field Name
Y/N Table Edit
Default Value: Y
|
| 15 |
CONSOLIDATE_EWN |
Character(1) |
VARCHAR2(1) NOT NULL |
Consolidate Email
Y/N Table Edit
|
| 16 |
CTX_RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name
Prompt Table:
SAC_ALRT_CTX_VW
|
| 17 |
DFLT_CTX_REC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Context Record
Y/N Table Edit
Default Value: Y
|
| 18 |
PRODUCT_ID |
Character(18) |
VARCHAR2(18) NOT NULL |
Product ID
Prompt Table:
SAC_PRODUCT_VW
|
| 19 |
URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Internet URL (Universal Resource Locator)
|
| 20 |
EWN_URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Internet URL (Universal Resource Locator)
|
| 21 |
PORTAL_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Portal Name (see PSPRDMDEFN).
|
| 22 |
PORTAL_OBJNAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Portal Object Name
Prompt Table:
SAC_PORTAL_VW
|
| 23 |
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
|