Offers data source fields and definitions

Follow
Available for Roles LTI seat holder
Permissions • N/A
Packages Advanced Analytics add-on

Here is a comprehensive list of the fields (and their definitions) within the Offers data source.

Field Type Field Name Data Type Definition
Dimension applicationCreatedDate Datetime Date when the application associated with the offer was created
Dimension applicationId Text Unique id of the application associated with the offer
Dimension archivedDate Text Date when a consideration's pipeline stage was changed to Archive
Dimension considerationArchiveReason Text Reason why this consideration was archived
Dimension considerationCreatedDate Datetime Date when this consideration was created
Dimension contactId Text Unique id of the contact information for the consideration
Dimension currentStageName Text Name of the current stage of the consideration
Dimension Include Offer Flag Text Whether or not to include an offer in a dashboard based on if the offerCreateDate / offerSentDate / OfferAcceptedDate is between the Start and End date on the dashboard (Helper dimension for more complex calculations)
Dimension isArchived Boolean True if the candidate under consideration was archived, else False
Dimension isHired Boolean True if the candidate was hired for this consideration, else False
Dimension manualOfferUploadDate Datetime Date when a manual offer was uploaded to the consideration, null if an offer was sent through a partner intergration
Dimension Hire Phases Text Track if a candidate is hired, declined offer, or still pending candidate response
Dimension Hire Phases Duplicate Text Track if a candidate is hired, declined offer, or still pending candidate response (duplicated as helper dimension for more complex calculations)
Dimension OfferAcceptedDate Datetime Date when an offer was accepted
Dimension offerAnticipatedStartDate Datetime Anticipated start date of most recent offer
Dimension offerCandidateName Text The name of the candidate the offer was extended to
Dimension offerCandidateSignedDate Datetime Date when candidate signed most recent offer
Dimension offerCreateDate Datetime Date when the offer was created
Dimension offerId Text Unique id of the offer
Dimension offerJobTitle Text Job title for the posting associated with this offer
Dimension offerPostingId Text ID for the posting associated with this offer
Dimension offerSentDate Datetime Offer sent date of most recent offer
Dimension offerStatus Text Status for this offer
Dimension postingDepartment Text Department of the posting associated with this offer
Dimension postingHiringManager Text Hiring manager of the posting associated with this offer
Dimension postingId Text Unique id of the posting associated with this offer
Dimension postingLocation Text Location of the posting associated with this offer
Dimension postingOwnerName Text Owner of the posting associated with this offer
Dimension postingTeam Text Team of the posting associated with this offer
Dimension PostingTitle Text Job title of the posting associated with this offer
Dimension postingWorkType Text Work type of the posting associated with this offer
Dimension profileId Text Unique id of the profile for the candidate this offer was made to
Dimension profileOwnerName Text Name of the owner of this candidate's profile
Dimension requisitionApprovedDate Datetime Approval date for the requisition that this offer is for
Dimension requisitionCode Text Code associated with the requisition that this offer is for
Dimension requisitionCreatedDate Datetime Creation date for the requisition that this offer is for
Dimension requisitionDepartment Text Department of the requisition that this offer is for
Dimension requisitionHiringManagerName Text Hiring manager on the requisition that this offer is for
Dimension requisitionId Text Unique id of the requisition that this offer is for
Dimension requisitionLocation Text Location of the requisition that this offer is for
Dimension requisitionName Text Name of the requisition that this offer is for
Dimension requisitionOwnerName Text Owner of the requisition that this offer is for
Dimension requisitionStatus Text Status of the requisition that this offer is for
Dimension requisitionTeam Text Team of the requisition that this offer is for
Dimension requisitionWorkType Text Work type of the requisition that this offer is for (i.e. contract, full time, intern)
Measure Current Offers Flag Numeric Shows as 1 if the candidate has not signed or declined the offer, 0 otherwise (Helper dimension for more complex calculations)
Measure Stage Start - Hire Start Date Numeric Count of days between the candidate creation and anticipated start date
Measure Stage Start - Signed Date Numeric Count of days between the candidate creation and candidate sign date (if the offer was not sent through Lever, counts the days between candidate creation and manual upload of the Offer to Lever)
Was this article helpful?
0 out of 0 found this helpful