QRYNAMEEOEN_PRCS_NAMEEOEN_CATEGORYN=Inactive
Y=Active
EB_ALERT_CFG_VW(SQL View) |
Index Back |
|---|---|
Alert view |
| SELECT A.QRYNAME , A.EOEN_PRCS_NAME , A.EOEN_CATEGORY , A.EOEN_ACTIVE_FLG , B.EOEN_NOTIFY_PUSH , B.EOEN_NOTIFY_EMAIL FROM PS_EOEN_AL_SETUP A , PS_EOEN_REG_SYS B WHERE A.EOEN_PRCS_NAME = b.eoen_prcs_name AND A.eoen_category = b.eoen_category AND A.QRYNAME IN ('EB_INV_DUE_PYMNT','EB_INV_MISSED_PYMNT','EB_PYMNT_PROCESSED','EB_STMT_NEW') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | QRYNAME |
Character(30) | VARCHAR2(30) NOT NULL | Query Name |
| 2 | EOEN_PRCS_NAME |
Character(30) | VARCHAR2(30) NOT NULL | EOEN Process Name |
| 3 | EOEN_CATEGORY |
Character(30) | VARCHAR2(30) NOT NULL | EOEN Category |
| 4 | EOEN_ACTIVE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Event Status
N=Inactive Y=Active |
| 5 | EOEN_NOTIFY_PUSH | Character(1) | VARCHAR2(1) NOT NULL | Eoen Push notify flag |
| 6 | EOEN_NOTIFY_EMAIL | Character(1) | VARCHAR2(1) NOT NULL | EOEN Email Notify Flag |