Reporting Columns - Projects Subject
The Projects subject in reporting contains data on project assignments, metric values, project details, team members, matrices, and other project information.
Project Access Group Information
| Column Name |
Data Type |
| Access Group Name |
String |
| Parent Access Group Name |
String |
| System Access Group ID |
ID |
Project Activities
| Column Name |
Data Type |
| Project Activity Name |
String |
| Project Activity Owner Name |
String |
| Project Activity Owner Changed By |
String |
| Project Activity Owner Changed Date |
Date |
| Project Activity Start Date |
Date |
| Project Activity Start Date Type |
List |
| Project Activity Start Date Offset |
Number |
| Project Activity Deadline |
Date |
| Project Activity Deadline Type |
List |
| Project Activity Deadline Offset |
Number |
| Project Activity Plan Date |
Date |
| Project Activity Function |
String |
| Project Activity Functional Area |
String |
| Project Activity Functional System Name |
String |
| Project Activity Last Published Date |
Date |
| Project Activity Status |
List |
| Project Activity Status Notes |
String |
| Project Activity Status Changed By |
String |
| Project Activity Status Change Date |
Date |
| Project Activity Published |
Boolean |
| Project Activity Order |
Number |
| Project Activity Is Collaborative |
Boolean |
| Project Activity Predecessor Name |
String |
| Project Activity Predecessor Type |
String |
| Project Activity Predecessor Stage Name |
String |
| Project Activity <extended field name> |
Varied, based on field type |
| System Project Activity ID |
ID |
| System Project Activity Owner ID |
ID |
| System Project Activity Status Code |
ID |
Project Deliverables
| Column Name |
Data Type |
| Project Deliverable Name |
String |
| Project Deliverable Owner Name |
String |
| Project Deliverable Owner Changed By |
String |
| Project Deliverable Owner Changed Date |
String |
| Project Deliverable Start Date |
Date |
| Project Deliverable Start Date Type |
List |
| Project Deliverable Start Date Offset |
Number |
| Project Deliverable Deadline |
Date |
| Project Deliverable Deadline Type |
List |
| Project Deliverable Deadline Offset |
Number |
| Project Deliverable Plan Date |
Date |
| Project Deliverable Function |
String |
| Project Deliverable Functional Area |
String |
| Project Deliverable Last Published Date |
Date |
| Project Deliverable Status |
List |
| Project Deliverable Status Notes |
String |
| Project Deliverable Status Changed By |
String |
| Project Deliverable Status Change Date |
Date |
| Project Deliverable Published |
Boolean |
| Project Deliverable Order |
Number |
| Project Deliverable Is Collaborative |
Boolean |
| Project Deliverable Predecessor Name |
String |
| Project Deliverable Predecessor Type |
String |
| Project Deliverable Predecessor Stage Name |
String |
| Project Deliverable <extended field name> |
Varied, based on field type |
| System Project Deliverable ID |
ID |
| System Project Deliverable Owner ID |
ID |
| System Deliverable Status Code |
ID |
Project Details
| Column Name |
Data Type |
| Project Name |
String |
| Project Thumbnail |
Image |
| Project Description |
String |
| Project Currency Code |
List |
| Project Currency Name |
List |
| Project Currency Conversion Factor |
Number |
| Project ID |
ID |
| Project Process Type |
List |
| Project Class |
List |
| Project Model Name |
String |
| Project Creation Date |
Date |
| Project Created By |
String |
| Project Manager Name |
String |
| Project Manager Can Manage Team |
Boolean |
| Project Start Date |
Date |
| Project End Date |
Date |
| Project Duration |
Number |
| Project Last Gate Decision |
List |
| Project Current Stage Name |
String |
| Project Is In Trouble |
Boolean |
| Project Most Recent Status Report Date |
Date |
| Project Most Recent Status Report Submitter Name |
String |
| Project Most Recent Status Report Text |
String |
| Project Excluded from Line-ups |
Boolean |
| Project Closed |
Boolean |
| Project Closed Date |
Date |
| Project Enforce Project Security |
Boolean |
| Idea Submitter Name |
String |
| Migrated-from Project Name |
String |
| System Project ID |
ID |
| System Project Rank |
ID |
| System Project Manager ID |
ID |
| System Project Current Phase ID |
ID |
| System Project Last Gate Decision Code |
ID |
| System Project Model ID |
ID |
| System Migrated-from Project ID |
ID |
Project Extended Project Data
| Column Name |
Data Type |
| Extended Project Data 1...10* |
String |
Project Gate Documents
| Column Name |
Data Type |
| Project Gate Document Name |
String |
| Project Gate Document Published |
Boolean |
| Project Gate Document Order |
Number |
Project Gatekeepers
| Column Name |
Data Type |
| Project Gatekeeper Name |
String |
| Project Gatekeeper Function (String) |
String |
| Project Gatekeeper Function (List) |
List |
| Project Gatekeeper Vote |
String |
| Project Gatekeeper Vote Comments |
String |
| System Project Gatekeeper ID |
ID |
Project History
| Column Name |
Data Type |
| Event Date |
Date |
| Event Type |
List |
| Event Reason |
List |
| Event Reason Code |
List |
| Event Reason Name |
List |
| Event User Name |
String |
| Event User Login |
String |
| Event Stage Number |
Number |
| Event Stage Name |
String |
| Event Gate Number |
Number |
| Event Gate Name |
String |
| Event Text |
String |
| Event Function Name |
List |
| Change-from Date |
Date |
| Change-to Date |
Date |
| Change-from Decision |
List |
| Change-to Decision |
List |
| Change-from Project Name |
String |
| Change-to Project Name |
String |
| Change-from Name |
String |
| Change-to Name |
String |
| Change-from Currency Code |
List |
| Change-to Currency Code |
List |
| Change-to In Trouble Flag |
Boolean |
| System Event User ID |
ID |
| System Change-from User ID |
ID |
| System Change-to User ID |
ID |
Project Link Rules
| Column Name |
Data Type |
| Rule Name |
String |
| Rule Link Type |
List |
| Rule Model |
List |
| Rule Condition Metric |
List |
| Rule Condition Metric Value |
String |
| Rule Condition Source Metric |
List |
| System Link Type ID |
ID |
| System Model ID |
ID |
| System Rule Metric ID |
ID |
| System Rule Source Metric ID |
ID |
Project Related Projects
| Column Name |
Data Type |
| Related Project System Project ID |
ID |
| Related Project System Link Type ID |
ID |
| Related Project Link Type Name |
List |
| Related Project In Conflict |
Boolean |
| Related Project Conflict Created On* |
Date |
| Related Project Conflict Created By* |
String |
| Related Project Dependency Left Date Type Name |
String |
| Related Project Dependency Left Date Name |
String |
| Related Project Dependency Right Date Type Name |
String |
| Related Project Dependency Right Date Name |
String |
| Related Project Dependency Left Date |
Date |
| Related Project Dependency Right Date |
Date |
Project Resource Plans
| Column Name |
Data Type |
| Project Resource Pool Name |
String |
| Project Resource Name |
String |
| Project Period Start Date |
Date |
| Project Period End Date |
Date |
| Project Resource Demand Type |
List |
| Project Resource Demand Curve |
List |
| Project Resource Demand Multiplier |
Number |
| Project Resource Demand Value |
Number |
| Project Resource Demand Is Active |
Boolean |
| System Project Resource Pool ID |
ID |
| System Project Resource ID |
ID |
| System Project Resource Period ID |
ID |
| System Project Resource Demand Type ID |
ID |
| Resource Plan Effective Time Period ID |
ID |
| Resource Plan Effective Time Period |
String |
Project Security List - <security list name>
There can be up to five security lists.
| Column Name |
Data Type |
| <list name> Selected Value Name |
String |
| <list name> Selected Level Name |
List |
| <list name> <level 1 name>
|
List (from 1 to 10 levels) |
Project Stages and Gates
| Column Name |
Data Type |
Additional Notes
|
| Project Stage Exists |
Boolean |
|
| Project Stage Name |
String |
|
| Project Stage Relative Position |
List |
For each stage in the report, shows the relationship to the current stage by returning an item from the list: Past, Previous, Current, Next, Future. |
| Project Stage Duration |
Number |
Days from the last gate date to the next gate date. |
| Project Stage Locked |
Boolean |
|
| Project Gate Exists |
Boolean |
|
| Project Gate Name |
String |
|
| Project Gate Owner Name |
String |
|
| Project Gate Date |
Date |
|
| Project Gate Date Metric Name |
String |
Gate date metric name will only display in the report if the gate is calculated by its associated metric. |
| Project Gate Decision |
List |
|
| Project Gate Meeting Place |
String |
|
| Project Gate Notes |
String |
|
| Project Gate Conditions |
String |
|
| Project Gate Plan Date |
Date |
|
| Project Gate Relative Position |
List |
For each gate in the report, shows the relationship to the next gate by returning an item from the list: Past, Previous, Next, Future. |
| System Project Phase ID |
ID |
|
| System Project Gate Owner ID |
ID |
|
| System Gate Decision Code |
ID |
|
Project Team Members
| Column Name |
Data Type |
| Project Team Member Name |
String |
| Project Team Member Function (String) |
String |
| Project Team Member Function (List) |
List |
| System Team Member ID |
ID |
| Project Team Member Is Primary |
Boolean |
MS Project Tasks
| Column Name |
Data Type |
| MS Project Task Name |
String |
| MS Project Task Owner Name |
String |
| MS Project Task Description |
String |
| MS Project Task Deadline |
Date |
| MS Project Task Planned Start Date |
Date |
| MS Project Task Planned Finish Date |
Date |
| MS Project Task Status |
List |
| MS Project Task Status Notes |
String |
| MS Project Task Status Changed By |
String |
| MS Project Task Change Date |
Date |
| MS Project Task Row Number |
Number |
| System MS Project Task ID |
ID |
| System MS Project Task Owner ID |
ID |
| System MS Project Task Status Code |
ID |
Metric Change History
| Column Name |
Data Type |
| Metric Name |
String |
| Metric System Name |
String |
| Metric Category |
String |
| Updated By |
String |
| Updated On |
Date |
| Update Source |
String |
| Value Before Update |
Varied, based on metric type |
| Value After Update |
Varied, based on metric type |
| System Metric ID |
ID |
| System Updated By ID |
ID |
| System Updated Source ID |
ID |
Trended Metric History
| Column Name |
Data Type |
| Change Source Name |
String |
| Change Event Date |
Date |
| Stage ID |
ID |
| Trended - <Metric Name>* |
String |
Matrix - <matrix name>
Each Matrix column set contains the metrics columns that are in the matrix. More than one matrix may be listed. Matrices are specific to each company; therefore, there is not a standard set of column names.
<metric category names>
Metrics that are available to the Table Wizard are listed under subheadings that reflect the metric categories. Metrics are specific to each company; therefore, there is not a standard set of column names.