Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| admin_id | Unknown | 0 | null |
| Id of the admin the record belongs to. | ||||||||||||||||||||||||
| id | int4 | 10 | null |
| Primary key. | ||||||||||||||||||||||||
| approved_at | timestamp | 29,6 | √ | null | Date the requisition was approved. | ||||||||||||||||||||||||
| archived_at | timestamp | 29,6 | √ | null | Date the requisition was archived. | ||||||||||||||||||||||||
| category | varchar | 255 | √ | null | Requisition category. | ||||||||||||||||||||||||
| city | varchar | 255 | √ | null | (DEPRECATED) Requisition city. Note: please use information from locations table instead. | ||||||||||||||||||||||||
| company_id | int4 | 10 | √ | null |
| Id of the company the record belongs to. | |||||||||||||||||||||||
| country_code | varchar | 255 | √ | null | (DEPRECATED) Requisition country code. Note: please use information from locations table instead. | ||||||||||||||||||||||||
| created_at | timestamp | 29,6 | √ | null | Date the record was created. | ||||||||||||||||||||||||
| department_id | int4 | 10 | √ | null |
| Id of the department the record belongs to. | |||||||||||||||||||||||
| education | varchar | 255 | √ | null | Requisition education. | ||||||||||||||||||||||||
| employment_type | varchar | 255 | √ | null | Requisition employment type. | ||||||||||||||||||||||||
| experience | varchar | 255 | √ | null | Requisition experience. | ||||||||||||||||||||||||
| filled_at | timestamp | 29,6 | √ | null | Date the requisition was filled. | ||||||||||||||||||||||||
| first_requested_at | timestamp | 29,6 | √ | null | Date the requisition was first requested. | ||||||||||||||||||||||||
| guid | varchar | 255 | √ | null | Requisition guid. | ||||||||||||||||||||||||
| hiring_budget | numeric | 18 | √ | null | Requisition hiring budget. | ||||||||||||||||||||||||
| hiring_budget_currency | varchar | 255 | √ | null | Requisition hiring budget currency. | ||||||||||||||||||||||||
| hiring_manager_id | int4 | 10 | √ | null |
| Id of the hiring manager the record belongs to. | |||||||||||||||||||||||
| hybrid | bool | 1 | √ | null | Whether requisition is hybrid. | ||||||||||||||||||||||||
| max_hours | int4 | 10 | √ | null | (DEPRECATED) Maximum number of hours in the requisition. | ||||||||||||||||||||||||
| max_hours_per_week | numeric | 18 | √ | null | Maximum number of hours per week in the requisition. | ||||||||||||||||||||||||
| min_hours | int4 | 10 | √ | null | (DEPRECATED) Minimum number of hours in the requisition. | ||||||||||||||||||||||||
| min_hours_per_week | numeric | 18 | √ | null | Minimum number of hours per week in the requisition. | ||||||||||||||||||||||||
| on_site | bool | 1 | √ | null | Whether requisition is on-site. | ||||||||||||||||||||||||
| priority | varchar | 255 | √ | null | Requisition priority - one of (‘low’, ‘normal’, ‘high’, ‘urgent’). | ||||||||||||||||||||||||
| recruiter_id | int4 | 10 | √ | null |
| Id of the recruiter the record belongs to. | |||||||||||||||||||||||
| rejected_at | timestamp | 29,6 | √ | null | Date the requisition was rejected. | ||||||||||||||||||||||||
| rejected_by_id | int4 | 10 | √ | null |
| Id of the admin the record was rejected by. | |||||||||||||||||||||||
| rejection_reason | varchar | 65535 | √ | null | Rejection reason. | ||||||||||||||||||||||||
| remote | bool | 1 | √ | null | Whether requisition is remote. | ||||||||||||||||||||||||
| requested_at | timestamp | 29,6 | √ | null | Date the requisition was requested. | ||||||||||||||||||||||||
| state_code | varchar | 255 | √ | null | (DEPRECATED) Requisition state code. Note: please use information from locations table instead. | ||||||||||||||||||||||||
| status | varchar | 255 | √ | null | Requisition status. | ||||||||||||||||||||||||
| street | varchar | 255 | √ | null | (DEPRECATED) Requisition street. Note: please use information from locations table instead. | ||||||||||||||||||||||||
| title | varchar | 255 | √ | null | Requisition title. | ||||||||||||||||||||||||
| updated_at | timestamp | 29,6 | √ | null | Date the record was updated. |