Use the following attributes when querying project information:
Displays the unique identifier for a project.
Displays the name of the project.
Displays the description for this project.
Displays the name of the company.
Displays the start date.
Displays the finish date.
Displays the baseline start date of an investment.
Displays the baseline finish date of the investment.
Displays the first and last name of the project manager.
Displays the charge code associated with the project.
Displays the project lifecycle stage.
Defines the goal of this investment that aligns it with the main corporate strategy.
Displays comments about the overall status of the project.
Indicates the status.
Stoplight values:
Displays the overall status of the project.
Displays the progress status of the project.
Displays the project entity.
Displays whether an investment is active. Displays Yes if the investment is active and No if it is not.
Displays whether this investment is open for time entry (TE). Displays "Yes" if actuals can be entered against the investment and "No" if actuals cannot be entered against the investment.
Displays "Yes" if this project is a program and "No" if the project is not a program.
Displays "Yes" if this project is marked as a template and "No" if it is not marked as a template.
Displays
Risk - Flexibility:
Risk - Funding:
Risk - Human Interface:
Risk - Implementation:
Risk - Interdependency:
Risk - Objectives:
Risk - Organizational Culture:
Risk - Resource Availability:
Risk - Sponsorship:
Risk - Supportability:
Risk - Technical:
Displays the planned cost for simple budgeting.
Displays the planned cost start date.
Displays the planned finish date.
Displays the planned benefit for simple budgeting.
Displays the planned benefit start date.
Displays the planned benefit finish date.
Displays the Net Present Value calculated from the planned cost and planned benefit.
Displays the return on investment as calculated from the planned cost and planned benefit.
Displays the planned breakeven date.
Indicates whether the Net-Present Value (NPV) date followed the investment's date. Displays Yes if the investment's net present value (NPV) includes the Planned NPV, Planned ROI, and Planned Breakeven data and No if the investment's net present value (NPV), does not include the Planned NPV, Planned ROI, and Planned Breakeven data.
Displays the date and time this project was created.
Displays the name of the resource who last created this project.
Displays the date and time this project was last updated.
Displays the resource that last updated this object or entity.
Use the following attributes when querying program information:
Displays the name of the program for which data is being entered.
Displays the unique identifier for the program.
Displays the description of the program.
Displays the start date of the program.
Displays the finish date of the program.
Displays the first and last name of the program manager.
Displays whether an investment is active. Displays Yes if the investment is active and No if it is not.
Displays risk factors associated with the project.
Displays the risk factor on how flexible the organization can adapt to change based on current practices. Low risk means the project is not dependent on current practices and High risk means the project is highly dependent on current practices.
Values: Low, Medium, High
Displays the project's risk in funding. Low risk means funds are available without constraints. High risk means the funds are not allocated.
Values: Low, Medium, High
Displays the project's risk associated with the human interface. Low risk means the project has a well defined user interface (UI) and High risk means the project has a poorly defined user interface (UI).
Values: Low, Medium, High
Displays the project's risk associated with implementation. Low risk means there are minor uncertainties with the implementation efforts and user acceptance. High risk means there are major uncertainties with implementation efforts and user acceptance.
Values: Low, Medium, High
Displays the project's risk with interdependencies. Low risk means the project is not dependent on other projects and High risk means project dependencies exist.
Values: Low, Medium, High
Displays the project's risk with objectives. Low risk means the requirements, objectives, scope, and benefits are reasonable, clearly defined, measurable, and verifiable. High risk means objectives are not reasonable, clearly defined, measurable, and verifiable.
Values: Low, Medium, High
Displays the project's risk with organizational culture. Low risk means the project requires little change to the organization culture, business processes, procedures or policies and High risk means the project requires major changes to the organization culture, business processes, procedures or policies.
Values: Low, Medium, High
Displays the project's risk in resource availability. Low risk means internal resources are available without constraints and external resources are not required. High risk means internal resource availability is uncertain and external resources are required.
Values: Low, Medium, High
Displays the project's risk with sponsorship. Low risk means the sponsorship is clearly identified and committed. High risk means the sponsorship is not clearly identified and uncommitted.
Values: Low, Medium, High
Displays the project's risk with supportability. Low risk means the project's supportability is easy with minor updates. High risk means the project's supportability is difficult and requires major updates.
Values: Low, Medium, High
Displays the project's risk with technology. Low risk means the project's technology is proven and does not require any new internal and external expertise. High risk means the project's technology is unproven and requires external expertise.
Values: Low, Medium, High
Use the following attributes when querying project team staff information:
Displays the system generated effective full name of the resource. This field is a concatenation of the first and last name of the resource.
Displays the project specific role for this resource.
Indicates whether this investment is derived from a role. Displays Yes if the investment is derived from a role and No if it is not.
Displays the booking status for the resource on this investment.
Values:
Displays the requisition status when a requisition is linked to the team record. Project managers use the request status to monitor the state of their requisitions and to manually book a resource without using a formal requisition.
Values:
Displays whether this investment is open for time entry (TE). Displays "Yes" if actuals can be entered against the investment and "No" if actuals cannot be entered against the investment.
Displays the start of the resource's allocation for the project.
Displays the finish of the resource's allocation for the project.
Displays the start of the resource's hard allocation to the project.
Displays the end of the resource's hard allocation to the project.
Displays the baseline start date of this project.
Displays the baseline finish date of this project.
Use the following attributes when querying work breakdown structure information:
Displays the unique identifier for the task.
Displays the name of the task.
Displays the work breakdown structure phase name of a task.
Displays the work breakdown structure activity name of a task.
Displays the status of the task.
Displays the task's depth in the work breakdown structure.
Displays the work breakdown structure record type.
Displays the sequence number of the task.
Indicates this task as a key task. Displays Yes if the task is a key task and No if it is not.
Displays the start date.
Displays the finish date.
Displays the duration days of the task.
Displays the baseline start date for the task.
Displays the baseline finish date for the task.
Displays the baseline duration of this task.
Displays the percentage complete calculation of this task.
Displays the charge code for this task.
Displays the category name for this task.
Use the following attributes when querying work breakdown structure phase name detail information:
Displays the system-generated internal phase ID.
Displays the unique identifier for the phase.
Displays the status of the phase.
Displays the order in which the phase appears in the work breakdown structure.
Indicates this phase as a key phase. Displays Yes if the phase is a key phase and No if it is not.
Displays the actual start date of the phase.
Displays the actual finish date of the phase.
Displays the phase duration in days.
Displays the baseline start date of the phase.
Displays the baseline finish date of the phase.
Displays the baseline duration of the phase.
Displays the percentage complete calculation of the phase.
Use the following attributes when querying work breakdown structure activity name detail information:
Displays the system generated internal activity ID.
Displays the unique identifier for an activity.
Displays the activity status.
Displays the order in which the activity appears in the work breakdown structure.
Indicates this activity as a key activity. Displays Yes if the activity is a key activity and No if it is not.
Displays the actual start date of an activity.
Displays the actual finish date of an activity.
Displays the activity duration in days.
Displays the baseline start date of an activity.
Displays the baseline finish date of an activity.
Displays the baseline duration of an activity.
Displays the percentage complete calculation of an activity.
Use the following attributes when querying project assignments information:
Displays the system generated effective full name of the resource.
Displays the unique identifier for this resource.
Displays the start date.
Displays the finish date.
Displays the baseline start date of an investment.
Displays the baseline finish date of the investment.
Use the following attributes when querying project risks information:
Displays the ID of the risk.
Displays the name of the risk.
Displays the description of the risk.
Displays the risk symptoms.
Displays the system generated effective full name of the resource. This field concatenates the first and the last name of the resource.
Displays the name of the risk.
Displays the risk impact of the project.
Values:
Displays the date this risk.
Displays the description of the risk.
Defines the assumptions of this project.
Displays the risk priority.
Values:
Displays the risk status.
Values:
Displays the degree of probability.
Values:
Displays the approach to mitigate the risk.
Values:
Displays the targeted resolution date.
Displays the description of the resolution.
Displays the date the risks request was resolved.
Displays the system generated effective full name of the resource. This field concatenates the first and the last name of the resource.
Displays the date and time this risk was created.
Displays the system generated effective full name of the resource. This field concatenates the first and last name of the resource.
Displays the date and time this risk was last updated.
Use the following attributes when querying project issues:
Displays the unique identifier assigned to the issue.
Displays the name of the issue.
Displays the short description of the issue.
Displays the name of the resource assigned to the issue.
Displays the issue category type.
Displays the priority of the issue.
Values:
Displays the status of the issue.
Values:
Displays the targeted resolution date.
Displays the description of the resolution.
Displays the date the issue was resolved.
Displays the resource who resolved this issue.
Displays the date and time this issue was created.
Displays the resource who last updated this issue.
Displays the date and time this issue was last updated.
Use the following attributes when querying project change requests:
Displays the unique identifier assigned to the change request.
Displays the name of the change request.
Displays the short description of the change request.
Displays the resource responsible for ensuring that the request is managed and tracked appropriately through its lifecycle. For example, If change request is created from a risk, the owner information is carried over to the change request.
Displays the category to which the request is assigned.
Displays the priority of the change request.
Values:
Displays the status of the change request.
Values:
Displays how this change benefits the project.
Displays the description of the impact on the baseline.
Displays how other projects are impacted by this request.
Displays the resource responsible to assess the request.
Displays the date by which the change request should be assessed.
Displays the resource responsible to approve the request.
Displays the date the change request was approved.
Displays the targeted resolution date.
Displays the date when the change request was reviewed.
Displays the date when this change request was closed.
Displays the date and time when this change request was created.
Displays the name of the resource who last updated this change request.
Displays the date and time this change request was last updated.
Displays the effect on cost.
Displays the effect on schedule.
Displays the effect on resources.
Use the following attributes when querying service information:
Displays the unique identifier for the service.
Displays the name of the service.
Displays the name of the resource who manages the service. By default the user who creates the service is the service manager.
Displays the short description of the service.
Displays the main application.
Displays the start date.
Displays the finish date.
Displays the baseline start date of an investment.
Displays the baseline finish date of the investment.
Specifies if planned cost dates are synchronized with the investment dates. Displays Yes if planned cost dates are synchronized with the investment's start and finish date and No if planned cost dates are not synchronized with the investment's start and finish date.
Defines the goal of this investment that aligns it with the main corporate strategy.
Displays the alignment score.
Displays the stage of the service.
Displays the status of the investment.
Values: Approved, Rejected, Unapproved
Indicates the status.
Stoplight values:
Indicates the relative importance to the organization's business goal.
Displays the level of work that has been completed.
Values:
Displays the charge code associated with the service.
Displays the partition associated with the service.
Displays whether the investment is required. Displays "Yes" if the investment is required for portfolio scenarios and "No" if the investment is not required for portfolio scenarios.
Displays whether an investment is active. Displays Yes if the investment is active and No if it is not.
Displays whether this investment is open for time entry (TE). Displays "Yes" if actuals can be entered against the investment and "No" if actuals cannot be entered against the investment.
Displays a short description for the entity associated with the service.
Displays the tracking method used to enter time for this investment, including the following:
Displays the short name for the risk.
Displays the total cost for a service.
Displays the total number of open incidents for this subscription.
Displays the total incident actual effort based on the following formula:
Total Incident Actual Effort = Actuals + remaining ETC
Displays the total labor effort.
Displays the planned cost for simple budgeting.
Displays the planned cost start date.
Displays the planned finish date.
Displays the planned benefit for simple budgeting.
Displays the planned benefit start date.
Displays the planned benefit finish date.
Displays the Net Present Value calculated from the planned cost and planned benefit.
Displays the return on investment as calculated from planned cost and planned benefit.
Displays the planned break even date.
Indicates whether the Net-Present Value (NPV) date followed the investment's date. Displays Yes if the investment's net present value (NPV) includes the Planned NPV, Planned ROI, and Planned Breakeven data and No if the investment's net present value (NPV), does not include the Planned NPV, Planned ROI, and Planned Breakeven data.
Displays the date and time this service was created.
Displays the resource that created this service.
Displays the date and time this service was last updated.
Displays the resource that last updated this service.
Use the following attributes when querying service team information:
Displays the system generated effective full name of the resource.
Displays the service specific role for the resource.
Indicates whether this investment is derived from a role. Displays Yes if the investment is derived from a role and No if it is not.
Displays the booking status for the resource on this investment.
Values:
Displays the requisition status when a requisition is linked to the team record. Project managers use the request status to monitor the state of their requisitions and to manually book a resource without using a formal requisition.
Values:
Displays whether this investment is open for time entry (TE). Displays "Yes" if actuals can be entered against the investment and "No" if actuals cannot be entered against the investment.
Displays the start of the resource's allocation for the service.
Displays the finish of the resource's allocation for the service.
Displays the start of the resource's hard allocation to the service.
Displays the finish of the resource's hard allocation to the service.
Displays the baseline start date of the service.
Displays the baseline finish date of the service.
You can use the following attributes to query dates:
Displays data on a daily basis.
Displays the weekly start date.
Displays the weekly end date.
Displays the monthly start date.
Displays the monthly end date.
Displays the quarterly start date.
Displays the quarterly end date.
Displays the previous week's dates for reports using weekly dates.
Displays the previous month's dates for reports using daily dates.
Displays the previous month's dates for reports using monthly dates.
Displays the previous quarter's dates for reports using monthly dates.
Displays the previous quarter's dates for reports using quarterly dates.
Displays the previous year's dates for reports using monthly dates.
Displays the current week's dates for reports using weekly dates.
Displays the current month's dates for reports using daily dates.
Displays the current month's dates for reports using monthly dates.
Displays the current quarter's dates for reports using monthly dates.
Displays the previous quarter's dates for reports using quarterly dates.
Displays the current year's dates for reports using monthly dates.
Displays the next week's dates for reports using weekly dates.
Displays the next month’s dates for reports using daily dates.
Displays the next month’s dates for reports using monthly dates.
Displays the next quarter’s dates for reports using monthly dates.
Displays the next quarter’s dates for reports using quarterly dates.
Displays the next year's dates for reports using monthly dates.
Use the following attributes when querying measure information:
Displays the date.
Displays the weekly start date.
Displays the weekly end date.
Displays the monthly start date.
Displays the monthly end date.
Displays the quarterly start date.
Displays the quarterly end date.
Displays the previous week's dates for reports using weekly dates.
Displays the previous month's dates for reports using daily dates.
Displays the previous month's dates for reports using monthly dates.
Displays the previous quarter's dates for reports using monthly dates.
Displays the previous quarter's dates for reports using quarterly dates.
Displays the previous year's dates for reports using monthly dates.
Displays the current week's dates for reports using weekly dates.
Displays the current month's dates for reports using daily dates.
Displays the current month's dates for reports using monthly dates.
Displays the current quarter's dates for reports using monthly dates.
Displays the previous quarter's dates for reports using quarterly dates.
Displays the current year's dates for reports using monthly dates.
Displays the next week's dates for reports using weekly dates.
Displays the next month’s dates for reports using daily dates.
Displays the next month’s dates for reports using monthly dates.
Displays the next quarter’s dates for reports using monthly dates.
Displays the next quarter’s dates for reports using quarterly dates.
Displays the next year's dates for reports using monthly dates.
| Copyright © 2010 CA. All rights reserved. | Email CA Technologies about this topic |