Elevate Invitations

Entity
Elevate Invitations
Description
Elevate invitations will contain invitations created either by Talis or by academics inviting other academics.
Database location
public.f_elevate_invitations

Columns

Column Name Datatype Description Example
invitation_id VARCHAR(64) The Talis ID of the invitation. 6200eae0790c89002bac4bd3
first_name VARCHAR(255) The first name of the person who was invited, only populated for invitations created by Talis staff Anne
surname VARCHAR(255) The surname of the person who was invited, only populated for invitations created by Talis staff Example
date_created TIMESTAMP Date created. Timezone is UTC 2016-01-12 00:00:00.0
created_by VARCHAR(64) Talis user ID of the user who created the invitation myoVK7wfosXXWlw
consumed_by VARCHAR(64) Talis user ID of the user who accepted the invitation fhf7jfohifnfwwoif
inst VARCHAR(32) The tenant short code broadminster
invite_type VARCHAR(32) Set to either “talis” (for invitations created by Talis staff) or “colleague” for invitations created by a user inviting a colleage from the same institution talis

WARNING: The data dictionary is subject to change. For that reason always refer to column names directly in your SQL statements, not column positions.