View slot9.WORLD.TSTA.ARREST_PERSON_SEARCH_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  √  null
ARRESTS.ARREST_ID Implied Constraint R
AGENCY_CODE varchar2 100  √  null
ARREST_NUM varchar2 100  √  null
PERSON_ID number 0  √  null
JAIL_PEOPLE.PERSON_ID Implied Constraint R
PRIMARY_PERSON_ID number 0  √  null
MASTER_PERSON_ID number 0  √  null
MASTER_PEOPLE.MASTER_PERSON_ID Implied Constraint R
ARREST_DATE date 7  √  null
VEHICLE_ID number 0  √  null
DEPARTMENT_VEHICLES.VEHICLE_ID Implied Constraint R
ADDRESS_ID number 38  √  null
ARREST_COMMENT varchar2 4000  √  null
VIN varchar2 20  √  null
LAST_NAME varchar2 100  √  null
FIRST_NAME varchar2 80  √  null
RACE_CODE varchar2 30  √  null
RACE_DESC varchar2 4000  √  null
SEX_CODE varchar2 30  √  null
SEX_DESC varchar2 4000  √  null
AGE_AT_TIME_OF_ARREST varchar2 30  √  null
STATUS_CODE varchar2 30  √  null
STATUS_DESC varchar2 4000  √  null
REVIEW_STATUS_CODE varchar2 30  √  null
REVIEW_STATUS_DESC varchar2 4000  √  null
DISPOSITION_CODE varchar2 30  √  null
DISPOSITION_DESC varchar2 4000  √  null
DL varchar2 4000  √  null
TOWING_CO_NAME varchar2 40  √  null
REPORT_NUMBER varchar2 20  √  null
JAIL_DATE date 7  √  null
JAIL_COUNTY_DESC varchar2 4000  √  null
JAIL_DESC varchar2 4000  √  null
LOCAL_JAIL_CODE varchar2 30  √  null
LOCAL_JAIL_DESC varchar2 4000  √  null
CREATOR_ID varchar2 100  √  null
ARREST_PERSON_ID number 0  √  null
ARREST_PEOPLE.ARREST_PERSON_ID Implied Constraint R
PERSON_MASTER_ID number 0  √  null
PERSON_LAST_NAME varchar2 100  √  null
PERSON_FIRST_NAME varchar2 80  √  null
PERSON_DOB date 7  √  null
PERSON_SEX_CODE varchar2 30  √  null
PERSON_SEX_DESC varchar2 4000  √  null
PERSON_RACE_CODE varchar2 30  √  null
PERSON_RACE_DESC varchar2 4000  √  null
PERSON_SSN number 0  √  null
PERSON_ROLES varchar2 4000  √  null
ROLE_TYPE char 1  √  null
EXPUNGE varchar2 1  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT A.ARREST_ID, A.AGENCY_CODE, A.ARREST_NUM, A.PERSON_ID, P.PERSON_ID, P.MASTER_PERSON_ID, A.ARREST_DATE, A.VEH_VEHICLE_ID AS VEHICLE_ID, A.ADDR_ADDRESS_ID AS ADDRESS_ID, A.ARR_COMMENT, V.VIN, MN.LNAME AS LAST_NAME, MN.FNAME AS FIRST_NAME, MP.RACE_CODE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = MP.RACE_CODE_TYPE AND EC.CODE = MP.RACE_CODE) AS RACE_DESC, MP.SEX_CODE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = MP.SEX_CODE_TYPE AND EC.CODE = MP.SEX_CODE) AS SEX_DESC, A.ARRESTEE_AGE_CODE, A.STATUS_CODE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = A.STATUS_CODE_TYPE AND EC.CODE = A.STATUS_CODE) AS STATUS_DESC, A.REVIEW_STATUS_CODE AS REVIEW_STATUS_CODE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = A.REVIEW_STATUS_CODE_TYPE AND EC.CODE = A.REVIEW_STATUS_CODE) AS REVIEW_STATUS_DESC, ARREST_DSP_CODE as DISPOSITION_CODE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = A.ARREST_DSP_CODE_TYPE AND EC.CODE = A.ARREST_DSP_CODE) AS DISPOSITION_DESC, EJS_GET_LATEST_PERSON_DL (P.PERSON_ID, 'N') AS DL, A.TOWING_CO_NAME, A.INC_REPORT_NUMBER, A.JAIL_DATE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = A.ARREST_DSP_CNTY_CODE_TYPE AND EC.CODE = A.ARREST_DSP_CNTY_CODE) AS JAIL_COUNTY_DESC, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = A.ARREST_DSP_JAIL_CODE_TYPE AND EC.CODE = A.ARREST_DSP_JAIL_CODE) AS JAIL_DESC, A.LOCAL_JAIL_CODE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = A.LOCAL_JAIL_CODE_TYPE AND EC.CODE = A.LOCAL_JAIL_CODE) AS JAIL_DESC, A.CREATOR_ID, AP.ARREST_PERSON_ID, OMP.MASTER_PERSON_ID, OMN.LNAME, OMN.FNAME, OMN.DOB, OMP.SEX_CODE, PSC.DESCRIPTION AS SEX_DESC, OMP.RACE_CODE, PRC.DESCRIPTION AS RACE_DESC, OMN.SSN, (JOIN(CURSOR(SELECT RC.ROLE_DESC FROM ARREST_PERSON_ROLES APR INNER JOIN ROLE_CODES RC ON APR.ROLE_CODE = RC.ROLE_TYPE WHERE APR.ARREST_PERSON_ID = AP.ARREST_PERSON_ID))), 'O', A.EXPUNGE FROM ARRESTS A INNER JOIN PEOPLE P2 ON A.PERSON_ID = P2.PERSON_ID INNER JOIN MASTER_PEOPLE MP ON P2.MASTER_PERSON_ID = MP.MASTER_PERSON_ID INNER JOIN PEOPLE P ON MP.MASTER_PERSON_ID = P.MASTER_PERSON_ID INNER JOIN MASTER_NAMES MN ON P.PERSON_ID = MN.PER_PERSON_ID INNER JOIN ARREST_PEOPLE AP ON A.ARREST_ID = AP.ARREST_ID INNER JOIN PEOPLE OP ON AP.PERSON_ID = OP.PERSON_ID INNER JOIN MASTER_NAMES OMN ON OP.PERSON_ID = OMN.PER_PERSON_ID INNER JOIN MASTER_PEOPLE OMP ON OP.MASTER_PERSON_ID = OMP.MASTER_PERSON_ID LEFT OUTER JOIN VEHICLES V ON A.VEH_VEHICLE_ID = V.VEHICLE_ID LEFT OUTER JOIN EJS_CODES PRC ON OMP.RACE_CODE_TYPE = PRC.CODE_TYPE AND OMP.RACE_CODE = PRC.CODE LEFT OUTER JOIN EJS_CODES PSC ON OMP.SEX_CODE_TYPE = PSC.CODE_TYPE AND OMP.SEX_CODE = PSC.CODE WHERE MN.NAME_TYPE_CODE = 'P' UNION SELECT A.ARREST_ID, A.AGENCY_CODE, A.ARREST_NUM, A.PERSON_ID, P.PERSON_ID, P.MASTER_PERSON_ID, A.ARREST_DATE, A.VEH_VEHICLE_ID AS VEHICLE_ID, A.ADDR_ADDRESS_ID AS ADDRESS_ID, A.ARR_COMMENT, V.VIN, MN.LNAME AS LAST_NAME, MN.FNAME AS FIRST_NAME, MP.RACE_CODE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = MP.RACE_CODE_TYPE AND EC.CODE = MP.RACE_CODE) AS RACE_DESC, MP.SEX_CODE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = MP.SEX_CODE_TYPE AND EC.CODE = MP.SEX_CODE) AS SEX_DESC, A.ARRESTEE_AGE_CODE, A.STATUS_CODE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = A.STATUS_CODE_TYPE AND EC.CODE = A.STATUS_CODE) AS STATUS_DESC, A.REVIEW_STATUS_CODE AS REVIEW_STATUS_CODE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = A.REVIEW_STATUS_CODE_TYPE AND EC.CODE = A.REVIEW_STATUS_CODE) AS REVIEW_STATUS_DESC, ARREST_DSP_CODE as DISPOSITION_CODE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = A.ARREST_DSP_CODE_TYPE AND EC.CODE = A.ARREST_DSP_CODE) AS DISPOSITION_DESC, EJS_GET_LATEST_PERSON_DL (P.PERSON_ID, 'N') AS DL, A.TOWING_CO_NAME, A.INC_REPORT_NUMBER, A.JAIL_DATE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = A.ARREST_DSP_CNTY_CODE_TYPE AND EC.CODE = A.ARREST_DSP_CNTY_CODE) AS JAIL_COUNTY_DESC, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = A.ARREST_DSP_JAIL_CODE_TYPE AND EC.CODE = A.ARREST_DSP_JAIL_CODE) AS JAIL_DESC, A.LOCAL_JAIL_CODE, (SELECT EC.DESCRIPTION FROM EJS_CODES EC WHERE EC.CODE_TYPE = A.LOCAL_JAIL_CODE_TYPE AND EC.CODE = A.LOCAL_JAIL_CODE) AS JAIL_DESC, A.CREATOR_ID, null, OMP.MASTER_PERSON_ID, OMN.LNAME, OMN.FNAME, OMN.DOB, OMP.SEX_CODE, PSC.DESCRIPTION AS SEX_DESC, OMP.RACE_CODE, PRC.DESCRIPTION AS RACE_DESC, OMN.SSN, (SELECT ROLE_DESC FROM ROLE_CODES WHERE ROLE_TYPE = 'V'), 'V', A.EXPUNGE FROM ARRESTS A INNER JOIN PEOPLE P2 ON A.PERSON_ID = P2.PERSON_ID INNER JOIN MASTER_PEOPLE MP ON P2.MASTER_PERSON_ID = MP.MASTER_PERSON_ID INNER JOIN PEOPLE P ON MP.MASTER_PERSON_ID = P.MASTER_PERSON_ID INNER JOIN MASTER_NAMES MN ON P.PERSON_ID = MN.PER_PERSON_ID INNER JOIN DOMESTIC_VIOLENCE_VICTIMS DVV ON A.ARREST_ID = DVV.ARREST_ID INNER JOIN PEOPLE OP ON DVV.PERSON_ID = OP.PERSON_ID INNER JOIN MASTER_NAMES OMN ON OP.PERSON_ID = OMN.PER_PERSON_ID INNER JOIN MASTER_PEOPLE OMP ON OP.MASTER_PERSON_ID = OMP.MASTER_PERSON_ID LEFT OUTER JOIN VEHICLES V ON A.VEH_VEHICLE_ID = V.VEHICLE_ID LEFT OUTER JOIN EJS_CODES PRC ON OMP.RACE_CODE_TYPE = PRC.CODE_TYPE AND OMP.RACE_CODE = PRC.CODE LEFT OUTER JOIN EJS_CODES PSC ON OMP.SEX_CODE_TYPE = PSC.CODE_TYPE AND OMP.SEX_CODE = PSC.CODE WHERE MN.NAME_TYPE_CODE = 'P'
 
Possibly Referenced Tables/Views:
ARREST_PEOPLE ARREST_PERSON_ROLES ARRESTS DOMESTIC_VIOLENCE_VICTIMS EJS_CODES MASTER_NAMES MASTER_PEOPLE PEOPLE ROLE_CODES VEHICLES 


Close relationships: