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. |