---
sourceDocument: Xanadu Platform Analytics
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/now-intelligence

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu Platform Analytics

ft:clusterId :

    - par

bundleId :

    - par

workflow :

    - Platform


---

# Create an audit table

# Create an audit table {#ariaid-title1}

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

Create an audit table to store data. Audit table is a staging table that is created with the required columns to populate the external data.

## Before you begin

Role required: sn_process_optimization_admin

## Procedure

1. Navigate to WorkspacesProcess Mining Workspace.
2. On the left of the page, select the External data integration icon ( ![External data integration icon]()).
3. Select Create dataset.  
   The Create an external dataset tab opens.
4. Provide a name for your dataset.  
   Note:  
   The dataset name must be unique. Ensure to have a user-friendly name that clarifies the type of data and the source for ease of use later.
5. Select Create dataset.  
   The next screen displays a list of columns for the audit table with their descriptions and examples.
6. Select Next.  
   The next screen enables you to add custom columns for the table. If you need more columns than what is already provided, you can do it here.{#create-table__table_nqz_v3x_3zb__entry__2}

   | Column title | Description |
   |-|-|
   | Case ID | Refers to a unique identifier that is assigned to each record to distinguish between different records. |
   | Event value | Refers to an action or activity that occurs within a process, and captures information about what happened. |
   | Timestamp | Captures the date and time when an event occurred. |
   | User | (Optional) Refers to the person who performed the action. |
   | Event type | (Optional) Refers to the specific kind of activity that is being recorded in an event log. Event types are often used to group together similar types of events in a single column. |
   [Table 1. Columns that are automatically added to the table]

   {#create-table__table_nqz_v3x_3zb}
7. Select Next.
{#create-table__steps_vgc_qld_lxb}

*[\>]: and then