RB_SLA_NTFY_AET

(SQL Table)
Index Back

sla notify aet

AET 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