Default Fields

Created by Advaith R, Modified on Tue, 1 Oct at 8:08 PM by Advaith R

  • Plan Availability
  • Essential
  • Standard
  • Premium
  • Enterprise

This is a comprehensive glossary to all the default fields that Rocketlane offers.

NAME
DESC
project_idA unique identifier for a project within an account
account_idA unique identifier used by Rocketlane administrators to track and manage customer accounts."
progress_percentCompleted tasks/total number of tasks %
current_phasesPhases that are currently active
last_completed_phaseLast phase that was marked complete
total_tasksTotal number of tasks
completed_tasksNumber of tasks completed
blocked_tasksNumber tasks that have been blocked
inprogress_tasksNumber of tasks currently in progress
todo_tasksNumber of tasks in the status "to-do"
tasks_at_riskNumber of tasks at risk
total_milestonesTotal number of milestones
completed_milestonesNumber of milestones completed
milestones_at_riskNumber of milestones at risk
blocked_milestonesNumber of Milestones that are blocked
todo_milestonesNumber of Milestones to be accomplished
inprogress_milestonesNumber of Milestones in progress
tracked_hoursNumber of hours that were tracked
billable_hoursNumber of hours that are billable
non_billable_hoursNumber of hours that are non billable
last_status_updateWhen the last project update was sent out
overdue_taskNumber of overdue tasks
overdue_milestoneNumber of overdue milestone tasks
total_allocated_hoursTotal number of hours allocated
ongoing_intervalsNumber of intervals, where the initial key event is captured, but the final key event is yet to be captured
customer_members_invitedNumber of Customer members that have been invited
customer_members_acceptedNumber of Customer members that have accepted the invitation
actual_revenueThe actual revenue is calculated based on the rate card and time tracked on the project
estimated_revenue
The forecasted portion of the fixed fee budget that can be recognized as per the hourly resource allocation
 plan for the project.
actual_costThe actual cost is calculated based on the team member's tracked hourly cost rates.
estimated_costEstimated cost is calculated based on the resource allocation plan for the project.
actual_profitDifference between the actual revenue and the actual cost incurred on a project.
estimated_profitThe difference between the forecasted recognized revenue and the forecasted cost.
actual_profit_marginThe ratio of profit to recognized revenue, represented as a percentage.
estimated_profit_marginThe ratio of profit to estimated revenue, represented as a percentage.
estimate_to_completeThe sum of all the remaining hours from today onwards based on the existing resource allocation data
estimate_at_completionThe projected total number of hours required to complete a project (EAC = ETC + Total tracked hours)
actual_revenue_in_account_currency
The actual revenue in account currency that is calculated based on the rate card and time tracked on the project
estimated_revenue_in_account_currency
The estimated revenue in account currency is calculated based on the rate card and allocated hours
 on the project.
actual_cost_in_account_currency
The actual cost in account currency, which is calculated based on the team member's tracked hourly cost rates.
estimated_cost_in_account_currency
The estimated cost in account currency which is calculated using the exchange rates you've configured in the
 system
actual_profit_in_account_currency
Actual profit in account currency, which is calculated by subtracting the cost incurred, based on
 team members' tracked hourly cost rates, from the recognized revenue.
estimated_profit_in_account_currency
Estimated profit in account currency, which is calculated as the difference between forecasted
 revenue and forecasted cost.
actual_profit_margin_in_account_currency
Actual profit margin in account currency, which is the percentage ratio of actual profit to
 recognized revenue, calculated as (Actual Profit / Recognized Revenue) * 100.
estimated_profit_margin_in_account_currency
Estimated profit margin in account currency represents the projected profit margin for a
 project as a percentage of forecasted revenue.
percentage_budgeted_hours_consumedBudgeted hours tracked/ Total budgeted hours %
percentage_budget_consumedBudget consumed/Budget allocated %


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article

Contact our support team

Have more questions? Paid users can log in and email or chat with us.

Start your free trial