xpms.v_sheet_staffing_requisition
View
The Playbook Staffing Requisition sheet as the database holds it: one row per source row, computed columns reproduced in SQL.
| Column | Type | Nullable | Description |
|---|---|---|---|
| source_row | integer | Yes | Row number in the source sheet. |
| req_id | text | Yes | REQ ID (column A), field. |
| event_phase | text | Yes | EVENT PHASE (column B), field. |
| role_code | text | Yes | ROLE CODE (column C), field. |
| headcount | text | Yes | HEADCOUNT (column F), field. |
| duration_days | text | Yes | DURATION (DAYS) (column G), field. |
| status | text | Yes | STATUS (column J), field. |
| flag | text | Yes | FLAG (column K), field. |
| notes | text | Yes | NOTES (column L), field. |
| created_by | text | Yes | CREATED BY (column M), field. |
| created_at | text | Yes | CREATED AT (column N), field. |
| updated_at | text | Yes | UPDATED AT (column O), field. |
| rate_card_id | xpms.canon_code | Yes | RATE CARD ID (column D), computed. |
| job_title | xpms.canon_text | Yes | JOB TITLE (column E), computed. |
| standard_rate | numeric | Yes | STANDARD RATE (column H), computed. |
| total_estimated_cost | numeric | Yes | TOTAL ESTIMATED COST (column I), computed. |