opportunity_form_events


Description

A row in this table represents a change event to a specific form connected to an opportunity. The type of events tracked in this table are available in the table “opportunity_form_event_enum”.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
account_id varchar 2147483647 null

ID of the account the record belongs to.

opportunity_id varchar 2147483647 null
opportunities.opportunity_id opportunities_form_events_opportunity_id_fkeyC

ID of the opportunity connected to this entity.

opportunity_form_id varchar 2147483647 null
opportunity_forms.opportunity_form_id opportunities_form_events_opportunity_form_id_fkeyN

ID of the opportunity form record related to this entity.

actor_id varchar 2147483647 null
users.user_id opportunities_form_events_actor_id_fkeyN

The user or system responsible for performing the action.

contact_id varchar 2147483647 null
contacts.contact_id opportunities_form_events_contact_id_fkeyN

ID of the contact that represents the personal information of a candidate independent from opportunities.

posting_id varchar 2147483647 null
postings.posting_id opportunities_form_events_posting_id_fkeyN

ID of the posting connected to this entity.

requisition_id varchar 2147483647 null
requisitions.requisition_id opportunities_form_events_requisition_id_fkeyN

ID of the requisition associated with this entity.

form_template_id varchar 2147483647 null
form_templates.form_template_id opportunities_form_events_form_template_id_fkeyN

ID of form template associated with this entity.

account_stage_id varchar 2147483647 null
account_stages.account_stage_id opportunities_form_events_account_stage_id_fkeyN

ID of the stage associated with this record.

opportunity_form_event_id varchar 2147483647 null
opportunity_form_event_enum.opportunity_form_event_id opportunity_form_events_opportunity_form_event_id_fkeyN

ID of the event type represented by this entity. See connected “enum” table for a list of the possible types.

event_date_id varchar 2147483647 null
dates.date_id opportunities_form_events_event_date_id_fkeyN

ID of the date and time when the event occurred. It’s used in combination with the datetime dimension table to simplify the creation of temporal queries.

job_department_id varchar 2147483647 null
job_departments.job_department_id opportunities_form_events_job_department_id_fkeyN

ID of the department associated with this record.

job_department_team_id varchar 2147483647 null
job_department_teams.job_department_team_id opportunities_form_events_job_department_team_id_fkeyN

ID of the team associated with this record.

job_level_id varchar 2147483647 null
job_levels.job_level_id opportunities_form_events_job_level_id_fkeyN

ID of the level used to capture the seniority of a position.

job_work_type_id varchar 2147483647 null
job_work_types.job_work_type_id opportunities_form_events_job_work_type_id_fkeyN

ID of the work type. Can be any number of user configured values, defaults are Contract, Full-time, Intern, Part-time.

job_location_id varchar 2147483647 null
job_locations.job_location_id opportunities_form_events_job_location_id_fkeyN

ID of a possible location value for job postings and requisitions.

event_at timestamp 29,6 null

Date and time when the event occurred.

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.

is_confidential bool 1 false

TRUE if the posting related to the opportunity is confidential.

event_key varchar 2147483647 null
previous_event_at timestamp 29,6 null

For note-commented events is the date and time the original note or previous comment was submitted. Otherwise, is the same as “event_at”.

next_event_at timestamp 29,6 null

For note-created and note-commented, the date and time the next reply was submitted. Otherwise, is 9999-09-09T12:00:00Z.

Indexes

Constraint Name Type Sort Column(s)
opportunity_form_events_pkey Primary key Asc event_key
opp_form_events_account_stage_id_idx Performance Asc account_stage_id
opp_form_events_form_id_idx Performance Asc opportunity_form_id
opp_form_events_job_department_id_idx Performance Asc job_department_id
opp_form_events_job_department_team_id_idx Performance Asc job_department_team_id
opp_form_events_job_level_id_idx Performance Asc job_level_id
opp_form_events_job_location_id_idx Performance Asc job_location_id
opp_form_events_job_work_type_id_idx Performance Asc job_work_type_id
opp_form_events_opportunity_id_idx Performance Asc opportunity_id
opportunities_form_events_account_id_index Performance Asc account_id
opportunity_form_events_contact_id_index Performance Asc contact_id

Relationships