View slot9.WORLD.TSTA.WARRANT_PERSON_ADDR_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
WARRANT_ID number 0
E_WARRANTS.WARRANT_ID Implied Constraint R
WSC_CODE varchar2 30
PLAINTIFF varchar2 100
DATE_ISSUED date 7  √  null
BOND_AMOUNT number 12,2  √  null
BOND_TYPE varchar2 2  √  null
BOND_TYPE_CODES.BOND_TYPE Implied Constraint R
SYS_ID varchar2 100  √  null
ISSUING_AGENCY varchar2 30
ISSUING_AGENCY_DESC varchar2 40  √  null
JUDGE varchar2 255  √  null
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE Implied Constraint R
AGENCY_DESC varchar2 40  √  null
WAR_STATE_CODE varchar2 30
PERSON_ID number 0
JAIL_PEOPLE.PERSON_ID Implied Constraint R
MN_ID number 0
PERSON_NAME_LFM varchar2 263  √  null
PERSON_NAME_FML varchar2 262  √  null
DOB date 7  √  null
SSN number 0  √  null
ADDRESS_ID number 0  √  null
ADDRESSES.ADDRESS_ID Implied Constraint R
STREET_NUMBER varchar2 10  √  null
DIRECTION_CODE varchar2 30  √  null
STREET_NAME varchar2 40  √  null
STREET_TYPE_CODE varchar2 30  √  null
DIRECT_SUFFIX varchar2 30  √  null
SUB_TYPE_CODE varchar2 30  √  null
SUBSCRIPTION_TYPE_CODES.SUB_TYPE_CODE Implied Constraint R
SUB_NUMBER varchar2 50  √  null
CITY varchar2 40  √  null
CITY_CODE varchar2 30  √  null
STATE_CODE varchar2 30  √  null
ZIP5 varchar2 30  √  null
ZIP4 number 0  √  null
LATITUDE varchar2 30  √  null
LONGITUDE varchar2 30  √  null
BEAT varchar2 30  √  null
SUB_BEAT varchar2 30  √  null
ADDRESS_SUMMARY varchar2 4000  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT ewar.warrant_id, ewar.wsc_code, ewar.plaintiff, ewar.date_issued, ewar.bond_amount, ewar.bnd_typ_cd_bond_type "BOND_TYPE", ewar.sys_id, ewar.issuing_agency, ac_iss.agency_desc "ISSUING_AGENCY_DESC", ewar.judge, ewar.agency_code, ac.agency_desc, ewar.state_cd_state_code "WAR_STATE_CODE", ewar.mn_per_person_id "PERSON_ID", ewar.mn_mn_id "MN_ID", TRIM (mn.lname || ', ' || mn.fname || ' ' || mn.mname) "PERSON_NAME_LFM", TRIM ( mn.fname || ' ' || DECODE (mn.mname, NULL, mn.lname, mn.mname || ' ' || mn.lname)) "PERSON_NAME_FML", mn.dob, mn.ssn, addr.address_id, addr.street_number, addr.dirct_cd_direction_code "DIRECTION_CODE", addr.street_name, addr.street_cd_street_type_code "STREET_TYPE_CODE", addr.direct_suffix, addr.addr_sc_address_subtype_code "SUB_TYPE_CODE", addr.sub_number, addr.city, addr.city_cd_city_code "CITY_CODE", addr.state_cd_state_code "STATE_CODE", addr.zip5, addr.zip4, addr.latitude, addr.longitude, addr.beat, addr.sub_beat, ejs_addresses.address_summary (addr.address_id) "ADDRESS_SUMMARY" FROM e_warrants ewar, master_names mn, agency_codes ac, agency_codes ac_iss, (SELECT person_id, address_id, date_of_info, creator_date FROM person_addresses pa WHERE (date_of_info, creator_date) = (SELECT MAX (date_of_info), MAX (creator_date) FROM person_addresses WHERE person_id = pa.person_id)) pa, addresses addr WHERE ewar.mn_mn_id = mn.mn_id AND ewar.mn_per_person_id = mn.per_person_id AND ac_iss.agency_code = ewar.issuing_agency AND ac.agency_code = ewar.agency_code AND ewar.mn_per_person_id = pa.person_id AND pa.address_id = addr.address_id(+)
 
Possibly Referenced Tables/Views:
ADDRESSES AGENCY_CODES E_WARRANTS MASTER_NAMES PERSON_ADDRESSES 


Close relationships: