Table slot9.WORLD.TSTA.OFFICERS
This table stores officer information created in the application
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
OFFICER_ID number 0
ARREST_OFFICERS.OFFICER_ID AO_OFF1_FK R
ARREST_PROPERTIES.RELEASE_OFFICER_ID ARP_OFF1_REL_FK R
ARREST_PROPERTIES.SEIZING_OFFICER_ID ARP_OFF1_FK R
ARREST_PROPERTIES_AUDIT.RELEASE_OFFICER_ID ARPA_OFF_REL_FK R
ARREST_PROPERTIES_AUDIT.SEIZING_OFFICER_ID ARPA_OFF1_FK R
ARRESTS.JAIL_STAFF_ID ARR_JS_FK R
ASSIGNMENT_LOGS.OFFICER_ID AL_OFF_FK R
CALENDAR_ASSIGNMENTS.OFFICER_ID Implied Constraint R
CALENDAR_ASSIGNMENTS_AUDIT.OFFICER_ID Implied Constraint R
CALENDAR_SHIFT_USERS.OFFICER_ID CALSHIFTU_OFF1_FK R
CASE_ACTIVITY_ASSIGNMENTS.OFFICER_ID CASE_ACT_ASSGN_OFF1_FK R
CASE_ASSIGNMENT_HISTORIES.ASSIGNED_BY CAH_OFF1_ASSIGNED_BY_FK R
CASE_ASSIGNMENT_HISTORIES.ENDED_BY CAH_OFF1_ENDED_BY_FK R
CASE_ASSIGNMENT_HISTORIES.OFFICER_ID CAH_OFF1_FK R
CASE_GROUP_OFFICERS.OFFICER_ID CASE_GRP_OFF_OFF1_FK R
CITATION_OFFICERS.OFFICER_ID CITOFF_OFF1_FK R
COURT_APPEARANCE_OFFS.OFFICER_ID CRTAPPOFF_OFF1_FK R
COURT_APPEARANCE_SEARCH_VW.OFFICER_ID Implied Constraint R
COURT_CASE_APP_SEARCH_VW.OFFICER_ID Implied Constraint R
COURT_CASE_OFFS.OFFICER_ID CRTCASEOFF_OFF1_FK R
COURT_CASE_SEARCH_VW.OFFICER_ID Implied Constraint R
COURT_PAPER_LOGS.OFFICER_ID CPAP_LOG_OFF1_FK R
COURT_PAPER_OFFICERS.OFFICER_ID CPOFF_OFF1_FK R
CRIMINAL_COMPLAINT_SEARCH_VW.OFFICER_ID Implied Constraint R
CRIMINAL_COMPLAINTS.COMPLAINTANT_OFF_ID CRMCMP_OFF1_FK R
DEL_DISPATCH_EVENT_OFFICERS.OFFICER_ID Implied Constraint R
DISPATCH_EVENT_OFFICERS.OFFICER_ID Implied Constraint R
DV_CRASH_INSURANCE_VW.OFFICER_ID Implied Constraint R
DV_CRASH_REFERENCES_VW.OFFICER_ID Implied Constraint R
DV_CRASH_SERVICE_RECORDS_VW.OFFICER_ID Implied Constraint R
DV_CRASH_SERVICE_REPAIRS_VW.OFFICER_ID Implied Constraint R
DV_CRASH_TOWS_VW.OFFICER_ID Implied Constraint R
DV_CRASHES.OFFICER_ID CRASH_OFF1_FK R
DV_CRASHES_VW.OFFICER_ID Implied Constraint R
DV_OFFICERS.OFFICER_ID DVOFF_OFF1_FK R
EMPLOYEES.OFFICER_ID EMP1_OFF_1_FK R
EVIDENCE.OFF1_OFFICER_ID EVI_OFF1_FK R
EVIDENCE_OFFICERS.OFF1_OFFICER_ID EVIDOFF_OFF1_FK R
FLDINT_OFF_VW.OFFICER_ID Implied Constraint R
FLDINT_OFFICERS.OFFICER_ID FLDO_OFF1_FK C
IMP_VEH_OFFICERS_VW.OFFICER_ID Implied Constraint R
IMPOUND_HOLD_OFFS.HOLD_OFF_ID HLDOFF_OFF1_FK R
IMPOUND_OFFICERS.OFFICER_ID IMPOFF_OFF1_FK R
INC_CASE_OFFICERS_VW.OFFICER_ID Implied Constraint R
INCIDENT_CASE_OFFICERS.ASSIGNED_BY INCCASOFF_ASSGNOFF1_FK R
INCIDENT_CASE_OFFICERS.OFFICER_ID INCCASOFF_OFF1_FK R
INCIDENT_CASE_OFFICERS_VW.OFFICER_ID Implied Constraint R
INCIDENT_CASE_SEARCH_VW.OFFICER_ID Implied Constraint R
INCIDENT_CASE_VW.OFFICER_ID Implied Constraint R
INCIDENT_COMBO_OFCR_VW.OFFICER_ID Implied Constraint R
INCIDENT_COMBO_PER_VW.OFFICER_ID Implied Constraint R
INCIDENT_COMBO_VEH_VW.OFFICER_ID Implied Constraint R
INCIDENT_COMBO_VW.OFFICER_ID Implied Constraint R
INCIDENT_CRIME_TARGET_VW.OFFICER_ID Implied Constraint R
INCIDENT_OFFICER_VW.OFFICER_ID Implied Constraint R
INCIDENT_PERSON_OFFENSES_VW.OFFICER_ID Implied Constraint R
ITEM_CUST_HIST_VW.OFFICER_ID Implied Constraint R
ITEM_CUSTODIES.OFFICER_ID ITCU_OFF1_FK R
ITEM_INSPECTION_ITEMS.OFFICER_ID ITINSPI_OFF1_FK R
ITEM_INST_CUSTODY_DESC_VW.OFFICER_ID Implied Constraint R
ITEM_INST_CUSTODY_VW.OFFICER_ID Implied Constraint R
ITEM_INST_ENT_ROLLUP_VW.OFFICER_ID Implied Constraint R
ITEM_INST_ROLLUP_VW.OFFICER_ID Implied Constraint R
ITEM_INSTANCES.OFFICER_ID ITII_OFF1_FK R
JS_FIELD_CONTACT_OFFICERS_VW.OFFICER_ID Implied Constraint R
JS_INCIDENT_CASE_VW.OFFICER_ID Implied Constraint R
JS_SCHEDULING_VW.OFFICER_ID Implied Constraint R
LEGAL_SEARCH_INDEX.OFFICER_ID LSI_OFF_1_FK R
LSI_ADDRESSES_VW.OFFICER_ID Implied Constraint R
LSI_PEOPLE_VW.OFFICER_ID Implied Constraint R
LSI_VW.OFFICER_ID Implied Constraint R
MY_CASE_SEARCH_VW.OFFICER_ID Implied Constraint R
N_INCIDENT_PERSON_OFFENSES_VW.OFFICER_ID Implied Constraint R
OFFICER_CASE_LOAD.OFF1_OFFICER_ID OCL_OFF1_FK C
OFFICER_CASE_VW.OFFICER_ID Implied Constraint R
OFFICER_IDS_TEMP.OFFICER_ID Implied Constraint R
OFFICER_INCIDENTS.OFF1_OFFICER_ID OFFINC_OFF1_FK R
OFFICERS.MASTER_OFFICER_ID OFF1_OFF1_FK R
PROPERTY_HOLD_CUSTODIES.OFFICER_ID PROPHOCUST_OFF1_FK R
PROPERTY_HOLD_SEARCH_VW.OFFICER_ID Implied Constraint R
PROPERTY_HOLDS.DISPOSITION_OFFICER_ID PROPHO_OFF1_FK R
TOWS.AUTH_OFF_ID TOW_OFF1_FK R
UF_QUERY_OFFICER_VW.OFFICER_ID Implied Constraint R
USER_FIELD_OFF_VALUES.OFFICER_ID USRSCRN_UFOV_OFF1_FK R
USER_SCREEN_INSTANCES.OFFICER_ID USRSCRN_INST_OFF1_FK R
VS_TIME_CATEGORY_VW.OFFICER_ID Implied Constraint R
WARRANT_OFFICER_SEARCH_VW.OFFICER_ID Implied Constraint R
WARRANT_OFFICER_VW.OFFICER_ID Implied Constraint R
WARRANT_OFFICERS.OFFICER_ID WAROFF_OFF1_FK R
WARRANT_SERVING_OFFICERS.OFFICER_ID WARSERV_OFF1_FK R
WARRANT_SRVOFF_SEARCH_VW.OFFICER_ID Implied Constraint R
Officer ID number
AGNCY_CD_AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE OFF1_AGNCY_CD_FK R
Agency involved
DISPTCH_DISPATCH_ID varchar2 9  √  null Unique # assigned
LNAME varchar2 20 Last name of officer
FNAME varchar2 20  √  null First name of officer
MNAME varchar2 20  √  null Middle name of officer
INTERNAL_ID varchar2 100 Officer"s internal ID number
TITLE varchar2 20  √  null Officer"s title
SUPERVISOR varchar2 1  √  null Yes or No
USER_ID varchar2 100  √  null System User Id for the Officer
EMAIL_ID varchar2 25  √  null email ID of the officer
ACTIVE varchar2 1  √  null
DETECTIVE varchar2 1  √  null
SIG_IMAGE_ID number 38  √  null
IMAGES.IMAGE_ID OFF1_IMA_FK R
Unique ID for Image
CAD_EMP_ID varchar2 15  √  null
REC_ID number 0  √  null
MASTER_OFFICER_ID number 0  √  null
OFFICERS.OFFICER_ID OFF1_OFF1_FK R
Foreign key to the most current officer record.
CREATOR_ID varchar2 100  √  null Id that created this record.
CREATOR_DATE date 7  √  null Date that record was created.
UPDATOR_ID varchar2 100  √  null ID that updated this record.
UPDATOR_DATE date 7  √  null Date that this record was updated.
SUFFIX varchar2 10  √  null Suffix like Jr for the officer.

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
ACTIVE IN ('Y', 'N') CK_OFF1_ACTIVE
"AGNCY_CD_AGENCY_CODE" IS NOT NULL OFF1_AGNCY_CD_AGENCY_CODE_NN
"INTERNAL_ID" IS NOT NULL OFF1_INTERNAL_ID_NN
"LNAME" IS NOT NULL OFF1_LNAME_NN
"OFFICER_ID" IS NOT NULL OFF1_OFFICER_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
OFFICER_ID Primary key Asc OFF1_PK
ACTIVE Performance Asc OFF1_ACTIVE_I
AGNCY_CD_AGENCY_CODE Performance Asc OFF1_AGNCY_CD_FK_I
Performance OFF1_FNAME_UPPER_FB_I
SIG_IMAGE_ID Performance Asc OFF1_IMA_FK_I
LNAME + FNAME Performance Asc/Asc OFF1_LNAME_FNAME_I
Performance OFF1_LNAME_UPPER_FB_I
MASTER_OFFICER_ID Performance Asc OFF1_OFF1_FK_I
Performance OFF1_UPPERTRIM_FNCBAS_I
USER_ID Performance Asc OFF1_USER_ID_I

Close relationships  within of separation: