Month: September 2021

Decoding EMR Logs: Synapse PACS Database Table Names

Where do I start?

TABLE_NAME:

A   B   C   D   E   F  G  H   I   J   K   L   M
N   O   P   Q   R   S   T   U   V   W   X   Y   Z

A

  • ACCESSOR
  • ACCESSOR_ACTIVE_DIRECTORY
  • ACCESS_ITEM
  • ACCESS_RESTRICTION
  • ACR
  • ADD_TO_QUEUE_JOB_STATUS
  • AFFINITY_DOMAIN
  • ALIAS_PATIENT
  • ANATOMIC_REGION
  • AUDIT_INSTALL
  • AUDIT_ROWCOUNT

B

  • BACKFILL_PROCESS_TYPE
  • BACKFILL_QUEUE_PRIORITY
  • BACKFILL_QUEUE_STATUS
  • BACKUP_CONFIG
  • BACKUP_LOG
  • BERMUDA_GSPS_CSPS_CNT_UPD_CTL
  • BERMUDA_STUDY_INS_EUID_UPD_CTL
  • BODY_PART
  • BROADCAST_MESSAGE
  • BUTTON

C

  • CALIBRATE_SEQUENCE
  • CANNED_NOTE
  • CASCADED_DICOM_SR
  • CASCADED_IMAGE
  • CASCADED_SERIES
  • CASCADED_STUDY
  • CASCADED_VISIT
  • CHANGE_NOTIFICATION
  • CODING_SCHEME
  • COMMAND
  • COMMAND_CLASS
  • COMMAND_COL
  • COMMAND_COL_OP
  • COMMAND_COMMAND_CLASS
  • COMMAND_COND
  • COMMAND_FILTER
  • COMMAND_INTERFACE
  • COMMAND_INTERFACE_CLIENT
  • COMPONENT_CLASS
  • COMPRESSION
  • CONFERENCE_WORKFLOW_STATUS
  • CONFIG_JSON

D

  • DASHBOARD_CACHE
  • DATA_AGGREGATION_NAME
  • DATA_GUARD_COMMANDS
  • DATA_MAINTENANCE_LOG
  • DB_CHARACTER
  • DB_MEMORY_SIZING_BREAKUP
  • DB_RECOVERY_CONFIG
  • DB_STATISTICS_CONFIG
  • DB_STATS_APRIL_WK#_1
  • DB_STATS_APRIL_WK#_2
  • DB_STATS_APRIL_WK#_3
  • DB_STATS_APRIL_WK#_4
  • DB_STATS_CBO
  • DB_STATS_CBO_CONFIG
  • DB_STATS_JUNE_WK#_1
  • DB_STATS_MARCH_WK#_2
  • DB_STATS_MARCH_WK#_3
  • DB_STATS_MARCH_WK#_4
  • DB_STATS_MAY_WK#_1
  • DB_STATS_MAY_WK#_2
  • DB_STATS_MAY_WK#_3
  • DB_STATS_MAY_WK#_4
  • DB_STATS_MAY_WK#_5
  • DELETED_DICOM_SR
  • DELETED_IMAGE
  • DELETED_PATIENT
  • DELETED_SERIES
  • DELETED_STUDY
  • DELETION_REJECT
  • DEPARTMENT
  • DIAGNOSTIC_CODE
  • DICOM_BACKFILL_QUEUE
  • DICOM_CONFIG
  • DICOM_DESTINATION
  • DICOM_GROUP
  • DICOM_QR_ATTRIBUTE_INFO
  • DICOM_QR_DATE_CLAUSE_INFO
  • DICOM_QR_MATCHING_INFO
  • DICOM_QR_SELECT_INFO
  • DICOM_RETRIEVAL
  • DICOM_SR
  • DICOM_STORAGE
  • DICOM_STORAGE_BACKUP
  • DICOM_TAG
  • DICOM_VALUE_REP
  • DICT_NOTIFY_BANNER
  • DISPLAY
  • DOCUMENT
  • DOCUMENT_TYPE_CONFIG

E

  • EBF_DASHBOARD_SUMMARY
  • EMAIL_CONFIG
  • EMAIL_TYPE
  • ERBF_SFQ_STAT_TRANS
  • ERF_PROFILE_ACTION_TYPE
  • ERF_PROFILE_VERIF_METHOD
  • ERROR_MESSAGE
  • ERROR_TRACE_LOG
  • EVENT_LOG
  • EVENT_TYPE_CONFIG
  • EXTERNAL_IMAGE
  • EXTERNAL_IMAGE_DELETED

F

  • FCR_CODE
  • FCR_TO_CR_QUEUE
  • FCR_TO_CR_QUEUE_CTL
  • FETCH_QUEUE
  • FOLDER
  • FOLDER_COLUMN_LIST
  • FOLDER_COLUMN_PROPERTY
  • FOLDER_ETAG
  • FOLDER_FILTER
  • FOLDER_GROUP_COLUMN
  • FOLDER_ITEM
  • FOLDER_JSON
  • FOLDER_LOCALE
  • FOLDER_MERGE
  • FOLDER_MIGRATION
  • FOLDER_OBJECT
  • FOLDER_TEMP_OAK_PATCH2
  • FOLDER_TEMP_OAK_PATCH3
  • FOLDER_TEMP_STARBOARD
  • FORWARDING_PROFILE
  • FORWARDING_QUEUE_RESPONSE
  • FORWARDING_QUEUE_STATUS
  • FRAME_BOOKMARK
  • FUJIRDS_LOG

I

  • IMAGE
  • IMAGE_CALCULATION
  • IMAGE_DISPLAY
  • IMAGE_OVERLAY
  • IMAGE_REALLOCATE_ACTIVITY
  • IMAGE_RETRIEVAL_OPTION
  • IMAGE_STORAGE
  • IMAGE_VERSION
  • IMAGE_VERSION_DELETED
  • IMAGE_VERSION_MIGRATE_CTL
  • IOCM_REASON
  • IOCM_REJECTNOTE
  • IOCM_STUDY_LAST_REJECT
  • IPP
  • IPPSET_REF
  • IPP_CURVE

K

  • KEYWORD

L

  • LINK_FOLDER
  • LINK_FOLDER_CONTENT
  • LOCALE
  • LOCALIZATION
  • LOCALIZATION_LOCALE
  • LOCALIZATION_TEMP
  • LOCAL_AE
  • LOCATION
  • LOCK_INFO
  • LOCK_TYPE
  • LOG_ACTIVITY
  • LOG_CATEGORY
  • LONG_TERM_EVENT_LOG
  • LOOKUP

M

  • MANUAL_FOLDER_MIGRATION_LOG
  • MANUFACTURER_MODEL
  • MATCH_WEIGHT
  • MENU_CODE
  • MODALITY
  • MONTHLY_EVENT_VOLUME
  • MPPS

O

  • OAK_FOLDER
  • OAK_FOLDER_COLUMN_PROPERTY
  • OAK_PATCH2_FOLDER
  • OAK_POST_UPGRADE
  • OBJECT_TYPE
  • OBSOLETED_IMAGE
  • OP5_POST_UPGRADE
  • OS_REGION

P

  • PATIENT
  • PATIENT_MERGE_ACTIVITY
  • PERMANENT_DELETED_STUDY
  • POST_PROCESS_QUEUE
  • POST_UPGRADE
  • POWERJACKET_SETTING
  • PREFETCH_CFG
  • PREFETCH_QUEUE
  • PRESET
  • PRIORITY
  • PRIVILEGE
  • PRIVILEGE_COM_COM_CLASS
  • PROCEDURE_INFO
  • PROCEDURE_INFO_FCR
  • PROC_INFO_BODY_PART
  • PROPERTY

Q

  • QBE_FOLDER

R

  • RADIATION_DOSE
  • READING_PROTOCOL_OLD
  • READING_SPECIALTY
  • READING_SPECIALTY_PROC_INFO
  • RECYCLE_BIN
  • RECYCLE_BIN_DELETED
  • REFERENCE_RECONCILE_QUEUE
  • REFERENCE_RECONCILE_STATUS
  • REJECT_DICOM_SR
  • REJECT_IMAGE
  • REJECT_TYPE
  • RELATED_PROCEDURE_SYSTEM
  • RELATED_PROCEDURE_USER
  • REMOTE_AE
  • REMOTE_AE_NET_CONFIG
  • REMOTE_AE_SOP_STORAGE
  • REPORT_STATUS
  • RIS_CONFIG

S

  • SBP0_POST_UPGRADE
  • SCHOONER_POST_UPGRADE
  • SCRIPT
  • SECURE_URL_KEY
  • SECURITY_HIERARCHY
  • SECURITY_KEY_3D
  • SERIES
  • SERIES_DESCRIPTION_DOWNLOAD
  • SERIES_DESCRIPTION_REPORT
  • SERIES_REALLOCATE_ACTIVITY
  • SERVICE_PATH
  • SERVICE_PATH_PARAM
  • SERVICE_TRACELOG
  • SESSION_AGGREGATION
  • SESSION_AGGREGATION_DETAIL
  • SESSION_INFO
  • SFI_TEMP_TABLE
  • SGA_CACHE_TABLES
  • SHORTCUT
  • SITE
  • SOP_CLASS
  • SOP_CLASS_STORAGE
  • SSO_CLIENT
  • SSO_CLIENT_PROPERTY
  • SSO_CLIENT_SECRET
  • SSO_EXTERNAL_PROVIDER
  • SSO_REFRESH
  • SSO_SCOPE
  • SSO_SCOPE_CLAIM
  • SSO_TRANSIENT_DATA
  • STANDARD_PROCEDURE
  • STARBOARD_FOLDER
  • STATUS_CHANGE_QUEUE
  • STORAGE
  • STORAGE_BACKUP
  • STUDY
  • STUDY_ANOMALY
  • STUDY_DISPLAY_HISTORY
  • STUDY_DISPLAY_STATE
  • STUDY_DOCUMENT
  • STUDY_FOLDER_INTERSECTION
  • STUDY_FORWARDING_QUEUE
  • STUDY_IMAGE_SENDER
  • STUDY_MEDICAL_EVENT
  • STUDY_MEDICAL_EVENT_ACTIVITY
  • STUDY_MERGE_ACTIVITY
  • STUDY_OPEN_SESSION
  • STUDY_PRODUCTIVITY
  • STUDY_REALLOCATE_ACTIVITY
  • STUDY_SERIES_DESC
  • STUDY_SESSION_MONITOR
  • STUDY_STATUS
  • STUDY_STATUS_LOCALE
  • STUDY_TAT_HISTORY
  • STUDY_WF_EVENT_ACTIVITY
  • STUDY_WF_EVENT_LOG
  • SUBSCRIPTION
  • SYMON_ALERT
  • SYMON_MA_DEFINITION
  • SYMON_MA_TRIGGER
  • SYMON_SAMPLE
  • SYSMODEL_SERVER
  • SYSTEM_CONFIG
  • SYSTEM_VERSION

T

  • TAG_LOOKUP
  • TAT_AGGREGATION_DETAIL
  • TAT_AGG_MODALITY
  • TAT_AGG_MODALITY_PROC
  • TAT_AGG_MODALITY_STAT
  • TAT_AGG_MODALITY_STAT_LOC
  • TAT_AGG_TIME_PERIOD
  • TAT_AGG_USER_RAD
  • TAT_AGG_USER_TECH
  • TAT_AGG_VISIT_CLASS_STAT
  • TAT_AGG_VISIT_LOC_STAT
  • TEMP_LOCALIZATION_NEW
  • TEMP_LOCALIZATION_OLD
  • TEMP_LOCALIZATION_OLD_NEW
  • THINK_LOG
  • THINK_LOG_KEYWORD
  • TIMEZONE
  • TIME_PERIOD
  • TRANSFER_SYNTAX

U

  • USER_DEBUG_LOG
  • USER_DEBUG_LOG_DETAIL
  • USER_INFO
  • USER_PREFERENCES
  • USER_SESSION
  • USER_SESSION_MONITOR

V

  • VISIT
  • VISIT_MERGE_ACTIVITY
  • VISUALIZATION_METRIC
  • VIZ_METRIC_AGGREGATION
  • VIZ_METRIC_AGGREGATION_DETAIL

W

  • WORKFLOW
  • WORKLIST_COL_LOCALE_MODIFIER
  • WORKLIST_FAVORITE
  • WORKSTATION_SPECIAL_PATH
  • WS_PLUGIN
  • WS_PLUGIN_PARAM
  • WS_PLUGIN_TYPE
  • WS_PLUGIN_TYPE_PARAM

X

  • XDS_AUTHOR
  • XDS_AUTHORITY
  • XDS_BODYPART_EVENTCODE
  • XDS_BPPC_EVENTCODE_OPT
  • XDS_BPPC_PRIVACY_OPTION
  • XDS_CODES
  • XDS_CODETYPE
  • XDS_COMMENTS_POLICY
  • XDS_FORMATCODES_FILETYPE
  • XDS_MODALITY_EVENTCODE
  • XDS_PERSONLINK
  • XDS_PERSON_ID
  • XDS_PERSON_NAME
  • XDS_PIX
  • XDS_PROFILE
  • XDS_PROFILE_CONFIDENTIALITY
  • XDS_PROFILE_RECIPIENT_ORG
  • XDS_PROFILE_RECIPIENT_PERSON
  • XDS_PROFILE_SHARINGOPTION
  • XDS_RECIPIENT_ORGANIZATION
  • XDS_RECIPIENT_PERSON
  • XDS_RECIP_PERSON_ORG_MAP
  • XDS_REPOSITORY
  • XDS_REPOSITORY_DOCUMENT
  • XDS_SHARINGOPTION
  • XDS_SUBMISSION
  • XDS_TYPECODES_PROCCODE
  • XDS_USERROLE_MAP

A Cautionary Tale of Audio Forensics and Trade Secrets

One private firm’s artificial-intelligence system is deemed insufficient evidence

ShotSpotter, a gunshot detection firm contracted by police departments nationwide, has recently received criticism for its audio forensics system that, it claims, incorporates “sensors, algorithms, and AI” to identify gunshots and locate their source. While several precincts have praised the company for increasing police response to incidents of gun violence, its accuracy as evidence in court remains questionable.

There are two primary reasons for skepticism: 1) studies have indicated that its algorithm has a propensity for generating false positives, and 2) employees are able to modify the database after alerts come in. Since its system is protected as a trade secret, it has been generally inscrutable from oversight.

As seen in this Associated Press investigation, a State’s Attorney’s Office used ShotSpotter’s data for evidence in a case against a Chicago man. This left him in prison for 11 months before the judge dismissed the case. The report eventually released by ShotSpotter showed that the alert in question was identified differently at first. It alerted to a “firecracker” several blocks away from the alleged scene of the crime — but an employee later revised the identification and location. As a result, prosecutors decided that the “evidence was insufficient to meet [their] burden of proof.”

How could it be improved?

This case emphasizes the importance of accountability in regards to digital evidence on either side of a case. The Health Information Portability and Accountability Act (HIPAA), for example, requires retention of Electronic Medical Records (EMR) stored in Health Information Systems (HIS). Healthcare firms must record a permanent record of all additions, changes and deletions of EMR, including the time and person making those changes.

While ShotSpotter obviously isn’t in healthcare, its system would still benefit from similar transparency. It would help improve the reliability of such information. In this case, such logs would have revealed human intervention earlier on. This would have saved the defendant from the 11 he spent months in prison. In other cases, transparency could support prosecution. Regardless, it would bolster ShotSpotter’s credibility when used as evidence.

It’s possible that we could examine information recorded — when the stored data was originally entered and changes to that stored data — without violating trade secret status to a software provider’s algorithms.  HIS software providers have trade secret protection to their software. Still, they are required to disclose all record EMR, as well as the revision history to those records.

Where we can help.

Asking the right questions and gathering all available digital evidence is important to achieving an equitable outcome. Enigma Forensics has experience auditing and authenticating digitally stored electronic evidence. We can assist with validating such claims as genuine.