Appendix: Standard Project Datasets
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 |
|---|---|
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:
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 |
|---|---|
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:
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 |
|---|---|
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 |
|---|---|
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 |
|---|---|
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 |
|---|---|
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 |
|---|---|
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 |
|---|---|
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 |
|---|---|
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 |
|---|---|
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 |
|---|---|
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 |
|---|---|
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 |
|---|---|
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 |
|---|---|
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 |
|---|---|
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 |
|---|---|
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 |
|---|---|
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 |
|---|---|
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 |
|---|---|
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 |
|---|---|
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 |
|---|---|
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 |
|---|---|
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 |
|---|---|
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 |
|---|---|
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).