|
|
| 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 |
| WARRANT_ID |
number |
0 |
|
|
|
|
|
| STATUS_DESC |
varchar2 |
4000 |
√ |
|
null |
|
|
| DATE_ISSUED |
date |
7 |
√ |
|
null |
|
|
| ISSUING_AGENCY_DESC |
varchar2 |
40 |
√ |
|
null |
|
|
| REFERENCE_NUMS |
varchar2 |
4000 |
√ |
|
null |
|
|
| PERSON_NAME |
varchar2 |
263 |
√ |
|
null |
|
|
Analyzed at Mon Sep 20 21:05 MDT 2021
|
View Definition:
SELECT DISTINCT
ewar.warrant_id,
ec.description,
ewar.date_issued,
ac_iss.agency_desc "ISSUING_AGENCY_DESC",
JOIN (
CURSOR (
SELECT DISTINCT
REPLACE (wr.reference_type, '_', ' ')
|| ': '
|| wr.reference_id
FROM warrant_references wr
WHERE WR.WARRANT_ID = EWAR.WARRANT_ID),
', '),
TRIM (mn.lname || ', ' || mn.fname || ' ' || mn.mname)
"PERSON_NAME_LFM"
FROM e_warrants ewar,
master_names mn,
people p,
master_people mp,
agency_codes ac,
agency_codes ac_iss,
ejs_codes ec
WHERE ewar.mn_mn_id = mn.mn_id
AND ewar.mn_per_person_id = mn.per_person_id
AND ewar.mn_per_person_id = p.person_id
AND p.master_person_id = mp.master_person_id
AND ac_iss.agency_code = ewar.issuing_agency
AND ac.agency_code = ewar.agency_code
AND ec.code = EWAR.WSC_CODE and ec.code_type = EWAR.WSC_CODE_TYPE
Possibly Referenced Tables/Views:
