Where do I start?
When you’re requesting that a defendant produce medical records from their Health Information System (“HIS”), it can be difficult to know where to start.
Below, we’ve laid out the database table names for Synapse PACS, providing a roadmap to the data you’re seeking. It is possible to generate an EMR audit log using data from any of the listed tables that delineates specific fields contained within those tables.
Sometime in the near future, we will be adding detailed table field pages to show the types of fields contained in each of the listed tables. In the meantime, if you are seeking discovery of the audit trail logs for any Synapse PACS HIS, we are happy to provide a complimentary consultation.
TABLE_NAME:
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