View slot9.WORLD.TSTA.JS_FIELD_ARREST_VW
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
ARREST_ID number 0
ARRESTS.ARREST_ID Implied Constraint R
PERSON_ID number 0
JAIL_PEOPLE.PERSON_ID Implied Constraint R
PERSON_SUMMARY varchar2 4000  √  null
ARREST_DATE date 7
TOWING_CO_ID number 0  √  null
TOW_COMPANY_CODES.TOWING_CO_ID Implied Constraint R
ARR_COMMENT varchar2 4000  √  null
TOWING_CO_AREA varchar2 3  √  null
TOWING_CO_CITY varchar2 40  √  null
TOWING_CO_NAME varchar2 40  √  null
TOWING_CO_PREFIX varchar2 3  √  null
TOWING_CO_STREET varchar2 40  √  null
TOWING_CO_SUFFIX varchar2 4  √  null
TOWING_CO_ZIP varchar2 5  √  null
TOWING_CO_STATE_CODE varchar2 30  √  null
VEHICLE_ID number 0  √  null
DEPARTMENT_VEHICLES.VEHICLE_ID Implied Constraint R
AGENCY_CODE varchar2 100
AGENCY_DESC varchar2 40  √  null
FINGERPRINT_CODE varchar2 30  √  null
FINGERPRINT_CODE_TYPE varchar2 30  √  null
ARREST_NUM varchar2 100
ARREST_DSP_CODE varchar2 30  √  null
ARREST_DSP_DESC varchar2 4000  √  null
ARREST_DSP_COMMENT varchar2 4000  √  null
ARREST_DSP_CNTY_CODE varchar2 30  √  null
ARREST_DSP_CNTY_DESC varchar2 4000  √  null
ARREST_DSP_JAIL_CODE varchar2 30  √  null
ARREST_DSP_JAIL_DESC varchar2 4000  √  null
BOND_TYPE varchar2 2  √  null
BOND_TYPE_CODES.BOND_TYPE Implied Constraint R
BOND_TYPE_DESC varchar2 40  √  null
BOND_AMOUNT number 12,2  √  null
ARREST_CNTY_CODE varchar2 30  √  null
ARREST_CNTY_DESC varchar2 4000  √  null
INC_REPORT_NUMBER varchar2 20  √  null
JAIL_DATE date 7  √  null
IMPOUND_ID number 0  √  null
IMPOUND.IMPOUND_ID Implied Constraint R
VEHICLE_SEIZED_FLAG varchar2 1  √  null
VEHICLE_STORED_FLAG varchar2 1  √  null
CURRENCY_SEIZED_FLAG varchar2 1  √  null
CURRENCY_TOTAL number 0  √  null
DISCHARGE_DATE date 7  √  null
STATUS_CODE varchar2 30  √  null
STATUS_DESC varchar2 4000  √  null
CASE_NUMBER varchar2 50  √  null
ADDRESS_ID number 38  √  null
ADDRESS_SUMMARY varchar2 4000  √  null
STREET_NUMBER varchar2 10  √  null
DIRECTION_CODE varchar2 30  √  null
STREET_NAME varchar2 40  √  null
STREET_TYPE_CODE varchar2 30  √  null
STREET_TYPE_DESC varchar2 4000  √  null
ADDRESS_SUBTYPE_CODE varchar2 30  √  null
ADDRESS_SUBTYPE_DESC varchar2 4000  √  null
SUB_NUMBER varchar2 50  √  null
INTRSECT1_STREET_NUMBER varchar2 10  √  null
INTRSECT1_DIR varchar2 30  √  null
INTRSECT1_NAME varchar2 40  √  null
REPORTING_AREA varchar2 61  √  null
CITY varchar2 40  √  null
STATE_CODE varchar2 30  √  null
STATE_DESC varchar2 4000  √  null
ZIP5 varchar2 30  √  null
ZIP4 varchar2 5  √  null
LATITUDE varchar2 30  √  null
LONGITUDE varchar2 30  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT A.ARREST_ID ,A.PERSON_ID ,EJS_PERSON_PKG.GET_PERSON_SUMMARY(PERSON_ID) ,A.ARREST_DATE ,A.TOWING_CO_ID ,A.ARR_COMMENT ,A.TOWING_CO_AREA ,A.TOWING_CO_CITY ,A.TOWING_CO_NAME ,A.TOWING_CO_PREFIX ,A.TOWING_CO_STREET ,A.TOWING_CO_SUFFIX ,A.TOWING_CO_ZIP ,A.TOWING_CO_STATE_CODE ,A.VEH_VEHICLE_ID ,A.AGENCY_CODE ,(SELECT AG.AGENCY_DESC FROM AGENCY_CODES AG WHERE AG.AGENCY_CODE = A.AGENCY_CODE) ,A.FINGERPRINT_CODE ,A.FINGERPRINT_CODE_TYPE ,A.ARREST_NUM ,A.ARREST_DSP_CODE ,(SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = ARREST_DSP_CODE_TYPE AND EC.CODE = ARREST_DSP_CODE ) ,A.ARREST_DSP_COMMENT ,A.ARREST_DSP_CNTY_CODE ,(SELECT EC1.DESCRIPTION FROM EJS_CODES EC1 WHERE EC1.CODE_TYPE = A.ARREST_DSP_CNTY_CODE_TYPE AND EC1.CODE = A.ARREST_DSP_CNTY_CODE) ,A.ARREST_DSP_JAIL_CODE ,(SELECT EC2.DESCRIPTION FROM EJS_CODES EC2 WHERE EC2.CODE_TYPE = A.ARREST_DSP_JAIL_CODE_TYPE AND EC2.CODE = A.ARREST_DSP_JAIL_CODE) ,A.BOND_TYPE ,(SELECT BTC.DESCRIPTION FROM BOND_TYPE_CODES BTC WHERE BTC.BOND_TYPE = A.BOND_TYPE) ,A.BOND_AMOUNT ,A.ARREST_CNTY_CODE ,(SELECT EC2.DESCRIPTION FROM EJS_CODES EC2 WHERE EC2.CODE_TYPE = A.ARREST_CNTY_CODE_TYPE AND EC2.CODE = A.ARREST_CNTY_CODE) ,A.INC_REPORT_NUMBER ,A.JAIL_DATE ,A.IMPOUND_ID ,A.VEHICLE_SEIZED_FLAG ,A.VEHICLE_STORED_FLAG ,A.CURRENCY_SEIZED_FLAG ,A.CURRENCY_TOTAL ,A.DISCHARGE_DATE ,A.STATUS_CODE ,(SELECT S.DESCRIPTION FROM EJS_CODES S WHERE S.CODE_TYPE = A.STATUS_CODE_TYPE AND S.CODE = A.STATUS_CODE) ,A.CASE_NUMBER ,A.ADDR_ADDRESS_ID ,EJS_FORMAT_ADDRESS(A.ADDR_ADDRESS_ID) ,ADDR.STREET_NUMBER ,ADDR.DIRCT_CD_DIRECTION_CODE ,ADDR.STREET_NAME ,ADDR.STREET_CD_STREET_TYPE_CODE ,(SELECT DESCRIPTION FROM EJS_CODES WHERE CODE_TYPE = ADDR.STREET_CD_STREET_TYPE_COD_TYPE AND CODE = ADDR.STREET_CD_STREET_TYPE_CODE) AS STREET_TYPE_DESC ,ADDR.ADDR_SC_ADDRESS_SUBTYPE_CODE ,(SELECT DESCRIPTION FROM EJS_CODES WHERE CODE_TYPE = ADDR.ADDR_SC_ADDRESS_SUBTYPE_C_TYPE AND CODE = ADDR.ADDR_SC_ADDRESS_SUBTYPE_CODE) AS ADDRESS_SUBTYPE_DESC ,ADDR.SUB_NUMBER ,ADDR.INTRSECT1_STREET_NUMBER ,ADDR.INTRSECT1_DIR ,ADDR.INTRSECT1_NAME ,CASE WHEN ADDR.BEAT IS NOT NULL AND ADDR.SUB_BEAT IS NOT NULL THEN ADDR.BEAT||'-'||ADDR.SUB_BEAT ELSE ADDR.BEAT||ADDR.SUB_BEAT END ,ADDR.CITY ,ADDR.STATE_CD_STATE_CODE ,(SELECT ST.DESCRIPTION FROM EJS_CODES ST WHERE ST.CODE_TYPE = ADDR.STATE_CD_STATE_CODE_TYPE AND ST.CODE = ADDR.STATE_CD_STATE_CODE) AS STATE_DESC ,ADDR.ZIP5 ,TO_CHAR(ADDR.ZIP4, 'FM0000') ,ADDR.LATITUDE ,ADDR.LONGITUDE FROM ARRESTS A LEFT OUTER JOIN ADDRESSES ADDR ON A.ADDR_ADDRESS_ID = ADDR.ADDRESS_ID
 
Possibly Referenced Tables/Views:
ADDRESSES AGENCY_CODES ARRESTS BOND_TYPE_CODES EJS_CODES 


Close relationships: