|
|
| 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 |
| ARREST_ID |
number |
0 |
|
|
|
|
| ARRESTS.ARREST_ID
|
Implied Constraint R |
|
| AGENCY_CODE |
varchar2 |
100 |
|
|
|
|
|
| ARREST_NUM |
varchar2 |
100 |
|
|
|
|
|
| PERSON_ID |
number |
0 |
|
|
|
|
|
| PRIMARY_PERSON_ID |
number |
0 |
|
|
|
|
|
| MASTER_PERSON_ID |
number |
0 |
|
|
|
|
|
| ARREST_DATE |
date |
7 |
|
|
|
|
|
| VEHICLE_ID |
number |
0 |
√ |
|
null |
|
|
| 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 |
|
|
|
|
|
| RACE_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| SEX_CODE |
varchar2 |
30 |
|
|
|
|
|
| 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 |
|
|
| 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,
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
LEFT OUTER JOIN VEHICLES V
ON A.VEH_VEHICLE_ID = V.VEHICLE_ID
WHERE MN.NAME_TYPE_CODE = 'P'
Possibly Referenced Tables/Views:
