---
sourceDocument: Xanadu ServiceNow AI Platform Administration
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/platform-administration

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu ServiceNow AI Platform Administration

ft:clusterId :

    - platadm

bundleId :

    - platadm

workflow :

    - Platform


---

# Database views in the base system

# Database views in the base system {#ariaid-title1}

* Release version: Xanadu
* 
* Updated August 1, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 3 minutes to read

Certain views are included in the base system with the Database Views and Database
Views for Service Management plugins.
{#r_DatabaseViewsInTheBaseSystem__table_acx_442_vq__entry__3}

| 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 |
[Table 1. Database views]

{#r_DatabaseViewsInTheBaseSystem__table_acx_442_vq}
**Related concepts**   

* [Database view creation](https://servicenow-prod.fluidtopics.net/a2KsLerbK3uXQvXwtKIIAg "Create a database view to join tables. You can then create a report based on the database view.")
* [Displaying function results in a database view](https://servicenow-prod.fluidtopics.net/kTnvPDax3tKT97CkQE7Xig "Enhance the display of a database view by adding a function field to the output to display function results.")
* [Using disjunctions in complex queries](https://servicenow-prod.fluidtopics.net/PKuvXfOJEsfJCBPafaFq3Q "ServiceNow performs conjunction (AND) statements before disjunction (OR) statements in a query.")

