Database views in the base system
reference brazil Updated Sep 10, 2026 3 min read r_DatabaseViewsInTheBaseSystem.md
Certain views are included in the base system with the Database Views and Database Views for Service Management plugins.
| Name | Description | Label |
|---|---|---|
| change_request_metric | Join change to metric definition to metric instance, creating a view that can be reported on for things like: Changes that were closed by category. | Change Metric |
| change_request_sla | Join change_request to sla(task_sla), creating a view that can be reported on for things like change request resolved by sla per change category. | Change Request SLA |
| change_task_metric | Join change task to metric definition to metric instance, creating a view that can be reported on for things like: Change tasks that were closed by change state | Change Task Metric |
| change_task_sla | Join change_task to sla(task_sla), creating a view that can be reported on for things like change tasks resolved by sla. | Change Task SLA |
| change_task_time_worked | Join change task to task time worked to pull time worked entries associated with incidents. | Change Task Time Worked |
| incident_metric | Join incident to metric definition to metric instance creating a view that can be reported on for things like: Incidents that were resolved on the first call by category | Incident Metric |
| incident_sla | Join incident to sla(task_sla) to report on things like incidents resolved by sla per incident category. | Incident SLA |
| incident_time_worked | Join incident to task time worked to pull time worked entries associated with incidents. | Incident Time Worked |
| pm_project_metric | Join pm_project to metric definition to metric instance creating a view that can be reported on for things like: Projects that were closed by name or date | Project Metric |
| pm_project_sla | Join pm_project to sla(task_sla) to report on things like project names by sla. | Project SLA |
| pm_project_task_metric | Join pm_project_task to metric definition to metric instance creating a view that can be reported on for things like: Project tasks that were closed by name or date | Project Task Metric |
| pm_project_task_sla | Join pm_project to sla(task_sla) to report on things like release tasks by sla. | Project Task SLA |
| pm_project_task_time_worked | Join pm_project_task to task time worked to pull time worked entries associated with project tasks. | Project Task Time Worked |
| problem_metric | Join problem to metric definition to metric instance creating a view that can be reported on for things like: Problems that were resolved on the first call by category | Problem Metric |
| problem_sla | Join problem to sla(task_sla) to report on things like problems resolved by sla per problem state. | Problem SLA |
| release_feature_metric | Join release_feature to metric definition to metric instance creating a view that can be reported on for things like: Release Features that were closed by product | Release Feature Metric |
| release_project_metric | Join release_project to metric definition to metric instance creating a view that can be reported on for things like: Releases that were closed by category | Release Metric |
| release_task_metric | Join release_task to metric definition to metric instance creating a view that can be reported on for things like: Release Features that were closed by feature | Release Task Metric |
| release_task_sla | Join release_task to sla(task_sla) to report on things like release tasks by sla. | Release Task SLA |
| sc_request_metric | Join sc_request to metric definition to metric instance creating a view that can be reported on for things like: Requests that were closed by category | Catalog Request Metric |
| sc_request_sla | Join sc_request to sla(task_sla) to report on things like requests by sla. | Catalog Request SLA |
| sc_req_item_metric | Join sc_request_item to metric definition to metric instance creating a view that can be reported on for things like: Request Items that were closed by item | Catalog Request Item Metric |
| sc_req_item_sla | Join sc_req_item to sla(task_sla) to report on things like request items by sla. | Catalog Request Item SLA |
| sc_task_metric | Join sc_task to metric definition to metric instance creating a view that can be reported on for things like: Catalog tasks that were closed by item | Catalog Task Metric |
| sc_task_sla | Join sc_task to sla(task_sla) to report on things like tasks by sla. | Catalog Task SLA |
Parent Topic:Working with database views for reporting
Related topics
Joining tables using database views
58 lines · 5.3 KB
--- title: Database views in the base system description: Certain views are included in the base system with the Database Views and Database Views for Service Management plugins. locale: en-US canonical_url: https://www.servicenow.com/docs/r/platform-administration/table-administration-and-data-management/r\_DatabaseViewsInTheBaseSystem.html release: brazil product: Table Administration and Data Management classification: table-administration-and-data-management topic_type: reference last_updated: "2026-09-10" reading_time_minutes: 3 breadcrumb: [Work with database views, Table admin, Tables and data, Configure core features, Administer the ServiceNow AI Platform] --- # Database views in the base system Certain views are included in the base system with the Database Views and Database Views for Service Management plugins. |Name|Description|Label| |----|-----------|-----| |change\_request\_metric|Join change to metric definition to metric instance, creating a view that can be reported on for things like: Changes that were closed by category.|Change Metric| |change\_request\_sla|Join change\_request to sla\(task\_sla\), creating a view that can be reported on for things like change request resolved by sla per change category.|Change Request SLA| |change\_task\_metric|Join change task to metric definition to metric instance, creating a view that can be reported on for things like: Change tasks that were closed by change state|Change Task Metric| |change\_task\_sla|Join change\_task to sla\(task\_sla\), creating a view that can be reported on for things like change tasks resolved by sla.|Change Task SLA| |change\_task\_time\_worked|Join change task to task time worked to pull time worked entries associated with incidents.|Change Task Time Worked| |incident\_metric|Join incident to metric definition to metric instance creating a view that can be reported on for things like: Incidents that were resolved on the first call by category|Incident Metric| |incident\_sla|Join incident to sla\(task\_sla\) to report on things like incidents resolved by sla per incident category.|Incident SLA| |incident\_time\_worked|Join incident to task time worked to pull time worked entries associated with incidents.|Incident Time Worked| |pm\_project\_metric|Join pm\_project to metric definition to metric instance creating a view that can be reported on for things like: Projects that were closed by name or date|Project Metric| |pm\_project\_sla|Join pm\_project to sla\(task\_sla\) to report on things like project names by sla.|Project SLA| |pm\_project\_task\_metric|Join pm\_project\_task to metric definition to metric instance creating a view that can be reported on for things like: Project tasks that were closed by name or date|Project Task Metric| |pm\_project\_task\_sla|Join pm\_project to sla\(task\_sla\) to report on things like release tasks by sla.|Project Task SLA| |pm\_project\_task\_time\_worked|Join pm\_project\_task to task time worked to pull time worked entries associated with project tasks.|Project Task Time Worked| |problem\_metric|Join problem to metric definition to metric instance creating a view that can be reported on for things like: Problems that were resolved on the first call by category|Problem Metric| |problem\_sla|Join problem to sla\(task\_sla\) to report on things like problems resolved by sla per problem state.|Problem SLA| |release\_feature\_metric|Join release\_feature to metric definition to metric instance creating a view that can be reported on for things like: Release Features that were closed by product|Release Feature Metric| |release\_project\_metric|Join release\_project to metric definition to metric instance creating a view that can be reported on for things like: Releases that were closed by category|Release Metric| |release\_task\_metric|Join release\_task to metric definition to metric instance creating a view that can be reported on for things like: Release Features that were closed by feature|Release Task Metric| |release\_task\_sla|Join release\_task to sla\(task\_sla\) to report on things like release tasks by sla.|Release Task SLA| |sc\_request\_metric|Join sc\_request to metric definition to metric instance creating a view that can be reported on for things like: Requests that were closed by category|Catalog Request Metric| |sc\_request\_sla|Join sc\_request to sla\(task\_sla\) to report on things like requests by sla.|Catalog Request SLA| |sc\_req\_item\_metric|Join sc\_request\_item to metric definition to metric instance creating a view that can be reported on for things like: Request Items that were closed by item|Catalog Request Item Metric| |sc\_req\_item\_sla|Join sc\_req\_item to sla\(task\_sla\) to report on things like request items by sla.|Catalog Request Item SLA| |sc\_task\_metric|Join sc\_task to metric definition to metric instance creating a view that can be reported on for things like: Catalog tasks that were closed by item|Catalog Task Metric| |sc\_task\_sla|Join sc\_task to sla\(task\_sla\) to report on things like tasks by sla.|Catalog Task SLA| **Parent Topic:**[Working with database views for reporting](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/brazil/markdown/platform-administration/table-administration-and-data-management/c_DatabaseViews.md) **Related topics** [Joining tables using database views]() [Displaying function results in a database view]() [Using disjunctions in complex queries]()
| title | Database views in the base system |
| description | Certain views are included in the base system with the Database Views and Database Views for Service Management plugins. |
| locale | en-US |
| canonical_url | https://www.servicenow.com/docs/r/platform-administration/table-administration-and-data-management/r\_DatabaseViewsInTheBaseSystem.html |
| release | brazil |
| product | Table Administration and Data Management |
| classification | table-administration-and-data-management |
| topic_type | reference |
| last_updated | 2026-09-10 |
| reading_time_minutes | 3 |
| breadcrumb | Work with database viewsTable adminTables and dataConfigure core featuresAdminister the ServiceNow AI Platform |