Position data
1. Dataset Name
position_data
2. Description
A position-level dataset that provides a filtered, passthrough snapshot of all valid job positions and their lifecycle, approval, and posting attributes. Each row represents one position, carrying its status, timestamps for creation, approval, closing, and publishing, along with organizational and complementary attributes such as job function, business unit, recruiter, hiring manager, title, and location. This dataset powers position creation volume, approval workflow health (pending approvals, approval turnaround time), position status distribution, and job posting audience reporting (internal, external, internally and externally both-posted, unpublished) for the Recruitment Effectiveness Dashboard (T2).
3. Source Tables
- customer_views.positions (aliased pos) — sole source table; every output column is a direct passthrough. No joins are performed.
4. Grain
One row per position_id.
5. Dashboards Supported
- Recruitment Effectiveness Dashboard (T2)
6. Metrics Supported
| Metric | Supported Breakdowns |
| Positions Created | location_country, job_function, recruiter |
| Pending Approvals | job_function, location_country, recruiter |
| Avg Position Approval Time | job_function, location_country, recruiter |
| Positions in Each Status | status (primary); job_function, location_country, business_unit |
| Position Creation Trend | location_country, job_function, business_unit (monthly trend) |
| Internal Only Postings | job_function, location_country, recruiter_name |
| External Only Postings | job_function, location_country, recruiter_name |
| Unpublished Count | job_function, location_country, recruiter_name |
| Publishing Trend | job_function, location_country, business_unit (monthly trend) |
| Positions Published Both Internally and Externally | location_country, job_function, recruiter_name |
| Approvals Pending Breakdown by Users | job_function, location_country, business_unit (grouped by recruiter_name) |
7. Known Exclusions / Filters Applied
- system_id values 'sourcing' and 'resourcing' are excluded — these represent internally-generated or automated position records rather than standard requisitions.
- Positions with a NULL system_id are excluded.
- Positions with a NULL status are excluded.
- position_type = 'TalentCommunity' is excluded — talent community entries are not standard open positions and are filtered out of all downstream metrics.
8. Schema
| Column Name | Data Type | Notes |
| position_id | bigint | Unique position identifier. COUNT DISTINCT grain for all metrics. |
| title | varchar | Job title of the position. Complementary field. |
| location | varchar | Specific office/site location. Complementary field. |
| location_country | varchar | Country of the position. Breakdown dimension across most widgets. |
| status | varchar | Current stage of the position (e.g. Draft, Pending Approval, Open, Filled). |
| is_open | boolean | Is 1 when the position is currently active (not archived or deleted). |
| is_posted | boolean | Is 1 when the position is currently live on an external channel. |
| creation_ts | datetime | Position creation timestamp. Primary date field for time-based filtering on most widgets. |
| last_modified_ts | datetime | Timestamp of the position's most recent update. Complementary field. |
| job_function | varchar | Department/function of the position. Breakdown dimension across nearly every widget. |
| business_unit | varchar | Business unit of the position. Breakdown dimension for widgets |
| system_id | varchar | Source system of the position record. Used at dataset level to exclude sourcing/resourcing records; not surfaced in any widget. |
| is_confidential | boolean | 1 = confidential search. Complementary field. |
| number_of_openings | bigint | Number of openings on the position. Complementary field. |
| calibration_status | varchar | Raw calibration status of the position. Complementary field. |
| position_type | varchar | Type of position (e.g. ats, local). Used at dataset level to exclude TalentCommunity records; not surfaced in any widget. |
| is_priority | boolean | 1 = flagged as priority hire. Complementary field. |
| hiring_manager | varchar | Hiring manager associated with the position. |
| recruiter | varchar | Recruiter associated with the position. Breakdown dimension |
| recruiter_name | varchar | Recruiter display name. |
| hiring_manager_name | varchar | Hiring manager display name. Complementary field. |
| closed_at | datetime | Position close timestamp. Complementary field. |
| job_code | varchar | Job code of the position. Complementary field. |
| position_name | varchar | Name of the position. Complementary field. |
| display_job_id | varchar | Job ID shown to candidates/employees. Complementary field. |
| posted_for | varchar | Current posting audience: 'internal', 'external', 'all', or NULL. |
| position_approved_at | datetime | Timestamp position was approved |
| sent_for_approval_at | datetime | Timestamp position was submitted for approval. |
| position_published_at | datetime | Timestamp position was first published. |
| time_to_fill_days | bigint | Days taken to fill the position. Complementary field. |
| created_by | varchar | User who created the position record. Complementary field. |