CHPTR_26_LEDSAGCY

CHPTR_26_LEDSAGCY

Chapter 26

LEDS

Agency Files

Last updated 9 March 2010

REVISIONS TO LEDS MANUAL CHAPTER 26, AGENCY FILE

Revision Date Section revised Subject revised

July 24, 2007 26.4.5 Minor typographical error corrected

April 17, 2008 26.8.24 New phone types added

March 9, 2010 26.7.4.9 Removed old Query of QAGY.OR024015Y.GRP/UCR1.MODE/E

Inserted corrected formats for this Query

January 29, 2016 All Formatting update.

Chapter 26 - LEDS Agency Files 26-1 For assistance call 503 378-5565

26.0 AGENCY FILE ....................................................................................................................... 5

26.1 FILE DESCRIPTION ................................................................................................................. 5

26.2 AUTHORIZED SYSTEM USE ............................................................................................... 5

26.3 ENTER AGENCY MESSAGE KEYS .................................................................................... 6

26.3.1 ENTER AGENCY TRANSACTION ..................................................................................... 6

26.3.2 EAGY - ENTER AGENCY ................................................................................................... 6

26.3.2.1 EAGY - ENTER AGENCY EXAMPLE .......................................................................... 7

26.3.2.2 EAGY – QUERY AFER ENTER AGENCY EXAMPLE ................................................. 7

26.3.3 ENTER AGENCY CONTACT.............................................................................................. 8

26.3.3.1 ECAG - ENTER AGENCY CONTACT ................................................................................ 8

26.3.3.2 ECAG – ENTER AGENCY CONTACT EXAMPLE ................................................... 8-8

26.3.3.3 ECAG – QUERY AFTER ENTER AGENCY CONTACT EXAMPLE ............................ 9

26.3.4 EPAG - ENTER AGENCY CONTACT TELEPHONE ..................................................... 10-9

26.3.4.1 EPAG - ENTER AGENCY CONTACT TELEPHONE EXAMPLE ...................................... 10

26.3.4.2 EPAG - QUERY AFTER ENTER AGENCY CONTACT TELEPHONE EXAMPLE............ 10

26.4 MAGY - MODIFY AGENCY TRANSACTION ............................................................... 11-10

26.4.1 MAGY - MODIFY AGENCY TRANSACTION DESCRIPTION .......................................... 11

26.4.2 MODIFY TRANSACTION PROCEDURE .......................................................................... 11

26.4.2.1 DELETIONS OF DATA FROM A RECORD .............................................................. 11

26.4.3 MODIFY AGENCY MESSAGE KEY ................................................................................. 12

26.4.4 IDENTIFICATION OF RECORD TO BE MODIFIED ......................................................... 12

26.4.5 MAGY - MODIFY AGENCY TRANSACTION ....................................................................... 12

26.4.5.1 MAGY - MODIFY AGENCY TRANSACTION EXAMPLE ................................................. 13

26.4.5.2 QUERY AFTER MODIFY AGENCY TRANSACTION ...................................................... 13

26.4.6 MODIFY AGENCY CONTACT TRANSACTION .................................................................. 14

26.4.6.1 MODIFY AGENCY CONTACT TRANSACTION EXAMPLE ............................................ 14

26.4.6.2 QUERY AFTER MODIFY AGENCY CONTACT TRANSACTION .................................... 14

26.4.6.3 MODIFY AGENCY TO REMOVE CONTACT’S ADDRESS INFORMATION .............. 15-14

26.4.7 MODIFY AGENCY CONTACT TELEPHONE TRANSACTION ........................................... 15

26.4.7.1 MODIFY AGENCY CONTACT TELEPHONE TRANSACTION EXAMPLE ...................... 15

26.4.7.2 QUERY AFTER MODIFY AGENCY CONTACT TELEPHONE TRANSACTION ........ 16-15

26.4.8 MODIFY AGENCY TO ADD AGENCY TO SELECTED GROUPS ...................................... 16

26.4.8.1 MODIFY AGENCY TO ADD AGENCY TO SELECTED GROUPS EXAMPLE ................ 16

26.4.8.2 QUERY AFTER MODIFY TO ADD AGENCY TO SELECTED GROUPS ................... 17-16

26.4.9 MODIFY AGENCY TO REMOVE AGENCY FROM SELECTED GROUPS ........................ 17

26.4.9.1 MODIFY AGENCY TO REMOVE AGENCY FROM SELECTED GROUPS EXAMPLE ... 17

26.4.9.2 QUERY AFTER MODIFY TO REMOVE AGENCY FROM SELECTED GROUPS ..... 18-17

26.5 CANCEL TRANSACTION .................................................................................................. 19

26.5.1 CANCEL AGENCY CONTACT TELEPHONE................................................................... 19

26.5.2 CANCEL AGENCY CONTACT TELEPHONE TRANSACTION ........................................ 19

26.5.2.1 CANCEL AGENCY CONTACT TELEPHONE TRANSACTION EXAMPLE .......... 19-18

26.5.2.2 QUERY AFTER CANCEL CONTACT TELEPHONE TRANSACTION ...................... 19

26.5.2 CANCEL AGENCY CONTACT ......................................................................................... 20

26.5.2.1 CANCEL AGENCY CONTACT TRANSACTION.......................................................... 20-19

26.5.2.2 CANCEL AGENCY CONTACT TRANSACTION EXAMPLE...................................... 20

26.5.2.3 QUERY AFTER CANCEL AGENCY CONTACT TRANSACTION ............................. 21

26.6 LOCATE TRANSACTION .................................................................................................... 21

26.7 QUERY AGENCY FILE TRANSACTION ............................................................................. 22

26.7.1 QUERY AGENCY FILE MESSAGE KEY .......................................................................... 22

26.7.2 QUERY AGENCY FILE TRANSACTION .......................................................................... 22

26.7.2.1 QUERY AGENCY FILE BY ORI EXAMPLE............................................................... 22

Chapter 26 - LEDS Agency Files 26-2 For assistance call 503 378-5565

26.7.2.2 QUERY AGENCY FILE BY ORI WITH WILDCARD EXAMPLE ................................ 23

26.7.2.3 QUERY AGENCY FILE BY ORI WITH WILDCARD AND RETURNING TECH.

SUPPORT STAFF EMAIL ........................................................................................................... 23

26.7.2.4 QUERY AGENCY FILE BY AGENCY MNEMONIC ................................................... 24

26.7.2.5 QUERY AGENCY FILE BY CONTACT TYPE EXAMPLE .................................... 24-23

26.7.2.6 QUERY AGENCY FILE BY CITY EXAMPLE ........................................................ 25-24

26.7.2.7 QUERY AGENCY FILE BY GROUP .......................................................................... 26

26.7.2.8 QUERY AGENCY FILE BY GROUP FOR LABELS ONLY ................................... 26-25

26.7.4.8.1 QUERY AGENCY FILE TO PRODUCE SINGLE LABEL FOR AN AGENCY. ........ 27

26.7.4.8.2 QUERY AGENCY FILE TO PRODUCE SINGLE LABEL FOR A CONTACT. .... 27-26

26.7.4.9 QUERY AGENCY FILE BY GROUP FOR EMAIL ADDRESSES ONLY .................... 28

26.7.4.10 QUERY AGENCY FILE BY GROUP TYPES ........................................................ 28-27

26.7.4.11 QUERY AGENCY FILE BY NAME WITH WILDCARD - FULL SINGLE LINE

RESPONSE ................................................................................................................................. 29

26.7.4.13 QUERY AGENCY FILE BY COUNTY - FULL SINGLE LINE RESPONSE ........... 29-28

26.7.4.13 QUERY AGENCY FILE BY TELEPHONE NUMBER WITH WILDCARD - FULL

SINGLE LINE RESPONSE .......................................................................................................... 30

26.8 MFC DIRECTORY ............................................................................................................... 30

26.8.1 ADL1 ADDRESS LINE 1 - 35 ........................................................................................... 30

26.8.2 ADL2 ADDRESS LINE 2 - 35 ........................................................................................... 30

26.8.3 ADL3 ADDRESS LINE 3 - 35 ........................................................................................... 30

26.8.4 AUTH APPOINTING AUTHORITY – 20 ........................................................................... 31

26.8.5 CCH PERMITTED ACCESS TO CCH – 1 ........................................................................ 31

26.8.5 CITY CITY – 20 ................................................................................................................ 31

26.8.6 CJA CRIMINAL JUSTICE AGENCY – 1 ........................................................................... 31

26.8.7 CMP COMPANY NAME - 40 ............................................................................................ 31

26.8.8 CNM CONTACT NAME – 40 ............................................................................................ 31

26.8.9 CTY COUNTY CODE – 2 ................................................................................................. 32

26.8.10 CTYP CONTACT TYPE – 4 ............................................................................................. 32

26.8.11 DOC DATE OF CANCEL – 8 ............................................................................................ 32

26.8.12 EML EMAIL ADDRESS - 80 ............................................................................................. 32

26.8.13 GRP ADD TO GROUP(S) - 4 ........................................................................................... 32

26.8.14 HOS HOURS OF SERVICE – 20 ..................................................................................... 33

26.8.15 III ACCESS TO INTERSTATE IDENTIFICATION INDEX – 1 .......................................... 33

26.8.16 MIS MISCELLANEOUS – 200 .......................................................................................... 33

26.8.17 MKE MESSAGE KEY - 4 .................................................................................................. 33

26.8.18 MNE AGENCY MNEMONIC – 4 ....................................................................................... 33

26.8.19 MODE MODE – 1 ............................................................................................................. 33

26.8.20 ORF OREGON ISSUED ORI – 1 ..................................................................................... 33

26.8.21 ORI ORIGINATING AGENCY IDENTIFIER – 9 ................................................................ 34

26.8.22 PHN TELEPHONE NUMBER – 10 ................................................................................... 34

26.8.23 PHNX TELEPHONE EXTENSION – 5 ............................................................................. 34

26.8.24 PTYP TELEPHONE TYPE – 4 ......................................................................................... 34

26.8.25 SPA STATE POLICE AGENCY – 1 .................................................................................. 34

26.8.26 SPVR SECURITY POLICY VERSION – 5 ....................................................................... 35

26.8.27 STA STATUS OF AGENCY – 1 ....................................................................................... 35

26.8.28 STE STATE – 2 ................................................................................................................ 35

26.8.29 TTL TITLE OF CONTACT PERSON – 20 ........................................................................ 35

26.8.30 UAR DATE USER AGREEMENT RECEIVED - 8 ............................................................ 35

Chapter 26 - LEDS Agency Files 26-3 For assistance call 503 378-5565

26.8.31 UAS DATE USER AGREEMENT SENT - 8 ..................................................................... 35

26.8.32 VAL DATE LAST VALIDATED – 8 ................................................................................... 35

26.8.33 XRP DELETE FROM GROUP(S) – 4 ............................................................................... 35

26.8.34 ZIP ZIP CODE – 9 ............................................................................................................ 35

Chapter 26 - LEDS Agency Files 26-4 For assistance call 503 378-5565

26.0 AGENCY FILE

26.1 FILE DESCRIPTION

The purpose of the CJIS Agency File is to provide contact information about Oregon criminal

justice and select governmental non-criminal justice agencies.

The CJIS Agency File contains address, telephone, and email information provided to CJIS by its

user community.

User agencies are requested to keep the data contained in their agency record accurate and up to

date.

26.2 AUTHORIZED SYSTEM USE

The LEDS, NCIC, and other databases are designed for, and made available to, criminal justice

agencies to aid in the investigation of crimes and prosecution of criminal offenses.

In addition, under certain conditions, select governmental non-criminal justice agencies are

granted limited access via specific authority set forth in law, rule, and/or executive order

necessary to fulfill very specific duties of given agency.

Notwithstanding this exception, use of the system as well as all the data entered into or extracted

from any such database(s) is restricted to a Criminal Justice Purpose and the “administration of

criminal justice” which is defined as:

“The performance of any of the following activities: detection, apprehension, detention, pretrial

release, post trial release, prosecution, adjudication, correctional supervision, or rehabilitation of

accused persons or criminal offenders.”

The administration of criminal justice shall include criminal identification activities and the

collection, storage, and dissemination of criminal history record information. Criminal justice

employment investigations are included, as is the licensing or issuing of a permit for a weapon or

explosive when required to be performed by a criminal justice agency, pursuant to a federal, state,

or local law. (This category includes firearms dealers and purchasers, carriers of concealed

weapons, explosives dealers and users and lethal weapons dealers and users). State and

Federal Inspector General offices are included.

Defense of accused persons, whether by private counsel, public defender or other court appointed

counsel is not included in the definition of the administration of criminal justice.

LEDS and NCIC conduct both routine and unscheduled audits to ensure strict adherence to

system discipline. LEDS is mandated to investigate all reports of violations of system use policies,

physical and technical security, as well as data access, use, and dissemination policies and

procedures.

Timely modification of a record is that which occurs as soon as possible following the detection of

erroneous data in an existing record, and/or as soon as possible following the receipt of data not

already stored in the record.

Chapter 26 - LEDS Agency Files 26-5 For assistance call 503 378-5565

26.3 ENTER AGENCY MESSAGE KEYS

EAGY ENTER Agency

ECAG ENTER Agency Contact

EPAG ENTER Agency Contact Telephone

26.3.1 ENTER AGENCY TRANSACTION

The Enter Agency (EAGY) transaction is used to enter an agency’s information into the CJIS

Agency File. This function is reserved for CJIS.

26.3.2 EAGY - ENTER AGENCY

EAGY OR 0 2 4 0 1 5 Y OR 0 3 7 0 4 0 0 Y N N L P Y Y N 3 7

         

MKE(4) ORI(9) ORI(9) CJA(1) ORF(1) MNE(4) CCH(1 III(1) SPA(1 CTY(2)

N EW T E S T ON L Y POL I CE 3 2 2 5 S T A T E S T RE E T



CNM(40) ADL1(35)

 SET #1

PO BOX 1 4 3 6 0

 

ADL1(Continued) ADL2(35) ADL3(35)

 SET #1 (Continued)

OR 9 7 3 0 9 2 3 8 7 9

   

ADL3(Continued) CITY(20) STE(2) ZIP(9)

 SET #1 (Continued)

5 0 3 3 7 8 3 0 5 5 5 5 0 1 4 2 0 0 6 0 8 1 5 3 4 0 T H I S I S A

   

PHN(10) PHNX(5) UAS(8) AUTH(20) SPVR(5) MISC(200)

T E S T RECORD

MISC(Continued)

MISC(Continued)

MISC(Continued)

Mandatory fields.

Conditional fields

Optional fields: however, if a mandatory field is present past the optional field, the dot on either

side is mandatory regardless if the optional field is used or left blank.

 SET Must be used as a dataset; therefore each related field must contain appropriate data.

Indicates dot required only if optional field(s) is/are used. The dot is required if the field is left

 

blank and another field is entered after it.

Chapter 26 - LEDS Agency Files 26-6 For assistance call 503 378-5565

26.3.2.1 EAGY - ENTER AGENCY EXAMPLE

EAGY.OR024015Y.OR0370400.Y.N.NLP.Y.Y.N.37.NEW TEST ONLY POLICE.3225 STATE STREET.PO

BOX 14630..SALEM.OR.973092387.5043783055.55014.20060815 340.THIS IS A TEST RECORD

LEDS RESPONSE: EAGY TRANSACTION

REUR 0028 LEDS

ENTERED OR0370400

NEW TEST ONLY POLICE

CCH ACCESS/YES NCIC III ACCESS/YES

26.3.2.2 EAGY – QUERY AFER ENTER AGENCY EXAMPLE

QAGY.OR024015Y.ORI/OR0370400

LEDS RESPONSE: QUERY AFTER ENTRY

REUR 0029 LEDS

ORI/OR0370400 COUNTY/37 - LEDS TEST

AGENCY/NEW TEST ONLY POLICE

ADL1/3225 STATE STREET 24 HR PHONE/(504) 378-3055 EXT/55014

ADL2/PO BOX 14630 FAX/

ADL3/ VALIDATED/

CITY/SALEM STATE/OR ZIP/97309-2387 MNE/NLP

MEMBER GROUPS/AGREEMENT NOT RETURNED

USER AGR SENT/2006/08/15 USER AGR RETN/

CRIMINAL JUSTICE AGENCY

OREGON CCH ACCESS/YES NCIC III ACCESS/YES SEC POLICY VER/3.40

MIS/THIS IS A TEST RECORD

ENT/2006/12/22 08:30 EMNE/LE41 UDT/

Chapter 26 - LEDS Agency Files 26-7 For assistance call 503 378-5565

26.3.3 ENTER AGENCY CONTACT

When entering an agency contact, address information should only be entered if this is different

from the “main” agency address data.

26.3.3.1 ECAG - ENTER AGENCY CONTACT

ECAG OR 0 2 4 0 1 5 Y 0 R 0 3 7 0 4 0 0 RE P J OHN Q PUB L I C

   

MKE(4) ORI(9) ORI(9) CTYP(4) CNM(40)

RECORDS SUPERV I SOR

  

CNM(CONTINUED) TTL(20) CMP(30)

N EWE MA I L@C H E A P ( D O T ) C OM

EML(80)

9 5 5 CEN T ER S T

 

EML(80)(Cont.) HOS(20) ADL1(35)

 SET #1

 

ADL2(35) ADL3(35)

 SET #1 (Continued)

SA L EM OR 9 7 3 0 1 DE SK 5 0 3 5 5 5 3 4 3 4

     

ADL3(Continued) CITY(20) STE(2) ZIP(9) PTYP(4) PHN(10)

 SET #1 (Continued)  SET #2

PHNX(5)

 SET #2

Mandatory fields.

Conditional fields

Optional fields: however, if a mandatory field is present past the optional field, the dot on either

side is mandatory regardless if the optional field is used or left blank.

 SET Must be used as a dataset; therefore each related field must contain appropriate data.

Indicates dot required only if optional field(s) is/are used. The dot is required if the field is left

 

blank and another field is entered after it.

26.3.3.2 ECAG – ENTER AGENCY CONTACT EXAMPLE

This enters contact data for the agency’s CJIS representative.

ECAG.OR024015Y.OR0370400.REP.JOHN Q PUBLIC.RECORDS

SUPERVISOR..NEWEMAIL@CHEAP(DOT)COM..955 CENTER ST...SALEM.OR.97301.DESK.5035553434

Chapter 26 - LEDS Agency Files 26-8 For assistance call 503 378-5565

LEDS RESPONSE: ECAG TRANSACTION

LQU01470000. Jan 11, 2007 13:25:42

REUR 0147 LEDS

ENTERED CONTACT FOR OR0370400

CNM/JOHN Q PUBLIC

CTYP/REP

EML/NEWEMAIL@CHEAP(DOT)COM

PHONE/(503) 555-3434

26.3.3.3 ECAG – QUERY AFTER ENTER AGENCY CONTACT EXAMPLE

QAGY.OR024015Y.ORI/OR0370400

LEDS RESPONSE: QUERY AFTER ENTER

LQU01480000. Jan 11, 2007 13:29:09

REUR 0148 LEDS

ORI/OR0370400 COUNTY/37 - LEDS TEST

AGENCY/ NEW TEST ONLY POLICE

ADL1/3225 STATE STREET 24 HR PHONE/(503) 378-3055 EXT/55014

ADL2/PO BOX 14360 FAX/

ADL3/ VALIDATED/

CITY/SALEM STATE/OR ZIP/97309-2387 MNE/LE41

MEMBER GROUPS/AGREEMENT NOT RETURNED, POLICE DEPARTMENTS

USER AGR SENT/2006/08/15 USER AGR RETN/

CRIMINAL JUSTICE AGENCY

OREGON CCH ACCESS/YES NCIC III ACCESS/YES SEC POLICY VER/3.40

MIS/THIS IS A TEST RECORD

CJIS REP/JOHN Q PUBLIC

TITLE/RECORDS SUPERVISOR

EMAIL/NEWEMAIL@CHEAP.COM

DESK NUMBER/(503) 555-3434

ADL1/955 CENTER ST

CITY/SALEM STATE/OR ZIP/97301

ENT/2006/12/22 08:30 EMNE/LE41 UDT/2007/01/11 13:25 UMNE/LE41

Chapter 26 - LEDS Agency Files 26-9 For assistance call 503 378-5565

26.3.4 EPAG - ENTER AGENCY CONTACT TELEPHONE

E PAG OR 0 2 4 0 1 5 Y OR 0 3 7 0 4 0 0 RE P F AX 5 0 3 3 6 3 8 2 4 9

     

MKE(4) ORI(9) ORI(9) CTYP(4) PTYP(4) PHN(10) PHNX(5)

Mandatory fields.

Conditional fields

Optional fields: however, if a mandatory field is present past the optional field, the dot on either

side is mandatory regardless if the optional field is used or left blank.

 SET Must be used as a dataset; therefore each related field must contain appropriate data.

Indicates dot required only if optional field(s) is/are used. The dot is required if the field is left

 

blank and another field is entered after it.

26.3.4.1 EPAG - ENTER AGENCY CONTACT TELEPHONE EXAMPLE

This example enters a facsimile number for the agency’s CJIS representative.

EPAG.OR024015Y.OR0370400.REP.FAX.5033638249

LEDS RESPONSE: EPAG TRANSACTION

REUR 0032 LEDS

ENTERED PHONE FOR OR0370400

CNM/JOHN Q PUBLIC

CTYP/REP

PHONE/(503) 363-8249

26.3.4.2 EPAG - QUERY AFTER ENTER AGENCY CONTACT TELEPHONE EXAMPLE

QAGY.OR024015Y.ORI/OR0370400

Chapter 26 - LEDS Agency Files 26-10 For assistance call 503 378-5565

LEDS RESPONSE: QUERY AFTER ENTER

REUR 0031 LEDS

ORI/OR0370400 COUNTY/37 - LEDS TEST

AGENCY/ NEW TEST ONLY POLICE DEPARTMENT

ADL1/3225 STATE STREET 24 HR PHONE/(503) 378-5565

ADL2/PO BOX 14360 FAX/

ADL3/ VALIDATED/

CITY/SALEM STATE/OR ZIP/97309-5074 MNE/LE41

MEMBER GROUPS/POLICE DEPARTMENTS

USER AGR SENT/2006/08/15 USER AGR RETN/

CRIMINAL JUSTICE AGENCY

OREGON CCH ACCESS/YES NCIC III ACCESS/YES SEC POLICY VER/3.40

MIS/THIS IS A TEST RECORD

CJIS REP/JOHN Q PUBLIC

TITLE/RECORDS SUPERVISOR

EMAIL/NEWEMAIL@CHEAP.COM

DESK NUMBER/(503) 555-3434 FAX NUMBER/(503) 363-8249

ENT/2006/12/22 08:30 EMNE/LE41 UDT/2008/12/02 15:51 UMNE/LE36

26.4 MAGY - MODIFY AGENCY TRANSACTION

26.4.1 MAGY - MODIFY AGENCY TRANSACTION DESCRIPTION

The modify transaction is used to add, delete or change data in one or more fields of an existing

Agency record. Fields that do not exist in the record cannot be modified i.e. a modify transaction

cannot be used to add new fields to a record but it can add data to existing empty fields.

26.4.2 MODIFY TRANSACTION PROCEDURE

An Agency record can only be modified by that agency or by CJIS. Records must be immediately

modified when it is determined:

 Data contained in the record is incorrect, or

 Additional data has been located that is not included in the record.

Key parts of the agency file have been reserved for use by CJIS staff but most fields are available

to agencies for updating.

26.4.2.1 DELETIONS OF DATA FROM A RECORD

To delete data from a field, enter the message field code followed by a slash and a period. (e.g.

MNE/. removes the data in that field from the record.) This technique can be used to delete data

from the following fields:- ADL1, ADL2, ADL3, AUTH, CITY, CMP, EML, HOS, MIS, MNE, PHNX,

STE, SPVR, TTL, UAR, and ZIP

Note: In the “MAIN” section of the record, agencies can modify the ADL1, ADL2, ADL3, CITY,

STE, and ZIP fields but cannot delete them.

Chapter 26 - LEDS Agency Files 26-11 For assistance call 503 378-5565

26.4.3 MODIFY AGENCY MESSAGE KEY

MAGY Modify Agency Record

26.4.4 IDENTIFICATION OF RECORD TO BE MODIFIED

Records to be modified must be identified by ORI.

Each field to be modified must be preceded by the appropriate message field code.

If address, contact name (CNM), contact title (TTL), and/or email address (EML) data is to be

modified then CTYP is also required to identify the contact type.

If telephone number (PHN) data is to be modified then CTYP is again required to identify the

contact type and PTYP is also required to identify the telephone type.

26.4.5 MAGY - MODIFY AGENCY TRANSACTION

MAGY●ORI●ORI/_ _ _●MNE/_ _ _

●CCH/_ _ _ Fields within this box can only be modified by CJIS

●III/_ _ _

●STA/_ _ _ If status is R then MIS cannot be modified.

●UAS/_ _ _

●UAR/_ _ _

●AUTH/_ _ _

●SPVR/_ _ _

●GRP/_ _ _●_ _ _●_ _ _●_ _ _●_ _ _ Up to five groups can be entered per MFC

●XRP/_ _ _●_ _ _●_ _ _●_ _ _●_ _ _ Up to five groups can be entered per MFC

●VAL/_ _ _

●MIS/_ _ _ If status is R then MIS cannot be modified.

●CTYP/_ _ _ Required only if modifying address and/or contact data.

●ADL1/_ _ _●ADL2/_ _ _●ADL3/_ _ _●CITY/ _ _ _●STE/ _ _ _●ZIP/ _ _ _

●CNM/_ _ _

●TTL/_ _ _

●EML/_ _ _

●CMP/_ _ _

●HOS/_ _ _

●PTYP/_ _ _ ** Required only if modifying telephone data **

●PHN/_ _ _●PHNX/_ _ _

BOX INDICATES DATA MUST BE USED AS A SET

Chapter 26 - LEDS Agency Files 26-12 For assistance call 503 378-5565

26.4.5.1 MAGY - MODIFY AGENCY TRANSACTION EXAMPLE

Modifies the base record to interchange the agency’s mailing and physical addresses.

MAGY.OR024015Y.ORI/OR0370400.CTYP/MAIN.ADL1/PO BOX 14360.ADL2/3225 STATE

STREET.CITY/SALEM.STE/OR.ZIP/973095074

LEDS RESPONSE: MAGY TRANSACTION

REUR 0045 LEDS

MODIFIED OR0370400

CNM/NEW TEST ONLY POLICE

YOU ARE STRONGLY URGED TO RUN THE RECORD

AND EXAMINE THE DISPLAY CLOSELY FOR ACCCURACY.

26.4.5.2 QUERY AFTER MODIFY AGENCY TRANSACTION

QAGY.OR024015Y.ORI/OR0370400

LEDS RESPONSE: QUERY AFTER MAGY TRANSACTION

REUR 0046 LEDS

ORI/OR0370400 COUNTY/37 - LEDS TEST

AGENCY/NEW TEST ONLY POLICE

ADL1/PO BOX 14360 24 HR PHONE/(504) 378-3055 EXT/55014

ADL2/3225 STATE STREET FAX/(503) 363-8249

ADL3/ VALIDATED/

CITY/SALEM STATE/OR ZIP/97309-5074 MNE/NLP

MEMBER GROUPS/AGREEMENT NOT RETURNED

USER AGR SENT/2006/08/15 USER AGR RETN/

CRIMINAL JUSTICE AGENCY

OREGON CCH ACCESS/YES NCIC III ACCESS/YES SEC POLICY VER/3.40

MIS/THIS IS A TEST RECORD

CJIS REP/JOHN Q PUBLIC

TITLE/RECORDS SUPERVISOR

EMAIL/NEWEMAIL@CHEAP.COM

DESK NUMBER/(503) 555-3434 EXT/55012 FAX NUMBER/(503) 363-8249

ADL1/955 CENTER ST

CITY/SALEM STATE/OR ZIP/97301

ENT/2006/12/22 08:30 EMNE/LE41 UDT/2006/12/28 06:57 UMNE/LE41

Chapter 26 - LEDS Agency Files 26-13 For assistance call 503 378-5565

26.4.6 MODIFY AGENCY CONTACT TRANSACTION

MAGY●ORI●ORI/_ _ _●CTYP/ _ _ _●CNM/ _ _ _

●CMP/_ _ _

●EML/_ _ _

●HOS/_ _ _

●ADL1/_ _ _●ADL2/_ _ _●ADL3/_ _ _●CITY/ _ _ _●STE/ _ _ _●ZIP/ _ _

BOX INDICATES DATA MUST BE USED AS A SET

26.4.6.1 MODIFY AGENCY CONTACT TRANSACTION EXAMPLE

Modifies the base record to change the agency’s name.

MAGY.OR024015Y.ORI/OR0370400.CTYP/MAIN.CNM/NEW TEST ONLY POLICE DEPARTMENT

LEDS RESPONSE: MAGY TRANSACTION

REUR 0047 LEDS

MODIFIED OR0370400

CNM/NEW TEST ONLY POLICE

YOU ARE STRONGLY URGED TO RUN THE RECORD

AND EXAMINE THE DISPLAY CLOSELY FOR ACCCURACY.

26.4.6.2 QUERY AFTER MODIFY AGENCY CONTACT TRANSACTION

QAGY.OR024015Y.ORI/OR0370400

LEDS RESPONSE: QUERY AFTER MAGY TRANSACTION

REUR 0048 LEDS

ORI/OR0370400 COUNTY/37 - LEDS TEST

AGENCY/NEW TEST ONLY POLICE DEPARTMENT

ADL1/PO BOX 14360 24 HR PHONE/(504) 378-3055 EXT/55014

ADL2/3225 STATE STREET FAX/(503) 363-8249

ADL3/ VALIDATED/

CITY/SALEM STATE/OR ZIP/97309-5074 MNE/NLP

MEMBER GROUPS/AGREEMENT NOT RETURNED

USER AGR SENT/2006/08/15 USER AGR RETN/

CRIMINAL JUSTICE AGENCY

OREGON CCH ACCESS/YES NCIC III ACCESS/YES SEC POLICY VER/3.40

MIS/THIS IS A TEST RECORD

CJIS REP/JOHN Q PUBLIC

TITLE/RECORDS SUPERVISOR

EMAIL/NEWEMAIL@CHEAP.COM

Chapter 26 - LEDS Agency Files 26-14 For assistance call 503 378-5565

DESK NUMBER/(503) 555-3434 EXT/55012 FAX NUMBER/(503) 363-8249

ADL1/955 CENTER ST

CITY/SALEM STATE/OR ZIP/97310

ENT/2006/12/22 08:30 EMNE/LE41 UDT/2006/12/28 10:48 UMNE/LE41

26.4.6.3 MODIFY AGENCY TO REMOVE CONTACT’S ADDRESS INFORMATION

MAGY.OR024015Y.ORI/OR0370400.CTYP/REP.ADL1/.CITY/.STE/.ZIP/

Note: ADL1, CITY, STE, and ZIP must be modified as a set.

LEDS RESPONSE: QUERY AFTER MAGY TRANSACTION

REUR 0169 LEDS

ORI/OR0370400 COUNTY/37 - LEDS TEST

AGENCY/ NEW TEST ONLY POLICE DEPARTMENT

ADL1/PO BOX 14360 24 HR PHONE/(503) 378-5565

ADL2/3225 STATE STREET FAX/(503) 363-8249

ADL3/ VALIDATED/

CITY/SALEM STATE/OR ZIP/97309-5074 MNE/LE41

MEMBER GROUPS/AGREEMENT NOT RETURNED, POLICE DEPARTMENTS

USER AGR SENT/2006/08/15 USER AGR RETN/

CRIMINAL JUSTICE AGENCY

OREGON CCH ACCESS/YES NCIC III ACCESS/YES SEC POLICY VER/3.40

MIS/THIS IS A TEST RECORD

CJIS REP/JOHN Q PUBLIC

TITLE/RECORDS SUPERVISOR

EMAIL/NEWEMAIL@CHEAP.COM

DESK NUMBER/(503) 555-3434 FAX NUMBER/(503) 363-8249

ENT/2006/12/22 08:30 EMNE/LE41 UDT/2007/01/12 06:45 UMNE/LE41

26.4.7 MODIFY AGENCY CONTACT TELEPHONE TRANSACTION

MAGY●ORI●ORI/_ _ _●CTYP/ _ _ _●PTYP/_ _ _●PHN/_ _ _●PHNX/_ _ _

26.4.7.1 MODIFY AGENCY CONTACT TELEPHONE TRANSACTION EXAMPLE

Modifies the base record to change the agency’s 24 hour contact telephone number

MAGY.OR024015Y.ORI/OR0370400.CTYP/MAIN.PTYP/MAIN.PHN/5033785565.PHNX/

Note: Modifying PHN by itself will make no difference to the contents of PHNX i.e. to change PHNX

requires that both PHN and PHNX are entered.

Chapter 26 - LEDS Agency Files 26-15 For assistance call 503 378-5565

LEDS RESPONSE: MAGY TRANSACTION

REUR 0017 LEDS

MODIFIED OR0370400

CNM/NEW TEST ONLY POLICE

YOU ARE STRONGLY URGED TO RUN THE RECORD

AND EXAMINE THE DISPLAY CLOSELY FOR ACCCURACY.

26.4.7.2 QUERY AFTER MODIFY AGENCY CONTACT TELEPHONE TRANSACTION

QAGY.OR024015Y.ORI/OR0370400

LEDS RESPONSE: QUERY AFTER MODIFY

REUR 0018 LEDS

ORI/OR0370400 COUNTY/37 - LEDS TEST

AGENCY/NEW TEST ONLY POLICE

ADL1/PO BOX 14360 24 HR PHONE/(503) 378-5565

ADL2/3225 STATE STREET FAX/(503) 363-8249

ADL3/ VALIDATED/

CITY/SALEM STATE/OR ZIP/97309-2387 MNE/NLP

MEMBER GROUPS/AGREEMENT NOT RETURNED

USER AGR SENT/2006/08/15 USER AGR RETN/

CRIMINAL JUSTICE AGENCY

OREGON CCH ACCESS/YES NCIC III ACCESS/YES SEC POLICY VER/3.40

MIS/THIS IS A TEST RECORD

CJIS REP/JOHN Q PUBLIC

TITLE/RECORDS SUPERVISOR

EMAIL/NEWEMAIL@CHEAP.COM

DESK NUMBER/(503) 555-3434 EXT/55012 FAX NUMBER/(503) 363-8249

ENT/2006/12/22 08:30 EMNE/LE41 UDT/2006/12/26 12:29 UMNE/LE41

26.4.8 MODIFY AGENCY TO ADD AGENCY TO SELECTED GROUPS

MAGY.OR024015Y.ORI/_ _ _.GRP/_ _ __ _ __ _ __ _ __ _ _

26.4.8.1 MODIFY AGENCY TO ADD AGENCY TO SELECTED GROUPS EXAMPLE

This modifies the record to add the agency to the Police Departments, NCIC Validations, and

Uniform Crime Reporting groups.

MAGY.OR024015Y.ORI/OR0370400.GRP/PD.NVAL.UCR

LEDS RESPONSE: MAGY TRANSACTION

LQU00120000. Jan 03, 2007 09:32:02

Chapter 26 - LEDS Agency Files 26-16 For assistance call 503 378-5565

REUR 0012 LEDS

MODIFIED OR0370400

CNM/ NEW TEST ONLY POLICE DEPARTMENT

YOU ARE STRONGLY URGED TO RUN THE RECORD

AND EXAMINE THE DISPLAY CLOSELY FOR ACCCURACY.

26.4.8.2 QUERY AFTER MODIFY TO ADD AGENCY TO SELECTED GROUPS

QAGY.OR024015Y.ORI/OR0370400

LEDS RESPONSE: QUERY AFTER MODIFY

LQU00130000. Jan 03, 2007 09:44:34

REUR 0013 LEDS

ORI/OR0370400 COUNTY/37 - LEDS TEST

AGENCY/NEW TEST ONLY POLICE DEPARTMENT

ADL1/PO BOX 14360 24 HR PHONE/(503) 378-5565

ADL2/3225 STATE STREET FAX/(503) 363-8249

ADL3/ VALIDATED/

CITY/SALEM STATE/OR ZIP/97309-5074 MNE/LE41

MEMBER GROUPS/AGREEMENT NOT RETURNED, POLICE DEPARTMENTS, NCIC VALIDATIONS,

FULL UCR AGENCY LIST

USER AGR SENT/2006/08/15 USER AGR RETN/

CRIMINAL JUSTICE AGENCY

OREGON CCH ACCESS/YES NCIC III ACCESS/YES SEC POLICY VER/3.40

MIS/THIS IS A TEST RECORD

CJIS REP/JOHN Q PUBLIC

EMAIL/NEWEMAIL@CHEAP.COM

DESK NUMBER/(503) 555-3434 EXT/55012 FAX NUMBER/(503) 363-8249

ENT/2006/12/22 08:30 EMNE/LE41 UDT/2007/01/03 09:32 UMNE/LE41

26.4.9 MODIFY AGENCY TO REMOVE AGENCY FROM SELECTED GROUPS

MAGY.OR024015Y.ORI/_ _ _.XRP/_ _ __ _ __ _ __ _ __ _ _

26.4.9.1 MODIFY AGENCY TO REMOVE AGENCY FROM SELECTED GROUPS EXAMPLE

This modifies the record to remove the agency from the NCIC Validations, and Uniform Crime

Reporting groups.

MAGY.OR024015Y.ORI/OR0370400.XRP/NVAL.UCR

LEDS RESPONSE: MAGY TRANSACTION

LQU00140000. Jan 03, 2007 10:19:58

REUR 0014 LEDS

Chapter 26 - LEDS Agency Files 26-17 For assistance call 503 378-5565

MODIFIED OR0370400

CNM/ NEW TEST ONLY POLICE DEPARTMENT

YOU ARE STRONGLY URGED TO RUN THE RECORD

AND EXAMINE THE DISPLAY CLOSELY FOR ACCCURACY.

26.4.9.2 QUERY AFTER MODIFY TO REMOVE AGENCY FROM SELECTED GROUPS

QAGY.OR024015Y.ORI/OR0370400

LEDS RESPONSE: QUERY AFTER MODIFY

LQU00150000. Jan 03, 2007 10:23:21

REUR 0015 LEDS

ORI/OR0370400 COUNTY/37 - LEDS TEST

AGENCY/NEW TEST ONLY POLICE DEPARTMENT

ADL1/PO BOX 14360 24 HR PHONE/(503) 378-5565

ADL2/3225 STATE STREET FAX/(503) 363-8249

ADL3/ VALIDATED/

CITY/SALEM STATE/OR ZIP/97309-5074 MNE/LE41

MEMBER GROUPS/AGREEMENT NOT RETURNED, POLICE DEPARTMENTS

USER AGR SENT/2006/08/15 USER AGR RETN/

CRIMINAL JUSTICE AGENCY

OREGON CCH ACCESS/YES NCIC III ACCESS/YES SEC POLICY VER/3.40

MIS/THIS IS A TEST RECORD

CJIS REP/JOHN Q PUBLIC

EMAIL/NEWEMAIL@CHEAP.COM

DESK NUMBER/(503) 555-3434 EXT/55012 FAX NUMBER/(503) 363-8249

ENT/2006/12/22 08:30 EMNE/LE41 UDT/2007/01/03 10:20 UMNE/LE41

Chapter 26 - LEDS Agency Files 26-18 For assistance call 503 378-5565

26.5 CANCEL TRANSACTION

XCAG CANCEL Agency Contact

XPAG CANCEL Agency Contact Telephone

26.5.1 CANCEL AGENCY CONTACT TELEPHONE

The Cancel Agency Contact Telephone (XPAG) transaction is used for the cancellation of a

specified telephone number associated with an agency contact. Telephone numbers may be

cancelled one at a time from the agency contact’s information in the CJIS Agency File. Currently

this function is reserved for CJIS use only.

26.5.2 CANCEL AGENCY CONTACT TELEPHONE TRANSACTION

X P A G OR 0 2 4 0 1 5 Y OR 0 3 7 0 4 0 0 R E P FAX 20070103

    

MKE(4) ORI(9) ORI(9) CTYP(4) PTYP(4) DOC(8)

Mandatory fields.

26.5.2.1 CANCEL AGENCY CONTACT TELEPHONE TRANSACTION EXAMPLE

This example removes the facsimile number for the CJIS representative.

XPAG.OR024015Y.OR0370400.REP.FAX.20070103

LEDS RESPONSE: XPAG TRANSACTION

LQU00160000. Jan 03, 2007 10:56:30

REUR 0016 LEDS

CANCELED PHONE FOR OR0370400

CNM/JOHN Q PUBLIC

CTYP/REP

PHONE/(503) 363-8249

26.5.2.2 QUERY AFTER CANCEL CONTACT TELEPHONE TRANSACTION

QAGY.OR024015Y.ORI/OR0370400

Chapter 26 - LEDS Agency Files 26-19 For assistance call 503 378-5565

LEDS RESPONSE: QUERY AFTER MODIFY

LQU00170000. Jan 03, 2007 11:01:19

REUR 0017 LEDS

ORI/OR0370400 COUNTY/37 - LEDS TEST

AGENCY/NEW TEST ONLY POLICE DEPARTMENT

ADL1/PO BOX 14360 24 HR PHONE/(503) 378-5565

ADL2/3225 STATE STREET FAX/

ADL3/ VALIDATED/

CITY/SALEM STATE/OR ZIP/97309-5074 MNE/LE41

MEMBER GROUPS/AGREEMENT NOT RETURNED, POLICE DEPARTMENTS

USER AGR SENT/2006/08/15 USER AGR RETN/

CRIMINAL JUSTICE AGENCY

OREGON CCH ACCESS/YES NCIC III ACCESS/YES SEC POLICY VER/3.40

MIS/THIS IS A TEST RECORD

CJIS REP/JOHN Q PUBLIC

EMAIL/NEWEMAIL@CHEAP.COM

DESK NUMBER/(503) 555-3434 EXT/55012

ENT/2006/12/22 08:30 EMNE/LE41 UDT/2007/01/03 10:56 UMNE/LE41

26.5.2 CANCEL AGENCY CONTACT

The Cancel Agency Contact (XCAG) transaction is used for the cancellation of a specified contact

associated with an agency. Contacts may be cancelled one at a time from the agency’s

information in the CJIS Agency File. Currently this function is reserved for CJIS use only.

26.5.2.1 CANCEL AGENCY CONTACT TRANSACTION

X C A G OR 0 2 4 0 1 5 Y OR 0 3 7 0 4 0 0 R E P 20070103

   

MKE(4) ORI(9) ORI(9) CTYP(4) DOC(8)

Mandatory fields.

26.5.2.2 CANCEL AGENCY CONTACT TRANSACTION EXAMPLE

This example totally removes the contact information for the CJIS representative.

XCAG.OR024015Y.OR0370400.REP.20070103

LEDS RESPONSE: XCAG TRANSACTION

LQU00180000. Jan 03, 2007 11:20:35

REUR 0018 LEDS

CANCELED CONTACT FOR OR0370400

CNM/JOHN Q PUBLIC

CTYP/REP

Chapter 26 - LEDS Agency Files 26-20 For assistance call 503 378-5565

26.5.2.3 QUERY AFTER CANCEL AGENCY CONTACT TRANSACTION

QAGY.OR024015Y.ORI/OR0370400

LEDS RESPONSE: QUERY AFTER MODIFY

LQU00190000. Jan 03, 2007 11:29:57

REUR 0019 LEDS

ORI/OR0370400 COUNTY/37 - LEDS TEST

AGENCY/NEW TEST ONLY POLICE DEPARTMENT

ADL1/PO BOX 14360 24 HR PHONE/(503) 378-5565

ADL2/3225 STATE STREET FAX/

ADL3/ VALIDATED/

CITY/SALEM STATE/OR ZIP/97309-5074 MNE/LE41

MEMBER GROUPS/AGREEMENT NOT RETURNED, POLICE DEPARTMENTS

USER AGR SENT/2006/08/15 USER AGR RETN/

CRIMINAL JUSTICE AGENCY

OREGON CCH ACCESS/YES NCIC III ACCESS/YES SEC POLICY VER/3.40

MIS/THIS IS A TEST RECORD

ENT/2006/12/22 08:30 EMNE/LE41 UDT/2007/01/03 11:20 UMNE/LE41

26.6 LOCATE TRANSACTION

CJIS Agency records cannot be located.

Chapter 26 - LEDS Agency Files 26-21 For assistance call 503 378-5565

26.7 QUERY AGENCY FILE TRANSACTION

26.7.1 QUERY AGENCY FILE MESSAGE KEY

QAGY Query Agency

26.7.2 QUERY AGENCY FILE TRANSACTION

QAGY●ORI●ORI/_ _ _●MODE/L

●MNE/_ _ _

●CITY/_ _ _●MODE/_

●CTYPE/_ _ _●MODE/_

●GRP/_ _ _●MODE/_

●CNM/_ _ _

●CTY/_ _ _●MODE/_

●PHN/_ _ _

26.7.2.1 QUERY AGENCY FILE BY ORI EXAMPLE

This query returns the data for the LEDSTEST Police Department (ORI OR0370100)

QAGY.OR024015Y.ORI/OR0370100

LEDS RESPONSE: QAGY TRANSACTION

REUR 0010 LEDS

ORI/OR0370100 COUNTY/37 - LEDS TEST

AGENCY/PD LEDSTEST

ADL1/ 24 HR PHONE/

ADL2/ FAX/

ADL3/ VALIDATED/

CITY/ STATE/ ZIP/ MNE/LTP

MEMBER GROUPS/AGREEMENT NOT RETURNED, POLICE DEPARTMENTS

USER AGR SENT/2004/07/02 USER AGR RETN/

CRIMINAL JUSTICE AGENCY

OREGON CCH ACCESS/YES NCIC III ACCESS/YES SEC POLICY VER/NONE

MIS/DUMMY 0RI F0R PERMANENT TEST REC0RDS

CJIS REP/CHUCKS TEST LREP

EMAIL/TRAINING.LEDS@TATE.OR.US

ENT/1999/07/13 11:11 EMNE/PGM UDT/

Chapter 26 - LEDS Agency Files 26-22 For assistance call 503 378-5565

26.7.2.2 QUERY AGENCY FILE BY ORI WITH WILDCARD EXAMPLE

This example queries the agency file to produce a list of county custodial facilities.

QAGY.OR024015Y.ORI/OR*3C

LEDS RESPONSE: QAGY TRANSACTION

REUR 0001 LEDS

OR001013C CO JL BAKER (541) 523-8011

OR002013C CO JL CORVALLIS (541) 766-6001

OR003013C CO JL OREGON CITY (503) 655-8331

OR003023C/RET COUNTY RANCH-OREGON CITY

OR003033C CLACKAMAS CO CORR FACILITY (503) 650-3151

OR004013C CLATSOP CO CORR FACILITY (503) 325-8641 EXT/0

OR005013C CO JAIL ST HELENS (503) 397-7245

OR034013C SO WASH CO JAIL-WARRANTS (503) 846-2526

OR034023C/RET COMM CORR HILLSBORO

OR034043C WASH CO COMM CORR CENTER (503) 846-8818

OR035013C CO JL FOSSIL (541) 763-4101

OR036013C CO JL MCMINNVILLE (503) 434-7507

OR036023C YAMHILL CO JUV DET FAC (503) 434-7407

OR037013C CO JL LEDSTEST

OR037023C LEDSTEST CO JUVENILE DEPT

Note: Retired agency records are only displayed for ORI OR024015Y

26.7.2.3 QUERY AGENCY FILE BY ORI WITH WILDCARD AND RETURNING TECH.

SUPPORT STAFF EMAIL

This requests the email addresses for the technical support personnel associated with custodial

facilities.

QAGY.OR024015Y.ORI/OR*3C.CTYP/TECH.MODE/E

LEDS RESPONSE: QAGY TRANSACTION

REUR 0014 LEDS

STHOMPSON@BAKER911.ORG,

LARRYSHE@CO.CLACKAMAS.OR.US,

LARRYV@DESCHUTES.ORG,

KRPOTTER@CO.DOUGLAS.OR.US,

HCEMA@CO.HARNEY.OR.US,

JHBROCK@CO.JOSEPHINE.OR.US,

DKILLIAN@CO.LINCOLN.OR.US,

CSMITH@MALHEURCO.ORG,

JBREWSTER@CO.MARION.OR.US,

PARTIAL RESPONSE FROM QUERY

Chapter 26 - LEDS Agency Files 26-23 For assistance call 503 378-5565

26.7.2.4 QUERY AGENCY FILE BY AGENCY MNEMONIC

This example requests the agency file record for the Criminal Justice Information Services

(LEDS).

QAGY.MNE/LED

LEDS RESPONSE: QAGY TRANSACTION

REUR 0154 LEDS

ORI/OR024015Y COUNTY/24 - MARION

AGENCY/OSP – LAW ENFORCEMENT DATA SYSTEM

ADL1/ANDERSON READINESS CENTER 24 HR PHONE/(503) 378-5565

ADL2/PO BOX 14360 FAX/(503) 364-2661

ADL3/3225 STATE ST VALIDATED/

CITY/SALEM STATE/OR ZIP/97309-5074 MNE/LED

MEMBER GROUPS/AGREEMENT NOT RETURNED, STATE POLICE OFFICES

USER AGR SENT/ USER AGR RETN/

CRIMINAL JUSTICE AGENCY

OREGON CCH ACCESS/YES NCIC III ACCESS/YES SEC POLICY VER/NONE

MIS/CONTROL TERMINAL AGENCY FOR OREGON

ADMINISTRATOR/TERRY OCONNELL

TITLE/DIRECT0R

EMAIL/TERRY.OCONNELL@STATE.OR.US

DESK NUMBER/(503) 378-5033 EXT/55020 FAX NUMBER/(503) 364-2661

CJIS REP/JENNIFER FERRIS

EMAIL/JENNIFER.FERRIS@STATE.OR.US

DESK NUMBER/(503) 378-3055 EXT/55014 FAX NUMBER/(503) 364-2661

UCR CONTACT/JEFF BOCK

EMAIL/JEFFREY.D.BOCK@STATE.OR.US

DESK NUMBER/(503) 378-3055 EXT/55002

TECH SUPPORT/KEITH KOHAN

EMAIL/KEITH.KOHAN@STATE.OR.US

DESK NUMBER/(503) 378-3055 EXT/55012

SECURITY CONTACT/MICHAEL CURTIS

EMAIL/MICHAEL.S.CURTIS@STATE.OR.US

DESK NUMBER/(503) 378-3055 EXT/55004 FAX NUMBER/(503) 364-2661

ENT/1999/07/13 11:11 EMNE/PGM UDT/2007/01/11 08:13 UMNE/LE42

26.7.2.5 QUERY AGENCY FILE BY CONTACT TYPE EXAMPLE

This example requests the email addresses for Sheriff Office CJIS representatives

QAGY.OR024015Y.ORI/OR0*0000.CTYP/REP.MODE/E

Chapter 26 - LEDS Agency Files 26-24 For assistance call 503 378-5565

LEDS RESPONSE: QAGY TRANSACTION

REUR 0050 LEDS

STHOMPSON@BAKER911.ORG,

KATY.KUHNERT@CO.BENTON.OR.US,

LORIVIC@CO.CLACKAMAS.OR.US,

JPERSCHEK@CO.CLATSOP.OR.US,

WEAVERE@CO.COLUMBIA.OR.US,

ARAKOSI@CO.COOS.OR.US,

CCSO.RECORDS@PSNET.US,

METCALFR@CO.CURRY.OR.US,

DANA_WHITEHURST@CO.DESCHUTES.OR.US,

VLTHOUVE@CO.DOUGLAS.OR.US,

CFITZSIM@NCESD.K12.OR.US,

SCDEFORD@CJI.NET,

SUPER911@CO.HARNEY.OR.US,

DEEVONNA.FRASIER@CO.HOOD-RIVER.OR.US,

FISCHEGM@JACKSONCOUNTY.ORG,

APRIL.STREAM@CO.JEFFERSON.OR.US,

JEGEIGER@CO.JOSEPHINE.OR.US,

BDAILEY@CO.KLAMATH.OR.US,

CAROLYN.KEGLEY@CO.LANE.OR.US,

CMEISTER@CO.LINCOLN.OR.US,

GJENKINS@LE.LINN.OR.US,

CSMITH@MALHEURCO.ORG,

KGUSHARD@CO.MARION.OR.US,

MC911CORD@CO.MORROW.OR.US,

LEDS@MCSO.US,

GRAY.AILSA@CO.POLK.OR.US,

SCSO@SHERMAN.K12.OR.US,

KADAMS@CO.TILLAMOOK.OR.US,

KATHLEENY@CO.UMATILLA.OR.US,

CFALCK@UNION-COUNTY.ORG,

MKELSAY@CO.WALLOWA.OR.US,

MARYC@CO.WASCO.OR.US,

MELANEY_KOCH@CO.WASHINGTON.OR.US,

SHERIFF@NCESD.K12.OR.US,

SMITHS@CO.YAMHILL.OR.US,

CHARLES.J.LANG@STATE.OR.US,

PARTIAL LISTING OF QUERY

Note:- The last entry in the above example shows that data for ORI OR0SP0000 was also

captured using the wildcard. This exemplifies the requirement to use caution when running

queries with wildcards.

“Retired” agencies are excluded from both the mailing label and email address lists.

26.7.2.6 QUERY AGENCY FILE BY CITY EXAMPLE

A list of agencies located within the city of Medford is returned by this inquiry.

QAGY.OR024015Y.CITY/MEDFORD

Chapter 26 - LEDS Agency Files 26-25 For assistance call 503 378-5565

LEDS RESPONSE: QAGY TRANSACTION

LQU00170000. Dec 21, 2006 12:25:33

REUR 0017 LEDS

OR0150000 JACKSON COUNTY SHERIFF OFFICE (541) 776-7206

OR0150001 JACNET (541) 776-7190

OR0150009 SO MEDFORD - SOJIS

OR015011A CITY ATTY EAGLE POINT (541) 779-8550

OR015013A JACKSON CO DIST ATTY (541) 774-8181

ORDEA0300 DEA-MEDFORD (541) 776-4260

ORDEA03S0 DEA-MEDFORD OREGON

ORICE0200 DHS/ICE MEDFORD (541) 776-3948

ORINSMF00 IMMIGRATION NAT MEDFORD (541) 776-3948

ORINSMFS0 IMMIGRATION NATL MEDFORD

ORUSM0300 US MARSHALL MEDFORD (541) 776-4277

ORUSM03S0 US MARSHALL MEDFORD (541) 776-4277

26.7.2.7 QUERY AGENCY FILE BY GROUP

A list of agencies that are members of the UCR1 group is returned by this query.

QAGY.OR024015Y.GRP/UCR1

LEDS RESPONSE: QAGY TRANSACTION

REUR 0018 LEDS

OR0010000 BAKER COUNTY SHERIFF OFFICE (541) 776-6111

OR0010100 PD BAKER (541) 523-3644

OR0020200 PD PHILOMATH (541) 929-6911

OR0030000 CLACKAMAS COUNTY SHERIFF OFFICE (503) 655-8821

OR0030100 PD CANBY (503) 655-8911

OR0341200 PD TUALATIN (503) 629-0111

OR0350000 WHEELER COUNTY SHERIFF OFFICE (541) 384-2080

OR0360500 PD CARLTON (503) 434-6500

OR0360700 PD AMITY (503) 434-6500

OR0360800 PD YAMHILL (503) 434-6500

OR0361000 PD DUNDEE (503) 538-8321

ORDI00400 PD SILETZ TRIBAL (541) 336-5555

26.7.2.8 QUERY AGENCY FILE BY GROUP FOR LABELS ONLY

Mailing labels are generated for the UCR1 group by this query.

QAGY.OR024015Y.GRP/UCR1.MODE/L

Chapter 26 - LEDS Agency Files 26-26 For assistance call 503 378-5565

LEDS RESPONSE: QAGY TRANSACTION

REUR 0019 LEDS

OR0010000 OR0010100

BAKER COUNTY SHERIFF OFFICE PD BAKER

BAKER C0UNTY SHERIFF’S 0FFICE BAKER CITY P0LICE DEPT

3410 “K” STREET 1616 2ND ST

P 0 B0X 650

BAKER CITY, OR 97814 BAKER CITY, OR 97814-0650

OR0020200 OR0030000

PD PHILOMATH CLACKAMAS COUNTY SHERIFF OFFICE

PHIL0MATH P0LICE DEPT CLACKAMAS C0UNTY SHERIFF'S 0FFICE

P 0 B0X 400 2223 S KAEN R0AD

1010 APPLEGATE ST

PHILOMATH, OR 97370-0400 OREGON CITY, OR 97045-4080

OR0360700 OR0360800

PD AMITY PD YAMHILL

PD AMITY YAMHILL P0LICE DEPT

109A MADD0X AVE 205 S0UTH MAPLE

P0 B0X 159 P0 B0X 9

AMITY, OR 97101 YAMHILL, OR 97148

OR0361000 ORDI00400

PD DUNDEE PD SILETZ TRIBAL

NEWBERG DUNDEE POLICE DEPT SILETZ TRIBAL P0LICE

P 0 B0X 220 P0 B0X 549

620 SW 5TH

DUNDEE, OR 97115 SILETZ, OR 97380

Note:- “Retired” agencies are excluded from both the mailing label and email address lists.

26.7.4.8.1 QUERY AGENCY FILE TO PRODUCE SINGLE LABEL FOR AN AGENCY.

This produces a single “label” for the New Test Only Police Department.

QAGY.OR024015Y.ORI/OR0370400.MODE/L

LEDS RESPONSE: QAGY TRANSACTION

REUR 0153 LEDS

OR0370400

NEW TEST ONLY POLICE DEPARTMENT

PO BOX 14360

3225 STATE STREET

SALEM, OR 97309-5074

26.7.4.8.2 QUERY AGENCY FILE TO PRODUCE SINGLE LABEL FOR A CONTACT.

This produces a single “label” for the New Test Only Police Department CJIS Representative.

QAGY.OR024015Y.ORI/OR0370400.CTYP/REP.MODE/L

Chapter 26 - LEDS Agency Files 26-27 For assistance call 503 378-5565

LEDS RESPONSE: QAGY TRANSACTION

REUR 0156 LEDS

OR0370400 JOHN Q PUBLIC

NEW TEST ONLY POLICE DEPARTMENT

3225 STATE ST

PO BOX 14360

SALEM, OR 97309-5074

26.7.4.9 QUERY AGENCY FILE BY GROUP FOR EMAIL ADDRESSES ONLY

This query requests e-mail addresses for agencies that are members of the group UCR

QAGY.OR024015Y.CTYP/UCR.MODE/E

This query requests e-mail addresses for agencies that are members of the group UCR1

QAGY.OR024015Y.CTYP/UCR.GRP/UCR1.MODE/E

This query requests e-mail addresses for agencies that are members of the group UCR2 (NIBRS)

QAGY.OR024015Y.CTYP/UCR.GRP/UCR2.MODE/E

LEDS RESPONSE: QAGY TRANSACTION

REUR 0035 LEDS

311@CITYOFTOLEDO.OR

GJENKINS@LE.LINN.OR.US

PRUEF@CI.LEBANON.OR.US

THIS IS A PARTIAL LIST OF WHAT YOU’D RECEIVE BACK ON QUERY

26.7.4.10 QUERY AGENCY FILE BY GROUP TYPES

This is the query to run when a current list of the available groups is required. As the group list is

dynamic, this query should be run whenever a decision to determine to which group(s) an agency

should be added has to be made.

QAGY.OR024015Y.GRP/LIST

(Response listed on next page)

Chapter 26 - LEDS Agency Files 26-28 For assistance call 503 378-5565

LEDS RESPONSE: QAGY TRANSACTION

REUR 0022 LEDS

VALID GROUP CODES

CODE LITERAL

JAIL JAILS

LIST FULL LIST OF GROUPS

NRET AGREEMENT NOT RETURNED

NTRM NON-TERMINAL AGENCY

NVAL NCIC VALIDATIONS

PD POLICE DEPARTMENTS

SA STATE AGENCIES

SO SHERIFF OFFICES

SP STATE POLICE OFFICES

UCR FULL UCR AGENCY LIST

UCR1 LEGACY UCR AGENCY LIST

UCR2 NIBERS AGENCY LIST

UCR3 CUSTOM UCR LIST

UCR4 CUSTOM UCR LIST

US FEDERAL OFFICES, COURTS

THIS IS JUST A PARTIAL LISTING FOR DISPLAY PURPOSES ONLY

ADDITIONAL CODES MAY BE ADDED AS NEEDED

BY CONTACTING CJIS PROGRAMMING STAFF

Note:- The code to enter in the GRP field is under the CODE heading whilst a fuller description is

given under the LITERAL heading

26.7.4.11 QUERY AGENCY FILE BY NAME WITH WILDCARD - FULL SINGLE LINE

RESPONSE

This query requests a list of contacts with a first name of JAMES

QAGY.OR024015Y.CNM/JAMES*

LEDS RESPONSE: QAGY TRANSACTION

REUR 0023 LEDS

OR0020000 JAMES SWINYARD (541) 766-6858

OR002013J JAMES W BOATNER (541) 757-6828

OR0120300 JAMES WOOD (541) 820-3788

OR0070100 JAMES WILSON

OR0100300 JAMES FRESHMAN (541) 269-9192

ORVA00200 JAMES HORNER

26.7.4.13 QUERY AGENCY FILE BY COUNTY - FULL SINGLE LINE RESPONSE

This query generates a list of all agencies within the county of Washington.

QAGY.OR024015Y.CTY/34

(Response listed on next page)

Chapter 26 - LEDS Agency Files 26-29 For assistance call 503 378-5565

LEDS RESPONSE: QAGY TRANSACTION

REUR 0024 LEDS

OR0340000 WASHINGTON COUNTY SHERIFF OFFICE (503) 629-0111

OR0340001 SO WASH CO - TUALATIN

OR0340002 SO WASH CO - CORRECTIONS

OR0340100 PD BEAVERTON (503) 629-0111

OR034011A CITY ATTY BEAVERTON (503) 526-2215

OR0341200 PD TUALATIN (503) 629-0111

OR034121J MUN CRT TUALATIN (503) 692-2000

OR034CPS0 DHS CHILD PS WAS (503) 646-9722

OR034SCF0/RET SERV TO CHILDREN/FAM -34 (503) 648-8951

OR0SP1800 SP BANKS (503) 325-2231

ORJIGSAWY JIGSAW (503) 846-2530

26.7.4.13 QUERY AGENCY FILE BY TELEPHONE NUMBER WITH WILDCARD - FULL

SINGLE LINE RESPONSE

This query returns a list of telephone numbers using a wild card to replace the uncertain last digit

of the prefix.

QAGY.OR024015Y.PHN/50337*3055

LEDS RESPONSE: QAGY TRANSACTION

REUR 0162 LEDS

OR024015Y TERRY OCONNELL (503) 378-3055 EXT/55020

OR024015Y KEITH KOHAN (503) 378-3055 EXT/55012

OR024015Y MICHAEL CURTIS (503) 378-3055 EXT/55004

OR024015Y JEFF BOCK (503) 378-3055 EXT/55002

OR024015Y LEDS TRAINING UNIT (503) 378-3055 EXT/55014

26.8 MFC DIRECTORY

Unless otherwise stated all fields given below are user modifiable.

26.8.1 ADL1 ADDRESS LINE 1 - 35

MANDATORY

If the agency mailing address is a post office box then this should be entered into this field.

If CTYP is MAIN, then ADL1 cannot be deleted but it can be modified.

26.8.2 ADL2 ADDRESS LINE 2 - 35

OPTIONAL

Address line 1 must have an entry before this can be used

26.8.3 ADL3 ADDRESS LINE 3 - 35

CONDITIONAL

Chapter 26 - LEDS Agency Files 26-30 For assistance call 503 378-5565

Address line 2 must have an entry before this can be used

26.8.4 AUTH APPOINTING AUTHORITY – 20

CONDITIONAL

AUTH shall be entered only if ORF is Y. Can only be entered and/or modified by CJIS staff.

26.8.5 CCH PERMITTED ACCESS TO CCH – 1

OPTIONAL

Can only be entered and/or modified by CJIS staff

26.8.5 CITY CITY – 20

MANDATORY

Name of city where US Post Office responsible for agency’s mail delivery is located.

26.8.6 CJA CRIMINAL JUSTICE AGENCY – 1

MANDATORY

Y or N – whether or not agency is a recognized Criminal Justice Agency. Can only be entered

and/or modified by CJIS staff.

26.8.7 CMP COMPANY NAME - 40

OPTIONAL

Name of contact’s employer if different from main agency.

26.8.8 CNM CONTACT NAME – 40

MANDATORY

Name of contact.

If CTYP is MAIN, ADMI, or REP then CNM cannot be deleted and can be modified only by CJIS

staff.

Chapter 26 - LEDS Agency Files 26-31 For assistance call 503 378-5565

26.8.9 CTY COUNTY CODE – 2

MANDATORY

Code(s) for county:

“CTY” Codes for Oregon Counties

Baker 01 Douglas 10 Lake 19 Sherman 28

Benton 02 Gilliam 11 Lane 20 Tillamook 29

Clackamas 03 Grant 12 Lincoln 21 Umatilla 30

Clatsop 04 Harney 13 Linn 22 Union 31

Columbia 05 Hood River 14 Malheur 23 Wallowa 32

Coos 06 Jackson 15 Marion 24 Wasco 33

Crook 07 Jefferson 16 Morrow 25 Washington 34

Curry 08 Josephine 17 Multnomah 26 Wheeler 35

Deschutes 09 Klamath 18 Polk 27 Yamhill 36

Can only be entered and/or modified by select CJIS staff.

Wildcards are not permitted when used in inquiries.

26.8.10 CTYP CONTACT TYPE – 4

MANDATORY

Type of contact – only one contact of each type can be entered per agency.

Contact Type CTYP

Agency Administrator ADMI

CJIS (i.e. LEDS) Representative REP

Uniform Crime Reporting Contact UCR

Technical Support Contact TECH

Terminal Security Contact SEC

Base Record for Agency MAIN

26.8.11 DOC DATE OF CANCEL – 8

MANDATORY

Date format i.e. YYYYMMDD. Date entry is cancelled.

26.8.12 EML EMAIL ADDRESS - 80

OPTIONAL

Email address of contact. Only one email address per contact is accepted. As the fields within a

LEDS message are “period delimited” no periods are allowed when entering an email address.

e.g. First.Name@state.or.us Must be entered as:- First(dot)Name@state(dot)or(dot)us

26.8.13 GRP ADD TO GROUP(S) - 4

OPTIONAL

Chapter 26 - LEDS Agency Files 26-32 For assistance call 503 378-5565

Groups are a feature of the CJIS Agency File that allows agencies to be categorized to permit

easy selection based on predefined criteria.

An agency can be added to up to five groups in one message using one MFC followed by the

required GRP’s separated with periods. Currently there is no limit to the number of groups that an

agency can be a member off.

An agency can request the addition of special groups that they can administer.

A full list of the current groups can be obtained by using “GRP/LIST” within an inquiry.

Wildcards not permitted in the GRP in inquiries.

Additional codes may be added as needed by contacting CJIS programming staff.

26.8.14 HOS HOURS OF SERVICE – 20

OPTIONAL

The times that the contact is normally available.

26.8.15 III ACCESS TO INTERSTATE IDENTIFICATION INDEX – 1

MANDATORY

If ORF is Y then III must be N (no). Can only be entered and/or modified by select CJIS staff.

26.8.16 MIS MISCELLANEOUS – 200

OPTIONAL

If STA is retired (R) then MIS can only be modified by CJIS.

26.8.17 MKE MESSAGE KEY - 4

MANDATORY

Code indicating the message being processed.

26.8.18 MNE AGENCY MNEMONIC – 4

OPTIONAL

Can only be entered and/or modified by select CJIS staff.

Wildcards not permitted in inquiries.

26.8.19 MODE MODE – 1

OPTIONAL

Allows the agency file to produce either labels (L) or a list of email (E) addresses.

The /L option produces a list in two columns suitable for Avery 5161 labels or similar 1 by 4 inch

labels.

The /E option provides a comma separated list suitable for cutting and pasting into an email client

such as Groupwise.

26.8.20 ORF OREGON ISSUED ORI – 1

MANDATORY

Chapter 26 - LEDS Agency Files 26-33 For assistance call 503 378-5565

Must be either Y (for Oregon only agency) or N. Can only be entered by select CJIS staff.

26.8.21 ORI ORIGINATING AGENCY IDENTIFIER – 9

MANDATORY

Must begin with “OR.” Can only be entered and/or modified by select CJIS staff.

Wild cards (*) may be used within inquiries – a minimum of five characters must be in the field and

only one wildcard may be used.

26.8.22 PHN TELEPHONE NUMBER – 10

MANDATORY

On entry must be 10 numerals i.e. area code, prefix, and number with no hyphens or spaces.

Wild cards (*) may be used within inquiries. If a wildcard is used then a minimum of seven

characters must be given – only one wildcard may be used in any telephone number inquiry.

26.8.23 PHNX TELEPHONE EXTENSION – 5

CONDITIONAL

Can only be entered and modified with PHN.

26.8.24 PTYP TELEPHONE TYPE – 4

OPTIONAL

“Type” of telephone – only one telephone number of each type can be entered per contact. MAIN

designates the agency’s 24 hour contact telephone number which can only be entered and/or

modified by CJIS. PTYP and PHN must be entered as a set

Telephone Type PTYP

Main Agency Telephone Number MAIN

Contact’s Desk Telephone Number DESK

Facsimile Number FAX

Contact’s Cell Phone Number CELL

Contact’s Pager Number PAGE

Contact’s Home Phone Number HOME

Agency’s Toll Free Telephone Number FREE

Agency’s Telephone Number For Deaf Users TTY

26.8.25 SPA STATE POLICE AGENCY FLAG – 1

MANDATORY

Y or N – whether or not the Agency is a State Police Agency. Can only be entered and/or modified

by select CJIS staff.

Chapter 26 - LEDS Agency Files 26-34 For assistance call 503 378-5565

26.8.26 SPVR SECURITY POLICY VERSION – 5

OPTIONAL

Can only be entered and/or modified by CJIS.

Three to five numeric characters – no decimal point (or period) can be entered. The rightmost two

characters are assumed to be after the implied decimal point.

e.g. version 3.4 should be entered as 340 – this will be displayed as 3.40.

26.8.27 STA STATUS OF AGENCY – 1

OPTIONAL

Can be either active (A) or retired (R). Can only be entered and/or modified by CJIS staff.

26.8.28 STE STATE – 2

MANDATORY

United States Postal Service two letter code for state.

26.8.29 TTL TITLE OF CONTACT PERSON – 20

OPTIONAL

The title of the contact person’s job position.

26.8.30 UAR DATE USER AGREEMENT RECEIVED - 8

OPTIONAL

Date format which is YYYYMMDD. Can only be modified by CJIS staff.

26.8.31 UAS DATE USER AGREEMENT SENT - 8

OPTIONAL

Date format which is YYYYMMDD. Can only be entered and/or modified by CJIS staff.

26.8.32 VAL DATE LAST VALIDATED – 8

OPTIONAL

Date format which is YYYYMMDD.

26.8.33 XRP DELETE FROM GROUP(S) – 4

OPTIONAL

Used to remove agency from group(s). An agency can be removed from up to five groups in one

message using one MFC followed by the required GRPs separated with periods.

26.8.34 ZIP ZIP CODE – 9

MANDATORY

United States Postal Service ZIP code (or ZIP+4) for the address. Do not use a hyphen or another

character to separate the two parts of a ZIP+4 code.

Chapter 26 - LEDS Agency Files 26-35 For assistance call 503 378-5565

Source: CHPTR_26_LEDSAGCY.docx