View slot9.WORLD.TSTA.JS_WARRANT_OFFENSE_CHARGE_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  √  null
E_WARRANTS.WARRANT_ID Implied Constraint R
WARRANT_STATUS_CODE varchar2 30  √  null
WARRANT_STATUS varchar2 4000  √  null
PLAINTIFF varchar2 100  √  null
DATE_ISSUED date 7  √  null
BOND_AMOUNT number 12,2  √  null
BOND_TYPE varchar2 2  √  null
BOND_TYPE_CODES.BOND_TYPE Implied Constraint R
BOND_TYPE_DESC varchar2 40  √  null
SYS_ID varchar2 100  √  null
ISSUING_AGENCY varchar2 30  √  null
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
STATE_CODE varchar2 30  √  null
PERSON_ID number 0  √  null
JAIL_PEOPLE.PERSON_ID Implied Constraint R
MN_MN_ID number 0  √  null
PERSON_NAME_LFM varchar2 263  √  null
PERSON_NAME_FML varchar2 262  √  null
DOB date 7  √  null
SSN number 0  √  null
MASTER_PERSON_ID number 0  √  null
MASTER_PEOPLE.MASTER_PERSON_ID Implied Constraint R
RACE_CODE varchar2 30  √  null
RACE_DESC varchar2 4000  √  null
SEX_CODE varchar2 30  √  null
SEX_DESC varchar2 4000  √  null
WAR_OFFNS_CHRG_TYPE varchar2 16  √  null
OFFENSE_CODE varchar2 40  √  null
OFFENSE_DESC varchar2 4000  √  null
WAR_OFFNS_CHRG_CREATOR_DATE date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT ewar.warrant_id, ewar.wsc_code, (SELECT W.DESCRIPTION FROM EJS_CODES W WHERE W.CODE = ewar.wsc_code AND W.CODE_TYPE = ewar.wsc_code_type), ewar.plaintiff, ewar.date_issued, ewar.bond_amount, ewar.bnd_typ_cd_bond_type "BOND_TYPE", (SELECT DESCRIPTION FROM BOND_TYPE_CODES WHERE BOND_TYPE = ewar.bnd_typ_cd_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 "STATE_CODE", ewar.mn_per_person_id person_id, ewar.mn_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, MP.MASTER_PERSON_ID, MP.RACE_CODE, (SELECT R.DESCRIPTION FROM EJS_CODES R WHERE R.CODE = MP.RACE_CODE AND R.CODE_TYPE = MP.RACE_CODE_TYPE), MP.SEX_CODE, (SELECT S.DESCRIPTION FROM EJS_CODES S WHERE S.CODE = MP.RACE_CODE AND S.CODE_TYPE = MP.RACE_CODE_TYPE), 'CHARGES', wc.cha_code, cc.cha_desc, wc.creator_date FROM e_warrants ewar, master_names mn, people p, master_people mp, agency_codes ac, agency_codes ac_iss, warrant_charges wc, charge_codes cc 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.warrant_id = wc.ewar_warrant_id AND wc.cha_code = cc.CODE AND mn.per_person_id = p.person_id AND mp.master_person_id = p.master_person_id UNION SELECT ewar.warrant_id, ewar.wsc_code, (SELECT W.DESCRIPTION FROM EJS_CODES W WHERE W.CODE = ewar.wsc_code AND W.CODE_TYPE = ewar.wsc_code_type), ewar.plaintiff, ewar.date_issued, ewar.bond_amount, ewar.bnd_typ_cd_bond_type "BOND_TYPE", (SELECT DESCRIPTION FROM BOND_TYPE_CODES WHERE BOND_TYPE = ewar.bnd_typ_cd_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 "STATE_CODE", ewar.mn_per_person_id person_id, ewar.mn_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, MP.MASTER_PERSON_ID, MP.RACE_CODE, (SELECT R.DESCRIPTION FROM EJS_CODES R WHERE R.CODE = MP.RACE_CODE AND R.CODE_TYPE = MP.RACE_CODE_TYPE), MP.SEX_CODE, (SELECT S.DESCRIPTION FROM EJS_CODES S WHERE S.CODE = MP.RACE_CODE AND S.CODE_TYPE = MP.RACE_CODE_TYPE), 'FREETEXT_CHARGES', TO_CHAR (wfc.freetext_charge_id), wfc.warrant_charge, wfc.creator_date FROM e_warrants ewar, master_names mn, people p, master_people mp, agency_codes ac, agency_codes ac_iss, warrant_freetext_charges wfc 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.warrant_id = wfc.warrant_id AND mn.per_person_id = p.person_id AND mp.master_person_id = p.master_person_id UNION SELECT ewar.warrant_id, ewar.wsc_code, (SELECT W.DESCRIPTION FROM EJS_CODES W WHERE W.CODE = ewar.wsc_code AND W.CODE_TYPE = ewar.wsc_code_type), ewar.plaintiff, ewar.date_issued, ewar.bond_amount, ewar.bnd_typ_cd_bond_type "BOND_TYPE", (SELECT DESCRIPTION FROM BOND_TYPE_CODES WHERE BOND_TYPE = ewar.bnd_typ_cd_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 "STATE_CODE", ewar.mn_per_person_id person_id, ewar.mn_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, MP.MASTER_PERSON_ID, MP.RACE_CODE, (SELECT R.DESCRIPTION FROM EJS_CODES R WHERE R.CODE = MP.RACE_CODE AND R.CODE_TYPE = MP.RACE_CODE_TYPE), MP.SEX_CODE, (SELECT S.DESCRIPTION FROM EJS_CODES S WHERE S.CODE = MP.RACE_CODE AND S.CODE_TYPE = MP.RACE_CODE_TYPE), 'ARREST_CHARGES', wac.arrest_charge_code, ar_cc.arrest_cha_desc, ar_cc.creator_date FROM e_warrants ewar, master_names mn, people p, master_people mp, agency_codes ac, agency_codes ac_iss, warrant_arrest_charges wac, arrest_charge_codes ar_cc 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.warrant_id = wac.warrant_id AND wac.arrest_charge_code = ar_cc.arrest_charge_code AND mn.per_person_id = p.person_id AND mp.master_person_id = p.master_person_id
 
Possibly Referenced Tables/Views:
AGENCY_CODES ARREST_CHARGE_CODES ARREST_CHARGES BOND_TYPE_CODES CHARGE_CODES E_WARRANTS EJS_CODES MASTER_NAMES MASTER_PEOPLE PEOPLE WARRANT_ARREST_CHARGES WARRANT_CHARGES WARRANT_FREETEXT_CHARGES 


Close relationships: