LM_NOTIF_CAT_IDPrompt Table: LM_NOTIF_CAT
LM_TEMPLATE_IDC=Custom
D=Delivered
Default Value: C
LM_NOTTMPL_DST(SQL View) |
Index Back |
|---|---|
Active notification templatesNotification Templates - distinct view |
| SELECT A.LM_NOTIF_CAT_ID , A.LM_TEMPLATE_ID , A.LM_DESCR , A.LM_DATA_SOURCE FROM PS_LM_NOTIF_TMPL A WHERE A.LM_NOTIF_STTS = 'A' AND ( A.LM_DATA_SOURCE = 'C' OR (A.LM_DATA_SOURCE = 'D' AND NOT EXISTS ( SELECT 1 FROM PS_LM_NOTIF_TMPL B WHERE B.LM_TEMPLATE_ID = A.LM_TEMPLATE_ID AND B.LM_DATA_SOURCE = 'C') )) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_NOTIF_CAT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Notification Event Category ID
Prompt Table: LM_NOTIF_CAT |
| 2 | LM_TEMPLATE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Template Name |
| 3 | LM_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Description |
| 4 | LM_DATA_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Data Source Code
C=Custom D=Delivered Default Value: C |