RB_EM_ACTSMRY_V(SQL View) |
Index Back |
|---|---|
ERMS ACTIVITY SYMMARYView used for ERMS activity aummary and report |
| SELECT E.MCF_EMAIL_ID , E.MAILBOX_ID , E.SLA_EXT_BASE_DTTM , E.INTERACTION_ID , E.LAST_GROUP_WL , E.BO_ID_CUST , E.ASSIGNED_TO , E.PRODUCT_GROUP , E.PRODUCT_ID , E.TMPLT_CATEGRY_ID , E.TMPLT_TYPE_ID FROM PS_RB_IN_EMAIL E |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MCF_EMAIL_ID | Number(16,0) | DECIMAL(16) NOT NULL | Email Id |
| 2 | MAILBOX_ID | Character(30) | VARCHAR2(30) NOT NULL | Mail Box Id is an Id associated with Mail Boxes |
| 3 | SLA_EXT_BASE_DTTM | DateTime(26) | TIMESTAMP | External Service Level Agreement Base Date/time |
| 4 | INTERACTION_ID | Character(15) | VARCHAR2(15) NOT NULL | interaction id |
| 5 | LAST_GROUP_WL | Character(30) | VARCHAR2(30) NOT NULL | Last/Current Group-level Worklist |
| 6 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 7 | ASSIGNED_TO | Character(15) | VARCHAR2(15) NOT NULL | This is a field to store assignment information. |
| 8 | PRODUCT_GROUP | Character(10) | VARCHAR2(10) NOT NULL | PRoduct Group |
| 9 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 10 | TMPLT_CATEGRY_ID | Number(6,0) | INTEGER NOT NULL | Template Category ID |
| 11 | TMPLT_TYPE_ID | Number(6,0) | INTEGER NOT NULL | Template Type ID |