Table slot9.WORLD.TSTA.E_WARRANTS
This table stores warrant 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
WARRANT_ID number 0
ARREST_CHARGE_VW.WARRANT_ID Implied Constraint R
ARREST_WARRANTS.WARRANT_ID ARRWAR_EWAR_FK R
CASE_ACTIVITY_WARRANTS.WARRANT_ID CACTWAR_EWAR_FK R
E_WARRANTS_AUDIT.WARRANT_ID Implied Constraint R
INCIDENT_WARRANTS.WARRANT_ID INC_WAR_EWAR_FK C
JS_WARRANT_OFFENSE_CHARGE_VW.WARRANT_ID Implied Constraint R
JS_WARRANT_VW.WARRANT_ID Implied Constraint R
USI_WARRANT_FIELDS.WARRANT_ID USI_WAF_EWAR_FK R
USI_WARRANTS.WARRANT_ID USI_WA_EWAR_FK R
USRSCRN_WARRANT_VW.WARRANT_ID Implied Constraint R
WARRANT_ADDR_SEARCH_VW.WARRANT_ID Implied Constraint R
WARRANT_ARREST_CHARGES.WARRANT_ID WAC_EWAR_FK R
WARRANT_ATTACHMENTS.WARRANT_ID WARATT_EWAR_FK C
WARRANT_CFS.WARRANT_ID WAR_CFS_EWAR_FK C
WARRANT_CHARGES.EWAR_WARRANT_ID WCHG_EWAR_FK C
WARRANT_FREETEXT_CHARGES.WARRANT_ID WFTC_EWAR_FK R
WARRANT_IMAGES.WARRANT_ID WARIMG_EWAR_FK R
WARRANT_LOG.EWAR_WARRANT_ID WL_EWAR_FK C
WARRANT_OFFENSE_CHARGE_VW.WARRANT_ID Implied Constraint R
WARRANT_OFFICER_SEARCH_VW.WARRANT_ID Implied Constraint R
WARRANT_OFFICERS.WARRANT_ID WAROFF_EWAR_FK R
WARRANT_PERSON_ADDR_VW.WARRANT_ID Implied Constraint R
WARRANT_REFERENCES.WARRANT_ID WREF_EWAR_FK R
WARRANT_SEARCH_VW.WARRANT_ID Implied Constraint R
WARRANT_SERVICE_ADDRESSES.WARRANT_ID WARSA_EWAR_FK R
WARRANT_SERVING_OFFICERS.WARRANT_ID WARSERV_EWAR_FK R
WARRANT_SRVOFF_SEARCH_VW.WARRANT_ID Implied Constraint R
WARRANTS_VW.WARRANT_ID Implied Constraint R
Warrant ID Number
WSC_CODE varchar2 30
EJS_CODES.CODE EWAR_WSC_CODE_EJS_CODE_FK R
Warrant Status Code
MN_PER_PERSON_ID number 0
MASTER_NAMES.PER_PERSON_ID EWAR_MN_FK R
Person ID number
MN_MN_ID number 0
MASTER_NAMES.MN_ID EWAR_MN_FK R
Master Name ID number
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE EWAR_AGNCY_CD_FK R
Agency involved
STATE_CD_STATE_CODE varchar2 30
EJS_CODES.CODE EWAR_STATE_CD_STAT_EJS_CODE_FK R
State code designator
PLAINTIFF varchar2 100 PlaIntiff on Warrant
DATE_ISSUED date 7  √  null Date Warrant was Issued
BND_TYP_CD_BOND_TYPE varchar2 2  √  null
BOND_TYPE_CODES.BOND_TYPE EWAR_BND_TYP_CD_FK R
Type of Bond
BOND_AMOUNT number 12,2  √  null Amount of Bail
CREATOR_ID varchar2 100  √  null Created by User ID
CREATOR_DATE date 7  √  null Creation Date
UPDATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
UPDATOR_DATE date 7  √  null Date of Last Update
STATE_CD_STATE_CODE_TYPE varchar2 30  √  'STATE_CODES'
EJS_CODES.CODE_TYPE EWAR_STATE_CD_STAT_EJS_CODE_FK R
WSC_CODE_TYPE varchar2 30  √  'WARRANT_STATUS_CODES'
EJS_CODES.CODE_TYPE EWAR_WSC_CODE_EJS_CODE_FK R
REC_ID number 0  √  null
ISSUING_AGENCY varchar2 30
AGENCY_CODES.AGENCY_CODE EWAR_ISSUING_AGNCY_CD_FK R
JUDGE varchar2 255  √  null
SYS_ID varchar2 100  √  null
STATE_ENTRY_DATE date 7  √  null
STATE_REMOVAL_DATE date 7  √  null
REMOVED char 1  √  'N'
ISSUING_COURT_LOC_ID number 0  √  null The authority that originated or issued the warrant. Typically a warrant will be issued by a court entity.
ISSUING_COURT_NAME varchar2 255  √  null Freeform text field used to enter a court name when the required court is not listed in the standard LOV
RECEIVED_DATE date 7  √  null The date the warrant was received from the court
WARRANT_TYPE_CODE_TYPE varchar2 30 'WARRANT_TYPES'
EJS_CODES.CODE_TYPE EWAR_EJSCD_WARTYP_FK R
EJS_CODE "WARRANT_TYPES"
WARRANT_TYPE varchar2 255 'WARRANT'
EJS_CODES.CODE EWAR_EJSCD_WARTYP_FK R
Identifies the type of warrant
CHARGING_AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE EWAR_AGNCY_CD_CHRG_FK R
Identifies the "Original or Charging Agency" in an effort to execute a Criminal Warrant that originated outside of their jurisdiction or issuing court
CHARGING_AGENCY_NAME varchar2 255  √  null Freeform text field for adding agencies not found in the root agencies list
CHARGING_AGENCY_COMMENT varchar2 4000  √  null External agency contact information, phone numbers or other pertinent information related to the external warrant request.
EXTRADITION_LIMIT_TYPE varchar2 255  √  null Each Warrant may come with a predefined Extradition Limitation and if no limitation is defined, then the agency can determine for themselves the Extradition conditions based in the severity of the charge.
EXTRADITION_LIMIT_COMMENT varchar2 4000  √  null If an EXTRADITION_LIMIT_TYPE of "In State" or "Specify" are used, then Comments are required.
NIC_NUMBER varchar2 30  √  null Transaction number returned by a successful data entry into the CJIS system. This number can later be used to CLEAR the warrant from the CJIS NCIC system.
ISSUING_COURT_AGENCY_CODE varchar2 30  √  null
WARRANT_COMMENT varchar2 1000  √  null
EXPIRED_DATE date 7  √  null
REVIEW_DATE date 7  √  null
WARRANT_NUMBER varchar2 100  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
EXTRADITION_LIMIT_TYPE IN ( 'no_limitation','in_state_limitation','specify_limitation') CK_EWAR_EXTLIMITYPE
REMOVED IN ( 'Y','N') CK_EWAR_REMOVED
"ISSUING_AGENCY" IS NOT NULL EWAR_ISSUAC_CODE_NN
"MN_MN_ID" IS NOT NULL EWAR_MN_MN_ID_NN
"MN_PER_PERSON_ID" IS NOT NULL EWAR_MN_PER_PERSON_ID_NN
"PLAINTIFF" IS NOT NULL EWAR_PLAINTIFF_NN
"STATE_CD_STATE_CODE" IS NOT NULL EWAR_STATE_CD_STATE_CODE_NN
"WARRANT_ID" IS NOT NULL EWAR_WARRANT_ID_NN
"WARRANT_TYPE" IS NOT NULL EWAR_WARTYPE_NN
"WARRANT_TYPE_CODE_TYPE" IS NOT NULL EWAR_WARTYPECD_NN
"WSC_CODE" IS NOT NULL EWAR_WSC_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
WARRANT_ID Primary key Asc EWAR_PK
MN_PER_PERSON_ID Performance Asc E_WARRANT_PERSON_ID_I
CHARGING_AGENCY_CODE Performance Asc EWAR_AGNCY_CD_CHRG_FK_I
AGENCY_CODE Performance Asc EWAR_AGNCY_CD_FK_I
BND_TYP_CD_BOND_TYPE Performance Asc EWAR_BND_TYP_CD_FK_I
DATE_ISSUED + WSC_CODE Performance Asc/Asc EWAR_DATE_ISSUED
WARRANT_TYPE_CODE_TYPE + WARRANT_TYPE Performance Asc/Asc EWAR_EJSCD_WARTYP_FK_I
ISSUING_AGENCY Performance Asc EWAR_ISSUING_AGNCY_CD_FK_I
MN_MN_ID + MN_PER_PERSON_ID Performance Asc/Asc EWAR_MN_FK_I
STATE_CD_STATE_CODE Performance Asc EWAR_STATE_CD_FK_I
STATE_CD_STATE_CODE_TYPE + STATE_CD_STATE_CODE Performance Asc/Asc EWAR_STATE_CD_STAT_EJS_CODE_I
WSC_CODE_TYPE + WSC_CODE Performance Asc/Asc EWAR_WSC_CODE_EJS_CODE_I
WSC_CODE Performance Asc EWAR_WSC_FK_I

Close relationships  within of separation: