Program Status Update List

This article provides all the Fields available for each View currently available under the Program Status Update List Data Source in Upland Analytics.

The following Views are available when Program Status Update List Data Source is selected upon creating a report. Click on any of them to view the available Fields.

Program
Program Status Update
User Permissions - Programs
User - Program Status Update Modified By

Program

Field Name	Description	Type
Created By	This is the project's program creator ID.	A
Created Date	The date the Program was created, formatted as mm/dd/yyyy with a timestamp.
Created Date Date	The date the Program was created, formatted as mm/dd/yyyy without a timestamp.
Created Date Month Year	The month and the year that the Program was created.
Created Date Quarter Year	The fiscal quarter and the year that the Program was created.
Created Date Year	The year that the Program was created.
Created Date Week	The week that the Program was created.
Description	This is the program description.	A
Modified By	This is the program modifier.	A
Modified Date	The date the Program was last modified, formatted as mm/dd/yyyy with a timestamp.
Modified Date Date	The date the Program was last modified, formatted as mm/dd/yyyy without a timestamp.
Modified Date Month Year	The month and the year that the Program was last modified.
Modified Date Quarter Year	The fiscal quarter and the year that the Program was last modified.
Modified Date Year	The year that the Program was last modified.
Modified Date Week	The week that the Program was last modified.
Name (Text)	This is the program name.	A
Name (URL)	This is the URL link to the program.	A
Number	This is the program number.	#
Organization Owner	This is the organization owner.	A
Owner	This is the program owner.	A
Portfolio	This is the name of the portfolio associated to the program.	A
Program Id	This is the Id of the program.	A
Program Last Status Update	The date (mm/dd/yyyy) and time the Program's Status Update was last modified. This only refers to the Status Update, not the Status or any Health Indicators.
Program Last Status Update Week	The week the Program's Status Update was last modified. This only refers to the Status Update, not the Status or any Health Indicators.
Status	This is the status of the program.	A
Program Status Update	The Program's current Status Update (not to be confused with Status).	A
Status Type	This is the status type of the program.	A
Status Type Id	This is the status type Id of the program.	A

 

Program Status Update

Field Name	Description	Type
Comment	This is the comment attached to the status update.	A
Modified By	This is the ID of the program's most recent modifier.	A
Modified Date	This is the date of the program's most recent modification, formatted mm/dd/yyyy with a timestamp.
Modified Date	This is the date of the program's most recent modification, formatted mm/dd/yyyy without a timestamp.
Program Id	This is the ID of the program.	A
Status Update	This is the name of the status update (entered in the "Status Update" text box, not the "Status" drop-down menu).	A

 

User Permissions - Programs

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 user.	A
User Created Date	This is the date the user was created, formatted mm/dd/yyyy with a timestamp.
User Created Date Month Year	The month and year the user was created.
User Created Date Quarter Year	The financial quarter and year the user was created.
User Created Date Year	The year the user was created.
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 Last Name	The user's full name, with the first name before the last name.	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.	A
User Initials	These are the initials of the user.	A
User Is Active	This indicates whether or not the user is active.	A

 

User - Program Status Update Modified By

Field Name	Description	Type
Account Type	This is the account type of the modifier.	A
Email	This is the email address of the modifier.	A
Full Name [First Last]	The full name of the most recent modifier, with the first name before the last name.	A
First Name	This is the first name of the modifier.	A
Is Active	This indicates whether or not the modifier is an active user.	A
Full Name [Last First]	The full name of the most recent modifier, with the last name before the first name.
Name [Last First] (URL)	The full name of the most recent modifier, with the last name before the first name. The field will link to the user's profile.
Last Name	This is the last name of the modifier.	A
Login	This is the login email of the modifier.	A
Name [First Last] (URL)	The full name of the most recent modifier, with the first name before the last name. The field will link to the user's profile.	A
User Id	This is the user ID of the modifier.	A