opportunity_eeo


Description

A row in this table represents a response to the EEO survey by a candidate for a specific opportunity.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
opportunity_id varchar 2147483647 null
opportunities.opportunity_id opportunity_eeo_opportunity_id_fkeyC

ID of the opportunity connected to this entity.

eeo_response_id varchar 2147483647 null
eeo_responses.eeo_response_id opportunity_eeo_eeo_response_id_fkeyC

ID of the EEO response connected to the opportunity.

account_id varchar 2147483647 null

ID of the account the record belongs to.

disability_status_signature varchar 2147483647 null

Text of the signature by the applicant.

disability_status_date varchar 2147483647 null

Date of the signature by the applicant.

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.

survey_sent_at timestamp 29,6 null

Timestamp of when the survey is sent to a sourced, referred, or agency-submitted candidates

Indexes

Constraint Name Type Sort Column(s)
opportunity_eeo_pkey Primary key Asc/Asc opportunity_id + eeo_response_id
opportunity_eeo_account_id_idx Performance Asc account_id
opportunity_eeo_opp_id_idx Performance Asc opportunity_id
opportunity_eeo_response_id Performance Asc eeo_response_id

Relationships