LM_NOTIF_EVENT_IDLM_USER_TYPE1=Learner
2=Manager
3=Instructor
4=Administrator
5=Approver
Prompt Table: LM_NOTIF_EV_USR
LM_LE_ID_STRPrompt Table: LM_LE_SRCH_STR
Prompt Table: LM_NOTTMPL_DST
Prompt Table: LM_NC_NOTIF_VW
LM_NOTIF_EV_DTL(SQL Table) |
Index Back |
|---|---|
Notification Event DetailsUser/LE combinations in effect per event |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_NOTIF_EVENT_ID |
Character(30) | VARCHAR2(30) NOT NULL | Notification Event ID |
| 2 | LM_USER_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
User Type
1=Learner 2=Manager 3=Instructor 4=Administrator 5=Approver Prompt Table: LM_NOTIF_EV_USR |
| 3 | LM_LE_ID_STR |
Character(20) | VARCHAR2(20) NOT NULL |
String representation of LE ID
Prompt Table: LM_LE_SRCH_STR |
| 4 | LM_TEMPLATE_ID | Character(30) | VARCHAR2(30) NOT NULL |
Template Name
Prompt Table: LM_NOTTMPL_DST |
| 5 | EONC_NOTIF_NAME | Character(50) | VARCHAR2(50) NOT NULL |
Notification Name
Prompt Table: LM_NC_NOTIF_VW |
| 6 | LM_ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | Datetime Added |
| 7 | LM_ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Added By |
| 8 | LM_ROW_MAINT_DTTM | DateTime(26) | TIMESTAMP | Row Maintainted DateTime |
| 9 | LM_ROW_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Row Maintained Oprid |