| RHDB_CROSS_ENTITY_ACTIVITY_REPORT_VIEW | ||
| Field | Characters | Description |
| CNTL_RESPORG_CODE | VARCHAR2(5) | The Resp Org ID of the Resp Org performing the transaction. If it is not available (e.g. password related transactions), it is set as N/A. |
| CNTL_RESPORG_NAME | VARCHAR2(30) | The name of the Resp Org performing the transaction. If it is not available (e.g. password related transactions), it is set as N/A. |
| ACT_RESPORG_CODE | VARCHAR2(5) | The Resp Org ID of the Resp Org that the transaction is being performed for by the Control Resp Org. Please Note: At the time of the transaction, the Control Resp Org can specify the Resp Org it is Acting As, by setting the ROID parameter.
|
| ACT_RESPORG_NAME | VARCHAR2(30) | The name of the Resp Org that the transaction is being performed for by the Control Resp Org. Please Note: At the time of the transaction, the Control Resp Org can specify the Resp Org it is Acting As, by setting the ROID parameter.
|
| METHOD | VARCHAR2(10) | Command used for the activity: Delete, Get, Post and Put. |
| PATH | VARCHAR2(328) | API transaction syntax/pattern used. |
| API | VARCHAR2(100) | The name of the transaction performed by the Control Resp Org on behalf of the Owner/Acting-As Resp Org. Examples: Carrier Approval, Copy Pointer Record, etc. |
| CHANNEL_ID | VARCHAR2(3) | Interface used to perform the activity. |
| ROID | CHAR(3) | Indicates whether the Acting-As Resp Org is populated (Yes), not populated (No). |
| TRANSACTIONS_DATE | DATE | Date the Transaction was performed. |
| TRANSACTIONS_COUNT | NUMBER(38) | Aggregated count/data for the transactions performed. |