RB_ATTMPT_SOL_V(SQL View) |
Index Back |
|---|---|
Solutions Attached To EmailsERMS view Used for ERMS Reports about information of Solutions Attached To Emails |
| SELECT C.OPRALIASVALUE , C.OPRID , A.INTERACTION_ID , B.MAILBOX_ID , B.LAST_GROUP_WL , B.CURRENT_WL , A.ROW_ADDED_DTTM , A.SOLUTION_ID FROM PS_RB_EM_ATMPT_SOL A , PS_RB_IN_EMAIL B , PSOPRALIAS C WHERE A.INTERACTION_ID = B.INTERACTION_ID AND A.ROW_ADDED_OPRID = C.OPRID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRALIASVALUE | Character(30) | VARCHAR2(30) NOT NULL | User ID Attribute Value |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | INTERACTION_ID | Character(15) | VARCHAR2(15) NOT NULL | interaction id |
| 4 | MAILBOX_ID | Character(30) | VARCHAR2(30) NOT NULL | Mail Box Id is an Id associated with Mail Boxes |
| 5 | LAST_GROUP_WL | Character(30) | VARCHAR2(30) NOT NULL | Last/Current Group-level Worklist |
| 6 | CURRENT_WL | Character(30) | VARCHAR2(30) NOT NULL | Current Worklist Value |
| 7 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 8 | SOLUTION_ID | Number(15,0) | DECIMAL(15) NOT NULL | Solution ID |