Investment Financials Universe

Use the CA PPM Investment Financials universe only for custom reports that are created in a release before CAPPM v13.0. We recommend creating new reports using the Universe: CA PPM Investment Financials v13.
ccppmod143
Use the CA PPM Investment Financials universe only for custom reports that are created in a release before
CA PPM
 v13.0. We recommend creating new reports using the Universe: CA PPM Investment Financials v13.
Investments Class (Investment Financials Universe)
The following are the attributes for querying the investments:
  • Investment ID
    Displays the identification code for an investment. 
  • Investment Name
    Displays the name of the investment. 
    Detail Object:
     Internal Investment ID
  • Description
    Displays the description.
  • Investment Manager
    Displays the name of the investment manager whose data displays in the report.
    Detail Object:
     Internal Investment Manager ID
  • Location
    Displays where the investment work is being performed.
    Detail Objects:
     Location Code and Internal Location ID
  • Entity
    Displays the entity that the investment belongs to.
    Detail Objects:
     Entity Code and Internal Entity ID
  • Department
    Displays the department to match with the investment.
    Detail Objects:
     Department Code and Internal Department ID
  • Financial Status
    Displays the status that determines how transactions entered against the investment are handled.
    Values:
    • Open. All transactions that are entered against an investment can be fully processed.
    • Hold. New transactions cannot accumulate on the investment, but existing transactions can be processed against the investment.
    • Closed. New transactions cannot accumulate and credit memos cannot be issued against an investment. When you mark the investment financial status as "Closed," it no longer is open for financial processing.
    Detail Object:
     Internal Financial Status Code
  • Affiliated Investment Name
    Displays the project name that is financially tied to the investment.
    Detail Object:
     Affiliated Investment ID and Internal Affiliated Investment ID
  • Type
    Displays the investment type.
  • Investment Class
    Displays the investment that is used to group projects or investments for reporting.
    Detail Object:
     Internal Investment ID
  • Stage
    Displays the lifecycle stage at which the investment stands. This metric is used in portfolio analysis when you use comparable stage criteria across all portfolio investments.
    Detail Object:
     Internal Stage Code
  • Goal
    Displays the goal for the investment that aligns it with the main corporate strategy. This metric is used in portfolio analysis when you use comparable goal criteria across all portfolio investments.
    Values:
     Cost Avoidance, Cost Reduction, Grow the Business, Infrastructure Improvement, and Maintain the Business
    Detail Object:
     Internal Goal Code
  • Start Date
    Displays the actual start day of an investment.
  • Finish Date
    Displays the actual finish day of an investment.
  • Baseline Start Date
    Displays the baseline start date of an investment.
  • Baseline Finish Date
    Displays the baseline finish date of an investment.
  • Status Indicator
    Indicates the status an investment.
    Values:
     On Track, Marginal, and Critical
    Detail Object:
     Internal Status Indicator Enum
  • Status Comments
    Displays comments, if any, about the project status.
  • Active (Yes/No)
    Displays if the investment is active.
  • Is Template (Yes/No)
    Displays if the investment is derived from a template.
  • Open for Time Entry (Yes/No)
    Displays if the investment is open for time entry.
    Values:
     Yes and No
  • Charge Code
    Displays charge codes, which can represent any breakdown of work that is associated with an investment.
    Detail Object:
     Internal Charge Code ID
  • Partition
    Displays the partition that is associated with an attribute.
    Detail Object:
     Internal Partition Code
 
Investment WBS Class
You can use the objects within the Investment WBS section to query the work breakdown schedule (WBS) of an investment.
Use the following attributes to query the investment WBS:
  • Task ID
    Displays the unique identifier that is associated with this task.
  • Task Name
    Displays the name of the task.
    Detail Object:
     Internal Task ID
  • Status
    Displays the status of the investment.
    Values:
     Completed, Started, and Not Started
    Detail Object:
     Internal Status Enum
  • WBS Level
    Specifies the number level depth in which to list elements of work breakdown structure (WBS). Information is aggregated from the level 2 position down to the specified level. Level 1 is reserved for the WBS root node element and is not included in this report.
  • WBS Sequence Number
    Displays the order in which the work breakdown structure (WBS) fields appear on the report.
  • Start Date
    Displays the actual start day of an investment.
  • Finish Date
    Displays the actual finish day of an investment.
  • Baseline Start Date
    Displays the baseline start date of an investment.
  • Baseline Finish Date
    Displays the baseline finish date of an investment.
  • Is Key (Yes/No)
    Indicates this project as a key project.
  • Task Level
    Displays the level of the task.
  • Percent Complete
    Displays the percentage of completion for the project.
  • Charge Code
    Displays charge codes, which can represent any breakdown of work that is associated with an investment.
    Detail Object:
     Internal Charge Code ID
  • Category
    Displays the classification of the investment.
Financial Information Class
You can use the objects within the Financial Information section to query the financial information of an investment, including its initial investment and its capital cost.
You can use the following attributes to query financial information:
  • Initial Investment
    Displays the calculated initial cost investment of an investment.
  • Calculate NPV Data (Yes/No)
  • Indicates if the Net-Present Value (NPV) date followed the investment date.
  • Planned Equals Budget
    Displays when the planned cost for the investment equals the planned benefit.
  • System's Total Cost of Capital
    Displays the annual finance rate that is used to calculate the total cost of capital.
  • Investment Total Cost of Capital
    Displays the annual finance rate that is used to calculate the total cost of capital of an investment.
  • System's Reinvestment Rate
    Displays the annual reinvestment rate that is used to calculate the total cost of capital.
  • Investment Reinvestment Rate
    Displays the annual reinvestment rate that is used to calculate the total cost of capital of an investment.
  • Planned Cost Start
    Displays the planned cost start date of an investment.
  • Planned Cost Finish
    Displays the planned cost finish date of an investment.
  • Planned Cost Total
    Displays the planned cost totals of an investment.
  • Planned Benefit Start
    Displays the date when the planned benefits of the investment started.
  • Planned Benefit Finish
    Displays the date when the planned benefits of the investment completed.
  • Planned Benefit Total
    Displays the planned benefit totals of this investment.
  • Planned NPV
    Displays the planned NPV (Net Present Value) of the investment.
  • Planned ROI
    Displays the planned ROI (Return on Investment) of this investment.
  • Planned Breakeven
    Displays the date and amount to indicate the period and value at which the project becomes profitable.
  • Planned IRR
    Displays the planned internal rate of return for the investment.
  • Planned MIRR
    Displays the planned modified internal rate of return (MIRR) for the investment.
  • Planned Payback Period
    Displays the date of the investment planned payback period.
  • Budget Cost Start
    Displays the budgeted cost start date of an investment.
  • Budget Cost Finish
    Displays the budgeted cost finish date of an investment.
  • Budget Cost Total
    Displays the budgeted cost totals of an investment.
  • Budget Benefit Start
    Displays the budgeted benefit start date of an investment.
  • Budget Benefit Finish
    Displays the budgeted benefit finish date of an investment.
  • Budget Benefit Total
    Displays the budgeted benefit totals of an investment.
  • Budget NPV
    Displays the budgeted NPV (Net Present Value) of this investment.
  • Budget ROI
    Displays the budgeted ROI (Return on Investment) of this investment.
  • Budget Breakeven
    Displays the date when the investment budgeted cost equals the budgeted benefit.
  • Budget IRR
    Displays the budgeted internal rate of return for the investment.
  • Budget MIRR
    Displays the budgeted modified internal rate of return for this investment.
  • Budget Payback Period
    Displays the date of the investment budgeted payback period.
Financial Plan Class
Cost Plan Class
You can use the following attributes to query cost plans:
  • Plan Name
    Displays the name of the plan.
  • Plan ID
  • Displays the unique identification of the plan.
  • Plan Revision
    Displays the revision of the plan.
  • Description
    Displays information about the cost plan.
  • Benefit
    Displays the benefit of the cost plan.
  • Period Type
    Displays the period type of the plan.
    Values:
     Monthly, Quarterly, and Annually
    Detail Object:
     Internal Period Type Code
  • Plan Start Period
    Displays the start date of the plan.
    Detail Objects:
     Internal Plan Start Period ID and Plan Start Date
  • Plan End Period
    Displays the end date of the plan.
    Detail Objects:
     Internal Plan End Period ID and Plan End Date
  • Cost Plan Type Code
    Displays the cost plan type code of the cost plan.
  • Status
    Displays the status when a cost plan or benefit plan is approved.
    Detail Object:
     Internal Status Code
  • Is Plan Of Record (Yes/No)
    Indicates if the cost plan was derived from a plan of record.
  • Last Updated Date
    Displays the date when this item was last updated and saved.
  • Last Updated By
    Displays the name of the resource who last updated and saved this item.
    Detail Object:
     Internal Last Updated By ID
  • Cost Plan Type
    Displays the cost plan type filter.
Cost Plan Details Class
You can use the following attributes to query cost plan details:
  • Charge Code
    Displays charge codes, which can represent any breakdown of work that is associated with an investment.
    Detail Object
    : Internal Charge Code ID
  • Cost Type
    Displays the cost type (capital cost or operating cost) for the line item detail.
    Detail Object
    : Internal Cost Type ID
  • GL Account Number
    Displays the general ledger (GL) account number.
    Detail Objects:
     Internal GL Account Number ID, Entity, Account Description, Main Account ID, Sub Account ID, Account Class, Account Type, and Overhead (Yes/No)
  • Resource Role
    Displays the name of a resource or role.
    Detail Object:
     Internal Resource Role ID
  • Department Name
    Displays the department name.
    Detail Object:
     Internal Department ID
  • Resource Class
    Displays the class of the resource.
    Detail Object:
     Internal Resource Class ID
  • Resource Name
    Displays the full name of the resource.
    Detail Object:
     Internal Resource ID
  • Location
    Displays where the investment work is being performed.
    Detail Object:
     Internal Location ID
  • Input Type Code
    Displays the input type code for the cost plan.
    Detail Object:
     Internal Input Type Code ID
  • Transaction Class
    Displays the transaction class for the cost plan.
    Detail Object:
     Internal Transaction Class ID
  • User Value 1
    Displays the first user value for the plan.
    Detail Object:
     Internal User Value 1 ID
  • User Value 2
    Displays the second user value for the plan.
    Detail Object:
     Internal User Value 2 ID
  • Fiscal Period
    Displays the fiscal period for the plan.
    Detail Object:
     Internal Fiscal Period ID
  • Percentage
    Displays the value of the plan by a percentage.
Cost Plan Measures Class
You can use the following attributes to query cost plan measures:
  • Units
    Displays the aggregate number of units of a cost plan.
  • Cost
  • Displays the aggregate cost of a cost plan.
Benefit Plan Class
A benefit plan allows you to calculate ROI or NPV on an investment or service when associating it with a cost plan. A benefit plan can be associated with an unlimited number of cost plans.
You can use the following attributes to query benefit plans:
  • Plan Name
    Displays the name of the plan.
  • Plan ID
  • Displays the unique identification of the plan.
  • Plan Revision
    Displays the revision of the plan.
  • Description
    Displays the description of the plan.
  • Period Type
    Displays the period type of the plan.
    Values:
     Monthly, Quarterly, and Annually
    Detail Object:
     Internal Period Type Code
  • Plan Start Period
    Displays the start date of the plan.
    Detail Objects:
     Internal Plan Start Period ID and Plan Start Date
  • Plan End Period
    Displays the end date of the plan.
    Detail Objects:
     Internal Plan End Period ID and Plan End Date
  • Benefit Plan Type Code
    Displays the benefit plan type code for the plan.
  • Status
    Displays the status when a cost plan or benefit plan is approved.
    Detail Object:
     Internal Status Code
  • Last Updated Date
    Displays the date when this item was last updated and saved.
  • Last Updated By
    Displays the name of the resource who last updated and saved this item.
    Detail Object:
     Internal Last Updated By ID
  • Benefit Plan Type
    Displays the benefit plan type filter.
Benefit Plan Details Class
You can use the following attributes to query benefit plan details:
  • Detail
    Displays the details of the benefit plan.
  • Fiscal Period
    Displays the fiscal period of the benefit plan.
    Detail Object:
     Internal Fiscal Period ID
  • Percentage
    Displays the value of the benefit plan by a percentage.
Benefit Plan Measures Class
You can use the following attributes to query benefit plan measures:
  • Benefit
    Displays the aggregate benefit of a benefit plan.
  • Actual Benefit
  • Displays the actual benefit of a benefit plan.
Budget Plan Class
A budget plan is created to help track the budget of an existing investment. The structure of a budget plan is the same as a cost plan.
You can use the following attributes to query budget plans:
  • Plan Name
    Displays the name of the plan.
  • Plan ID
    Displays the unique identification of the plan.
  • Plan Revision
    Displays the revision of the plan.
  • Description
    Displays a description of the plan.
  • Period Type
    Displays the period type of the plan.
    Values:
     Monthly, Quarterly, and Annually
    Detail Object:
     Internal Period Type Code
  • Plan Start Period
    Displays the start date of the plan.
    Detail Objects:
     Internal Plan Start Period ID and Plan Start Date
  • Plan End Period
    Displays the end date of the plan.
    Detail Objects:
     Internal Plan End Period ID and Plan End Date
  • Budget Plan Type Code
    Displays the budget plan type code for the budget plan.
  • Status
    Displays the status when a cost plan or benefit plan is approved.
    Detail Object:
     Internal Status Code
  • Is Plan Of Record (Yes/No)
    Indicates if the cost plan was derived from a plan of record.
  • Last Updated Date
    Displays the date when this item was last updated and saved.
  • Last Updated By
    Displays the name of the resource who last updated and saved this item.
    Detail Object:
     Internal Last Updated By ID
  • Budget Plan Type
    Displays the budget plan type filter.
Budget Plan Details Class
You can use the following attributes to query budget plan details:
  • Charge Code
    Displays charge codes, which can represent any breakdown of work that is associated with an investment.
    Detail Object
    : Internal Charge Code ID
  • Cost Type
    Displays the cost type (capital cost or operating cost) for the line item detail.
    Detail Object
    : Internal Cost Type ID
  • GL Account Number
    Displays the general ledger (GL) account number.
    Detail Objects:
     Internal GL Account Number ID, Entity, Account Description, Main Account ID, Sub Account ID, Account Class, Account Type, and Overhead (Yes/No)
  • Resource Role
    Displays the role of the resource.
    Detail Object:
     Internal Resource Role ID
  • Department Name
    Displays the name of the department. 
    Detail Object:
     Internal Department ID
  • Resource Class
    Displays the unique class ID for the resource.
    Detail Object:
     Internal Resource Class ID
  • Resource Name
    Displays the full name of the resource.
    Detail Object:
     Internal Resource ID
  • Location
    Displays where work for the investment is being performed.
    Detail Object:
     Internal Location ID
  • Input Type Code
    Displays the Input Type Code for the resource.
    Detail Object:
     Internal Input Type Code ID
  • Transaction Class
    Displays the user-define value that groups transaction types.
    Detail Object:
     Internal Transaction Class ID
  • User Value 1
    Displays the first user value for the plan.
    Detail Object:
     Internal User Value 1 ID
  • User Value 2
    Displays the second user value for the plan.
    Detail Object:
     Internal User Value 2 ID
  • Fiscal Period
    Displays the fiscal period for the plan.
    Detail Object:
     Internal Fiscal Period ID
  • Percentage
    Displays the value of the plan by a percentage.
Budget Plan Measures Class
You can use the following attributes to query the Budget Plan Measures:
  • Units
    Displays the aggregate number of units of a budgeted plan.
  • Cost
  • Displays the aggregate cost of a budgeted plan.
OBS Class (Investment Financials Universe)
You can use the following attributes to query OBS:
  • OBS Path 
    Displays the OBS path.
    Detail Object:
     Internal OBS Unit ID.
  • OBS Type Name 
  • Displays the model for the OBS. For example, a geographical office location for a company, organizational chart, project types, and resource pool.
  • Level 1 through Level 10 Name 
    Displays the structure of the OBS hierarchy.
    Example:
     An OBS type based on organization chart could have "Company" as level 1, "Business Unit" as level 2, and "Department" as level 3.
  • Investment OBS Filter
    Displays the filter that is used by OBS.
Report Labels Class (Investment Financials Universe)
Use the following attributes to query report labels:
  • Label Code 
    Displays the label code that is used for the report label.
    Detail Object:
     Id.
  • Language Code
  • Displays the language code that is used for the report label.
  • Translated String
    Displays the translated string that is used for the report label.
  • Description
    Displays a description of the report label.