FCT_CONTENT_EVENT_SERVICE_WAITLISTS

Prev Next

COLUMN NAME

DATA TYPE (FIELD SIZE)

DESCRIPTION

CURRENT AVAILABLE VALUES

EXAMPLE

Availability Notified At

TIMESTAMP_NTZ(9)

Timestamp showing when the user was notificed of availability for the event

2025-01-01

Created At

TIMESTAMP_NTZ(9)

Timestamp to show when this waitlist record was created

2025-01-01T00:00:00.000+0000

Days On Waitlist

NUMBER(9,0)

The number of days between created at and either when availability was notified for registered and cancelled status if it exists or updated at. For active waitlists this is the number of days between created at and today

5

Doc Created At

TIMESTAMP_NTZ(9)

Timestamp inherited from parent snowflake object(s)

2025-01-01T00:00:00.000+0000

Doc Updated At

TIMESTAMP_NTZ(9)

Timestamp inherited from parent snowflake object(s)

2025-01-01T00:00:00.000+0000

Event ID

VARCHAR(16777216)

Identifier for the event (content)

123a12b3cd4e5f67g890h1ij

Is Active Waitlist Entry

NUMBER(1,0)

Will show 0 if the status is registered or cancelled else 1

0, 1

1

Status

VARCHAR(16777216)

Status of the waitlist entry - registered (user is now registered on an event), cancelled (user has cancelled their waitlist entry), active (user is on a waitlist currently for an event)

registered, cancelled, active

active

Tenant ID

VARCHAR(16777216)

Identifier for the tenant

eu-west-2_abcdefGh1

Updated At

TIMESTAMP_NTZ(9)

Timestamp to show when this waitlist record was last updated

2025-01-01T00:00:00.000+0000

User ID

VARCHAR(16777216)

Identifier for the user

123a12b3cd4e5f67g890h1ij

Waitlist ID

VARCHAR(16777216)

Identifier for the waitlist entry

123a12b3cd4e5f67g890h1ij