Values and join keys¶

Join keys¶

Topic	Contract
Company	`companies.company_name` (PK) and `companies.company_uid`. Aliases, COS, `title_conversion`, and `hiring_flag` join on name. Parent/sub/sibling lists store UIDs — resolve via `company_uid_name`.
Occupation cluster	`occupation_info.cluster_id` = `occupation_cluster.cluster_id` = `company_occupation_summary.cluster_id` = `wage_data.cluster_id` = `promotion_retention.cluster_id` = `ai_expertise_impact.cluster_id` = `occupation_name_catalog.cluster_id`.
O*NET	`occupation_cluster.onet_code` = `title_conversion.onet_code` = `title_probability.onet_code`. Many O*NET codes share one `cluster_id`.
Location	`location_mapping.zip` → `cbsa` + `msa_size`. `hiring_flag.cbsa` is INT; `location_mapping.cbsa` is VARCHAR — join on the numeric value. Wages and promotion filter on `msa_size`, not `cbsa`.
Industry	`companies.primary_industry` = `industries.industry_name` (exact).
Title → cluster	TITLECONVERT (optionally EXPAND CLUSTER) or CLUSTERCONVERT.

Allowed values¶

Topic	Contract
Badges	Platinum \| Gold \| NULL. NULL = unbadged / insufficient data. Filter `Ranked` = any non-null tier.
Posting tiers (COS)	`high` \| `above-average` \| `average` \| `low` \| `none`. Filters: `entry_posting_tier`, `total_posting_tier`. Sorts: `entry_postings`, `total_postings`. WYWM sort uses `entry_posting_tier` for early_career and `total_posting_tier` for growth/stability.
early_career_access	`0` \| `1`. Response-only.
top10_occupation	Stored `'1'` \| `'0'`. Queries also accept Yes / Y / true.
hiring_postings_qtile	`1` \| `2` \| `3` on `hiring_flag` (3 = strongest). Column name in the table is `postings_count_qtile`; API filter is `hiring_postings_qtile`.
AI flag	Raising the Bar \| Shrinking Fields \| Lower Potential \| Winners Pull Away \| NULL (unclassified).
AI trends	`entry_barrier_trend`, `expertise_premium_trend`: Rising \| Falling.
job_level	Sub-Bachelor's Degree \| Bachelor's Degree \| Advanced Degree \| Sub-Bachelor's Degree + Experience \| Bachelor's Degree + Experience \| NULL
msa_size	Large \| Small/Medium
wage_data.years_in	`0`–`10` (INT). The tenure grain since 0.17.0-beta; `0` \| `5` \| `10` before it
wage_data.experience_level	`0` through `10` (years, as strings). Text mirror of `years_in`
promotion_retention.experience_level	Entry-Level \| Experienced
wage_growth_tier	`low` \| `medium` \| `high`. Served as `wage_growth.tier`
premium_skill_vintage	`2026-09` \| `carried`. Not published by default
O*NET code	`XX-XXXX.XX` e.g. `15-1252.00`
Catalog name_type	`onet_title` \| `bgi_suboccupation` \| `cluster_name` \| `survey_title` \| `company_title_consensus` \| `common_title` \| `cluster_member` \| `acquired` \| `company_title_singleton`
match_source	`name_corpus` · `database` · `vector` · `hint` · `catalog_exact` · `catalog_canonical` · `catalog_fts` · `catalog_prefix`, and compounds with `+`: `database+catalog_exact`, `database+vector`.
confidence	`high` \| `low`
Hint action / source	action: `pin` \| `promote`. source: `curated` \| `derived`.
disambiguation.status	`resolved` \| `ambiguous` \| `no_match`