Work History Data Source
The Work History Data Source allows report builders to create Upland Analytics reports that report on everything that happens to particular PowerSteering work items
This article provides all the Fields available for each View currently available under Work History Data Source in Upland Analytics.
The following Views are available when the Work History Data Source is selected upon creating a report. Click on any of them to view the available fields.
- Basic Details for Work
- Gated Work Attributes
- Owned By
- Parent Work
- Portfolio Filter
- Program Details for Work
- All Work Custom Fields
- All Work Tags
- Work History
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 | A |
Create Date | Work creation date | |
Created By | Work creator ID | A |
Currency | Work currency code |
|
Last Change | Work last change date |
A |
Location | Work location |
A |
Location with Icon | Work location with image icon display and link to project |
A |
Master Project | Master project name |
A |
Master Project with Icon | Master project name and URL link to the master project |
A |
Name | Work name |
A |
Name with Object Type Icon | Work name with object type icon displayed and URL linked to project |
A |
Object Type | Work object type name |
A |
Objective | Work objective |
A |
Owner ID | Work owner ID |
A |
Parent ID | Parent work ID |
A |
Percent On Track | Percent on track |
A |
Priority | Work priority |
A |
Project ID | Work project ID (user defined ID) |
A |
Sequence | Work sequence number (sequence generated from object type settings) |
A |
Source | Work source |
A |
Status | Work status |
A |
Status Report | Last status report summary text |
A |
Status Report Days Late | Number of status report days late |
A |
Status with Icon | Work status with icon displayed |
A |
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 |
A |
Template | Work template name |
A |
Top Project | Top project name |
A |
Top Project with Icon | Top project name with URL linked to top project |
A |
Work ID | Work ID to join by. This view only returns one row per work ID |
A |
Work Type Code | Object type code (object type ID) |
A |
Context Currency | Default currency defined in context |
A |
Idea Status | Idea status (only for objects derived from idea object type) |
A |
Idea Status Comment | The comment that was included with the most recent Idea status change. | A |
Is Idea | Flag to mark if current work row is an idea, Y for true, N for false |
A |
Is Program | Flag to mark if current work row is a program |
A |
Gated Work Attributes
Field Name | Description | Type |
Active Gate | Gated project active gate name | A |
Active Gate Champions | Active gate champions list |
A |
Active Gate Champions Link | Active gate champions list with links to the users |
A |
Active Gate Days Late | Active gate days late |
A |
Active Gate with Icon | Active gate with icon display |
A |
Gate Approval Status | Active gate approval status |
A |
Gate Due | Active gate due date |
|
Gate Review | Active gate review |
# |
Gate Status | Active gate status |
A |
Performance to Baseline | Work performance to baseline |
A |
Phase Days | Number of days since start of current gate |
# |
Progress Indicator | Description of each phase status for this Gated Project |
A |
Progress Indicator Icon | Icon display of each phase status for this Gated Project |
A |
Work ID | Work ID to join by. This view only returns one row per work ID |
A |
Work Type Code | Object type code (object type ID) |
A |
Owned By
Field Name | Description | Type |
Address Line 1 | User first address | A |
Address Line 2 | User second address | A |
City | User city | A |
Company Name | User company name | A |
Country | User country |
A |
Days per Week | Number of days per week |
A |
Department | User department |
A |
Email Address | User email address |
A |
End Date | The user's End date | |
Fax | User fax | A |
First Name | User first name | A |
Full Name | Full user name | A |
Groups | List of user groups | A |
Hours per Day | Number of hours per day |
A |
Instant Messenger ID | IM account ID |
A |
Instant Messenger Type | IM type |
A |
Job Title | User job title |
A |
Last Name | User last name | A |
License Type | User license type | A |
Mobile Phone | User mobile phone number | A |
No Access | Flag to mark if user is a No Access user. Y if true, N if false | A |
Pager Number | User pager number | A |
Pools | A list of all the Resource Pools that the user belongs to. | A |
Postal Code | User postal code |
A |
Roles | A list of all the Roles that the user is associated with. | A |
Skills | User skills |
A |
Start Date | The user's Start date | |
State | User state |
A |
User ID | User ID to join by |
A |
User Link | User URL link to profile page | A |
Work ID | Work ID to join by. This view only returns one row per work ID |
A |
Parent Work
Field Name | Description | Type |
Cancel Date | Work cancel date | |
Core Type | Work core object type | A |
Create Date | Work creation date | |
Created By | Work creator ID | A |
Currency | Work currency code |
A |
Last Change | Work last change date |
|
Location | Work location |
A |
Location with Icon | Work location with image icon display and link to project |
A |
Master Project | Master project name |
A |
Master Project with Icon | Master project name and URL link to the master project |
A |
Name | Work name |
A |
Name with Object Type Icon | Work name with object type icon displayed and URL linked to project |
A |
Object Type | Work object type name |
A |
Objective | Work objective |
A |
Owner ID | Work owner ID |
A |
Parent ID | Parent work ID |
A |
Percent On Track | Percent on track |
# |
Priority | Work priority |
A |
Project ID | Work project ID (user defined ID) |
A |
Sequence | Work sequence number (sequence generated from object type settings) |
A |
Source | Work source |
A |
Status | Work status |
A |
Status Report | Last status report summary text |
A |
Status Report Days Late | Number of status report days late |
A |
Status with Icon | Work status with icon displayed |
A |
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 |
A |
Template | Work template name |
A |
Top Project | Top project name |
A |
Top Project with Icon | Top project name with URL linked to top project |
A |
Work ID | Work ID to join by. This view only returns one row per work ID |
A |
Work Type Code | Object type code (object type ID) |
A |
Context Currency | Default currency defined in context |
A |
Idea Status | Idea status (only for objects derived from idea object type) |
A |
Is Idea | Flag to mark if current work row is an idea, Y for true, N for false |
A |
Is Program | Flag to mark if current work row is a program |
A |
Portfolio Filter
Field Name | Description | Type |
Descended From ID | Ancestor work ID to filter by; not intended as output column as it will return redundant rows | A |
Descended From | Ancestor work name to filter by; not intended as output column as it will return redundant rows | A |
Work ID | Work ID to join by. This view only returns one row per work ID | A |
Work Type Code | Work type ID to join with Work Type view | A |
Work Name | Work name | A |
Work Status | Work status column to join with Work Status view | A |
Work Visibility | Work visibility (CURR, ARCD,DLTD) | A |
Work Start Date | The work item's Scheduled Start Date. | |
Work End Date | The work item's Scheduled End Date. |
|
Child Depth | Level in the hierarchy that the project is in |
A |
Program Details for Work
Field Name | Description | Type |
Program | List of programs that the work_id is into | A |
Program Links | List of programs that the work_id is into (Link version) | A |
Program Size | Amount of items in this program | A |
Top Program | List of top programs that the work_id is into |
A |
Work ID | Work ID to join by. This view only returns one row per work ID | A |
All Work Custom Fields
Field Name | Description | Type |
Application Start Date | *This is just a sample Custom Field column, these custom field columns are dynamically generated per each context CF definition | |
Assumptions | *This is just a sample Custom Field column, these custom field columns are dynamically generated per each context CF definition | |
Availability | *This is just a sample Custom Field column, these custom field columns are dynamically generated per each context CF definition | |
Work ID | Work ID to join by. This view only returns one row per work ID | A |
All Work Tags
Field Name | Description | Type |
Business Area | *This is just a sample Tag column, these tag columns are dynamically generated per each context Tag definition | |
Business Unit | *This is just a sample Tag column, these tag columns are dynamically generated per each context Tag definition | |
Department | *This is just a sample Tag column, these tag columns are dynamically generated per each context Tag definition | |
Work ID | Work ID to join by. This view only returns one row per work ID | A |
Work History
Field Name | Description | Type |
Author | The name of the user who took the action that created a History event. | A |
Event | The History event (i.e. "Add Child", "Create", etc.). | A |
History Description | The description of the History event (i.e. "Jack Skelly created Gated Project Five Phase Implementation Plan"). | A |
Modified Date | The date and time the History event took place. | |
Sequence | The Sequence Number of the work item. | A |
Work Id | The 26-digit ID number of the work item that the History event belongs to. | A |
Work Name | The name of the work item that the History event belongs to. | A |