criminaljustice.ny.gov lawfile dump

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;