Timesheet Data Source and related views

The Timesheet Data Source allows you to create comprehensive reports on Time Entries, capturing details such as hours logged, Workflow status, and Notes. Using the available Views, you can analyze time data across Clients, Projects, Portfolios, and Programs, as well as review User- and Group-level approval paths. With detailed breakdowns including Hourly Timesheet Entry, Time Entry Basic/Extended, and Timesheet Workflow History, this Data Source is essential for timesheet tracking, approval audits, resource utilization analysis, and compliance reporting across various organizational Scopes.

This article lists all the Fields available for each View currently supported under the Timesheet Data Source in Upland Analytics.

When creating a report, select this data source to access the Views described below. Click any View name to see its available Fields and descriptions.

Note: This page is being updated as new information becomes available.

Active Site

Field Name Description Type
Active Site This is the Name of the User's Active Site.
Active Site Id This is the Id of the User's Active Site.

Alternate Program Manager

Field Name Description Type
Alternate Program Manager First Name This is the First name of the Alternate Program Manager.
Alternate Program Manager Is Active This defines whether the Alternate Program Manager is Active (Yes/No)
Alternate Program Manager Last Name This is the Last name of the Alternate Program Manager.
Alternate Program Manager Name This is the Alternate Program Manager User Name (Last Name, First Name).

Alternate Project Manager

Field Name Description Type
Alternate Project Manager First Name This is the First name of the Alternate Project manager.
Alternate Project Manager Id This is the Id of the Alternate Project manager.
Alternate Project Manager Last Name This is the Last name of the Alternate Project manager.

Approval Alternate Group Manager

Field Name Description Type
Approval Alternate Group Manager First Name This is the alternate Approval Group Manager First name.
Approval Alternate Group Manager Id This is the alternate Approval Group Manager Id.
Approval Alternate Group Manager Last Name This is the alternate Approval Group Manager Last name.

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.

Client

Field Name Description Type
Client This is the Name of the Client.
Client Account Executive First Name This is the First name of the Client's Account Executive.
Client Account Executive Last Name This is the Last name of the Client's Account Executive.
Client Address Line 1 This is the first line of the Client's Address.
Client Address Line 2 This is the second line of the Client's Address.
Client Annual Revenue This is the Annual Revenue of the Client (as defined on the CRM tab of Client Edit). Measure
Client City This is the Client's City.
Client Company This is the Company of the Client.
Client Company Type This is the Company type of the Client (as defined on the CRM tab of Client Edit).
Client Country This is the Country of the Client.
Client Country Code This is the Country Code of the Client.
Client Date Created This is the Date and Time the Client was created on.
Client Date Modified This is the Date and Time the Client was updated on.
Client Department This is the Department of the Client.
Client Description This is the Description of the Client.
Client Division This is the Division of the Client.
Client Email This is the Email address of the Client.
Client Employees This is the number of Employees of the Client (as defined on the CRM tab of Client Edit). Measure
Client Exchange Rate This identifies which Exchange rate should be used for invoicing (e.g. entry date, invoice start date, invoice end date).
Client Fax This is the Fax number of the Client.
Client Fiscal End Date This is the Fiscal End Date of the Client (as defined on the CRM tab of Client Edit).
Client Id This is the Id of the Client.
Client Industry This is the Industry of the Client (as defined on the CRM tab of Client Edit).
Client Invoice Issuer Contact First Name This is the first name of the Issuer contact of the Client.
Client Invoice Issuer Contact Last Name This is the Last Name of the Invoice Issuer Contact of the Client.
Client Invoice To The Attn Of First Name This is the First name of the Client contact in the To the attention of field.
Client Invoice To The Attn Of Last Name This is the Last name of the Client contact in the To the attention of field.
Client Is Active This defines whether the Client is Active (Yes/No)
Client Ownership This is the Ownership of the Client (as defined on the CRM tab of Client Edit).
Client Payment Term This is the Payment Term for the Client.
Client Phone This is the Phone number of the Client.
Client Purchase This is the Purchased field of the Client (as defined on the CRM tab of Client Edit).
Client Rating This is the Rating of the Client (as defined on the CRM tab of Client Edit).
Client Reference Customer This is the Reference customer field of the Client (as defined on the CRM tab of Client Edit).
Client Referred By This is the Referred by field (as defined on the CRM tab of Client Edit).
Client Sic Code This is the SIC Code of the Client (as defined on the CRM tab of Client Edit).
Client State Province This is the State/Province of the Client.
Client State Province Code This is the State/Province code of the Client
Client Status This is the Status of the Client (as defined on the CRM tab of Client Edit).
Client Status Comment This is the Status comment of the Client (as defined on the CRM tab of Client Edit).
Client Tax Group This is the Tax Group of the Client.
Client Ticker Symbol This is the Ticker Symbol of the Client (as defined on the CRM tab of Client Edit).
Client Type This is the Client type of the Client.
Client Web Site This is the Web Site of the Client (as defined on the CRM tab of Client Edit).
Client Zip Postal Code This is the Zip/Postal code of the Client.

Client Created By User

Field Name Description Type
Client Created By User First Name This will display the First name of the User that created the Client.
Client Created By User Last Name This will display the Last name of the User that created the Client.
Client Created By User Name This will display the User name of the User that created the Client.

Client Modified By User

Field Name Description Type
Client Modified By User First Name This will display the First name of the User that updated the Client.
Client Modified By User Last Name This will display the Last name of the User that updated the Client.
Client Modified By User Name This will display the User name of the User that updated the Client.

Hourly Timesheet Entry

Field Name Description Type
Hourly Timesheet Entry End Time This is the End Time of the hourly entry (in AM and PM format).
Hourly Timesheet Entry Hours This is the total hours calculated for each row between Start and End Time. Measure
Hourly Timesheet Entry Note This is the Note of each hourly entry.
Hourly Timesheet Entry Start Time This is the Start Time of the hourly entry (in AM and PM format).

Master Site

Field Name Description Type
Master Site This is the Name of the User's Master Site.
Master Site Id This is the unique Id of the User's Master Site.

Portfolio

Field Name Description Type
Portfolio This is the name of the Portfolio associated to the Project.
Portfolio Code This is the Portfolio Code.
Portfolio Description This is the Portfolio Description.
Portfolio Id This is the Id of the Portfolio.
Portfolio Is active This defines whether the Portfolio is Active. This will show 0 (for suspended) or 1 (for active).
Portfolio Parent This is the Parent Portfolio.
Portfolio Project Workflow This is the Portfolio Project Workflow.

Program

Field Name Description Type
Program This is the Name of the Program.
Program Description This is the Description of the Program.
Program Health This is the Program Health.
Program Id This is the Id of the Program.
Program Is Completed This defines whether the Program is Completed. This will show 0 (for not completed) or 1 (for completed). Measure
Program Projects This is the number of Projects associated to the Program. Measure
Program Status This is the Status of the Program.

Program Manager

Field Name Description Type
Program Manager First Name This is the First name of the Program Manager.
Program Manager Is Active This defines whether the Program Manager is Active (Yes/No) Measure
Program Manager Last Name This is the Last name of the Program Manager.
Program Manager Name This is the Name of the Program Manager (Last name, First name).

Project

Field Name Description Type
Project This is the Name of the Project.
Project Actual End This is the Actual End date of the Project; latest Time Entry date.
Project Actual End Month This is the Actual End date of the Project; latest Time Entry date (Aggregate Date - Month).
Project Actual End Month Year This is the Actual End date of the Project; latest Time Entry date (Aggregate Date - Month Year).
Project Actual End Quarter This is the Actual End date of the Project; latest Time Entry date (Aggregate Date - Quarter).
Project Actual End Quarter Year This is the Actual End date of the Project; latest Time Entry date (Aggregate Date - Quarter Year).
Project Actual End Week This is the Actual End date of the project; latest Time Entry date (Aggregate Date - Week).
Project Actual End Year This is the Actual End date of the Project; latest Time Entry date (Aggregate Date - Year).
Project Actual Start This is the Actual Start date of the Project; earliest Time Entry date.
Project Actual Start Month This is the Actual Start date of the Project; earliest Time Entry date (Aggregate Date - Month).
Project Actual Start Month Year This is the Actual Start date of the Project; earliest Time Entry date (Aggregate Date - Month Year).
Project Actual Start Quarter This is the Actual Start date of the Project; earliest Time Entry date (Aggregate Date - Quarter).
Project Actual Start Quarter Year This is the Actual Start date of the Project; earliest Time Entry date (Aggregate Date - Quarter Year).
Project Actual Start Week This is the Actual Start date of the Project; earliest Time Entry date (Aggregate Date - Week).
Project Actual Start Year This is the Actual Start date of the Project; earliest Time Entry date (Aggregate Date - Year).
Project Code This is the Project Code.
Project Company This is the accounting Company associated to the Project.
Project Contact This will display the Project Contact Name (Last Name, First Name). If multiple Contacts exist, they will be separated by a --.
Project Date Created This is the Date and Time the Project was created on.
Project Description This is the Description of the Project.
Project End This is the End date of the Project.
Project Health This is the Health of the Project.
Project Id This is the Id of the Project.
Project Is Active This defines whether the Project is Active. This will show 0 (for Suspended) or 1 (for Active).
Project Link This is the Name of the Project with a link to the corresponding Project Edit page.

Project Parent This is the Parent Project Name of the Project.
Project Priority This is the Priority of the Project.
Project Start This is the Start date of the Project.
Project State This is the State of the Project.
Project Sum of Allocated Hours This is the sum of Allocated Hours of a Project (in hours). Measure
Project Sum of Planned Hours This is the sum of Planned work Hours of a Project (in hours). Measure
Project Tracking No This is the Tracking # of the Project.
Project Workflow This is the Workflow associated to the Project.

Project Manager

Field Name Description Type
Project Manager First Name This is the First name of the Project Manager.
Project Manager Id This is the Id of the Project Manager.
Project Manager Last Name This is the Last name of the Project Manager.

Scope - All Groups

Field Name Description Type
Login Name This is the Logon name of the logged in User.  

Scope - All Projects

Field Name Description Type
Login Name This is the Logon name of the logged in User.  

Scope - Available Projects

Field Name Description Type
Login Name This is the Logon name of the logged in User.  

Scope - Client Contacts

Field Name Description Type
Login Name This is the Logon name of the logged in User.  

Scope - My Approval Groups

Field Name Description Type
Login Name This is the Logon name of the logged in User.  

Scope - My Entries

Field Name Description Type
Login Name This is the Logon name of the logged in User.  

Scope - My Functional Group

Field Name Description Type
Login Name This is the Logon name of the logged in User.  

Scope - My Portfolios

Field Name Description Type
Login Name This is the Logon name of the logged in User.  

Scope - My Programs

Field Name Description Type
Login Name This is the Logon name of the logged in User.  

Scope - My Projects

Field Name Description Type
Login Name This is the Logon name of the logged in User.  

Task

Field Name Description Type
Task This is the Name of the Task.
Task Description This is the Description of the Task.
Task End This is the End date of the Task.
Task ETC Enabled This defines whether ETC is enabled on the Task. This will show 1 if ETC is enabled, 0 otherwise.
Task Id This is the Id of the Task.
Task Is Active This defines whether the Task is Active. This will show No (for suspended/decommissioned) or Yes (for active).
Task Is Billable This defines whether the Task is Billable. This will show 0 (for non-billable) or 1 (for billable).
Task Is Capitalized This defines whether the Task is Capitalized. This will show 0 (for not capitalized) or 1 (for capitalized).
Task Is Decommissioned This defines whether the Task is Decommissioned (yes/No).
Task Is Funded This defines whether the Task is Funded. This will show 0 (for not payable) or 1 (for payable).
Task Is Payable This defines whether the Task is Payable. This will show 0 (for not payable) or 1 (for payable).
Task Is Project Overhead This indicates if the Task is considered a Cost / Overhead to the company (1) or not (0).
Task Is RandD This defines whether the Task is R&D This will show 0 (for not R&D) or 1 (for R&D).
Task Is Suspended This defines whether the Task is Suspended (yes/No).
Task Link This is the Name of the Task with a link to the corresponding Task Edit page.
Task Milestone This is the Milestone that is associated to the Task.
Task Priority This is the Priority of the Task.
Task Start This is the Start date of the Task. Measure
Task State This is the State of the Task.
Task Used by Expense This defines whether the Task can be used by Expense.
Task Used by Money Charge This defines whether the Task can be used by Money Charges.
Task Used by Product This defines whether the Task can be used by Products.
Task Used by Purchase This defines whether the Task can be used by Purchases.
Task Used by Resource Planning This defines whether the Task can be used by Resource Planning.
Task Used by Time This defines whether the Task can be used by Time.
Task Used by Work Process This defines whether the Task can be used by Work Processes.

Time Entry Basic

Field Name Description Type
Billing Rule Name This is the Name of the Billing Rule associated with the Billable Time Entries & used for calculation of total Billable Amount
Billing Rule Id This is the Id of the Billing Rule associated with Billable Time Entries.
Cost Rule Name This is the Name of the Cost Rule associated with the Payable Time Entries & used for calculation of total Payable Amount
Cost Rule Id This is the Id of the Cost Rule associated with Payable Time Entries
Resource Type This is the User's Resource type on the date of the Time Entry.
Time Charge This is the name of the Time Charge associated to the Entry.
Time Entry Billable Amount in Base Curr This is the Billable Amount in the Base Currency. Measure
Time Entry Billable Total Time This is the total number of Billable hours. Measure
Time Entry Business Unit This is the name of the Business Unit associated to the Time Entry.
Time Entry Date This is the Time Entry date.
Time Entry Date Month This is the Time Entry date (Aggregate Date - Month).
Time Entry Date Month Year This is the Time Entry date (Aggregate Date - Month Year).
Time Entry Date Quarter This is the Time Entry date (Aggregate Date - Quarter).
Time Entry date Quarter Year This is the Time Entry date (Aggregate Date - Quarter Year).
Time Entry date Week This is the Time Entry date (Aggregate Date - Week).
Time Entry Date Year This is the Time Entry date (Aggregate Date - Year).
Time Entry Group This is the Name of the Group associated to the Time Entry.
Time Entry Is Approved This defines whether the Time Entry is approved. This will show 0 (for not approved) or 1 (for approved).
Time Entry Is Billable This defines whether the Time Entry is Billable. This will show 0 (for non-billable) or 1 (for billable).
Time Entry Is Billed This defines whether the Time Entry is in a Posted Invoice. This will show 0 (for not posted) or 1 (for posted).
Time Entry Is Completed This defines whether the Time Entry is Completed. This will show 0 (for not completed) or 1 (for completed).
Time Entry Is Payable This defines whether the Time Entry is Payable. This will show 0 (for not payable) or 1 (for payable).
Time Entry Is Posted This defines whether the Time Entry is included in a Posted Payroll Batch. This will show 0 (for not posted) or 1 (for posted).
Time Entry Non billable Total Time This is the number of Non-billable total time hours. Measure
Time Entry Non payable Total Time This is the number of Non-payable total time hours. Measure
Time Entry Note This is the Time Entry Notes. If multiple Notes exist, they will be separated by a --.
Time Entry Note Type This is the Time Entry Note Type (ex. Alert, Invoice, Notice, R&D, Rejection, Specifications, Status, etc.)
Time Entry Payable Amount in Base Curr This is the total Payable Amount in the Base Currency. Measure
Time Entry Payable Total Time This is the total number of Payable hours. Measure
Time Entry Team This is the Name of the Team associated to the Time Entry.
Time Entry Title This is the Name of the Title associated to the Time Entry.
Time Entry Total Time This is the Total hours. Measure

Note: Selection Type User Defined Fields associated to a Timesheet Template are available through the Time Entry Basic View. Note that one of the UDF options must be marked as Default.

Time Entry Extended

Field Name Description Type
Time Entry Billable Adjustment This is the number of Billable Time Adjustment hours. Measure
Time Entry Billable Amount in Client Curr This is the Billable amount in the Client Currency. Measure
Time Entry Billable Company Id This is the Id of the Company used for billing.
Time Entry Billable Company Name This is the Name of the Company used for billing.
Time Entry Billable Double Overtime This is the number of Billable Double overtime hours. Measure
Time Entry Billable Double Overtime Amount This is the Billable Double overtime amount in the Billing Currency. Measure
Time Entry Billable Overtime This is the number of Billable Overtime hours. Measure
Time Entry Billable Overtime Amount This is the Billable overtime amount in the Billing Currency. Measure
Time Entry Billable Regular Amount This is the Billable regular time amount in the Billing Currency. Measure
Time Entry Billable Regular Time This is the number of Billable regular hours. Measure
Time Entry Billable Total Amount This is the total Billable amount in the Billing Currency. Measure
Time Entry Double Overtime This is the number of Double overtime hours. Measure
Time Entry Invoice Batch Number This is the Invoice Batch # in which the Time Entry is included.
Time Entry Invoice Number This is the Invoice # in which the Time Entry is included.
Time Entry Is Capitalized This defines whether the Time Entry is Capitalized. This will show 0 (for not capitalized) or 1 (for capitalized).
Time Entry Is Funded This defines whether the Time Entry is Payable. This will show 0 (for not payable) or 1 (for payable).
Time Entry Is Invoice Adjustment This defines whether the Time Entry is an Adjustment created from the Invoice. This will show 0 (for not adjustment created from invoice) or 1 (for adjustment created from invoice).
Time Entry Is RandD This defines whether the Time Entry is R&D. This will show 0 (for not R&D) or 1 (for R&D).
Time Entry Is Rated This defines whether the Time Entry is Rated. This will show 0 (for not rated) or 1 (for rated).
Time Entry Is Recognized Revenue This defines whether the Time Entry is Recognized. This will show 0 (for not recognized) or 1 (for recognized).
Time Entry Non Billable Adjustment This is the number of Non-billable Time Adjustment hours. Measure
Time Entry Non Billable Double Overtime This is the number of Non-billable Double overtime hours. Measure
Time Entry Non Billable Overtime This is the number of Non-billable Overtime hours. Measure
Time Entry Non Billable Regular Time This is the number of Non-billable Regular Time hours. Measure
Time Entry Non Payable Adjustment This is the number of non-payable Time Adjustment hours. Measure
Time Entry Non Payable Double Overtime This is the number of non-payable Double overtime hours. Measure
Time Entry Non Payable Overtime This is the number of non-payable overtime hours Measure
Time Entry Non Payable Regular Time This is the number of non-payable regular time hours. Measure
Time Entry Overtime This is the number of Overtime hours. Measure
Time Entry Payable Company Id This is the Id of the Company used for Payroll/Payable.
Time Entry Payable Company Name This is the Name of the Company used for Payroll/Payable.
Time Entry Payable Double Overtime This is the number of payable Double overtime hours. Measure
Time Entry Payable Double Overtime Amount This is the payable Double overtime amount in Cost Currency. Measure
Time Entry Payable Overtime This is the number of Payable Overtime hours. Measure
Time Entry Payable Overtime Amount This is the Payable Overtime amount in the Cost Currency. Measure
Time Entry Payable Regular Amount This is the Payable Regular Time amount in the cost currency. Measure
Time Entry Payable Regular Time This is the number of Payable Regular hours. Measure
Time Entry Payable Total Amount This is the total Payable amount in the Cost Currency. Measure
Time Entry Payroll Batch Number This is the Posted Payroll Batch # in which the Time Entry is included.
Time Entry Phase This is the Name of the Phase associated to the Time Entry.
Time Entry Reference Date This is the Reference Date of the Time Entry.
Time Entry Reference Date Date This is the Reference Date of the Time Entry.
Time Entry Reference Date Month This is the Reference Date of the Time Entry (Aggregate Date - Month).
Time Entry Reference Date Month Year This is the Reference Date of the Time Entry (Aggregate Date - Month Year).
Time Entry Reference Date Quarter This is the Reference Date of the Time Entry (Aggregate Date - Quarter).
Time Entry Reference Date Quarter Year This is the Reference Date of the Time Entry (Aggregate Date - Quarter Year).
Time Entry Reference Date Week This is the Reference Date of the Time Entry (Aggregate Date - Week).
Time Entry Reference Date Year This is the Reference Date of the Time Entry (Aggregate Date - Year).
Time Entry Regular Time This is the number of Regular hours. Measure

Time Entry Functional Group

Field Name Description Type
Time Entry Functional Group Default Task This is the Default Task of the User's Functional Group on the Time Entry date.
Time Entry Functional Group Description This is the Description of the User's Functional Group on the Time Entry date.
Time Entry Functional Group Id This is the unique Id of the User's Functional Group on the Time Entry date.
Time Entry Functional Group Is Active This defines whether the User's Functional Group is Active (Yes/No)
Time Entry Functional Group Name This is the Name of the User's Functional Group on the Time Entry date.

Time Entry Site

Field Name Description Type
Time Entry Site This is the Site Name of the Time Entry.
Time Entry Site Id This is the unique Id of the Site of the Time Entry (used to link to other views).

Timesheet Notes

Field Name Description Type
Timesheet Note Description This is the Note created on the Timesheet or through Task Assignment description
Timesheet Note Category This is the Note category: Assignment or Timesheet
Timesheet Note Date Modified This is the date when the Note was modified.
Timesheet Note Type This is the timesheet note type (ex. Alert, Invoice, Notice, R&D, Rejection, Specifications, Status, etc.)
Timesheet Note Project This is the Project of the Assignment for which the note/description is created for
Timesheet Note Task This is the Task of the Assignment for which the note/description is created for
Timesheet Note Work Type This is the WorkType of the Assignment for which the note/description is created for

Timesheet Summary

Field Name Description Type
Timesheet Assigned To This is the name of the User(s) assigned to the current State of the Timesheet. If more than 1 User is assigned, they will be separated by a --.
Timesheet Document Count This is the number of documents attached to the Timesheet. Measure
Timesheet Is Approved This defines whether the Timesheet is approved. This will show 0 (for not approved) or 1 (for approved).
Timesheet Is Completed This defines whether the Timesheet is completed. This will show 0 (for not completed) or 1 (for completed).
Timesheet is Final Displays Yes/No to indicate if Timesheet Is Final or not.
Timesheet is Read Only Displays Yes/No to indicate if Timesheet Is Read-only or not.
Timesheet is Rejected This defines whether the Timesheet is rejected. This will show 0 (for not rejected) or 1 (for rejected).
Timesheet Link This is the Timesheet Period with a link to the corresponding Timesheet edit page.

Timesheet Note This is the Timesheet Notes. If multiple Notes exist, they will be separated by a ---.
Timesheet Period End This is the End date of the Timesheet Period.
Timesheet Period Start This is the Start date of the Timesheet Period.
Timesheet State This is the current State of the Timesheet.
Timesheet Template This is the Name of the Timesheet Template.
Timesheet Workflow This is the Name of the Workflow associated to the Timesheet.
Timesheet Workflow Version Displays a number indicating the version of the workflow.

Timesheet Workflow History

Field Name Description Type
Timeheet Workflow History Source State Displays the State from which the Timesheet was transitioned from.
Timesheet Workflow History Action Displays the transition that was used to move the Timesheet from the source State to the destination State.
Timesheet Workflow History Date Modified Displays the date and time when the transition was made.
Timesheet Workflow History Destination State Displays the Workflow State to which the Timesheet was transitioned to.

Timesheet Workflow History Modified By User

Field Name Description Type
Timesheet Workflow History Modified By User First Name Displays the First name of the User that performed the Action.
Timesheet Workflow History Modified By User Last Name Displays the Last name of the User that performed the Action.

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 Alternate Role This is the Alternate Role of the User. When user has multiple roles, they are displayed as concatenated with --
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 Date Created This is the date and time when the User account was created.
User Date Modified* This is the date and time when the User account was last modified.
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 of the User.
User Last Login Date This is the date and time when the User last logged into the system.
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 Payment Method This is the Default Payment Method 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 Type of the User.

Note: User Date Modified refers to the date when any changes are made to the User properties found in the Details tab, including its General, Personal, and Security sub-tabs. Modifications can include entering or selecting a new value for a field, updating, or deleting an existing value. This also covers changes made to associated User Defined Fields within the Details tab and its sub-tabs. It is noteworthy to mention that the User Date Modified fields are also triggered when a User Profile is saved without any modifications.

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 Is Active This defines whether the Approval Group is Active (Yes/No)
Approval Group Name This is the Approval Group Name of the User.