Table slot9.WORLD.TSTA.CITATIONS
This table stores the main citation information as entered 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
APPEARANCE_DATE date 7  √  null
BOND_TYPE varchar2 2  √  null
BOND_TYPE_CODES.BOND_TYPE CITATION_BND_TYP_CD_FK R
Type of Bond
CITATION_ID number 38
ACTIVITY_HEADERS.CITATION_ID ACTHD_CITATION_FK R
BI_CITATIONS_VW.CITATION_ID Implied Constraint R
CITATION_ADDRESS_VW.CITATION_ID Implied Constraint R
CITATION_ADDRESSES.CITATION_ID CIT_ADDR_CITATION_FK C
CITATION_ATTACHMENTS.CITATION_ID CITA_CITATION_FK R
CITATION_BUSINESS_VW.CITATION_ID Implied Constraint R
CITATION_BUSINESSES.CITATION_ID CB1_CITATION_FK C
CITATION_DCNS.CITATION_ID CITDCN_CITATION_FK C
CITATION_EMPLOYEE_VW.CITATION_ID Implied Constraint R
CITATION_EMPLOYEES.CITATION_ID CITEMP_CITATION_FK R
CITATION_IMAGES.CITATION_ID CITIMG_CITATION_FK R
CITATION_METHODS.CITATION_ID CIT_METH_CITATION_FK C
CITATION_OFFICERS.CITATION_ID CITOFF_CITATION_FK R
CITATION_PEOPLE.CITATION_ID CP_CITATION_FK C
CITATION_PERSON_VW.CITATION_ID Implied Constraint R
CITATION_RACIAL_INFO.CITATION_ID Implied Constraint R
CITATION_RACIAL_PROFILE_VW.CITATION_ID Implied Constraint R
CITATION_REPORTS.CITATION_ID CITREP_CITATION_FK R
CITATION_ROAD_CONDITIONS.CITATION_ID CIT_ROAD_CITATION_FK C
CITATION_VEHICLE_VW.CITATION_ID Implied Constraint R
CITATION_VEHICLES.CITATION_ID CITVEH_CITATION_FK C
CITATION_VIOLATIONS.CITATION_ID CITVIO_CITATION_FK R
CITATION_VISIBILITIES.CITATION_ID CIT_VIS_CITATION_FK C
CITATION_VW.CITATION_ID Implied Constraint R
CITATION_XREFS.CITATION_ID CX_CITATION_XREF_FK C
CITATION_XREFS.PARENT_CITATION_ID CX_CITATION_FK C
CITATION_XREFS_VW.CITATION_ID Implied Constraint R
COURT_CASE_CITATIONS.CITATION_ID CRTCASECIT_CITATION_FK R
INCIDENT_CITATION_VW.CITATION_ID Implied Constraint R
INCIDENT_CITATIONS.CITATION_ID INC_CIT_CITATION_FK C
JS_CITATION_VW.CITATION_ID Implied Constraint R
USI_CITATION_FIELDS.CITATION_ID USI_CIF_CITATION_FK R
USI_CITATIONS.CITATION_ID USI_CI_CITATION_FK R
USRSCRN_CITATION_VW.CITATION_ID Implied Constraint R
sequence to distinguish individual tickets
STATE_DIST_CODE varchar2 2  √  null
STATE_DISTRICT_CODES.STATE_DIST_CODE CITATION_STDISTCD_FK R
TICKET_NUMBER varchar2 20  √  null Hard copy ticket number
MUST_APPEAR varchar2 1 'N' Yes or no will the citation require a court apperance?
BOND_AMOUNT number 10  √  null The amount of the bond
TWP_RD varchar2 1 'N' Yes or no. If yes pay fine to TWP. but sharif still is credited with citation.
CITATION_DATE date 7  √  null
FILED_DATE date 7  √  null Date the citation is filed.
CREATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
UPDATOR_DATE date 7  √  null Date of record update
CITATION_TYPE_CODE varchar2 2  √  null
CITATION_TYPE_CODES.CITATION_TYPE_CODE CITATION_CITAT_CD_FK R
code to determine the citation type (warning ordiance)
COUNTY_CODE varchar2 30
EJS_CODES.CODE CITATION_COUNTY_CO_EJS_CODE_FK R
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE CITATION_AGNCY_CD_FK R
CITY_CODE varchar2 30  √  null
EJS_CODES.CODE CITATION_CITY_CODE_EJS_CODE_FK R
City/Unincorp. code (I-UCR)
ACTUAL_SPEED number 0  √  null The actual speed a vehcile was traveling.
POSTED_SPEED number 0  √  null The speed limit posted for the cited location.
CITY_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE CITATION_CITY_CODE_EJS_CODE_FK R
COUNTY_CODE_TYPE varchar2 30  √  'COUNTY_CODES'
EJS_CODES.CODE_TYPE CITATION_COUNTY_CO_EJS_CODE_FK R
REC_ID number 0  √  null
PLAINTIFF varchar2 100  √  null
USER_AGENCY varchar2 100
AGENCY_CODES.AGENCY_CODE CITATION_USER_AGNCY_FK R
PERCEIVED_RACE_CODE varchar2 30  √  null
EJS_CODES.CODE CITATION_EC_RACE_FK R
PERCEIVED_RACE_CODE_TYPE varchar2 30  √  'RACE_CODES'
EJS_CODES.CODE_TYPE CITATION_EC_RACE_FK R
RACE_KNOWN char 1  √  'N'
DURATION_CODE varchar2 30  √  null
EJS_CODES.CODE CITATION_EC_DURA_FK R
DURATION_CODE_TYPE varchar2 30  √  'STOP_DURATION_CODES'
EJS_CODES.CODE_TYPE CITATION_EC_DURA_FK R
STOP_COMMENT varchar2 1000  √  null
LOADED_BY varchar2 100  √  null Loaded by XML Document Category Code
LAST_LOAD_DATE date 7  √  null Date Last XML Load Processed
PHYSICAL_FORCE_FLAG varchar2 1  √  null
RESULT_OF_STOP_CODE varchar2 30  √  null
EJS_CODES.CODE CITATION_EJSCD_RESSTOP_FK R
RESULT_OF_STOP_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE CITATION_EJSCD_RESSTOP_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"AGENCY_CODE" IS NOT NULL CITATION_AGENCY_CODE_NN
"CITATION_ID" IS NOT NULL CITATION_CITATION_ID_NN
"COUNTY_CODE" IS NOT NULL CITATION_COUNTY_CODE_NN
"MUST_APPEAR" IS NOT NULL CITATION_MUST_APPEAR_NN
"TWP_RD" IS NOT NULL CITATION_TWP_RD_NN
"USER_AGENCY" IS NOT NULL CITATION_USER_AGENCY_NN
MUST_APPEAR IN ('Y', 'N') CK_CITATION_MUST_APPEAR
RACE_KNOWN IN ('Y','N') CK_CITATION_RACE_KNOWN
TWP_RD IN ('Y', 'N') CK_CITATION_TWP_RD

Indexes:
Column(s) Type Sort Constraint Name
CITATION_ID Primary key Asc CITATION_PK
CITATION_DATE Performance Asc CIT_CITATION_DATE_I
AGENCY_CODE Performance Asc CITATION_AGNCY_CD_FK_I
BOND_TYPE Performance Asc CITATION_BND_TYP_CD_FK_I
CITATION_TYPE_CODE Performance Asc CITATION_CITAT_CD_FK_I
CITY_CODE Performance Asc CITATION_CITY_CD_FK_I
CITY_CODE_TYPE + CITY_CODE Performance Asc/Asc CITATION_CITY_CODE_EJS_CODE_I
COUNTY_CODE Performance Asc CITATION_CNTY_CD_FK_I
COUNTY_CODE_TYPE + COUNTY_CODE Performance Asc/Asc CITATION_COUNTY_CO_EJS_CODE_I
DURATION_CODE_TYPE + DURATION_CODE Performance Asc/Asc CITATION_EC_DURA_FK_I
PERCEIVED_RACE_CODE_TYPE + PERCEIVED_RACE_CODE Performance Asc/Asc CITATION_EC_RACE_FK_I
RESULT_OF_STOP_CODE_TYPE + RESULT_OF_STOP_CODE Performance Asc/Asc CITATION_EJSCD_RESSTOP_FK_I
STATE_DIST_CODE Performance Asc CITATION_STDISTCD_FK_I
TICKET_NUMBER Performance Asc CITATION_TICKET_NUM_I
USER_AGENCY Performance Asc CITATION_USER_AGNCY_FK_I

Close relationships  within of separation: