Program List

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

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

Program Portfolio
Program
Program Health Indicators
Program Organization Unit
Resource - Program Owner
*User Permissions - Program

Note: *The "User Permissions - Program" data view is hidden from report builders by default. See Permission-Based Data Views for more information.

User - Program Created By
User - Program Modified By

 

Program Portfolio

Field Name	Description	Type
Created By	The user ID of the user who created the Program's Portfolio.	A
Created Date	The date the Program's Portfolio was created, formatted mm/dd/yyyy with a timestamp.
Created Date Month Year	The month and year the Program's Portfolio was created.
Created Date Quarter Year	The financial quarter and year the Program's Portfolio was created.
Created Date Year	The year the Program's Portfolio was created.
Portfolio Id	This is the id of the portfolio.	A
Modified By	The user ID of the user who last modified the Program's Portfolio.
Modified Date	The date the Program's Portfolio was last modified, formatted mm/dd/yyyy with a timestamp.
Modified Date Month Year	The month and year the Program's Portfolio was last modified.
Modified Date Quarter Year	The financial quarter and year the Program's Portfolio was last modified.
Modified Date Year	The year the Program's Portfolio was last modified.	A
Portfolio Name	This is the name of the portfolio.	A

 

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 Health Indicators

Field Name	Description	Type
Health Indicator 1 Color	This is the color of Health Indicator 1.	A
Health Indicator 1 Description	This is the description of Health Indicator 1.	#
Health Indicator 1 Id	This is the Id of Health Indicator 1.	A
Health Indicator 1 Name	This is the name of Health Indicator 1.	A
Health Indicator 1 State Description	This is the state description of Health Indicator 1.	A
Health Indicator 10 Color	This is the color of Health Indicator 10.	A
Health Indicator 10 Description	This is the description of Health Indicator 10.	A
Health Indicator 10 Id	This is the Id of Health Indicator 10.	A
Health Indicator 10 Name	This is the name of Health Indicator 10.	A
Health Indicator 10 State Description	This is the state description of Health Indicator 10.	A
Health Indicator 2 Color	This is the color of Health Indicator 2.	A
Health Indicator 2 Description	This is the description of Health Indicator 2.	A
Health Indicator 2 Id	This is the Id of Health Indicator 2.	#
Health Indicator 2 Name	This is the name of Health Indicator 2.	A
Health Indicator 2 State Description	This is the state description of Health Indicator 2	A
Health Indicator 3 Color	This is the color of Health Indicator 3.	A
Health Indicator 3 Description	This is the description of Health Indicator 3.	A
Health Indicator 3 Id	This is the Id of Health Indicator 3.	A
Health Indicator 3 Name	This is the name of Health Indicator 3.	A
Health Indicator 3 State Description	This is the state description of Health Indicator 3.	A
Health Indicator 4 Color	This is the color of Health Indicator 4.	A
Health Indicator 4 Description	This is the description of Health Indicator 4.	A
Health Indicator 4 Id	This is the Id of Health Indicator 4.	A
Health Indicator 4 Name	This is the name of Health Indicator 4.	A
Health Indicator 4 State Description	This is the state description of Health Indicator 4.	A
Health Indicator 5 Color	This is the color of Health Indicator 5.	A
Health Indicator 5 Description	This is the description of Health Indicator 5.	A
Health Indicator 5 Id	This is the Id of Health Indicator 5.	A
Health Indicator 5 Name	This is the name of Health Indicator 5.	A
Health Indicator 5 State Description	This is the state description of Health Indicator 5.	A
Health Indicator 6 Color	This is the color of Health Indicator 6.	A
Health Indicator 6 Description	This is the description of Health Indicator 6.	A
Health Indicator 6 Id	This is the Id of Health Indicator 6.	A
Health Indicator 6 Name	This is the name of Health Indicator 6.	A
Health Indicator 6 State Description	This is the state description of Health Indicator 6.	A
Health Indicator 7 Color	This is the color of Health Indicator 7.	A
Health Indicator 7 Description	This is the description of Health Indicator 7.	A
Health Indicator 7 Id	This is the Id of Health Indicator 7.	A
Health Indicator 7 Name	This is the name of Health Indicator 7.	A
Health Indicator 7 State Description	This is the state description of Health Indicator 7.	A
Health Indicator 8 Color	This is the color of Health Indicator 8.	A
Health Indicator 8 Description	This is the description of Health Indicator 8.	A
Health Indicator 8 Id	This is the Id of Health Indicator 8.	A
Health Indicator 8 Name	This is the name of Health Indicator 8.	A
Health Indicator 8 State Description	This is the state description of Health Indicator 8.	A
Health Indicator 9 Color	This is the color of Health Indicator 9.	A
Health Indicator 9 Description	This is the description of Health Indicator 9.	A
Health Indicator 9 Id	This is the Id of Health Indicator 9.	A
Health Indicator 9 Name	This is the name of Health Indicator 9.	A
Health Indicator 9 State Description	This is the state description of Health Indicator 9.	A
Program Id	This is the Id of the program.	A

 

Program Organization Unit

Field Name	Description	Type
Abbreviation	This is the abbreviation of the organization unit.	A
Created By	This is the organization unit creator ID.	A
Created Date	This is the organization unit creation date.
Id	This is the organization unit Id.	A
Modified By	This is the organization unit modifier Id.	A
Modified Date	This is the organization unit modification date.
Name	This is the organization unit name.	A

 

Resource - Program Owner

Field Name	Description	Type
Created Date Month Year	The month and year the Program Owner's Resource profile was created.
Created Date Quarter Year	The financial quarter and year the Program Owner's Resource profile was created.
Created Date Year	The year the Program Owner's Resource profile was created.
Email	This is the email of the program owner.	A
Full Name [First Last]	The full name of the Program Owner, with the first name before the last name.	A
First Name	This is the first name of the program owner.	A
Full Name [Last First]	The full name of the Program Owner, with the last name before the first name.	A
Name [Last First] (URL)	The full name of the Program Owner, with the last name before the first name. The field will link to the Program Owner's Resource profile.	A
Last Name	This is the last name of the program owner.	A
Modified Date Month Year	The month and year the Program Owner's Resource profile was last modified.
Modified Date Quarter Year	The financial quarter and year the Program Owner's Resource profile was last modified.
Modified Date Year	The year the Program Owner's Resource profile was last modified.
Resource Id	This is the resource Id of the program owner.	A
Status	This is the status of the program owner.	A
Name [First Last] (URL)	The full name of the Program Owner, with the first name before the last name. The field will link to the Program Owner's Resource profile.	A

 

User Permissions - Program

Note: The "User Permissions - Program" data view is hidden from report builders by default. See Permission-Based Data Views for more information.

Field Name	Description	Type
User Account Type	This is the report viewer's account type.	A
User Chat Id	This is the chat ID of the report viewer.	A
User Created By	This is the creator of the report viewer.	A
User Created Date	This is the date the report viewer's profile was created.
User Created Date Month Year	This is the month and the year the report viewer's profile was created
User Created Date Quarter Year	This is the annual quarter and year the report viewer's profile was created.
User Created Date Year	This is the year the report viewer's profile was created.
User Email	This is the email address of the report viewer.	A
User Employee Id	This is the employee ID of the report viewer.	A
User Ext	This is the phone ext. of the report viewer.	A
User Fax	This is the fax number of the report viewer.	A
User First Last Name	The full name of the report viewer, with the first name before the last name.	A
User First Name	This is the first name of the report viewer.	A
User Handle	This is the Eclipse PPM handle of the report viewer.	A
User Id	This is the ID of the report viewer.	A
User Initials	These are the initials of the report viewer.	A
User Is Active	This indicates whether or not the report viewer is an active user.	A
User Last First Name	The full name of the report viewer, with the last name before the first name.	A
User Last First URL	The full name of the report viewer, with the last name before the first name. The field will link to the report viewer's user profile.	A
User Last Name	This is the last name of the report viewer.	A
User Login	This is the login name of the report viewer.	A
User Modified By	This indicates who last modified the report viewer.	A
User Modified Date	This is the date the report viewer was last modified.
User Modified Date Month Year	This is the month and the year that the report viewer was last modified.
User Modified Date Quarter Year	This is the annual quarter and the year that the report viewer was last modified.
User Modified Date Year	This is the year that the report viewer was last modified.
User Phone	This is the phone number of the report viewer.	A
User URL	The name of the report viewer, with the first name before the last name. The field will link to the report viewer's user profile.	A

 

User - Program Created By

Field Name	Description	Type
Account Type	This is the creator account type.	A
Email	This is the email address of the creator.	A
Full Name [First Last]	The full name of the creator, with the first name before the last name.	A
First Name	This is the first name of the creator.	A
Is Active	This defines whether the creator is active.	A
Full Name [Last First]	The full name of the creator, with the last name before the first name.	A
Name [Last First] (URL)	The full name of the creator, with the last name before the first name. The field will link to the creator's user profile.	A
Last Name	This is the last name of the creator.	A
Login	This is the name of the logged in program creator.	A
Name [First Last] (URL)	The full name of the creator, with the first name before the last name. The field will link to the creator's user profile.	A
User Id	This is the Id of the user.	A

 

User - Program Modified By

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