| Field Type |
Field Name |
Data Type |
Definition |
| Dimension |
_id |
Text |
Unique id of the requisition |
| Dimension |
Approval Date Filter |
Boolean |
True if the requisition was approved between the Start and End date on the dashboard, else False |
| Dimension |
Creation / Closed Period |
Text |
Checking if a requisition was new in the period, already existing, or created after the period when selecting Start and End dates on a dashboard to look at historic status of a requisition |
| Dimension |
linkedPostingTitles |
Text |
String of title of the postings associated with this requisition |
| Dimension |
linkedReservedOfferIds |
Text |
Unique id of the offer created against this requisition |
| Dimension |
post |
Text |
Unique id of the posting associated with this requisition |
| Dimension |
Req Status (historic) |
Text |
What the status of the requisition was between the Start and End date on the dashboard filters |
| Dimension |
Req_Age |
Text |
Bucket the age of the requisition based on how many days it has been since it was created (i.e. 0 - 30 days, 31 - 60 days) |
| Dimension |
requisitionApprovalStatus |
Text |
Status of the requisition approval |
| Dimension |
requisitionApprovedDate |
Datetime |
Approval date for the requisition |
| Dimension |
requisitionBackfill |
Boolean |
True if requisition is a backfill |
| Dimension |
requisitionCode |
Text |
Code associated with the requisition |
| Dimension |
requisitionCompensationCurrency |
Text |
Currency of the compensation |
| Dimension |
requisitionCompensationPaymentInterval |
Text |
Interval at which the compensation is paid out |
| Dimension |
requisitionCreatedDate |
Datetime |
Creation date for the requisition |
| Dimension |
requisitionDepartment |
Text |
Department of the requisition |
| Dimension |
requisitionHiringManagerName |
Text |
Hiring manager on the requisition |
| Dimension |
requisitionIsHeadcountInfinite |
Boolean |
True if headcount associated to the requisition is infinite |
| Dimension |
requisitionLastClosedDate |
Datetime |
Time when the requisition was last closed |
| Dimension |
requisitionLocation |
Text |
Location of the requisition |
| Dimension |
requisitionName |
Text |
Name of the requisition |
| Dimension |
requisitionOwnerName |
Text |
Owner of the requisition |
| Dimension |
requisitionStatus |
Text |
Status of the requisition |
| Dimension |
requisitionTeam |
Text |
Team of the requisition |
| Dimension |
requisitionUpdatedDate |
Datetime |
Time when the requisition was updated |
| Dimension |
requisitionWorkType |
Text |
Work type of the requisition (i.e. contract, full time, intern) |
| Measure |
Age of Req |
Numeric |
If the requisition status is still open, count the days between the requisition creation date and today |
| Measure |
avg time to fill |
Numeric |
Count the days between when the requisition was created and when it was most recently closed |
| Measure |
avgreqapproval |
Numeric |
Count the days between when the requisition was created and when it was approved |
| Measure |
Hired |
Numeric |
Total headcount hired into a requisition |
| Measure |
Open |
Numeric |
Total headcount minus hired headcount |
| Measure |
Total Headcount |
Numeric |
Total headcount associated with a requisition |
