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 | 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 |