MCF_EMAIL_IDINTERACTION_IDRB_UAD_ECATG_VW(SQL View) |
Index Back |
|---|---|
UAD Interaction CategoryRecord to store the UAD Interaction Category when Categorized on the UAD console. |
| SELECT C.MCF_EMAIL_ID , B.INTERACTION_ID , B.CONVERSION_CODE , B.ROW_LASTMANT_DTTM , B.ROW_LASTMANT_OPRID FROM PS_RB_UAD_RI_CATGR B , PS_RB_IN_EMAIL C WHERE B.INTERACTION_ID = C.INTERACTION_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MCF_EMAIL_ID |
Number(16,0) | DECIMAL(16) NOT NULL | Email Id |
| 2 | INTERACTION_ID |
Character(15) | VARCHAR2(15) NOT NULL | interaction id |
| 3 | CONVERSION_CODE | Character(4) | VARCHAR2(4) NOT NULL | Conversion Code |
| 4 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 5 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |