[PDF] THE HEAD OF (SPSA) INFORMATION SERVICES, CRIMINAL JUSTICE on (OFFICE HOURS) THE SERVICE DESK SPSA on (24 HOURS)

Download THE HEAD OF (SPSA) INFORMATION SERVICES, CRIMINAL JUSTICE on (OFFICE HOURS) THE SERVICE DESK SPSA on (24 HOURS)...

ISCJIS

SUMMARY JUSTICE REFORM / ISCJIS – DATA STANDARDS UPDATE DATE – 20/04/2010

Version 1.27

WARNING THE DATA DEFINITIONS AND CODE LISTS CONTAINED WITHIN THIS MANUAL ARE THE CURRENT ISCJIS DATA STANDARDS AND THOSE AGREED FOR THE PURPOSES OF SUMMARY JUSTICE REFORM. ANY CHANGES TO THE MANUAL MUST BE APPROVED BY THE JSITS/ ISCJIS DATA STANDARDS CHANGE CONTROL GROUP. THE MANUAL IS HELD BY THE SCOTTISH POLICE SERVICE AUTHORITY (SPSA) (FORMERLY KNOWN AS SCOTTISH CRIMINAL RECORD OFFICE (SCRO)) WHO ARE RESPONSIBLE FOR ANY CHANGES. ANY AGENCY OR MANUAL HOLDER WHO RECEIVES UP-DATE INFORMATION FROM ANY SOURCE OTHER THAN SPSA SHOULD DISREGARD SUCH INFORMATION AND CONTACT: THE HEAD OF (SPSA) INFORMATION SERVICES, CRIMINAL JUSTICE on 0141 585 8321 (OFFICE HOURS) OR THE SERVICE DESK SPSA on 0141 585 8333 (24 HOURS) THIS VERSION IS EFFECTIVE FROM 21st April 2010 and will run in parallel with the existing ISCJIS data Standards until Summary Justice Reform is implemented. At that time the ISCJIS data standards will no longer be used The current version is version 1.27

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL VERSION CONTROL 1.

OWNERSHIP

This document is owned by ISCJIS and maintained by SPSA Information Services, Criminal Justice 2.

AUTHORITY TO CHANGE

Any proposed changes to the SJR/ISCJIS data standards and /or this document will be subject to acceptance by JSITS and ISCJIS Change Control Group. 3.

VERSION CONTROL VERSION

Version Version Version Version Version Version Version Version Version Version Version Version Version Version Version Version Version Version Version Version Version Version Version Version Version Version Version Version Version Version Version Version Version

0.1 0.2 0.3 0.4 0.5 1.0 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 1.10 1.11 1.12 1.13 1.14 1.15 1.16 1.17 1.18 1.19 1.20 1.21 1.22 1.23 1.24 1.25 1.26 1.27

DATE ISSUED August 2007 20/09/2007 10/10/2007 12/11/2007 30/11/2007 10/12/2007 25/01/ 2008 4/02/ 2008 10/03/ 2008 18 /04/ 2008 2/07/ 2008 4/08/ 2008 27/08/ 2008 14 /10/2008 6 /11/ 2008 6 /01/2009 26/01/ 2009 19 /03/2009 14/04/ 2009 2 /06/2009 2 /06/2009 9 /06/2009 9 /06/2009 21 /07/2009 21 /07/2009 24/11/ 2009 1/12/2009 2/02/ 2010 2 /02/ 2010 3/02/2010 22/02/2010 16/04/2010 20/4/2010

COMMENT First draft Discussed at JSITS September 2007 Discussed at JSITS October 2007 Discussed at JSITS 16 Nov 2007 SJR Data SJR Data Court Report New Aggravators Fixed Penalty Ticket JP Courts Work Offers Next of Kin Youth Courts SCRA Office type New Prison Codes New Station Codes for L&B New Modifiers /Drugs/Weapon Court Code/ Disposal/ PF Office New Station Codes for Northern New Language New Drug Ethnic Codes Aggravators Codes Mental Health./Secure Units Court Type New Diet Type Nationality Country codes SCDEA PNC Codes New PF Office Code New Drug Modifier Drug and Weapon Modifier New Drug Modifier New Diet Type

CHARGE CODES

Charge code email address [emailprotected] Charge Code telephone Fax number ‘CHARGE CODES’ ON 0131 226 0801 The protocol for issue of new charge codes is at Annex 5 5.

OWNERSHIP

Data Standards It is important to establish the ownership of any data standard within the 5.1 criminal justice system in order that, in the event of extending code-lists or any other problems with the standard, the agency with the authority or right to change the standard is identified. 5.2 Throughout the manual, ownership of each standard has been attributed to one or more agencies. 5.3 Where one agency has been designated owner of the standard, then any changes can only be made by that agency, any requests for changes must be made to that agency. 5.4 Where two agencies have been designated as having joint ownership, then any change must be made only after both agencies have consulted together. The most common example of this is joint ownership by Crown Office and Scottish Court Service. Both agencies wish to record, for example, diet type, and so any change to the code list would affect both of them equally. 5.5 Where the ownership is designated as being common, then the standard is one which is used by all the agencies, for example, name and address standards. Any change will affect all the agencies equally, and therefore no decision to change the standard should be taken without consultation with, and agreement of, all the agencies. Data entities It is important to establish the ownership of any data entity within the 5.6 criminal justice system in order that, at any point in the criminal justice procedure, the agency currently responsible for the accuracy of the data is defined. There are two models of data ownership - 'originator ownership' and 'final ownership'. 5.7 The entity ownership model (Appendix D of the ISE Project report) documented the ownership of data throughout the criminal justice system and is a 'final ownership' model.

The Ownership Table maps out the major data entities identified within the SCJS and traces their passage from entering the system to final ownership. It is acknowledged that in almost all instances, agencies will retain a reference copy of the information for internal use. This copy cannot, in most cases, be altered or amended, as to do so would cause confusion, endanger the integrity of the criminal justice system and could be unfair to the accused.

5.8 In the Ownership Table, 'final ownership' has been attributed to the agency which maintains the data entity in its final format and to whom updating or amending information would pass within the proposed system. For example, ACCUSED DETAILS would ultimately be the property of SPSA as updates regarding future pending cases, changes of address, physical appearance, conviction, wanted/missing information etc. would be passed there from other agencies, although they themselves may keep the updated information for internal reference purposes. 5.9 The table identifies the data entity, the agency which gathers the information initially and any subsequent transfers of ownership prior to the entity's final destination and ownership. The last column identifies the data store (which in most cases will be a document) in which the entity is found. 5.10 The 'originator ownership' model is that favoured by the PHOENIX standards team. In this model, responsibility for the accuracy of the information contained in the data entity remains with the agency/person who originated the information. 5.11 In this model, the question arises -'who is responsible for maintaining the accuracy of the record?' In many cases, the Reporting Officer is responsible for entering the information onto the system initially, but over the space of time during which the record is live, parts of the information may change. The accused may change address or name. It would be unfair to expect the Reporting Officer to be responsible for updating the record, in some cases long after the initial entries were made. Such responsibility must pass to other agencies further along the criminal justice system. At issue is the point at which the Reporting Officer's responsibility ceases and, for example, the fiscal's begins. 5.12 At this point, the two models overlap. The issue has not been resolved because of the underlying uncertainty of the future dataflow.

SCJS DATA ENTITIES - OWNERSHIP TABLE ENTITY INITIAL > 1st Case details Police >

OWNERSHIP 2nd > >

COMMENTS FINAL P.F.

P.F Police P.F. Police Reporter

> SPSA Police > P.F.

Court

P.F > >

Reporter Court

Police Report, Statements Complaint Pending Case Copy Complaint Police Report

Evidence Productions

“ “

Police

P.F.

Reporting Officer

“>

Police

Reporter

P.F.

Production Schedule

Police Police

P.F PF/Reporter

Court/P.F >

Police Police

Police Report Police Report, Disposals

Accused details

Police

P.F.

Court

SPSA

Police P.F

SPSA Police

P.F

Court Prisons Prisons Police Reporter

SWSG SWSG Police Reporter Police

SPSA Hearing >

Police Report, Complaint Pending Case Citation, Copy Complaint Disposals Releases Releases, Parole Police report Disposal

Supervisory Officer “ Case Documents “

Reporter SPSA

Police Reports, Statements Police Reports, Statements

ENTITY

Charge details

Witness details

Previous Convictions

Hearing/Appearance

INITIAL Reporter Police

1st > P.F. P.F.

OWNERSHIP 2nd > Court Court

COMMENTS FINAL SPSA SPSA

Police P.F. Court Police Reporter Reporter

SPSA Police P.F. Reporter Police P.F.

P.F. Police Hearing > Court

Reporter SPSA SPSA

Police

P.F.

Police P.F Police

Agent Police >

P.F. >

Reporter

P.F.

SPSA P.F. SPSA

P.F. Accused Reporter

SPSA

P.F. P.F.

>Accused

Court

P.F. Reporter Reporter

Police Offender Police

Disposal Police Report, Complaint, Disposals Pending Case Copy Complaint Warrant Police report Disposal Disposal Police Report, Statements Precognition Citation Police report, Statements Police report, Statements Proposed direct link Copy Complaint

Court List, Complaint Copy Complaint, Citation Citation Referral Citation

ENTITY >

1st > SLAB

OWNERSHIP 2nd > Court

COMMENTS

Legal Aid Application

INITIAL Agent

FINAL SLAB

Legal Aid Application

Bail Order / Recall

Court

P.F.

SPSA

Disposal

Warrant

Court

P.F.

Police

Court

Police

Court

Police

Prison

L.A.

Police

Reporter

Apprehension Warrants Non payment/Non Appear. --->FEC) Extract Conviction warrant L.A. Warrant

Background Report

SWSG SWSG

> >

Court Reporter

Financial Penalty

Court Court

> P.F

> SPSA

Court Court

Sentence Disposal

Community Serv. Order

Court

SWSG

Sentence

Court

P.F

SPSA

Attendance Order

Court Court

> P.F.

> SPSA

SWSG

Sentence Disposal

Probation Order

Court Court

> P.F.

> SPSA

SWSG

Sentence Disposal

Custody Order

Court Court

Police P.F.

> SPSA

Prisons

Sentence Disposal

Disposal

ENTITY INITIAL

Discharge

1st

OWNERSHIP 2nd >

COMMENTS FINAL

Court Court

> P.F.

> >

Court SPSA

Sentence Disposal

Prisons Prisons

SWSG >

SPSA

Release Order Release Order

Appeal

Agent

Court

P.F

Court

Disposal

Juror

Court

Jury List

Not Guilty Not Proven Admonished Release

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS

Added XML TAG-NAME column to data standards index table To assist in locating the correct XML tag for a given data item or application of a data standard, an additional column has been added to the Data Standards index table indicating the most appropriate XML tag to use when exchanging a given piece of data. This new column has been filled with the tag-names relating to the new and modified entries to the index that have been added in this update to the data standard manual which are based on changes made to the “SPR” XML schema documents. When future updates are made to this document based on the XML schemas from other contributing bodies, it is anticipated that the updaters in each case can add in the appropriate tags corresponding to the data standards that their schemas own or contribute towards.

Table of Contents Ownership Authority to Change Version Control Charge Codes Ownership SCJS Data Entities – Ownership table XML Tag Names Table of Contents Index of Data Items defined in SPR2 XML Schema Introduction Users Guide Standards Accused Status Address Address Type Admit Age Alcohol Level Alphanumeric Agency Codes/Agency Reference Background Bail – Additional Conditions Bail reason Case Category Charge Number (Within the Complaint) Compensation Consecutive Accused Number (Within the Complaint) Court Court Codes – High Courts Court Codes – Sheriff Courts Court Codes – District Courts Court Codes – Unified JP (Justice of Peace) Courts

Court Types Crime/Offence Reference Number Date Death Contact Type Diet Type Diet Type Codes – High Court Diet Type Codes – Summary Complaints Diet Type Codes – Petition Diet Type Codes – Indictment Diet Type Codes – Other Disposal Disposal codes Document Type Duration DVLA Driver Number Email Address Ethnicity Evidence Type Fixed Penalty Notice Offence Code Fixed Penalty Ticket Number Forenames(s) Gender Language Legal Aid Number Local Authority Local Authority Codes Means to pay Mental Health Establishments Money National ID Number Nationality Numeric Occupation Codes Health occupations Education Occupations Social Work Occupations Government Occupations Industry/Commerce Occupations Occupation Text Offence Code Offence Aggravation Offence Modifier Notification Type Organisation Name/Company Name Personal Title Pleas Pleas Method Police Force/ Station Codes Police Force Codes Police Station Codes Police Station Codes Police Station Codes Police Station Codes Police Station Codes Police Station Codes Police Station Codes

– – – – – – –

British Transport Police Dumfries & Galloway Fife Constabuary Grampian Lothian & Borders Northern Strathclyde Police

Police Station Codes – Tayside Police Police Officer Rank Codes Postcode Prejudice Incident Previous Convictions Previous Juvenile Warning Prison Prisoner Absence/Movement Reasons Prison Codes Prison Codes – IBIS & Phoenix Procurator Fiscal Procuarator Fiscal Codes Procuarator Fiscal Reference Number Production Type (As used in COPFS System) Reporting Officer Rescheduled Reason Responsible Person Type Result Secure units Sent To Sentence Type Shoulder Number Substance Subject Reference Number Subject Status Surname Telephone Number Text Time Vehicle Registration Mark Verdict Vulnerability Vulnerability Specific Type (VST) Witness Number Witness Type Work Order Type Yes/No Flag Appendices Annex 1 - Court Result Data Exchange Court Data Coplink Files Sent from SCS Record Record Record Record Record

1 2 3 4 7

– – – – –

Court Details Charge Details Sentence Type Scheduled Court Appearance Record Data from Court Bail Details

Court Data Coplink File Sent from COPFS Record 0 – Header File Record 1 – Case Details SCRO Extract – Scheduled Court Appearance Record 2 – Accused Details SCRO Extract – Accused Details

Record 3 – Charge Details SCRO Extract – Charge Details Record 9 – End of file Roll Up Information Sent to SCRO NoPro Information Sent to SCRO Annex 2 - Direct Measures Data Standards Non-Court file from COPFS (data flow number 2) Record 0 – Header file Record 4 – Accused Details SCRO Extract Record 5 – Payment Record SCRO Extract New Record 5a – Penalty Record Record 6 – Charge Details SCRO Extract Record 9 – End of File Non-Court file to COPFS and SCRO (data flow number 3) Record 0 – Header File Record 5 – Charge Details Record 9 – End of File Change of Address Details (data flow number 6) Record 0 – Header File Record 6a Record 9 – End of File Work Offer Extract from COPFS (data flow number 7) Record 0 – header File Record 4 – Accused Details SCRO Extract Record 7a – Work Offer Record Record 6 – Charge Details Record 9 – End of File Work Offer Suitability (data flow number 8) Record 0 – header File Record 8a – Work Offer suitability Record 9 – End of File Work Order Update (data flow number 9) Record 0 – Header File Record 9a – Work Offer Update Record 9– End of File Conditional offer to Court (data flow number 10) Police to Court Header Record Police to Court Detail Record

Conditional Offer from Court (data flow number 11) Court to Police Header Record Court to Police Detail Record Cancel/Amend Undertaking Record/Conditions Record 0 – CX006 Header File Record 10 – CX035 Remove /Amend Undertaking Conditions Record 9 – CX013 End of File Annex 3 - XML SCHEMA Definition Files ASBO – Example of Police CO Fixed Penalty (ASBO) from Court to Police Direct Measures – Court to Police Direct Measures – Police to Court Annex 4 - Direct Measures Naming Conventions Direct Measure Interface Files Fiscal Accounts Incoming Interface Files Fiscal Outgoing Notification Interface Files Police Accounts Incoming Interface Files Police Outgoing Notification Interface Files Fiscal Fine Letters Incoming Interface Files Direct Measures – Fiscal Fine Letter – COPFS to SCS Annex 5 - Protocol for Issue of New Charge Codes and Styles Annex 6 - Format of data files Annex 7 - Protocol for file names for Passing between CJOs Annex 8 - File naming Convention for Charge Code Updates Annex 9 - Development of Document Headers for Return Data to ISCJIS Partners Annex 10 - Individual Mail to the Police Annex 11 – Offence Aggravations Combination Codes Annex 12 - SPR2 Schemas – Separate document on ISCJIS Website

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS INDEX OF DATA ITEMS DEFINED IN SPR2 XML SCHEMA DATA ITEM Top Level Agency Reference Category SPR Document Type Prejudice Incident Date of first Offence Recipient of Report Accused Details SCRO Number Accused Number National Identity Number Forename Surname Alias Forename Alias Surname Date of Birth Age Place of Birth Driver Number Occupation Code Occupation Gender Status Ethnicity Sex Offenders Register OLR Recommendation Juvenile Section Bail Opinion Additional needs Work Order Juvenile Section PF Referral Reason Responsible Person Forename Responsible Person Surname Responsible Person Address BS Address Structure SAON PAON Street Description Unique Street Reference number Locality Town Administrative Area Post Code Unique Property Reference Number JLO Recommendation General Attitude Position in Family

XML TAG NAME

ISCJISCore:Agency reference ISCJISCore:CategoryType ISCJISCore:DocType ISCJISCore:Yes/NoType ISCJIS:DoFo ISCJISCore:SentToType ISCJISCore:SCRONoType ISCJISCore:AccusedNoType ISCJISCore:NationalIDNo ISCJISCore:ForenameType ISCJISCore:SurnameType ISCJISCore:ForenameType ISCJISCore:SurnameType ISCJISCore:DOBType ISCJISCore:AgeType ISCJISCore:PlaceOfBirthType ISCJISCore:DriverNoType ISCJISCore:OccType ISCJISCore:OccupationType ISCJISCore:GenderType ISCJISCore:StatusType ISCJISCore:EthnicityType ISCJISCore:Yes/NoType ISCJISCore:Yes/NoType ISCJISCore:JUVSectionType ISCJISCore:String600Type ISCJISCore:String500Type ISCJISCore:String600Type ISCJISCore:PFReferralReason ISCJISCore:ResponsiblePersonForename ISCJISCore:ResponsiblePersonSurname

ISCJISCore:JLORecommendation ISCJISCore:AttitudeType ISCJISCore:PositionInfamily

Home Condition Previous Juvenile Warning Previous Juvenile Know Previous Family Knowledge Behaviour School Substance Abuse Domestic Abuse Type Location of Domestic Abuse Incident Perpetrator of Domestic Abuse Juvenile Present at DA Incident Other Agencies Involved Victim Advice Victim Injuries Charge Details Type Content Incident Number Charge Code Modifier Known Date PropertyValue Recovered Amount Loss Amount Compensation Required Charged Accused Type SCRO Number Aggravation Code Admit Caution date Forename Surname Victim Organisation Charge Variable Type Variable Name Variable Text Offence date Produtions Type Case Production Number Type Description Location Agency Register Number Owner Remarks Case Related Documents Photograph Officer Type Forename Surname Officer Agency Officer unique Number Shoulder number Rank Station Code

ISCJISCore:HomeCondition ISCJISCore:PrevJuvWarnType ISCJISCore:PrevJuvKnow ISCJISCore:PrevFamKnow ISCJISCore:CoreBehaviourType ISCJISCore:SchoolType ISCJISCore:SubstanceType ISCJISCore:DALocType ISCJISCore:DAPerpType ISCJISCore:Yes/NoType ISCJISCore:Other Agencies ISCJISCore:VictimAdvice ISCJISCore:VictimInjuries ISCJISCore:AgencyReference ISCJISCore:ChargeCode ISCJISCore:ModifierType xsd:date ISCJISCore:Compensation ISCJISCore:Compensation ISCJISCore:Compensation ISCJISCore:YesNoType ISCJISCore:SCRONoType ISCJISCore:allowedAggravation ISCJISCore:AdmitType xsd:Date ISCJISCore:ForenameType ISCJISCore:SurnameType ISCJISCore:CompanyType ISCJISCore:VariableNameType ISCJISCore:PopulatedString xsd:date ISCJISCore:ItemNumberType ISCJISCore:ProductionType ISCJISCore:String600Type ISCJISCore:String100Type ISCJISCore:String50Type ISCJISCore:String500Type ISCJISCore:String100Type ISCJISCore:CDATAType ISCJISCore:Yes/NoType ISCJISCore:ForenameType ISCJISCore:SurnameType ISCJISCore:OfficerAgencyType ISCJISCore:OfficerUniqueReferenceNumber Ttype ISCJISCore:Shouldernumbertype ISCJISCore:RankType ISCJISCore:DivisionType

EMail Police Witness Type SCRO Number Witness Number Forenames Surname Date of involvement Ethnicity Shoulder Number Officer Agency Officer Unique Reference Number Rank Station Code Email Family Liaison Officer Additional Needs Civilian Witness Witness Number Witness SCRO number Forenames Surname Alias Forenames Alias Surname National ID number Ethnicity Occupation Code Date of Birth Age Vulnerability Category Vulnerability Specific Gender Responsible Person Number Hostile Witness Flag Additional Needs Contact Details Address Telephone Number Mobile Number Email Contact By Email Local Division BS Address Structure SAON PAON Street Description Unique Street Reference number Locality Town Administrative Area Post Code Unique Property Reference Number Prejudice Incident Type Prejudice Incident Type Background

ISCJISCore:EmailType ISCJISCore:SCRONoType ISCJISCore:ItemNumberType ISCJISCore:ForenameType ISCJISCore:SurnameType xsd:date ISCJISCore:EthnicityType ISCJISCore:ShoulderNo ISCJISCore:OfficerAgencyType ISCJISCore:Officeruniquereferencenumbert ype ISCJISCore:RankType ISCJISCore:DivisionType ISCJISCore:EmailType ISCJISCore:Yes/NoType ISCJISCore:String500Type ISCJISCore:ItemNumberType ISCJISCore:SCRONoType ISCJISCore:ForenameType ISCJISCore:SurnameType ISCJISCore:ForenameType ISCJISCore:SurnameType ISCJISCore:CDATAType ISCJISCore:Ethnicity Type ISCJISCore:OccType ISCJISCore:DOBType ISCJISCore:AgeType ISCJISCore:KnownVulnerabilityType ISCJISCore:KnownVulnerabilityType ISCJISCore:GenderType ISCJISCore:ItemNumberType ISCJISCore:Yes/NoType ISCJISCore:String500Type ISCJISCore:AddressType ISCJISCore:TelephoneType ISCJISCore:telephoneType ISCJISCore:EmailType ISCJISCore:Yes/NoType ISCJISCore:DivisionType

ISCJISCore:StringAlphaNumeric ISCJISCore: StringAlphaNumeric

Impact Complainer Complainer Family Complainer Community Complainer Property Prejudice Incident Details Prejudice Flag Prejudice Incident Type Background Impact Complainer Complainer Family Complainer Community Complainer Property Interpreter Flag Language Interpreter Flag II Date of Involvement Date Involvement Responsible person Civilian Witness Details Witness Civilian Code Witness Occupation Witness professional Code Recommendation Details Recommend Bail Bail Reason Code Description English Previous Convictions Obtained NI Previous Convictions Obtained Euro Previous Convictions Obtained Liberation on Undertakings Date of Appearance Time of Appearance Court ID Supervising Officer Standard Conditions Special Conditions Officer Notes Report Submitted Accused Company Type Company Name Representative Forename Representative Surname Position in Company Means to Pay Means to pay rating Means to pay Note

ISCJISCore:String500Type ISCJISCore: String500Type ISCJISCore: String500Type ISCJISCore: String500Type ISCJISCore:YesType ISCJISCore:StringAlphaNumeric ISCJISCore: StringAlphaNumeric ISCJISCore:String500Type ISCJISCore: String500Type ISCJISCore: String500Type ISCJISCore: String500Type ISCJISCore:YesType ISCJISCore:LanguageType ISCJISCore:NoType Xsd:date ISCJISCore:ResonsiblePerson ISCJISCore:CivilianCodeType ISCJISCore:OccupationType ISCJISCore:ProfessionalCode ISCJISCore:Yes/NoType ISCJISCore:ReasonCodeType ISCJISCore:String600Type ISCJISCore:Yes/NoType ISCJISCore:Yes/NoType ISCJISCore:Yes/NoType Xsd:date Xsd:time ISCJISCore:CourtIDType SPR:OfficerType ISCJISCore:Yes/NoType ISCJISCore:String600Type ISCJISCore:String600Type ISCJISCore:Yes/NoType ISCJISCore:CompanyType ISCJISCore:ForenameType ISCJISCore:SurnameType ISCJISCore:String100Type ISCJISCore:StringAlphaNumeric ISCJISCore:String600Type

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS INTRODUCTION 1. The first version of the ISCJIS Data Standards Manual was developed and released in March 1994. The purpose of the Data Standards Manual was to facilitate the exchange and sharing of information, not to impose a uniform system throughout the Scottish Criminal Justice Organisations (SCJOs). 2. Since the Data Standards Manual was developed in March 1994, it became apparent that to improve information interchange between SCJOs more than common data standards were required. From this recognition, the Integration of Scottish Criminal Justice Information Systems (ISCJIS) programme was established to develop a methodology that would enhance the interchange of data by developing common (between SCJOs) tracking systems. This revision to the Data Standards Manual included the new data elements that establish the format of these tracking numbering systems. DEFINITIONS 3. Formats and codes for data items are a fundamental part of a computerised system. The ISCJIS data standards are for the EXCHANGE and SHARING of information BETWEEN agencies. Provided information is passed to the ISCJIS STANDARD the wider interests of ISCJIS will be met. Whether they are used for all purposes within agencies is a matter for each agency, not for ISCJIS. USER'S GUIDE 4. A list of Standards for the format and content of each individual data item follows. The adoption of these standards by all ISCJIS SCJOs makes it easier not only to exchange and share data, but to track information between one agency and another. 5. Code lists will remain the responsibility of the originating agency, which has been identified as OWNER in the description of the standard, although any changes will be subject to the ISCJIS change control procedure (see para 2 (Authority to Change) for details of ISCJIS change control procedure). 6. Where the owner of a data standard is described as COMMON this indicates that two or more SCJOs own/use the data standard. 7. As each ISCJIS agency uses their own internal numbering system the ISCJIS 'Tracking Number' was established to facilitate the cross-referencing of data between the various computer systems. The 'Tracking Number' consists of 4 separate ISCJIS data standards; namely:1 2 3 4

S Number Agency Reference Number Procurator Fiscal's Complaint Number Procurator Fiscal's Charge Number, within the Complaint

8. It has been agreed that all accused details passed by ISCJIS reporting agencies will have an associated ‘S’ Number . 9. Annex 11 refers to the agreed format of the revised Standard Prosecution Report 2 (SPR2) that details the structure and layout for the electronic interchange of data. This is a separate document on the ISCJIS website.

. LAYOUT 11.

The layout of each standard is the same structure:Definition of the data which the standard formats The data items to which the standard relates The permissible character set. The range/values The ownership of the standard XML Tag-Name The codes to be used in the standard

12. Each standard is on a separate page, and the relevant codes, if extensive, are also on separate pages, for ease of updating. Owing to the sheer volume of Charge Codes the individual codes are not shown within this document. These codes will be supplied in an electronic form, by Crown Office who will maintain these codes on behalf of ISCJIS. The charge codes are published on the ISCJIS website – www.iscjis.gov.uk

ACCUSED STATUS

DEFINITION:

The current status of the accused.

DATA ITEMS:

Accused Status.

PERMISSIBLE CHARACTER SET: Restricted below.

alphanumeric

code,

see

table

RANGES/VALUES:

Single characters from the code-table below

XML TAG-NAME:

ISCJIS Core: StatusType

PRIMARY OWNERSHIP:

Common.

CODES: Custody Report Undertaking Warrant

ADDRESS

C R U W

DEFINITION:

The address of the relevant person, firm, organisation or event.

DATA ITEMS:

Accused Address Civilian Witness Address Detention Address Local Authority Address Responsible Person Address Witness Address

PERMISSIBLE CHARACTER SET: Controlled by Schema. If flat numbers are used then a – (hyphen) should be used instead of a / (forward slash) RANGES/VALUES: An address can be defined in two forms: either using the following set of value ranges OR conforming to the separate BS7666 standard. PRIMARY OWNERSHIP:

Common.

Address value ranges: An address must be compliant with BSB7666 standard An address must also have a postcode which may be either a conformant “BS7666 postcode” or a so-called partial postcode that is defined as: One or two characters in the A-Z range followed by… One character from the range 0-9 or R followed by… One or more characters from the 0-9 or A-Z ranges. For no fixed abode – retain the current practice of inserting ‘no fixed abode’ across the three mandatory lines, e.g. No fixed abode The DISC address must exist for both the accused and civilian witnesses.

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL STANDARD ADDRESS TYPES

DEFINITION:

A coded item used to identify the type of addresses being submitted to the Procurator Fiscal..

DATA ITEMS:

Accused Address Civilian Witness Address Detention Address Local Authority Address Witness Address Responsible Person Address

PERMISSIBLE CHARACTER SET: Agreed code list. RANGES/VALUES: XML TAG-NAME: PRIMARY OWNERSHIP:

4 character code. ISCJISCore: AddressType COPFS.

CODES: CODE B CBAD CITE C CONV H POSA OLD WTNI DISC NEW

DESCRIPTION Business address Custody/bail address Cite address Care of police Conversion Home address Place of safety Previous address Witness intimation address Disclosable address Used to indicate an updated address from that previously submitted (Needed so the Subject report can update an existing address)

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL STANDARDS ADMIT DEFINITION:

Comment on any responsibility/guilt

DATA ITEMS:

Crime/Offence Admitted

PERMISSIBLE CHARACTER SET: Restricted below. RANGES/VALUES:

acknowledgement

alphanumeric

code,

see

table

Single characters from the code-table below

XML TAG-NAME:

ISCJISCore:AdmitType

PRIMARY OWNERSHIP:

Common.

CODES: Accept Deny Not Applicable

A D N

AGE DEFINITION:

The age of an individual at a specific point.

DATA ITEMS:

Civilian Witness Age. Accused Age

PERMISSIBLE CHARACTER SET: Alphanumeric. RANGES/VALUES:

N/K or a numeric value. (1-120)

XML TAG-NAME:

ISCJIS Core:AgeType

PRIMARY OWNERSHIP:

Common.

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS ALCOHOL LEVEL DEFINITION:

The level of alcohol measured on the subject in question.

DATA ITEMS:

Alcohol Level.

PERMISSIBLE CHARACTER SET:

Numeric only.

RANGES/VALUES:

The field is 4 characters long. The first character indicates the measurement was of blood, breath or urine. The following three characters show the Alcohol level and give the exact measurement in micrograms of alcohol per 100ml of blood, breath or urine.

OWNERSHIP:

Scottish Court Service.

CODES:

Single letter (A, B or C) followed by 3 digits.

ALPHANUMERIC DEFINITION:

Used for simple alphanumeric fields.

PERMISSIBLE CHARACTER SET:

Alphanumeric.

RANGES/VALUES:

Field length is given in the index entry for a respective data item. eg: “ALPHANUMERIC (500)” would represent a text field that is a maximum of 500 characters in length. This definition carries an implied minimum length of zero characters. If a field has a non-zero minimum length, then the field length range is given instead, ie; “ALPHANUMERIC (1-500)” for example.

PRIMARY OWNERSHIP:

Common

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS

AGENCY CODES/AGENCY REFERENCE DEFINITION:

Agencies who may report cases to the Procurator Fiscal or prosecute cases in court.

DATA ITEMS:

Agency code

PERMISSIBLE CHARACTER SET:

Agreed code list

RANGES/VALUES:

3 characters –the middle character identifies the police force the agency updates the CHS (Criminal History System) through.

XML TAG-NAME:

ISCJISCore: AgencyReference

PRIMARY OWNERSHIP:

Common.

EXAMPLE: GLV - the Vehicle Inspectorate reporting to Lothian & Borders Police GTV –the Vehicle Inspectorate reporting to Tayside Police. ZLY – HM Revenue & Customs reporting to Lothian & Borders Police ZCY – HM Revenue & Customs reporting to Central Scotland Police These codes are displayed within a separate Excel spreadsheet on the ISCJIS web site. BACKGROUND DEFINITION:

A coded item used to identify the type of background relating to prejudice information..

DATA ITEMS:

Background

PERMISSIBLE CHARACTER SET:

Upper case alpha only.

RANGES/VALUES:

The field is 4 characters long

XML TAG-NAME:

ISCJIS Core: String AlphaNum4Type

PRIMARY OWNERSHIP:

COPFS

CODES: Code

Description

ASUB

Accused, SPR submitted to PF

WSUB

Witness, SPR submitted to PF

LSUB

Location, SPR submitted to PF

CSUB

Combination, SPR submitted to PF

ANUB

Accused, SPR not submitted to PF

WNUB

Witness, SPR not submitted to PF

LNUB

Location, SPR not submitted to PF

CNUB

Combination, SPR not submitted to PF

NREC

No record of previous prejudice incident.

UNRS

Unknown at report submission( Custody Only)

NSPR

Previous reported case prejudice incident – No SPR

SPRP

Previous reported prejudice incident – SPR submitted to PF

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS BAIL – ADDITIONAL CONDITIONS DEFINITION:

The conditions of bail imposed by a court in addition to the standard conditions.

DATA ITEMS:

Pending Case Bail Details. Bail Conditions.

PERMISSIBLE CHARACTER SET:

Alphanumeric.

RANGES/VALUES:

The field is 500 characters long.

PRIMARY OWNERSHIP:

Scottish Court Service

BAIL REASON DEFINITION:

A coded item used to identify the type of Bail Reasons being submitted to the Procurator Fiscal.

DATA ITEMS:

Bail Reason

PERMISSIBLE CHARACTER SET:

Numeric 1 to 8

RANGES/VALUES:

The field is 2 characters long

XML TAG-NAME: PRIMARY OWNERSHIP:

ISCJISCore:ReasonCodeType COPFS

CODES: CODE

Description

Any reason to believe that the accused would fail to appear?

Believe acc would interfere with administration of justice?

Any reason to believe the accused is likely to re-offend?

Reason to believe accused is likely to cause public disorder

Information accused is subject to a bail or court order?

Any information to suggest accused should be remanded?

Information that special conditions should be appropriate?

Reporting officers bail opinion

CASE CATEGORY DEFINITION:

A coded item used to identify the type of report being submitted to the Procurator Fiscal.

DATA ITEMS:

Case Category

PERMISSIBLE CHARACTER SET:

Upper case alpha only.

RANGES/VALUES:

The field is 4 characters long

PRIMARY OWNERSHIP:

Crown Office/SCRA

CODES:Category

Code

Breach of order Camera Fixed Penalty Defaults Camera Offences (Non-Fixed Penalty) Case Against a Police Officer

BR CD CO CM

Case Against Prison Officer Common Law Consumer protection Conversion Death Declined Adult Warning Declined Fixed Penalty Driver Improvement Scheme Extradition Order FAI/Public Inq Fire Foreign Precognition Miscellaneous Occurrence Report – (Moorov) Occurrence Report (Advice Direction) Outside tapes Parking Penalty Declined Police Fixed Penalty Defaults (NonCamera) Racial Indicator Road Traffic (ex speeding/parking) Speeding Statutory (except traffic) Ultimus Haeres Vehicle Excises Wireless Telegraphy

and

CW CL CP CC DE DA DF DS ED DI FI FP MI OR AD OT PA PD FD RI RT SP ST UH VE WY

CHARGE NUMBER (WITHIN THE COMPLAINT) DEFINITION:

The consecutive number which corresponds to a particular charge libelled in a copy complaint or indictment.

DATA ITEMS:

Charge Number (within the complaint)

PERMISSIBLE CHARACTER SET:

Numeric only.

RANGES/VALUES:

The field is 3 characters long.

XML TAG-NAME: PRIMARY OWNERSHIP:

Crown Office

COMPENSATION DEFINITION:

A coded item used to identify the type of Compensation being submitted to the Procurator Fiscal..

DATA ITEMS:

Compensation

PERMISSIBLE CHARACTER SET:

Upper case alpha only.

RANGES/VALUES:

The field is 4 characters long

XML TAG-NAME: PRIMARY OWNERSHIP:

ISCJISCore:Compensation COPFS

CODES: CODE

Description

LOSS IAAD

LOSS OR DAMAGE INJURY, ALARM AND DISTRESS

CONSECUTIVE ACCUSED NUMBER (WITHIN THE COMPLAINT) DEFINITION:

The consecutive number which corresponds to an accused person, named individually or along with other accused persons, in a copy complaint or indictment.

DATA ITEMS:

Charge Number (within Civilian Witness SCR Number

PERMISSIBLE CHARACTER SET:

Numeric only.

RANGES/VALUES:

The field is 3 characters long.

XML TAG-NAME:

the

complaint)

PRIMARY OWNERSHIP:

Crown Office

COURT

DEFINITION:

The court at which a case is heard or a warrant raised.

DATA ITEMS:

Conviction - Place of Court Original Court

PERMISSIBLE CHARACTER SET: RANGES/VALUES:

XML TAG-NAME:

Alphanumeric The field is 5 characters long. The first 4 characters will be numeric followed by a nonmandatory alpha- character containing the court identifier. The court identifiers will be: A High Court Lawnmarket B High Court Parliament House H High Court Aberdeen Annex Y Youth Court ISCJIS Core: Court ID Type

PRIMARY OWNERSHIP:

Scottish Court Service

CODES:

See next page.

COURT CODES - HIGH COURTS

Code 0901 0901A 0901B 0902 0903 0904 0905 0906 0907 0908 0909 0910 0911 0912 0913 0914 0915 0916 0917 0918 0919 0920 0921 0922 0923 0924 0925

Court Edinburgh Edinburgh Lawnmarket Edinburgh Judiciary Glasgow Stirling Oban Airdrie Alloa Arbroath Banff Campbeltown Cupar Jedburgh Dumfries Ayr Dingwall Dornoch Dumbarton Dunfermline Dunoon Duns Elgin Aberdeen Inverness Perth Dundee Forfar

0926 0927 0928 0929 0930 0931 0932 0933 0934 0935 0936 0937 0938 0939 0940 0941 0942 0943 0944 0945 0946 0947 0948 0949 0950 PRVY

Fort William Greenock Haddington Hamilton Kilmarnock Kirkcaldy Kirkcudbright Kirkwall Lanark Lerwick Linlithgow Lochmaddy Falkirk Paisley Peebles Peterhead Portree Rothesay Selkirk Stonehaven Stornoway Stranraer Tain Wick Livingston Privy Council

COURT CODES - SHERIFF COURTS

Code 9701 9701H 9702 9702Y 9703 9704 9705 9711 9716 9717 9721 9722 9723 9724 9726 9727 9728 9729 9730 9741 9742 9751 9752 9753 9761 9762 9771 9772 9772Y 9781 9791 9801 9803 9804 9805 9811 9812 9813 9814 9815 9841 9851 9852 9853 9854 9855 9861 9871 9872 9873

Court Aberdeen Aberdeen Annexe Airdrie Youth Court Airdrie Alloa Ayr Arbroath Banff Campbeltown Cupar Dingwall Dornoch Dumbarton Dumfries Dundee Dunfermline Dunoon Duns Lochgilphead Edinburgh Elgin Falkirk Forfar Fort William Glasgow & Strathkelvin Greenock Haddington Hamilton Youth Court Hamilton Inverness Jedburgh Kilmarnock Kirkcaldy Kirkcudbright Kirkwall Lanark Lerwick Linlithgow Lochmaddy Livingston Oban Paisley Peebles Perth Peterhead Portree Rothesay Selkirk Stirling Stonehaven

9874 9875 9881 9891

Stornoway Stranraer Tain Wick

COURT CODES - DISTRICT COURTS and JP COURTS District Court Code

New JP Court Code

Local Authority and Court

See Note** Below

9400 9405 9406 9407 9408 9409 9415 9416 9417 9425 9426 9427 9428 9429 9430 9431 9440 9445 9446 9447 9448 9449 9450 9451 9456 9460 9461 9465 9466 9470 9474 9478 9482 9485 9486 9487 9495 9500 9501 9502 9503 9504

9251 9252 Closing 9253 9254 9263 9264 9289 9290 9291 9292 9293 9294 9240 9245 9246 9247 9248 9250 9256 9260 9261 9265 9266 9270 9274 9278 9282 9285 9286 9287 9295 9343 9344 9345 9346 Closing

Aberdeen City Aberdeenshire: Banff Aberdeenshire: Fraserburgh (later) Aberdeenshire: Inverurie Aberdeenshire: Peterhead Aberdeenshire: Stonehaven Angus: Arbroath Angus: Brechin Angus: Forfar Argyll & Bute: Bowmore Argyll & Bute: Campbeltown Argyll & Bute: Dunoon Argyll & Bute: Helensburgh Argyll & Bute: Lochgilphead Argyll & Bute: Oban Argyll & Bute: Rothesay Clackmannanshire: Alloa Will be known as Alloa JP Court after Unification Dumfries: Annan Dumfries: Dumfries Dumfries: Kirkcudbright Dumfries: Lockerbie Dumfries: Sanquhar Dumfries: Stranraer Dumfries: Wigtown Dundee East Ayrshire: Cumnock East Ayrshire: Kilmarnock East Dunbartonshire: Kirkintilloch East Dunbartonshire: Milngavie East Lothian: Haddington East Renfrewshire: Giffnock Edinburgh Falkirk Fife: Cupar Fife: Dunfermline Fife: Kirkcaldy Glasgow City Highland: Dingwall Highland: Dornoch Highland: Fort William Highland: Inverness Highland: Kingussie

9505 9506 9507 9509 9508 9514 9518 9522 9526 9530 9531 9532 9538

Closing 9347 9349 9348 9340 Closed 9341 9354 9355 9356 9357 9358

9542 9550 9551 9552 9553 9560 9561 9565 9566 9567 9568 9572 9575 9576 9580 9584

9342 9350 9351 9352 9353 9360 9361 9365 9366 9367 9368 9372 9375 9376 9380 9384

Highland: Nairn Highland: Portree Highland: Thurso Highland: Wick Highland: Tain Inverclyde: Greenock Midlothian: Penicuik/Dalkeith Moray: Elgin North Ayrshire: Irvine North Lanarkshire: Coatbridge North Lanarkshire: Cumbernauld North Lanarkshire: Motherwell Perth and Kinross: Perth Will be known as Perth JP Court after unification Renfrewshire: Paisley Scottish Borders: Duns Scottish Borders: Jedburgh Scottish Borders: Peebles Scottish Borders: Selkirk South Ayrshire: Ayr South Ayrshire: Girvan South Lanarkshire: East Kilbride South Lanarkshire: Hamilton South Lanarkshire: Lanark South Lanarkshire: Rutherglen Stirling West Dunbartonshire: Clydebank West Dunbartonshire: Dumbarton West Lothian: Livingston Western Isles: Stornoway

Note**: Following a review of the summary justice system, the Criminal Proceedings etc. (Reform) (Scotland) Act 2007 provides for District Courts to become JP Courts and their administration will be undertaken by SCS. The administration will transfer from local authorities to SCS on a phased basis by Sheriffdom commencing with Lothian and Borders in March 2008, followed by Grampian, Highland and Islands in June 2008, and the remaining Sheriffdoms over the next 2 years The new JP Court Codes will therefore be implemented on a phased basis.

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS COURT TYPES DEFINITION:

A code to describe the type of court.

PERMISSIBLE CHARACTER SET:

Alphanumeric

RANGES/VALUES:

The field is up to 2 characters long.

PRIMARY OWNERSHIP:

COPFS/SCS

CODES: CODE 16 76 AC CU DI DT EX FA FC HC ID IP JE MP NO PD PH RS SC SJ SM SP SU ST TP TR UT WT

Description Section 16 Section 76 Appeal Court Custody Indictment Deferred Diet Further examination Fatal Accident Enquiry Full Committal High Intermediate Diet Initial Petition Judicial Examination Minute of Postponement Noble Officium Pleading Diet Preliminary Hearing Reduction to Summary Stipendiary Custody Sheriff & Jury Summary Stipendiary Pleading Diet Stipendiary Undertaking Stipendiary Trial Transfer of Proceedings Trial Undertaking Initiating Warrant

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS CRIME/OFFENCE REFERENCE NUMBER DEFINITION:

This number is charge orientated and is the unique reference number issued by the reporting agency which relates to a particular charge or charges contained within a report to the Procurator Fiscal.

DATA ITEMS:

Crime/Offence Number

PERMISSIBLE CHARACTER SET:

Upper-case alpha, oblique and numeric.

RANGES/VALUES:

The field is 13 characters long and consists of 4 elements as follows:-

The first 3 characters identify the agency, next 6 relate to the agencies internal sequential identifier, next 2 numbers are the month and the last 2 numbers are the year. Other agency’s will be issued an identifier by SCJS. EXAMPLE: XML TAG-NAME: PRIMARY OWNERSHIP:

PSP1234560199 ISCJISCore: Agency Reference Type

Common

DATE DEFINITION:

The day, month and year of the relevant event or document.

DATA ITEMS:

Accused Undertaking Date Alias date of birth Annual Leave Date(s) Civilian Witness Date of Involvement Civilian Witness DoB Crime/Offence Caution Date Crime/Offence Earliest Date Crime/Offence Known Date Crime/Offence Latest Date Crime/Offence Offence Date Date of Birth Date of first offence

Date of next appearance Date of order Disposal Date Instalment Date Pending Case Date Plea Date Police Witness Date of Involvement Scheduled Court Date Sentence Date PERMISSIBLE CHARACTER SET: Numeric only. XML TAG-NAME:

xsd:date

RANGES/VALUES:

The field is 8 characters long for data transfer but may be 3 separate field within systems.

DEPENDING ON FILE TYPE The first 2 characters represent the day, the next 2 the month, and the last 4 the year. Value less than 10 should be indicated by a zero in the first position. EXAMPLES: 26061992 = 26 June 1992. For SPR2: yyyymmdd so 19920626 = 26 June 1992 PRIMARY OWNERSHIP:

Common

DEATH REPORT NEXT OF KIN CONTACT TYPE DEFINITION:

A coded item used to identify the type of Death Contact being submitted to the Procurator Fiscal..

DATA ITEMS:

Death Contact Type

PERMISSIBLE CHARACTER SET:

Upper case alpha only.

RANGES/VALUES:

The field is 4 characters long

XML TAG-NAME: PRIMARY OWNERSHIP: CODES:

ISCJISCore: NOK Type COPFS

CODE MEDI PART RELA CONT FAMI OTHR

Description Medical Partner Nearest relative Point of contact Family member Other

DIET TYPE DEFINITION:

The type of criminal justice process in question.

DATA ITEMS:

Appearance Type Case Type Continuation Type Breach of Order

PERMISSIBLE CHARACTER SET:

Alpha-numeric.

RANGES/VALUES:

The field is 2 characters long.

PRIMARY OWNERSHIP:

Scottish Court Service

CODES:

See Diet type codes: High Court Summary Complaints Petition

DIET TYPE CODES

Indictment Others

High Court Confiscation Hearing – Notional Confiscation Proof

73 74

Summary complaints New Deferred Continued Without Plea Trial Accelerated After Warrant Intermediate Diet Contempt of Court Examination of Facts Notional Diet Adjourned Trial Part Heard Trial

10 11 12 13 14 15 16 17 18 19 52 53

Petition Committal for Further Examination Full committal Judicial Examination New Petition After Warrant

20 21 22 23 24

Indictment Indictment contd prelim diet Accelerated Procedure (Section 76) Preliminary Diet Trial Deferred Accelerated After Warrant Contempt Examination of Facts Adjourned Trial Part Heard Trial Reduction to Summary Preliminary Hearing

29 30 31 32 33 34 35 36 37 54 55 38 PH

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS Diet Type Codes Others Means Enquiry Arrested Drug Court Custody Undertaking for Drug Court, Warrant Drug Court, Sentence Deferred Drug Court Drug Court (Adjourned Diet) Fines Enquiry – After Warrant Fines Enforcement Court Fines Enforcement Court – After Warrant Private Prosecution Breach of Order Attendance Order Breach Change of Order Drug Treatment Order Review DTTO/Probation Order Review Disqualification Removal Special Reasons Proof Mitigating Reasons Proof Debate Diet of Debate and Continued without Plea Diet of Debate and Notional Diet Diet of Debate and Deferred Sentence Notional Diet and Deferred Sentence Intermediate Diet Adjourned Case Adjourned Bail Hearing Bail Review Duty Arrear Proof Section 195 Hearing CWP& Deferred Sentence Appeal Hearing Intermediate Diet and Sentence Deferred Trial and Sentence Deferred Provisional High Court FAI Mandatory FAI Discretionary Public Enquiry Appeal Procedural Hearing Appeal interim liberation def Appeal substantive hearing Appeal advising Appeal pre-trial Crown Bail appeal Defence bail appeal Examination of facts Preliminary hearing contd Preliminary hearing adj Preliminary hearing sec 72 Further pre-trial diet sec 72

40 41 42 43 44 45 46 47 48 50 60 61 65 66 67 70 71 72 80 81 82 83 84 85 86 90 91 92 95 96 97 98 99 C1 C2 C3 C4 A1 A2 A3 A4 A5 BL BO EF H1 H2 H3 H4

Fixed trial diet Dedicated floating trial Floating trial diet Alteration of diet application Joint application no prelim hearing Recovery of documents S16 recall of licence Section 65 Hearing

H5 H6 H7 H8 H9 RD RL EX

DISPOSAL DEFINITION:

The disposal by the court of the proceedings against the subject.

DATA ITEMS:

Conviction – Disposal Financial Disposal Type Type of Detention Alternative Imposed Type of Order

PERMISSIBLE CHARACTER SET:

Alphanumeric.

RANGES/VALUES:

The field is up to 4 characters long.

PRIMARY OWNERSHIP:

Common

CODES:

Disposal Codes - See next page. Courts Fiscal Fines

DISPOSAL CODES Courts ABS ANG ADM TEXT ASB DVLA ASSC DUTY CAPS CAU CDEN CH

Absolute Discharge Accepted not guilty Admonition All other disposals not covered by the rest of the codes Antisocial Behaviour Orders Any DVLA disposals (inc disqualification and Penalty Points) Associate Back Duty CAP closure marking Caution Child Detention Children’s Hearing

CRO CS CWN COMP CMPO CCRO CONF DOG DETH DEC DPRT DSP DISC DIS C1 DVRT DTO EXCL EXP IMPE FINE COFP COFF COMB FFDF PAD FBO FRI FTO FORF FNG GB GO HARR HODI HOSP IMP INS INAS MERG ACQ NO NPIA NPRO NSP FNP ORDA ORDC ORDD ORDE LLR ORDR ORDV PRW PC

Community reparation order Community Service Order Community warning notice Compensation Compulsion order Compulsion restriction order Confiscation Orders Dangerous dogs act Death closure marking Declaration Deportation Desert Simpliciter Discontinued Dismissed Divert Diverted Drug Treatment Order Exclusion Orders (normally from Licensed Premises) Expenses Extended Sentence Fines Fiscal conditional offer of Fixed Penalty Fiscal fine Fiscal Fine / Fiscal Compensation combined Fiscal fine defaulted Fixed penalty paid Football banning orders Football related incident Foreign travel order Forfeiture of drugs, money, guns etc Found not guilty Good Behaviour Guardianship Order Harassment Order Hospital direction Hospital Order Imprisonment Insane Insufficient assets Merge charges No case to answer No Order No pro industrial action No proceedings No sentence passed Not proven Order amended Order continued Order discharged Order extended Order for lifelong restriction Order revoked Order varied Police restorative warning Probation Compensation

PO POD PCA RHC RSC SCRA RELO RSHO ROLL SCH SCHC SCHS SCHV SOO SO SOPO SAO RSAO SRO STO WARN YOI

Probation Order Probation Order Drug Protection of children act Remit to High Court Remit to Sheriff Court Reporter Restriction of Liberty Order Risk of sexual harm order Roll up Schedule 1 Offender Schedule 1 Offender (Care) Schedule 1 Offender (Sex) Schedule 1 Offender (Violence) Sex Offenders Order Sex Offenders Register Sexual offences prevention order Supervised Attendance Order Supervised Attendance Order (revocation) Supervised Release Order Supervision and Treatment Orders Warning Young Offenders Institute

Fiscal Fines FCC FPD FUD FWD FDL FRF FDA FRC FPT DAL FRJ FAD UNSD DUFF

Pending Cheque Clearance Fine Paid Fine Unpaid Withdrawn Non DVLA Driving Licence Refused Deemed acceptance Recalled Too many points Deemed Acceptance Letter Fine Rejected – ASBO’s only FAD Address Changes Unused Draft Indictment Charge Charge Added in Error

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS Document Type DEFINITION:

Types of Documents.

DATA ITEMS:

Listed below

PERMISSIBLE CHARACTER SET: RANGES/VALUES:

The field is up to 3 characters

PRIMARY OWNERSHIP:

Common

CODES: CODE

Document Type

SPR

Sheriff Prosecution report

SUR

Sheriff Undertaking Report

SCR

Sheriff Custody Report

SWR

Sheriff Warrant Report

YPR

Youth Prosecution Report

YUR

Youth Undertaking Report

YCR

Youth Custody Report

YWR

Youth warrant report

DPR

District Prosecution Report

DUR

District Undertaking Report

DCR

District Custody Report

DWR

District Warrant Report

Subject Report

Production Report

Witness Report

Witness Statement

Memo Report

Occurrence Report

Death Report

Previous Conviction

COM

Summary Complaint

PET

Petition

IND

Indictment

Let

Letter

BAI

Bail Order

FFL

Fiscal Fine Letter

SER

Social Enquiry Report

DURATION DEFINITION:

The length or period of time in question.

DATA ITEMS:

Detention Period Disqualification Period Alternative Period Order Period

PERMISSIBLE CHARACTER SET:

RANGES/VALUES:

PRIMARY OWNERSHIP:

The identifier field is 1 character long. The quantity field is 4 characters long. In the identifier field, there are six possible units of duration. In the quantity field the permissible ranges are: (a) any whole number from 1 to 999 inclusive (b) any number containing a half (expressed as a decimal, ie 0.5) from 0.5 to 99.5 inclusive. If two or more units need to be combined, eg 2 years 4 months, the fields should be re-used as appropriate.

Common

CODES: Code H D W M Y L

Identifier field: Alphabetic Quantity field: Numeric and full stop.

Meaning Hours Days Weeks Months Years Life

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS DVLA DRIVER NUMBER DEFINITION:

A unique key allocated to individual driver records held by DVLA.

DATA ITEMS:

Accused Driver Number

PERMISSIBLE CHARACTER SET:

RANGES/VALUES:

Upper-case alphanumeric; an asterisk appear on manually produced licences.

may

The field is 16 characters long, and consists of 5 sub-fields:(a) first 5 characters of surname (b) date of birth scrambled – 6 characters (c) initial letters of first and second forenames (d) alpha or numeric ‘tie-breaker’ character (e) 2 alpha check characters

PRIMARY OWNERSHIP:

DVLA

EMAIL ADDRESS DEFINITION:

An email address.

DATA ITEMS:

Civilian Witness Email Address Police Witness Email Address Reporting Officer Email Address Supervising Officer Email Address

PERMISSIBLE CHARACTER SET:

Alphanumeric only.

RANGES/VALUES:

Up to 127 characters, an “@” symbol followed by up to 127 further characters.

XML TAG-NAME:

ISCJISCore:EmailType

PRIMARY OWNERSHIP:

Common

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS ETHNICITY DEFINITION:

The ethnicity of an entity.

DATA ITEMS:

Accused Ethnicity Civilian Witness Ethnicity Police Witness Ethnicity

PERMISSIBLE CHARACTER SET:

Alphanumeric only.

XML TAG-NAME:

ISCJISCore:Ethnicity Type

RANGES/VALUES:

The field is 4 characters long.

PRIMARY OWNERSHIP:

Common

ETHNICITY

CODE

White Scottish

WSCO

White English

WENG

White Welsh

WWEL

White Northern Ireland

WNIR

White British

BRIT

White Irish

WLRI

White Gypsy/Traveller

WGTR

White Polish

WPOL

Other White

WOTW

Any Mixed Ethnic group

MOTM

Pakistani

PACK

Indian

AIND

Bangladeshi

ABAN

Chinese

MCOE

Other Asian

AOTA

African

AAFR

Caribbean

BCRB

Black Scottish or Other Black

BOTB

Other African, Caribbean or Black AOTB

Arab

ARAB

Other Ethnic Group

OOEG

Unknown

UNKN

INACTIVE ETHNICITY

CODE

Other White British WOWB

EVIDENCE TYPE DEFINITION:

A measure of the length of a trial.

PERMISSIBLE CHARACTER SET:

Upper-case alpha only.

RANGES/VALUES:

The field is 1 character long.

PRIMARY OWNERSHIP:

Crown Office / SCS

CODE:

Code E P N

Meaning Evidence Led Plea Recorded No Evidence Led

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS FIXED PENALTY NOTICE OFFENCE CODE The code for the category of traffic offence covered by fixed penalty notices issued by the Police or Traffic Wardens.

DEFINITION:

This information is relevant to the transfer of information between Police and Courts. Each police force maintains its own set of local codes of traffic offences for which fixed penalty notices can be issued. These codes vary by force. However, courts require only a broad categorisation of the type of offence involved, and this data standard defines the categories to which the local offence codes should be mapped before fixed penalty notice data are transmitted by the police to the courts. These are consistent with the categories used in the national statistics on fixed penalty notices collected from the police by the Scottish Government Analytical Services Division. PERMISSIBLE CHARACTER SET:

Alphanumeric

RANGES/VALUES: The field is four characters long. It consists of an alphanumeric code which identifies the category of traffic offence that is the subject of a fixed penalty notice. The description may be held in a text field within individual systems and will be an automatic expansion of the code into text to specify the general nature of the offence. PRIMARY OWNERSHIP:

ISCJIS

CODES: Code

Description

PAR

parking place offence

RES

Restricted street offence (excluding clearway offences)

CLE

Clearway offences

TAX

Non-display of current vehicle excise licence

OTH

Other offences (vehicle lighting, prescribed route, infringement of construction & use regulations)

PCOA

Police Conditional Fixed Penalty (ASBO)

PCOC

Police Conditional Offer Fixed Penalty (Camera endorsable and non endorsable)

PCOT

Police Conditional Offer Fixed Penalty (Road Traffic - endorsable and non endorsable)

PCPF

Criminalised Parking Fines

PRAS

Registered Fines (ASBOs)

PREG

Registered fines 9former Criminalised parking Fines)

FIXED PENALTY TICKET NUMBER DEFINITION:

The number of the ticket issued in respect of all fixed-penalty tickets

DATA ITEMS:

Fixed Penalty Ticket Number

PERMISSIBLE CHARACTER SET:

Alpha, numeric

RANGES/VALUES: The data standard agreed is as follows:Up to 20 characters alpha/numeric until date of unification. The first two to three characters must be unique and contain the Police force PNC identifier eg Strathclyde 074 or 74 Following the police identifier, the next 1-4 characters will contain a ticket type After ticket type, there must be a minimum of 6 additional character to identify the ticket number EG 74A123456 – this is the minimum specification for the ticket number. From the date of unification of the Sheriffdom the ticket number must be unique to enable tickets to be distinguishable between forces. Dates of Unification Sheriffdom Date of Court Unification Lothian & Borders 10 March 2008 Grampian, Highlands & Islands 2 June 2008 Rolling Programme Estimated dates* extracted from Press release on 2 June Glasgow *December 2008 Tayside, Central & Fife *February 2009 South Strathclyde *June 2009 Dumfries & Galloway *October 2009 North Strathclyde PRIMARY OWNERSHIP:

Common

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS FORENAME(S) DEFINITION:

The given name of the relevant person.

DATA ITEMS:

Accused Forename Alias Forename Reporting Officer Forename Civilian Witness Forename Civilian Witness Alias Forename Police Witness Forename CHS Filename Victim Forename Responsible Person

PERMISSIBLE CHARACTER SET:

Alphabetic, space, apostrophe, hyphen.

RANGES/VALUES:

The field is 120 characters long. The first given name should be entered followed by the other component names in their normal order. Spaces, apostrophes, hyphens and full stops that occur within a component name should be entered as such. Maiden surnames and, if married more than once, all previous married surnames should be entered in this field with the current surname entered in the SURNAME field.

XML TAG-NAME:

ISCJISCore: Forename Type

PRIMARY OWNERSHIP:

Common

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS GENDER DEFINITION: DATA ITEMS:

PERMISSIBLE CHARACTER SET: XML TAG-NAME:

The gender of the relevant person. Accused Gender Civilian Witness Gender

Alphabetic only. ISCJISCore: Gender Type

RANGES/VALUES:

The field is 1 character long

PRIMARY OWNERSHIP:

Common

CODES:

M - Male F - Female C - Company U – Unknown

LANGUAGE

DEFINITION:

DATA ITEMS: PERMISSIBLE CHARACTER SET: RANGES/VALUES:

XML TAG-NAME:

ISCJISCore: Language Type

PRIMARY OWNERSHIP:

Common

Language Types DATE

Language

AFRI ALBA AMHA ARAB ARME BENG BERB BOSN BULG BURM CAMB CANT CATA CROA CZEC DANI DARI DUTC ENGL ESTO FARS FILI FINN FLEM FREN GAAA

AFRIKAANS ALBANIAN AMHARIC ARABIC ARMENIAN BENGALI BERBER BOSNIAN BULGARIAN BURMESE CAMBODIAN CANTONESE CATALAN CROATIAN CZECH DANISH DARI DUTCH ENGLISH ESTONIAN FARSI FILIPINO FINNISH FLEMISH FRENCH GA GAELIC (WELSH) GAELIC (SCOTTISH) GEORGIAN GERMAN GREEK GUJARATI HAKKA HEBREW HINDI HUNGARIAN ICELANDIC IGBO INDONESIAN ITALIAN JAPANESE KAZAKH KOREAN KURDISH LAO LATVIAN LINGALA LITHUANIAN

GAEW GAES GEOR GERM GREE GUJA HAKK HEBR HIND HUNG ICEL IGBO INDO ITAL JAPA KAZA KORE KURD LAO LATV LING LITH

MACE MALA MAND MARA MIRP MONG NEPA NORW OTHE POLI PORT PUNJ PUSH ROMA RUSS SERB SIGN SINH SLOV SLOE SOMA SPAN SWAH SWED SYLH TAGA TAIW TAMI THAI TIGR TURK TWIA UKRA URDU UZBE VIET WELS YIDD YORU

MACEDONIAN MALAYALAM MANDARIN MARATHI MIRPURI MONGOLIAN NEPALESE NORWEGIAN OTHER POLISH PORTUGUESE PUNJABI PUSHTU ROMANIAN RUSSIAN SERBIAN Sign Language SINHALESE SLOVAK SLOVENE SOMALI SPANISH SWAHILI SWEDISH SYLHETI TAGALOG TAIWANESE TAMIL THAI TIGRINIAN TURKISH TWI UKRAINIAN URDU UZBEK VIETNAMESE WELSH YIDDISH YORUBA

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS LEGAL AID NUMBER DEFINITION:

The number assigned on the first legal aid application.

DATA ITEMS:

Legal Aid Code Number

PERMISSIBLE CHARACTER SET:

’LA', numeric and oblique only.

RANGES/VALUES:

The field is 17 characters long, and constructed as follows: The alphabetic characters LA: oblique; 4 numeric characters constituting the court code; oblique,

2 numeric characters representing the year of issue; oblique; 6 numeric characters constituting the serial number. PRIMARY OWNERSHIP: EXAMPLE:

Scottish Legal Aid Board LA/1234/92/123456

LOCAL AUTHORITY DEFINITION:

The local authority responsible for dealing with a particular aspect of the case at the particular stage in question.

DATA ITEMS:

Local Authority Name Regional Authority

PERMISSIBLE CHARACTER SET:

Alphabetic only.

RANGES/VALUES:

The field is 5 characters long.

PRIMARY OWNERSHIP:

Common.

CODES:

See local authority codes

LOCAL AUTHORITY CODES CODE 94051 94001 94061 94071 94081 94091 94151 94161 94171 94251 94261 94271 94281 94291 94301 94311 94401 94451 94461 94471 94481 94491 94501 94511 94561 94601 94611 94651 94661 95762 94701 94741 94781 94821 94851 94861 94871 94951 95001 95011 95021 95031 95041 98051 98121 98141 95051 95061

LOCAL AUTHORITY LOCATION Aberdeenshire at Banff Aberdeen City Aberdeenshire at Fraserburgh Aberdeenshire at Inverurie Aberdeenshire at Peterhead Aberdeenshire at Stonehaven Angus at Arbroath Angus at Brechin Angus at Forfar Argyll & Bute at Bowmore Argyll & Bute at Campbeltown Argyll & Bute at Dunoon Argyll & Bute at Helensburgh Argyll & Bute at Lochgilphead Argyll & Bute at Oban Argyll & Bute at Rothesay Clackmannanshire at Alloa Dumfries at Annan Dumfries at Dumfries Dumfries at Kirkcudbright Dumfries at Lockerbie Dumfries at Sanquhar Dumfries at Stranraer Dumfries at Wigtown Dundee East Ayrshire at Cumnock East Ayrshire at Kilmarnock East Dunbartonshire at Kirktintilloch East Dunbartonshire at Milngavie East Dunbartonshire at Bearsden East Lothian at Haddington East Renfrewshire at Giffnock Edinburgh Falkirk Fife at Cupar Fife at Dunfermline Fife at Kirkcaldy Glasgow Highland at Dingwall Highland at Dornoch Highland at Fort William Highland at Inverness Highland at Kingussie Highland at Kirkwall Highland at Lerwick Highland at Lochmaddy Highland at Nairn Highland at Portree

95071 95081 95091 95141 95181 95221 95261 95301 95302 95311 95321 95381 95421 95501 95511 95521 95531 95601 95611 95651 95661 95671 95681 95721 95751 95761 95801 95841

Highland at Thurso Highland at Wick Highland at Tain Inverclyde at Greenock Midlothian at Penicuik Moray at Elgin North Ayrshire at Irvine North Lanarkshire at Coatbridge North Lanarkshire at Kilsyth North Lanarkshire at Cumbernauld North Lanarkshire at Motherwell Perth and Kinross at Perth Renfrewshire at Paisley Scottish Borders at Duns Scottish Borders at Jedburgh Scottish Borders at Peebles Scottish Borders at Selkirk South Ayrshire at Ayr South Ayrshire at Girvan South Lanarkshire at East Kilbride South Lanarkshire at Hamilton South Lanarkshire at Lanark South Lanarkshire at Rutherglen Stirling West Dunbartonshire at Clydebank West Dunbartonshire at Dumbarton West Lothian at Livingston Western Isles at Stornoway

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS Means to Pay

DEFINITION:

The information field relates to the income of the subject only.

DATA ITEMS:

Means to Pay Rating Means to Pay Note

PERMISSIBLE CHARACTER SET: 4 Character Code RANGES/VALUES:

XML TAG-NAME:

ISCJISCore:

PRIMARY OWNERSHIP:

Common

Bandings CODE

Description

BNDA

BAND A - UNDER £10,000 (To include benefits)

BNDB

BAND B - £10,000 - £30,000

BNDC

BAND C - OVER £30,000

NOTP

NOT PROVIDED

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS Mental Health Hospitals

LOCATION AILSA HOSPITAL, AYR ARGYLL & BUTE HOSPITAL, LOCHGILPHEAD ARROL PARK RESOURCE CENTER, AYR BELLSDYKE HOSPITAL, LARBERT CRICHTON ROYAL HOSPITAL, DUMFRIES CROSSHOUSE HOSPITAL, KILMARNOCK DYKEBAR HOSPITAL, PAISLEY GARTNAVEL ROYAL HOSPITAL, GLASGOW HARTWOODHILL HOSPITAL, HARTWOOD, SHOTTS HERDMANFLAT HOSPITAL, HADDINGTON, HUNTL YBURN HOUSE, MELROSE, SCOTTISH BORDERS INVERCLYDE ROYAL HOSPITAL, GREENOCK LEVERNDALE HOSPITAL , GLASGOW MONKLANDS HOSPITAL, AIRDRIE MURRAY ROYAL HOSPITAL, PERTH NEW CRAIGS HOSPITAL, INVERNESS PARKHEAD HOSPITAL, GLASGOW RAVENSCRAIG HOSPITAL, GREENOCK ROWANBAMK CLINIC, GLASGOW ROSSLYNLEE HOSPITAL, MIDLOTHIAN ROYAL CORNHILL HOSPITAL, ABERDEEN ROYAL DUNDEE LIFF, HOSPITAL , DUNDEE ROYAL EDINBURGH HOSPITAL, EDINBURGH SOUTHERN GENERAL PSYCHIATRIC , GLASGOW ST JOHN'S HOSPITAL, LIVINGSTON, WEST LOTHIAN STOBHILL HOSPITAL , GLASGOW G21 3UW STRATHEDEN HOSPITAL, CUPAR STRATHLEA RESOURCE CENTRE, KILMARNOCK STRATHMARTINE HOSPITAL, DUNDEE ST MICHAEL'S COTTAGE, DUMFRIES SUNNYSIDE ROYAL HOSPITAL, MONTROSE THE STATE HOSPITAL, CARSTAIRS, LANARK VALE OF LEVEN DISTRICT HOSPTIAL, ALEXANDRIA WILLIAM FRASER CENTRE, MORNINGSIDE, EDINBURGH

CODE AH AR AP BL CT CH DK GR HW HE HB IC LV MO MU NC PH RC RB RL CO LI RE SG SJ SH SD SL SM SC SU CS VL WF

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS

SECURE YOUTH ACCOMMODATION, SCOTLAND

Location KIBBLE SECURE UNIT, PAISLEY ST PHILIPS SECURE UNIT, AIRDRIE THE GOOD SHEPERD CENTRE, RENFREWSHIRE ROSSIE, MONTROSE ST MARY’S KENMURE, GLASGOW HOWDEANHALL, EDINBURGH THE ELMS, DUNDEE

Code KS PS GS RO SK HD TE

MONEY DEFINITION: DATA ITEMS:

PERMISSIBLE CHARACTER SET:

The amount of money or value in question. Financial Amount. Instalment Amount Money in Possession Property Value Recovered value Loss Amount Fine Amount Additional Amount

Numeric only, with last three digits the decimal point followed by pence

RANGES/VALUES:

The field is 13 characters long.

PRIMARY OWNERSHIP:

Common

EXAMPLES:

NATIONAL ID NUMBER

The amount allowed is up to £10 billion less 1p and is shown in pounds, pence format e.g. 9999999999.00

DEFINITION:

A data item that represents a national id number.

DATA ITEMS:

Civilian Witness National ID Number.

PERMISSIBLE CHARACTER SET:

Alphanumeric

RANGES/VALUES:

Up to 20 characters.

XML TAG-NAME:

ISCJISCore: National ID No

PRIMARY OWNERSHIP:

Common

PAGE/SECTION

AMENDMENT

Front Cover

Change Version to 1.6 (2 places)

Version Control Page 2

Section 3 – Add version 1.6, Date Issued 4 August 2008

Next of Kin DEFINITION: A coded item used to identify the Next of Kin. DATA ITEMS: Next of Kin Type PERMISSIBLE CHARACTER SET: Upper case alpha only. RANGES/VALUES: The field is 4 characters long XML TAG-NAME: PRIMARY OWNERSHIP: COPFS CODES: NEXT OF KIN DESCRIPTION AU BL BR CC CO DA DL FA FL FR GC GF GM HB

AUNT BROTHER IN_LAW BROTHER CONVERSION COUSIN DAUGHTER DAUGHTER IN_LAW FATHER FATHER IN_LAW FRIEND GRANDCHILD GRANDFATHER GRANDMOTHER HUSBAND

LG ML MO NE NI PR SB SD SF SI SL SM SO SS ST TL UN WF

LEGAL GUARDIAN MOTHER IN_LAW MOTHER NEPHEW NIECE PARTNER STEP BROTHER STEP DAUGHTER STEP FATHER SISTER SON IN_LAW STEP MOTHER SON STEP SON STEP SISTER SISTER IN_LAW UNCLE WIFE

NATIONALITY DEFINITION:

The coded item used to identify the nationality of the accused person

DATA ITEMS: Nationality PERMISSIBLE CHARACTER SET: Upper Case alpha only RANGES/VALUES: The code field is 3 long PRIMARY OWNERSHIP:

Country Afghanistan Åland Islands Albania Algeria American Samoa Andorra Angola Anguilla Antarctica Antigua and Barbuda Argentina Armenia Aruba Australia Austria Azerbaijan Bahamas

ISCJIS - Maintained through standard ISO Nationality list

Code AFG ALA ALB DZA ASM AND AGO AIA ATA ATG ARG ARM ABW AUS AUT AZE BHS

Bahrain Bangladesh Barbados Belarus Belgium Belize Benin Bermuda Bhutan Bolivia Bosnia and Herzegovina Botswana Bouvet Island Brazil British Indian Ocean Territory Brunei Darussalam Bulgaria Burkina Faso Burundi Cambodia Cameroon Canada Cape Verde Cayman Islands Central African Republic Chad Chile China Christmas Island Cocos (Keeling) Islands Colombia Comoros Congo Cook Islands Costa Rica Côte d.Ivoire Croatia Cuba Cyprus Czech Republic Democratic People’s Republic of Korea Democratic Republic of the Congo Denmark Djibouti Dominica Dominican Republic Ecuador Egypt El Salvador Equatorial Guinea Eritrea Estonia Ethiopia

BHR BGD BRB BLR BEL BLZ BEN BMU BTN BOL BIH BWA BVT BRA IOT BRN BGR BFA BDI KHM CMR CAN CPV CYM CAF TCD CHL CHN CXR CCK COL COM COG co*k CRI CIV HRV CUB CYP CZE PRK COD DNK DJI DMA DOM ECU EGY SLV GNQ ERI EST ETH

Falkland Islands (Malvinas) Faroe Islands Fiji Finland France France, Metropolitan French Guiana French Polynesia French Southern Territories Gabon Gambia Georgia Germany Ghana Gibraltar Greece Greenland Grenada Guadeloupe Guam Guatemala Guernsey Guinea Guinea-Bissau Guyana Haiti Heard and McDonald Islands Holy See (Vatican City State) Honduras Hong Kong Special Administrative Region of China Hungary Iceland India Indonesia Iran (Islamic Republic of) Iraq Ireland Isle of Man Israel Italy Jamaica Japan Jersey Jordan Kazakhstan Kenya Kiribati Korea Republic of Kuwait Kyrgyzstan Lao People’s Democratic Republic Latvia Lebanon Lesotho

FLK4 FRO FJI FIN FRA FXX GUF PYF ATF GAB GMB GEO DEU GHA GIB GRC GRL GRD GLP GUM GTM GGY GIN GNB GUY HTI HMD VAT HND HKG HUN ISL IND IDN IRN IRQ IRL IMN ISR ITA JAM JPN JEY JOR KAZ KEN KIR KOR KWT KGZ LAO LVA LBN LSO

Liberia Libyan Arab Jamahiriya Liechtenstein Lithuania Luxembourg Macau Special Administrative Region of China Madagascar Malawi Malaysia Maldives Mali Malta Marshall Islands Martinique Mauritania Mauritius Mayotte Mexico Micronesia(Federation States of) Monaco Mongolia Montserrat Morocco Mozambique Myanmar Namibia Nauru Nepal Netherlands Netherlands Antilles Neutral Zone New Caledonia New Zealand Nicaragua Niger Nigeria Niue Norfolk Island Northern Mariana Islands Norway Oman Pakistan Palau Panama Papua New Guinea Palestinian Territory, Occupied Paraguay Peru Philippines Pitcairn Poland Portugal Puerto Rico Qatar

LBR LBY LIE LTU LUX MAC MDG MWI MYS MDV MLI MLT MHL MTQ MRT MUS MYT MEX FSM MCO MNG MSR MAR MOZ MMR NAM NRU NPL NLD ANT NTZ NCL NZL NIC NER NGA NIU NFK MNP NOR OMN PAK PLW PAN PNG PSE PRY PER PHL PCN POL PRT PRI QAT

Democratic Peoples Republic of Korea Republic of Moldova Réunion Romania Russian Federation Rwanda St. Helena Saint Kitts and Nevis Saint Lucia St. Pierre and Miquelon Saint Vincent and the Grenadines Samoa San Marino Sao Tome and Principe Saudi Arabia Senegal Serbia and Montenegro Seychelles Sierra Leone Singapore Slovakia Slovenia Solomon Islands Somalia South Africa South Georgia and the South Sandwich Islands Spain Sri Lanka Sudan Suriname Svalbard and Jan Mayen Islands Swaziland Sweden Switzerland Syrian Arab Republic Taiwan, Province of China Tajikistan Thailand The former Yugoslav Republic of Macedonia Timor-Leste Togo Tokelau Tonga Trinidad and Tobago Tunisia Turkey Turkmenistan Turks and Caicos Islands Tuvalu Uganda Ukraine United Arab Emirates

PRK MDA REU ROU RUS RWA SHN KNA LCA SPM VCT WSM SMR STP SAU SEN SCG SYC SLE SGP SVK SVN SLB SOM ZAF SGS ESP LKA SDN SUR SJM SWZ SWE CHE SYR TWN TJK THA MKD TLS TGO TKL TON TTO TUN TUR TKM TCA TUV UGA UKR ARE

United Kingdom British . Citizen . Dependent territories citizen . National (Overseas) . Overseas citizen . Protected person . Subject United Republic of Tanzania United States United States Minor Outlying Islands Uruguay Uzbekistan Vanuatu Vatican City State (Holy See) Venezuela Viet Nam Virgin Islands (British) Virgin Islands (U.S.) Wallis and Futuna Islands Western Sahara Yemen Zambia Zimbabwe

GBR GBD* GBN* GBO* GBP* GBS* TZA USA UMI URY UZB VUT VAT VEN VNM VGB VIR WLF ESH YEM ZMB ZWE

NUMERIC DEFINITION:

A data item that represents a simple numerical value.

DATA ITEMS:

Accused number (within the complaint) Civilian Witness Responsible Person Number Juvenile Position in Family Production Number

PERMISSIBLE CHARACTER SET: RANGES/VALUES:

Numeric only The length or range of the field is advised in the index entry for data items conforming to this data standard. Eg: A data item may be listed as “NUMERIC (5)” to indicate a field that conforms to the Numeric standard and exists in the range 0-99999. If a data-item does not conform to the 0-9x value range for its length, the range is given in the index instead. Ie: “Numeric (1-99999).

PRIMARY OWNERSHIP:

Common

OCCUPATION Codes DEFINITION:

The current occupation of the subject including rank held, or unemployed.

DATA ITEMS:

Accused Occupation Civilian Witness Occupation

PERMISSIBLE CHARACTER SET:

3 characters alphanumeric followed by a suffix letter: E - employed R - retired S - student U - unemployed

RANGES/VALUES:

The field is 4 characters long.

XML TAG-NAME:

ISCJISCore: Occupation Type

PRIMARY OWNERSHIP:

Common

CODES:

Occupation Codes - See next page Health Occupations Education Occupations Social Work Occupations Government Occupations Industry/Commerce Occupations

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS

OCCUPATION CODES 1. HEALTH OCCUPATIONS 100 110 111 112 113 114 120 130 140 150 160 170 190

Managers and Administrators Health Professional Doctor Nurse Dentist Other Healthcare Clerical & Secretarial Scientific/Technical Legal Craft & Related Personal & Protective Plant & Machine Operatives Other

2. EDUCATION OCCUPATIONS 200 210 211 212 213 220 230 240 250 260 270 290

Managers & Administrators Education Professional Teacher Lecturer Other Education Clerical & Secretarial Scientific/Technical Legal Craft & Related Personal & Protective Plant & Machine Operatives Other

3. SOCIAL WORK OCCUPATIONS 300 310 311 312 313 320 330 340 350 360 361 362 370 390

Managers & Administrators Social Work Professional Social Worker Children's Home Worker Old Folks Home Worker Clerical & Secretarial Scientific/Technical Legal Craft & Related Personal & Protective Careworker (residential) Careworker (community) Plant & Machine Operatives Other

4. GOVERNMENT OCCUPATIONS 400 401 402 410 411 412 420 421 422 430 431 432 440 441 442 450 451 452 460 461 462 470 490

Managers & Administrators Central Government Local Government Professional Occupations Central Government Local Government Clerical & Secretarial Central Government Local Government Scientific/Technical Central Government Local Government Legal Central Government Local Government Craft & Related Central Government Local Government Personal & Protective Central Government (Military) Local Government (Police) Plant & Machine Operatives Other

5. INDUSTRY/COMMERCE OCCUPATIONS 500 510 520 530 540 550 560 561 562 570 590

Managers & Administrators Professional Clerical & Secretarial Scientific/Technical Legal Craft & Related Personal & Protective Private Security Other Plant & Machine Operatives Other

OCCUPATION (Text) DEFINITION:

The current occupation of the subject including rank held, or unemployed.

DATA ITEMS:

Accused Occupation Civilian Witness Occupation

PERMISSIBLE CHARACTER SET:

100 characters alphanumeric

RANGES/VALUES:

The field is 100 characters long.

XML TAG-NAME:

ISCJISCore: Occupation Type

PRIMARY OWNERSHIP:

Common

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS OFFENCE CODE DEFINITION:

The code for a crime or offence with which an accused person is charged, proceeded or convicted.

DATA ITEMS:

Crime/Offence Code Disposal/Charge Section Pending Case Charge Detail

PERMISSIBLE CHARACTER SET: RANGES/VALUES:

Code field - Alpha, numeric. The code field is 16 characters long and consists of an alphanumeric code, which identifies the offence. The character positions within the offence code differ between Common Law and Statutory offences. The following detail individual elements for each type of offence.

COMMON LAW Characters 1 - 4 relate to the first element of the charge Characters 5 - 8 are always 0 (zero) Characters 9 - 12 relate to the second element of the charge Characters 13 - 16 relate to the third element of the charge. If there is no second or third element these parts of the code will be 0 (zero) filled. If a charge has more than 3 elements a combination element will be created for the first element. Character positions 1, 9 and 13 indicate whether it is the full charge, an attempt or intent to. STATUTORY Characters 1 - 4 relate to the Act, Regulation or Order. Characters 5 - 8 relates to the year that the Act, Regulation or Order came into force. Characters 9 - 12 relate to the principal Section of the Act, Regulation or Order. Characters 13 - 14 relate to the first sub-section of the Act, Regulation or Order. Characters 15 - 16 are a sequence to hold variations within the principal Section and first sub-section of the Act, Regulation or Order. An Offence description may be held in a text field within individual systems and will be an automatic expansion of the Offence code into text to specify the nature of the Offence. OWNERSHIP:

ISCJIS - maintained by Crown Office

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS OFFENCE AGGRAVATION DEFINITION:

The code for a crime or offence that adds to the Offence Code by highlighting particular circ*mstances relating to the specific incident as opposed to the actual charge.

DATA ITEMS:

Crime/Offence Aggravator.

PERMISSIBLE CHARACTER SET: Code field – Alpha or Zero. RANGES/VALUES:

PRIMARY OWNERSHIP:

The code field is 1 character long and consists of an alpha code, which identifies the Aggravation to the offence committed. It is possible that a charge can have a combination of up to 6 aggravations. An Aggravation description may be held in a text field within individual systems and will be an automatic expansion of the Offence Aggravation code into text to specify the nature of the Aggravation.

ISCJIS - maintained by Crown Office.

CODES: Over page:-

CODE Aggravation 0

No Aggravation

Anti Social Behaviour

Offending whilst on Bail

Cancelled

Domestic Abuse

Disability

Football

Football Banning Order

Harassment

Harassment Order

Connected to Serious Crime

Offence against a child

Inactive Anticipated activation date indicator

October 2010

Breach of undertaking

Sexual Orientation

Sex Offenders Order

Religious

Racial

Sexual

Transgender

October 2010

Full List of Combination Codesare held with the SPSA Service Desk, 0141-585 - 8333

OFFENCE MODIFIER The code for a crime or offence which provides additional information for the specific incident as opposed to the actual charge. PERMISSIBLE CHARACTER SET: Code field. Alpha, numeric. DEFINITION:

RANGES/VALUES:

PRIMARY OWNERSHIP:

CODES:-

The code field is 4 characters long and consists of an alphanumeric code, which identifies additional elements of the charge. The code will consist of an alphabetic character followed by 3 numeric characters. If no modifier exists, 4 0's (zeroes) characters will be transferred. An Offence Modifier description may be held in a text field within individual systems and will be an automatic expansion of the Offence Modifier code into text to specify the nature of the Offence Modifier. ISCJIS maintained by Crown Office

See offence modifier definitions are:A B C W

For For For For

codes.

Class A Drugs Class B Drugs Class C Drugs Weapons

The

current

CODE

Description

0000 A001 A002 A003

No Modifier 1-Methyl-4-phenylpiperidine-4-carboxylic acid 2,5-Dimethoxy-a,4-dimethylphenethylamine 2-Methyl-3-morpholino-1,1-diphenylpropanecarboxylic acid 4-Bromo-2,5-dimethoxy-methylphenethylamine 4-Cyano-1-methyl-4phenylpiperidine 4-Cyano-2-dimethylamino-4,4-diphenylbutane 4-Methyl-aminorex 4-Phenylpiperidine-4-carboxylic acid athyl ester Acetorphine Alfentanil (Rapifen) Allylprodine Alphacetylmethadol Alphameprodine Alphamethadol Alphaprodine Anileridine Benzethidine Benzylmorphine (3-benzylmorphine) Betacetylmethadol Betameprodine Betamethadol Betaprodine Bezitramide Bufotenine Cannabinol Cannabinol Derivatives Carfentanil Clonitazene Coca leaf Cocaine Desomorphine Dextromoramide Diamorphine (Heroin) Diampromide Diethylthiambutene Difenoxin (diphenylpropyl) phenylpiperdine-4carboxylic acid Dihydrocodienone carboxymethyloxime Dihydromorphine Dimenoxadole Dimepheptanol Dimethylthiambutene Dioxaphethyl butyrate Diphenoxylate Dipipanone Drotebanol (3,4-dimethoxy-17-methylmorphinan-6B, 14-diol) Ecogonine Ecstasy

A004 A005 A006 A007 A008 A009 A010 A011 A012 A013 A014 A015 A016 A017 A018 A019 A020 A021 A022 A023 A024 A025 A026 A027 A028 A029 A030 A031 A032 A033 A034 A035 A036 A037 A038 A039 A040 A041 A042 A043 A044 A045 A046 A047

A048 A049 A050 A051 A052 A053 A054 A055 A056 A057 A058 A059 A060 A061 A062 A063 A064 A065 A066 A067 A068 A069 A070 A071 A072 A073 A074 A075 A076 A077 A078 A079 A080 A081 A082 A083 A084 A085 A086 A087 A088 A089 A090 A091 A092 A093 A094 A095 A096 A097 A098 A099 A100 A101 A102

Ethylmethylthiambutene Eticyclidine Etonitazene Etorphine Etoxeridine Etryptamine Fentanyl Furethidine Hydrocodone Hydromorphinol Hydromorphone Hydroxypethidine Isomethadone Ketobemidone Levomethorphan Levomoramide Levophenacylmorphan Levorphanol Lofentanil Lysergamide Lysergide Mescaline Metazocine Methadone Methadyl acetate Methyldesorphine Methyldihydromorphine (6-methyldihydromorphine) Metopon Morpheridine Morphine Morphine methobromide Morphine N-oxide Myrophine N,N-diethyltryptamine N,N-dimethyltryptamine N-alkyl derivatives of lysergamide N-Hydroxy-tenamphetamine N-methyl-1(1,3-benzodioxol-5-yl)-2-butanamine Nicomorphine Noracymethadol Norlevorphanol Normethadone Normorphine Norpipanone Omnopon Opium Oxycodone Oxymorphone Papaverinum Pethidine Phenadoxone Phenampromide Phenazocine Phencyclidine Phenethylamine

A103 A104 A105 A106 A107 A108 A109 A110 A111 A112 A113 A114 A115 A116 A117 A118 A119 A120 A121 A122 A123 A124 A125

Phenomorphan Phenoperdine Piminodine Piritramide Pitramide Poppy-straw Proheptazine Properidine Psilocin Racemethorphan Racemoramide Racemorphan Rolicyclidine Sufentanil Tenocylidine Thebacon Thebaine Tilidate Trimeperidine Remifentanil Dihydroetorphine Methylamphetamine Fluoroamphetamine

B001 B002 B003 B004 B005 B006 B007 B008 B009 B010 B011 B012 B013 B014 B015 B016 B017 B018 B019 B020 B021 B022 B023 B024 B025 B026 B027 B028 B029 B030 B031

Acetyldihydrocodeine Amphetamine Cannabis Cannabis Resin Codeine Dexamphetamine Dihydrocodeine Drinayl Ethylmorphine-ethylmorphine) Glutethimide Lefetamine Macloqualone Methaqualone Methcathinone Methylamphetamine Methylphenidate Methylphenobarbitone Nembutal Nicocodine Nicodicodine-nicotinoyldihydrocodeine) Nobese Noludar Norcodeine Pentazocine Pentobarbitone Sodium Phanodom Phenmetrazine Phenobarbitone Pholcodine Propiram Zipeprol

B032 B033 B034 B035 B036 B037 B038 B039 B040 B041 B042 B043 B044 B045

Cannabinol Cannabinol Derivatives Nabilone 3-Dimethylheptyl-11-Hydroxyhexahydrocannabinol 3-(1-Naphthoyl) Indole Derivatives 1H-Indol-3-YL-(1-Naphthyl) Methane Derivatives 3-(1-Naphthoyl) Pyrrole Derivatives 1-(1-Naphthylmethyl) Indene Derivatives 3-Phenylacetylindole Derivatives 2-(3-Hydroxycyclohexyl) Phenol Derivatives Win 55,212-2 Levonantradol HU-210 Mephedrone

C001 C002 C003 C004 C005 C006 C007 C008 C009 C010 C011 C012 C013 C014 C015 C016 C017 C018 C019 C020 C021 C022 C023 C024 C025 C026 C027 C028 C029 C030 C031 C032 C033 C034 C035 C036 C037 C038 C039 C040

4-Chloromethandienone Alprazolam Aminorex Atamestane Benzphetamine Bolandiol Bolasterone Bolazine Boldenone Bolenol Bolmantalate Bromazepam Brotizolam Buprenorphine (Temgesic) Calusterone Camazapam Cathine Cathinone Chlordiazepoxide Chlorphentermine Clobazam Clonazepam Clorazepic acid Clostebol Clotiazepam Cloxazolam Delorazepam Dextropropoxyphene Diazepam Diethylpropion (Tenuate Dosipan) Drostanolone Enestebol Epitiostanol Estazolam Ethchlorvynol Ethinamate Ethyl loflazepate Ethyloestrenol Fencamfamin Fenethylline

C041 C042 C043 C044 C045 C046 C047 C048 C049 C050 C051 C052 C053 C054 C055 C056 C057 C058 C059 C060 C061 C062 C063 C064 C065 C066 C067 C068 C069 C070 C071 C072 C073 C074 C075 C076 C077 C078 C079 C080 C081 C082 C083 C084 C085 C086 C087 C088 C089 C090 C091 C092 C093 C094 C095

Fenproporex Fludiazepam Flunitrazepam Fluoxymesterone Flurazepam Formebolone Furazabol Halazepam Haloxazolam Humanchorionic gonadotrophin Ketazolam Loprazolam Lorazepam Lormetazepam Mazindol Mebolazine Medazepam Mefenorex Mephentermine Mepitiostane Meprobamate Mesabolone Mesocarb Mestanolone Mesterolone Methandienone (Dianabol) Methandriol Methenolone Methyltestosterone Methyprylone Metribolone Mibolerone Midazolam (Hypnovel) Mirapront N-Ethylamphetamine Nandrolone Nimetazepam Nitrazepam Non-human chorionic gonadotrophin Norboletone Norclostebol Nordazepam Norethandrolone Ovandrotone Oxabolone Oxandrolone Oxazepam Oxazolam Oxymesterone Oxymetholone Pemoline Phendimetrazine Phentermine Pinazepam Pipradrol

C096 C097 C098 C099 C100 C101 C102 C103 C104 C105 C106 C107 C108 C109 C110 C111 C112 C113 C114 C115 C116 C117 C118 C119 C120 C121 C122 C123 C124 C125 C126 C127 C127 C128 C129 C130 C131 C132 C133 C134 C135 C136 C137 C138 C139 C140 C141 C142 C143 C144 C145 C146 C147 C148

Prasterone Prazepam Prolintane Propetandrol Propylhexedrine Pyrovalerone Quinbolone Roxibolone Silandrone Stanolone Stanozolol Stenbolone Temazepam Testosterone Tetrazepam Thiomesterone Trenbolone Triazolam 4-Hydroxy-N-Butyric Acid Zolpidem 4-Androstene-3 17-Dione 19-Nor-4-Androstene-3 17-Dione 5-Androstene-3 17-Diol 19-Nor-5-Androstene-3 17-Diol Cannabis Cannabis Resin Cannabinol Cannabinol Derivatives Ketamine GHB Gamma Hydroxybutyrat Fluoxetine Danazol Zeranol Boldione Oripavine Gestrinone Zilpaterol Danazol Prostanozol 1,4-Butanediol 1-Androstenediol 1-Androstenedione 5-Androstenedione 19-Norandrosterone Gamma-Butyrolactone Tetrahydrogestrinone 19-Norandrostenedione 19-Noretiocholanolone 5Α-Androstane-3,17-Diol Androst-4-ENE-3,17-Diol Desoxymethyltestosterone 3-Hydroxy-5Α-Androstan-17-One 1-Benzylpiperazine Derivatives 1-Phenylpiperazine Derivatives

W001 W002 W003 W004 W005 W006 W007 W008 W009 W010 W011 W012 W013 W014 W015 W016 W017 W018 W019 W020 W021 W022 W023 W024 W025 W026 W027 W028 W029 W030 W031 W032 W033 W034 W035 W036 W037 W038 W039 W040 W041 W042 W043 W044 W045 W046 W047 W048 W049 W050 WO51 WO52

Aerosol Air gun Air Rifle Axe Baseball bat Belt Blunt object Bottle Brick Shovel Cattle prod Chain Shotgun Crossbow Crowbar Explosive Firework Glass Golf club Sharp object Hammer Hand gun Screwdriver Scissors Hypodermic needle Japanese fighting sticks Knife Scaffolding pole Cosh Laser pen Rope Mace Metal pole Nanchucks Open blade razor Rifle Pick axe Piece of wood Pitch fork Cue Blow torch Helmet Stun Gun Machete Sword Metal bar Knuckleduster Imitation Firearm Truncheon Saw Footwear Ski Pole

F001 F002

FPN (Fixed Penalty Issued FPN ( FPN Issued Court Hearing Requested )

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS Notification Type DEFINITION:

A coded item used to identify the type of notification.

DATA ITEMS:

Notification

PERMISSIBLE CHARACTER SET:

Upper case alpha only.

RANGES/VALUES:

The field is 4 characters long

XML TAG-NAME: PRIMARY OWNERSHIP:

COPFS

CODES: CWN CLA VWN

Child witness notice Common law application Vulnerable witness notice

ORGANISATION NAME/COMPANY NAME DEFINITION:

The name of the subject where this is an organisation rather than an Individual person.

DATA ITEMS:

Accused Name (Company) Solicitor’s Firm Compensation – Organisation name

PERMISSIBLE CHARACTER SET:

Alphanumeric.

XML TAG-NAME: RANGES/VALUES:

The field is 100 characters long.

PRIMARY OWNERSHIP: EXAMPLES:

Common. Domestic and Catering Staffing Agency Marks & Spencer plc Littlewoods Chain Stores Ltd John Lewis Partnership

PERSONAL TITLE DEFINITION:

The title used by the subject.

DATA ITEMS:

Personal Title

PERMISSIBLE CHARACTER SET: Unrestricted. RANGES/VALUES:

The field length is 10 characters long. Where the title exceeds the field length, it should be abbreviated.

PRIMARY OWNERSHIP:

Common.

EXAMPLES:

'Mr', 'Dr', 'Sir', 'Rev', 'Professor', 'Major', etc.

PLEA DEFINITION:

The subject's plea to the charge.

DATA ITEMS:

Intended Plea Plea

PERMISSIBLE CHARACTER SET:

Upper case alpha.

RANGES/VALUES:

The field is 2 characters long.

PRIMARY OWNERSHIP:

Scottish Court Service.

CODES:

Plea No plea taken Guilty Not guilty No plea, no declaration Plea requiring additional text Plea of Competency & Relevancy Plea of Competency Plea of Relevancy Pled Guilty to Amended Charge Pled Guilty to Alternative Charge Pled Guilty Under Deletion Pled Guilty Under Insertion Breach admitted Breach not admitted Withdraw guilty prev tendered

Code NP PG NG ND PT CR PC PR PB PA PD PI BA BD WG

PLEA METHOD DEFINITION:

The method used to submit a plea to the court.

DATA ITEMS:

Plea Method Plea Representation in court How Compared

PERMISSIBLE CHARACTER SET:

Upper-case alpha.

RANGES/VALUES:

The field is 1 character long.

PRIMARY OWNERSHIP:

Scottish Court Service

CODES:

Plea submitted by:Description Absent Accused (personal appearance) Accused's Solicitor Letter Not known Other Representative Video

Code A P S L N O V

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS POLICE FORCE/STATION CODES DEFINITION:

The police force and station responsible for dealing with the case at the particular stage in question.

DATA ITEMS:

Accused Custody Location Civilian Witness Police Contact Police Force/Station Police Witness Station Code Reporting Officer Police Force

PERMISSIBLE CHARACTER SET:

Upper case alpha, numeric.

RANGES/VALUES:

The field is 4 characters long. The first 2 characters are numeric and constitute the force code. A list of valid codes, and the forces they identify, is given below. The third character is alphabetic, and the fourth character may be either alphabetic or numeric. These characters identify the relevant station within the force area. The station codes to be used are those in the PNC Combined Directory.

OWNERSHIP:

PNC

CODES:

See next page

POLICE FORCE CODES Force Dumfries & Galloway Strathclyde Lothian & Borders Fife Tayside Grampian Central Scotland Northern SCDEA SPSA Metropolitan Police Metropolitan Police

Code 70 74 76 78 80 82 84 87 90 96 01 02

British Transport Police MoD Police Cumbria Lancashire Merseyside Greater Manchester Cheshire Criminal Cases Review PO Security Northumbria Durham North Yorkshire West Yorkshire South Yorkshire RMP Provost Humberside Cleveland Dept Trade & Industry X400 Interface Broadcasts Departmental Security Unit West Midlands Staffordshire West Mercia Warwickshire PNC Hendon PNC Horseferry (Testing) PNC Testing PNC Restart terminals 1 PNC Restart terminals 2 Derbyshire Nottinghamshire Lincolnshire Leicestershire Northamptonshire Cambridgeshire Norfolk Suffolk RAF Provost NPT (Formerly CTS) Bedfordshire Hertfordshire Essex Thames Valley Hampshire Surrey Kent Sussex City of London Kent Ports Devon & Cornwall Force 51 Avon & Somerset Gloucestershire Wiltshire Dorset

93 24 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 2A 20 21 22 23 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55

Guernsey Jersey (States) Dover Harbour Board Police UKAEA North Wales Gwent South Wales Dyfed-Powys National Ports Office National Joint Unit NIS NCIS Govt Communications Force 69 Royal Navy NIS Liaison RAF Army NIS Liaison Dir Civil Nuclear DSS Bramshill Police College MoD Security Scottish Police College Inland Revenue Prison Service Customs & Excise Dept of Environment National Crime Squad NAFIS TRW DVLA Criminal Records Office Isle Of Man PSNI - Police Service Northern Ireland Criminal Records Office POLICE STATION CODES British Transport Police Aberdeen Dalmuir Dundee Edinburgh Falkirk Glasgow Inverness Kilwinning Kirkcaldy Motherwell Paisley Perth

93DJ 93DU 93DL 93DE 93DF 93DG 93DI 93DK 93DC 93DW 93DP 93DD

56 57 58 59 60 61 62 63 64 65 66 67 68 69 71 72 73 75 77 79 81 83 85 86 88 89 91 92 94 95 97 98 99

Dumfries and Galloway Annan Castle Douglas Dalbeattie Dumfries Headquarters Kirkcudbright Lockerbie Newton Stewart Sanquhar Stranraer

70AN 70CD 70DB 70DF 70HQ 70KB 70LO 70NS 70SA 70ST

Fife Constabulary Anstruther Auchtermuchty Ballingry Burntisland Cardenden Cowdenbeath Cupar Dalgety Bay Dunfermline Glenrothes Kennoway Kirkcaldy Levenmouth Newmills Newport-on-Tay Oakley St Andrews

78AN 78AU 78BA 78BU 78CA 78CO 78EA 78DB 78WE 78GL 78KW 78CE 78LM 78NM 78NT 78OA 78SA

Grampian Aberdeen (Police HQ) Moray Peterhead Stonehaven

82C1 82A1 82A3 82D1

Lothian & Borders Armadale Balerno Bathgate Blackburn Bonnyrigg Borders Traffic Broughton Broxburn Camera Unit (Edinburgh) Coldstream Corstorphine Craigmillar

76AR 76PB 76BT 76BB 76BD 76GT 76BR 76BX 76OC 76GC 76WV 76EC

Criminal Intelligence Section Dalkeith Dalkeith Traffic Drylaw Dunbar Duns Earlston Edinburgh Airport Edinburgh Traffic Eyemouth Fauldhouse Force Headquarters Galashiels Gayfield Square Gorebridge Haddington Hawick Howdenhall Innerleithen Jedburgh Kelso Lauder Leith Linlithgow Livingston Livingston Traffic Loanhead Melrose Mid Calder Musselburgh Newbattle Newcastleton North Berwick Oxgangs Peebles Penicuik Portobello Prestonpans Selkirk South Queensferry Southside St Boswells Stow Tollcross Tranent West Calder West Linton Wester Hailes Whitburn

76AC 76DK 76ET 76ND 76DB 76DU 76EA 76WA 76TE 76EY 76FH 76HQ 76GL 76CG 76GO 76HD 76HA 76SH 76IN 76JE 76KE 76LA 76NL 76LG 76LV 76FT 76LH 76ME 76MC 76MU 76NE 76NC 76NB 76PO 76PE 76PK 76EP 76PP 76SE 76WQ 76CS 76SB 76ST 76CT 76TR 76WC 76WL 76PW 76WH

Northern Constabulary

ALNESS

87DB

AVIEMORE

87GC

DINGWALL

87DA

DORNOCH

87CH

FORT WILLIAM

87FB

INVERNESS HQ

87HQ

INVERNESS (BURNETT ROAD)

87IA

KIRKWALL

87BD

LERWICK

87AB

NAIRN

87IE

PORTREE

87DC

ROAD POLICING

87RP

STORNOWAY

87ED

THURSO

87CE

WICK

87CA

LOCHMADDY

87EI

FIXED PENALTY TICKET

87HF

INFORMATION MANAGEMENT

87HR

FIREARMS LICENSING DEPT

87FL

HQ CID

87HC

Strathclyde Police

Revised Codes 2 July 2008

STRATHCLYDE POLICE OFFICE

ISCJIS CODE

Stewart Street Police Office 50 Stewart Street Glasgow G4 0HY

74AB

Anderson Police Office 945 Argyle Street Glasgow G3 8JG

74AC

Partick Police Office 609-611 Dumbarton Road Glasgow G11 6HY

74AD

Drumchapel Police Office 300 Kinfauns Drive Glasgow G15 7HA

74AE

A Division Headquarters 50 Stewart Street Glasgow G4 0HY

74AZ

London Road Police Office 851 London Road Glasgow G40 3RX

74BA

Baird Street Police Office 6 Baird Street Glasgow G4 0EX

74BC

Shettleston Police Office 1051 Shettleston Road Glasgow G32 7PE

74BD

Maryhill Police Office 1380 Maryhill Road Glasgow G20 9TX

74BE

Kirkintilloch Police Office 45 Southbank Drive Kirkintilloch G66 1XJ

74BF

B Division Headquarters 851 London Road Glasgow G40 3RX

74BZ

Govan Police Office 923 Helen Street Glasgow G52 1EE

74GA

Pollok Police Office 3 Brockburn Crescent Glasgow G53 5AF

74GB

Giffnock Police Office Braidholm Road Glasgow G46 6HA

74GC

Aikenhead Road Police Office 744 Aikenhead Road Glasgow G42 0NS

74GD

Gorbals Police Office 383 Cumberland Street Glasgow G5 0ST

74GE

Barrhead Police Office Main Street Barrhead G78 2RA

74GF

G Division Headquarters 923 Helen Street Glasgow G52 1EE

74GZ

Paisley Police Office Mill Street Paisley PA1 1JU

74KA

Johnstone Police Office Quarry Street Johnstone PA5 8DY

74KB

Greenock Police Office 160 Rue End Street Greenock PA15 1HX

74KC

Glasgow Airport Police Office St Andrews Drive Renfrew PA3 2ST

74KX

K Division Headquarters Mill Street Paisley PA1 1JU

74KZ

Ports Unit Glasgow Airport Police Office St Andrews Drive Renfrew PA3 2ST

74HA

Dumbarton Police Office Stirling Road Dumbarton G82 3PT

74LA

Oban Police Office Albany Street Oban PA34 4AJ

74LB

Clydebank Police Office 50 Montrose Street Clydebank G81 2QD

74LC

Dunoon Police Office Argyll Road Dunoon PA23 8ES

74LD

Helensburgh Police Office East King Street Helensburgh G84 7QP

74LF

Alexandria Police Office Hill Street Alexandria G83 0DU

74LG

Campbeltown Police Office Castlehill Campbeltown PA28 6AN

74LH

Lochgilphead Police Office Lochnell Street Argyll PA31 8JJ

74LL

Rothesay Police Office High Street Rothesay PA20 9AZ

74LR

L Division Headquarters Stirling Road Dumbarton G82 3PT

74LZ

Coatbridge Police Office Whittington Street Coatbridge ML5 3AD

74NA

Airdrie Police Office Anderson Street Airdrie ML6 0AA

74NB

Cumbernauld Police Office South Muirhead Road Cumbernauld G67 1AX

74NC

Bellshill Police Office 5 Thorn Road Bellshill ML4 1PB

74ND

Wishaw Police Office 100 Stewarton Street Wishaw ML2 8AG

74NE

Kilsyth Police Office Parkfoot Street Glasgow G65 0SW

74NK

Motherwell Police Office 217 Windmillhill Street Motherwell ML1 1RZ

74PA

N Division Headquarters 217 Windmillhill Street Motherwell ML1 1RZ

74NZ

East Kilbride Police Office Andrew Street East Kilbride G74 1AA

74QA

Hamilton Police Office Campbell Street Hamilton ML3 6AT

74QB

Lanark Police Office 27 Westport Lanark ML11 9HD

74QC

Rutherglen Police Office King Street Rutherglen G73 1DG

74QD

Q Division Headquarters Campbell Street Hamilton ML3 6AT

74QZ

Traffic (Ayr) c/o Road Policing Complex 433 Helen Street Glasgow G51 3HH

74TA

Traffic (Administration) c/o Road Policing Complex 433 Helen Street Glasgow G51 3HH

74TD

Traffic (Greenock) c/o Road Policing Complex 433 Helen Street Glasgow G51 3HH

74TG

Road Policing Complex 433 Helen Street Glasgow G51 3HH

74TH

Traffic (Dumbarton) c/o Road Policing Complex 433 Helen Street Glasgow G51 3HH

74TL

Traffic (Motherwell) c/o Road Policing Complex 433 Helen Street

74TM

Glasgow G51 3HH Irvine Police Office 25 Kilwinning Road Irvine KA12 8RR

74UA

Kilmarnock Police Office 10 St Marnock Street Kilmarnock KA1 1TJ

74UC

Ayr Police Office 1 King Street Ayr KA8 0BU

74UD

U Division Headquarters 10 St Marnock Street Kilmarnock KA1 1TJ

74UZ

Nationality and Special Branch Force Headquarters 173 Pitt Street Glasgow G2 4JS

74HB

Force Surveillance Unit (Drug Squad) Force Headquarters 173 Pitt Street Glasgow G2 4JS

74HD

Complaints and Discipline Force Headquarters 173 Pitt Street Glasgow G2 4JS

74HE

Fraud Squad 923 Helen Street Glasgow G52 1EE

74HF

Serious Crime Squad 923 Helen Street Glasgow G52 1EE

74HS

V Division 755 Hawthorn Street Glasgow G22 6AY

74HV

Stolen Vehicle Section Meiklewood Road Complex 91 Meiklewood Road Glasgow G51 4DU

74SV

Tayside Police Central (Dundee) Eastern (Forfar) Headquarters (Dundee) Western (Perth)

80CD 80ED 80HQ 80WD

SCDEA PNC Codes Force CENTRAL FIFE DUMFRIES AND GALLOWAY GRAMPIAN LOTHIAN AND BORDERS NORTHERN STRATHCLYDE TAYSIDE BRITISH TRANSPORT POLICE MOD POLICE

PNC CODE 90AC 90AF 90AD 90AG 90AL 90AN 90AS 90AT 90AX 90AM

POLICE OFFICER RANK CODES DEFINITION:

The police officer rank please note this includes force support officers including all police support staff such as SOCO’s etc.

DATA ITEMS:

Police Witness Rank Reporting Officer Rank

PERMISSIBLECHARACTER SET: 4 Characters Uppercase – Alpha. XML TAG-NAME:

ISCJISCore: Rank Type

PRIMARY OWNERSHIP:

Police

CODES: Rank Chief Constable Deputy Chief Constable

Code CC DCC

Assistant Chief Constable Police Constable Police Sergeant Police Inspector Chief Inspector Superintendent Chief Superintendent Detective Constable Detective Sergeant Detective Inspector Detective Chief Inspector Detective Superintendent Detective Chief Superintendent Force Support Officer Traffic Warden Special Constable (All ranks) Non Police Reporting Officer Non Police Agency Witness Police Cadet

ACC PC PS PI CI SU CS DC DSGT DI IC DSUP DCSU FSO TW SC NPRO NPAW PCAD

POSTCODE DEFINITION:

The postcode for the relevant address.

DATA ITEMS

Postcode

PERMISSIBLE CHARACTER SET:

Upper-case Alpha, numeric and space.

RANGES/VALUES:

PRIMARY OWNERSHIP:

The postcode field is 8 characters long. Only alphanumeric characters and a space are permissible in the postcode field. The format must be 2-4 alphanumeric characters(the first of them alpha), followed by 1 space, 1 numeric and 2 alpha characters. Where only the first part of a postcode is known, the field should be padded with spaces.

Common

Prejudice Incident DEFINITION:

Category used where it is considered that prejudice has been a motivating or

contributing reported.

factor with respect to the matter

DATA ITEMS:

PERMISSIBLE CHARACTER SET: RANGES/VALUES: XML TAG-NAME:

ISCJISCore: String AlphaNumeric

PRIMARY OWNERSHIP:

Common

Type Religious Racial Group Sexual Bias Disability

Code RELG RACG SEXB DISY

PREVIOUS CONVICTIONS DEFINITION:

An indication as to whether the accused has been previously convicted in a court of law.

DATA ITEMS:

Previous Convictions

PERMISSIBLE CHARACTER SET:

Alphabetic only.

RANGES/VALUES:

The field is 1 character long.

PRIMARY OWNERSHIP:

Common.

CODES:

Y = Has previous convictions N = Has no previous convictions.

Previous Juvenile Warning DEFINITION:

A coded item used to identify the type of Previous Juvenile Warning.

DATA ITEMS:

Previous Juvenile Warning

PERMISSIBLE CHARACTER SET:

Upper case alpha only and numeric.

RANGES/VALUES:

The field is 4 characters long

XML TAG-NAME: PRIMARY OWNERSHIP:

ISCJISCore: Prev Juv Warn Type Police/SCRA

CODES: 0000 W000 W001 W002 W003 W004 W005 W006 W007 W008 W009 W010 W011 W012 W013 W014 W015 W016 W017 W018 W019 W020 W021 W022 W023 W024 W025 W026 W027 W028 W029

NOT KNOWN NO PREVIOUS WARNINGS 1 PREVIOUS WARNING 2 PREVIOUS WARNINGS 3 PREVIOUS WARNINGS 4 PREVIOUS WARNINGS 5 PREVIOUS WARNINGS 6 PREVIOUS WARNINGS 7 PREVIOUS WARNINGS 8 PREVIOUS WARNINGS 9 PREVIOUS WARNINGS 10 PREVIOUS WARNINGS 11 PREVIOUS WARNINGS 12 PREVIOUS WARNINGS 13 PREVIOUS WARNINGS 14 PREVIOUS WARNINGS 15 PREVIOUS WARNINGS 16 PREVIOUS WARNINGS 17 PREVIOUS WARNINGS 18 PREVIOUS WARNINGS 19 PREVIOUS WARNINGS 20 PREVIOUS WARNINGS 21 PREVIOUS WARNINGS 22 PREVIOUS WARNINGS 23 PREVIOUS WARNINGS 24 PREVIOUS WARNINGS 25 PREVIOUS WARNINGS 26 PREVIOUS WARNINGS 27 PREVIOUS WARNINGS 28 PREVIOUS WARNINGS 29 PREVIOUS WARNINGS

W030 W031 W032 W033 W034 W035 W036 W037 W038 W039 W040 W041 W042 W043 W044 W045 W046 W047 W048 W049

30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49

PREVIOUS PREVIOUS PREVIOUS PREVIOUS PREVIOUS PREVIOUS PREVIOUS PREVIOUS PREVIOUS PREVIOUS PREVIOUS PREVIOUS PREVIOUS PREVIOUS PREVIOUS PREVIOUS PREVIOUS PREVIOUS PREVIOUS PREVIOUS

WARNINGS WARNINGS WARNINGS WARNINGS WARNINGS WARNINGS WARNINGS WARNINGS WARNINGS WARNINGS WARNINGS WARNINGS WARNINGS WARNINGS WARNINGS WARNINGS WARNINGS WARNINGS WARNINGS WARNINGS

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS PRISON DEFINITION:

The prison establishment having control of the subject at the material time.

DATA ITEMS

Penal Establishment Place of Detention

PERMISSIBLE CHARACTER SET:

Upper-case alpha only.

RANGES/VALUES:

The field is 2 characters long. In the event of the data item being transmitted to a location outwith the Scottish criminal justice system, the addition of a further 2 characters to the 2 character codes listed overleaf will comply with the standards of both the IBIS and PHOENIX systems. The two characters are:- (a) a third character X, for all except the Special Units at Barlinnie and Shotts, for which the third character is S and (b) a fourth character S for Scotland/ Scottish.

PRIMARY OWNERSHIP:

Scottish Prison Service.

CODES:

See prison codes.

PRISONER ABSENCE/MOVEMENT REASONS DEFINITION:

A reason for a prisoner being absent/moved from prison.

PERMISSIBLE CHARACTER SET:

Any alpha, numeric.

RANGES/VALUES:

The field is 50 characters long.

PRIMARYOWNERSHIP:

SPS

Movement Categories ID CATEGORY EXT : External Movement

TMP: Temporary Absence Movement Types. MOVEMENT TYPE ID 1 2 3 4 5 6 7 8 9 11 15

DESCRIPTION Court Productions Establishment Transfers Liberations Liberation to Court Other Temporary Absence Out of Estate Transfers Placement To Police Custody Unlawfully at Large HDC Release UAL following HDC Breach

CATEGORY TMP EXT EXT EXT TMP EXT TMP TMP TMP EXT EXT

Movement Reasons MOVEMENT REASON ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 25 26

DESCRIPTION Court Court Must Return Civil Court Case Home Leave - 48 Hours Home Leave - 5 Days Accumulated Visits Criminal Injuries Board Hospital Education Marriage Escaped Funeral Pre Parole Leave Children's Panel Placement Compassionate Leave (Escorted) Compassionate Leave (Unescorted) Compassionate Visit (Escorted) Compassionate Visit (Unescorted) Sels Temporary Licence ID Parade Cross Border Transfer Mental Hospital - Section 70 Mental Hospital - Section 71

MOVEMENT TYPE ID 1 1 1 5 5 5 5 5 5 5 9 5 5 5 7 5 5 5 5 5 5 5 5 5 5

27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72

Absconder Industrial Tribunal Community Work Employment Interview Medical - Dentist Medical - Optician Medical - Chiropodist Medical - Physiotherapist Medical - Other TFF Parole Licence Revoked Recreation Inter Prisoner Visit Interim Liberation Bail Summer Leave Transfer Out Accum. Visits X-Border Trans. Hospital Mental Hospital Lib On Appeal Lib From Court Lib On Parole Lib Fine Paid Lib Sent. Exp. Lib To Interlib Lib To List D Repatriation Pardon Proc. Fiscal Lib Imm. Author Police Int'view Lib To S.R.O Lib Dungavel DC To Bail Deported Deceased Fail To Return Lib On Licence Local Authority Court Due to Recall ID Parade Questioning Duplicate Record

9 5 5 5 5 5 5 5 5 5 5 5 5 9 1 5 2 2 6 6 6 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 4 10 8 8 3

73 74 75 76 77 78

3 Day Home Leave Lib To Mental Hosp Police Interview Temporary Transfer Bail Hearing HDC Breach

PRISON CODES Prison codes

CODES: HM Prison Aberdeen Addiewell Barlinnie Kilmarnock CorntonVale Dumfries Dungavel (Closed) Edinburgh Friarton Glenochil Greenock Inverness Low Moss (Closed) Noranside (Closed) Open Estate Penninghame Perth Peterhead Shotts

Code AB AW BA KM CV DF DG ED FR GO GR IN LO NA OE PH PR PE SO

HMYOI Castle Huntly (Closed) Glenochil (Closed) Cornton Vale Polmont Brightons

Code CA GO CV PL

5 3 5 2 5 15

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS PRISON CODES – IBIS AND PHOENIX Institution Aberdeen Addiewell Barlinnie Barlinnie Special Unit Castle Huntly (Closed) Cornton Vale Dumfries Dungavel (Closed) Edinburgh Friarton Glenochil (Closed) Greenock Inverness Kilmarnock Longriggend (Closed) Low Moss (Closed) Noranside (Closed) Open Estate Penninghame (Closed) Perth Peterhead Polmont Brightons Shotts Special Unit (Closed)

Code ABXS AWXS BAXS BASS CAXS CVXS DFXS DGXS EDXS FRXS GOXS GRXS INXS KMXS LRXS LOXS NAXS OEXS PHXS PRXS PEXS PLXS SOSS

PROCURATOR FISCAL DEFINITION:

The Procurator Fiscal's office responsible for dealing with the case.

DATA ITEMS

PF Office

PERMISSIBLE CHARACTER SET:

Upper-case alpha.

RANGES/VALUES:

The field is 2 characters long.

PRIMARY OWNERSHIP:

Crown Office.

CODES:

See next page.

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS PROCURATOR FISCAL CODES CODES: PF Office Aberdeen Airdrie Alloa Arbroath Ayr Banff Campbeltown Cupar Dingwall Dornoch Dumbarton Dumfries Dundee Dunfermline Dunoon Duns East Kilbride District Edinburgh Edinburgh Edinburgh Edinburgh Elgin Falkirk Forfar Fort William Glasgow Glasgow District Glasgow Office A Glasgow Office C Glasgow Office E Glasgow Office G Greenock Haddington Hamilton Hamilton District Inverness Jedburgh Kilmarnock Kirkcaldy Kirkcudbright Kirkcudbright Old Kirkintilloch District Kirkwall Lanark Lerwick Linlithgow

Code AB AI AL AR AY BA CM CU DI DO DB DF DN DR DU DS HE ED EC ES EW EL FA FO FW GL GD GA GC GE GG GR HA HM HD IN JE KM KC KS KB GK KW LN LE LI

Lochmaddy Monklands District Motherwell District Oban Paisley Peebles Perth Peterhead Portree Rothesay Selkirk Stirling Stonehaven Stornoway Stranraer Tain Wick

LO AM HW OB PA PE PR PT PO RO SE ST SH SW SR TA WI

Others Crown Office National Casework Division - Private National Casework Division Health and Safety Division

Code CO CP NC HS

PROCURATOR FISCAL REFERENCE NUMBER DEFINITION:

The case identification number created on the PF's PROMIS system and attached to that individual case.

DATA ITEMS:

Case Reference Number (PF Reference Number)

PERMISSIBLE CHARACTER SET:

RANGES/VALUES:

Alpha-numeric. Two alpha characters representing the Fiscal's office generating the code. The field is 10 characters long and is comprised of

Positions 1 and 2 the location of the PF system that generated the number. Positions 3 and 4 represent the year that the number was generated.

Positions 5 to 10 represent the fiscal sequence number. PRIMARY OWNERSHIP:

Crown Office

EXAMPLE:

AB99123456

PRODUCTION TYPE DEFINITION:

The codes used to identify productions. Please Note the longer list of codes below is for use internally by COPFS ONLY.

DATA ITEMS:

Production Types

PERMISSIBLE CHARACTER SET:

Alpha-characters.

RANGES/VALUES:

The field is up to 4 characters long.

Codes used in SPR2 for STANDARD PRODUCTIONS are:DOCS LABL

Documentation Label

The Following production codes are used internally by COPFS only FORN COMP CLOT DRGS MONY WPON VIDT ANML VCLS FDRK AMMO MEDA CC ARMS HHLD AUDT BHZD PERS MEDL MEDD

FORENSIC COMPUTERS CLOTHING DRUGS MONEY WEAPON VIDEO TAPE LIVESTOCK VEHICLES FOOD/DRINK AMMUNITION MEDIA CONVERSION FIREARMS HOUSEHOLD AUDIO TAPE BIO HAZARD PERSONAL EFFECTS MEDICAL LABEL MEDICAL DOCUMENT

PICS RDCT WS WPC CD DRPA DVD

PHOTOGRAPHS REDACTED DOCUMENT WITNESS STATEMENTS WITNESS PRODUCTIONS Compact Disc Drug Paraphanelia Digital Video Disc

REPORTING OFFICER DEFINITION:

The unique Police Officer identifier.

DATA ITEMS:

Reporting Officer.

PERMISSIBLE CHARACTER SET:

Alphanumeric.

XML TAG-NAME:

ISCJISCore: Officer URN Type

RANGES/VALUES:

Reporting officer is 10 characters – first 3 = police division and remaining 7= unique number 10 characters

PRIMARY OWNERSHIP:

Police

RESCHEDULED REASON DEFINITION:

A reason for rescheduling a court appearance.

PERMISSIBLE CHARACTER SET:

Upper-case alpha, numeric.

RANGES/VALUES:

The field is 4 characters long.

PRIMARY OWNERSHIP:

Crown Office / SCS

CODES:

Code AALA AFTA ANBC CFTA CMON ECWA DMON EDWA ILAC ILCO IPTC IPTD JOIN LANG LOCT MPRD TECP POFB JMON EXPM STOUT SWRQ NCOW

Allow accused to get legal advice Accused failed to attend Acc not brought from custody Co-accused failed to attend Crown motion Essential crown witness absent Defence motion Essential defence wit. Absent Illness of accused Illness of co accused Inadequate prepare time crown Inadequate prepare time def On joint motion Legal aid not granted Lack of court time Missing productions Technical problems Pressure of business Joint minute Ex proprio motu For outcome of sheriff court case Social work request No citation of witness

RESPONSIBLE PERSON TYPE DEFINITION:

Applied For individuals who are required to assist the witness in providing their statements to the police and in providing evidence in court.

DATA ITEMS: PERMISSIBLE CHARACTER SET: Alphabetic, space, apostrophe, hyphen. RANGES/VALUES:

XML TAG-NAME:

ISCJISCore: Responsible Person

PRIMARY OWNERSHIP:

Common

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS

Category Parent/Guardian Appropriate Adult Social Worker Carer

Code PG AA SW CR

RESULT PERMISSIBLE CHARACTER SET:

Code field. Alpha, numeric

RANGES/VALUES:

The code field is 4 characters long and consists of an alpha numeric code which identifies the Result

PRIMARY OWNERSHIP:

Common

Code A B C CONV D E F G H I J K M N O P Q R S T U V

Result CONTINUED CONTINUED WITHOUT PLEA DEBATE CONVERSION DEFERRED D.P.L.E.T. NOT CALLED INTERMEDIATE DIET APPLICATION GRANTED APPLICATION REFUSED LIBERATE PRIOR TO FC REMIT TO CHILDRENS PANEL EXAMINATION OF THE FACTS CONT FURTHER EXAM BAIL CONT FURTHER EXAM CUSTODY PETITION BAIL GRANTED PRE FULL COMMITTAL REMIT TO HIGH COURT TRIAL AND SENTENCE DEFFERED TRIAL BAIL GRANTED POST FULL COMMITTAL REMIT TO SHERIFF COURT

W X Y Z APHW PRVY

WARRANT FULL COMMITAL BAIL FULL COMMITAL CUSTODY FINAL APPEAL HEARING WITHDRAWN PRIVY COUNCIL

SCRA Document Type

PAGE/SECTION

AMENDMENT

Front Cover

Change Version to 1.8 (2 places)

Version Control Page 2 DOCUMENT TYPE

Section 3 – Add version 1.8, Date 14 October 2008 Amendment to the Document Type was agreed at the 33rd meeting of JSITS held on 25th September 2008.

SCRA Office Type

Add a new document type of ‘DA - Defence Agent’ to the agreed code list. See Annex A attached Addition to the data standard as agreed at JSITS 25th September 2008. This section is to be inserted between ‘RESULT’ and ‘SENT TO’ data standards. See Annex B attached.

Annex 9 - DEVELOPMENT OF DOCUMENT HEADERS FOR RETURN DATA TO ISCJIS PARTNERS

Add the following text to the bottom of this page: OUTGOING FILES TO SCRA This replicates the COPFS implementation of their 2 digit office code. The ISCJIS Email Header, for SPR Reports, is currently constructed in two elements (i.e. OODOC) where:OO = A valid Procurator Fiscal Office code; DOC = A valid ISCJIS Document Type SCRA will use the OO for sending to a valid SCRA Office. Therefore to decipher whether the code relates to a COPFS office or an SCRA office it will be necessary to examine the ‘Sent to’ field of the email. This obviously means that when the when there is a ISCJIS Core: Sent To Type of ‘Joint’ or ‘Both’, two separate SPR2s must be produced each with the appropriate ISCJIS Email Header. Examples Email sent to COPFS only A Sheriff Custody Report to be sent to COPFS City of Aberdeen Office only will require the following ISCJIS Email Header ABSCR Where AB will be the 2 digit code for the COPFS City of Aberdeen office ISCJIS Core: Sent To Type : Fiscal Email sent to SCRA only A Youth Custody Report to be sent to SCRA City of Aberdeen office only will require the following ISCJIS Email Header 22YCR Where 22 is the 2 digit code for the SCRA City of Aberdeen office (as indicated in the 2 digit codes above) ISCJIS Core: Sent To Type: SCRA Email sent to SCRA and COPFS A Standard Prosecution report relating to a City of Aberdeen case, which has the accused as both an adult and a juvenile, then two distinct SPR2’s are required to be sent. 1) The report sent to COPFS City of Aberdeen Office only will require the following ISCJIS Email Header

ABSPR Where AB will be the 2 digit code for the COPFS City of Aberdeen office ISCJIS Core :Sent To Type: Both (or could be joint) 2) The report sent to SCRA City of Aberdeen Office only will require the following ISCJIS Email Header 22SPR Where 22 is the 2 digit code for the SCRA City of Aberdeen office ISCJIS Core: Sent To Type: Both (or could be joint)

Document Type DEFINITION:

Types of Documents.

DATA ITEMS:

Listed below

PERMISSIBLE CHARACTER SET: RANGES/VALUES:

The field is up to 3 characters

PRIMARY OWNERSHIP:

Common

CODES: CODE Document Type SPR

Sheriff Prosecution report

SUR

Sheriff Undertaking Report

SCR

Sheriff Custody Report

SWR

Sheriff Warrant Report

YPR

Youth Prosecution Report

YUR

Youth Undertaking Report

YCR

Youth Custody Report

YWR

Youth warrant report

DPR

District Prosecution Report

DUR

District Undertaking Report

DCR

District Custody Report

DWR

District Warrant Report

Subject Report

Production Report

Witness Report

Witness Statement

Memo Report

Occurrence Report

Death Report

Previous Conviction

COM

Summary Complaint

PET

Petition

IND

Indictment

Let

Letter

BAI

Bail Order

FFL

Fiscal Fine Letter

SER

Social Enquiry Report

Defence Agent

Annex B SCRA Office Type DEFINITION:

Code lists for SCRA Offices.

DATA ITEMS:

Listed below

PERMISSIBLE CHARACTER SET:

Numeric

RANGES/VALUES:

The field is up to 2 characters

PRIMARY OWNERSHIP:

SCRA

CODES: Region Central West

SCRA Destination Electronic Mail Box Names Stirling Clackmannan Falkirk South Lanarkshire North Lanarkshire A North Lanarkshire B South Ayrshire North Ayrshire East Ayrshire D&G - Dumfries D&G - Stranraer

E-mail Box Team Code 01 02 03 04 05 06 07 08 09 10 11

East

Angus Dundee East Lothian Midlothian West Lothian Edinburgh Perth & Kinross The Scottish Borders Fife

12 13 14 15 16 17 18 19 20

North

Aberdeenshire City of Aberdeen Highland - Inverness Highland - Thurso Moray Orkney Shetland Western Isles

21 22 23 24 25 26 27 28

West

Glasgow East Dunbartonshire East Renfrewshire Renfrewshire West Dunbartonshire Argyll & Bute - Lochgilphead Argyll & Bute - Helensburgh Inverclyde

29 30 31 32 33 34 35 36

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS SENT TO DEFINITION:

This is used to identify which agencies the police have submitted SPR to.

PERMISSIBLE CHARACTER SET:

Alphabetic only. Upper-case alpha, numeric.

RANGES/VALUES:

String

XML TAG NAME

ISCJIS Core: Sent To Type

PRIMARY OWNERSHIP

Common

CODES:

Fiscal SCRA Joint Both

SENTENCE TYPE DEFINITION:

The type of sentence.

PERMISSIBLE CHARACTER SET:

Upper-case alpha, numeric.

RANGES/VALUES:

The field is 4 characters long.

PRIMARY OWNERSHIP: CODE: CUMU INDV REPD

CUMULATIVE INDIVIDUAL REPEATED

Crown Office.

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS SHOULDER NUMBER DEFINITION:

The identifying shoulder number for a police officer.

DATA ITEMS:

Police officer shoulder number. Police Witness Shoulder Number Reporting Officer Shoulder Number Supervising officer Shoulder Number

PERMISSIBLE CHARACTER SET:

Alphanumeric

XML TAG-NAME:

ISCJISCore: Shoulder Number Type

RANGES/VALUES:

The maximum string length is 6 characters.

PRIMARY OWNERSHIP:

Police

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS SUBSTANCE DEFINITION:

A coded item used to identify the type of substance.

DATA ITEMS:

substance

PERMISSIBLE CHARACTER SET:

Upper case alpha only.

RANGES/VALUES:

The field is 4 characters long

XML TAG-NAME: PRIMARY OWNERSHIP:

ISCJISCore: Substance Type SCRA

CODES: NONE UNDT CMBI ALUN FUOA OUOA DRUN FUOD OUOD INUN FUOI OUOI

None Undetermined Combination Alcohol unknown Frequent use of alcohol Occasional use of alcohol Drugs unknown Frequent use of drugs Occasional use of drugs Inhalant unknown Frequent use of inhalant Occasional use of inhalant

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS SUBJECT REFERENCE NUMBER DEFINITION:

The unique personal identification number created at SPSA in respect of every individual accused person and recorded on every police report relevant to that accused person.

DATA ITEMS:

Subject Reference identifier)

Number

(SPSA

personal

PERMISSIBLECHARACTER SET: Upper-case alpha, oblique and numeric. RANGES/VALUES:

The field is 11 characters long and comprises the letter S, a six digit number, oblique, a twodigit number representing the year, and a check character. Algorithm available on request.

XML TAG-NAME:

ISCJISCore: SCRO No Type

PRIMARY OWNERSHIP:

Scottish Police Services Authority

EXAMPLE:

S003524/92E

CONVERSION CHART Remai nder

1 0 K

1 1 L

1 2 M

1 3 N

1 4 P

1 5 Q

1 6 R

1 7 T

1 8 U

1 9 V

2 0 W

2 1 X

2 2 Y

0 Z

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS SUBJECT STATUS DEFINITION: proceedings.

The

accused's

status

during

DATA ITEMS:

Remand Status Continuation Status Mental Condition Scheduled Appearance Type

PERMISSIBLE CHARACTER SET: Alphabetic only. XML TAG-NAME:

ISCJISCore: Status Type

RANGES/VALUES:

The field is 2 characters long.

PRIMARY OWNERSHIP:

Scottish Court Service

CODES:

Status

Code

Remand In custody Bail Bail continued Bail Refused Bail Revoked Ordained In care Reported Not applicable (company)

CU BA BC BR RV OR IC RE NA

Mental Disorders Mental illness Mental handicap Illness & Handicap

MI MH IH

Unruly Reasons Depraved

Unruly

any

court

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS SURNAME DEFINITION: LIST OF EXAMPLES:

The surname of the relevant person.

Accused Surname Alias Surname Civilian Witness Surname Civilian Witness Alias Surname Clerk of Court Compensation – Victim Surname Filename PF Depute Surname Police Witness Surname Reporting Officer Surname Responsible person Sheriff Surname Solicitor’s Name

PERMISSIBLE CHARACTER SET:

Alphabetic, space, apostrophe, hyphen.

XML TAG-NAME:

ISCJISCore: Surname Type

RANGES/VALUES:

The field is 30 characters long.

PRIMARY OWNERSHIP:

Common

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS TELEPHONE NUMBER DEFINITION:

The number and associated details of the telephone concerned.

This includes fax number. DATA ITEMS:

Telephone Number Civilian Witness Mobile Telephone Number Civilian Witness Telephone Number

PERMISSIBLE CHARACTER SET:

Numeric, hyphen, literals "EXT".

XML TAG-NAME:

ISCJISCore: Telephone Type

RANGES/VALUES:

The field is up to 22 characters long.

PRIMARY OWNERSHIP:

Common

TEXT DEFINITION:

Used for simple text fields.

DATA ITEMS:

Accused Additional Needs Civilian Witness Additional Needs Civilian Witness Occupation Crime/Offence Date Range Qualifier Crime/Offence Variable Text Domestic Abuse Juvenile Present Domestic Abuse Location Domestic Abuse Other Agencies Domestic Abuse Perpetrator Domestic Abuse Victim Advice Domestic Abuse Victim Injuries Behaviour Home Condition Liaison Officer Recommendation PF Referral Reason Previously Family Known Previously Known School

Police Witness Additional Needs Prejudice Incident Impact Complainer Prejudice Incident Impact Complainer Community Prejudice Incident Impact Complainer Family Production Description Production Location Production Owner Production Remarks Summary Analysis Summary Caution Charge Summary Event Description Summary Further Enquiries Summary Interview Summary Locus Description Summary Medical Evidence Summary Remarks Bail Summary Remarks General PERMISSIBLE CHARACTER SET: No restrictions, any strings permitted. RANGES/VALUES:

Field length is given in the index entry for a respective data item eg: “TEXT (500)” would represent a text field that is a maximum of 500 characters in length. This definition carries an implied minimum length of zero characters. If a field has a non-zero minimum length, then the field length range is given instead, ie; “TEXT (1-500)” for example.

PRIMARY OWNERSHIP:

Common

TIME DEFINITION:

The time of the event in question.

DATA ITEMS:

Detention Period Scheduled Court Time

PERMISSIBLE CHARACTER SET:

Numeric only.

RANGES/VALUES:

The field is 4 characters long.

The time prevailing at the time and place of the event in question should be entered using the 24 hour format. Midnight should be recorded as either 2359 or 0001, and not as 2400 or 0000. When we move to XML the new standard will be hh:mm:ss

VEHICLE REGISTRATION MARK DEFINITION:

The identifying mark issued by the relevant licensing authority which is required to be displayed on the vehicle in question.

DATA ITEMS:

Vehicle Registration Number.

CHARACTER SET:

Upper-case alpha, numeric, space.

RANGES/VALUES:

The field is 11 characters long. The mark should be recorded as shown on the vehicle or relevant documentation, but with any spaces tripped out.

Example:-

UXS 538 J should be transmitted as UXS538J.

PRIMARY OWNERSHIP:

DVLA

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS VERDICT DEFINITION:

The adjudication of a court in respect of proceedings taking against the subject.

DATA ITEMS:

Verdict.

PERMISSIBLE CHARACTER SET:

Upper-case alpha only.

RANGES/VALUES:

The field is 3 characters long.

PRIMARY OWNERSHIP:

Scottish Court Service

CODES: Verdict Pled Guilty Pled Guilty to Amended Charge Pled Guilty to Alternative Charge Pled Guilty under Deletion Pled Guilty under Insertion Then Pled Guilty Found Guilty Found Guilty under Deletion Found Guilty under Insertion Breach not established Found Guilty Amended Found Insane Found Not Guilty Found Not Proven Deserted pro loco et tempore Deserted simpliciter Acquitted Dismissed Not Called Accepted Not Guilty Declaration No Plea or Declaration Breach Established Fixed penalty paid Fine Unpaid WARNING

Code Courts PLG PGT PGA PGD PGI TPG FDG FGD FGI BNE FGT INS FNG FNP DPL DSP ACQ DIS NCD ANG DEC NPD BE PAD FUD WARN

Fiscal Fines Pending Cheque Clearance Fine Paid Fine Unpaid Withdrawn Non DVLA Driving Licence Refused Deemed acceptance Recalled Too many points Deemed Acceptance Letter Fine Rejected – ASBO’s only FAD Address Changes Unused Draft Indictment Charge Charge Added in Error

FCC FPD FUD FWD FDL FRF FDA FRC FPT DAL FRJ FAD UNSD DUFF

Vulnerability DEFINITION: DATA ITEMS: PERMISSIBLE CHARACTER SET:

Alphanumeric

RANGES/VALUES:

The field is 4 characters long.

XML TAG-NAME:

ISCJISCore:

PRIMARY OWNERSHIP:

Common

Code

Description

CHLD VULN 0000 0001

Child Vulnerable None Vulnerability assessed by the Police no special measures required No special measures required after COPFS review No special measures required after self referral

0002 0003

VRCO

No vulnerability assessed by the Police, COPFS review No vulnerability assessed by the Police, special measures required following COPFS review Self referral, COPFS review Self referral special measure required after COPFS review

VCSP

VRSP VCSR

Vulnerability Specific Type (VST)

DEFINITION:

The Vulnerability Specific Type conveys additional information is does not replace existing vulnerability field. The given name of the relevant person.

DATA ITEMS:

Civilian Witness Victim

PERMISSIBLE CHARACTER SET: Alphabetic, space, apostrophe, RANGES/VALUES:

XML TAG-NAME:

ISCJISCore:

PRIMARY OWNERSHIP:

Common

Categories Code ORIE AGED LEAR MHIS SENS PHYS OTHE VIST

Sexual Age Learning Difficulty Mental Health Issues Sensory Disability Physical Disability Other Vulnerability Victim/Witness of Sex offence

New Case Categories for SPR2

Code Description AD

Advice & Direction - Sexual

Advice & Direction - Non - Sexual

WITNESS NUMBER DEFINITION:

Witness Number.

DATA ITEMS:

Civilian Witness Number (within the complaint) Police Witness Number (within the complaint)

PERMISSIBLE CHARACTER SET:

Numeric

XML TAG-NAME:

ISCJISCore: Item Number Type

RANGES/VALUES:

1-99999

PRIMARY OWNERSHIP:

Common.

WITNESS TYPE DEFINITION:

Witness Type.

DATA ITEMS:

Civilian Witness Type Police Witness Type Professional/Expert/Official Witness

PERMISSIBLE CHARACTER SET:

Alphanumeric

RANGES/VALUES:

One of the codes given below.

PRIMARY OWNERSHIP:

Common.

CODES: CODE CIVI PEOW POLC POLX

Description Civilian Professional/Expert/Official Police Inactive relates to Police Witness outwith reporting force

WORK ORDER TYPE DEFINITION:

A coded item used to identify the type of Work Order being submitted to the Procurator Fiscal..

DATA ITEMS:

Work Order Type

PERMISSIBLE CHARACTER SET:

Upper case alpha only.

RANGES/VALUES:

The field is 4 characters long

XML TAG-NAME:

ISCJISCore:

PRIMARY OWNERSHIP:

COPFS

CODES: Code WO10 WO20 WO30 WO40 WO50

WorkOffer/Order WorkOffer/Order WorkOffer/Order WorkOffer/Order WorkOffer/Order

10 20 30 40 50

Hours Hours Hours Hours Hours

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS YES/NO FLAG DEFINITION:

Used to indicate flag status of some condition.

Data Items:

Accused Sex Offender’s Register Civilian Witness Hostile Witness Flag Crime/Offence Warning Police Witness Liaison Officer Prejudice Incident Flag Prejudice Incident Interpreter

PERMISSIBLE CHARACTER SET:

Alphanumeric.

XML TAG-NAME:

ISCJISCore: Yes/No Type

RANGES/VALUES:

“Y” or “N” only.

PRIMARY OWNERSHIP:

Common.

ANNEXES Annex 1 - COURT RESULT DATA EXCHANGE 1.

COURT DATA COPLINK FILES SENT FROM SCS

Record 1 – Court Details JSITSREF: CX001 Description

Data Type

Length

Value 1

Record Identifier

SCRO Number

Alphanumeric

Agency Reference Number

Alphanumeric

Case Number

Alphanumeric

Subject Sequence Number

Alphanumeric

Scheduled Appearance Date

Date

Alphanumeric

Scheduled Court Type ( Appearance Type)

Comments

Description

Data Type

Length

Result

Alphanumeric

Plea Method

Alphanumeric

Bench ID

Alphanumeric

Depute

Alphanumeric

Information (Custody Date)

Alphanumeric

Evidence Type

Alphabetic

Alphanumeric

Alphabetic

Bail Text

Alphanumeric

500

Court Room Number

Alphanumeric

Rescheduled Reason Rescheduled Indicator

Comments

“Y” if rescheduled reason given

Record 2 – Charge Details JSITSREF: CX002 Description

Data Type

Length

Value 2

Comments Record Identifier

SCRO Number

Alphanumeric

Incident Number

Alphanumeric

Integer

Alphanumeric

Integer

Case Number

Alphanumeric

Subject Sequence Number

Alphanumeric

Plea

Alphanumeric

Date

Must be completed if plea taken

Disposal Aggravation

Alphanumeric

Changed from 2 - 6

Disposal Charge

Alphanumeric

Disposal Modifier

Alphanumeric

Complaint Number Charge Priority Number Charge Sequence Number

Plea Date

Result Indicator Disposal Date Closed Verdict Verdict Date

Alphabetic

Alphanumeric

Date

Alphanumeric

Date

“Y” or Blank Must be completed if Disposal given Must be completed if verdict given

Record 3 – Sentence Record JSITSREF: CX003 Description Data Type Length Value 3

Comments

Record Identifier

SCRO Number

Alphanumeric

Incident Number

Alphanumeric

Integer

Alphanumeric

Integer

Case Number

Alphanumeric

Subject Sequence Number

Alphanumeric

Date

Cumulo

Alphanumeric

Disposal

Alphanumeric

Detention/ Order Type

Alphanumeric

Years/ Months/ Days / Hours

Integer

Amount of detention

Years/ Months/ Days / Hours Type

Alphanumeric

Type of detention

Consecutive/Concurr ent

Alphabetic

Disqualified Years/ Months/ Days

Integer

Amount of disqualification

Disqualified Years/ Months/ Days

Alphanumeric

Type of disqualification

Real

9.2

Alphanumeric

Additional Amount

Real

9.2

Alternate Months / Alternate Days

Integer

Alternative period detention

Alternate Months / Alternate Days

Alphanumeric

Type of alternative detention

Complaint Number Charge Priority Number Charge Sequence Number

Sentence Date

Fine Amount Additional Type

Penalty Points

Alphanumeric

Forfeiture Description

Alphanumeric

120

Sentence Note

Alphanumeric

500

25.02.2000

Record 4 – Scheduled Court Appearance Record JSITSREF: CX004 Description

Data Type

Length

Value 4

Comments Record Identifier

SCRO Number

Alphanumeric

Agency Reference Number

Alphanumeric

Case Number

Alphanumeric

Subject Sequence Number

Alphanumeric

Scheduled Appearance Date

Date

Time

Alphanumeric

Scheduled Court Appearance

Alphanumeric

Court Room Number

Alphanumeric

Court ID

Alphanumeric

List Number

Alphanumeric

Changed from 4 to 5

Data from Court – Bail Details Record 7 JSITSREF: CX005 Description

Data Type

Length

Comments

Court Details Value 7

Record Identifier

SCRO Number

Alphanumeric

Agency Reference Number

Alphanumeric

Police Case Reference / Lead Incident No

Case Number

Alphanumeric

PF Reference No

Subject Sequence Number

Alphanumeric

Scheduled Appearance Date

Date

Date Bail granted / amended

Scheduled Court Type ( Appearance Type)

Alphanumeric

Court Type ie (10, 15 etc)

Result

Alphanumeric

Null

Plea Method

Alphanumeric

Present absent etc

Bench ID

Alphanumeric

Currently 0000

Depute

Alphanumeric

PF depute no.

Information

Alphanumeric

BAIL or BAIL CONTINUED

Alphabetic

Null

Alphanumeric

As above

Alphabetic

As above

Alphanumeric

500

Evidence Type Rescheduled Reason Rescheduled Indicator Bail Text

Extra conditions of Bail

Description

Data Type

Length

Court ID

Alphanumeric

Accused Bail address 1

Alphanumeric

}Only inserted if address

Accused Bail address 2

Alphanumeric

}different from the address

Accused Bail address 3

Alphanumeric

}on the

Accused Bail address 4

Alphanumeric

}complaint

Accused Bail Post Code

Alphanumeric

Comments Court room in which the case called Changed from 4 to 5

COURT DATA COPLINK FILE SENT FROM COPFS

Record 0 - Header File JSITSREF: CX006 Description Data Type Length Comments Value 0 Court/ Alphanumeric 5 Council/PF ID Date

Date

Time

Alphanumeric

Record 1 Description Value 1

Case Details JSITSREF: CX007 Comments Data Type Length Record Identifier

Agency Reference Number

Alphanumeric

Complaint Number

Integer

Alphanumeric

Date

Time

Alphanumeric

Scheduled Appearance Type

Alphanumeric

Depute

Alphanumeric

Case Number Scheduled Appearance Date

Court ID

Alphanumeric

Court Type

Alphanumeric

Court Room Number

Alphanumeric

SCRO Extract JSITSREF: CX008 Description Data Type Length Value 1 Agency Reference Number

Alphanumeric

Complaint Number

Integer

Alphanumeric

Date

Case Number Scheduled Appearance Date Time

Alphanumeric

Scheduled Appearance Type

Alphanumeric

Court ID

Alphanumeric

Record 2

Data Type

SCRO Number

Alphanumeric

Agency Reference Number

Alphanumeric

DVLA Number

Alphanumeric

Case Number

Alphanumeric

Subject Sequence Number

Integer

Subject Priority Number

Integer

Subject Forenames

Alphanumeric

minOccurs="0"/> minOccurs="0"/> minOccurs="0"/>

Annex 5 - PROTOCOL FOR THE ISSUE OF NEW CHARGE CODES AND STYLES. Circ*mstances in which a new ISCJIS code can be requested A request for a new ISCJIS charge code must only be made if the new code is required for an entry under ISCJIS into an information management system either to record a crime made known or when an SPR is generated for onward transmission to another Criminal Justice agency. New codes must not be requested unless there is a specific need. If circ*mstances justify, a request for a new code may be dealt with under a “fast track” procedure, described separately below. “Fast track” procedures will only be justified in cases, which are “Custody”, “Undertaking” or “Time Bar”. NORMAL PROCEDURES Action of Crown Office on receipt of request for new ISCJIS code REQUESTS FOR NEW “CODES” OR “STYLES” SHOULD BE SUBMITTED TO THE DOCUMENT ADMINISTRATOR AT CROWN OFFICE. IDEALLY THE REQUEST SHOULD BE SENT BY E-MAIL TO [emailprotected] (IF E-MAIL IS UNAVAILABLE THE REQUEST SHOULD BE SET BY ‘FAX’ to ‘CHARGE CODES’ ON 0131 247 2650). THE REQUEST SHOULD CONTAIN AS MUCH INFORMATION REGARDING THE CIRc*msTANCES OF THE OFFENCE AS POSSIBLE. IF INSUFFICIENT DETAIL IS PROVIDED THIS WILL BE REQUESTED PRIOR TO ANY

ACTION BEING TAKEN ON THE REQUEST. THE REQUEST WILL THEN BE FORWARDED TO THE CROWN OFFICE Policy Group who will examine the request for a new code and check the legislation. They will decide whether a new code is justified or consider an alternative. If a new code is NOT REGARDED AS APPROPRIATE, Crown Office will ADVISE the agency requesting the code directly, explaining any problem and proposing alternative action. If ACCEPTED, Crown Office Policy Group will prepare the requested new code and associated style. This protocol does not set out any time limit for Crown Office action on the above because the time allowed depends on the urgency/importance of the request and may vary from as little as 1-2 days to 2 weeks and over. However, such requests will be treated as high priority. For non “fast path” requests, Crown Office will not issue new codes and styles directly to police forces. Instead, in the first full calendar week in each calendar month Crown Office will issue to SPSA, copied to SEJD Justice Statistics Unit, the up to date versions of the Charge Codes and Charge Styles data sets, incorporating any new codes issued.

CROWN OFFICE WILL ADVISE AN IMPLEMENTATION DATE FOR THE SWITCHOVER TO THE LATEST VERSION OF THE ‘CODES’. IT IS IMPERRATIVE THAT REPORTING AGENCIES DO NOT IMPLEMENT THE CHANGES UNTIL THE AGREED DATE. NB: FAILURE TO IMPLEMENT CHANGES ON THE AGREED DATE WILL RESULT IN UNSPECIFIED ERRORS Note: The format of these data sets is set out in the Annex: “Format of Data Files” at sections 1.1 and 1.2. CROWN OFFICE WILL ONLY ISSUE THE COMPLETE FILES FOR THE REGULAR UPDATE RATHER THAN AN AMENDMENTS FILE. If, exceptionally, the data sets have not been updated that month, Crown Office will send a ‘Nil Return’ to SPSA copied to SEJD Justice Statistics Unit. IN ADDITION, TO THE CHARGE ‘CODE’ AND ‘STYLE’ FILES CROWN OFFICE WILL INCLUDE A TEXT FILE INDICATING WHAT THE CHANGES ARE. Action of Crown Office on receipt of request for other changes to ISCJIS codes/styles Other changes, for examples requests for correction of typographical errors in styles, requested from Crown Office, will not be cleared with the Crown Office policy branch but will be enacted directly. These changes will be incorporated in the data sets 1.1 and 1.2 sent to SPSA, copied to SEJD Justice Statistics Unit, each month.

Action of SPSA on receipt of data sets 1.1 and 1.2 each month

SPSA, on receipt of the data sets 1.1 and 1.4 from the Crown Office (or ‘Nil Return’), will immediately transmit these by e-mail to the 8 nominated police force representatives and all other interested Criminal Justice agencies. (SPSA will insist that each police force nominates a single representative to receive the data sets from SPSA and supplies an email address for this representative. This is necessary to avoid delays occurring in forces’ activation of the new data sets due to their receipt by an inappropriate officer.) Forces and other agencies should therefore be in a position to RECEIVE the charge codes and styles into their information systems in the first full calendar week in each calendar month. At this point, any new codes will not have an allocated SEJD mapping; these will be supplied later, as described below. REPORTING AGENCIES MUST BE ABLE TO IMPLEMENT THE AGREED CHANGES ON THE AGREED DATE THAT WILL BE CIRCULATED WITH THE FILES. Note: The formats of these data sets are set out in the Annex: “Format of Data Files” at sections 1.1 and 1.2. Action of SEJD Justice Statistics Unit on receipt of data sets 1.1 and 1.2 each month Justice Statistics Unit will translate the data set 1.1 from TEXT file to EXCEL spreadsheet format. They will compare the updated version of the data set with the previously held version to identify any new charge codes issued by the Crown Office. Justice Statistics Unit will allocate an SEJD crime code to each new ISCJIS charge code identified above. (The SEJD code may be an ‘X’ (if it is felt that the ISCJIS charge code should not be used for recording crimes made known) or an ‘M’ (if a modifier is required in order to allocate a unique SEJD code.)) Justice Statistics Unit will send a data set in EXCEL spreadsheet format to SPSA covering all new ISCJIS codes identified, which shows the SEJD codes allocated. Note: The format of this data set is set out in the Annex: “Format of Data Files” at section 1.3. Justice Statistics Unit will send the data set 1.3 to SPSA within 5 working days. If a new ISCJIS charge code has been allocated an SEJD code of ‘M’, this means that the list of charge codes requiring a modifier, held in EXCEL spreadsheet format, will also be updated. On the occasions when this happens, an updated version of this spreadsheet will be sent to SPSA at the same time as the data set 1.3. Action of SPSA on receipt of data sets 1.3 each month SPSA on receipt of the data set 1.5 from Justice Statistics Unit, will immediately transmit it by e-mail to the 8 nominated police force representatives only. Forces should therefore be in a position to load the SEJD mappings for the new charge codes into their information systems for use in the second full calendar week in each calendar month. “FAST PATH” PROCEDURES NB: “Fast path” procedures will only be justified in cases, which are “Custody”, “Undertaking” or “Time Bar”. Action of Crown Office on receipt of “fast path” request for new ISCJIS code

As with the normal procedure, Crown Office Policy Group will examine the request for a new code and check the legislation. They will decide whether a new code is justified or consider an alternative. If a new code is not REGARDED AS APPROPRIATE, Crown Office will ADVISE the agency requesting the code directly, explaining any problem and proposing alternative action. If ACCEPTED, Crown Office Policy Group will prepare the requested new code and associated style. This will be carried out at a speed commensurate with the urgency of request – in a matter of hours, if necessary. The new charge code and associated style will be copied to SPSA for immediate transmission to all criminal justice agencies. Crown Office will add the new code and style to the Charge Codes and Charge Styles data sets to be sent to SPSA in the first full week of the following calendar month and procedures thereon will follow the normal procedure. Forces and other agencies should therefore be in a position to load “fast track” charge codes and styles into their information systems for use within the timescale required. However, forces will not be in a position to load the SEJD mappings for these new charge codes into their information systems until the second full calendar week in the following calendar month. “STATISTICAL APPLICATION” TO ASSIST POLICE FORCES COMPILE THEIR QUARTERLY MKQ DATA AND COLLATE STATISTICS FOR INTERNAL INTELLIGENCE PURPOSES In some police forces, the SEJD codes associated with the ISCJIS charge codes are not held within the force information system. This means that the information system can only provide counts of crimes recorded and crimes cleared up by ISCJIS charge code. To assist such forces in the production of their MKQ returns (by SEJD code) each quarter and to collate statistics meaningful for their internal intelligence purposes, SEJD is developing an “application” which converts counts by ISCJIS charge code to counts by SEJD code or SEJD code groupings. So far, only Fife Constabulary require to use this application but other forces may also require it as they become ISCJIS compliant. Intrinsic in this application is the mapping of an SEJD code for each (permitted) ISCJIS charge code/modifier combination. Through the protocols described above, these mappings will be updated monthly. However, MKQ returns are required only on a quarterly basis. SEJD Justice Statistics Unit will therefore supply force statistical officers, copied to SPSA, with the information needed to update the application in the final fortnight of each quarter. SEJD Justice Statistics Unit will include with this information a copy of the ISCJIS charge code list used in the application, sorted by the associated SEJD code and the list of modifiers with associated SEJD code mappings. Forces will be able, if they wish, to use this list as a check that they are holding a consistent list of charge codes in their information systems.

SUMMARY JUSTICE REFORM/ISCJIS DATA STANDARDS MANUAL: STANDARDS

Annex 6 - Format of data files This section describes the format of data within each of the data files. All files will be text files with no column headings. 1.1 Charge Codes The fields in these records are separated by “@” signs. There will be no “quotes” within this file. Each record contains the following fields: Field Name Charge Code Charge Type Search Description Effective Date Inactive Date Endorsable Act Section Description UPDATE VERSION Changed

Comments Must be 16 characters with no spaces or the record will be rejected. Up to 2 characters this is used by Crown Office Up to 60 characters 8 digits (ddmmyyyy) mandatory 8 digits (ddmmyyyy) or empty. If value is supplied the Charge should no longer be used. It is effectively deleted. Up to 1 character ( ‘Y’ if endorsable, otherwise ‘N’) Up to 104 characters Up to 16 characters Section narrative – Up to 120 characters This will show ‘Original’ or Month/Year of change Will be “” or “new” or amended”. Charges that are ‘deleted’ will be marked “amended” as the inactive date has changed from ‘blank’ to a value.

Example records: 0ABD000000000000@CL@Abduction@@@@Abduction@@Abduction@November 1999@new 0ASS000000000000@@Assault@@@@Assault@@Assault@Original@ 0BOP000000000000@X@Breach of the Peace@@@@Breach of the Peace@@Breach of the Peace@November 1999@amended

1.2

Charge Styles

This file contains the charge style for every charge code. Each record can contain up to 600 characters of charge style text. If the charge style requires more than 600 characters then this is handled by using consecutive records with ascending sequence numbers. In this file, the fields are separated by “@” signs and the Charge Text will be surrounded with “quotes”:

Field Name Charge Code Sequence Numbers Charge text

Comments Must be 16 characters 3 digits An opening double quotes followed by up to 600 characters and a closing double quotes.

NOTE : Charges Styles will only be sent when these have been added or amended. Consequently, there is no requirement to put a version ID on the data sent Example records: 0AED000000000000@001@”on [OFFDATE:TYPE OFFENCE DATE] at [LOCUS:TYPE LOCUS] you [ACCNAME:TYPE ACCUSED NAME] did assault [NAME:TYPE VICTIM NAME], [ADDRESS:TYPE VICTIM ADDRESS] and did [DETAILS:TYPE DETAILS OF EXPLOSIVE DEVICE]” RTA0198801640205@001@”on [OFFDATE:TYPE OFFENCE DATE] at [LOCUS:TYPE LOCUS] you [ACCNAME:TYPE ACCUSED NAME] being a person whom a [RANK:TYPE RANK] had reasonable cause to believe was supervising the holder of a provisional licence while driving at a time when an accident occurred owing to the presence of a motor vehicle namely motor [VEH:TYPE KIND OF VEHICLE] registered number [REGNO:TYPE REGISTERED NUMBER] on a road, namely [DETAILS:TYPE NAME OF ROAD] and on being required by said [RANK:TYPE RANK], namely [NAME:TYPE NAME], [RANK:TYPE RANK], [FORCE:TYPE POLICE OFFICE] to state your date of birth you did “RTA0198801640205@002@”fail to do so; CONTRARY to the Road Traffic Act 1988, Section 164(2) and (6) as amended” NOTE: The above example indicates a file containing 3 records. The blank lines have been included for readability. Variable always consist of open square bracket, a word, a colon, other word(s) and a closing square bracket as indicated in the examples.

1.3 Update Guide This file describes the layout of the complimentary Information file that will accompany Charge Code updates from the April 2001 update. This file has been introduced following the acceptance of the revised protocol for introducing Charge Code/Style updates. The layout for each item in the information file will be:Both(2) Amendment(3) Modified the [CHOICE] SECU198500040000 (1) 4) and [CHOICE2] tags.( Security for Private Road Works (Scotland) Regulations 1985 Commence building works before consent obt/security prov/two weeks before written notice of intention(5) Explanation (1)

This is the Charge Code

(2)

This indicates what has been changed Both = Charge Code & Style Code = Charge Code only Style = Charge Style only

(3)

This indicates the nature of the change Amendment = an existing item has been altered Deletion = an existing item now has an ‘Inactive Date’ Insertion = this is a new item

(4)

This narrative details what has changed and provides additional information.

(5)

This is a copy of the Section Narrative to assist the proper identification of the Charge Code. The information file will be output in the following order:1 2 3 4 5 6

Changes affecting Charge Within that Amendments, Changes affecting Charge Within that Amendments, Changes affecting Charge Within that Amendments,

Code & Style (i.e. both) followed by Deletions, and finally Insertions Code only followed by Deletions, and finally Insertions Styles only followed by Deletions, and finally Insertions

Annex 7 - PROTOCOL FOR FILE NAMES FOR PASSING BETWEEN (CJOS) There is a tri-lateral convention as follows: PF Office ID (2 chars) (eg AB = Aberdeen, full list in standards manual) Origin (3 chars) (eg PFS = Proc. Fiscal, SCS = Scottish Court Service) Court ID (4 chars) (eg 9456 = Dundee District) Date/time (14 chars) DDMMYYYYHHMMSS Files from the police should contain their agency ID in the “origin” part (eg PTP for Tayside). Example: ABPFS9456DDMMYYYYMMSS

Annex 8 - FILE NAMING CONVENTION FOR CHARGE CODE UPDATES Charge codes: yyymmcd.txt Charge style: yyymmst.txt

Annex 9 - DEVELOPMENT OF DOCUMENT HEADERS FOR RETURN DATA TO ISCJIS PARTNERS

JSITS STANDARDS FOR SUBJECT HEADERS Outgoing Files court file Office Code (2) PFS, PFD, PFH(3) Court id (5) DDMMYYYY (6) SSSSSS (6) .SCRO (5) Examples EDPFS974114062007385660 EDPFS97411406200738566.SCRO104249 EDPFD947820062007686300 EDPFD94782006200768630.SCRO190435 SCS have asked that the court id be “packed” to 5 characters. Add a 1 to the end of each court id. These below do not need packed. EDPFH0901A04072007702840 EDPFH0901A0407200770284.SCRO193203 HMPFS9772Y08062007353240 HMPFS9772Y0806200735324.SCRO094851 non court file Office Code (2) PND (3) Court id (5) DDMMYYYY (6) SSSSSS (6) .SCRO (5) Examples In a Non Unified court the sending office and receipting court id are used. EDPND9518112062007190435 EDPND9518112062007.SCRO190435 In a Unified court we will use the generic office code CO and court id of 9999. COPND9999112062007190435 EDPND9518112062007.SCRO190435 Direct Measures Document Office Code (2) doc (3) Court id (5) case num (10) SUBJSEQ (3) DDMMYYYY (6) SSSSSS (6) Example: EDDOC9741ED0700384700114062007110530 SCRO files only rollup Office Code (2) DDMMYYYY (6) .ROLL (5) SSSSSS (6) Example: ED12062007.ROLL190435 nopro Office Code (2) DDMMYYYY (6) .NOPRO (6) SSSSSS (6) Example: ED12062007.NOPRO190435

BATCH REPORTS These reports are only submitted to the police. The key elements that the police want is that all requests are submitted as individual items each with their own subject header. The format will have the following structure:OOPFSDOCTAGENCY REFDDMMYYYYROUNIQREFN Where OO = The Fiscal Office Code for the sending office PFS = Static value to signify a message from the Procurator Fiscal service DOCT = Type of document being sent AGENCY REF = Lead Incident Number (will not be required for some documents) DDMMYYYY = required by (will not be required for some documents) ROURN = Reporting Officer Unique Reference Number (will not be required for some documents MISCELANEOUS MEMOS This is perhaps the most difficult area to address because the originator types the subject header. I do not think that it is reasonable to ask out staff to lookup then type the Lead Incident Number. Consequently, the best that we can do, would be:OOPFSMEMCASE NUMBER Where OO = The Fiscal Office Code for the sending office PFS = Static value to signify a message from the Procurator Fiscal service MEM = Memo (There is scope to add different document types) Case Number = Fiscal’s Case Number

Annex 10 - INDIVIDUAL MAIL TO THE POLICE The following is a list of the codes used to identify the individual request files sent from the Procurator Fiscals Standard Office System (SOS) to the police systems. NAME

DESCRIPTION

FSPC FSPB FSSC FSSB FSTN

Petition Custody Petition Bail Summary Custody or High profile Summary Bail/Ordained Full Statement Not Guilty – Accused has pled Not Guilty and Fiscal has requested full statements for all Accused on all Charges Partial Statement Not Guilty – Accused has pled Not Guilty and Fiscal

PSTN

NAME

FSTM PSTM FSPT PSPT FSRN

PSRN

FSRM PSRM

FSLN

PSLN

FSLM PSLM

FSLT

PSLT

DESCRIPTION has requested full statements for Accused and Charges listed at A: Full Statement Marking –Fiscal has requested full statements for all Accused on all Charges prior to marking the case Full Statement Marking –Fiscal has requested full statements for Accused and Charges listed at A: prior to marking the case Full Statement Petition –Fiscal has requested full statements for all Accused on all Charges for a Petition case Full Statement Petition –Fiscal has requested full statements for Accused and Charges listed at A: for a Petition case Full Statement Not Guilty – Accused has pled Not Guilty and Fiscal has requested full statements for all Accused on all Charges. Reminder that statements are due following week and have not been received. Partial Statement Not Guilty – Accused has pled Not Guilty and Fiscal has requested full statements for Accused and Charges listed at A: Reminder that statements are due following week and have not been received. Full Statement Marking –Fiscal has requested full statements for all Accused on all Charges prior to marking the case. Reminder that statements are due following week and have not been received. Full Statement Marking –Fiscal has requested full statements for Accused and Charges listed at A: prior to marking the case. Reminder that statements are due following week and have not been received. Full Statement Not Guilty – Accused has pled Not Guilty and Fiscal has requested full statements for all Accused on all Charges. Notification that the statements have not been received by the due date. Partial Statement Not Guilty – Accused has pled Not Guilty and Fiscal has requested full statements for Accused and Charges listed at A: Notification that the statements have not been received by the due date. Full Statement Marking –Fiscal has requested full statements for all Accused on all Charges prior to marking the case. Notification that the statements have not been received by the due date. Full Statement Marking –Fiscal has requested full statements for Accused and Charges listed at A: prior to marking the case. Notification that the statements have not been received by the due date. Full Statement Petition –Fiscal has requested full statements for all Accused on all Charges for a Petition case. Notification that the statements have not been received by the due date.

GOOD

Full Statement Petition –Fiscal has requested full statements for Accused and Charges listed at A: for a Petition case. Notification that the statements have not been received by the due date. Bail Order Cancellation – Notification that the Fiscal has terminated proceedings for the Accused on the notified case and that the Bail Conditions associated for the Accused on this case have been cancelled. A request for a Good Behaviour report for Accused

GORD

A request for a Good Behaviour report for Accused. Reminder that

FORC

NAME

GOLD

DESCRIPTION Good Behaviour report is due the following week and has not been received. A request for a Good Behaviour report for Accused. Notification that the Good Behaviour Report has not been received by the due date.

In addition to the Individual requests the following batch files are sent: NAME

DESCRIPTION

GGRC FSRC CHNP NPRO FINE

Daily Case Receipt list Daily Witness Receipt List Monthly list of Charges closed where Subject has no S Number Monthly list of Cases closed where Subject has no S Number Monthly Fine Paid report

Annex 11 – Offence Aggravations Combination Codes Procedure for Obtaining a new Aggravation Combination Code This process assumes the SPR will be the first point of failure whereas in reality it will be the entry onto CHS by a force Records Office. This is because CHS must be update first before a SPR is submitted to COPFS. 1. Where an update to /creation of a CHS record fails due to the aggravator string not being recognised the operator will 2. Establish that the characters provided are accurate and thereafter contact the CHS Service Desk. 3. CHS will investigate to determine if the code is not missing or inactive 4. Where it is recognised that the string requires a new code then the CHS Service Desk will submit a request to COPFS Help Desk at [emailprotected] 5. COPFS helpdesk will investigate and if needed will create the new code and advise the CHS Service Desk of the new code and also inform JSITS to get the value added to the list of combination codes held in the Data Standards Manual. 6. The CHS Service Desk will cause the CHS list to be updated and thereafter notify the relevant force Records Office. They will hold a full list of aggravator codes and be contacted at [emailprotected] or telephone 0141-585-8333 7. The force Records Office will thereafter progress the record update/creation of the affected record. This creates a single point of contact with police to CHS and CHS to COPFS. It also addresses the need for the string rejection to be explored at the first stage of failure on a 24/7 basis.

CODE Aggravation 0

No Aggravation

Anti Social Behaviour

Offending whilst on Bail

Cancelled

Domestic Abuse

Disability

Football

Football Banning Order

Harassment

Harassment Order

Connected to Serious Crime

Offence against a child

Breach of undertaking

Sexual Orientation

Sex Offenders Order

Religious

Racial

Sexual

Transgender

Inactive Anticipated activation date indicator

October 2010

Full List of Combination Codes are held with the SPSA Service Desk, 0141-585 - 8333

Annex 12 - SPR2 Schemas These can be found as a separate document on the ISCJIS website www.iscjis.gov.uk Annex 13 - FILE FORMATS SUPPORTED BY THE COURTROOM PC. MEDIA CODEX

Microsoft Word (.doc, .rtf, .txt) Microsoft Powerpoint (.ppt, .pps) Microsoft Excel (.xls) Portable Document Format (.PDF) Graphics (Xnview): ADEX

img,rle

AIM Grey Scale ARF AT&T Group 4 Access Aces200 Acorn Sprite Adobe Illustrator Adobe PhotoParade Adobe Photoshop Advanced Art Studio AirNav Alias Image File Alpha Microsystems BMP Amapi Amica Paint Amiga IFF Amiga icon Amstrad Cpc Screen Andrew Toolkit raster object Apollo HDRU ArcInfo Binary Art Director Artisan Artist 64 Astronomical Research Network Aurora Auto F/X Autocad CAD-Camera AutoCAD DXF AutoCAD DWG Autodesk Animator Autodesk SKETCH thumbnail Autodesk SketchUp component Autologic Award Bios Logo Axialis Screensaver B3D (images) BFLI BMF BYU SIR Bfx Bitware Bio-Rad confocal Blazing Paddles Bob Raytracer Brooktrout 301 Buttonz & Tilez texture byLight CALS Raster CDU Paint CMU Window Manager CP8 256 Gray Scale Calamus Canon Navigator Fax Canon PowerShot Cartes Michelin

ima,im arf att g4 ace ai php psd ocp,art,pic anv pix,als,alias bmp 2d ami,[b] iff,blk info atk hdru,hdr hdr art art a64 arn sim afx img dxf dwg fli,flc skf skp gm,gm2,gm4 epa ssp b3d bfl,bfli bmf sir bfx pic pi bob brk,301,brt til bif cal,cals cdu cmu cp8 cpi,crg can crw big

Casio QV-10/100 Camera Chinon ES-1000 digital camera Cloe Ray-Tracer ColoRIX CompW CompuServe GIF Computer Eyes, Digital Vision ComputerEyes Raw Core IDC Corel Draw Bitmap (preview) Corel Draw Pattern (preview) Corel Flow Corel Metafile Exchange (preview) Corel PhotoPaint 6.0 CoverDesigner CoverDesigner Template DBW Render DIV Game Studio Map DIV Game Studio Multi Map DKB Ray-Tracer DPX Dali Raw Datacopy Degas & Degas Elite Deluxe Paint, Electronic Arts Dicom Digital F/X Digital Research (GEM Paint) Discorp CMP Image DjVu Doodle Atari Doodle C64 Doodle C64 (Compressed) Dr Halo Draz Paint EA Sports FSH EPS Interchange Format ERI-chan (Entis Rasterized Image) ESM Software Pix Ecchi Eclipse Edmics Electric Image Embroidery Encapsulated Postscript(Preview) Enhance Simplex Eroiica Enhanced Compressed Wavelet Explore (TDI) & Maya FIF (Iterated System) FIT Fax Group 3 Fenix Map

cam cmt clo,cloe rix,sci,scx,sc? wlm gif,giff ce ce1,ce2 idc cdr pat bmf cmx cpt ncd nct map fpg dis dpx sd0,sd1,sd2 img pi1,pc1,pi2, pc2,pi3,pc3, pi4,pi5,pi6 lbm,ilbm dcm,acr tdim img,gem cmp djvu,djv,iw4 doo dd jj cut drz fsh epi eri pix ecc tile c4 ei,eidi bmc eps esm eif ecw tdi,iff fif fit g3,fax map

Fenix Multi Map Flash Image FlashPix Format Flexible Image Transport System Fuzzy bitmap GeoPaint Gfa Raytrace Gimp Bitmap Gimp Brush Gimp Icon Gimp Pattern GoDot HF HP-48/49 GROB HRU HSI Raw Half-Life Model Hayes JTFax Hemera Photo Image Hemera Thumbs Heretic II MipMap Hi-Eddi Hires C64 Homeworld Texture HPGL/2

IBM Kips IBM Printer Page Segment IM5 (Visilog) IMNET Image IOCA ISS Icon Library Image Capture Board Image Magick file Image Speeder Image System (Hires) Image System (Multicolor) Image Systems RLC2 Graphic ImageLab Imaging Fax Imaging Technology Img Software Set Inshape InterPaint (Hires) InterPaint (Multicolor) Intergraph Format Interleaf Iris CT Iris graphic J Wavelet Image Codec JBIG JPEG / JFIF

fpg fi fpx fts,fits,fit fbm,cbm geo sul xcf gbr ico pat 4bt,4bit,clp hf gro,grb hru raw mdl jtf hpi hta m8 hed hir lif plt, hgl, hg, hpg, plo, hp, hp1, hp2, hpgl, hpgl2, gl2, prn, spl kps pse im5 imt ica,ioca iss icl icb mif,miff ish ish ism rlc b&w,b_w g3n img img iim iph ipt itg,cit,rle iimg ct iris wic jbg,bie,jbig jpg,jpeg,jif,jfif,J,jpe

JPEG-2000 Code Stream JPEG-2000 JP2 File Format JPEG-LS Jeff's Image Format Jovian VI Jpeg Network Graphics JustButtons animated bitmap Khoros Visualization Image file KinuPix Skin Kiss Cel Koala Paint Koala Paint (Compressed) Kodak Cineon Kodak DC120 Digital Camera Kodak DC25 Camera Kodak Photo CD Kofax Group 4 Konica Camera File LSS16 LView Pro LaserData Light Work Image LucasFilm Format Lumena CEL LuraDocument Format LuraWave Format LuraWave JPEG-2000 Code Stream LuraWave JPEG-2000 Format MAGIchan Graphics MGI Photosuite Project MGR bitmap MTV Ray-Tracer Mac Paint Macintosh Quickdraw/Pict Maggi Hairstyles & Cosmetics Male MRI Male Normal CT Marks Russel File Mavica Maw-Ware Textures Mayura Draw MegaPaint Megalux Frame Micro Dynamics MARS Micro Illustrator Uncompressed Micrografx Picture Publisher 4.0 Micrografx Picture Publisher 5.0 Microsoft Paint Microtek Eyestar Mindjongg Format MonkeyCard MonkeyLogo MrSid Msx 2 Screen

jpc jp2,j2k,jpx jls jif vi jng btn vif,viff,xv thb cel koa gg cin kdc k25 pcd kfx kqp 16 lvp lda lwi lff cel ldf lwf jpc jp2,j2k,jpx mag pzp mgr mtv mac,mpnt,macp, pntg,pnt,paint pic,pict,pict2, pct fff pd,t1,t2 fre mrf 411 mtx pdx bld frm pbt mil pp4 pp5 msp img ipg pdb pdb sid sc2

Multiple Network Graphics Multiple Network Graphics NCR Image NIST ihdr National Imagery Transmission NeoBook Cartoon Neochrome (ST & TT) Neopaint Mask Neopaint Stamp Nikon D1 digital camera Nokia Group Graphics Nokia Logo File Nokia Operator Logo Nokia OTA bitmap OAZ Fax OS/2 Bitmap Olicom Fax Open Image Library Format Optigraphics Optigraphics Tiled Optocat Oric Hires Oric TAP Os/2 Warp PABX background PC Paint / Pictor Page PCO PM PWC Page Control Language Paint Magic PaintShopPro Browser Cache File PaintShopPro Frame PaintShopPro Image PaintShopPro Mask PaintShopPro Pattern PaintShopPro Picture Tube PaintShopPro Texture Palm Pilot Pegs Pfs Art Publisher Photo Deluxe PhotoFantasy Image PhotoFrame PhotoStudio File PhotoStudio Stamp Photomatrix Pict2 Photopaint Image Picasso 64 Picture Gear Pocket Pixar picture file Pixel Power Collage Pixia Pixibox

mng mng ncr pct nitf car neo npm stw nef ngg nlm nol otb oaz bmp,bga ofx oil cft ttf abs hir tap bga pix pic,clp b16 pm pwc pcl pmg jbf pfr psp msk pat tub tex pdb pxs,pxa art pdd,pdb fsy frm psf stm cat p2 apx p64 prc pic,pxr,picio, pixar ib7,i17,i18, if9 pxa pxb

Planetary Data System Playback Bitmap Sequence Pocket PC Bitmap Polychrome Recursive Format Portable Bitmap Portable Document Format Portable Greyscale Portable Image Portable Network Graphics Portable Pixmap Portfolio Graphics Portfolio Graphics Compressed Portrait Poser Bump Postscript PowerPoint (images) PowerPoint Presentation (images) Printfox/Pagefox Prisms Psion Series 3 Bitmap Psion Series 5 Bitmap Punk Productions Picture Puzzle Q0 Qdv (Random Dot Software) Qrt Ray-Tracer Quake Texture Quantel VPB RIPTerm Image Radiance Rainbow Painter Raw Rayshade Red Storm File Format Ricoh Digital Camera Ricoh Fax Ricoh IS30 RunPaint (Multicolor) SBIG CCD camera ST-4 SBIG CCD camera ST-X SPOT Saracen Paint SciFax SciTex Continuous Tone Seattle Film Works Seattle Film Works multi-image SecretPhotos puzzle Sega SJ-1 DIGIO Sharp GPB Silicon Graphics RGB Skantek Slow Scan Television

pds,img bms 2bp prf pbm,rpbm pdf pgm,rpgm pnm,rpnm,pbm, rpbm,pgm,rpgm, ppm,rppm png ppm,rppm pgf pgc cvp bum ps,eps pps ppt bs,pg,gb pri pic mbm ppp pzl q0,rgb qdv qrt wal vpb icn rad,img,pic rp raw,gry,grey pic rsb j6i 001 pig rpm st4 stx,st4,st5, st6,st7,st8 dat sar sci sct,ct sfw pwp,sfw xp0 sj1 img rgb,rgba,bw, iris,sgi skn hrz

SmartDraw 6 template SmartFax SmoothMove Pan Viewer Softimage Solitaire Image Recorder Sony DSC-F1 Cyber-shot Sony Playstation TIM Spectrum 512 Spectrum 512 (Compressed) Spectrum 512 (Smooshed) SriSun Stad Star Office Gallery Starbase Stardent AVS X Starlight Xpress SX 500x291 RAW Stereo Image Structured Fax Format Sun Icon/Cursor Sun Rasterfile Sun TAAC file Synthetic Universe TG4 TI Bitmap TIFF Revision 6 TRS 80 TealPaint Thumbnail Tiny Total Annihilation Truevision Targa Ulead Pattern Ulead PhotoImpact Ulead Texture Usenix FaceServer Utah raster image VITec VRML2 Verity Vicar Vidcom 64 Video Display Adapter Vista Vivid Ray-Tracer Vort Vue d'esprit WAD (Half Life) WaveL Wavefront Raster file WebShots WhyPic WinFAX

sdt 001 pan pic,si sir pmp tim spu spc sps ssi pic,pac,seq sdg img x,avs,mbfs, mbfavs jps sff icon,cursor,ico,pr ras,rast,sun, sr,scr,rs iff,vff,suniff, taac syn,synu tg4 92i,73i,82i, 83i,85i,86i, 89i tif,tim,tiff hr pdb tnl tny,tn1,tn2,tn3 gaf tga,targa,pix, bpx,ivb pst upi pe4 fac,face rle,urt vit wrl vif vic,vicar,img vid vda vst img pix vob wad iwc rla,rlb wbc,wbz ypc fxs,fxo,wfx

WinMIPS Windows & Aldus Metafile Windows Animated Cursor Windows Bitmap Windows Clipboard Windows Cursor Windows DIB Windows Enhanced Metafile Windows Icon Wireless Bitmap (level 0) Word Perfect Graphics X Windows System dump X11 Bitmap X11 Pixmap XV Visual Schnauzer Xara (images) Xerox DIFF Ximage Xionics SMP YUV 16Bits YUV 16Bits Interleaved YUV 4:1:1 YUV 4:2:2 YUV 4:4:4 ZX Spectrum Hobetta ZX Spectrum Snapshot ZX Spectrum standard screen ZZ Rough Zoner Callisto Metafile (preview) Zoner Zebra Metafile (preview) Zsoft Multi-page Paintbrush Zsoft Publisher's Paintbrush Audio/Video/Graphics (Quicktime) 3DMF (Mac OS 9 & Windows) 3GPP 3GPP2 AIFF AMC AMR Animated GIF AU Audio CD Data (Mac OS 9) AVI BMP CAF (Mac OS X) Cubic VR DLS DV FLC GIF GSM JPEG/JFIF

pic wmf ani bmp,rle,vga, rl4,rl8,sys clp cur dib emf ico wbmp,wbm,wap wpg xwd,x11 xbm,bm xpm,pm p7 xar xif xim smp yuv,qtl,uyvy yuv,qtl,uyvy yuv,qtl yuv,qtl yuv,qtl $s,$c,!s sna scr rgh zmf zbr dcx pcx,pcc,dcx

Karaoke MacPaint MIDI MPEG-1 MP3 (MPEG-1, Layer 3) M3U (MP3 Playlist files) MPEG-2** MPEG-4 MQV M4A, M4B, M4P (iTunes 4 audio), M4V (iTunes video) PDF (Mac OS X) Photoshop* PICS PICT PLS PNG Quartz Composer Composition (Mac OS X) QCP (Mac OS 9 & Windows) QuickTime Image File QuickTime Movie SD2 (Mac OS 9 & Windows) SDP SDV SF2 (SoundFont 2) SGI SMIL Targa Text TIFF* TIFF Fax VDU (Sony Video Disk Unit) Virtual Reality (VR) Wave Audio/Video (Windows Media Player) Advanced Systems Format (.asf) Audio Visual Interleave (.avi) Audio for Windows (.wav) Microsoft® Digital Video Recording (.dvr-ms) Windows Media Audio (.wma) Windows Media Video (.wmv, .wm) Advanced Stream Redirector (.asx) Windows Media Audio Redirector (.wax) Windows Media Download Package (.wmd) Windows Media Player Playlist (.wpl) Windows Media Redirector (.wmx) Windows Media Video Redirector (.wvx) MPEG-1 (.mpeg, .mpg, .m1v) MPEG Audio Layer III (.mp3) MPEG Audio Layer II (.mp2, .mpa) Metafile Playlist (.m3u) Audio Interchange File Format ( .aif, .aifc, .aiff) CD Audio Track (.cda) Musical Instrument Digital Interface (.mid, .midi, .rmi) Sun Microsystems and NeXT (.au, .snd)

Audio/Video (VLC) 3GP, ASF, AVI, FLV, MKV, QuickTime, MP4, Ogg, OGM, WAV, MPEG-2 (ES, PS, TS, PVA, MP3), AIFF, Raw audio, Raw DV, MXF, VOB. Video formats Cinepak, DV, H.263, H.264/MPEG-4 AVC, HuffYUV, Indeo 3,[16] MJPEG, MPEG-1, MPEG2, MPEG-4 Part 2, WMV. The XP Codec Pack is also installed and provides the following “filters” to enable other software to increase the number of supported file types… AC3Filter 1.51a AVI Splitter 1.0.0.9 CDXA Reader 1.0.0.2 CoreAAC (AAC DirectShow Decoder) 1.2.0 CoreFlac Decoder 0.4 FFDShow MPEG-4 Video Decoder 2008.12.19 GPL MPEG-1/2 Decoder 0.1.2.0 Matroska Splitter 1.0.3.0 Media Player Classic 6.4.9.1 OggSplitter/CoreVorbis 1.1.0.79 RealMedia Splitter 1.0.1.2 RadLight MPC Filter 1.0.0.4 RadLight APE Filter 1.0.0.4 RadLight OFR Filter 1.0.0.4 RadLight TTA Filter 1.0.0.2 The Codec Detective 2.0 VSFilter (DirectVobSub) 2.39

[PDF] THE HEAD OF (SPSA) INFORMATION SERVICES, CRIMINAL JUSTICE on (OFFICE HOURS) THE SERVICE DESK SPSA on (24 HOURS) - Free Download PDF (2024)