Visual Program Hierarchy Data Source
This article provides all the Fields available for each View currently available under the Visual Program Hierarchy Data Source in Upland Analytics.
The following Views are available when Visual Program Hierarchy Data Source is selected upon creating a report. Click on any of them to view the available Fields.
- Basic Details for Work
- Cost Details for Work
- Gated Work Attributes
- Owned By
- Program
- Program Details for Work
- Schedule Details for Work
- Visual Program Hierarchy
Note: This page is being updated as new information becomes available.
Basic Details for Work
| Field Name | Description | Type |
| Cancel Date | Work cancel date | |
| Core Type | Work core object type | |
| Create Date | Work creation date | |
| Created By | Work creator ID | |
| Currency | Work currency code |
|
| Last Change | Work last change date |
|
| Location | Work location |
|
| Location with Icon | Work location with image icon display and link to project |
|
| Master Project | Master project name |
|
| Master Project with Icon | Master project name and URL link to the master project |
|
| Name | Work name |
|
| Name with Object Type Icon | Work name with object type icon displayed and URL linked to project |
|
| Object Type | Work object type name |
|
| Objective | Work objective |
|
| Owner ID | Work owner ID |
|
| Parent ID | Parent work ID |
|
| Percent On Track | Percent on track |
|
| Priority | Work priority |
|
| Project ID | Work project ID (user defined ID) |
|
| Sequence | Work sequence number (sequence generated from object type settings) |
|
| Source | Work source |
|
| Status | Work status |
|
| Status Report | Last status report summary text |
|
| Status Report Days Late | Number of status report days late |
|
| Status with Icon | Work status with icon displayed |
|
| Team Status | Given a project and its team members, the longest an invite has been sent and unattended to by one of its team members, in days |
|
| Template | Work template name |
|
| Top Project | Top project name |
|
| Top Project with Icon | Top project name with URL linked to top project |
|
| Work ID | Work ID to join by. This view only returns one row per work ID |
|
| Work Type Code | Object type code (object type ID) |
|
| Context Currency | Default currency defined in context |
|
| Idea Status | Idea status (only for objects derived from idea object type) |
|
| Idea Status Comment | The comment that was included with the most recent Idea status change. | |
| Is Idea | Flag to mark if current work row is an idea, Y for true, N for false |
|
| Is Program | Flag to mark if current work row is a program |
|
Cost Details for Work
| Field Name | Description | Type |
| Actual Cost | Total Actual costs for this work_id | |
| Advanced Timesheet Enabled | Flag to mark if current row uses advanced timesheet setting or not, 1 when enabled, 0 or null if not | |
| Allow Time Entry | Flag to mark if current row has the allow_time_entry setting or not, 1 when enabled, 0 or null if not | |
| Baseline Budget | Baseline budget | |
| Estimated Cost | Total Estimated costs for this work_id |
|
| Restrict Time Entry to Assignees | Flag to mark if current row has the restrict_time_entry_to_assignees setting or not, 1 when enabled, 0 or null if not |
|
| Total Budget | Budget total |
|
| Work ID | Work ID to join by. This view only returns one row per work ID |
|
Gated Work Attributes
| Field Name | Description | Type |
| Active Gate | Gated project active gate name | |
| Active Gate Champions | Active gate champions list |
|
| Active Gate Champions Link | Active gate champions list with links to the users |
|
| Active Gate Days Late | Active gate days late |
|
| Active Gate with Icon | Active gate with icon display |
|
| Gate Approval Status | Active gate approval status |
|
| Gate Due | Active gate due date |
|
| Gate Review | Active gate review |
|
| Gate Status | Active gate status |
|
| Performance to Baseline | Work performance to baseline |
|
| Phase Days | Number of days since start of current gate |
|
| Progress Indicator | Description of each phase status for this Gated Project |
|
| Progress Indicator Icon | Icon display of each phase status for this Gated Project |
|
| Work ID | Work ID to join by. This view only returns one row per work ID |
|
| Work Type Code | Object type code (object type ID) |
|
Owned By
| Field Name | Description | Type |
| Address Line 1 | User first address | |
| Address Line 2 | User second address | |
| City | User city | |
| Company Name | User company name | |
| Country | User country |
|
| Days per Week | Number of days per week |
|
| Department | User department |
|
| Email Address | User email address |
|
| End Date | The user's End date | |
| Fax | User fax | |
| First Name | User first name | |
| Full Name | Full user name | |
| Groups | List of user groups | |
| Hours per Day | Number of hours per day |
|
| Instant Messenger ID | IM account ID |
|
| Instant Messenger Type | IM type |
|
| Job Title | User job title |
|
| Last Name | User last name | |
| License Type | User license type | |
| Mobile Phone | User mobile phone number | |
| No Access | Flag to mark if user is a No Access user. Y if true, N if false | |
| Pager Number | User pager number | |
| Pools | A list of all the Resource Pools that the user belongs to. | |
| Postal Code | User postal code |
|
| Roles | A list of all the Roles that the user is associated with. | |
| Skills | User skills |
|
| Start Date | The user's Start date | |
| State | User state |
|
| User ID | User ID to join by |
|
| User Link | User URL link to profile page | |
| Work ID | Work ID to join by. This view only returns one row per work ID |
|
Program
| Field Name | Description | Type |
| Cancel Date | Work cancel date | |
| Core Type | Work core object type | |
| Create Date | Work creation date | |
| Created By | Work creator ID | |
| Currency | Work currency code |
|
| Last Change | Work last change date |
|
| Location | Work location |
|
| Location with Icon | Work location with image icon display and link to project |
|
| Master Project | Master project name |
|
| Master Project with Icon | Master project name and URL link to the master project |
|
| Name | Work name |
|
| Name with Object Type Icon | Work name with object type icon displayed and URL linked to project |
|
| Object Type | Work object type name |
|
| Objective | Work objective |
|
| Owner ID | Work owner ID |
|
| Parent ID | Parent work ID |
|
| Percent On Track | Percent on track |
|
| Priority | Work priority |
|
| Project ID | Work project ID (user defined ID) |
|
| Sequence | Work sequence number (sequence generated from object type settings) |
|
| Source | Work source |
|
| Status | Work status |
|
| Status Report | Last status report summary text |
|
| Status Report Days Late | Number of status report days late |
|
| Status with Icon | Work status with icon displayed |
|
| Team Status | Given a project and its team members, the longest an invite has been sent and unattended to by one of its team members, in days |
|
| Template | Work template name |
|
| Top Project | Top project name |
|
| Top Project with Icon | Top project name with URL linked to top project |
|
| Work ID | Work ID to join by. This view only returns one row per work ID |
|
| Work Type Code | Object type code (object type ID) |
|
| Context Currency | Default currency defined in context |
|
| Idea Status | Idea status (only for objects derived from idea object type) |
|
| Is Idea | Flag to mark if current work row is an idea, Y for true, N for false |
|
| Is Program | Flag to mark if current work row is a program |
|
Program Details for Work
| Field Name | Description | Type |
| Program | List of programs that the Work ID field is into | |
| Program Links | List of programs that the Work ID field is into (Link version) | |
| Program Size | Amount of items in this program | |
| Top Program | List of top programs that the Work ID field is into |
|
| Work ID | Work ID to join by. This view only returns one row per work ID |
Schedule Details for Work
| Field Name | Description | Type |
| Actual End Date | Work actual end date |
|
| Actual Labor Amount | Work actual labor amount (time from start to end dates in actual labor unit ) | # |
| Actual Labor Unit | Actual labor unit (unit of measure for actual labor amount) | A |
| Actual Start Date | Work actual start date |
|
| Baseline End Date | The end date of the work's current Baseline. |
|
| Baseline Duration (Days) | The total duration in days of the work's current Baseline. | A |
| Baseline Start Date | The start date of the work's current Baseline. |
|
| Baseline [1-12] End Date | The end date of the work's corresponding supplemental Baseline, numbered 1-12. |
|
| Baseline [1-12] Duration (Days) | The total duration in days of the work's corresponding supplemental Baseline, numbered 1-12. | A |
| Baseline [1-12] Start Date | The start date of the work's corresponding supplemental Baseline, numbered 1-12. |
|
| Constraint Type | Work schedule constraint type | A |
| Manual Scheduling | Flag to display work manual schedule setting. N if false, Y if true | A |
| Percent Complete | Work percent complete | A |
| Percent Complete Method | Work percent complete method | A |
| Performance to Baseline | Work performance to baseline |
A |
| Planned End Date | Work planned end date |
|
| Planned Labor Amount | Work planned labor amount (time from start to end dates in planned labor unit ) | # |
| Planned Labor Unit | Planned labor unit (unit of measure for planned labor amount) | A |
| Planned Start Date | Work planned start date |
|
| Project Days | Number of days transpired from start of the project | A |
| Project Days Late | Number of days late for the current project | A |
| Project Due | Work due date |
|
| System End Date | Work system end date |
|
Visual Program Hierarchy
This view returns program to child members relationship grouped by levels (up to eight levels deep). For each program in program tree (parent program), all child members are returned (child), if a program is more than one level deep, first child sub-program is placed in Level 2, next one in Level 3, etc.
| Field Name | Description | Type |
| Depth | Current work depth in current row program hierarchy; depth of current work related to Level1 parent program | |
| LevelX | Level program name in the hierarchy; top is parent, then descendent programs | |
| LevelX ID | Top level program ID in the hierarchy; top is parent, then descendent programs | |
| Project ID | Last level child project ID, project ID for current row; null if Work ID field is from program type |
|
| Project Name | Last level child project name, project name for current row; null if Work ID field is from program type |
|
| Work ID | Last level Work ID; column is joined with other views for more work details |
|