The registrationaudit table describes activity related to participant recruitment.
Table Schema
| Name |
Type
|
Description |
| personid |
VARCHAR |
Internal identifier used for distribution. Unlike most personid columns, this column should never be used in a join.
|
| registrationauditkey |
VARCHAR |
Primary key. A unique, auto-generated internal identifier to specify a unique instance of the registration related event.
|
| application |
VARCHAR |
The application that recorded this registration related event.
|
| event |
VARCHAR |
A description of the registration related event.
|
| time |
TIMESTAMP |
The time of the event.
|
| baseurl |
VARCHAR |
The base url the visitor visited related to the registration event.
|
| eventcategory |
VARCHAR |
A categorization of audit events, primarily to indicate normal flow versus errored flow. For example: Page View, Error.
|
| page |
VARCHAR |
The page or step in the registration page flow.
|
| pageorder |
INTEGER |
An ordering of the page flow expected to be performed by visitors as they go through pre-registration.
|
| platform |
VARCHAR |
The device platform associated with the registration event. For example: Andriod, iOS, Web.
|
| utmcampaign |
VARCHAR |
UTM campaign associated with the registration event.
|
| utmcontent |
VARCHAR |
UTM content associated with the registration event.
|
| utmmedium |
VARCHAR |
UTM medium associated with the registration event.
|
| utmsource |
VARCHAR |
UTM source associated with the registration event.
|
| utmterm |
VARCHAR |
UTM term associated with the registration event.
|
| visitkey |
VARCHAR |
Identifier for the instance of a visit to the base URL in this audit.
|
| visitorkey |
VARCHAR |
Identifier for the instance of a visitor to the URL in this audit. This should remain constant for the same browser over time.
|
Back to Overview of the RKStudio Model
