| Old Column Names | Report Type | New Column Names |
|---|
| Name | Project, Task, App (Bugs, |
hange | Change Request, etc.) | Name |
| Amount (Act, Billable) | Project, Task, Task Assignment, App | Actual Revenue |
| Amount (Est, Billable) | Project, Task, Assignment | Planned Labor Revenue |
| Amount (Invoiced) | Project, Task, App | Invoiced Revenue |
| Budget Status | Project, Task | Budget Health |
| Cost (Act) | Project, Task, Assignment, App | Actual Cost |
| Cost (Est) | Project, Task, Assignment | Planned Cost |
| Finish (Est) | Project, Task, Assignment | Planned Finish |
| Hours (Act) | Project, Task, App | Actual Hours |
| Hours (Est) | Project, Task | Planned Hours |
| Manager | Project, Task, Time Entry, Expense, Discussion, File | Manager |
SF Opportunity ID | SF Opportunity ID |
| Schedule Status | Project, Task | Schedule Health |
| Start (Month, Year) | Project, Task | Start |
State | State | | %Comp (Baseline) | Project, Task | Baseline %Comp |
| %Comp (Est) | Project, Task | Planned % Comp |
ACWPProject, Task | ACWP | Alignment | Alignment | | Amount (Act, Non-Billable Expense) | Project, Task | Actual Non-billable Expense |
| Amount (Act, Non-Billable Labor) | Project, Task | Actual Non-billable Labor |
| Amount (Expense, Invoiced) | Project, Task | Invoiced Expense |
| Amount (Time, Invoiced) | Project, Task | Invoiced Labor |
| BCWP | Project, Task | BCWP |
BCWS | Project, Task | BCWSBilling Model | Billing Model | Benifit | Benifit | Project, Task | Budget | Budget | (Baseline) | Project, Task | Baseline Budget |
| CPI | Project, Task | CPI |
Code | Code |
| Cost (Accrued, Fixed) | Project, Task | Actual Fixed Cost |
| Cost (Act, Labor) | Project, Task | Actual Labor Cost |
| Cost (Act, Non-Labor) | Project, Task | Actual Non-labor Cost |
| Cost (Est, Baseline) | Project, Task | Baseline Cost |
| Cost (Est, Fixed) |
| Planned Fixed Cost |
| Cost (Est, Labor) | Project, Task | Planned Labor Cost |
| Cost (Est, Non-Labor) | Project, Task | Planned Non-labor Cost |
| Cost (Projected) | Project, Task | Projected |
Cost VarianceProject, Task | Cost Variance | Created | Created | Creator | Creator | | Deadline (Month, Year) |
| Deadline (Week, Month, Quarter, Year) |
| Deadline (Baseline) |
| Baseline Deadline |
| Deadline Variance (Baseline) |
| Baseline Deadline Variance |
| Description | Project, Task | Description |
| Finish (Act) | Project, Task | Actual Finish |
| Finish (Baseline) | Project, Task | Baseline Finish |
| Finish (Projected) | Project, Task | Projected Finish |
| Finish Variance (Baseline) | Project, Task | Baseline Finish Variance |
Fixed Price | Fixed Price |
| Hours (Act, Billable) | Project, Task, App | Actual Billable Hours |
| Hours (Act, Non-Billable) | Project, Task, App | Actual Non-billable Hours |
| Hours (Invoiced) | Project, Task, App | Invoiced Hours |
| Hours (Projected) | Project, Task | Projected Hours |
Priority, TaskPriority | Project Remaining Work, TaskRemaining Effort | Risk | Risk | | SPI | Project, Task | SPI |
| Schedule Variance | Project, Task | Schedule Variance |
| Type |
| Start (Baseline) | Project, Task | Baseline Start |
| Start Variance (Baseline) | Project, Task | Baseline Start Variance |
| System ID | Project, Task | ID |
Team | Team | | Work Baseline | Project, Task | Baseline Effort |
| Work Variance (Baseline) | Project, Task | Baseline Effort Variance |
WorkspaceProject, User, Client | Workspace | | Email | User, Client | Email |
Hierarchy | Hierarchy | | Last Access | User, Client | Last Accessed |
Login| Phone | User, Client | Phone |
Root | Root | Admin | Admin | Bill Rate | Bill Rate | Cost Rate | Cost Rate | Roles | Roles | Work Calendar | Work Calendar | Task | FinishUser, Client | Login | Parent | Parent | | Project, Task | Planned Finish |
| Project | Task, Time Entry, Expense, Discussion, File | Project |
Resources | Resources | Task (Month, Year) | ?? | Update (Last) | Update (Last) | Allow Time | Allow Time Logging | Attachments | Attachments | Constraint Date | Constraint Date | Constraint Type | Constraint Type | | Allow Time | Task | Allow Time Logging |
| Cost (Fixed) | Task | Planned Fixed Cost |
CriticalHierarchy | Hierarchy | Critical | Duration | Duration | Hours (My, Est)| My Planned Effort |
| Hours (My, Act) | Task |
Hours (My, Act)Milestone | Milestone | Predecessor | Predecessors | Schedule Type | Schedule Type | | My Actual Effort |
| ID | Task | # |
| Last Updated On | Task | Last Updated |
Manually Scheduled | Manually Scheduled | | Start (Act) | Task | Actual Start |
| Start (Projected) | Task | Projected Start |
Topmost Task | Topmost Task | Updates (All) | Updates (All) | | Work (Hr) | Task | Planned Effort |
Time Entry | Date (Month, Year) | Date | Approved , Expense | Column Removed. The "Approved On |
Approver Comments | Approver Comments | Rejected On | Rejection Comments | State| " will accommodate this data. |
| Rejection Comments | Time Entry |
, ExpenseState | User | User | User Comments | Comments | Work Item | Work Item | Hours | Hours | Accounting Code | | Column Removed. The "Approver Comments" will accommodate this data. |
| User Comments | Time Entry, Expense |
Accounting CodeApprover, ExpenseApprover | Bill Rate | Bill Rate | | Billable | Time Entry, Expense | Billable |
Billing | Revenue | Cost Rate | Cost Rate | | Costable | Time Entry, Expense | Costable |
Cost | Cost | | Created (Month, Year) | Time Entry, Expense, Discussion, File | Created |
Creator | Creator | Invoiced By | Invoiced By | Invoiced On | Invoiced On | System ID | System ID | Task | Task | Time Code | Time Code | Year - Week | Year - Week | Expense | Expense | Expense | Expense Total | Expense Total | Submitted By | Submitted By | Attachment | Attachment | Description | Description | Expense Code | Expense Code | Expense Item Amount | Expense Item Amount | Expense Item Date | Expense Item Date | Reimbursable | Reimbursable | Discussion | Discussion | Discussion | Last Post | Last Post | Project | Project | Client Shared | Client Shared | Description | Description | Initiator | Initiator | Last Post On | Last Post On | Open | Open | Replies | Replies | File | Messages | Messages | Name | Name | Owner | Owner | Path | Path | Size | Size | Version | Version | Checkouts | Checkouts | Client Shared | Client Shared | Description | Description | Last Checkin | Last Checkin | Total Size | Total Size | Task Status Update | %Comp | %Comp | Comments | Comments | Date | Date | Update By | Update By | Finish (Act) | Actual Finish | Start (Act) | Actual Start | Task Assignment | Finish | Planned Finish | Hours (Act) | Actual Effort | Hours (Est) | Planned Labour Hours | Start | Planned Start | User | User | App | Assigned To | Assigned To | Due | Due | State | State | Summary | Name | Update (Last) | Update (Last) | Age | Age | App | App | Completed | Completed | Created (Month, Year) | Created | Creator | Creator | Delayed | Delayed | Detail | Description | Last Updated On | Last Updated On | Open | Open | Priority | Priority | Requestor | Requestor | State Manager | State Manager | System ID | ID | Time Out | Time Out | Updates (All) | Updates (All) | Visible to requestor | Visible to requestor | Workspace | Workspace | Time Phased | Capacity (Act)| Revenue |
| Capacity (Act) | Time Phased | Actual Capacity |
| Capacity (Est) | Time Phased | Planned Capacity |
| Hours (Act) | Time Phased | Actual Effort |
| Hours (Est) | Time Phased | Planned Effort |
| Utilization (Act) | Time Phased | Actual Utilization |
Utiliation | Utilization (Est) | Time Phased | Planned Utilization |
EfficiencyEfficiency | Free Hours (Realtime)Free Hours (Realtime) |
| Hours (Act, Billable) | Time Phased | Actual Billable Hours |
| Hours (Act, Non-Billable) | Time Phased | Actual Non-billable Hours |
| Hours (Available) | Time Phased | Available Hours |
| Hours (Invoiced) | Time Phased | Invoiced |
HoursActual Billable Actual Cost | Actual Labor Cost | Actual Margin | Actual Profit | Actual Revenue | Invoiced Revenue | Planned Cost | Planned Labor Cost | Planned Margin | Planned Profit | Possible Revenue | User | Admin | Bill Rate | Cost Rate | Email | Last Accessed | Login | Name | Phone | Roles | Work Calendar | Workspace | Other | Actual Profit | Planned Profit | Actual Margin | Last Modified | Planned Margin | Actual Billable Expense | Actual Billable Labor | ExternalKey | Successors | WBS | App | Possible Revenue