RI_INTERACT_V1(SQL View) |
Index Back |
|---|---|
Interaction ViewUsed to determine maximum interaction ID in the RI_INTERACTION table. |
| SELECT TO_NUMBER(INTERACTION_ID) FROM PS_RI_INTERACTION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INTERACTION_ID_NUM | Number(15,0) | DECIMAL(15) NOT NULL | Used as the numeric value of INTERACTION_ID in RI_INTERACTION table. |