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