A row in this table represents an external agency setup in your Lever account.


Column Type Size Nulls Auto Default Children Parents Comments
agency_id varchar 2147483647 null
agency_contacts.agency_id agency_contacts_agency_id_fkeyN
agency_jobs.agency_id agency_jobs_agency_id_fkeyN
agency_sources.agency_id agency_sources_agency_id_fkeyN
opportunity_progress_events.agency_id opportunities_progress_events_agency_id_fkeyN

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

name varchar 2147483647 null

The name of the agency

domain_name varchar 2147483647 null

Domain name of the agency

status varchar 2147483647 null

Current standing of the agency. The agency can be active or deactivated.

created_at timestamp 29,6 null

Date the object referred to in this entity was created.

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.


Constraint Name Type Sort Column(s)
agencies_pkey Primary key Asc agency_id
agencies_account_id_index Performance Asc account_id