Info
NetWise provides a series of Core views in Ad-hoc reporting that are pre-formatted to give you easy access to commonly used data. Descriptions of these views are as follows:

Core Views

VIEW NAME	DESCRIPTION
nw_vwAppointments	This view brings back any appointment information across all workspaces. The only condition is with the OrgID & Org Name. It first looks to pull that information from the “Project”, if no project then it will be pulled from “tblCRMCalendarEvent”. nw_vwOrganization_Activities This view brings back ALL Appointments, Tasks, and Calls/Emails that exist. No filter criteria specified. Appointments Returns all Appointments in system Tasks Returns all Tasks in system Calls/Emails Returns all Calls and Emails in system
nw_vwImportQueue	This view brings back Import Queue information (PrismHR API Imports) Including file name and import Status.
nw_vwLookups_Field Labels	This view brings back a listing of all lookup datatype fields in the application and their associated Lookup Group.
nw_vwLookups	This view brings back the Group Name, Code, & Decode for ALL Lookups.
nw_vwOrganization_Activities	This view brings back all organization acitivities and related OrgID and ProjectID
nw_vwTimeTracker_By_User	This view brings back Time tracker data
nw_vwUploaded_Files_GUIDS_To_Varchar	This view brings back Uploaded file data
nw_vwUser	This view brings back User data and related departmental data
nw_vwWorkspaceTemplates	This view brings back all Template Workspaces (Active or Inactive) along with their Group Name and Template Name. Can be used to filter results to certain template workspaces.

Versions Compared