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 |