Abandonment Read

ShowCode

String

An 8 alpha numerical code provided to an event. (EX.AFTS0124 = 4 letter event code and month and year of the event)

Email

String

Attendees Email address.

TempBadge

Integer

Temporary badge number provided while the attendee is shopping.

TempOrder

Integer

Temporary order number. Valid until a permanent order number is created.

Badge

Integer

A unique ID provided to an Attendee

DateSent

String

Date and time the data is sent.

UniqueID

String

Unique transaction ID

EventPK

Integer

Event Primary key.

AbandonmentAnswerID

Integer

Why was the card abandoned

RegistrationTemp

All the fields below are part of RegistrationTemp section.

EventCode

String

An 8 alpha numerical code provided to an event. (EX.AFTS0124 = 4 letter event code and month and year of the event)

RegTimeStamp

String

Date and time stamp when the Attendee registered for the event.

Modified_TS

String

Date and time the data was modified.

Badge

Integer

A unique ID provided to an Attendee

uid

String

Unique user ID provided to the Attendee.

FirstName

String

First name (Legal First name) of the attendee

MiddleInitial

String

Middle initial (Legal first initial of the middle name) of the attendee

LastName

String

Last name (Legal Last name (Surname)) of the attendee

NickName

String

A secondary name for the attendee.

Degree

String

Educational certification provided to the Attendee

Title

String

Attendees professional title

Company

String

Company Attendees works for or represents

Street

String

Attendees street name and building number

Street2

String

Attendees additional address information

Street3

String

Attendees additional address information

City

String

Attendees city of residence

State

String

Attendees State of residence

Zipcode

String

Attendees postal code

Country

String

Attendees country of residence

Phone

String

Attendees phone number

CellPhone

String

Attendees mobile phone number

EXT

String

Attendees phone extension

Fax

String

Attendees fax number

Email

String

Attendees email

AlternativeEmail

String

Attendees secondary email

WebsiteURL

String

Extra data field requested by clients. Primarily used for Attendees company website.

Association

String

Defined by the client and is often the clients member number for the registrant or something similar.

CASLOptIn

String

Canadian Anti-Spam Legislation opt in flag

MethodID

Integer

Method how registration was received.

EB

String

Username for manually entered registrations.

RegClass

String

Attendees registration class. (RegClasses are defined by clients)

Promo1

String

Promo code to provide discounts to the customer.

Promo2

String

Promo code to provide discounts to the customer.

VIPCode

String

Promo code to provide discounts to the customer.

BatchTag

String

Tag assigned to record based on method.

BadgePrinted

String

Last Date and Time badge was printed.

BadgePrinted_Org

String

First Date and Time badge was printed.

BadgePrinted_Cnt

Integer

Count of how many times badge was printed.

GuestOf

String

Guest of which Attendee

EmailConf

String

Email confirmation send date and time

FaxConf

String

Fax confirmation send date and time

MailConf

String

Mail confirmation send date and time

Ordernumber

String

Unique number provided to an order

HandicapBtn

String

Extra data field requested by clients. Used to indicate if service is required.

HandicapText

String

Extra data field requested by clients. Used to capture service required.

ThirdPartyKey

String

Extra data field requested by clients. Used to store third party key.

Suffix

String

Suffix for the Attendee (Ex. JR. III)

Prefix

String

Prefix for the Attendee (Ex. DR, MS, MR)

Region

String

Extra data field requested by clients.

Reg_notes

String

Registration notes

GDPROptIn

Integer

EU General Data Protection Regulation opt in flag

GDPR

Integer

Flag indicating if the registrant’s country is covered by the General Data Protection Regulation

ExtraInfo Fields

String

Extra Data fields requested by clients.