Table slot9.WORLD.TSTA.CITATION_TYPE_CODES
This table defines the valid types for a citation
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
CITATION_TYPE_CODE varchar2 2
BI_CITATIONS_VW.CITATION_TYPE_CODE Implied Constraint R
CITATION_ADDRESS_VW.CITATION_TYPE_CODE Implied Constraint R
CITATION_BUSINESS_VW.CITATION_TYPE_CODE Implied Constraint R
CITATION_DELETE.CITATION_TYPE_CODE Implied Constraint R
CITATION_EMPLOYEE_VW.CITATION_TYPE_CODE Implied Constraint R
CITATION_PERSON_VW.CITATION_TYPE_CODE Implied Constraint R
CITATION_RACIAL_PROFILE_VW.CITATION_TYPE_CODE Implied Constraint R
CITATION_VEHICLE_VW.CITATION_TYPE_CODE Implied Constraint R
CITATION_VW.CITATION_TYPE_CODE Implied Constraint R
CITATIONS.CITATION_TYPE_CODE CITATION_CITAT_CD_FK R
INCIDENT_CITATION_VW.CITATION_TYPE_CODE Implied Constraint R
JS_CITATION_VW.CITATION_TYPE_CODE Implied Constraint R
code to determine the citation type (warning ordiance)
DESCRIPTION varchar2 40  √  null describes the citation type
ACTIVE varchar2 1  √  'N'
ACTIVE_DATE date 7  √  null
CASE_TYPE_CODE varchar2 2  √  null
CASE_TYPE_CODES.CODE CITAT_CD_CTC3_FK R
REC_ID number 0  √  null
RP_FLAG varchar2 1  √  'N'
REQ_TICKET_NUM_FLAG varchar2 1  √  'Y' if a ticket number required when adding/saving a citation with this code type. Setting this to N will also allow for citations with the same ticket number and enforcement type to be saved/updated

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"CITATION_TYPE_CODE" IS NOT NULL CITAT_CD_CITATION_TYPE_CODE_NN
ACTIVE IN ('Y', 'N') CK_CITAT_CD_ACTIVE
RP_FLAG IN ('Y', 'N') CK_CITAT_RP_CODE

Indexes:
Column(s) Type Sort Constraint Name
CITATION_TYPE_CODE Primary key Asc CITAT_CD_PK
CASE_TYPE_CODE Performance Asc CITAT_CD_CTC3_FK_I

Close relationships  within of separation: