SchemaSpy Analysis of slot9.WORLD.TSTA - Anomalies

Generated by SchemaSpy

Things that might not be 'quite right' about your schema:

• Columns whose name and type imply a relationship to another table's primary key:

  Child Column	Implied Parent Column
  ACTIVITY_CODES.CATEGORY_CODE	ACTIVITY_CATEGORY_CODES.CATEGORY_CODE
  ACTIVITY_TEMPLATE_CODES.TEMPLATE_CODE	ASSIGNMENT_TEMPLATES.TEMPLATE_CODE
  ACTIVITY_TEMPLATE_RESULTS.AGENCY_CODE	AGENCY_CODES.AGENCY_CODE
  ADDRESS_COLLAPSE_LOG.COLLAPSE_ID	BUSINESS_COLLAPSE_LOG.COLLAPSE_ID
  ADDRESS_COLLAPSE_LOG.INDX_SEC_LEVEL_CODE	MASTER_INDEX_SECURITY_CODES.INDX_SEC_LEVEL_CODE
  AGENCY_API_KEYS.ID	DS_ICR_CAT_QUERIES.ID
  AGENCY_ATTACHMENT_INTERFACES.ID	COURT_CASE_DELETE.ID
  AGENCY_CODES_TEMP.AGENCY_CODE	AGENCY_CODES.AGENCY_CODE
  AGNCY_SRCH_INT_COUNT_HISTORY.ID	COURT_CASE_DELETE.ID
  ARREST_CHARGE_NARRATIVES.ARREST_NARRATIVE_ID	ARREST_NARRATIVES.ARREST_NARRATIVE_ID
  ARREST_REF_NUMBERS.ID	DS_ICR_CAT_QUERIES.ID
  ARRESTEE_WEAPONS.ARREST_ID	ARREST_DELETE.ARREST_ID
  ASSIGNMENT_LOGS.LOG_ID	ACCESS_LOGS.LOG_ID
  ATTACHMENT_INTERFACES.SERVICE_NAME	EJS_WEB_SERVICES.SERVICE_NAME
  ATTACHMENTS.ID	COURT_CASE_DELETE.ID
  AUDIT_REPORTS.ID	COURT_CASE_DELETE.ID
  AUDIT_SEARCHES.ID	COURT_CASE_DELETE.ID
  CALENDAR_ASSIGNMENTS.OFFICER_ID	OFFICERS.OFFICER_ID
  CALENDAR_ASSIGNMENTS_AUDIT.ASSIGNMENT_SERIES_ID	CALENDAR_ASSIGNMENT_SERIES.ASSIGNMENT_SERIES_ID
  CALENDAR_ASSIGNMENTS_AUDIT.CALENDAR_ASSIGNMENT_ID	CALENDAR_ASSIGNMENTS.CALENDAR_ASSIGNMENT_ID
  CALENDAR_ASSIGNMENTS_AUDIT.OFFICER_ID	OFFICERS.OFFICER_ID
  CALENDAR_SHIFT_USERS.CALENDAR_SHIFT_ID	CALENDAR_SHIFTS.CALENDAR_SHIFT_ID
  CALENDAR_TEMPLATES.TEMPLATE_ID	ROUTE_TEMPLATES.TEMPLATE_ID
  CALL_DISPOSITION_CODES.EVENT_TYPE_CODE	DISPATCH_EVENT_TYPES.EVENT_TYPE_CODE
  CASE_ACTIVITY_ASSIGNMENTS.ID	COURT_CASE_DELETE.ID
  CASE_ASSIGNMENT_HISTORIES.AGENCY_CODE	AGENCY_CODES.AGENCY_CODE
  CASE_TYPE_CODES.CODE	ENROLLMENT_STATUS_CODES.CODE
  CERTIFICATION_CERT_PREREQ.ID	COURT_CASE_DELETE.ID
  CERTIFICATION_COURSE_PREREQ.ID	COURT_CASE_DELETE.ID
  CERTIFICATION_EMPLOYEE.ID	COURT_CASE_DELETE.ID
  CERTIFICATION_RANK.ID	COURT_CASE_DELETE.ID
  CERTIFICATIONS.ID	COURT_CASE_DELETE.ID
  CHAIN_OF_CUSTODIES.CUSTODY_ID	ITEM_CUSTODIES.CUSTODY_ID
  CHARGE_CLASS_CODES.BOND_TYPE	BOND_TYPE_CODES.BOND_TYPE
  CHARGE_CODE_TOKENS.ID	COURT_CASE_DELETE.ID
  CHARGE_CODES.BOND_TYPE	BOND_TYPE_CODES.BOND_TYPE
  CHARGE_CODES.CODE	BLOOD_TYPE_CODES.CODE
  CHARGE_LANGUAGE_TEMPLATES.TEMPLATE_ID	PRINT_TEMPLATES.TEMPLATE_ID
  CITATION_DELETE.AGENCY_CODE	AGENCY_CODES.AGENCY_CODE
  CITATION_DELETE.CITATION_TYPE_CODE	CITATION_TYPE_CODES.CITATION_TYPE_CODE
  CITATION_DELETE.LOG_ID	ACCESS_LOGS.LOG_ID
  CITATION_RACIAL_INFO.CITATION_ID	CITATIONS.CITATION_ID
  COLLAPSED_MASTER_NAMES.PERSON_ID	JAIL_PEOPLE.PERSON_ID
  COURSE.ID	COURT_CASE_DELETE.ID
  COURSE_ATTACHMENTS.ID	COURT_CASE_DELETE.ID
  COURSE_EMPLOYEE_GROUPS.ID	COURT_CASE_DELETE.ID
  COURSE_IMAGES.ID	COURT_CASE_DELETE.ID
  COURSE_INST_EMP_ATTACHMENTS.ID	COURT_CASE_DELETE.ID
  COURSE_INST_EMP_IMAGES.ID	COURT_CASE_DELETE.ID
  COURSE_INSTANCE.ID	COURT_CASE_DELETE.ID
  COURSE_INSTANCE_EMPLOYEE.ID	COURT_CASE_DELETE.ID
  COURSE_PREREQUISITES.ID	COURT_CASE_DELETE.ID
  COURT_APPEARANCE_OFFS.ID	COURT_CASE_DELETE.ID
  COURT_APPEARANCES.ID	COURT_CASE_DELETE.ID
  COURT_CASE_APPEARANCES.ID	COURT_CASE_DELETE.ID
  COURT_CASE_ARRESTS.ID	COURT_CASE_DELETE.ID
  COURT_CASE_CITATIONS.ID	COURT_CASE_DELETE.ID
  COURT_CASE_COMPLAINTS.ID	COURT_CASE_DELETE.ID
  COURT_CASE_DELETE.AGENCY_CODE	AGENCY_CODES.AGENCY_CODE
  COURT_CASE_INCS.ID	COURT_CASE_DELETE.ID
  COURT_CASE_OFFS.ID	COURT_CASE_DELETE.ID
  COURT_CASE_PEOPLE.ID	COURT_CASE_DELETE.ID
  COURT_CASE_REFS.ID	COURT_CASE_DELETE.ID
  COURT_CASES.ID	COURT_CASE_DELETE.ID
  COURT_PAPER_LOGS.CP_PARTY_ID	COURT_PAPER_UNKNWN_DETAILS.CP_PARTY_ID
  COURT_PAPER_PARTIES.CP_PARTY_ID	COURT_PAPER_UNKNWN_DETAILS.CP_PARTY_ID
  COURT_PAPERS.CP_ID	CP_DEL_LOG.CP_ID
  CP_DEL_LOG_PARTIES.CP_PARTY_ID	COURT_PAPER_UNKNWN_DETAILS.CP_PARTY_ID
  CP_PAYMENT_PARTIES_LOG.FEE_PAYMENT_ID	COURT_PAPER_PAYMENTS.FEE_PAYMENT_ID
  CRIMINAL_COMP_ATTACHMENTS.ID	COURT_CASE_DELETE.ID
  CRIMINAL_COMP_CHARGE_TOKENS.ID	COURT_CASE_DELETE.ID
  CRIMINAL_COMP_IMAGES.ID	COURT_CASE_DELETE.ID
  CRIMINAL_COMPLAINT_ARRESTS.ID	COURT_CASE_DELETE.ID
  CRIMINAL_COMPLAINT_CHARGES.ID	COURT_CASE_DELETE.ID
  CRIMINAL_COMPLAINT_DELETE.ID	COURT_CASE_DELETE.ID
  CRIMINAL_COMPLAINT_INCIDENTS.ID	COURT_CASE_DELETE.ID
  CRIMINAL_COMPLAINT_SUBMIT_LOG.ID	COURT_CASE_DELETE.ID
  CRIMINAL_COMPLAINTS.ID	COURT_CASE_DELETE.ID
  DEGREE_TYPE_CODES.CODE	WEAPON_MAKE_CODES.CODE
  DEL_DISPATCH_EVENT_CASES.DISPATCH_ID	DISPATCH_EVENTS.DISPATCH_ID
  DEL_DISPATCH_EVENT_CASES.INCIDENT_ID	INCIDENTS.INCIDENT_ID
  DEL_DISPATCH_EVENT_OFFICERS.DISPATCH_ID	DISPATCH_EVENTS.DISPATCH_ID
  DEL_DISPATCH_EVENT_OFFICERS.OFFICER_ID	OFFICERS.OFFICER_ID
  DEL_DISPATCH_EVENTS.DISPATCH_ID	DISPATCH_EVENTS.DISPATCH_ID
  DEL_DISPATCH_EVENTS.EVENT_TYPE_CODE	DISPATCH_EVENT_TYPES.EVENT_TYPE_CODE
  DISPATCH_EVENT_OFFICERS.OFFICER_ID	OFFICERS.OFFICER_ID
  DS_IBR_MIGRATION_ERRORS.ID	COURT_CASE_DELETE.ID
  DS_IBR_MIGRATION_ERRORS.INCIDENT_ID	INCIDENTS.INCIDENT_ID
  DS_ICR_ADDL_PROPERTY_ITEMS_GTT.DATASETID	DS_ICR_DATA_SETS.DATASETID
  DS_ICR_ADDL_PROPERTY_ITEMS_GTT.HEADERID	DS_ICR_HEADERS.HEADERID
  DS_ICR_ADDRESSES.ADDRESS_ID	ADDRESSES.ADDRESS_ID
  DS_ICR_ARRESTS.ARREST_ID	ARRESTS.ARREST_ID
  DS_ICR_ARRESTS.INC_PER_ID	INCIDENT_PEOPLE.INC_PER_ID
  DS_ICR_ARRESTS_GTT.ARREST_ID	ARRESTS.ARREST_ID
  DS_ICR_ARRESTS_GTT.DATASETID	DS_ICR_DATA_SETS.DATASETID
  DS_ICR_ARRESTS_GTT.HEADERID	DS_ICR_HEADERS.HEADERID
  DS_ICR_ARRESTS_GTT.INC_PER_ID	INCIDENT_PEOPLE.INC_PER_ID
  DS_ICR_DATA_SETS.AGENCY_CODE	AGENCY_CODES.AGENCY_CODE
  DS_ICR_GROUPB_GTT.ARREST_ID	ARRESTS.ARREST_ID
  DS_ICR_GROUPB_GTT.DATASETID	DS_ICR_DATA_SETS.DATASETID
  DS_ICR_GROUPB_GTT.HEADERID	DS_ICR_HEADERS.HEADERID
  DS_ICR_GROUPB_GTT.INC_PER_ID	INCIDENT_PEOPLE.INC_PER_ID
  DS_ICR_HEADER_FILES.ID	COURT_CASE_DELETE.ID
  DS_ICR_HEADER_MESSAGES.ID	COURT_CASE_DELETE.ID
  DS_ICR_HEADERS_GTT.DATASETID	DS_ICR_DATA_SETS.DATASETID
  DS_ICR_HEADERS_GTT.HEADERID	DS_ICR_HEADERS.HEADERID
  DS_ICR_INC_QRY_SEL_TEMP.INCIDENT_ID	INCIDENTS.INCIDENT_ID
  DS_ICR_INCIDENT_ERRORS.DATASETID	DS_ICR_DATA_SETS.DATASETID
  DS_ICR_INCIDENT_ERRORS.ERROR_ID	ERROR_CODES.ERROR_ID
  DS_ICR_INCIDENT_ERRORS.INCIDENT_ID	INCIDENTS.INCIDENT_ID
  DS_ICR_INSERT_QUEUE.ID	COURT_CASE_DELETE.ID
  DS_ICR_INSERT_QUEUE.INCIDENT_ID	INCIDENTS.INCIDENT_ID
  DS_ICR_OFFENDERS.INC_PER_ID	INCIDENT_PEOPLE.INC_PER_ID
  DS_ICR_OFFENDERS_GTT.DATASETID	DS_ICR_DATA_SETS.DATASETID
  DS_ICR_OFFENDERS_GTT.HEADERID	DS_ICR_HEADERS.HEADERID
  DS_ICR_OFFENDERS_GTT.INC_PER_ID	INCIDENT_PEOPLE.INC_PER_ID
  DS_ICR_OFFENSES.INCIDENT_ID	INCIDENTS.INCIDENT_ID
  DS_ICR_OFFENSES_GTT.DATASETID	DS_ICR_DATA_SETS.DATASETID
  DS_ICR_OFFENSES_GTT.HEADERID	DS_ICR_HEADERS.HEADERID
  DS_ICR_OFFENSES_GTT.INCIDENT_ID	INCIDENTS.INCIDENT_ID
  DS_ICR_ORI_GTT.DATASETID	DS_ICR_DATA_SETS.DATASETID
  DS_ICR_PROPERTY_DRUGS_GTT.DATASETID	DS_ICR_DATA_SETS.DATASETID
  DS_ICR_PROPERTY_DRUGS_GTT.HEADERID	DS_ICR_HEADERS.HEADERID
  DS_ICR_PROPERTY_ITEMS_GTT.DATASETID	DS_ICR_DATA_SETS.DATASETID
  DS_ICR_PROPERTY_ITEMS_GTT.HEADERID	DS_ICR_HEADERS.HEADERID
  DS_ICR_SEGMENTS.INCIDENT_ID	INCIDENTS.INCIDENT_ID
  DS_ICR_VICTIM_SUSPECTS_GTT.DATASETID	DS_ICR_DATA_SETS.DATASETID
  DS_ICR_VICTIM_SUSPECTS_GTT.HEADERID	DS_ICR_HEADERS.HEADERID
  DS_ICR_VICTIMS.INC_PER_ID	INCIDENT_PEOPLE.INC_PER_ID
  DS_ICR_VICTIMS_GTT.DATASETID	DS_ICR_DATA_SETS.DATASETID
  DS_ICR_VICTIMS_GTT.HEADERID	DS_ICR_HEADERS.HEADERID
  DS_ICR_VICTIMS_GTT.INC_PER_ID	INCIDENT_PEOPLE.INC_PER_ID
  DS_ICR_ZERO_GTT.DATASETID	DS_ICR_DATA_SETS.DATASETID
  DS_ICR_ZERO_GTT.HEADERID	DS_ICR_HEADERS.HEADERID
  DV_CRASH_DELETE_LOG.ID	COURT_CASE_DELETE.ID
  DV_CRASH_DELETE_LOG.VEHICLE_ID	DEPARTMENT_VEHICLES.VEHICLE_ID
  DV_OFFICERS.ID	COURT_CASE_DELETE.ID
  DV_ROLE_RESTRICTIONS.ID	COURT_CASE_DELETE.ID
  E_WARRANTS_AUDIT.AGENCY_CODE	AGENCY_CODES.AGENCY_CODE
  E_WARRANTS_AUDIT.WARRANT_ID	E_WARRANTS.WARRANT_ID
  EJS_CODES.CODE	BLOOD_TYPE_CODES.CODE
  EJS_DB_CONFIG_NOTES.NOTE_ID	EJS_NOTES.NOTE_ID
  EJS_FTP.LOGIN_ID	IJIS_USER_PROFILES.LOGIN_ID
  EJS_INC_VALDN_VAR_VALUES.INC_ERR_VALDN_ID	EJS_INC_VLDN_ERRORS.INC_ERR_VALDN_ID
  EJS_INC_VALDN_VAR_VALUES.VARIABLE_ID	EJS_INC_VLDN_ERR_VARIABLES.VARIABLE_ID
  EJS_INC_VLDN_ERRORS.INCIDENT_ID	INCIDENTS.INCIDENT_ID
  EJS_JOB_LOG.LOG_ID	CP_PAYMENT_PARTIES_LOG.LOG_ID
  EJS_NIBRS_DATA_ELEMENTS.ID	COURT_CASE_DELETE.ID
  EJS_NOTES_ANNOTATED.ID	COURT_CASE_DELETE.ID
  EJS_NOTES_ANNOTATIONS.ID	COURT_CASE_DELETE.ID
  EJS_NOTES_FLASHBACK.INCIDENT_ID	INCIDENTS.INCIDENT_ID
  EJS_NOTES_FLASHBACK.NOTE_ID	EJS_NOTES.NOTE_ID
  EJS_REPORT_PARAMETERS.PARAMETER_ID	REPORT_USER_PARAMETERS.PARAMETER_ID
  EJS_XML_DEFAULT_VALUES.TABLE_NAME	APPLICATION_TABLES.TABLE_NAME
  EJS_XML_PARENT_TAG_VALUES.ROW_TAG_ID	EJS_XML_ROW_TAGS.ROW_TAG_ID
  EJSXML_DOCS_PRE_XSLT.DOC_CATEGORY_CODE	XML_DOCUMENT_CATEGORY_CODES.DOC_CATEGORY_CODE
  EJSXML_DOCS_PRE_XSLT.XML_DOC_ID	EJSXML_DOCS.XML_DOC_ID
  EMP_ASSIGNMENT_K9_DOGS.ASSIGN_ID	ASSIGNMENTS.ASSIGN_ID
  EMP_INFO_TYPE_CODE_ROLES.ID	COURT_CASE_DELETE.ID
  EMP_SERVICE_ASSIGN_CODES.CODE	EMP_RANK_TITLE_CODES.CODE
  EMPLOYEE_AFFILIATIONS.ID	COURT_CASE_DELETE.ID
  EMPLOYEE_CLASSIFICATIONS.ID	COURT_CASE_DELETE.ID
  EMPLOYEE_CONTACTS.ID	COURT_CASE_DELETE.ID
  EMPLOYEE_EDUCATION.ID	COURT_CASE_DELETE.ID
  EMPLOYEE_GROUP_EMPLOYEES.ID	COURT_CASE_DELETE.ID
  EMPLOYEE_GROUPS.ID	COURT_CASE_DELETE.ID
  EMPLOYEE_INFO.ID	COURT_CASE_DELETE.ID
  EMPLOYEE_INFO_ATTACHMENTS.ID	COURT_CASE_DELETE.ID
  EMPLOYEE_INFO_IMAGES.ID	COURT_CASE_DELETE.ID
  EMPLOYEE_INFO_TYPE_CODES.ID	COURT_CASE_DELETE.ID
  EMPLOYEE_MISC_IDS.ID	COURT_CASE_DELETE.ID
  EMPLOYEE_SKILLS.ID	COURT_CASE_DELETE.ID
  EVIDENCE_DELETE.AGENCY_CODE	AGENCY_CODES.AGENCY_CODE
  EVIDENCE_DELETE.LOG_ID	ACCESS_LOGS.LOG_ID
  EXPORT_TRANSACTION_LOGS.ARREST_ID	ARRESTS.ARREST_ID
  EXPORT_TRANSACTION_LOGS.PERSON_ID	JAIL_PEOPLE.PERSON_ID
  EXT_SEARCH_LOGIN_HISTORY.MACHINE_NAME	EXT_SEARCH_MNEMONICS.MACHINE_NAME
  EXT_SEARCHES.SEARCH_ID	NARRATIVE_SEARCHES.SEARCH_ID
  EXTERNAL_INFO_REQUEST_PARAMS.PARAMETER_ID	REPORT_USER_PARAMETERS.PARAMETER_ID
  EXTERNAL_INFO_REQUESTS.INTERFACE_ID	SEARCH_INTERFACES.INTERFACE_ID
  EXTERNAL_INFO_REQUESTS.REQUEST_ID	DV_SERVICE_REQUEST.REQUEST_ID
  EXTERNAL_SYSTEM_DELETES.TRANSACTION_ID	EXTERNAL_SYSTEM_EXPUNGEMENTS.TRANSACTION_ID
  FLDINT_DELETE.AGENCY_CODE	AGENCY_CODES.AGENCY_CODE
  FLDINT_DELETE.FLDINT_ID	FIELD_INTERVIEWS.FLDINT_ID
  FLDINT_DELETE.LOG_ID	ACCESS_LOGS.LOG_ID
  GIS_TEMP.ADDRESS_ID	ADDRESSES.ADDRESS_ID
  GIS_TEMP.OFFENSE_CODE	OFFENSE_CODES.OFFENSE_CODE
  GIS_TEMP.SESSIONID	GIS_TEMP_SESSIONS.SESSIONID
  HYBRID_TRANSACTIONS.INDEX_TYPE	HYBRID_TRANSFERS.INDEX_TYPE
  HYBRID_TRANSFERS.DOC_CATEGORY_CODE	XML_DOCUMENT_CATEGORY_CODES.DOC_CATEGORY_CODE
  HYBRID_TRIGGER_TABLES.INDEX_TYPE	HYBRID_TRANSFERS.INDEX_TYPE
  IMPOUND_BUSINESSES.ID	COURT_CASE_DELETE.ID
  IMPOUND_DELETE_LOG.ID	COURT_CASE_DELETE.ID
  IMPOUND_HOLD_OFFS.IMP_HOLD_ID	IMPOUND_HOLDS.IMP_HOLD_ID
  IMPOUND_LOG.LOG_NUM	COURT_PAPER_LOGS.LOG_NUM
  INC_CASE_ROUTING.ROUTE_ID	INCIDENT_ROUTES.ROUTE_ID
  INC_COMMENT_GROUP_COMMENTS.ID	COURT_CASE_DELETE.ID
  INC_COMMENT_GROUPS.ID	COURT_CASE_DELETE.ID
  INC_NARRATIVE_PEOPLE.ID	COURT_CASE_DELETE.ID
  INC_PAGE_VISITS.INCIDENT_ID	INCIDENTS.INCIDENT_ID
  INC_PAGE_VISITS.LOGIN_ID	IJIS_USER_PROFILES.LOGIN_ID
  INC_REVIEW_ROUTE_INSTANCES.ROUTE_LEVEL_ID	INC_REVIEW_ROUTE_LEVELS.ROUTE_LEVEL_ID
  INC_REVIEW_TYPES.ROUTE_ID	INCIDENT_ROUTES.ROUTE_ID
  INC_SUPP_NARR_APPR_UPDATES.INCIDENT_ID	INCIDENTS.INCIDENT_ID
  INC_SUPP_NARR_APPR_UPDATES.NOTE_ID	EJS_NOTES.NOTE_ID
  INCIDENT_DELETE.AGENCY_CODE	AGENCY_CODES.AGENCY_CODE
  INCIDENT_DELETE.LOG_ID	ACCESS_LOGS.LOG_ID
  INCIDENT_LOCATIONS.ID	COURT_CASE_DELETE.ID
  INCIDENT_SUPP_TEMP.INCIDENT_ID	INCIDENTS.INCIDENT_ID
  INCIDENT_WARNING_NOTIFY_LOG.ID	DS_ICR_CAT_QUERIES.ID
  INCIDENT_WARNINGS.TYPE	SOLR_ASYNC_SETTINGS.TYPE
  ITEM_INSPECTION_ITEMS.INSPECTION_RUN_ID	ITEM_INSPECTION_RUNS.INSPECTION_RUN_ID
  ITEM_INSPECTION_ITEMS.INSTANCE_ID	INC_REVIEW_ROUTE_INSTANCES.INSTANCE_ID
  ITEM_LOG_ENTRIES.LOG_ID	CP_PAYMENT_PARTIES_LOG.LOG_ID
  ITEM_VEHICLE_DESCRIPTORS.DESCRIPTOR_ID	ITEM_GUN_DESCRIPTORS.DESCRIPTOR_ID
  K9_ATTACHMENTS.K9_ID	K9_DOGS.K9_ID
  K9_MEDICAL.CLINIC_ID	K9_CLINIC_CODES.CLINIC_ID
  K9_MEDICAL.K9_ID	K9_DOGS.K9_ID
  MAP_EVENT_TYPES_TEMP.EVENT_TYPE_CODE	DISPATCH_EVENT_TYPES.EVENT_TYPE_CODE
  MAP_ICONS.ID	COURT_CASE_DELETE.ID
  MASTER_INDEX_DELETE_LOG.LOG_ID	CP_PAYMENT_PARTIES_LOG.LOG_ID
  MASTER_PERSON_TEMP.MASTER_PERSON_ID	MASTER_PEOPLE.MASTER_PERSON_ID
  NARRATIVE_SEARCH_RESULTS.SEARCH_ID	NARRATIVE_SEARCHES.SEARCH_ID
  NARRATIVE_TEMPLATES.TEMPLATE_ID	PRINT_TEMPLATES.TEMPLATE_ID
  NOTIFICATION_AUDITS.ID	COURT_CASE_DELETE.ID
  NOTIFICATION_DETAILS.AGENCY_CODE	AGENCY_CODES.AGENCY_CODE
  NOTIFICATION_DETAILS_DATA.ID	COURT_CASE_DELETE.ID
  OFFENSE_ACTIVITIES.ACTIVITY_ID	ACTIVITIES.ACTIVITY_ID
  OFFENSE_GROUP_OFFENSES.ID	COURT_CASE_DELETE.ID
  OFFENSE_GROUPS.ID	COURT_CASE_DELETE.ID
  OFFICER_IDS_TEMP.OFFICER_ID	OFFICERS.OFFICER_ID
  PAWN_TICKETS.ID	DS_ICR_CAT_QUERIES.ID
  PEOPLE_WARRANTS.INC_PER_ID	INCIDENT_PEOPLE.INC_PER_ID
  PERSON_ADDR_HISTORY.ADDRESS_ID	ADDRESSES.ADDRESS_ID
  PERSON_ADDR_HISTORY.PERSON_ID	JAIL_PEOPLE.PERSON_ID
  PERSON_ADDR_PHONES.ADDRESS_ID	ADDRESSES.ADDRESS_ID
  PERSON_ADDR_PHONES.PERSON_ID	JAIL_PEOPLE.PERSON_ID
  PERSON_CAUTIONS.ID	COURT_CASE_DELETE.ID
  PHOTO_LINEUP_CASES.ID	COURT_CASE_DELETE.ID
  PHOTO_LINEUP_DELETE.PHOTO_LINEUP_ID	PHOTO_LINEUP.PHOTO_LINEUP_ID
  PHOTO_LINEUP_LIBRARY.ID	COURT_CASE_DELETE.ID
  PLAN_TABLE.ID	COURT_CASE_DELETE.ID
  PROFILE_SCREEN_ITEMS.INSTANCE_ID	INC_REVIEW_ROUTE_INSTANCES.INSTANCE_ID
  PROPERTIES_AUDIT.GUN_MAKE_ID	GUN_MAKE_CODES.GUN_MAKE_ID
  PROPERTIES_AUDIT.INDX_SEC_LEVEL_CODE	MASTER_INDEX_SECURITY_CODES.INDX_SEC_LEVEL_CODE
  PROPERTIES_AUDIT.PROP_AUDIT_ID	ARREST_PROPERTIES_AUDIT.PROP_AUDIT_ID
  PROPERTIES_AUDIT.PROPERTY_ID	PROPERTIES.PROPERTY_ID
  PROPERTY_HOLD_CUSTODIES.ID	COURT_CASE_DELETE.ID
  PROPERTY_HOLD_LOCATIONS.ID	COURT_CASE_DELETE.ID
  PROPERTY_HOLDS.ID	COURT_CASE_DELETE.ID
  REPORT_CATEGORIES.CATEGORY_ID	ITEM_CATEGORY_CODES.CATEGORY_ID
  REPORT_PARAMETER_INSTANCES.INSTANCE_ID	ITEM_INSTANCES.INSTANCE_ID
  RMS_ALERTS.ID	COURT_CASE_DELETE.ID
  ROUTE_ACTION_INST_AGENCIES.ID	COURT_CASE_DELETE.ID
  ROUTE_ACTION_INST_ROLES.ID	COURT_CASE_DELETE.ID
  ROUTE_INSTANCE_AGENCIES.ID	COURT_CASE_DELETE.ID
  ROUTE_INSTANCE_ROLES.ID	COURT_CASE_DELETE.ID
  RV_ACCESS_CHAIN_NODES.CHAIN_ID	RV_ACCESS_CHAINS.CHAIN_ID
  RV_ACCESSORS.ID	COURT_CASE_DELETE.ID
  RV_ATTRIBUTES.ATTRIBUTE_CODE	INC_VALID_ATTRIBUTES.ATTRIBUTE_CODE
  RV_CONDITION_FACTORS.ID	COURT_CASE_DELETE.ID
  RV_CONDITION_PROPERTIES.ID	COURT_CASE_DELETE.ID
  RV_CUSTOM_OBJECTS.ID	COURT_CASE_DELETE.ID
  RV_CUSTOM_OBJECTS.TYPE_CODE	VEHICLE_TYPE_CODES.TYPE_CODE
  RV_MODULE_SCREEN_TYPES.OPERATOR_CODE	RV_OPERATOR_CODES.OPERATOR_CODE
  RV_PROPERTIES.PROPERTY_ID	PROPERTIES.PROPERTY_ID
  RV_PROPERTY_VARIABLES.VARIABLE_CODE	RV_VARIABLES.VARIABLE_CODE
  SCREEN_TYPE_SCREEN_PDF_FIELDS.ID	COURT_CASE_DELETE.ID
  SCREEN_TYPE_SCREEN_PDFS.ID	COURT_CASE_DELETE.ID
  SEARCH_INT_RESULTS_ACCESS.ID	COURT_CASE_DELETE.ID
  SEARCH_INTERFACE_RESULTS.ID	COURT_CASE_DELETE.ID
  SOLR_UPDATE_ID_TMP.ID	COURT_CASE_DELETE.ID
  STAGING_OFFENSES.ARREST_CHARGE_CODE	ARREST_CHARGE_CODES.ARREST_CHARGE_CODE
  STAGING_OFFENSES.OFFENSE_CODE	OFFENSE_CODES.OFFENSE_CODE
  SUB_BEAT_CODES.SHAPE_ID	MAP_SHAPES.SHAPE_ID
  SUBSCRIPTIONS_QUEUE.SUB_TYPE_CODE	SUBSCRIPTION_TYPE_CODES.SUB_TYPE_CODE
  TAG_CASES.ID	COURT_CASE_DELETE.ID
  TAGS.ID	COURT_CASE_DELETE.ID
  TOAD_PLAN_TABLE.ID	COURT_CASE_DELETE.ID
  TRACE_ENTRIES.LOGIN_ID	IJIS_USER_PROFILES.LOGIN_ID
  TRAINING_TYPE_CODES.CODE	WEAPON_MAKE_CODES.CODE
  UCR_ARRESTEES_GTT.IBR_SEGMENT	DS_IBR_SEGMENTS.IBR_SEGMENT
  UCR_HEADERS_GTT.IBR_SEGMENT	DS_IBR_SEGMENTS.IBR_SEGMENT
  UCR_O_RANK_GTT.DATASETID	DS_ICR_DATA_SETS.DATASETID
  UCR_OFFENSES_GTT.IBR_SEGMENT	DS_IBR_SEGMENTS.IBR_SEGMENT
  UCR_VICTIMS_GTT.IBR_SEGMENT	DS_IBR_SEGMENTS.IBR_SEGMENT
  USER_FIELD_OFFENSE_VALUES.INST_OFF_VALUE_ID	USER_FIELD_OFF_VALUES.INST_OFF_VALUE_ID
  USER_FIELD_ROWS.ROW_ID	EVIDENCE_LABEL_ROWS.ROW_ID
  USER_GROUP_USERS.ID	DS_ICR_CAT_QUERIES.ID
  USER_GROUPS.ID	DS_ICR_CAT_QUERIES.ID
  USER_LOV_CODES.CODE	EXTERNAL_SYSTEM_CODES.CODE
  USER_PINNED_RECORDS.ID	COURT_CASE_DELETE.ID
  USER_PINNED_RECORDS.RECORD_ID	EXPORT_RECORDS.RECORD_ID
  USER_SCREEN_AUDIT_LOG.AUDIT_ID	HOME_AGENCY_AUDIT.AUDIT_ID
  USER_SCREEN_DELETE_AUDIT.ID	COURT_CASE_DELETE.ID
  USER_SCREEN_DELETE_AUDIT.SCREEN_ID	MAP_USER_SCREENS.SCREEN_ID
  USER_SCREEN_INSTANCE_DELETE.ID	COURT_CASE_DELETE.ID
  USER_SCREEN_INSTANCE_DELETE.INSTANCE_ID	ITEM_INSTANCES.INSTANCE_ID
  USER_SCREEN_INSTANCE_DELETE.SCREEN_ID	MAP_USER_SCREENS.SCREEN_ID
  USER_SCREEN_INSTANCES.INSTANCE_ID	INC_REVIEW_ROUTE_INSTANCES.INSTANCE_ID
  USI_CITATION_FIELDS.INSTANCE_ID	INC_REVIEW_ROUTE_INSTANCES.INSTANCE_ID
  VISIBILITY_CODES.CODE	ENROLLMENT_STATUS_CODES.CODE
  WARRANT_DELETE.LOG_ID	ACCESS_LOGS.LOG_ID
  WARRANT_LOG.LOG_NUM	COURT_PAPER_LOGS.LOG_NUM
  WARRANT_OFFICERS.ID	DS_ICR_CAT_QUERIES.ID
  WARRANT_REFERENCES.WARRANT_REFERENCE_ID	WARRANT_REFERENCES_DELETE.WARRANT_REFERENCE_ID
  WARRANT_REFERENCES_AUDIT.AUDIT_ID	HOME_AGENCY_AUDIT.AUDIT_ID
  WARRANT_REFERENCES_AUDIT.WARRANT_REFERENCE_ID	WARRANT_REFERENCES_DELETE.WARRANT_REFERENCE_ID
  WARRANT_SERVICE_ADDRESSES.ID	DS_ICR_CAT_QUERIES.ID
  WARRANT_SERVING_OFFICERS.LOG_ID	ACCESS_LOGS.LOG_ID
  WEAPON_MODEL_CODES.CODE	ENROLLMENT_STATUS_CODES.CODE
  WEAPON_TYPE_CODES.CODE	ENROLLMENT_STATUS_CODES.CODE
  ZZ_AGENCY_CODES.AGENCY_CODE	AGENCY_CODES.AGENCY_CODE
  ZZ_AGENCY_CODES.IMAGE_ID	IMAGES.IMAGE_ID
  ZZ_ARREST_CHARGE_CODES.ARREST_CHARGE_CODE	ARREST_CHARGE_CODES.ARREST_CHARGE_CODE
  ZZ_ARREST_CHARGE_CODES.OFFENSE_CODE	OFFENSE_CODES.OFFENSE_CODE
  ZZ_CHARGE_CODES.ARREST_CHARGE_CODE	ARREST_CHARGE_CODES.ARREST_CHARGE_CODE
  ZZ_CHARGE_CODES.CHARGE_CATEGORY_CODE	CHARGE_CATEGORY_CODES.CHARGE_CATEGORY_CODE
  ZZ_CHARGE_CODES.CODE	BLOOD_TYPE_CODES.CODE
  ZZ_EJS_CODE_NIBRS_MAPPINGS.CODE	BLOOD_TYPE_CODES.CODE
  ZZ_EJS_CODE_NIBRS_MAPPINGS.NIBRS_CODE	NIBRS_CODES.NIBRS_CODE
  ZZ_EJS_CODES.CODE	BLOOD_TYPE_CODES.CODE
  ZZ_GUN_MAKE_CODES.GUN_MAKE_ID	GUN_MAKE_CODES.GUN_MAKE_ID
  ZZ_NIBRS_CODE_EJS_MAPPINGS.CODE	BLOOD_TYPE_CODES.CODE
  ZZ_NIBRS_CODE_EJS_MAPPINGS.NIBRS_CODE	NIBRS_CODES.NIBRS_CODE
  ZZ_NIBRS_CRIME_TARGETS.NIBRS_CODE	NIBRS_CODES.NIBRS_CODE
  ZZ_NIBRS_LESSER_OFFENSES.NIBRS_CODE	NIBRS_CODES.NIBRS_CODE
  ZZ_NIBRS_OFFENSES.NIBRS_CODE	NIBRS_CODES.NIBRS_CODE
  ZZ_NIBRS_OFFENSES.OFFENSE_CODE	OFFENSE_CODES.OFFENSE_CODE
  ZZ_NIBRS_PROP_MAPPINGS.CODE	BLOOD_TYPE_CODES.CODE
  ZZ_NIBRS_PROP_MAPPINGS.NIBRS_CODE	NIBRS_CODES.NIBRS_CODE
  ZZ_NIBRS_PROP_MAPPINGS.NIBRS_PROP_ID	NIBRS_PROP_MAPPINGS.NIBRS_PROP_ID
  ZZ_NIBRS_PROP_MAPPINGS.PROPERTY_CODE	INC_VALID_PROPERTIES.PROPERTY_CODE
  ZZ_OFFENSE_CODES.OFFENSE_CODE	OFFENSE_CODES.OFFENSE_CODE
  ZZ_TOW_COMPANY_CODES.TOWING_CO_ID	TOW_COMPANY_CODES.TOWING_CO_ID

  335 instances of anomaly detected

• Tables without indexes:

  Table
  AGENCY_CODES_TEMP
  DATASETID_GTT
  DIR_LIST
  DS_ICR_ADDL_PROPERTY_ITEMS_GTT
  DS_ICR_ARRESTS_GTT
  DS_ICR_GROUPB_GTT
  DS_ICR_HEADERS_GTT
  DS_ICR_INC_QRY_SEL_TEMP
  DS_ICR_OFFENDERS_GTT
  DS_ICR_OFFENSES_GTT
  DS_ICR_ORI_GTT
  DS_ICR_PROPERTY_DRUGS_GTT
  DS_ICR_PROPERTY_ITEMS_GTT
  DS_ICR_VICTIM_SUSPECTS_GTT
  DS_ICR_VICTIMS_GTT
  DS_ICR_ZERO_GTT
  DS_NIBR_PIVOT_GTT
  INCIDENT_SUPP_TEMP
  MAP_EVENT_TYPES_TEMP
  MASTER_INDX_AUDITING
  MASTER_PERSON_TEMP
  OFFICER_IDS_TEMP
  PHOTO_LINEUP_IMAGE_TEMP
  PLAN_TABLE
  STAGING_OFFENSES
  TOAD_PLAN_TABLE
  TRANSACTION_CONTROL
  UCR_ARRESTEES_GTT
  UCR_COL_TBL_GTT
  UCR_DISP_GTT
  UCR_HEADERS_GTT
  UCR_I_RANK_GTT
  UCR_LEOKA_BASE_GTT
  UCR_LEOKA_DISP_GTT
  UCR_LEOKA_DS_WEP_HIER_GTT
  UCR_LEOKA_ROOT_GTT
  UCR_LEOKA_VICTIM_GTT
  UCR_LEOKA_WEP_HIRE_GTT
  UCR_MOTO_GTT
  UCR_O_RANK_GTT
  UCR_OFFENSES_GTT
  UCR_PIVOT_GTT
  UCR_PLOSS_GTT
  UCR_PROPERTY_GTT
  UCR_ROOT_DS_GTT
  UCR_ROOT_RANK_COL_2_GTT
  UCR_ROOT_RANK_COL_3_GTT
  UCR_ROOT_RANK_COL_4_GTT
  UCR_ROOT_RANK_COL_5_GTT
  UCR_ROOT_RANK_COL_6_GTT
  UCR_VICTIMS_GTT
  ZZ_AGENCY_CODES
  ZZ_ARREST_CHARGE_CODES
  ZZ_CHARGE_CODES
  ZZ_DS_ICR_FILE_REFERENCES
  ZZ_EJS_CODE_NIBRS_MAPPINGS
  ZZ_EJS_CODES
  ZZ_EJS_SUB_MAINT
  ZZ_GUN_MAKE_CODES
  ZZ_NIBRS_CODE_EJS_MAPPINGS
  ZZ_NIBRS_CRIME_TARGETS
  ZZ_NIBRS_LESSER_OFFENSES
  ZZ_NIBRS_OFFENSES
  ZZ_NIBRS_PROP_MAPPINGS
  ZZ_OFFENSE_CODES
  ZZ_TOW_COMPANY_CODES

  66 instances of anomaly detected

• Columns that are flagged as both 'nullable' and 'must be unique':

  Column
  ACCESS_LOGS.ACCESS_TIMESTAMP
  ACCESS_LOGS.ACCESS_TYPE_CODE
  ACCESS_LOGS.ACCESS_TYPE_CODE_TYPE
  ACCESS_LOGS.AGENCY_CODE
  ACCESS_LOGS.MODULE_CODE
  ACCESS_LOGS.RECORD_ID
  ACCESS_LOGS.USER_NAME
  CALENDAR_SHIFT_USERS.EMPLOYEE_ID
  CALENDAR_SHIFT_USERS.OFFICER_ID
  DISPATCH_EVENTS.AGENCY
  DISPATCH_EVENTS.DISPATCH_NUMBER
  DV_FUEL_OIL.ASSIGNMENT_VEHICLE_ID
  EJS_INC_REPORT_VALIDATIONS.ACTION_NAME
  EJS_INC_REPORT_VALIDATIONS.ERROR_ID
  MASTER_REPORTS.EXTERNAL_ID
  PRINT_TEMPLATES.EXTERNAL_ID
  REPORT_UNITS.RESOURCE_NAME
  RV_ACCESSORS.ROOT_OBJECT_CODE
  USER_SCREENS.FORM_NUMBER

  19 instances of anomaly detected

• Tables that contain a single column:

  Table	Column
  DATASETID_GTT	DATASETID
  TRANSACTION_CONTROL	TRANSACTION_CONTROL_SEQ
  UCR_ROOT_RANK_COL_3_GTT	INCIDENT
  UCR_ROOT_RANK_COL_4_GTT	INCIDENT
  UCR_ROOT_RANK_COL_5_GTT	INCIDENT
  UCR_ROOT_RANK_COL_6_GTT	INCIDENT

  6 instances of anomaly detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  ADDRESS_COLLAPSE_LOG
  ADDRESS_COMMON_NAMES_VW
  ADDRESSES
  ADDRESSES_SEARCH_VW
  ALL_ADDRESS_COMMON_NAMES_VW
  ATTACHMENTS_VW
  BI_CALLS_FOR_SERVICE_VW
  BOLO_DESCRIPTOR_CODES
  BUS_ADDR_ALARM_VW
  BUS_ADDR_BUS_REL_VW
  BUS_ADDR_EMP_VW
  BUS_ADDR_PEOP_VW
  BUS_ADDR_PERMIT_VW
  BUSINESS_ADDRESS_VW
  BUSINESS_RMS_SEARCH_VW
  BUSINESS_VEHICLES_VW
  BUSINESSES_SEARCH_VW
  CASE_SEARCH_ADDRESS_VW
  CITATION_ADDRESS_VW
  COURT_LOCATION_CODES
  DEL_DISPATCH_EVENTS
  DISPATCH_EVENT_PEOPLE
  DISPATCH_EVENT_PEOPLE_VW
  DISPATCH_EVENTS
  DISPATCH_SEARCH_VW
  DISPATCH_VW
  DS_ICR_ADDL_PROPERTY_ITEMS_GTT
  DS_ICR_ADDRESSES
  DS_ICR_ARRESTS
  DS_ICR_ARRESTS_GTT
  DS_ICR_GROUPB_GTT
  DS_ICR_HEADERS_GTT
  DS_ICR_MORE_DATA
  DS_ICR_OFFENSES
  DS_ICR_OFFENSES_GTT
  DS_ICR_ORI_GTT
  DS_ICR_PROPERTY_ITEMS
  DS_ICR_PROPERTY_ITEMS_GTT
  DS_ICR_SEGMENTS
  DS_ICR_VICTIMS
  DS_ICR_VICTIMS_GTT
  DS_NIBR_PIVOT
  DS_NIBR_PIVOT_GTT
  DS_NIBRS_ARRESTS_VW
  DS_NIBRS_GROUPB_VW
  DS_NIBRS_HEADERS_VW
  DS_NIBRS_OFFENDERS_VW
  DS_NIBRS_OFFENSES_VW
  DS_NIBRS_PROPERTY_VW
  DS_NIBRS_VICTIMS_VW
  EJS_SUB_MAINT
  EXPORT_FIELDS
  EXT_SEARCH_PARAMETERS
  FLDINT_ADD_VW
  INC_COMMENT_GROUP_COMMENTS
  INC_FLD_CONTACT_ADDRESSES_VW
  INCIDENT_ADDRESS_VW
  INCIDENT_BAIR_EXTRACT_VW
  INCIDENT_CRIME_TARGET_VW
  INCIDENT_DISPATCH_VW
  INCIDENT_GIS_VW
  INCIDENT_OFFENSE_ADDRESSES_VW
  INCIDENT_PERSON_OFFENSES_VW
  INCIDENT_RECOVERY_VW
  IX_PERSON_SUMMARY_VW
  JAIL_PEOPLE
  JS_BAIR_PERSON_VW
  JS_DS_NIBRS_ARRESTS_VW
  JS_DS_NIBRS_GROUPB_VW
  JS_DS_NIBRS_HEADERS_VW
  JS_DS_NIBRS_OFFENDERS_VW
  JS_DS_NIBRS_OFFENSES_VW
  JS_DS_NIBRS_PROPERTY_VW
  JS_DS_NIBRS_VICTIMS_VW
  JS_FIELD_ARREST_CHARGE_VW
  JS_FIELD_ARREST_VW
  JS_FIELD_CONTACT_ADDRESS_VW
  JS_FIELD_CONTACT_VW
  JS_INCIDENT_ADDRESS_VW
  JS_INCIDENT_OFFENSE_VW
  JS_USERS_VW
  LSI_ADDRESSES_VW
  MAP_EVENT_VW
  MAP_USER_SCREENS
  MAPPING_TYPE_CODES
  N_INCIDENT_PERSON_OFFENSES_VW
  NARRATIVE_SEARCH_RESULTS
  NARRATIVE_SEARCHES
  NIBRS_TAB_COLS
  NOTIFICATION_AUDITS
  NOTIFICATION_DEF_MASTERS
  NOTIFICATION_DETAILS
  PEOPLE_ADDRESS_VW
  PEOPLE_COMBO_VW
  PEOPLE_JAIL_SEARCH_VW
  PEOPLE_SEARCH_ONEADDRESS_VW
  TDEX_RMS_ARRESTEE_VW
  TDEX_RMS_OFFENSE_VW
  TDEX_RMS_SUSPECT_VW
  UCR_ARRESTEES_GTT
  UCR_COL_TBL_GTT
  UCR_HEADERS_GTT
  UCR_I_RANK_GTT
  UCR_LEOKA_BASE_GTT
  UCR_LEOKA_DS_WEP_HIER_GTT
  UCR_LEOKA_ROOT_GTT
  UCR_LEOKA_VICTIM_GTT
  UCR_LEOKA_WEP_HIRE_GTT
  UCR_MOTO_GTT
  UCR_O_RANK_GTT
  UCR_OFFENSES_GTT
  UCR_PIVOT_GTT
  UCR_PROPERTY_GTT
  UCR_ROOT_DS_GTT
  UCR_ROOT_RANK_COL_2_GTT
  UCR_VICTIMS_GTT
  UFI_FIELDARRESTS_ADDRESS_VW
  UFI_FIELDARRESTS_CHARGE_VW
  UFI_FIELDARRESTS_PERSON_VW
  UFI_FIELDARRESTS_VEHICLE_VW
  UFI_INCIDENTS_ADDRESS_VW
  UFI_INCIDENTS_OFFENSE_VW
  UFI_INCIDENTS_ORGANIZATION_VW
  UFI_INCIDENTS_PERSON_VW
  UFI_INCIDENTS_PROPERTY_VW
  UFI_INCIDENTS_VEHICLE_VW
  USER_DEFINED_DATA
  USER_SCREEN_TYPES
  USER_SCREEN_VIEWS
  WARRANT_PERSON_ADDR_VW
  ZZ_EJS_SUB_MAINT
  ZZC1_EJS_SUB_MAINT
  ZZV1_EJS_SUB_MAINT

  133 instances of anomaly detected

• Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended:

  Column
  ADDRESSES.ADDR_SC_ADDRESS_SUBTYPE_C_TYPE
  ADDRESSES.CITY_CD_CITY_CODE_TYPE
  ADDRESSES.CNTRY_CD_COUNTRY_TYPE_COD_TYPE
  ADDRESSES.CNTY_CD_COUNTY_CODE_TYPE
  ADDRESSES.DIRCT_CD_DIRECTION_CODE_TYPE
  ADDRESSES.DIRECT_SUFFIX_TYPE
  ADDRESSES.INTRSECT1_DIR_SUFFIX_TYPE
  ADDRESSES.INTRSECT1_DIR_TYPE
  ADDRESSES.INTRSECT1_STREET_TYPE_COD_TYPE
  ADDRESSES.INTRSECT2_DIR_TYPE
  ADDRESSES.STATE_CD_STATE_CODE_TYPE
  ADDRESSES.STREET_CD_STREET_TYPE_COD_TYPE
  ADDRESSES.VERIFY_STATUS_CODE_TYPE
  AGENCY_CODES.JRD_AGENCY_TYPE_TYPE
  AGENCY_CODES.OFFICE_CODE_TYPE
  AGENCY_CODES.POC_TITLE_CODE_TYPE
  BUSINESS_COLLAPSE_LOG.BTC_TYPE_CODE_TYPE
  BUSINESSES.BTC_TYPE_CODE_TYPE
  CASE_TYPE_CODES.CC1_CODE_TYPE
  CITATIONS.CITY_CODE_TYPE
  COLLAPSED_MASTER_NAMES.TITLE_CODE_TYPE
  CSAU_CODES.AC_CD_CODE_TYPE
  DV_CRASH_TOWS.STATE_CD_STATE_CODE_TYPE
  EJS_REPORTS.GROUP_CODE_TYPE
  EJS_XML_TAG_NAMES.TAG_TYPE_CODE_TYPE
  EMP_RANK_TITLE_CODES.EMP_TYPE_CODE_TYPE
  EMP_SERVICE_ASSIGN_CODES.EMP_TYPE_CODE_TYPE
  EMPLOYEES.DL_STATE_CODE_TYPE
  EMPLOYEES.EMP_TYPE_CODE_TYPE
  EMPLOYEES.ETHNICITY_CODE_TYPE
  EMPLOYEES.RACE_CODE_TYPE
  EMPLOYEES.SEX_CODE_TYPE
  EMPLOYEES.TITLE_CODE_TYPE
  EMPLOYMENTS.EMPLOYMENT_CODE_TYPE
  EVIDENCE.DISPOSITION_CODE_TYPE
  EVIDENCE.STATUS_CODE_TYPE
  EXT_SEARCH_PARAMETERS.TYPE_CODE_TYPE
  EXT_SEARCH_RESULTS.STATUS_CODE_TYPE
  FIELD_INTERVIEWS.FLDINT_TYPE_TYPE
  IMPOUND.IMP_DISP_CODE_TYPE
  INCIDENT_CASES.SC1_SOLVABILITY_CODE_TYPE
  INCIDENT_DELETE.NEW_STATUS_CODE_TYPE
  INCIDENT_DELETE.OLD_STATUS_CODE_TYPE
  INCIDENT_PEOPLE.RES_ST_CD_RESIDENT_STATUS_TYPE
  INCIDENT_PEOPLE.VICTM_CD_VICTIM_TYPE_CODE_TYPE
  INCIDENTS.CARGO_THEFT_CODE
  INCIDENTS.CARGO_THEFT_CODE_TYPE
  INCIDENTS.PUBLIC_FLAG
  JAIL_PEOPLE.BIRTH_COUNTRY_TYPE
  JAIL_PEOPLE.BIRTH_STATE_TYPE
  JAIL_PEOPLE.CITIZENSHIP_COUNTRY_TYPE
  K9_ACTIVITY.ACTIVITY_CODE_TYPE
  K9_MISC_IDS.COUNTRY_TYPE_CODE_TYPE
  K9_MISC_IDS.MISC_ID_TYPE_TYPE
  K9_MISC_IDS.STATE_CODE_TYPE
  LANGUAGES.M_LC_CODE_TYPE
  LANGUAGES.S_LC_CODE_TYPE
  LEGAL_SEARCH_INDEX.VEH_STATE_CODE_TYPE
  LIENHOLDERS.CITY_CD_CITY_CODE_TYPE
  LIENHOLDERS.STATE_CD_STATE_CODE_TYPE
  MASTER_NAMES.TITLE_CODE_TYPE
  MILITARY_SERVICE.LAST_ASSIGNED_STATE_CODE_TYPE
  MILITARY_SERVICE.MRC_REASON_CODE_TYPE
  MISC_IDS.CNTRY_CD_COUNTRY_TYPE_COD_TYPE
  MISC_IDS.MISC_ID_TYPE_TYPE
  MISC_IDS.STATE_CD_STATE_CODE_TYPE
  NIBR_SUBMISSION_FORMAT_TYPES.STC_SUBMISSION_TYPE_CODE_TYPE
  NOTIFICATION_DEF_MASTERS.JRD_AGENCY_TYPE_TYPE
  OFFENSE_STATUS_CODES.ENIBR_EXCEPTION_CLEARANCE_TYPE
  OFFENSES.CAMPUS_CODE_TYPE
  OFFENSES.FEC_FORCED_ENTRY_CODE_TYPE
  OFFICER_ROLE_CODES.INTAKE_ROLE_CODE_TYPE
  PEOPLE_WARRANTS.PWS_CODE_TYPE
  PERMIT_BUSINESSES.PERMIT_ROLE_CODE_TYPE
  PERMIT_PEOPLE.PERMIT_ROLE_CODE_TYPE
  PERMITS.PERMIT_REASON_CODE_TYPE
  PERSON_ADDR_HISTORY.ADDR_SOURCE_CODE_TYPE
  PERSON_ADDRESSES.ADDR_SOURCE_CODE_TYPE
  PERSON_IMAGES.MC1_MUGSHOT_CODE_TYPE
  PHYSICAL_DESCRIPTIONS.BLD_CD_BUILD_CODE_TYPE
  PHYSICAL_DESCRIPTIONS.EYE_CD_EYE_CODE_TYPE
  PHYSICAL_DESCRIPTIONS.FACE_HR_FACIAL_HAIR_TYPE
  PHYSICAL_DESCRIPTIONS.HAIR_CD_HAIR_CODE_TYPE
  PHYSICAL_DESCRIPTIONS.HAIR_LNGTH_HAIR_LENGTH_CO_TYPE
  PHYSICAL_DESCRIPTIONS.SKN_CD_SKIN_CODE_TYPE
  PROPERTIES.CALGAG_CODE_TYPE
  PROPERTIES.CURRENCY_CODE
  PROPERTIES.CURRENCY_CODE_TYPE
  PROPERTIES.DRUG_TYPE_TYPE
  PROPERTIES.GUN_ACT_CODE_TYPE
  PROPERTIES.GUN_TYP_CODE_TYPE
  PROPERTIES.PRIMARY_COLOR_TYPE
  PROPERTIES.SECONDARY_COLOR_TYPE
  PROPERTIES.TYPE_OF_QUANTITY_TYPE
  SCHEDULES.MONTHLY_OCCUR_CODE_TYPE
  TOW_COMPANY_CODES.TOWING_CO_STATE_TYPE
  TOWS.CITY_CD_CITY_CODE_TYPE
  TOWS.STATE_CD_STATE_CODE_TYPE
  USER_DATA_FIELDS.ULTC_TYPE_CODE_TYPE
  VEHICLE_DESCRIPTIONS.COND_CODE_TYPE
  VEHICLE_DESCRIPTIONS.DAMAGE_CODE_TYPE
  VEHICLE_DESCRIPTIONS.LIC_STATE_CODE_TYPE
  VEHICLE_DESCRIPTIONS.LIC_TYPE_CODE_TYPE
  VICTIMS.ACTIVITY_TYPE_CODE_TYPE
  VICTIMS.ASSIGNMENT_TYPE_CODE_TYPE
  VICTIMS.VICTM_CD_VICTIM_TYPE_CODE_TYPE
  XML_DOCUMENT_CATEGORY_CODES.STATUS_CODE_TYPE

  107 instances of anomaly detected