This article contains:

1. Overview

Fields available through each dataset are indicated below. These will usually reflect the labels used within your cammsproject application. However, please note that your Insights Administrator can,

change the names of datasets and fields for use within the Insights application.
show/hide specific fields/datasets based on your user role.

This section lists all datasets applicable for cammsproject. Use the links below to jump directly to the section you are looking for,

Project datasets.
Business Requirement datasets.

Project_ProjectRegister_STND

This dataset will include all fields activated for the Project Register page in your cammsproject application. It includes several fixed fields for additional usability – see below.

Fixed fields:

Field name in Insights	Notes

Field name in Insights	Notes
PROJECTID	Unique identifier for Projects – not usually displayed in reports.
Project Name	Name of the project.
Project Workflow	Workflow name.
Project Current Actual % Complete	Project Current Actual % Complete.
Project Current Target % Complete	Project Current Target % Complete.
Project Current Budget Performance Traffic Light	Project Current Budget Performance Traffic Light.
Project Current Budget Performance Value	Project Current Budget Performance Value.
Project Current Comment	Project Current Comment.
Project Current Progress Performance Traffic Light	Project Current Progress Performance Traffic Light.
Project Current Progress Performance Value	Project Current Progress Performance Value.
Project Current Status	Project Current Status.
Current Year Expenditure Budget
Current Year Income Budget
Current Year Net Budget
Total Expenditure
Total Income
Total Net Project Budget
Project Baseline Start Date
Project Baseline End Date
Project Start Date
Project End Date

Other fields are determined from those made visible via the cammsproject Settings Configuration > Project Register View as shown below:

Figure 1.1

Project_ProjectDetails_STND

This dataset will show all fields activated for all instances of the first tab of the project details object across all your workflows. It includes several fixed fields for additional usability – see below.

Fixed fields:

Field name in Insights	Notes

Field name in Insights	Notes
PROJECTID	Unique identifier for Projects – not usually displayed in reports.
Project Name	Name of the project.
Project Workflow	Workflow name.
LINKEDACTIONID	Used to get information of the action linked to this project from Planning_ActionDetails_STND.
Linked Action Name	Linked Action Name.
LINKEDTASKID	Used to get information of the task linked to this project from Planning_TaskDetails_STND.
Linked Task Name	Linked Task Name.
Start Date	Start Date.
End Date	End Date.
SERVICEPROFILEID	Used to get information of the primary service linked to this project from Planning_OrgHierarchy_STND.
Primary Service Profile
STRATEGYID	Used to get information of the primary strategy linked to this project from Planning_PlanningHierarchy_STND.
Primary Strategy
PARENTPROJECTID	Used to get information of the parent project this project belongs to from Project_ProjectDetails_STND.
Parent Project Name	Parent Project Name.

Other fields are determined from those made visible via the respective cammsproject Project Workflow's Project Detail object configuration as shown below:

Figure 1.2

Project_QuickUpdate_STND

This dataset will include all fields activated for the Quick Update page in your cammsproject application. These fields are configured from your Project Details object. It includes several fixed fields for additional usability – see below.

Fixed fields:

Field name in Insights	Notes

Field name in Insights	Notes
PROJECTID	Unique identifier for Projects – not usually displayed in reports.
Project Name	Name of the project.
Project Workflow	Workflow name.
LINKEDACTIONID	Used to get information of the action linked to this project from Planning_ActionDetails_STND.
Linked Action Name	Linked Action Name.
LINKEDTASKID	Used to get information of the task linked to this project from Planning_TaskDetails_STND.
Linked Task Name	Linked Task Name.
Start Date	Start Date.
End Date	End Date.
Primary Service Profile
SERVICEPROFILEID	Used to get information of the service linked to this project from Planning_OrgHierarchy_STND.
Primary Strategy
PARENTPROJECTID	Used to get information of the parent project this project belongs to from Project_ProjectDetails_STND.
Parent Project Name	Parent Project Name.
Project Last Change Date	Project Last Change Date.
Project Last Change Person	Project Last Change Person.

Other fields are determined from those made visible via the cammsproject Project Workflow's Project Detail object configuration as shown below:

Project_SignOff_STND

This dataset provides all fields relevant to sign offs.

Field name in Insights	Notes

Field name in Insights	Notes
PROJECTID	Unique identifier for Projects – not usually displayed in reports.
Project Name	Name of the project.
Project Workflow	Name of the workflow.
Project Phase	Name of the phase.
Object Title	Name of the object sign off is attached to if relevant.
SIGNOFFID	Unique identifier for each sign off – not usually displayed in reports.
Sign Off Person	Person doing the sign off action.
Approval Action	The type of action e.g. apply for approval.
Approval Status	Status of the approval e.g. Pending Approval.
Approved Date	Date of the sign off action.
General Comment	General Comment.
Project Position	Project Position.
Sign Off Comment	Sign Off Comment.

Project_PreliminaryBudget_STND

This dataset includes all standard (non-custom) fields enabled for the Preliminary Budget object across all workflows and phases used within your organisation.

Field name in Insights	Notes

Field name in Insights	Notes
PROJECTID	Unique identifier for Projects – not usually displayed in reports.
Project Workflow	Name of the workflow.
Project Phase	Name of the phase.
Project Name	Name of the project.
Account No	Account No.
Budget Line	Budget Line.
Type	Budget Type e.g. Income, Expenditure, Net.
Type Order	Used to sort types in Income, Expenditure, Net order.
Budget Value	Numerical value of budget.
Comment	Comment.
Custom date field	Custom date field.
Budget Type	Budget Type.
Budget Year	Budget Year.

Project_PreliminaryBudgetCustomFields_STND

This dataset includes all custom (non-standard) fields activated for the Preliminary Budget object across all workflows and phases used within your organisation.

(to be updated).

Project_LessonsLearned_STND

This dataset will include all fields activated for the Lessons Learned object in your cammsproject application. It includes several fixed fields for additional usability – see below.

Fixed fields:

Field name in Insights	Notes

Field name in Insights	Notes
PROJECTID	Unique identifier for Projects – not usually displayed in reports.
Project Name	Name of the project.
Project Workflow	Name of the workflow.
Project Phase	Name of the phase.
LESSONLEARNEDID	Unique identifier for each lesson learned – not usually displayed in reports.
Category	Category.
Impact	Impact.
Lesson	Lesson.
Lesson ID	Unique identifier for each lesson – not usually displayed in report.
Recommended Action	Recommended Action.

Other fields are determined from those made visible for the object via the Settings Configuration > Lessons Learned Page as shown below:

Project_LessonsLearnedRegister

This dataset will include all fields activated for the Lessons Learned Register object in your cammsproject application. It includes several fixed fields for additional usability – see below.

Fixed fields:

Field name in Insights	Notes

Field name in Insights	Notes
Category	Unique identifier for Projects – not usually displayed in reports.
Impact	Impact.
Lesson	Lesson.
Lesson ID	Unique identifier for Lessons – not usually displayed in report.
LESSONLEARNID	Unique identifier for each lesson – not usually displayed in report.
Recommended Action	Recommended Action.

Other fields are determined from those made visible for the object via the Settings Configuration > Lessons Learned Page as shown below:

Project_TaskDetails_STND

This dataset includes all fields enabled for the Task Details object across all workflows and phases used within your organisation. It includes the fixed filter parameters 'Project Workflow' and ‘Project Phase’ which enables you to filter tasks from projects matching a specific Workflow and Phase.

Important: Please ensure you select a single Workflow and a single Phase from the same Workflow to ensure this dataset works accurately.

Field name in Insights	Notes

Field name in Insights	Notes
PROJECTID	Unique identifier for Projects – not usually displayed in reports.
Project Title	Name of project.
Project Workflow	Name of the workflow.
Project Phase	Name of the phase.
PARENTPROJECTTASKID	Unique identifier for parent tasks – not usually displayed in reports.
Parent Task Title	Name of parent task.
PROJECTTASKID	Unique identifier for tasks – not usually displayed in reports.
Last Changed Date	Last Changed Date.
Last Changed By	Last Changed By.
Baseline End	Baseline End.
Baseline Start	Baseline Start.
Comment	Comment.
Completion Date	Completion Date.
Duration	Duration.
End Date	End Date.
Predecessors	Predecessors.
Progress %	Progress Percentage.
ProgressPerformanceTrafficLight	Progress Performance Traffic Light.
Responsible Person	Responsible Person.
Revised End Date	Revised End Date.
Revised Start Date	Revised Start Date.
Start Date	Start Date.
Status	Status.
Task	Task.
Task Cost	Task Cost.
Worked	Worked.

Remaining fields are determined from those made visible via the Project Workflow's Task Planning object configuration as shown below:

Project_AssessmentModel_STND

This dataset includes all summary level fields relevant for the Assessment Model object across all workflows and phases used within your organisation. For criteria level scoring refer Project_AssessmentModelExtended_STND.

Field in Insights	Notes

Field in Insights	Notes
PROJECTID	Unique identifier for Projects – not usually displayed in reports.
Project Title	Name of project.
Project WorkFlow	Project WorkFlow.
Project Phase	Project Phase.
Template Name Final Score	Template Name Final Score.
Date Finalised	Date Finalised.
Date	Date.
Status	Status.

Final Score	Final Score.
Finalise	Finalise.

Project_AssessmentModelExtended_STND

This dataset provides criteria level scoring and commentary with regards to project assessments.

(to be updated).

Project_ImplementationBudgetByYear_STND

This dataset includes all fields activated for all instances of the Implementation Budget object across all your workflows. It includes several fixed fields for additional usability – see below.

Note: This dataset produces yearly data only. For month level data refer Project_ImplementationBudgetByMonth_STND

Fixed fields:

Field name in Insights	Notes

Field name in Insights	Notes
PROJECTID	Unique identifier for Projects – not usually displayed in reports.
Project Title	Name of project.
Project Workflow	Name of the workflow.
Project Phase	Name of the phase.
Type Sort	Allows sorting of the Budget Type by Income, Expenditure, Net order.
Actual YTD	Actual Year to Date.
ActualYTD + Committed	Actual Year to Date + Committed.
Annual Budget	Annual Budget.
Budget Type	Budget Type.
Budget YTD	Budget Year to Date.
Committed YTD	Committed Year to Date.
Forecast	Forecast.
Opening Balance	Opening Balance.
Original Budget	Original Budget.
Performance	Performance.
Project Name	Project Name.
Reporting Year	Reporting Year.
Revised Budget	Revised Budget.
Sort Date	Sort Date.
Type Order	Type Order.
Variance	Variance.
Variance%	Variance Percentage.

Project_ImplementationBudgetByMonth_STND

This dataset includes all fields activated for all instances of the Implementation Budget object across all your workflows. It includes several fixed fields for additional usability – see below.

Note: This dataset produces monthly data only. For year level data refer Project_ImplementationBudgetByYear_STND

Fixed fields:

Field name in Insights	Notes

Field name in Insights	Notes
PROJECTID	Unique identifier for Projects – not usually displayed in reports.
Project Workflow	Name of the workflow.
Project Phase	Name of the phase.
Project Title	Name of project.
Reporting Year	Reporting year e.g. 18/19.
Account Period	Account Period e.g. P01, P02 etc.
Date Sort	Allows sorting of the account periods.
Type Sort	Allows sorting of the above by Income, Expenditure, Net order.
Actual	Actual.
Budget	Budget.
Budget Type	Budget Type.
Project Name	Project Name.
Sort Date	Sort Date.
Type Order	Type Order.
Variance	Variance.

Project_ImplementationBudgetExtended_STND

This dataset will include all fields relevant for the Implementation Budget object. It produces account level data.

Field name in Insights	Notes

Field name in Insights	Notes
PROJECTID	Unique identifier for Projects – not usually displayed in reports.
Reporting Year	Reporting year e.g. 18/19.
Account Number	Account Number.
Account Description	Account Description.
Type	Expenditure/Income/Net.
Type Sort	Allows sorting of the above by Income, Expenditure, Net order.
Variance %	Variance %.
Variance	Variance.
Performance	Performance.
Budget YTD	Budget YTD.
Actual YTD	Actual YTD.
Actual YTD Committed	Actual YTD Committed.
Committed YTD	Committed YTD.
Original Budget	Original Budget.
Annual Budget	Annual Budget.
Revised Budget	Revised Budget.
Opening Balance	Opening Balance.
Forecast	Forecast.
Account	Account.
Budget Type	Budget Type.
Project Name	Project Name.
Project Phase	Project Phase.
Project Workflow	Project Workflow.
Sort Date	Sort Date.
Type Order	Type Order.

Project_CustomObject_STND

Please note that this dataset will show all fields activated for all instances of the custom object (excluding custom tables) across all your workflows and phases. It includes fixed fields ‘Project Workflow’, ‘Project Phase’ and ‘Object Name’ which enables you to filter the data as needed.

Project_CustomTable_STND

Please note that this dataset will show all fields activated for all instances of custom tables across all your workflows and phases. It includes fixed fields ‘Project Workflow’, ‘Project Phase’ and ‘“Table Name’ which enables you to filter the data as needed.

Project_ImageGallery_STND

Field name in Insights	Notes

Field name in Insights	Notes
PROJECTID	Unique identifier for Projects – not usually displayed in reports.
Project Name	Name of the project.
Project Workflow	Name of the workflow.
PROJECTIMAGEID	Unique identifier for each task – not usually displayed in reports.
Title	Name of associated image.
Description	Description.
Alternate Text	Alternate Text.
Image Default Option	Image Default Option.
Image	Thumbnail of image.

Project_BoardAndTeam_STND

Field name in Insights	Notes

Field name in Insights	Notes
PROJECTID	Unique identifier for Projects – not usually displayed in reports.
Project Name	Name of the project.
Project Workflow	Name of the workflow.
Project Phase	Name of the phase.
PROJECTBOARDMEMBERID	Unique identifier for each board member – not usually displayed in reports.
Board Member Name	Name of linked Staff member.
Position	Position of staff member.
Description	Description.
Number of Man Days	Number of Man Days.
Charge Out Rate	Charge Out Rate.
Implementation Role	Yes or no.
Interplan Responsible Person	Yes or no.
Name	Name.

Project_ResourceAllocation_STND

This dataset provides information on staff members and their time allocations for tasks/projects.

Field name in Insights	Notes

Field name in Insights	Notes
PROJECTID	Unique identifier for Projects – not usually displayed in reports.
Project Name	Name of the project.
PROJECTTASKID	Unique identifier for each task – not usually displayed in reports.
Task Name	Name of associated task.
PROJECTBOARDMEMBERID	Unique identifier for each board member – not usually displayed in reports.
Board Member Name	Name of linked Staff member.
Allocation Date	Allocated date.
Allocation Hours	Allocated hours.

Project_ProjectLinks_STND

This dataset will show all elements which can be linked to a Project.

Field name in Insights	Notes

Field name in Insights	Notes
PROJECTID	Unique identifier for Projects – not usually displayed in reports.
CHILDPROJECTID	Used to get information of the Child Projects belonging to this project from Project_ProjectRegister_STND.
REFERENCEPROJECTID	Used to get information of the Reference Projects linked to this project from Project_ProjectRegister_STND.
RISKID	Used to get information of the Risks for this project from Risk_RiskDetails_STND.
KPIID	Used to get information of the KPIs for this project from Planning_KPIDetails_STND.
PROJECTASSETID	Used to get information of the Assets for this project from Project_AssetHierarchy_STND.
STRATEGYID	Used to get information of the Primary Strategy for this project from Planning_PlanningHiearachy_STND.
SECONDARYSTRATEGYID	Used to get information of the Secondary Strategies for this project from Planning_PlanningHiearachy_STND.
AGENCYID	Used to get information of the Agency for this project from.
HIERARCHYID
HIERARCHYLEVELID
Incident Title	Incident Title.
INCIDENTID	Used to get information of the Incidents for this project from.
PROJECTRISKID
Secondary Strategy Title	Secondary Strategy Title.
Strategy Title	Strategy Title.

Project_DocumentsLinks_STND

This dataset will include all fields relevant for the Documents object across all workflows and phases used within your organisation. It includes several fixed fields for additional usability – see below.

Fixed fields:

Field name in Insights	Notes

Field name in Insights	Notes
PROJECTID	Unique identifier for Projects – not usually displayed in reports.
Project Name	Name of the project.
Project Workflow	Workflow name.
Project Phase	Phase name.
Document Title	Document Title.
Document Type	Document Type.
Document Description	Document Description.
Document Reference Number	Document Reference Number.
Document URL	Document URL.
ATTACHMENTID	Unique identifier for Attachments – not usually displayed in reports.

Project_BusinessCaseDetails_STND

This dataset will show all fields activated for all instances of the first tab of the Business Case object across all your workflows and phases. It includes several fixed fields for additional usability – see below.

Fixed fields:

Field name in Insights	Notes

Field name in Insights	Notes
PROJECTID	Unique identifier for Projects – not usually displayed in reports.
Project Name	Name of the project.
Project Workflow	Workflow name.
Project Phase	Phase name.

Remaining fields are determined from those made visible via the Project Workflow's Business Case object configuration as shown below:

Project_BusinessCaseObjectives_STND

This dataset will show all fields activated for all instances of the second tab of the Business Case object across all your workflows and phases. It includes several fixed fields for additional usability – see below.

Fixed fields:

Field name in Insights	Notes

Field name in Insights	Notes
PROJECTID	Unique identifier for Projects – not usually displayed in reports.
Project Name	Name of the project.
Project Workflow	Workflow name.
Project Phase	Phase name.

Remaining fields are determined from those made visible via the Project Workflow's Business Case object configuration as shown below:

Project_BusinessCaseOptions_STND

This dataset will show all fields activated for all instances of the third tab of the Business Case object across all your workflows. It includes several fixed fields for additional usability – see below.

Fixed fields:

Field name in Insights	Notes

Field name in Insights	Notes
PROJECTID	Unique identifier for Projects – not usually displayed in reports.
Project Name	Name of the project.
Project Workflow	Workflow name.
Project Phase	Phase name.

Remaining fields are determined from those made visible via the Project Workflow's Business Case object configuration as shown below:

Project_AdvancedScope_STND

(to be updated).

Project_ActivityLog_STND

Field name in Insights	Notes

Field name in Insights	Notes
PROJECTID	Unique identifier for Projects – not usually displayed in reports.
Project Name	Name of the project.
ACTIVITYLOGID	ACTIVITYLOGID.
Created Date	Created Date.
Description	Description.
Description Text	Description Text.
Type	Type.
Last Changed Date	Last Changed Date.
Last Changed By	Last Changed By.

Project_StakeholderAnalysis_STND

(to be updated).

Project_ActivityLog_STND

Field name in Insights	Notes

Field name in Insights	Notes
Project Name	Name of the project.
Project Phase	Project Phase.
Project Workflow	Workflow name.
PROJECTID	Unique identifier for Projects – not usually displayed in reports.
PROJECTSTAKEHOLDERID	Unique identifier for Stakeholders – not usually displayed in reports.

Project_Location_STND

(to be updated).

Project_AssetHierarchy_STND

(to be updated).

Field name in Insights	Notes

Field name in Insights	Notes
Asset Name	Name of the Asset.
ASSETID	Unique identifier for Assets – not usually displayed in report.
ASSETPARENTID	Unique identifier for Asset Parents – not usually displayed in reports.
Focus Area	Focus Area.
Process	Process.
Type	Type.

2. Business Requirement Module Datasets

Project_BusinessRequirementDetails_STND

(to be updated).

Field name in Insights	Notes

Field name in Insights	Notes
Benefits	Benefits.
BUSINESSREQUIREMENTID	Unique identifier for Business Requirements – not usually displayed in report.
Code	Code.
Current State	Current State.
Date Proposed	Date Proposed.
High Level Cost	High Level Cost.
Idea Sponsor	Idea Sponsor.
Implications	Implications.
Initiative Description	Description of the Initiative.
Outcomes	Outcomes.
Outputs	Outputs.
Prioritisation Score	Prioritisation Score.
Proposed By	Proposed By.
Resources/Procurement	Resources/Procurement.
Responsible Owner	Responsible Owner.
Risks and Assumptions	Risks and Assumptions.
Stakeholders	Stakeholders.
Status	Status.
Strategic Objective	Strategic Objective.
Title	Title.
Type	Type.

Project_BusinessRequirementLinks_STND

(to be updated).

Project_BusinessRequirementPrioritisation_STND

(to be updated).

Project_BusinessRequirementPrioritisationExtended_STND

(to be updated).

Project_BusinessRequirementSignOff_STND

(to be updated).

<< Previous section
Standard Strategy Datasets

Table of Contents

Next section >>
Standard Risk Datasets

Camms.Support Documentation

Appendix: Standard Project Datasets

1. Overview

2. Business Requirement Module Datasets