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