Menu

Your location join is copying salaries across cities
📰

Your location join is copying salaries across cities

DEV Community: postgres·Nimbryxo-studio·14 days ago
#gWjb2QGu
#devtopostgresql#devto#dev#selected#const
Reading 0:00
15s threshold

You expand a job into city rows, and every office suddenly appears to share a salary range. The dashboard looks consistent. That's the uncomfortable part.

A posting's selected salary range isn't a salary observation for every listed location.

The Actor chooses the range matching the primary location when applicable. Otherwise, it uses the posting's typical/base range. Flattening the location list copies that selection without adding evidence about another office.

Why that salary stays with the posting

Employers can publish several geographic pay bands inside a single job description. The Actor exposes a selected range through scalar compensation fields, alongside the sentence it came from.

That gives you something useful for a posting record.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.