This article provides all the Fields available for each View currently available under the Skill Associations Data Source in Upland Analytics.
The following Views are available when Skill Associations Data Source is selected upon creating a report. Click on any of them to view the available Fields.
Version Note: The Skill Associations Data Source, Views and Fields are available as of Tenrox 2019 R1 SP3.
Note: This page is being updated as new information becomes available.
Approval Group Manager
| Field Name | Description | Type |
| Approval Group Manager First Name | This is the approval group manager first name. |
|
| Approval Group Manager ID | This is the approval group manager ID. |
|
| Approval Group Manager Last Name | This is the approval group manager last name. |
|
Functional Group Manager
| Field Name | Description | Type |
| Functional Group Manager First Name | This is the first name of the functional group manager. |
|
| Functional Group Manager ID | This is the ID of the functional group manager. |
|
| Functional Group Manager Last Name | This is the last name of the functional group manager. |
|
Resource Group Manager
| Field Name | Description | Type |
| Resource Group Manager First Name | This is the first name of the group manager of the resource group. |
|
| Resource Group Manager ID | This is the ID of the group manager of the resource group. |
|
| Resource Group Manager Last Name | This is the last name of the group manager of the resource group. |
|
Scope - My Approval Groups
| Field Name | Description | Type |
| Login Name | This is the name of the logged in user. |
Scope - My Functional Group
| Field Name | Description | Type |
| Login Name | This is the name of the logged in user. |
Scope - My Resource Group
| Field Name | Description | Type |
| Login Name | This is the name of the logged in user. |
Skill List
| Field Name | Description | Type |
| Skill | This will be the name of the skill. |
|
| Skill Description | This will be the description of the skill. |
|
| Skill Id | This will be the id of the skill. |
|
| Skill Is Placeholder | This will be set to Yes or No |
|
| Skill Is Suspended | This will be set to Yes or No |
|
User
| Field Name | Description | Type |
| User Address | This is the address of the user. |
|
| User Alternate Phone | This is the alternate phone number of the user. |
|
| User Business Phone | This is the business phone number of the user. |
|
| User Can Report On Any Client | This defines whether the user can report on any client (Yes/No). |
|
| User Can Report On Any Group | This defines whether the user can report on any group (Yes/No). |
|
| User Can Report On Any Project | This defines whether the user can report on any project(Yes/No). |
|
| User Can Report On Any User | This defines whether the user can report on any user (Yes/No). |
|
| User Description | This is the description of the user. |
|
| User Email | This is the email address of the user. |
|
| User Fax | This is the fax number of the user. |
|
| User First Name | This is the first name of the user. |
|
| User Gender | This is the user gender. |
|
| User Hire Date | This is the hire date of the user. |
|
| User Holiday Set | This is the holiday set of the user. |
|
| User ID | This is the Id of the user. |
|
| User Is Active | This defines whether the user is active (Yes/No). |
|
| User Is Decommissioned | This defines whether the user is decommissioned. This will show 0 (for not decommissioned) or 1 (for decommissioned). |
|
| User Is Suspended | This defines whether the user is Suspended. This will show 0 (for not suspended) or 1 (for suspended). |
|
| User Language | This is the language of the user. |
|
| User Last Evaluation Date | This is the last evaluation date date of the user. |
|
| User Last Name | This is the last name of the user. |
|
| User Logon Name | This is the logon name of the user |
|
| User Mobile | This is the mobile phone number of the user. |
|
| User Name | This is the user name (Last Name, First Name). |
|
| User Next Evaluation Date | This is the next evaluation date of the user. |
|
| User Pager | This is the pager number of the user. |
|
| User Primary Role | This is the primary role of the user. |
|
| User Resource Type | This is the name of the (current) resource type. |
|
| User Resource Type ID | This is the Id of the (current) resource type. |
|
| User Security Role | This is the security role of the user. |
|
| User Service Date | This is the service date of the user. |
|
| User Termination Date | This is the termination date of the user. |
|
| User Title | This is the title of the user. |
|
| User Type | This is the user type of the user. |
|
Version note: Available as of Tenrox 2019 R1 SP4: User Name (Last Name, First Name), Suspended, Decommissioned, Gender, Can report on any client, Can report on any group, Can report on any project and Can report on any user.
User Approval Group
| Field Name | Description | Type |
| Approval Group Default Task | This is the approval group default task of the user. |
|
| Approval Group Description | This is the approval group description of the user. |
|
| Approval Group ID | This is the approval group ID of the user. |
|
| Approval Group Name | This is the approval group name of the user. |
|
User Functional Group
| Field Name | Description | Type |
| Functional Group Default Task | This is the default task of the functional group. |
|
| Functional Group Description | This is the description of the functional group. |
|
| Functional Group ID | This is the unique ID of the functional group. |
|
| Functional Group Name | This is the name of the functional group. |
|
User Resource Group
| Field Name | Description | Type |
| Resource Group Default Task | This is the default task of the resource group. |
|
| Resource Group Description | This is the description of the resource group. |
|
| Resource Group ID | This is the unique ID of the resource group. |
|
| Resource Group Name | This is the name of the resource group. |
|
User Skill Associations
| Field Name | Description | Type |
| Expiry Date | This will be the expiry date of the associated skill. |
|
| Expiry Date Month | This will be the expiry date of the associated skill (Aggregate Date - Month). |
|
| Expiry Date Month Year | This will be the expiry date of the associated skill (Aggregate Date - Month Year). |
|
| Expiry Date Quarter | This will be the expiry date of the associated skill (Aggregate Date - Quarter). |
|
| Expiry Date Quarter Year | This will be the expiry date of the associated skill (Aggregate Date - Quarter Year). |
|
| Expiry Date Year | This will be the expiry date of the associated skill (Aggregate Date - Year). |
|
| Interest | This will be the interest selected for the associated skill. |
|
| Proficiency | This will be the proficiency selected for the associated skill. |
|