INTERACTION_IDSEQNUMSDB_INTER_MVW(SQL View) |
Index Back |
|---|---|
Interaction Merge viewInteraction Merge view, used in Customer Data hub intergartion with Dashboard |
| SELECT INTERACTION_ID , 0 , BO_ID_CUST FROM PS_RI_INTERACTION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INTERACTION_ID |
Character(15) | VARCHAR2(15) NOT NULL | interaction id |
| 2 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 3 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |