Cobra Help

Export Structures Page of the Cost Data Wizard

Use this page to select the fields that contain the work and organizational breakdown structures to be exported.

Note: Cobra work packages are aggregated by the WBS_ID_WP field. In the DS03 JSON file, the aggregation combines the period_date, WBS_ID_CA, WBS_ID_WP, EOC, EVT, and is_indirect fields. Multiple Cobra work packages associated with a single WBS_ID_WP field are aggregated accordingly.

Contents

FieldDescription
WBS

Click to display the Lookup dialog box and select the field to which the WBS is assigned.

This field is required.

OBS

Click to display the Lookup dialog box and select the field to which the OBS is assigned.

This field is required.

Work Package
Note: This field displays only if you select DOE PARS on the Project and Format page.

Click this field to display the Lookup dialog box and select a code field from the list of validated code fields associated to the Wok Package file.

This field is required.

Activities loaded as Work Packages
Note: This field displays only if you select DOE PARS on the Project and Format page.

When this checkbox is selected, Cobra exports the DS03 JSON file by replacing the WBS code assignment on the control account with that of the nearest parent element where the WBS Type is equal to CA. Specifically, the WBS_ID_CA field in the JSON file is populated with the value of its nearest parent element.

  • If the WBS code has multiple parent elements with a WBS Type equal to CA, the process log displays the following message: “WBS ‘XX’ has multiple parent codes with ‘CA’ WBS Type. The immediate/nearest parent code will be used for the WBS Code.”
  • If the WBS code has no parent element with a WBS Type equal to CA, the process log displays the following message: “WBS ‘XX’ has no parent code with ‘CA’ WBS Type. WBS ‘XX’ will be used for the WBS Code.”
Note: The selection you made in this checkbox also applies when you run the Cost Data Export process through the API and Cobra Web Service.
Cobra Control Account EVT
Note: This field displays only if you select DOE PARS on the Project and Format page.

This field is enabled only when the Activities loaded as Work Package checkbox is selected. Use this field to select a valid Cobra control account code assignment to populate the DS03 EVT field in the JSON file.

When the Activities loaded as Work Package checkbox is not selected, Cobra will populate the DS03 EVT field from the standard work package EVT.

When the EVT is set to Apportioned (EVT = "J") or Calculated Apportionment (EVT = "M"):

  • The field, EVT_J_to_WBS_ID, with a value of Many, will be added to the DS03_cost.json file.
  • The field, EVT_J_pct, with a value of 100, will be added to the DS03_cost.json file.
Parent code for multiple top level codes
Note: This field displays if you select Deltek Common Data or IPMDAR-Contract Performance Format on the Project and Format page.

The value entered in this field will be used as the single top-level element for structures that have multiple top-level elements. The default value is Top, but you can enter a different value in the field.

This field is always enabled. The value in this field applies only to structures with multiple top levels.

Use WBS/OBS combination as the Control Account ID
Note: This field displays if you select IPMDAR-Contract Performance Format on the Project and Format page.

Select this option to export data based on the WBS and OBS selected on this page, which define the control account ID. When this option is selected, control accounts with similar WBS and OBS are aggregated. When this option is not selected, Cobra exports the control account ID as defined on the Fields tab of the Project Properties dialog box.

The field values that will be exported for the combined control accounts are as follows:

  • BaselineStartDate: The earliest baseline start date is exported.
  • BaselineFinishDate: The latest baseline finish date is exported.
  • ForecastStartDate: The earliest forecast start date is exported.
  • ForecastFinishDate: The latest forecast finish date is exported.
  • ActualStartDate: The earliest actual date is exported.
  • ActualEndDate: This is exported only when all control accounts are in Completed status and the latest actual end date is exported.
  • CAM: The CAM of the first control account that the database sees when combining control accounts with the same WBS/OBS is exported.
  • CA/WP Code assignments: The values from the first control account that the database sees when combining control accounts with the same WBS/OBS are exported.
  • Progress Technique: The progress technique of the first work package that the database sees when combining control accounts with the same WBS/OBS and work package ID is exported.
Note: If you are using three key fields to define the control accounts but need to combine some of them to avoid duplicates, ensure that the combined control accounts are uniquely identified. This will prevent any duplicate entries from being exported and ensure accurate data during import.
PARS ID
Note: This field displays only if you select DOE PARS on the Project and Format page.

Use this field to specify the mapping of the PARS ID. You can either enter a custom ID or select from a validated list of project codes.

  • Select the Use custom PARS ID checkbox to enter the PARS ID value in the field.
  • Clear the Use custom PARS ID checkbox to display in the field. Click to select an assigned project code from the validated list.

How to...

Assign Control Account and Work Package Structures to a Project

Export Cost Data

Notes Tab of the Code View


Learn more about...

Cost Data Export


Parent Topic:

Cost Data Wizard