requisitions


Description

A row in this table represents a requisition.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
requisition_id varchar 2147483647 null
email_events.requisition_id emails_events_requisition_id_fkeyN
nurture_campaign_events.requisition_id nurture_campaign_events_requisition_id_fkeyN
offer_events.requisition_id offer_events_requisition_id_fkeyN
offers.requisition_id offers_requisition_id_fkeyN
opportunities.requisition_id opportunities_requisition_id_fkeyN
opportunity_feedback_events.requisition_id opportunities_feedback_events_requisition_id_fkeyN
opportunity_form_events.requisition_id opportunities_form_events_requisition_id_fkeyN
opportunity_progress_events.requisition_id opportunities_progress_events_requisition_id_fkeyN
requisition_approvers.requisition_id requisition_approvers_requisition_id_fkeyC
requisition_events.requisition_id requisition_events_requisition_id_fkeyN
requisition_fields.requisition_id requisition_fields_requisition_id_fkeyC
requisition_postings.requisition_id requisition_postings_requisition_id_fkeyC

Primary key.

account_id varchar 2147483647 null

ID of the account the record belongs to.

job_department_id varchar 2147483647 null
job_departments.job_department_id requisitions_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 requisitions_job_department_team_id_fkeyN

ID of the team associated with this record.

job_location_id varchar 2147483647 null
job_locations.job_location_id requisitions_job_location_id_fkeyN

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

requisition_text varchar 2147483647 null

The name of the requisition

is_backfill bool 1 null

Indicates if this requisition represents a backfill.

is_headcount_infinite bool 1 null

Indicates if the headcount for this requisition is infinite

headcount_total numeric 131089 null

The total headcount associated with the requisition

compensation_currency varchar 2147483647 null

The currency that compensation will be paid in

compensation_band_min numeric 131089 null

The minimum value of the compensation band

compensation_band_max numeric 131089 null

The maximum value of the compensation band

compensation_band_interval varchar 2147483647 null

The timeframe in which the compensation will be paid \(e.g. per year, per month, one time, etc\)

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.

requisition_code varchar 2147483647 null

User defined code for each requisitions

hiring_manager_user_id varchar 2147483647 null
users.user_id requisitions_hiring_manager_user_id_fkeyN

ID of the user assigned as the hiring manager for this entity.

owner_user_id varchar 2147483647 null
users.user_id requisitions_owner_user_id_fkeyN

ID of the owner of this record.

creator_user_id varchar 2147483647 null
users.user_id requisitions_creator_user_id_fkeyN

ID of the user that created this entity.

requisition_status_id varchar 2147483647 null
requisition_status_enum.requisition_status_id requisitions_requisition_status_id_fkeyR

ID of the status of this entity.

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.

employment_status varchar 2147483647 null

The employment status of a requisition.

internal_notes varchar 2147483647 null

Notes about a requisition for internal usage.

Indexes

Constraint Name Type Sort Column(s)
requisitions_pkey Primary key Asc requisition_id
requisitions_account_id_index Performance Asc account_id
requisitions_creator_user_id_idx Performance Asc creator_user_id
requisitions_hiring_manager_user_id_idx Performance Asc hiring_manager_user_id
requisitions_job_department_id_idx Performance Asc job_department_id
requisitions_job_department_team_id_idx Performance Asc job_department_team_id
requisitions_job_location_id_idx Performance Asc job_location_id
requisitions_owner_user_id_idx Performance Asc owner_user_id
requisitions_req_code_idx Performance Asc/Asc account_id + requisition_code

Relationships