| 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) |
