RB_SLA_NTFY_AET(SQL Table) |
Index Back |
---|---|
sla notify aetAET for SLA Notify |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
4 | CURR_DTTM | DateTime(26) | TIMESTAMP | Current DateTime |
5 | MCF_EMAIL_ID | Number(16,0) | DECIMAL(16) NOT NULL | Email Id |
6 | RUN_DTTM | DateTime(26) | TIMESTAMP | Run Date and Time |
7 | SLA_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
SLa Type
MBDU=Mailbox Due Datetime MBEW=Mailbox Early Warning WLDU=Worklist Due DateTime WLEW=Worklist Early Warning |
8 | EMAIL_STATUS | Character(4) | VARCHAR2(4) NOT NULL | ERMS Inbound Email Status |
9 | CURRENT_WL | Character(30) | VARCHAR2(30) NOT NULL | Current Worklist Value |
10 | LAST_GROUP_WL | Character(30) | VARCHAR2(30) NOT NULL | Last/Current Group-level Worklist |
11 | MAILBOX_OWNER | Character(30) | VARCHAR2(30) NOT NULL | Identifies the Owner of Mailbox who need to be notified in the event of an Escalation |
12 | GROUP_WLIST_OWNER | Character(30) | VARCHAR2(30) NOT NULL | Identifies the Owner of Group Worklist |
13 | MAILBOX_ID | Character(30) | VARCHAR2(30) NOT NULL | Mail Box Id is an Id associated with Mail Boxes |
14 | WL_CATEGORY | Character(2) | VARCHAR2(2) NOT NULL |
Worklist Category
AG=Agent Worklist GO=Group Worklist Owner MO=Mailbox Owner NO=No Group Worklist Owner Found |
15 | WORKLISTNAME | Character(30) | VARCHAR2(30) NOT NULL | Worklist Name |
16 | NOTIFY_DTTM | DateTime(26) | TIMESTAMP | Notify Date/Time |