Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | null | Primary key. | |||||||
| anticipated_start_date | date | 13 | √ | null | Anticipated start date. | ||||||
| company_id | int4 | 10 | √ | null |
| Id of the company the record belongs to. | |||||
| explanation | varchar | 255 | √ | null | Explanation for requisition opening. | ||||||
| filled_at | timestamp | 29,6 | √ | null | Date the requisition opening was filled. | ||||||
| placement_id | int4 | 10 | √ | null |
| Id of the placement the record belongs to. | |||||
| reason | varchar | 255 | √ | null | Reason for requisition opening. - one of (‘replacement’, ‘new_position’) | ||||||
| requisition_id | int4 | 10 | √ | null |
| Id of the requisition the record belongs to. | |||||
| status | varchar | 255 | √ | null | Opening status - one of (‘open’, ‘filled’). |