TIBURON (FORMERLY COMPUDYNE - PUBLIC SAFETY - SOFTWARE LICENSE) 2006

Home Browse Search

Santa Ana, CA Attachment 2 -Ab Data Dictonary Messages replyflag Reserved for Future Use bit fdid Fire Dept. ID char incidentnumber Incident Number char incidentdate Incident Date datetime station Fire Department Station char incidenttype Incident Type varchar alarmdatetime Alarm Date and Time datetime controlleddatetime Incident Controlled Date and Time datetime district District char locationtype Location Type char number Number or Milepost varchar streetprefix Street Prefix char street Street or Highway Name varchar streettype Street Type char streetsuffix Street Suffix char apartment Apartment Number char city City varchar state State char postalcode Zip char directions Directions text xstreetprefix Cross Street Prefix char xstreet Cross Street or Highway Name varchar xstreettype Cross Street Type char xstreetsuffx Cross Street Suffix char addressl UnParsed 1st Address Line char citystatezip UnParsed CityStateZip char address2 UnParsed 2nd Address Line char latitude Latitude decimal longitude Longitude decimal township Township decimal northsouth North /South char range Range int eastwest East/West char section Section smallint subsection Subsection char meridian Meridian char remarks Incident Remarks text remarkssequence Remarks Sequence bigint commonname Common Name varchar returntoservicedatetime Return to Service Time datetime alarms Alarms tinyint emspatients Ems Patients from CAD int emsruncard Run Card char cadcallnumber CAD Call Number varchar phone Phone Number char messagecontrolnumber Message Control # bigint messagesenderid Message Sender ID varchar ... ... 1 5 7 16 3 255 16 16 8 4 10 2 30 4 2 15 20 2 9 2 30 4 2 255 255 255 10 11 20 1 4 1 2 4 2 32 16 15 25 10 50 1 CompuDyne Public Safety Justice, Inc