Tables installed with Investigative Case Management

  • リリースバージョン: Australia
  • 更新日 2026年03月12日
  • 所要時間：4分

    • 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

    表 : 1. Public Sector Digital Services Investigative Case Management tables
    Table Description Extends Table
    Master Index

    [sn_icm_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

    [sn_icm_firearm]

    		 Contains information about the firearm entity records created within the case. N/A
    Location Index

    [sn_icm_location]

    		 Contains information about the location entity records created within the case. N/A
    Organization Index

    [sn_icm_organization]

    		 Contains information about the organization entity records created within the case. N/A
    Person Index

    [sn_icm_person]

    		 Contains information about the person entity records created within the case. N/A
    Property Index

    [sn_icm_property]

    		 Contains information about the property entity records created within the case. N/A
    Vehicle Index

    [sn_icm_vehicle]

    		 Contains information about the vehicle entity records created within the case. N/A
    Investigative Evidence

    [sn_icm_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

    [sn_gsm_icm_evidence]
    Chain of Custody Log

    [sn_icm_chain_of_custody]

    		 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

    [sn_gsm_icm_chain_of_custody]

    Investigative Case

    [sn_gsm_icm_case]

    		 Contains information about the investigative case record.

    CSM Investigative Case

    [sn_csm_icm_case]
    Investigative Task

    [sn_gsm_icm_task]

    		 Contains information about the investigative tasks records associated with the case.

    CSM Investigative Task

    [sn_csm_icm_task]
    Evidence

    [sn_gsm_icm_evidence]

    		 Contains evidence records created within the case. Specific to PSDS ICM. N/A
    Chain of Custody Log

    [sn_gsm_icm_chain_of_custody]

    		 Contains the custody log files created each time a piece of evidence is transferred. Specific to PSDS ICM. N/A
    CSM Investigative Case

    [sn_csm_icm_case]

    		 Investigative case parent table. Non-specific to PSDS ICM. N/A
    CSM Investigative Task

    [sn_csm_icm_task]

    		 Investigative case task parent table. Non-specific to PSDS ICM. N/A