|
|
| 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 |
| HEADER |
char |
2 |
√ |
|
null |
|
|
| ACTION |
varchar2 |
0 |
√ |
|
null |
|
|
| LABEL |
varchar2 |
0 |
√ |
|
null |
|
|
| UPDATE_DATE |
date |
7 |
√ |
|
null |
|
|
| UPDATE_TIME |
varchar2 |
4 |
√ |
|
null |
|
|
| AGENCY |
varchar2 |
9 |
√ |
|
null |
|
|
| WARRANT_UNIQUE_ID |
number |
0 |
|
|
|
|
|
| WARRANT_NUMBER |
number |
0 |
|
|
|
|
|
| WARRANT_CHARGE_UNIQUE_ID |
number |
12 |
|
|
|
|
|
| WARRANT_AGENCY_NAME |
varchar2 |
40 |
√ |
|
null |
|
|
| WARRANT_AGENCY_STATE |
varchar2 |
2 |
√ |
|
null |
|
|
| CHARGE_SEQUENCE |
varchar2 |
0 |
√ |
|
null |
|
|
| CHARGE_COUNT |
number |
5 |
√ |
|
null |
|
|
| CHARGE_CODE |
varchar2 |
30 |
|
|
|
|
|
| CHARGE_DESCRIPTION |
varchar2 |
255 |
√ |
|
null |
|
|
| SEVERITY_TEXT |
varchar2 |
1024 |
√ |
|
null |
|
|
| BOND_AMOUNT |
number |
12,2 |
√ |
|
null |
|
|
| BOND_TYPE |
varchar2 |
2 |
√ |
|
null |
|
|
| FINE_AMOUNT |
varchar2 |
0 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
select distinct
'WC' HEADER,
null ACTION,
null LABEL,
wc.updator_date UPDATE_DATE,
to_char(wc.updator_date, 'HH24MI') UPDATE_TIME,
ac.ori_number AGENCY,
ewar.warrant_id WARRANT_UNIQUE_ID,
ewar.warrant_id WARRANT_NUMBER,
wc.warrant_charge_id WARRANT_CHARGE_UNIQUE_ID,
ac.agency_desc WARRANT_AGENCY_NAME,
ac.agency_state WARRANT_AGENCY_STATE,
null CHARGE_SEQUENCE,
wc.charge_count CHARGE_COUNT,
wc.cha_code CHARGE_CODE,
cc.cha_desc CHARGE_DESCRIPTION,
wc.remark SEVERITY_TEXT,
ewar.bond_amount BOND_AMOUNT,
ewar.bnd_typ_cd_bond_type BOND_TYPE,
null FINE_AMOUNT
from warrant_charges wc,
e_warrants ewar,
agency_codes ac,
charge_codes cc
where ewar.warrant_id = wc.ewar_warrant_id
--and ac.agency_code = ewar.agncy_cd_agency_code --18230
and ac.agency_code = ewar.agency_code
and cc.code = wc.cha_code
Possibly Referenced Tables/Views:
