users


Description

A row in this table represents a user in your Lever account. Users can be recruiters, hiring managers, interviewers…

Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id varchar 2147483647 null
api_credentials.creator_id api_credentials_creator_id_fkeyN
contact_consent_events.user_id contacts_consent_events_user_id_fkeyN
data_requests.assigned_user_id Implied ConstraintR
data_requests.closed_by_user_id Implied ConstraintR
form_templates.creator_id form_templates_creator_id_fkeyN
interview_panel_interviewers.user_id interview_panels_interviews_interviewers_user_id_fkeyN
interview_panels.creator_id interview_panels_creator_id_fkeyN
nurture_campaign_events.actor_id nurture_campaign_events_actor_id_fkey
nurture_campaign_step_emails.from_user_id nurture_campaign_step_emails_from_user_id_fkeyN
nurture_templates.owner_user_id nurture_templates_owner_user_id_fkeyN
offer_approvers.approver_id offer_approvers_approver_id_fkeyN
offer_events.actor_id offer_events_actor_id_fkeyN
offer_events.hiring_manager_user_id offer_events_hiring_manager_user_id_fkeyN
opportunities.archived_by_user_id opportunities_archived_by_user_id_fkeyN
opportunities.owner_user_id opportunities_owner_user_id_fkeyN
opportunities.sourced_by_user_id opportunities_sourced_by_user_id_fkeyN
opportunity_feedback_events.actor_id opportunities_feedback_events_actor_id_fkeyN
opportunity_form_events.actor_id opportunities_form_events_actor_id_fkeyN
opportunity_forms.user_id opportunity_forms_user_id_fkeyN
opportunity_progress_events.actor_id opportunities_progress_events_actor_id_fkeyN
opportunity_referrals.user_id opportunity_referrals_user_id_fkeyN
posting_approvers.approver_id posting_approvers_approver_id_fkeyN
posting_events.actor_id posting_events_actor_id_fkeyN
posting_followers.user_id posting_followers_user_id_fkeyC
postings.hiring_manager_user_id postings_hiring_manager_user_id_fkeyN
postings.owner_user_id postings_owner_user_id_fkeyN
requisition_approvers.approver_id requisition_approvers_approver_id_fkeyN
requisition_events.actor_id requisition_events_actor_id_fkeyN
requisition_events.creator_user_id requisition_events_creator_user_id_fkeyN
requisition_events.hiring_manager_user_id requisition_events_hiring_manager_user_id_fkeyN
requisition_events.owner_user_id requisition_events_owner_user_id_fkeyN
requisitions.creator_user_id requisitions_creator_user_id_fkeyN
requisitions.hiring_manager_user_id requisitions_hiring_manager_user_id_fkeyN
requisitions.owner_user_id requisitions_owner_user_id_fkeyN

Primary key.
account_id varchar 2147483647 √ null

ID of the account the record belongs to.
name varchar 2147483647 √ null

Full name of the user
email varchar 2147483647 √ null

Email address associated with this entity.
username varchar 2147483647 √ null

Custom naming field to identify the user. Default falls to all lower case full name joined together
created_at timestamp 29,6 √ null

Date the object referred to in this entity was created.
is_active bool 1 √ null

TRUE if the user is active, False if the user in inactive.
is_deleted bool 1 false

TRUE if the source of data for the current entity has been deleted.
row_updated_at timestamp 29,6 √ CURRENT_TIMESTAMP

Date this entity was updated in the database. Useful to setup incremental refreshes of the data in your periodic ETL job.
user_role_id varchar 2147483647 √ null
user_role_enum.user_role_id users_user_role_id_fkeyN
hiring_manager_id varchar 2147483647 √ null

Lever ID of a user that another user reports to
job_title varchar 2147483647 √ null

The job title of a user

Indexes

Constraint Name Type Sort Column(s)
users_pkey Primary key Asc user_id
users_account_id_index Performance Asc account_id

Relationships

Close relationships within degrees of separation