Skip to end of banner
Go to start of banner

User Activity Table

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

Version 1 Current »

Name

UserAccess

Type

Table

Description

When a user logs in or out of QFD, an event is generated.  This information is useful for understanding time spent in the system. 

Fields

Data Category

Event Field/Column Name

Data Type

Description

Applicability

Sample Value

Notes

Key

TenantId

VARCHAR(32)

Unique ID associated with each Quavo client.

ALWAYS

qvo-stg

Key

UserId

VARCHAR(64)

Unique ID associated with each user, typically their business email address.

ALWAYS

devan.robertson@quavo.com

Activity Details

EventType

VARCHAR(32)

The log in/out event that occurred.

ALWAYS

Login, Logout, Timeout

Metadata

EventDateTime

TIMESTAMP_NTZ(9)

The datetime that the event was recorded.

ALWAYS

2023-09-09 21:00:00

Metadata

EventIdentifier

VARCHAR(64)

A unique ID associated with each business event.

ALWAYS

70b1c86d-d06f-4c93-bab2-0e938a4ef768

Metadata

EventItemId

VARCHAR(64)

An ID included with each business event that identifies the tenant and Claim ID or Dispute ID associated with the event.

ALWAYS

qvo-stg|devan.robertson@quavo.com

  • No labels