Table slot9.WORLD.TSTA.COURT_LOCATION_CODES
This table defines valid court locations to be used as a court or receiving agency or both on a Court Paper (referred to as civil process) 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
COURT_ID number 0
ARREST_CHARGE_NARRATIVES.COURT_ID ARRCHGNR_CRTLOC_FK R
CRIMINAL_COMPLAINTS.COURT_ID CRMCMP_CRTLOC_FK R
WARRANT_CHARGE_NARRATIVES.COURT_ID WARCHGNAR_CRTLOC_FK R
Unique ID assigned to a court locations to serve as part of primary key
AGENCY_CODE varchar2 30
ARREST_CHARGE_NARRATIVES.COURT_AGENCY_CODE ARRCHGNR_CRTLOC_FK R
CRIMINAL_COMPLAINTS.COURT_AGENCY_CODE CRMCMP_CRTLOC_FK R
WARRANT_CHARGE_NARRATIVES.COURT_AGENCY_CODE WARCHGNAR_CRTLOC_FK R
AGENCY_CODES.AGENCY_CODE CRTLOC_AGNCY_CD_FK R
Agency code for court locations to serve as part of primary key, foreign key to agency codes table
COURT_NAME varchar2 255  √  null Display name for court location
COURT_NAME2 varchar2 255  √  null Additional display name for court location
COURT_ADDR varchar2 255  √  null Address for court location
COURT_ADDR2 varchar2 255  √  null Additional address for court location
COURT_CITY varchar2 255  √  null Address city for court location
COURT_STATE varchar2 2  √  null
EJS_CODES.CODE CRTLOC_STATE_CD_FK R
Address state for court location, foreign key to ejs codes table
COURT_ZIP number 0  √  null Address (5 digit) zip for court location
COURT_PHONE number 0  √  null Phone number for court location
COURT_COMMENT varchar2 4000  √  null Default comment when court location selected
IS_COURT varchar2 1  √  'Y' Y or N flag determines if this location is a court
IS_AGENCY varchar2 1  √  'Y' Y or N flag determines if this location is a received by agency
IS_ACTIVE varchar2 1  √  'Y' Y or N flag determines if this location is active
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null
COURT_ZIP4 number 0  √  null Address (4 digit) zip for court location
COURT_STATE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE CRTLOC_STATE_CD_FK R
Y or N flag determines if this location is from a free text location entry
USER_GENERATED varchar2 1  √  'N'
JURISDICTION_NAME varchar2 100  √  null
JURISDICTION_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE CRTLOC_EJSCD_JURIS_FK R
JURISDICTION_TYPE_CODE_TYPE varchar2 30  √  'COURT_JURIS_TYPE_CODES'
EJS_CODES.CODE_TYPE CRTLOC_EJSCD_JURIS_FK R
IS_AFFIDAVIT_FOOTER varchar2 1  √  'N' Y or N flag determines if this location has footer text associated to it
SORT_ORDER number 0  √  null Numner - Optional, can be used to sort the court locations in LOVs throughout the application

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"AGENCY_CODE" IS NOT NULL CRTLOC_AGENCY_CODE_NN
"COURT_ID" IS NOT NULL CRTLOC_CRT_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
COURT_ID + AGENCY_CODE Primary key Asc/Asc CRTLOC_PK
AGENCY_CODE Performance Asc CRTLOC_AGNCY_CD_FK_I
COURT_ID Performance Asc CRTLOC_COURT_ID_I
JURISDICTION_TYPE_CODE_TYPE + JURISDICTION_TYPE_CODE Performance Asc/Asc CRTLOC_EJSCD_JURIS_FK_I
COURT_STATE_CODE_TYPE + COURT_STATE Performance Asc/Asc CRTLOC_STATE_CD_FK_I

Close relationships  within of separation: