NOTICE: You are in the old ClientSpace Help system. Please link to the new ClientSpace Help here https://extranet.clientspace.net/helpdoc/home/ClientSpace.htm
CORE View Listing
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.
|
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. |
Related articles
Related articles
NOTICE: You are in the old ClientSpace Help system. Please link to the new ClientSpace Help here https://extranet.clientspace.net/helpdoc/home/ClientSpace.htm