SUBINT_OBJ_TYPEOBJECTVALUE1RB_EM_IB_BASE_V(SQL View) |
Index Back |
|---|---|
View for Inbound Email PromptUsed by Outbound Email component. |
| SELECT DISTINCT B.SUBINT_OBJ_TYPE , CASE WHEN B.SUBINT_OBJ_TYPE = 'CASE' THEN %NumToChar(B.CASE_ID) WHEN B.SUBINT_OBJ_TYPE = 'LEAD' THEN B.LEAD_ID WHEN B.SUBINT_OBJ_TYPE = 'ORDR' THEN B.CAPTURE_ID WHEN B.SUBINT_OBJ_TYPE = 'OPPY' THEN B.OPPORTUNITY_ID WHEN B.SUBINT_OBJ_TYPE = 'SVCO' THEN B.SO_ID WHEN B.SUBINT_OBJ_TYPE = 'QUOT' THEN B.CAPTURE_ID END , B.INTERACTION_ID FROM PS_RI_SUB_INTERACT B |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SUBINT_OBJ_TYPE |
Character(4) | VARCHAR2(4) NOT NULL | sub-interaction object type |
| 2 | OBJECTVALUE1 |
Character(100) | VARCHAR2(100) NOT NULL | Object Value 1 |
| 3 | INTERACTION_ID | Character(15) | VARCHAR2(15) NOT NULL | interaction id |