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 |
Report Center Only/ Izenda Only/Both |
Description |
|||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| nw_vwAppointments |
Both |
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 |
Both |
This view brings back a listing of all reports currently used on widget layouts. It lists the reports by named and provides the Last Run Date and by whom. 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_vwEmailTemplate |
Both |
This view brings back a list of all email templates. |
|||||||||
|
nw_vwFieldChangeAudit |
Both |
This view is the last 90 days of audit log changes. |
|||||||||
| nw_vwImportQueue | Both | This view brings back Import Queue information (PrismHR API Imports) Including file name and import Status. | |||||||||
| nw_vwLookup_FieldLabels | Both | This view brings back a listing of all lookup datatype fields in the application and their associated Lookup Group. | |||||||||
| nw_vwLookups | Both | This view brings back the Group Name, Code, & Decode for ALL Lookups. | |||||||||
| nw_vwOrganization_Activities | Both |
This view brings back all organization activities and related OrgID and ProjectID. It includes ALL Appointments, Tasks, and Calls/Emails that exist. No filter criteria specified.
|
|||||||||
| nw_vwTimeTracker_By_User | Both | This view brings back Time tracker data | |||||||||
|
nw_vwTwoFactorAuthentication |
Both |
This view displays two-factor authentication settings. |
|||||||||
|
nw_vwUploadedFiles |
Both |
This is a list of uploaded fields by form name, date, and who uploaded them. |
|||||||||
|
nw_vwUploaded_Files_GUIDS_To_Varchar
|
Both | This view brings back Uploaded file data | |||||||||
| nw_vwUser | Both | This view brings back User data and related departmental data | |||||||||
| nw_vwWorkspaceTemplates | Both |
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. |