Reporting Data Fields
Field Name | Field Category | Description |
|---|---|---|
Cost Center Mapping (Expense) | Accounting Fields | The accounting system's cost center to which expense will be routed. |
Cost Center Mapping (Revenue) | Accounting Fields | The accounting system's cost center to which revenue will be routed. |
Actual Cost End Date | Activity Fields | Date of the last reported expenses for the project. Includes unapproved (submitted) expenses if the report is configured to include unapproved expenses. Null if no reported expenses. |
Actual Cost Start Date | Activity Fields | Date of the first reported expenses for the project. Includes unapproved (submitted) expenses if the report is configured to include unapproved expenses. Null if no reported expenses. |
Projected Cost End Date | Activity Fields | Date of the last projected expenses for the project. Null if no reported expenses. |
Projected Cost Start Date | Activity Fields | Date of the first projected expenses for the project. Null if no reported expenses. |
Projected Hours End Date | Activity Fields | Date of the last projected hours for the project. Includes requested hours if the report is configured to include requested hours. Null if no scheduled hours. |
Task Plan End Date | Activity Fields | Latest task end date for the project. |
Task Plan Start Date | Activity Fields | Earliest task start date for the project. |
Actuals to Date | Actuals to Date Metrics | Amount of metric (e.g., hours, RDC, etc.) expended through the actuals cutoff date |
Budget Remaining | Actuals to Date Metrics | Budget - ATD |
Budget Remaining % | Actuals to Date Metrics | Budget - ATD, as a percentage of the budget |
Time Card Write-Up Amount | Adjustment Fields | Time Card Billing Adjusted Amount - Time Card Contract Amount |
Time Card Write-Up Percent | Adjustment Fields | Time Card Billing Adjusted Amount / Time Card Hours. |
Distance | Automobile Distance | Distance driven |
Distance Units | Automobile Distance | <M>iles or <K>ilometers |
Disbursed Amount Backlog | Backlog Fields | Costs that have been committed or budgeted, but not yet expended to date, measured in disbursed amount; (BudgetedDisbursedAmou ntAtCompletion) - (ActualDisbursedAmountTo Date), never less than zero |
Resource Direct Cost Backlog | Backlog Fields | Work that has been committed or budgeted, but not yet delivered to date, measured in resource direct cost; (BudgetedResourceDirectC ostAtCompletion)- (ActualResourceDirectCost ToDate), never less than zero |
Task Hours Backlog | Backlog Fields | Work that has been committed or budgeted, but not yet delivered to date, measured in task hours; (BudgetedTaskHoursAtCo mpletion) - (ActualTaskHoursToDate), never less than zero |
Baseline Created By | Baseline Fields | Name of user who created currently |
Baseline Created On | Baseline Fields | Date and time currently active task |
Baseline Name | Baseline Fields | Name of currently active task plan baseline |
Last Updated By | Baseline Fields | The last person who made modifications to budgeted amounts |
Metric | Baseline Fields | Hours, Billing Adjusted Revenue, Contract Revenue, RDC, Client Amount, or other metric for the baseline |
% Achieved Milestones | Billing Fields | Percentage of billing milestones that have been achieved |
% Achieved Milestones to Date | Billing Fields | Percentage of billing milestones that should have been achieved to date that have been achieved |
% Cost Written Down | Billing Fields | Percentage of actual disbursed costs that have been written down |
% Foregone Milestones | Billing Fields | Percentage of billing milestones that have been foregone |
% Foregone Milestones to Date | Billing Fields | Percentage of billing milestones that should have been achieved to date that have been foregone |
% Time Written Down | Billing Fields | Percentage of actual time that has been written down |
% Total Written Down | Billing Fields | Percentage of actual time and disbursed costs that have been written down |
% Unachieved Milestones to Date | Billing Fields | Percentage of billing milestones that should have been achieved to date that have not been achieved to date |
% Unbilled Billing Adjusted Revenue | Billing Fields | Percentage of actual time that has not yet been billed |
% Unbilled Client Amount | Billing Fields | Percentage of actual costs that have not yet been billed |
% Unbilled Hours | Billing Fields | Unbilled Hours / Hours at Completion |
Billed Billing Adjusted Revenue | Billing Fields | Actual time that has been billed, measured in billing adjusted revenue |
Billed Client Amount | Billing Fields | Actual costs that have been billed, measured in client amount |
Billed Hours | Billing Fields | Actual time that has been billed (T&M and NTE only) |
Billed Milestone Amount | Billing Fields | Milestones that have been billed |
Cost Written Down | Billing Fields | Actual costs that have been written down; (ActualDisbursedAmount) - (ActualClientAmount) |
% of Cost Budget Consumed | Budget Fields | % of Cost Budget Consumed |
% of Time Budget Consumed | Budget Fields | % of Time Budget Consumed |
Budget | Budget Fields | Budget amount, measured using the specified metric |
Budgeted Hours Variance | Budget Fields | If not defined, return a very large number in Excel format, null otherwise (csv, json, xml, etc) |
Budgeted Hours Variance % | Budget Fields | If not defined, return a very large number in Excel format, null otherwise (csv, json, xml, etc) |
Budgeted ODC | Budget Fields | If not defined, return a very large number in Excel format, null otherwise (csv, json, xml, etc) |
Budgeted ODC Client | Budget Fields | If not defined, return a very large number in Excel format, null otherwise (csv, json, xml, etc) |
Budgeted ODC Client Variance | Budget Fields | If not defined, return a very large number in Excel format, null otherwise (csv, json, xml, etc) |
Budgeted ODC Client Variance % | Budget Fields | If not defined, return a very large number in Excel format, null otherwise (csv, json, xml, etc) |
Budgeted ODC Expense | Budget Fields | If not defined, return a very large number in Excel format, null otherwise (csv, json, xml, etc) |
Budgeted ODC Expense Variance | Budget Fields | If not defined, return a very large number in Excel format, null otherwise (csv, json, xml, etc) |
Budgeted ODC Expense Variance % | Budget Fields | If not defined, return a very large number in Excel format, null otherwise (csv, json, xml, etc) |
Budgeted ODC Variance | Budget Fields | If not defined, return a very large number in Excel format, null otherwise (csv, json, xml, etc) |
Budgeted ODC Variance % | Budget Fields | If not defined, return a very large number in Excel format, null otherwise (csv, json, xml, etc) |
Budgeted Resource Direct Cost | Budget Fields | If not defined, return a very large number in Excel format, null otherwise (csv, json, xml, etc) |
Budgeted Resource Direct Cost Variance % | Budget Fields | If not defined, return a very large number in Excel format, null otherwise (csv, json, xml, etc) |
CostActualAmount | Budget Fields |
|
CostBudgetAmountDenominator | Budget Fields |
|
Engagement Cost Budget | Budget Fields | Engagement Cost Budget |
Engagement Cost Budget Metric | Budget Fields | Client Amount, Expense Amount, or Disbursed Amount |
Engagement Time Budget | Budget Fields | Engagement Time Budget |
Engagement Time Budget Metric | Budget Fields | Hours, Billing Adjusted Revenue, or RDC |
TimeActualAmount | Budget Fields |
|
TimeBudgetAmountDenominator | Budget Fields |
|
Description | Card Fields | Description of the RDC card |
Inactive (Yes/No) | Card Fields |
|
Name | Card Fields | Name of the RDC card |
Field | Category | Description |
Client | Client Fields |
|
Client Inactive (Yes/No) | Client Fields |
|
Client UDF's | Client Fields |
|
User Client | Client Fields | The client that this user is associated with |
User Mobile Phone | Contact Information Fields | Mobile phone number for this user |
User Office Phone | Contact Information Fields | Office phone number for this user |
User Other Contact Info | Contact Information Fields | Other contact information for this user |
Cost Contract Amount in Engagement Currency | Contract Line Item Fields | Contract cost contract amount |
Cost Contract Amount in Reporting Currency | Contract Line Item Fields | Converted to currency set on the parameters tab. |
New Contract Type | Contract Line Item Fields | Contract Type for the destination contract line item that deferred revenue was transferred to. |
New Cost Contract Terms | Contract Line Item Fields | Cost Contract Terms for the destination contract line item that deferred revenue was transferred to. |
New Time Contract Terms | Contract Line Item Fields | Time Contract Terms for the destination contract line item that deferred revenue was transferred to. |
Original Contract Line Item Code | Contract Line Item Fields | Contract Line Item Code for the original contract line item that deferred revenue was transferred from. |
Original Contract Line Item Name | Contract Line Item Fields | Contract Line Item Name for the original contract line item that deferred revenue was transferred from. |
Original Contract Type | Contract Line Item Fields | Contract Type for the original contract line item that deferred revenue was transferred from. |
Original Cost Contract Terms | Contract Line Item Fields | Cost Contract Terms for the original contract line item that deferred revenue was transferred from. |
Original Time Contract Terms | Contract Line Item Fields | Time Contract Terms for the original contract line item that deferred revenue was transferred from. |
Time Contract Amount Less Holdback in Engagement Currency | Contract Line Item Fields | Time contract amount minus the time holdback amount |
Time Contract Amount Less Holdback in Reporting Currency | Contract Line Item Fields | Time contract amount minus the time holdback amount. Converted based on currency set on the parameters tab. |
Time Contract Amount in Engagement Currency | Contract Line Item Fields | Engagement time contract amount |
Time Contract Amount in Reporting Currency | Contract Line Item Fields | Engagement time contract amount converted to currency set on the parameters tab |
Time Contract Terms | Contract Line Item Fields | Engagement time contract terms: T&M, Fixed Price, or Not to Exceed |
Time Holdback Amount | Contract Line Item Fields | Engagement time holdback amount |
Time Holdback Percent | Contract Line Item Fields | Time holdback as a percentage of the time contract amount |
Total Contract Amount | Contract Line Item Fields |
|
Total Contract Amount Less Holdback | Contract Line Item Fields |
|
Total Contract Amount Less Holdback in Engagement Currency | Contract Line Item Fields |
|
Total Contract Amount in Engagement Currency | Contract Line Item Fields |
|
Total Contract Amount in Engagement Currency | Contract Line Item Fields | Sum of Time and Cost Contract Amounts. |
Unbilled ODC Revenue | Cost Card Fields | Unbilled revenue from Other Direct Cost (ODC) mark-up and/or treatment of cost as fees |
Unbilled Reimbursable Expenses | Cost Card Fields |