|
|
| 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 |
| INC_INCIDENT_ID |
number |
0 |
|
|
|
|
|
| OFFENSE_NUMBER |
number |
0 |
|
|
|
|
|
| OFFNSE_CD_OFFENSE_STATUS_CODE |
varchar2 |
2 |
√ |
|
null |
|
|
| OFFNS_CD_OFFENSE_CODE |
varchar2 |
30 |
|
|
|
|
|
| PLACE_PLACE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| PRO_PROPERTY_ID |
number |
0 |
√ |
|
null |
|
|
| FEC_FORCED_ENTRY_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| PREMISES |
number |
38 |
√ |
|
null |
|
|
| SUPP_SEQ |
number |
5 |
|
|
|
|
|
| REMARKS |
varchar2 |
255 |
√ |
|
null |
|
|
| UCR_NUMBER |
number |
0 |
√ |
|
null |
|
|
| OFFENSE_STATUS_DATE |
date |
7 |
√ |
|
null |
|
|
| CREATOR_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| CREATOR_DATE |
date |
7 |
√ |
|
null |
|
|
| UPDATOR_ID |
varchar2 |
100 |
√ |
|
null |
|
|
| UPDATOR_DATE |
date |
7 |
√ |
|
null |
|
|
| DVU |
varchar2 |
1 |
√ |
|
null |
|
|
| CAC |
varchar2 |
1 |
√ |
|
null |
|
|
| CAMPUS_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| CHARGE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| CAMPUS_CODE_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| FEC_FORCED_ENTRY_CODE_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| BIAS_CODE_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| BIAS_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| AC_CODE_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| AC_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| PLACE_CODE_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| REC_ID |
number |
0 |
√ |
|
null |
|
|
| ARREST_CHARGE_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
| DV_RELATED_CODE_TYPE |
varchar2 |
30 |
√ |
|
null |
|
|
| DV_RELATED_CODE |
varchar2 |
30 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
select "INC_INCIDENT_ID","OFFENSE_NUMBER","OFFNSE_CD_OFFENSE_STATUS_CODE","OFFNS_CD_OFFENSE_CODE","PLACE_PLACE_CODE","PRO_PROPERTY_ID","FEC_FORCED_ENTRY_CODE","PREMISES","SUPP_SEQ","REMARKS","UCR_NUMBER","OFFENSE_STATUS_DATE","CREATOR_ID","CREATOR_DATE","UPDATOR_ID","UPDATOR_DATE","DVU","CAC","CAMPUS_CODE","CHARGE_CODE","CAMPUS_CODE_TYPE","FEC_FORCED_ENTRY_CODE_TYPE","BIAS_CODE_TYPE","BIAS_CODE","AC_CODE_TYPE","AC_CODE","PLACE_CODE_TYPE","REC_ID","ARREST_CHARGE_CODE","DV_RELATED_CODE_TYPE","DV_RELATED_CODE" from offenses o
where o.supp_seq in (
select max(o2.supp_seq)
from offenses o2
inner join incident_supplements isup on O2.INC_INCIDENT_ID = ISUP.INC_INCIDENT_ID
and o2.supp_seq = isup.supp_seq
where o2.inc_incident_Id = o.inc_incident_Id
and O2.OFFENSE_NUMBER = o.offense_number
AND ISUP.ISC_STATUS_CODE_TYPE = 'INCIDENT_STATUS_CODES' AND ISUP.ISC_STATUS_CODE = 'A'
)
Possibly Referenced Tables/Views:
