Postings_mastertable source fields and definitions

Follow

List of job postings created in Lever. Different from Postings table because Postings table holds all requisitions linked to a posting in a single row, within an array. Postings_mastertable breaks out every posting-requisition relationship in its own row.

Primarily used to power Postings global filters on dashboards.

Field Type Field Name Data Type Definition
Dimension Blank Text Helper dimension to show a blank in the dashboard when there is no data, instead of null
Dimension postingDepartment Text Department of the posting
Dimension postingHiringManager Text Hiring manager of the posting
Dimension postingId Text Unique id of the posting
Dimension postingLastUnlistedDate Datetime Date of the last time the posting was unlisted. If the posting was never unlisted, then null
Dimension postingLocation Text Location of the posting
Dimension postingOwnerName Text Owner of the posting
Dimension postingPublishedInternalAt Datetime Date when the posting was published as Internal
Dimension postingPublishedPublicAt Datetime Date the posting was published as Public
Dimension postingTeam Text Team of the posting
Dimension postingText Text Job title of the posting
Dimension requisitionCode Text Requisition code associated with this posting (can have multiple requisitions associated to a single posting, but each relationship will have a row in this table)
Dimension requisitionHiringManager Text Hiring manager on the requisition associated with this posting
Dimension requisitionId Text Requisition id associated with this posting (can have multiple requisitions associated to a single posting, but each relationship will have a row in this table)
Dimension requisitionLocation Text Location of the requisition associated with this posting
Dimension requisitionName Text Name of the requisition associated with this posting
Dimension requisitionOwnerName Text Owner of the requisition associated with this posting
Dimension requisitionTeam Text Team of the requisition associated with this posting
Was this article helpful?
0 out of 0 found this helpful