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.

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