PrismHR 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 is pulled from tblCRMCalendarEvent. |
|||||||||
|
nw_vwAdHocReportsWidgets |
This view brings back a listing of all reports currently used on widget layouts. The following fields are included in the view:
No filter criteria are specified by default. You can set filter criteria, for instance, to only include records where Widget Layout Active = True. |
|||||||||
| 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 activities 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. |