---
sourceDocument: Brazil Public Sector
sourceDocumentLink: https://www.servicenow.com/docs/r/government-industry

 Release :

    - brazil

ft:locale :

    - en-US

ft:publication_title :

    - Brazil Public Sector

ft:clusterId :

    - gvin

bundleId :

    - gvin

workflow :

    - Customer and Industry


---

# Investigative Case Management Tables

# Tables installed with Investigative Case Management {#ariaid-title1}

Release version: Brazil  
Updated September 10, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
This section describes the tables installed with the Investigative Case Management application and shows how they store and manage information.

## Investigative Case Management tables installed {#psds-data-model-icm-tables__section_s1x_dzh_wdb}

{#psds-data-model-icm-tables__table_fbz_45z_vdb__entry__3}

| Table | Description | Extends Table |
|-|-|-|
| Master Index | Parent table that contains information about all entity records created within the case. All new entities created within the case extend from this index. | N/A |
| Firearm Index | Contains information about the firearm entity records created within the case. | N/A |
| Location Index | Contains information about the location entity records created within the case. | N/A |
| Organization Index | Contains information about the organization entity records created within the case. | N/A |
| Person Index | Contains information about the person entity records created within the case. | N/A |
| Property Index | Contains information about the property entity records created within the case. | N/A |
| Vehicle Index | Contains information about the vehicle entity records created within the case. | N/A |
| Investigative Evidence | Contains information about evidence records within the case. Non-specific to PSDS ICM. Parent table of GSM Evidence \[sn_gsm_icm_evidence\] table. | Evidence |
| Chain of Custody Log | Contains the custody log files created each time a piece of evidence is transferred. Non-specific to PSDS ICM. Parent table of GSM Chain of Custody Log \[sn_gsm_icm_chain_of_custody\] table. | Chain of Custody Log |
| Investigative Case | Contains information about the investigative case record. | CSM Investigative Case |
| Investigative Task | Contains information about the investigative tasks records associated with the case. | CSM Investigative Task |
| Evidence | Contains evidence records created within the case. Specific to PSDS ICM. | N/A |
| Chain of Custody Log | Contains the custody log files created each time a piece of evidence is transferred. Specific to PSDS ICM. | N/A |
| CSM Investigative Case | Investigative case parent table. Non-specific to PSDS ICM. | N/A |
| CSM Investigative Task | Investigative case task parent table. Non-specific to PSDS ICM. | N/A |
[Table 1. Public Sector Digital Services Investigative Case Management tables]

{#psds-data-model-icm-tables__table_fbz_45z_vdb}