TFNRegistry Reporting: Cross Entity Activity Report (RHDB_CROSS_ENTITY_ACTIVITY_REPORT_VIEW)

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.

• If ROID is provided by Control Resp Org, then the Acting As Resp Org is set using the ROID.
• If ROID is not provided, and if resource owner is identified, then the Acting As Resp Org is set using the Resource Owner.
• If ROID is not provided, and the Resource Owner is not identifiable, then set the Acting As Resporg is set as N/A.

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.

• If ROID is provided by Control Resp Org, then the Acting As Resp Org is set using the ROID.
• If ROID is not provided, and if resource owner is identified, then the Acting As Resp Org is set using the Resource Owner.
• If ROID is not provided, and the Resource Owner is not identifiable, then set the Acting As Resporg is set as N/A.

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.