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