Resource Base
Use this base to see information for each of your resources, such as project or phase ID and description, employee, activity, vendor, and units/hours.
| Available Columns | Description | Date Range Available | Chartable | Links to Page |
| General Information | ||||
| Activity Type Value | Numeric value in the database for Labor, Expense, or Consultant | |||
| Activity Type | The activity type of the resource: Labor, Expense, or Consultant | |||
| Activity | The name of the activity assigned to the expense resource | Activity | ||
| Employee Type | The name of the employee type assigned to the labor resource | Employee Type | ||
| Is Resource | Indicates whether this is a resource | |||
| Is Task | Indicates the resource is a task | |||
| Notes | Any notes about the resource | |||
| Order |
The position of the resource on the Manage tab in the Project Command Center Example: You may sort the inquiry by resource order so it mirrors the order of the resources on the Manage tab. |
|||
| Phase Description | The description of the phase associated with the resource | Phase | ||
| Phase ID & Description | The ID and description of the project associated with the resource | Phase | ||
| Phase ID | The ID of the phase associated with the resource | Phase | ||
| Phase Order |
The position of the phase associated with the resource in the Project Command Center Example: You may sort the inquiry by phase order so it mirrors the order of the work breakdown structure in the Project Command Center. |
Phase | ||
| Priority | The priority of the task | |||
| Project Description | The name of the project | Project | ||
| Project ID & Description | The ID and description of the project associated with the resource | Project | ||
| Project ID | The ID of the project associated with the resource | Project | ||
| Reference | A short description that further identifies the resource | |||
| Resource Type | Indicates the type of resource (expense or consultant) | Vendor Type | ||
| Resource/Task Description | The name of the resource | |||
| Status | The status of the task | |||
| Vendor Type | The vendor type associated with the resource | Vendor Type | ||
| Vendor | The name of the vendor assigned to the expense or consultant resource | Vendor | ||
| People | ||||
| Employee | The name of the employee assigned to the labor resource | Employee | ||
| Supervisor | The supervisor of the employee associated with the resource | Employee | ||
| Dates | ||||
| Actual Completion Date | The actual date when work is complete for the resource | |||
| Actual Start Date | The actual date when work begins for the resource | |||
| End Date | The end date of the resource | |||
| Estimated Completion Date | The date when work is scheduled to be complete for the resource | |||
| Estimated Start Date | The date when work is scheduled to begin for the resource | |||
| Reported % Complete Date | The percent of a project or phase that is complete for the resource as reported on a specific date in the project lifecycle | X | ||
| Start Date | The start date of the resource | |||
| Hours/Units | ||||
| Scheduled Hours | The number of hours in the future scheduled for the resource in the Schedule Manager | X | X | |
| Units/Hours | The number of units or hours assigned to the resource | X | ||
| Dollars | ||||
| Beginning Balance Cost Amount | The amount entered in the Committed Cost Invoiced column on the Manage tab of the Project Command Center for the expense or consultant resource | X | ||
| Beginning Balance Fee Amount | The amount entered in the Committed Contract Invoiced column on the Manage tab of the Project Command Center for the expense or consultant resource | X | ||
| Cost Amount | The amount paid to employees for work performed, or the out-of-pocket costs to the company for expenses and consultants, for the resource | X | ||
| Cost Rate | The rate that reflects the actual cost of the resource without overhead or profit | |||
| Fee Amount | For billable billing types, the contract amount for the resource | X | ||
| Fee Rate | For billable billing types, the billing rate for the resource | |||
| Markup Rate | The markup rate associated with the resource | |||
| Percent Distribution | The percent of the total hours/units, cost amount, or contract amount represented by the resource | |||
| Reported % Complete | The date when you report the percent of work that is complete for the resource | X | X | |
| Scheduled Dollars |
The amount scheduled to date for the resource in the Schedule Manager Ajera calculates the amount by multiplying the scheduled hours by the billing rate. |
X | X | |
| Keys | ||||
| Activity Key | The database identifier of the activity associated with the resource | Activity | ||
| Employee Key | The database identifier of the employee associated with the resource | Employee | ||
| Employee Type Key | The database identifier of the employee type associated with the resource | Employee Type | ||
| Parent Resource Key |
The database identifier of the parent resource |
|||
| Phase Key | The database identifier of the phase | Phase | ||
| Project Key | The database identifier of the project associated with the resource | Project | ||
| Resource Key | The database identifier of the resource | Resource | ||
| Supervisor Key | The database identifier of the supervisor of the employee associated with the resource | Employee | ||
| Vendor Key | The database identifier of the vendor associated with the resource | Vendor | ||
| Vendor Type Key | The database identifier of the vendor type associated with the resource | Vendor Type | ||
| Gantt |
unavailable in ajeraCore Select to add the Gantt chart to your table widget. |
|||