Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Fuck da police!!
- A lil somethin FROM NY criminal justice dpt. A dump OF they entire law file log!! fun times.
- Just FOR SOME laughs AND TO say fuck you TO the punk ass pigs!
- #AntiSec
- spool c:\temp\entire.log;
- DROP TABLE coded_nys_law_rank CASCADE CONSTRAINTS;
- CREATE TABLE coded_nys_law_rank (
- law_ordinal NUMBER(4) NULL,
- attempt VARCHAR2(1) NULL,
- charge_rank NUMBER(5) NULL
- );
- ALTER TABLE coded_nys_law_rank
- ADD ( CONSTRAINT coded_nys_law_rank_pk PRIMARY KEY (
- law_ordinal, attempt) ) ;
- ALTER TABLE coded_nys_law_rank
- MODIFY CHARGE_RANK
- CONSTRAINT CODEDNYSLAWRANK_CHGRANK_NN NOT NULL;
- DROP TABLE coded_nys_law_tca_link CASCADE CONSTRAINTS;
- CREATE TABLE coded_nys_law_tca_link (
- law_ordinal NUMBER(4) NULL,
- tca_code VARCHAR2(1) NULL
- );
- ALTER TABLE coded_nys_law_tca_link
- ADD ( CONSTRAINT coded_nys_law_tca_link_pk PRIMARY KEY (
- law_ordinal, tca_code) ) ;
- DROP TABLE coded_nys_law CASCADE CONSTRAINTS;
- CREATE TABLE coded_nys_law (
- law_ordinal NUMBER(4) NULL,
- attempted_dna_indicator VARCHAR2(2) NULL,
- dna_indicator VARCHAR2(2) NULL,
- attempted_class VARCHAR2(1) NULL,
- attempted_vf_indicator VARCHAR2(1) NULL,
- attempted_nys_law_category VARCHAR2(1) NULL,
- bus_driver_charge_code NUMBER(1) NULL,
- sex_offender_registry_code NUMBER(1) NULL,
- ncic_code NUMBER(4) NULL,
- ucr_code NUMBER(2) NULL,
- safis_crime_category_code NUMBER(2) NULL,
- offense_category VARCHAR2(3) NULL,
- jo_indicator NUMBER(1) NULL,
- jd_indicator NUMBER(1) NULL,
- ibr_code VARCHAR2(3) NULL,
- maxi_law_description VARCHAR2(60) NULL,
- law_description VARCHAR2(30) NULL,
- mini_law_description VARCHAR2(15) NULL,
- title VARCHAR2(3) NULL,
- SECTION VARCHAR2(9) NULL,
- section13 VARCHAR2(5) NULL,
- subsection VARCHAR2(6) NULL,
- subsection13 VARCHAR2(2) NULL,
- degree VARCHAR2(1) NULL,
- effective_date DATE NULL,
- repeal_date DATE NULL,
- fp_offense VARCHAR2(1) NULL CONSTRAINT codednyslaw_fpoffense_tf15 CHECK (fp_offense IN ('T', 'F')),
- unconst_date DATE NULL,
- weapon_charge NUMBER(1) NULL,
- armed_vfo_charge VARCHAR2(1) NULL CONSTRAINT codednyslaw_armedvfochg_tf15 CHECK (armed_vfo_charge IN ('T', 'F')),
- minors_charge NUMBER(1) NULL,
- career_criminal_charge VARCHAR2(1) NULL CONSTRAINT codednyslaw_careercrimchg_tf15 CHECK (career_criminal_charge IN ('T', 'F')),
- ins_charge VARCHAR2(1) NULL CONSTRAINT codednyslaw_inschg_tf15 CHECK (ins_charge IN ('T', 'F')),
- non_seal_charge VARCHAR2(1) NULL CONSTRAINT codednyslaw_nonsealchg_tf15 CHECK (non_seal_charge IN ('T', 'F')),
- sub_convict_charge VARCHAR2(1) NULL CONSTRAINT codednyslaw_subconvictchg_tf15 CHECK (sub_convict_charge IN ('T', 'F')),
- jail_charge VARCHAR2(1) NULL CONSTRAINT codednyslaw_jailchg_tf15 CHECK (jail_charge IN ('T', 'F')),
- post_convict_charge VARCHAR2(1) NULL CONSTRAINT codednyslaw_postconvictchg_t15 CHECK (post_convict_charge IN ('T', 'F')),
- auto_strip_charge VARCHAR2(1) NULL CONSTRAINT codednyslaw_autostripchg_tf15 CHECK (auto_strip_charge IN ('T', 'F')),
- full_law_description VARCHAR2(70) NULL,
- nys_law_category VARCHAR2(1) NULL,
- vf_indicator VARCHAR2(1) NULL,
- class VARCHAR2(1) NULL,
- escape_charge VARCHAR2(1) NULL CONSTRAINT codednyslaw_escapechg_tf8 CHECK (escape_charge IN ('T', 'F')),
- hate_crime NUMBER(1) NULL,
- date_invalidated DATE NULL,
- terrorism_indicator VARCHAR2(1) NULL CONSTRAINT codednyslaw_terrind_tf3 CHECK (terrorism_indicator IN ('T', 'F')),
- dmv_vtcode VARCHAR2(8) NULL
- );
- ALTER TABLE CODED_NYS_LAW
- MODIFY WEAPON_CHARGE
- CONSTRAINT CODEDNYSLAW_WEAPONCHG_NN NOT NULL;
- ALTER TABLE coded_nys_law
- ADD ( CONSTRAINT coded_nys_law_pk PRIMARY KEY (law_ordinal) ) ;
- ALTER TABLE coded_nys_law
- MODIFY LAW_DESCRIPTION
- CONSTRAINT CODEDNYSLAW_LAWDESC_NN NOT NULL;
- ALTER TABLE coded_nys_law
- MODIFY NCIC_CODE
- CONSTRAINT CODEDNYSLAW_NCICCODE_NN NOT NULL;
- DROP TABLE coded_nys_law_class CASCADE CONSTRAINTS;
- CREATE TABLE coded_nys_law_class (
- class VARCHAR2(1) NULL,
- class_description VARCHAR2(15) NULL
- );
- ALTER TABLE coded_nys_law_class
- ADD ( CONSTRAINT coded_nys_law_class_pk PRIMARY KEY (class) ) ;
- ALTER TABLE coded_nys_law_class
- MODIFY CLASS_DESCRIPTION
- CONSTRAINT CODEDNYSLAWCLASS_CLASSDESC_NN NOT NULL;
- DROP TABLE CODED_HATE_CRIME CASCADE CONSTRAINTS;
- CREATE TABLE CODED_HATE_CRIME (
- HATE_CRIME_CODE NUMBER(1) NULL,
- HATE_CRIME_DESCRIPTION VARCHAR2(65) NULL
- );
- ALTER TABLE CODED_HATE_CRIME
- ADD ( CONSTRAINT CODED_HATE_CRIME_PK PRIMARY KEY (HATE_CRIME_CODE) ) ;
- ALTER TABLE CODED_HATE_CRIME
- MODIFY HATE_CRIME_DESCRIPTION
- CONSTRAINT CODEDHATCRIM_HATECRIMEDESC_NN NOT NULL;
- DROP TABLE coded_bus_driver_charge CASCADE CONSTRAINTS;
- CREATE TABLE coded_bus_driver_charge (
- bus_driver_charge_code NUMBER(1) NULL,
- bus_driver_charge_description VARCHAR2(55) NULL
- );
- ALTER TABLE coded_bus_driver_charge
- ADD ( CONSTRAINT coded_bus_driver_charge_pk PRIMARY KEY (
- bus_driver_charge_code) ) ;
- ALTER TABLE coded_bus_driver_charge
- MODIFY BUS_DRIVER_CHARGE_DESCRIPTION
- CONSTRAINT CODEDBUSDRVCHG_BUSDRVCHGDSC_NN NOT NULL;
- DROP TABLE coded_nys_law_vf CASCADE CONSTRAINTS;
- CREATE TABLE coded_nys_law_vf (
- vf_indicator VARCHAR2(1) NULL,
- vf_description VARCHAR2(50) NULL
- );
- ALTER TABLE coded_nys_law_vf
- ADD ( CONSTRAINT coded_nys_law_vf_pk PRIMARY KEY (
- vf_indicator) ) ;
- ALTER TABLE coded_nys_law_vf
- MODIFY VF_DESCRIPTION
- CONSTRAINT CODEDNYSLAWVF_VFDESC_NN NOT NULL;
- DROP TABLE coded_ucr CASCADE CONSTRAINTS;
- CREATE TABLE coded_ucr (
- ucr_code NUMBER(2) NULL,
- ucr_description VARCHAR2(70) NULL
- );
- ALTER TABLE coded_ucr
- ADD ( CONSTRAINT coded_ucr_pk PRIMARY KEY (ucr_code) ) ;
- ALTER TABLE coded_ucr
- MODIFY UCR_DESCRIPTION
- CONSTRAINT CODEDUCR_UCRDESC_NN NOT NULL;
- DROP TABLE coded_tca CASCADE CONSTRAINTS;
- CREATE TABLE coded_tca (
- tca_code VARCHAR2(1) NULL,
- tca_description VARCHAR2(40) NULL
- );
- ALTER TABLE coded_tca
- ADD ( CONSTRAINT coded_tca_pk PRIMARY KEY (tca_code) ) ;
- ALTER TABLE coded_tca
- MODIFY TCA_DESCRIPTION
- CONSTRAINT CODEDTCA_TCADESC_NN NOT NULL;
- DROP TABLE coded_nys_law_category CASCADE CONSTRAINTS;
- CREATE TABLE coded_nys_law_category (
- nys_law_category VARCHAR2(1) NULL,
- nys_law_category_description VARCHAR2(11) NULL
- );
- ALTER TABLE coded_nys_law_category
- ADD ( CONSTRAINT coded_nys_law_category_pk PRIMARY KEY (
- nys_law_category) ) ;
- ALTER TABLE coded_nys_law_category
- MODIFY NYS_LAW_CATEGORY_DESCRIPTION
- CONSTRAINT CODEDNYSLAWCAT_CATDESC_NN NOT NULL;
- DROP TABLE coded_ncic CASCADE CONSTRAINTS;
- CREATE TABLE coded_ncic (
- ncic_code NUMBER(4) NULL,
- ncic_description VARCHAR2(61) NULL,
- dcjs_assigned VARCHAR2(1) NULL CONSTRAINT codedncic_dcjsassigned_tf9 CHECK (dcjs_assigned IN ('T', 'F'))
- );
- ALTER TABLE coded_ncic
- ADD ( CONSTRAINT coded_ncic_pk PRIMARY KEY (ncic_code) ) ;
- ALTER TABLE coded_ncic
- MODIFY NCIC_DESCRIPTION
- CONSTRAINT CODEDNCIC_NCICDESC_NN NOT NULL;
- DROP TABLE coded_ibr CASCADE CONSTRAINTS;
- CREATE TABLE coded_ibr (
- ibr_code VARCHAR2(3) NULL,
- ibr_description VARCHAR2(50) NULL
- );
- ALTER TABLE coded_ibr
- ADD ( CONSTRAINT coded_ibr_pk PRIMARY KEY (ibr_code) ) ;
- ALTER TABLE coded_ibr
- MODIFY IBR_DESCRIPTION
- CONSTRAINT CODEDIBR_IBRDESC_NN NOT NULL;
- DROP TABLE coded_nys_law_jd CASCADE CONSTRAINTS;
- CREATE TABLE coded_nys_law_jd (
- jd_indicator NUMBER(1) NULL,
- jd_description VARCHAR2(120) NULL
- );
- ALTER TABLE coded_nys_law_jd
- ADD ( CONSTRAINT coded_nys_law_jd_pk PRIMARY KEY (
- jd_indicator) ) ;
- ALTER TABLE coded_nys_law_jd
- MODIFY JD_DESCRIPTION
- CONSTRAINT CODEDNYSLAWJD_JDDESC_NN NOT NULL;
- DROP TABLE coded_nys_law_jo CASCADE CONSTRAINTS;
- CREATE TABLE coded_nys_law_jo (
- jo_indicator NUMBER(1) NULL,
- jo_description VARCHAR2(120) NULL
- );
- ALTER TABLE coded_nys_law_jo
- ADD ( CONSTRAINT coded_nys_jo_pk PRIMARY KEY (jo_indicator) ) ;
- ALTER TABLE coded_nys_law_jo
- MODIFY JO_DESCRIPTION
- CONSTRAINT CODEDNYSLAWJO_JODESC_NN NOT NULL;
- DROP TABLE coded_offense_category CASCADE CONSTRAINTS;
- CREATE TABLE coded_offense_category (
- offense_category VARCHAR2(3) NULL,
- offense_description VARCHAR2(35) NULL
- );
- ALTER TABLE coded_offense_category
- ADD ( CONSTRAINT coded_offense_category_pk PRIMARY KEY (
- offense_category) ) ;
- ALTER TABLE coded_offense_category
- MODIFY OFFENSE_DESCRIPTION
- CONSTRAINT CODEDOFFCAT_OFFDESC_NN NOT NULL;
- DROP TABLE coded_safis CASCADE CONSTRAINTS;
- CREATE TABLE coded_safis (
- safis_crime_category_code NUMBER(2) NULL,
- safis_description VARCHAR2(45) NULL
- );
- ALTER TABLE coded_safis
- ADD ( CONSTRAINT coded_safis_pk PRIMARY KEY (
- safis_crime_category_code) ) ;
- ALTER TABLE coded_safis
- MODIFY SAFIS_DESCRIPTION
- CONSTRAINT CODEDSAFIS_SAFISDESC_NN NOT NULL;
- DROP TABLE coded_sex_offender_registry CASCADE CONSTRAINTS;
- CREATE TABLE coded_sex_offender_registry (
- sex_offender_registry_code NUMBER(1) NULL,
- sex_offender_registry_literal VARCHAR2(80) NULL
- );
- ALTER TABLE coded_sex_offender_registry
- ADD ( CONSTRAINT coded_sex_offender_registry_pk PRIMARY KEY (
- sex_offender_registry_code) ) ;
- ALTER TABLE coded_sex_offender_registry
- MODIFY SEX_OFFENDER_REGISTRY_LITERAL
- CONSTRAINT CODEDSEXOFFREG_SEXOFFREGLIT_NN NOT NULL;
- DROP TABLE coded_attempt CASCADE CONSTRAINTS;
- CREATE TABLE coded_attempt (
- attempt VARCHAR2(1) NULL,
- attempt_description VARCHAR2(10) NULL
- );
- ALTER TABLE coded_attempt
- ADD ( CONSTRAINT coded_attempt_pk PRIMARY KEY (attempt) ) ;
- ALTER TABLE coded_attempt
- MODIFY ATTEMPT_DESCRIPTION
- CONSTRAINT CODEDATTEMPT_ATTEMPTDESC_NN NOT NULL;
- DROP TABLE coded_dna CASCADE CONSTRAINTS;
- CREATE TABLE coded_dna (
- dna_indicator VARCHAR2(2) NULL,
- dna_description VARCHAR2(400) NULL
- );
- ALTER TABLE coded_dna
- ADD ( CONSTRAINT coded_dna_pk PRIMARY KEY (dna_indicator) ) ;
- ALTER TABLE coded_dna
- MODIFY DNA_DESCRIPTION
- CONSTRAINT CODEDDNA_DNADESC_NN NOT NULL;
- ALTER TABLE coded_nys_law_rank
- ADD ( CONSTRAINT codednyslawrank_attempt_fk
- FOREIGN KEY (attempt)
- REFERENCES coded_attempt ) ;
- ALTER TABLE coded_nys_law_rank
- ADD ( CONSTRAINT codednyslawrank_laword_fk
- FOREIGN KEY (law_ordinal)
- REFERENCES coded_nys_law
- ON DELETE CASCADE ) ;
- ALTER TABLE coded_nys_law_tca_link
- ADD ( CONSTRAINT codednyslawtcalink_tcacode_fk
- FOREIGN KEY (tca_code)
- REFERENCES coded_tca ) ;
- ALTER TABLE coded_nys_law_tca_link
- ADD ( CONSTRAINT codednyslawtcalink_laword_fk
- FOREIGN KEY (law_ordinal)
- REFERENCES coded_nys_law
- ON DELETE CASCADE ) ;
- ALTER TABLE coded_nys_law
- ADD ( CONSTRAINT codednyslaw_attdnaind_fk
- FOREIGN KEY (attempted_dna_indicator)
- REFERENCES coded_dna ) ;
- ALTER TABLE coded_nys_law
- ADD ( CONSTRAINT codednyslaw_dnaindicator_fk
- FOREIGN KEY (dna_indicator)
- REFERENCES coded_dna ) ;
- ALTER TABLE coded_nys_law
- ADD ( CONSTRAINT codednyslawclass_class_fk
- FOREIGN KEY (class)
- REFERENCES coded_nys_law_class ) ;
- ALTER TABLE coded_nys_law
- ADD ( CONSTRAINT codednyslaw_attclass_fk
- FOREIGN KEY (attempted_class)
- REFERENCES coded_nys_law_class ) ;
- ALTER TABLE coded_nys_law
- ADD ( CONSTRAINT codednyslaw_vfind_fk
- FOREIGN KEY (vf_indicator)
- REFERENCES coded_nys_law_vf ) ;
- ALTER TABLE coded_nys_law
- ADD ( CONSTRAINT codednyslaw_attvfind_fk
- FOREIGN KEY (attempted_vf_indicator)
- REFERENCES coded_nys_law_vf ) ;
- ALTER TABLE coded_nys_law
- ADD ( CONSTRAINT codednyslaw_category_fk
- FOREIGN KEY (nys_law_category)
- REFERENCES coded_nys_law_category ) ;
- ALTER TABLE coded_nys_law
- ADD ( CONSTRAINT codednyslaw_attcategory_fk
- FOREIGN KEY (attempted_nys_law_category)
- REFERENCES coded_nys_law_category ) ;
- ALTER TABLE coded_nys_law
- ADD ( CONSTRAINT codednyslaw_busdriverchgcd_fk
- FOREIGN KEY (bus_driver_charge_code)
- REFERENCES coded_bus_driver_charge ) ;
- ALTER TABLE CODED_NYS_LAW
- ADD ( CONSTRAINT CODEDNYSLAW_WEAPONCHG_FK
- FOREIGN KEY (WEAPON_CHARGE)
- REFERENCES CODED_WEAPON_CHARGE (WEAPON_CHARGE_CODE));
- ALTER TABLE CODED_NYS_LAW
- ADD ( CONSTRAINT CODEDNYSLAW_MINORSCHG_FK
- FOREIGN KEY (MINORS_CHARGE)
- REFERENCES CODED_MINORS_CHARGE (MINORS_CHARGE_CODE));
- ALTER TABLE coded_nys_law
- ADD (CONSTRAINT CODEDNYSLAW_HATECRIME_FK
- FOREIGN KEY (HATE_CRIME)
- REFERENCES CODED_HATE_CRIME (HATE_CRIME_CODE));
- ALTER TABLE coded_nys_law
- ADD ( CONSTRAINT codednyslaw_sexoffregcode_fk
- FOREIGN KEY (sex_offender_registry_code)
- REFERENCES coded_sex_offender_registry ) ;
- ALTER TABLE coded_nys_law
- ADD ( CONSTRAINT codednyslaw_nciccode_fk
- FOREIGN KEY (ncic_code)
- REFERENCES coded_ncic ) ;
- ALTER TABLE coded_nys_law
- ADD ( CONSTRAINT codednyslaw_ucrcode_fk
- FOREIGN KEY (ucr_code)
- REFERENCES coded_ucr ) ;
- ALTER TABLE coded_nys_law
- ADD ( CONSTRAINT codednyslaw_safcrimecatcode_fk
- FOREIGN KEY (safis_crime_category_code)
- REFERENCES coded_safis ) ;
- ALTER TABLE coded_nys_law
- ADD ( CONSTRAINT codednyslaw_offensecategory_fk
- FOREIGN KEY (offense_category)
- REFERENCES coded_offense_category ) ;
- ALTER TABLE coded_nys_law
- ADD ( CONSTRAINT codednyslaw_joindicator_fk
- FOREIGN KEY (jo_indicator)
- REFERENCES coded_nys_law_jo ) ;
- ALTER TABLE coded_nys_law
- ADD ( CONSTRAINT codednyslaw_jdindicator_fk
- FOREIGN KEY (jd_indicator)
- REFERENCES coded_nys_law_jd ) ;
- ALTER TABLE coded_nys_law
- ADD ( CONSTRAINT codednyslaw_ibrcode_fk
- FOREIGN KEY (ibr_code)
- REFERENCES coded_ibr ) ;
- INSERT INTO CODED_ATTEMPT (ATTEMPT, ATTEMPT_DESCRIPTION)
- VALUES ('A','Attempted');
- INSERT INTO CODED_ATTEMPT (ATTEMPT, ATTEMPT_DESCRIPTION)
- VALUES ('C','Completed');
- INSERT INTO CODED_BUS_DRIVER_CHARGE (BUS_DRIVER_CHARGE_CODE,
- BUS_DRIVER_CHARGE_DESCRIPTION)
- VALUES (1, 'Bus Driver Charge regardless of conviction date'
- );
- INSERT INTO CODED_BUS_DRIVER_CHARGE (BUS_DRIVER_CHARGE_CODE,
- BUS_DRIVER_CHARGE_DESCRIPTION)
- VALUES (2, 'Bus Driver Charge if convicted within the last 5 years'
- );
- INSERT INTO CODED_BUS_DRIVER_CHARGE (BUS_DRIVER_CHARGE_CODE,
- BUS_DRIVER_CHARGE_DESCRIPTION)
- VALUES (3, 'Bus Driver Charge if convicted within the last 10 years'
- );
- INSERT INTO CODED_BUS_DRIVER_CHARGE (BUS_DRIVER_CHARGE_CODE,
- BUS_DRIVER_CHARGE_DESCRIPTION)
- VALUES (9, 'Not a Bus Driver Charge'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('09A', 'Murder and Non-Negligent Manslaughter'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('09B', 'Negligent Manslaughter'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('09C', 'Justifiable Homicide'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('100', 'Kidnaping'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('11A', 'Forcible Rape'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('11B', 'Forcible Sodomy'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('11C', 'Sexual Assault with an object'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('11D', 'Forcible Fondling'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('11E', 'Course of Repeated Sexual Contact'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('120', 'Robbery'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('13A', 'Aggravated Assault'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('13B', 'Simple Assault'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('13C', 'Intimidation'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('200', 'Arson'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('210', 'Extortion/Blackmail'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('220', 'Burglary/Breaking and Entering'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('23A', 'Pocket-Picking'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('23B', 'Purse-Snatching'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('23C', 'Shoplifting'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('23D', 'Theft from a Building'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('23E', 'Theft from a Coin-Operated Machine or Device'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('23F', 'Theft from a Motor Vehicle'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('23G', 'Theft of Motor Vehicle Parts or Accessories'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('23H', 'All Other Larceny'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('240', 'Motor Vehicle Theft'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('250', 'Counterfeiting/Forgery'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('26A', 'False Pretenses/Swindle/Confidence Game'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('26B', 'Credit Card/ATM Fraud'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('26C', 'Impersonation'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('26D', 'Welfare Fraud'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('26E', 'Wire Fraud'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('270', 'Embezzlement'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('280', 'Stolen Property Offenses'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('290', 'Destruction/Damage/Vandalism of Property'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('35A', 'Drug/Narcotic Violations'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('35B', 'Drug Equipment Violations'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('36A', 'Incest'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('36B', 'Statutory Rape'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('370', 'Pornography/Obscene Material'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('39A', 'Betting/Wagering'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('39B', 'Operating/Promoting/Assisting Gambling'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('39C', 'Gambling Equipment Violations'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('39D', 'Sports Tampering'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('40A', 'Prostitution'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('40B', 'Assisting or Promoting Prostitution'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('510', 'Bribery'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('520', 'Weapon Law Violations'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('90A', 'Bad Checks'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('90B', 'Curfew/Loitering/Vagrancy Violations'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('90C', 'Disorderly Conduct'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('90D', 'Driving Under the Influence'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('90E', 'Drunkenness'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('90F', 'Family Offense, Nonviolent'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('90G', 'Liquor Law Violations'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('90H', 'Peeping Tom'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('90I', 'Runaway'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('90J', 'Trespass of Real Property'
- );
- INSERT INTO CODED_IBR (IBR_CODE,
- IBR_DESCRIPTION)
- VALUES ('90Z', 'All Other Offenses'
- );
- INSERT INTO CODED_IBR (IBR_CODE, IBR_DESCRIPTION)
- VALUES ('999', 'Do Not Count'
- );
- INSERT INTO CODED_DNA (DNA_INDICATOR, DNA_DESCRIPTION)
- VALUES ('1','Convicted on or after Dec 1, 1999 or convicted prior to Dec 1, 1999 where sentence imposed has not been completed prior to Dec 1, 1999');
- INSERT INTO CODED_DNA (DNA_INDICATOR, DNA_DESCRIPTION)
- VALUES ('2','Convicted within the previous 5 years');
- INSERT INTO CODED_DNA (DNA_INDICATOR, DNA_DESCRIPTION)
- VALUES ('3','Convicted on or after Dec 1, 1999 only');
- INSERT INTO CODED_DNA (DNA_INDICATOR, DNA_DESCRIPTION)
- VALUES ('4','Convicted and sentenced for a Hate Crime enhancement of a DNA eligible offense');
- INSERT INTO CODED_DNA (DNA_INDICATOR, DNA_DESCRIPTION)
- VALUES ('5','Convicted and sentenced for an offense included in Anti-terrorism legislation of 2001');
- INSERT INTO CODED_DNA (DNA_INDICATOR, DNA_DESCRIPTION)
- VALUES ('6','Convicted and sentenced for an offense committed on or after July 6, 2004 OR convicted and sentenced for an offense committed prior to July 6, 2004 where the sentence imposed has not been completed prior to July 6, 2004');
- INSERT INTO CODED_DNA (DNA_INDICATOR, DNA_DESCRIPTION)
- VALUES ('7','Convicted and sentenced for an offense committed on or after July 6, 2004 OR convicted and sentenced for an offense committed prior to July 6, 2004 where service of the sentence imposed has not been completed prior to July 6, 2004 AND there is a previous conviction for a sex offense, sexually violent offense, or any provision of PL 130.52 or PL 130.55 or an attempt of PL 130.52 or PL 130.55');
- INSERT INTO CODED_DNA (DNA_INDICATOR, DNA_DESCRIPTION)
- VALUES ('8','Convicted and sentenced for an offense committed on or after July 6, 2004 OR convicted and sentenced for an offense committed prior to July 6, 2004 where service of the sentence imposed has not been completed prior to July 6, 2004 AND the victim is less than 17 years of age and the offender is not the parent of the victim');
- INSERT INTO CODED_DNA (DNA_INDICATOR, DNA_DESCRIPTION)
- VALUES ('9','DNA-eligible pursuant to the Anti-terrorism Act of 2004');
- INSERT INTO CODED_DNA (DNA_INDICATOR, DNA_DESCRIPTION)
- VALUES ('10','Convicted and sentenced for an offense committed on or after June 23, 2006 OR convicted and sentenced for an offense committed prior to June 23, 2006 where the sentence imposed has not been completed prior to June 23, 2006');
- INSERT INTO CODED_DNA (DNA_INDICATOR, DNA_DESCRIPTION)
- VALUES ('11','Convicted and sentenced for the crime of PL 230.04 or 110/230.04 committed on or after Nov 1, 2007');
- INSERT INTO CODED_NYS_LAW_CLASS (CLASS,CLASS_DESCRIPTION)
- VALUES ('A','Class A');
- INSERT INTO CODED_NYS_LAW_CLASS (CLASS,CLASS_DESCRIPTION)
- VALUES ('B','Class B');
- INSERT INTO CODED_NYS_LAW_CLASS (CLASS,CLASS_DESCRIPTION)
- VALUES ('C','Class C');
- INSERT INTO CODED_NYS_LAW_CLASS (CLASS,CLASS_DESCRIPTION)
- VALUES ('D','Class D');
- INSERT INTO CODED_NYS_LAW_CLASS (CLASS,CLASS_DESCRIPTION)
- VALUES ('E','Class E');
- INSERT INTO CODED_NYS_LAW_CLASS (CLASS,CLASS_DESCRIPTION)
- VALUES ('U','Unspecified');
- INSERT INTO CODED_HATE_CRIME(HATE_CRIME_CODE, HATE_CRIME_DESCRIPTION)
- VALUES('0', 'Not a Hate Crime');
- INSERT INTO CODED_HATE_CRIME(HATE_CRIME_CODE, HATE_CRIME_DESCRIPTION)
- VALUES('1', 'Hate Crime per PL 485.05');
- INSERT INTO CODED_HATE_CRIME(HATE_CRIME_CODE, HATE_CRIME_DESCRIPTION)
- VALUES('2', 'Like a Hate Crime but not included in PL 485.05');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0001, 'Unspecified Violation', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0101, 'Treason', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0102, 'Treason Misprison', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0103, 'Espionage', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0104, 'Sabotage', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0105, 'Sedition', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0106, 'Selective Service', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0199, 'Sovereignty', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0201, 'Military Desertion', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0299, 'Military', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0301, 'Illegal Entry', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0302, 'False Citizenship', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0303,'Smuggling Aliens', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0399, 'Immigration', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0901, 'Homicide - Willful Kill-Family-Gun', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0902, 'Homicide - Willful Kill-Family-Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0903, 'Homicide - Willful Kill-Nonfamily-Gun', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0904, 'Homicide - Willful Kill-Nonfamily-Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0905, 'Homicide - Willful Kill-Pub Off-Gun', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0906, 'Homicide - Willful Kill-Pub Off-Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0907, 'Homicide - Willful Kill-Pol Off-Gun', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0908, 'Homicide - Willful Kill-Pol Off-Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0909, 'Homicide - Negligent Manslaughter-Vehicle', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0910, 'Homicide - Negligent Manslaughter-Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0911, 'Homicide - Willful Kill-Gun', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0912, 'Homicide - Willful Kill-Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0913, 'Homicide - John or Jane Doe - No Warrant', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0989, 'Homicide - Gun', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0990, 'Homicide - Other Firearm', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (0999, 'Homicide', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1001, 'Kidnap Minor For Ransom', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1002, 'Kidnap Adult For Ransom', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1003, 'Kidnap Minor To Sexually Assault', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1004, 'Kidnap Adult To Sexually Assault', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1005, 'Kidnap Minor', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1006, 'Kidnap Adult', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1007, 'Kidnap Hostage for Escape', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1008, 'Abduction - No Ransom or Assault', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1009, 'Kidnap - Hijack Aircraft', 'F');
- INSERT INTO CODED_NCIC(NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1010, 'Kidnap Minor-Parental', 'F');
- INSERT INTO CODED_NCIC(NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1011, 'Kidnap Minor- Nonparental', 'F');
- INSERT INTO CODED_NCIC(NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1020, 'False Imprisonment- Minor-Nonparental', 'F');
- INSERT INTO CODED_NCIC(NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1021, 'False Imprisonment- Minor- Parental', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1089, 'Kidnap - Gun', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1090, 'Kidnap - Poss/Display Firearms', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1099, 'Kidnaping', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1101, 'Rape - Gun', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1102, 'Rape - Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1103, 'Rape - Strongarm', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1104, 'Sex Assault - Sodomy-Boy-Gun', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1105, 'Sex Assault - Sodomy-Man-Gun', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1106, 'Sex Assault - Sodomy-Girl-Gun', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1107, 'Sex Assault - Sodomy-Woman-Gun', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1108, 'Sex Assault - Sodomy-Boy-Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1109, 'Sex Assault - Sodomy-Man-Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1110, 'Sex Assault - Sodomy-Girl-Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1111, 'Sex Assault - Sodomy-Woman-Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1112, 'Sex Assault - Sodomy-Boy-Strongarm', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1113, 'Sex Assault - Sodomy-Man-Strongarm', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1114, 'Sex Assault - Sodomy-Girl-Strongarm', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1115, 'Sex Assault - Sodomy-Woman-Strongarm', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1116, 'Statuary Rape - No Force', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1117, 'Sex Assault - Carnal Abuse', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1118, 'Rape - Elderly', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1119, 'Rape - Disabled', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1120, 'Sex Assault - Elderly', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1121, 'Sex Assault - Disabled', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1122, 'Rape - Drug-induced', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1123, 'Sex Assault - Drug-induced', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1189, 'Sex Assault - Gun', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1190, 'Sex Assault - Other Firearm', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1198, 'Rape', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1199, 'Sex Assault', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1201, 'Robbery - Business-Gun', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1202, 'Robbery - Business-Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1203, 'Robbery - Business-Strongarm', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1204, 'Robbery - Street-Gun', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1205, 'Robbery - Street-Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1206, 'Robbery - Street-Strongarm', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1207, 'Robbery - Residence-Gun', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1208, 'Robbery - Residence-Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1209, 'Robbery - Residence-Strongarm', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1210, 'Forcible Purse Snatching', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1211, 'Robbery - Banking/Type Institution', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1212, 'Carjacking - Armed', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1289, 'Robbery - Gun', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1290, 'Robbery - Other Firearm', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1299, 'Robbery', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1301, 'Aggravated Assault - Family-Gun', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1302, 'Aggravated Assault - Family-Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1303, 'Aggravated Assault - Family-Strongarm', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1304, 'Aggravated Assault - Nonfamily-Gun', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1305, 'Aggravated Assault - Nonfamily-Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1306, 'Aggravated Assault - Nonfamily-Strongarm', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1307, 'Aggravated Assault - Pub Off-Gun', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1308, 'Aggravated Assault - Pub Off-Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1309, 'Aggravated Assault - Pub Off-Strongarm', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1310, 'Aggravated Assault - Pol Off-Gun', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1311, 'Aggravated Assault - Pol Off-Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1312, 'Aggravated Assault - Pol Off-Strongarm', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1313, 'Simple Assault', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1314, 'Aggravated Assault - Gun', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1315, 'Aggravated Assault - Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1316, 'Intimidation (includes stalking)', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1389, 'Assault - Gun', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1390, 'Assault - Other Firearm', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1391, 'Assault - Sawed-Off Shotgun', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1399, 'Assault', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1401, 'Abortional Act on Other', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1402, 'Abortional Act on Self', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1403, 'Submission to Abortional Act', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1404, 'Abortifacient (selling, manufacturing, delivering, etc.)', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1499, 'Abortion', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1601, 'Threat - Federal Protectees (President, Vice President, etc.)', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1602, 'Threat - Terrorist, State Offenses', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1701, 'State/Local Material Witness', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (1702, 'Federal Material Witness', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2001, 'Arson - Business-Endangered Life', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2002, 'Arson - Residence-Endangered Life', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2003, 'Arson - Business-Defraud Insurer', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2004, 'Arson - Residence-Defraud Insurer', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2005, 'Arson - Business', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2006, 'Arson - Residence', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2007, 'Burning Of Object', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2008, 'Arson - Public Building-Endangered Life', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2009, 'Arson - Public Building', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2090, 'Arson - Poss/Display Firearms', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2099, 'Arson', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2101, 'Extortion - Threat Injure Person', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2102, 'Extortion - Threat Damage Property', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2103, 'Extortion - Threat Injure Reputation', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2104, 'Extortion - Threat Accuse Person of Crime', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2105, 'Extortion - Threat of Informing of Vio', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2199, 'Extortion', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2201, 'Burglary - Safe-Vault', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2202, 'Burglary - Forced Entry-Residence', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2203, 'Burglary - Forced Entry-Nonresidence', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2204, 'Burglary - No Forced Entry-Residence', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2205, 'Burglary - No Forced Entry-Nonresidence', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2206, 'Burglary Tools - Possess', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2207, 'Burglary - Banking/Type Institution', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2289, 'Burglary - Gun', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2290, 'Burglary - Poss/Display Firearms', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2299, 'Burglary', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2301, 'Pocketpicking', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2302, 'Purse Snatching - No Force', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2303, 'Shoplifting', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2304, 'Larceny - Parts From Vehicle', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2305, 'Larceny - From Auto', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2306, 'Larceny - From Shipment', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2307, 'Larceny - From Coin Machine', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2308, 'Larceny - From Building', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2309, 'Larceny - From Yards', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2310, 'Larceny - From Mails', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2311, 'Larceny - From Banking/Type Institution', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2312, 'Larceny - From Interstate Shipment', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2313, 'Obstruct Correspondence (postal violation)', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2314, 'Theft of US Government Property', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2315, 'Larceny on US Government Reservation', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2316, 'Larceny - Postal', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2399, 'Larceny', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2401, 'Theft and Sale Vehicle', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2402, 'Theft and Strip Vehicle', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2403, 'Theft and Use Vehicle Other Crime', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2404, 'Vehicle Theft', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2405, 'Theft Vehicle by Bailee', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2406, 'Receive Stolen Vehicle', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2407, 'Strip Stolen Vehicle', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2408, 'Possess Stolen Vehicle', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2409, 'Interstate Transportation of Stolen Vehicle', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2410, 'Aircraft Theft', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2411, 'Unauthorized Use of Vehicle (includes joy riding)', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2499, 'Stolen Vehicle', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2501, 'Forgery of Checks', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2502, 'Forgery of Object', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2503, 'Counterfeiting of Object', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2504, 'Pass Forged Object', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2505, 'Pass Counterfeited Object', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2506, 'Possess Forged Object', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2507, 'Possess Counterfeited Object', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2508, 'Possess Tools for Forgery/Counterfeiting', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2509, 'Transport Forged Object', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2510, 'Transport Counterfeited Object', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2511, 'Transport Tools for Forgery/Counterfeiting', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2589, 'Forgery', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2599, 'Counterfeiting', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2601, 'Fraud - Confidence Game', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2602, 'Fraud - Swindle', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2603, 'Mail Fraud', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2604, 'Fraud - Impersonation', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2605, 'Fraud - Illegal use of Credit Cards', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2606, 'Fraud - Insufficient Funds Check', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2607, 'Fraud - False Statement', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2608, 'Fraud By Wire', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2609, 'Fraud and Abuse - Computer', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2699, 'Fraud', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2701, 'Embezzle - Business Property', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2702, 'Embezzle - Interstate Shipment', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2703, 'Embezzle - Banking/Type Institution', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2704, 'Embezzle - Public Property (federal, state, city property)', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2705, 'Embezzle - Postal', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2799, 'Embezzle', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2801, 'Sale Of Stolen Property', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2802, 'Transport Interstate Stolen Property', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2803, 'Receive Stolen Property', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2804, 'Possess Stolen Property', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2805, 'Conceal Stolen Property', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2899, 'Stolen Property', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2901, 'Damage Property - Business', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2902, 'Damage Property - Private', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2903, 'Damage Property - Public', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2904, 'Damage Property - Business with Explosive', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2905, 'Damage Property - Private with Explosive', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2906, 'Damage Property - Public with Explosive', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (2999, 'Damage Property', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3501, 'Hallucinogen - Manufacture', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3502, 'Hallucinogen - Distribution', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3503, 'Hallucinogen - Sell', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3504, 'Hallucinogen - Possess', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3505, 'Hallucinogen - (not marijuana)', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3506, 'LSD - Sale', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3507, 'LSD - Possession', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3510, 'Heroin - Sell', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3511, 'Heroin - Smuggle', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3512, 'Heroin - Possess', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3513, 'Heroin', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3516, 'Phencyclidine/Angel Dust - Sale', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3517, 'Phencyclidine/Angel Dust - Possession', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3520, 'Opium or Derivative - Sell', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3521, 'Opium or Derivative - Smuggle', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3522, 'Opium or Derivative - Possess', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3523, 'Opium or Derivative', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3526, 'Morphine - Sale', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3527, 'Morphine - Possession', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3530, 'Cocaine - Sell', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3531, 'Cocaine - Smuggle', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3532, 'Cocaine - Possess', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3533, 'Cocaine', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3536, 'Crack - Sale', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3537, 'Crack - Possession', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3540, 'Synthetic Narcotic - Sell', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3541, 'Synthetic Narcotic - Smuggle', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3542, 'Synthetic Narcotic - Possess', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3543, 'Synthetic Narcotic', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3546, 'Methadone - Sale', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3547, 'Methadone - Possession', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3550, 'Narcotic Equipment - Possess', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3560, 'Marijuana - Sell', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3561, 'Marijuana - Smuggle', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3562, 'Marijuana - Possess', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3563, 'Marijuana - Producing', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3564, 'Marijuana', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3566, 'Concentrated Cannabis - Sale', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3568, 'Concentrated Cannabis - Possession', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3570, 'Amphetamine - Manufacture', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3571, 'Amphetamine - Sell', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3572, 'Amphetamine - Possess', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3573, 'Amphetamine', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3576, 'Other Stimulants - Sale', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3577, 'Other Stimulants - Possession', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3580, 'Barbiturate - Manufacture', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3581, 'Barbiturate - Sell', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3582, 'Barbiturate - Possess', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3583, 'Barbiturate', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3586, 'Depressants/Tranquilizers - Sale', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3587, 'Depressants/Tranquilizers - Possession', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3596, 'Anabolic Steroids - Sale', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3597, 'Anabolic Steroids - Possession', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3599, 'Dangerous Drugs', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3601, 'Sex Offense - Against Child-Fondling', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3602, 'Homosexual Act with a Girl', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3603, 'Homosexual Act with a Boy', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3604, 'Incest with Minor', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3605, 'Indecent Exposure', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3606, 'Bestiality', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3607, 'Incest with Adult', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3608, 'Seduction of Adult', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3609, 'Homosexual Act with Woman', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3610, 'Homosexual Act with Man', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3611, 'Peeping Tom', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3612, 'Failure to Register as a Sex Offender', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3613, 'Sex Offender Registration Violation', 'F');
- INSERT INTO CODED_NCIC(NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3614, 'Indecent Exposure to Minor', 'F');
- INSERT INTO CODED_NCIC(NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3615, 'Indecent Exposure to Adult', 'F');
- INSERT INTO CODED_NCIC(NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3616, 'Lewd or Lascivious Acts with Minor', 'F');
- INSERT INTO CODED_NCIC(NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3617, 'Sexually Violate Human Remains/Necrophilia', 'F');
- INSERT INTO CODED_NCIC(NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3618, 'Molestation of Minor', 'F');
- INSERT INTO CODED_NCIC(NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3619, 'Voyeurism', 'F');
- INSERT INTO CODED_NCIC(NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3620, 'Sex Offense - Elderly', 'F');
- INSERT INTO CODED_NCIC(NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3621, 'Sex Offense - Disabled', 'F');
- INSERT INTO CODED_NCIC(NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3622, 'Transport Interstate for Sexual Activity', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3699, 'Sex Offense', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3700, 'Obscene Material', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3701, 'Obscene Material - Manufacture', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3702, 'Obscene Material - Sell', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3703, 'Obscene Material - Mailing', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3704, 'Obscene Material - Possess', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3705, 'Obscene Material - Distribution', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3706, 'Obscene Material - Transportation', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3707, 'Obscene Communication', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3799, 'Obscenity', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3801, 'Neglect Family', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3802, 'Cruelty Toward Child', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3803, 'Cruelty Toward Wife', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3804, 'Bigamy', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3805, 'Contributing to the Delinquency of a Minor', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3806, 'Neglect Child (includes nonsupport of child)', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3807, 'Nonpayment of Alimony', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3808, 'Nonsupport of Parent', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3809, 'Cruelty Toward Elderly', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3810, 'Cruelty Toward Disabled', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3811, 'Neglect Elderly', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3812, 'Neglect Disabled', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3899, 'Family Offense', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3901, 'Bookmaking', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3902, 'Card Game - Operating', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3904, 'Card Game', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3905, 'Dice Game - Operating', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3907, 'Dice Game', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3908, 'Gambling Device - Possess', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3909, 'Gambling Device - Transportation', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3910, 'Gambling Device - Not Registered', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3911, 'Gambling Device', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3912, 'Gambling Goods - Possess', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3913, 'Gambling Goods - Transportation', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3914, 'Gambling Goods', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3915, 'Lottery - Operating', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3916, 'Lottery - Runner', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3918, 'Lottery', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3919, 'Sports Tampering', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3920, 'Transmit Wager Information', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3921, 'Establish Gambling Place', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (3999, 'Gambling', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4001, 'Keeping House Ill Fame', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4002, 'Procure for Prostitute (pimping)', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4003, 'Commercial Sex - Homosexual Prostitution', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4004, 'Prostitution', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4005, 'Frequent House Ill Fame', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4006, 'Transporting Female Interstate for Immoral Purposes', 'F');
- INSERT INTO CODED_NCIC(NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4007, 'Procure for Prostitute Who Is A Minor', 'F');
- INSERT INTO CODED_NCIC(NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4008, 'Procure for Prostitute Who Is An Adult', 'F');
- INSERT INTO CODED_NCIC(NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4009, 'Transport Interstate for Commercialized Sex', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4099, 'Commercial Sex', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4101, 'Liquor - Manufacture', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4102, 'Liquor - Sell', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4103, 'Liquor - Transportation', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4104, 'Liquor - Possess', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4105, 'Misrepresenting Age - Minor', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4199, 'Liquor', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4299, 'Drunkenness', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4801, 'Resisting Officer', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4802, 'Obstruct Criminal Investigation', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4803, 'Making False Report', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4804, 'Evidence - Destroying', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4805, 'Witness - Dissuading', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4806, 'Witness - Deceiving', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4807, 'Refusing to Aid Officer', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4808, 'Compounding Crime', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4809, 'Unauthorized Communication with Prisoner', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4810, 'Illegal Arrest', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4811, 'Crossing Police Lines', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4812, 'Failure to Report Crime', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4813, 'Failing to Move On', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4899, 'Obstructing Police', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4901, 'Escape', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4902, 'Flight to Avoid (Prosecution, Confinement, etc.)', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4903, 'Aiding Prisoner Escape', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4904, 'Harboring Escape/Fugitive', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (4999, 'Flight/Escape', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5001, 'Bail - Secured Bond', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5002, 'Bail - Personal Recog', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5003, 'Perjury', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5004, 'Perjury - Subornation Of', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5005, 'Contempt of Court', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5006, 'Obstructing Justice', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5007, 'Obstructing Court Order', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5008, 'Misconduct - Judiciary Officer', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5009, 'Contempt of Congress', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5010, 'Contempt of Legislature', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5011, 'Parole Violation', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5012, 'Probation Violation', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5013, 'Conditional Release Violation', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5014, 'Mandatory Release Violation', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5015, 'Failure to Appear', 'F');
- INSERT INTO CODED_NCIC(NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5016, 'Violation of a Court Order', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5099, 'Obstruction', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5101, 'Bribe - Giving', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5102, 'Bribe - Offering', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5103, 'Bribe - Receiving', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5104, 'Bribe', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5105, 'Conflict of Interest', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5106, 'Gratuity - Giving', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5107, 'Gratuity - Offering', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5108, 'Gratuity - Receiving', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5109, 'Gratuity', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5110, 'Kickback - Giving', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5111, 'Kickback - Offering', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5112, 'Kickback - Receiving', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5113, 'Kickback', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5199, 'Bribery', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5201, 'Altering Identification on Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5202, 'Carrying Concealed Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5203, 'Carrying Prohibited Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5204, 'Explosives - Teaching Use', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5205, 'Explosives - Transporting', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5206, 'Explosives - Using', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5207, 'Incendiary Device - Possess', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5208, 'Incendiary Device - Using', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5209, 'Incendiary Device - Teaching Use', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5210, 'Licensing - Registration Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5211, 'Explosives - Possessing', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5212, 'Possession of Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5213, 'Firing Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5214, 'Selling Weapon', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5215, 'Threat to Bomb', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5216, 'Threat to Burn', 'F');
- INSERT INTO CODED_NCIC(NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5217, 'Weapon Trafficking', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5289, 'CPW - Gun', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5290, 'Poss/Display Firearms', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5291, 'Weapon Offense - S/Off Shotgun', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5292, 'Weapon Offense - Rifle', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5293, 'Weapon Offense - Machine Gun', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5294, 'Weapon Offense - Shotgun', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5295, 'Weapon Offense - Long Gun', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5296, 'Weapon Offense - Starting Pistol', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5297, 'Weapon Offense - Sealed Indict', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5299, 'Weapon Offense', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5301, 'Anarchism', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5302, 'Riot - Inciting', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5303, 'Riot - Engaging in', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5304, 'Riot - Interfere Firearm', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5305, 'Riot - Interfere Officer', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5306, 'Riot', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5307, 'Assembly - Unlwful', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5308, 'False Fire Alarm', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5309, 'Harassing Communication', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5310, 'Desecrating Flag', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5311, 'Disorderly Conduct', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5312, 'Disturbing The Peace', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5313, 'Curfew', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5314, 'Loitering', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5399, 'Public Peace', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5401, 'Hit and Run', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5402, 'Transporting Dangerous Material', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5403, 'Driving Under Influence of Drugs', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5404, 'Driving Under Influence of Liquor', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5405, 'Moving Traffic Violation', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5406, 'NonMoving Traffic Violation', 'T');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5499, 'Traffic Offense', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5501, 'Drugs - Adulterated', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5502, 'Drugs - Misbranded', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5503, 'Drugs - Health or Safety', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5510, 'Food - Adulterated', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5511, 'Food - Misbranded', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5512, 'Food - Health or Safety', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5520, 'Cosmetics - Adulterated', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5521, 'Cosmetics - Misbranded', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5522, 'Cosmetics - Health or Safety', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5599, 'Health Safety', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5699, 'Civil Rights', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5701, 'Divulge Eavesdropping Information', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5702, 'Divulge Eavesdropping Order', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5703, 'Divulge Message Contents', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5704, 'Eavesdropping', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5705, 'Eavesdropping Equipment', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5706, 'Opening Sealed Communication', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5707, 'Trespassing', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5708, 'Wiretap - Failure to Report', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5799, 'Invade Privacy', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5801, 'Smuggle Contraband', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5802, 'Smuggle Contraband into Prison', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5803, 'Smuggle to Avoid Paying Duty', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5899, 'Smuggling', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (5999, 'Election Laws', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (6099, 'Antitrust', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (6101, 'Income Tax', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (6102, 'Sales Tax', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (6103, 'Liquor Tax', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (6110, 'Money Laundering (if tax based)', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (6199, 'Tax Revenue', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (6201, 'Conservation Animals', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (6202, 'Conservation - Fish', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (6203, 'Conservation - Birds', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (6204, 'Conservation - License-Stamp', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (6205, 'Conservation - Environment', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (6299, 'Conservation', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (6300, 'Money Laundering', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (6401, 'Sexual Exploitation of Minor - Material - Transport', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (6402, 'Sexual Exploitation of Minor - Material - Photograph', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (6403, 'Sexual Exploitation of Minor - Material - Film', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (6404, 'Sexual Exploitation of Minor - Exhibition of Minor', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (6405, 'Sexual Exploitation of Minor - Sex Performance', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (6406, 'Sexual Exploitation of Minor - Via Telecommunications', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (6407, 'Sexual Exploitation of Minor - Prostitution', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (6408, 'Enticement of Minor-Indecent Purposes- via Telecommunications', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (6409, 'Enticement of Minor for Prostitution', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (6410, 'Enticement of Minor for Indecent Purposes', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (6499, 'Exploitation/Enticement', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (7099, 'Crimes Against Person', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (7199, 'Property Crimes', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (7299, 'Morals Decency Crimes', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (7399, 'Public Order Crimes', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (8100, 'Escape From Custody', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (8101, 'Abscond While on Parole', 'F');
- INSERT INTO CODED_NCIC (NCIC_CODE,
- NCIC_DESCRIPTION, DCJS_ASSIGNED)
- VALUES (8102, 'Abscond While on Probation', 'F');
- INSERT INTO CODED_NYS_LAW_CATEGORY (NYS_LAW_CATEGORY,
- NYS_LAW_CATEGORY_DESCRIPTION)
- VALUES ('F', 'Felony'
- );
- INSERT INTO CODED_NYS_LAW_CATEGORY (NYS_LAW_CATEGORY,
- NYS_LAW_CATEGORY_DESCRIPTION)
- VALUES ('M', 'Misdemeanor'
- );
- INSERT INTO CODED_NYS_LAW_CATEGORY (NYS_LAW_CATEGORY,
- NYS_LAW_CATEGORY_DESCRIPTION)
- VALUES ('V', 'Violation'
- );
- INSERT INTO CODED_NYS_LAW_CATEGORY (NYS_LAW_CATEGORY,
- NYS_LAW_CATEGORY_DESCRIPTION)
- VALUES ('I', 'Infraction'
- );
- INSERT INTO CODED_NYS_LAW_CATEGORY (NYS_LAW_CATEGORY,
- NYS_LAW_CATEGORY_DESCRIPTION)
- VALUES ('O', 'Offense'
- );
- INSERT INTO CODED_NYS_LAW_CATEGORY (NYS_LAW_CATEGORY,
- NYS_LAW_CATEGORY_DESCRIPTION)
- VALUES ('9', 'Unspecified'
- );
- INSERT INTO CODED_NYS_LAW_CATEGORY (NYS_LAW_CATEGORY,
- NYS_LAW_CATEGORY_DESCRIPTION)
- VALUES ('U', 'Unknown'
- );
- INSERT INTO CODED_NYS_LAW_CATEGORY (NYS_LAW_CATEGORY,
- NYS_LAW_CATEGORY_DESCRIPTION)
- VALUES ('0', 'Dummy Code'
- );
- INSERT INTO CODED_NYS_LAW_JD (JD_INDICATOR,
- JD_DESCRIPTION)
- VALUES (0, 'Not a fingerprintable JD Offense'
- );
- INSERT INTO CODED_NYS_LAW_JD (JD_INDICATOR,
- JD_DESCRIPTION)
- VALUES (1, 'JD if age is 11-15 (Class A Felony)'
- );
- INSERT INTO CODED_NYS_LAW_JD (JD_INDICATOR,
- JD_DESCRIPTION)
- VALUES (2, 'JD if age is 11-12, not an attempt; or if age is 13-15 (Class B Felony)'
- );
- INSERT INTO CODED_NYS_LAW_JD (JD_INDICATOR,
- JD_DESCRIPTION)
- VALUES (3, 'JD if age is 13-15, crime date before 11/1/96, not attempt - JD if age 13-15, crime date after 10/31/96 (Class C Felony)'
- );
- INSERT INTO CODED_NYS_LAW_JD (JD_INDICATOR,
- JD_DESCRIPTION)
- VALUES (4, 'JD if age 13-15, crime date after 10/31/96 (Class D Felony)'
- );
- INSERT INTO CODED_NYS_LAW_JD (JD_INDICATOR,
- JD_DESCRIPTION)
- VALUES (5, 'JD if age 13-15, crime date after 10/31/96, not an attempt (Class E Felony)'
- );
- INSERT INTO CODED_NYS_LAW_JO (JO_INDICATOR,
- JO_DESCRIPTION)
- VALUES (0, 'Law not covered by JO Legislation'
- );
- INSERT INTO CODED_NYS_LAW_JO (JO_INDICATOR,
- JO_DESCRIPTION)
- VALUES (1, 'JO if individual 13-15 yrs old, if not attempt; or 14-15 if attempt'
- );
- INSERT INTO CODED_NYS_LAW_JO (JO_INDICATOR,
- JO_DESCRIPTION)
- VALUES (2, 'JO if individual 14-15 yrs old, if not an attempt'
- );
- INSERT INTO CODED_NYS_LAW_JO (JO_INDICATOR,
- JO_DESCRIPTION)
- VALUES (3, 'JO if individual 14-15 yrs old, if attempt or not an attempt'
- );
- INSERT INTO CODED_NYS_LAW_JO (JO_INDICATOR,
- JO_DESCRIPTION)
- VALUES (4, 'JO if individual 14-15 yrs old, and if there is an accompanying charge which
- has a value of 2 or 3 in the JO indicator'
- );
- INSERT INTO CODED_NYS_LAW_VF ( VF_INDICATOR, VF_DESCRIPTION)
- VALUES ('N', 'Not a VFO'
- );
- INSERT INTO CODED_NYS_LAW_VF ( VF_INDICATOR, VF_DESCRIPTION)
- VALUES ('V', 'VFO'
- );
- INSERT INTO CODED_NYS_LAW_VF ( VF_INDICATOR, VF_DESCRIPTION)
- VALUES ('L', 'VFO-like class A-1 offenses not in VFO Legislation'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('100', 'Crim Solicit'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('105', 'Conspiracy'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('110', 'Attempt'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('115', 'Crim Facilitate'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('120', 'Assault'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY
- (OFFENSE_CATEGORY, OFFENSE_DESCRIPTION)
- VALUES
- ('121', 'Strangulation and Related Offenses');
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('125', 'Homicide'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('130', 'Sexual Miscond'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('135', 'Kidnapping'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('140', 'Burglary'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('145', 'Crim Mischief'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('150', 'Arson'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('155', 'Larceny'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('156', 'Computer Crime'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('158', 'Welfare Fraud'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('160', 'Robbery'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('165', 'Stolen Property'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('170', 'Forgery'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('175', 'Falsify Doc'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('176', 'Insurance Fraud'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('177', 'Health Care Fraud'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('178', 'Prescriptions'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('180', 'Comm Bribery'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('185', 'Fraud'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('187', 'Residential Mortgage Fraud'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('190', 'Bad Check'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('195', 'Misconduct'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('200', 'Public Bribery'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('205', 'Escape'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('210', 'Purjury'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('215', 'Juror Tampering'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('220', 'Control Subs'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('221', 'Marijuana'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('225', 'Gambling'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('230', 'Prostitution'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('235', 'Obsenity'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('240', 'Harassment'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('241', 'Harass Tenant'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('242', 'Offenses Against Service Animals'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('245', 'Public Lewdness'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('250', 'Communication'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('255', 'Bigamy'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('260', 'Care Of Child'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('263', 'Sexual Performance by a Child'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('265', 'Weapons'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('270', 'Offenses Relating to Public Safety'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('275', 'Unauth Record'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('400', 'Firearm Lic'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('405', 'Fireworks and Related Provisions'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('460', 'Enterprise Corruption'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('470', 'Money Launder'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('490', 'Terrorism');
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('ABC', 'Alcohol'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('ACA', 'Arts'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('AM', 'Ag and Market'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('BL', 'Banking'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('BUS', 'Business'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('CCL', 'Coop Corps'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('CCP', 'Code of Criminal Procedure'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('CON', 'Conservation Law'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('COR', 'Correction'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('CPL', 'Crim Procedure'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('CR', 'Civil Rights'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('CS', 'Civil Service'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('DOM', 'Domestic Rel'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('ECL', 'Envirnomental'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('ED', 'Education'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('EL', 'Election'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('ENG', 'Energy'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('EPT', 'Estates'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('EX', 'Executive'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('FCA', 'Family Court'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('GB', 'General Business'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('GCI', 'General City'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('GCO', 'General Corp'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('GML', 'General Muni'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('GOB', 'General Oblig'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('HYL', 'Highway'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('IN', 'Insurance'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('IND', 'Indian'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('JUD', 'Judiciary'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('LAB', 'Labor'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('LL', 'Lien Law'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('LEG', 'Legislative Law'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('LOC', 'Local'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('MD', 'Multi Dwelling'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('MHY', 'Mental Hygiene'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('MIL', 'Military'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('MLR', 'Multi Reside'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('NAV', 'Navigation'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('NPC', 'Not For Profit'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('OUT', 'Out of State Charge'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('PHL', 'Public Health'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('POL', 'Public Officers'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('PPL', 'Personal Prop'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('PRL', 'Parks and Rec'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('PSL', 'Public Service'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('RP', 'Real Property'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('RPW', 'Racing Wagering'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('RR', 'Railroad'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('RSS', 'Retirement'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('SCC', 'Sec Cls Cities'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('SW', 'Social Serv'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('TAX', 'Tax'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('TC', 'Trans Corp'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('TL', 'Transportation'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('TR', 'Transportation'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('TWN', 'Town'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('UN', 'Unconsolidated'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('VTL', 'Vehicle ' || '&' || ' Traffic Law'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('WC', 'Work Comp'
- );
- INSERT INTO CODED_OFFENSE_CATEGORY (OFFENSE_CATEGORY,
- OFFENSE_DESCRIPTION)
- VALUES ('REG', 'Thruway and Parkway Rules and Regs'
- );
- INSERT INTO CODED_SAFIS (SAFIS_CRIME_CATEGORY_CODE,
- SAFIS_DESCRIPTION)
- VALUES (00, 'Not a Latent Cognizant File Qualifying Charge'
- );
- INSERT INTO CODED_SAFIS (SAFIS_CRIME_CATEGORY_CODE,
- SAFIS_DESCRIPTION)
- VALUES (01, 'Burglary'
- );
- INSERT INTO CODED_SAFIS (SAFIS_CRIME_CATEGORY_CODE,
- SAFIS_DESCRIPTION)
- VALUES (05, 'Sex Crimes'
- );
- INSERT INTO CODED_SAFIS (SAFIS_CRIME_CATEGORY_CODE,
- SAFIS_DESCRIPTION)
- VALUES (06, 'Public Lewdness'
- );
- INSERT INTO CODED_SAFIS (SAFIS_CRIME_CATEGORY_CODE,
- SAFIS_DESCRIPTION)
- VALUES (07, 'Robbery'
- );
- INSERT INTO CODED_SAFIS (SAFIS_CRIME_CATEGORY_CODE,
- SAFIS_DESCRIPTION)
- VALUES (08, 'Forgery'
- );
- INSERT INTO CODED_SAFIS (SAFIS_CRIME_CATEGORY_CODE,
- SAFIS_DESCRIPTION)
- VALUES (09, 'Criminal Possession of Drugs'
- );
- INSERT INTO CODED_SAFIS (SAFIS_CRIME_CATEGORY_CODE,
- SAFIS_DESCRIPTION)
- VALUES (10, 'Criminal Sale of Drugs'
- );
- INSERT INTO CODED_SAFIS (SAFIS_CRIME_CATEGORY_CODE,
- SAFIS_DESCRIPTION)
- VALUES (11, 'Possession of Drug Paraphernalia'
- );
- INSERT INTO CODED_SAFIS (SAFIS_CRIME_CATEGORY_CODE,
- SAFIS_DESCRIPTION)
- VALUES (12, 'Prostitution'
- );
- INSERT INTO CODED_SAFIS (SAFIS_CRIME_CATEGORY_CODE,
- SAFIS_DESCRIPTION)
- VALUES (14, 'Aggravated Assault'
- );
- INSERT INTO CODED_SAFIS (SAFIS_CRIME_CATEGORY_CODE,
- SAFIS_DESCRIPTION)
- VALUES (16, 'Criminal Trespass'
- );
- INSERT INTO CODED_SAFIS (SAFIS_CRIME_CATEGORY_CODE,
- SAFIS_DESCRIPTION)
- VALUES (17, 'Weapons'
- );
- INSERT INTO CODED_SAFIS (SAFIS_CRIME_CATEGORY_CODE,
- SAFIS_DESCRIPTION)
- VALUES (18, 'Criminal Possession of Stolen Property'
- );
- INSERT INTO CODED_SAFIS (SAFIS_CRIME_CATEGORY_CODE,
- SAFIS_DESCRIPTION)
- VALUES (19, 'Grand Larceny (Auto Only)'
- );
- INSERT INTO CODED_SAFIS (SAFIS_CRIME_CATEGORY_CODE,
- SAFIS_DESCRIPTION)
- VALUES (20, 'Grand Larceny (excluding Auto)'
- );
- INSERT INTO CODED_SAFIS (SAFIS_CRIME_CATEGORY_CODE,
- SAFIS_DESCRIPTION)
- VALUES (21, 'Homicide'
- );
- INSERT INTO CODED_SAFIS (SAFIS_CRIME_CATEGORY_CODE,
- SAFIS_DESCRIPTION)
- VALUES (22, 'Arson'
- );
- INSERT INTO CODED_SAFIS (SAFIS_CRIME_CATEGORY_CODE,
- SAFIS_DESCRIPTION)
- VALUES (23, 'Patronizing a Prostitute'
- );
- INSERT INTO CODED_SEX_OFFENDER_REGISTRY (SEX_OFFENDER_REGISTRY_CODE,
- SEX_OFFENDER_REGISTRY_LITERAL)
- VALUES (1, 'Sex Offender Registry Charge'
- );
- INSERT INTO CODED_SEX_OFFENDER_REGISTRY (SEX_OFFENDER_REGISTRY_CODE,
- SEX_OFFENDER_REGISTRY_LITERAL)
- VALUES (2, 'Sex Offender Registry Charge if the victim is 16 years of age or
- younger'
- );
- INSERT INTO CODED_SEX_OFFENDER_REGISTRY (SEX_OFFENDER_REGISTRY_CODE,
- SEX_OFFENDER_REGISTRY_LITERAL)
- VALUES (9, 'Not a Sex Offender Registry Charge'
- );
- INSERT INTO CODED_TCA (TCA_CODE, TCA_DESCRIPTION)
- VALUES ('B', 'Buying/Receiving'
- );
- INSERT INTO CODED_TCA (TCA_CODE, TCA_DESCRIPTION)
- VALUES ('C', 'Cultivating/Manufacturing/Publishing'
- );
- INSERT INTO CODED_TCA (TCA_CODE, TCA_DESCRIPTION)
- VALUES ('D', 'Distributing/Selling'
- );
- INSERT INTO CODED_TCA (TCA_CODE, TCA_DESCRIPTION)
- VALUES ('E', 'Exploiting Children'
- );
- INSERT INTO CODED_TCA (TCA_CODE, TCA_DESCRIPTION)
- VALUES ('O', 'Operating/Promoting'
- );
- INSERT INTO CODED_TCA (TCA_CODE, TCA_DESCRIPTION)
- VALUES ('P', 'Possessing/Concealing'
- );
- INSERT INTO CODED_TCA (TCA_CODE, TCA_DESCRIPTION)
- VALUES ('T', 'Transporting/Transmitting/Importing'
- );
- INSERT INTO CODED_TCA (TCA_CODE, TCA_DESCRIPTION)
- VALUES ('U', 'Using/Consuming'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (1, 'Murder'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (2, 'Non-Negligent Manslaughter'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (3, 'Negligent Manslaughter'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (4, 'Rape, Forcible'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (5, 'Robbery'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (6, 'Aggravated Assault'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (7, 'Burglary'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (8, 'Larceny'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (9, 'MV Theft'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (10, 'Arson'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (11, 'Kidnaping'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (12, 'Controlled Substance Sale: Opium, Cocaine, or Derivatives'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (13, 'Controlled Substance Sale: Marijuana'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (14, 'Controlled Substance Sale: Synthetic Narcotics'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (15, 'Controlled Substance Sale: Other'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (16, 'Controlled Substance Possession: Opium, Cocaine, or Derivatives'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (17, 'Controlled Substance Possession: Marijuana'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (18, 'Controlled Substance Possession: Synthetic Narcotics'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (19, 'Controlled Substance Possession: Other'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (20, 'Dangerous Weapons'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (21, 'Bribery'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (22, 'Sex Offense (Except Forcible Rape or Prostitution)'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (23, 'Extortion'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (24, 'Forgery' || '&' || 'Counterfeiting'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (25, 'Promoting Prostitution'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (26, 'Prostitution'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (27, 'Patronizing Prostitutes'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (28, 'Stolen Property'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (29, 'Coercion'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (30, 'Criminal Mischief'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (31, 'Fraud'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (32, 'Gambling - Bookmaking'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (33, 'Gambling - Numbers and Lottery'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (34, 'Gambling - Other'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (35, 'Offenses Against Public Order'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (36, 'Embezzlement'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (37, 'Simple Assault'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (38, 'Offenses'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (39, 'Driving Under The Influence - Alcohol'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (40, 'Driving Under The Influence - Drugs'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (41, 'Unauthorized Use Of Vehicle'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (42, 'Possession Of Burglar''s Tools'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (43, 'Other Fingerprintable Offenses'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (44, 'Liquor Law Violations'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (45, 'Disorderly Conduct'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (46, 'Public Narcotic Intoxication'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (47, 'Loitering (Vagrancy)'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (48, 'All Other Offenses (Except Traffic)'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (49, 'Runaway'
- );
- INSERT INTO CODED_UCR (UCR_CODE, UCR_DESCRIPTION)
- VALUES (99, 'Unknown'
- );
- DROP TABLE CODED_WEAPON_CHARGE CASCADE CONSTRAINTS;
- CREATE TABLE CODED_WEAPON_CHARGE
- (WEAPON_CHARGE_CODE NUMBER(1) NULL,
- WEAPON_CHARGE_DESCRIPTION VARCHAR2(350) NULL);
- ALTER TABLE CODED_WEAPON_CHARGE
- ADD (CONSTRAINT CODED_WEAPON_CHARGE_PK PRIMARY KEY (WEAPON_CHARGE_CODE));
- ALTER TABLE CODED_WEAPON_CHARGE
- MODIFY WEAPON_CHARGE_DESCRIPTION
- CONSTRAINT CODEDWEAPONCHARGE_CHARGEDSC_NN NOT NULL;
- INSERT INTO CODED_WEAPON_CHARGE (WEAPON_CHARGE_CODE, WEAPON_CHARGE_DESCRIPTION)
- VALUES(1, 'Offense does not involve the use/display, possession or sale of a firearm or deadly weapon; is not a firearm licensing offense.');
- INSERT INTO CODED_WEAPON_CHARGE (WEAPON_CHARGE_CODE, WEAPON_CHARGE_DESCRIPTION)
- VALUES(2, 'Commission of an offense which exclusively involves the use/display, possession or sale of a firearm as defined in PL 265.00 subdivisions 1, 3, 11, 12, 15, 20 and 22.');
- INSERT INTO CODED_WEAPON_CHARGE (WEAPON_CHARGE_CODE, WEAPON_CHARGE_DESCRIPTION)
- VALUES(3, 'Commission of an offense which involves the use/display of a deadly weapon as defined in PL 10.00(12), which may or may not involve a firearm.');
- INSERT INTO CODED_WEAPON_CHARGE (WEAPON_CHARGE_CODE, WEAPON_CHARGE_DESCRIPTION)
- VALUES(4, 'Commission of an offense which involves the use/display of a dangerous instrument as defined in PL 10.00(13) (excluding vehicles), and any other dangerous weapon, including but not limited to those defined in PL 265.00 subdivisions 2, 18 and 23.');
- INSERT INTO CODED_WEAPON_CHARGE (WEAPON_CHARGE_CODE, WEAPON_CHARGE_DESCRIPTION)
- VALUES(5, 'Commission of a firearm licensing offense as defined in PL Article 400.');
- DROP TABLE CODED_MINORS_CHARGE CASCADE CONSTRAINTS;
- CREATE TABLE CODED_MINORS_CHARGE
- (MINORS_CHARGE_CODE NUMBER(1) NULL,
- MINORS_CHARGE_DESC VARCHAR2(200) NULL);
- ALTER TABLE CODED_MINORS_CHARGE
- ADD (CONSTRAINT CODED_MINORS_CHARGE_PK PRIMARY KEY (MINORS_CHARGE_CODE));
- ALTER TABLE CODED_MINORS_CHARGE
- MODIFY MINORS_CHARGE_DESC
- CONSTRAINT CODEDMINORSCHARGE_CHGDESC_NN NOT NULL;
- INSERT INTO CODED_MINORS_CHARGE VALUES (
- 1,'Does not involve minor victim');
- INSERT INTO CODED_MINORS_CHARGE VALUES (
- 2,'PL 130 sex offense involving minor victims');
- INSERT INTO CODED_MINORS_CHARGE VALUES (
- 3,'Other sexual offense involving minor victims');
- INSERT INTO CODED_MINORS_CHARGE VALUES (
- 4,'Crime on School Grounds or Day Care Facility');
- INSERT INTO CODED_MINORS_CHARGE VALUES (
- 5,'All other crimes involving minor victims');
- commit;
- spool off;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement