We're making updates to Business Intelligence Connector on Monday, July 31, 2023.
Overview of changes
We're adding an organization_id column to all Greenhouse Recruiting tables that don't already include it. We're also adding a company_id column to all Greenhouse Onboarding tables that don't already include it. These changes will enhance performance long-term and enable organizations with multiple environments to more easily differentiate their datasets.
Organization ID
The organization_id update will affect the following tables:
- agency_question_custom_fields
- application_custom_fields
- application_question_answers
- application_stages
- applications
- applications_jobs
- approvals
- candidate_custom_fields
- candidate_email_addresses
- candidate_mailing_addresses
- candidate_phone_numbers
- candidate_survey_questions
- candidates
- candidates_tags
- demographic_answer_option_translations
- demographic_answer_options
- demographic_answers
- demographic_free_form_answers
- demographic_question_translations
- educations
- eeoc_responses
- employments
- events
- gdpr_consent_decisions
- gdpr_consent_requests
- gdpr_office_rules
- greenhouse_usages
- hiring_team
- interviewer_tags
- interviewers
- job_custom_fields
- job_post_questions
- job_posts
- job_snapshots
- jobs_attributes
- jobs_departments
- jobs_interviews
- jobs_offices
- jobs_stages
- offer_custom_fields
- offers
- opening_custom_fields
- openings
- prospect_pool_stages
- prospect_pool_transitions
- prospect_pools
- referral_question_custom_fields
- rejection_question_custom_fields
- scheduled_interviews
- scorecard_question_answers
- scorecard_questions
- scorecards
- scorecards_attributes
- stage_snapshots
- user_actions
- user_attribute_custom_fields
- user_candidate_links
Company ID
The company_id update will affect the following tables:
- gho_assigned_tasks
- gho_custom_field_values
- gho_custom_fields
- gho_employee_roles
- gho_employees
- gho_roles
- gho_user_activities