SUBINT_OBJ_TYPEOBJECTVALUE1MCF_EMAIL_IDN=NO
Y=YES
RB_EMAIL_IB_VW(SQL View) |
Index Back |
|---|---|
Email Work RecordInbound email work record for displaying information on outbound email and/or threading. |
| SELECT B.SUBINT_OBJ_TYPE , B.OBJECTVALUE1 , A.MCF_EMAIL_ID , A.INTERACTION_ID , A.STRUCTURED_SW , A.STRUCTURED_SW , A.MCF_WL_SUBJECT , A.SLA_EXT_BASE_DTTM , A.STRUCTURED_SW FROM PS_RB_EM_IB_BASE_V B , PS_RB_IN_EMAIL A WHERE B.INTERACTION_ID = A.INTERACTION_ID |
| # | 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 | MCF_EMAIL_ID |
Number(16,0) | DECIMAL(16) NOT NULL | Email Id |
| 4 | INTERACTION_ID | Character(15) | VARCHAR2(15) NOT NULL | interaction id |
| 5 | IMAGE_FIELD | Image Reference(30) | VARCHAR2(30) | Image Reference Field to display images used in Personalizations explanations. |
| 6 | CURRENT_ROW | Character(1) | VARCHAR2(1) NOT NULL | Current Row Only (for Eff. Dt) |
| 7 | MCF_WL_SUBJECT | Character(254) | VARCHAR2(254) NOT NULL | Subject |
| 8 | SLA_EXT_BASE_DTTM | DateTime(26) | TIMESTAMP | External Service Level Agreement Base Date/time |
| 9 | SELECT_EMWL | Character(1) | VARCHAR2(1) NOT NULL |
Recommended Worklist Selection Checkbox
N=NO Y=YES |