Table slot9.WORLD.TSTA.IMPOUND
This table stores the impound information added to a vehicle 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
IMPOUND_ID number 0
ARRESTS.IMPOUND_ID ARR_IMPD_FK R
IMP_VEH_BUSINESSES_VW.IMPOUND_ID Implied Constraint R
IMP_VEH_OFFICERS_VW.IMPOUND_ID Implied Constraint R
IMPOUND_ATTACHMENTS.IMPOUND_ID IMPATT_IMPD_FK C
IMPOUND_BUSINESSES.IMPOUND_ID IMPBUS_IMPD_FK C
IMPOUND_HOLD_OFFS.IMPOUND_ID HLDOFF_IMPD_FK R
IMPOUND_HOLDS.IMPOUND_ID IMPHLD_IMPD_FK R
IMPOUND_IMAGES.IMPOUND_ID IMPIMA_IMPD_FK C
IMPOUND_INVENTORY.IMPOUND_ID IMPINV_IMPD_FK C
IMPOUND_LOG.IMPOUND_ID IMPLOG_IMPD_FK C
IMPOUND_OFFICERS.IMPOUND_ID IMPOFF_IMPD_FK R
IMPOUND_PEOPLE.IMPOUND_ID IMPP_IMPD_FK C
IMPOUND_REASONS.IMPOUND_ID IMPRSN_IMPD_FK R
IMPOUND_VEHICLE_VW.IMPOUND_ID Implied Constraint R
INCIDENT_IMPOUNDS.IMPOUND_ID INC_IMP_IMPD_FK C
JS_FIELD_ARREST_CHARGE_VW.IMPOUND_ID Implied Constraint R
JS_FIELD_ARREST_VW.IMPOUND_ID Implied Constraint R
JS_VEHICLE_TOW_IMPOUND_VW.IMPOUND_ID Implied Constraint R
USI_IMPOUND_FIELDS.IMPOUND_ID USI_IMPF_IMP_FK R
VEHICLE_IMPOUND_VW.IMPOUND_ID Implied Constraint R
Impound ID - Unique Number
VEHICLE_ID number 38
TOWS.VEH_VEHICLE_ID IMPD_TOW_FK R
VEHICLES.VEHICLE_ID IMPD_VEH_FK R
VEHICLE_DESCRIPTIONS.VEHICLE_ID IMPD_VEHDSC_FK R
Vehicle ID number
DATE_OF_INFO date 7
VEHICLE_DESCRIPTIONS.DATE_OF_INFO IMPD_VEHDSC_FK R
Date of Vehicle Description Information
DATE_OF_IMPOUND date 7 Date and Time of Impound
IMPOUNDING_AGENCY varchar2 30
IMP_LOC_CODES.AGENCY_CODE IMPD_IMPLC_FK R
AGENCY_CODES.AGENCY_CODE IMPD_AGNCY_CD_IMPOUNDING_FK R
Agency involved
TOW_SEQ number 0  √  null
TOWS.TOW_SEQ IMPD_TOW_FK R
Towing - Vehicle Sequence
LOC_CODE varchar2 6  √  null
IMP_LOC_CODES.LOC_CODE IMPD_IMPLC_FK R
Impound Location Code
VEH_INS_ID number 0  √  null
VEHICLE_INSURANCE.VEH_INS_ID IMPD_VEHINS_FK R
Vehicle Insurance ID - Unique Generated Number
IMP_DISP_CODE varchar2 30  √  null
EJS_CODES.CODE IMPD_IMP_DISP_CODE_EJS_CODE_FK R
Impound Disposition Code
REPORTING_AGENCY varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE IMPD_AGNCY_CD_FK R
Agency involved
INCIDENT_NUMBER varchar2 20  √  null Impounding Agency Incident Report/Case Number
DATE_AGENCY_CONTACED date 7  √  null Date Reporting Agency Contacted
DATE_RELEASE_SIGNED date 7  √  null Date Release was signed
DATE_OF_RELEASE date 7  √  null Date of Vehicle Release
COMMENTS varchar2 2000  √  null Comments Regarding Impound
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
OWNER_TAG_CHECK varchar2 1  √  null Yes/No field for tag checks to owner
VEHICLE_TAG_CHECK varchar2 1  √  null Yes/No field or tag checks to vehicle
DATA_ENTRY_COMPLETE varchar2 1  √  null Yes/No field for data entry completed
DPS_NOTICE_SENT varchar2 1  √  null Yes/No field for DPS Notice sent
DATE_OWNER_NOTIFIED date 7  √  null Date the owner was notified
STOLEN_VEHICLE varchar2 1  √  null Yes/No field for stolen vehicle
OWNER_NOTIFIED varchar2 1  √  'N' Yes or No Fields for owner notified
NOTIFIED_AT_SCENE varchar2 1  √  null Yes or No Fields for notified at scene
LOCATION_OF_IMPOUND varchar2 255  √  null Location of Impoundment
IMP_DISP_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE IMPD_IMP_DISP_CODE_EJS_CODE_FK R
REC_ID number 0  √  null
CITY varchar2 100  √  null
GEO_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE IMPD_GEO_AGNCY_CD_FK R
COUNTY_CODE varchar2 30  √  null
EJS_CODES.CODE IMPD_IMP_CNTY_CD_EJS_CODE_FK R
COUNTY_CODE_TYPE varchar2 30  √  'COUNTY_CODES'
EJS_CODES.CODE_TYPE IMPD_IMP_CNTY_CD_EJS_CODE_FK R
TOWNSHIP_CODE varchar2 30  √  null
EJS_CODES.CODE IMPD_IMP_TNSP_CD_EJS_CODE_FK R
TOWNSHIP_CODE_TYPE varchar2 30  √  'TOWNSHIP_CODES'
EJS_CODES.CODE_TYPE IMPD_IMP_TNSP_CD_EJS_CODE_FK R
CAD_NUMBER varchar2 30  √  null
REVIEW_STATUS_CODE varchar2 30  √  null
EJS_CODES.CODE IMPD_IMP_REV_CD_EJS_CODE_FK R
REVIEW_STATUS_CODE_TYPE varchar2 30  √  'IMPOUND_REVIEW_STATUS_CODES'
EJS_CODES.CODE_TYPE IMPD_IMP_REV_CD_EJS_CODE_FK R
OWNER_UNKNOWN varchar2 1  √  'N'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
DATA_ENTRY_COMPLETE IN ('Y', 'N') CK_IMPD_DATA_ENTRY_COMPLETE
DPS_NOTICE_SENT IN ('Y', 'N') CK_IMPD_DPS_NOTICE_SENT
NOTIFIED_AT_SCENE IN ('Y', 'N') CK_IMPD_NOTIFIED_AT_SCENE
OWNER_NOTIFIED IN ('Y', 'N') CK_IMPD_OWNER_NOTIFIED
OWNER_TAG_CHECK IN ('Y', 'N') CK_IMPD_OWNER_TAG_CHECK
STOLEN_VEHICLE IN ('Y', 'N') CK_IMPD_STOLEN_VEHICLE
VEHICLE_TAG_CHECK IN ('Y', 'N') CK_IMPD_VEHICLE_TAG_CHECK
"DATE_OF_IMPOUND" IS NOT NULL IMPD_DATE_OF_IMPOUND_NN
"DATE_OF_INFO" IS NOT NULL IMPD_DATE_OF_INFO_NN
"IMPOUND_ID" IS NOT NULL IMPD_IMPOUND_ID_NN
"IMPOUNDING_AGENCY" IS NOT NULL IMPD_IMPOUNDING_AGENCY_NN
"VEHICLE_ID" IS NOT NULL IMPD_VEHICLE_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
IMPOUND_ID Primary key Asc IMPD_PK
REPORTING_AGENCY Performance Asc IMPD_AGNCY_CD_FK_I
IMPOUNDING_AGENCY Performance Asc IMPD_AGNCY_CD_IMPOUNDING_FK_I
GEO_CODE Performance Asc IMPD_GEO_AGNCY_CD_FK_I
COUNTY_CODE_TYPE + COUNTY_CODE Performance Asc/Asc IMPD_IMP_CNTY_CD_EJS_CODE_FK_I
IMP_DISP_CODE_TYPE + IMP_DISP_CODE Performance Asc/Asc IMPD_IMP_DISP_CODE_EJS_CODE_I
REVIEW_STATUS_CODE_TYPE + REVIEW_STATUS_CODE Performance Asc/Asc IMPD_IMP_REV_CD_EJS_CODE_FK_I
TOWNSHIP_CODE_TYPE + TOWNSHIP_CODE Performance Asc/Asc IMPD_IMP_TNSP_CD_EJS_CODE_FK_I
IMP_DISP_CODE Performance Asc IMPD_IMPDC_FK_I
IMPOUNDING_AGENCY + LOC_CODE Performance Asc/Asc IMPD_IMPLC_FK_I
VEHICLE_ID + TOW_SEQ Performance Asc/Asc IMPD_TOW_FK_I
VEHICLE_ID Performance Asc IMPD_VEH_FK_I
VEHICLE_ID + DATE_OF_INFO Performance Asc/Asc IMPD_VEHDSC_FK_I
VEH_INS_ID Performance Asc IMPD_VEHINS_FK_I

Close relationships  within of separation: