|
<br />F ~~~!~~~
<br />
<br />
<br />I EXAMPLES OF QUERIES [
<br />0 SELECT EVENTID, YEAR, MAKE, MODEL, COLOR, COMMENTS FROM
<br />EVENT VEHICLE WHERE TAG = '%PLATE%'
<br /> select vin,veh_make make,veh_model model,veh_coll coll,veh col2
<br /> col2,Vehicle_comment comments,veh_status_stolen -
<br />ZV S, veh_status_recovered R, veh_status_ evidence E, veh_status_ da maged
<br /> D,veh_status_found F,veh_status_seized Z,veh_persname
<br /> Owner,veh_address Address, cdoperid officer from vehicle where
<br /> lic_num = '%PLATE%' and lic_state = '%STATE%'
<br /> select ALRT_NOTES caution, (SELECT COUNT(WARRANT_ID) FROM
<br /> WARRANT WHERE PERSON.SEQNUM = WARRANT.PERSON_SEQNUM
<br /> AND WARRANT.5TATUS='Active' ) warrants,
<br /> rtrim(PERSON.surname) II ','II rtrim(PERSON.first_name) II'
<br /> 'II rtrim(PERSON.middle_name) name, person.dob, person.age,
<br />ZP person.sex, PERSON.str_numll"11 PERSON.street II" II
<br /> PERSON.apt_num II',' II PERSON.mun II' , II PERSON.state Address,
<br /> PERSON.RES_PHONE PHONE, PERSON.licENSE, PERSON.lic_state,
<br /> PERSON.5SN, person.seqnum, person.ALlAS_PERSON_SEQNUM from
<br /> person where upper(rtrim(surname) II ','II rtrim(firscname)) like
<br /> '%NAME%%' ORDER BY SURNAME,first name,middle name
<br /> select I.EVENTID, I.Involvement,
<br /> l.evTYPE,I.involve_type, I.occurr _date,l.agency,l.description, l.offense_id,l.
<br />ZP offense_descr from involvements I, person where PERSON_seqnum =
<br /> person.seqnum and upper(rtrim(surname) 11','11 rtrim(firscname)) like
<br /> '%NAME%%'
<br />0 select Eventid, Year, make, model, color, comments from event_vehicle
<br />where tag = '%PLATE%' and State = '%STATE%' and rownum < 11
<br /> SELECT EVENT.EVENTID,SUBSTRING(TYPE,l,15)
<br /> TYPE,SUBSTRING(DISPOSITION,l,10) DISPO,UPDATE_DATE FROM
<br />ZV EVENT,EVENT_VEHICLE WHERE EVENT_VEHICLE.TAG = '%PLATE%' AND
<br /> EVENT_VEHICLE.EVENTID = EVENT.EVENTID AND EVENT.CURRENT_REC
<br /> ='T'
<br />G SELECT EVENTID, YEAR, MAKE, MODEL, COLOR, COMMENTS FROM
<br />EVENT VEHICLE WHERE TAG = '%PLATE%'
<br />
<br />. IQjCAD _ CLETS/Orange County/NCIC/NLETS (bidirectional) via ComSys
<br />. IQjCAD _ Positron IQjMobile Software [(Positron lQ Mobile client), (bidirectional))
<br />
<br />CHANGE ORDER #2 to Computer Aided Dispatch Purchase Agreement A-2004-229
<br />Exhibit A.1 - IQ/CAD System Statement of Work
<br />
<br />Page 6 of 149
<br />
<br />~
<br />-
<br />
|