Project Status Update List
This article provides all the Fields available for each View currently available under the Project Status Update List Data Source in Upland Analytics.
The following Views are available when Project Status Update List Data Source is selected upon creating a report. Click on any of them to view the available Fields.
Project
Project Status Update
Project Workplan
User Permissions - Projects
Project Status Update Modified By
| Field Name | Description | Type |
| Business Priority | This is the project business priority. | A |
| Category | This is the project category. | A |
| Category Sort Order | This is the project category sort order. | A |
| Created By | Project creator ID. | A |
| Created Date | The date the Project was created, formatted as mm/dd/yyyy with a timestamp. |
|
| Created Date Date | The date the Project was created, formatted as mm/dd/yyyy without a timestamp. |
|
| Created Date Month Year | The month and the year the Project was created. |
|
| Created Date Quarter Year | The fiscal quarter and the year the Project was created. |
|
| Created Date Year | The year the Project was created. |
|
| Created Date Week | The week the Project was created. |
|
| Description | This is the project description. | A |
| Last Status Update | This is the date and time of the project's last status update. |
|
| Modified By | This is the project modifier. | A |
| Modified Date | The date the Project was last modified, formatted as mm/dd/yyyy with a timestamp. |
|
| Modified Date Date | The date the Project was last modified, formatted as mm/dd/yyyy without a timestamp. |
|
| Modified Date Month Year | The month and the year the Project was last modified. |
|
| Modified Date Quarter Year | The fiscal quarter and the year the Project was last modified. |
|
| Modified Date Year | The year the Project was last modified. |
|
| Modified Date Week | The week the Project was last modified. |
|
| Name (Text) | This is the project name. | A |
| Name (URL) | This is the project name. It links directly to the project summary page. | A |
| Number | This is the project number. | A |
| Operations | This is the project operation. | A |
| Organization Owner | This is the project organization owner. | A |
| Owner Id | This is the Id of the owner. | A |
| Portfolio | This is the name of the portfolio associated to the project. | A |
| Priority | This is the project priority. | A |
| Priority Sort Order | This is the project priority sort order. | A |
| Program | This is the name of the program. | A |
| Project Id | This is the ID number of the project. | A |
| Project Status Id | This is the ID number of the project's current status. | |
| Status | This is the current project status. | |
| Status Id | This is the ID number of the project's current status. | A |
| Status Sort Order | This is the where the project's current status is listed in the status sort order. | A |
| Status Type | This is the project status type. | A |
| Status Type Id | This is the ID number of the project's status type. | A |
| Status Update | This is the project's most recent status update. Note that this could take up a lot of space in the report. | A |
| Type | This is the project's type. | A |
| Field Name | Description | Type |
| Actual Effort | This is the actual effort of the project workplan. | # |
| Actual Effort To Date | This is the actual effort to date of the project workplan. |
|
| Actual Effort To Date Vs Allocated Effort To Date | This is the actual effort to date vs allocated effort to date of the project workplan. |
|
| Allocated Effort | This is the allocated effort of the project workplan. | # |
| Allocated Effort To Date | This is the allocated effort to date of the project workplan. |
|
| Baseline Duration | This is the baseline duration of the project workplan. | # |
| Baseline End Date | This is the baseline end date of the project workplan, formatted (mm/dd/yyyy). |
|
| Baseline End Date Month Year | This is the baseline end date of the project workplan, formatted by month and year. |
|
| Baseline End Date Quarter Year | This is the baseline end date of the project workplan, formatted by annual quarter and year. |
|
| Baseline End Date Year | This is the year of the workplan's baseline end date. |
|
| Baseline Start Date | This is the baseline start date of the project workplan, formatted (mm/dd/yyyy). |
|
| Baseline Start Date Month Year | This is the baseline start date of the project workplan, formatted by month and year. |
|
| Baseline Start Date Quarter Year | This is the baseline start date of the project workplan, formatted by annual quarter and year. |
|
| Baseline Start Date Year | This is the year of the workplan's baseline start date. |
|
| Checkout Date | This is the most recent checkout date of the project workplan, formatted (mm/dd/yyyy) with time. |
|
| Checkout Date Month Year | This is the most recent date of the project workplan, formatted by month and year. |
|
| Checkout Date Quarter Year | This is the most recent checkout date of the project workplan, formatted by annual quarter and year. |
|
| Checkout Date Year | This is the year the project workplan was last checked out. |
|
| Checkout User Id | This is the ID number of the resource who most recently checked out the project workplan. | A |
| Completed Through Date | This is the "completed through" date of the project workplan, formatted (mm/dd/yyyy). |
|
| Completed Through Date Month Year | This is the "completed through" date of the project workplan, formatted by month and year. |
|
| Completed Through Date Quarter Year | This is the "completed through" date of the project workplan, formatted by annual quarter and year. |
|
| Completed Through Date Year | This is the "completed through" year of the project workplan. |
|
| Current End Vs Baseline End | This is the current end vs baseline end of the project workplan. | # |
| Current Workplan Id | This is the current Id of the workplan. | # |
| Duration | This is the duration of the project workplan. | # |
| End Date | This is the end date of the project workplan, formatted (mm/dd/yyyy). |
|
| End Date Month Year | This is the end date of the project workplan, formatted by month and year. |
|
| End Date Quarter Year | This is the end date of the project workplan, formatted by annual quarter and year. |
|
| End Date Year | This is the year of the project workplan's end date. |
|
| Expected Work Complete | This is the expected work complete of the project workplan. | A |
| Expected Work Complete Critical | This is the expected work complete critical of the project workplan. | A |
| Progress | This is the progress of the project workplan. | A |
| Project Id | This is the ID number of the project. | A |
| Project Workplan Created By | This is the ID number of the Resource who created the Work Plan. | A |
| Project Workplan Created Date | This is the date the Work Plan was created, formatted (mm/dd/yyyy) with time. |
|
| Project Workplan Modified By | This is the ID number of the Resource who last modified the Work Plan | A |
| Project Workplan Modified Date | This is the date the Work Plan was last modified, formatted (mm/dd/yyyy) with time. |
|
| Resource Productivity Ratio | This is the resource productivity ratio of the project workplan. | # |
| Start Date | This is the start date of the project workplan, formatted (mm/dd/yyyy). |
|
| Start Date Month Year | This is the start date of the project workplan, formatted by month and year. |
|
| Start Date Quarter Year | This is the start date of the project workplan, formatted by annual quarter and year. |
|
| Start Date Year | This is the year of the project workplan's start date. |
|
| Variance Days | This is the variance days of the project workplan. |
|
| Work Complete | This is the work complete of the project workplan. | A |
| Work Complete Critical | This is the work complete critical of the project workplan. | A |
| Field Name | Description | Type |
| Modified By | This is the name of the project status update modifier. | A |
| Comment | This is the comment of the project status update modifier. | A |
| Modified Date | This is the modification date of the project status update. |
|
| Project Id | This is the Id of the project. | A |
| Status Update | This is the project status update. | A |
| Field Name | Description | Type |
| User Account Type | This is the account type of the user. | A |
| User Chat Id | This is the chat ID of the user. | A |
| User Created By | This is the ID of the creator. | # |
| User Created Date | This is the date the user was created. | A |
| User Email | This is the email address of the user. | A |
| User Employee Id | This is the employee ID of the user. | A |
| User Ext | This is the phone number extension of the user. | A |
| User Fax | This is the fax number of the user. | A |
| User First Name | This is the first name of the user. | A |
| User Handle | This is the "@" handle of the user. | A |
| User Id | This is the ID of the user. | # |
| User Initials | These are the initials of the user. | A |
| User Is Active | This indicates whether or not the user is active. | A |
| User Last Name | This is the last name of the user. | A |
| User Login | This is the login/username email of the user. | A |
| User Modified By | This is the ID of the most recent modifier of the user. | # |
| User Modified Date | This is the date of the most recent modification of the user. | A |
| User Phone | This is the phone number of the user. | A |
| User URL | This is the name of the user, which is a link to the user's profile. | A |
Project Status Update Modified By
| Field Name | Description | Type |
| Account Type | This is the account type of the project status update modifier. | A |
| This is the email address of the project status update modifier. | A | |
| First Name | This is the first name of the project status update modifier. | A |
| Is Active | This defines whether the project status update modifier is active. | A |
| Last Name | This is the last name of the project status update modifier. | A |
| Login | This is the name of the logged in project status update modifier. | A |
| Name (URL) | This is the URL to the project status update modifier. | A |
| User Id | This is the Id of the user. | A |