Requisitions_postings_mastertable source fields and definitions

Follow

List of requisitions created in Lever. Different from Requisitions table, which holds all postings linked to a requisition in a single row, within an array. Requisitions_postings_mastertable breaks out every requisition-posting relationship in its own row. Primarily used to power Requisition 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 Posting Activity Filter Text Filter to include postings that were created / unlisted / published between the Start and End dates on the dashboard, otherwise exclude from analysis. (Helper dimension for more complex calculations)
Dimension postingCreatedDate Datetime Creation date for the posting associated with this requisition
Dimension postingDepartment Text Department of the posting associated with this requisition
Dimension postingHiringManager Text Hiring manager of the posting associated with this requisition
Dimension postingId Text Unique id of the posting associated with this requisition
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 associated with this requisition
Dimension postingOwnerName Text Owner of the posting associated with this requisition
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 associated with this requisition
Dimension postingText Text Job title of the posting associated with this requisition
Dimension requisitionClosedDate Datetime Time when the requisition was last closed
Dimension requisitionCode Text Requisition code associated with this posting (can have multiple postings associated to a single requisition or vice versa, but each relationship will have a row in this table)
Dimension requisitionCreatedDate Datetime Creation date for the requisition
Dimension requisitionHiringManager Text Hiring manager on the requisition
Dimension requisitionId Text Requisition id associated with this posting (can have multiple postings associated to a single requisition or vice versa, but each relationship will have a row in this table)
Dimension requisitionLocation Text Location of the requisition
Dimension requisitionName Text Name of the requisition
Dimension requisitionOwnerName Text Owner of the requisition
Dimension requisitionTeam Text Team of the requisition
Was this article helpful?
1 out of 1 found this helpful