Table slot9.WORLD.TSTA.E_WARRANTS_AUDIT
This table is a shadow table for E_WARRANTS
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_AUDIT_ID number 38 Auto generated ID
WARRANT_ID number 0
E_WARRANTS.WARRANT_ID Implied Constraint R
Warrant ID Number
WSC_CODE varchar2 30  √  null Warrant Status Code
MN_PER_PERSON_ID number 0  √  null Person ID number
MN_MN_ID number 0  √  null Master Name ID number
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE Implied Constraint R
Agency involved
STATE_CD_STATE_CODE varchar2 30  √  null State code designator
PLAINTIFF varchar2 100  √  null PlaIntiff on Warrant
DATE_ISSUED date 7  √  null Date Warrant was Issued
BND_TYP_CD_BOND_TYPE varchar2 2  √  null 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  √  null
WSC_CODE_TYPE varchar2 30  √  null
REC_ID number 0  √  null
ISSUING_AGENCY varchar2 30  √  null
JUDGE varchar2 255  √  null
SYS_ID varchar2 100  √  null
STATE_ENTRY_DATE date 7  √  null
STATE_REMOVAL_DATE date 7  √  null
REMOVED char 1  √  null
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  √  null EJS_CODE "WARRANT_TYPES"
WARRANT_TYPE varchar2 255  √  null Identifies the type of warrant
CHARGING_AGENCY_CODE varchar2 30  √  null 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
EXPIRED_DATE date 7  √  null
REVIEW_DATE date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"WARRANT_AUDIT_ID" IS NOT NULL EWAR_AUDIT_ID_NN
"WARRANT_ID" IS NOT NULL EWAR_AUDIT_WARRANT_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
WARRANT_AUDIT_ID Primary key Asc EWAR_AUDIT_PK
WARRANT_ID Performance Asc EWAR_AUDIT_WARRANT_ID_I

Close relationships: