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