• No results found

End of File JSITSREF: CX013 Description Data Type Length Comments

Value 9 Record Identifier

Record Count Integer 99999 The number of records in the file Trailer Identifier Alphanumeric 3 This file will contain the word

“End”

Work Order Update (data flow number 9) Record 0 Header File JSITSREF: CX006

Description Data Type Length Comments Value 0

Court/

Council ID/PF Alphanumeric 5

Date Date 8 Production date

Time Alphanumeric 4

Record 9A Work Offer Update JSITSREF: CX030

Description Data Type Length Comments

Value 9A Record Identifier

SCRO Number Alphanumeric 11 Incident Number Alphanumeric 13 Complaint Number Integer 2

Charge Priority

Number Alphanumeric 3

Charge Sequence

Number Integer 3

Case Number Alphanumeric 10 Authority ID Alphanumeric 5 Work Order

Complete Indicator 1 Y or N Date Completed Alphanumeric 18

Date Date 8

Record 9 End of File JSITSREF: CX013 Description Data Type Length Comments

Value 9 Record Identifier

Record Count Integer 99999 The number of records in the file Trailer Identifier Alphanumeric 3 This file will contain the word

Conditional Offer to Court (data flow number 10) Police to Court Header Record JSITSREF: CX031

Police to Court Detail Record JSITSREF: CX032 Description

Data Type Length Mandatory XML Tag Name ISCJIS Standard SCRO Number Alphanumeric 11 No <SCRONo>

DVLA Licence Number

Alphanumeric 16 No - not available for foreign drivers

<DVLADriver> DVLA Driver Number File Creation

Date Date 8 Yes - date on which export from EROS is run

<FileDate> Date

Date of Birth Date 8 No <Dob> Date

Offer Date Date 8 Yes <OfferDate> Date Forenames Alphanumeric 120 No <Forenames> Forename(s) Surname Alphanumeric 30 Yes <Surname> Surname Address 1 Alphanumeric 30 Yes <Add1> Address Address 2 Alphanumeric 30 No <Add2> Address Address 3 Alphanumeric 30 No <Add3> Address Address 4 Alphanumeric 30 No <Add4> Address Description Data Type Length Mandatory XML Tag Name ISCJIS Standard File Alphanumeric N/A Yes – this is the

root element of the XML file

<File> N/A – no ISCJIS standard Originator Alphanumeric 30 Yes – who has

created the file

<Originator> N/A – no ISCJIS standard Recipient Alphanumeric 30 Yes – who the

file is intended for

<Recipient> N/A – no ISCJIS standard DVLA Code Alphanumeric 4 Yes – DVLA code

of the District Court concerned

<DVLACode> Court Codes

Creation date Date 8 Yes – date the

file was created <CreationDate> Date Creation Time Numeric 6 Yes – time the

file was created <CreationTime> Time

Police Force Code Alphanumeric 2 Yes <PolForceCode> DVLA Police Code

Post Code Alphanumeric 8 No <Pcode> Postcode Fine Amount Real 9.2 Yes - standard

fine (in pence) <FineAm> Money Police CO

Number

Alphanumeric 20 Yes <PolOffNo> Conditional Offer Number Penalty Points Alphanumeric 2 Yes <PenPts> N/A – no

ISCJIS standard DVLA Offence Code Alphanumeric 4 No - Standard offence code e.g. SP30 <DVLAOffCode> N/A – no ISCJIS standard Police (SEJD)

Offence Code Numeric 6 No - this is the Scottish Executive Offence Code

<SEJDCode> N/A – no ISCJIS standard Charge Code Alphanumeric 16 No - this is the

ISCJIS offence code

<ChgCode> Offence Code

Charge Variable

Text (LOCUS) Alphanumeric 200 No <Locus> N/A – no ISCJIS standard

Offence Date Date 8 Yes <OffDate> Date Charge Variable Text (LOCAL ORDER) Alphanumeric 200 No - Maximum length to be confirmed <LocalOrd> N/A – no ISCJIS standard Vehicle Registration Mark

Alphanumeric 11 No <RegNo> Vehicle Registration Mark

Offence Time Numeric 6 No <OffenceTime> Time

Conditional Offer from Court (data flow number 11) Court to Police Header Record JSITSREF: CX033

Description Data Type Length Mandatory XML Tag Name ISCJIS Standard File Alphanumeric N/A Yes – this is the

root element of the XML file

<File> N/A – no ISCJIS standard Originator Alphanumeric 30 Yes – who has

created the file <Originator> N/A – no ISCJIS standard Recipient Alphanumeric 30 Yes – who the

file is intended for

<Recipient> N/A – no ISCJIS standard DVLA Code Alphanumeric 4 Yes – DVLA code

of the District Court concerned

Court to Police Detail Record JSITSREF: CX034

Cancel/Amend Undertaking Record/Conditions Record 0 - Header File JSITSREF: CX006

Description Data Type Length Comments Court/

Council/PF ID

Alphanumeric 5

Date Date 8

Time Alphanumeric 4

Creation date Date 8 Yes – date the

file was created <CreationDate> Date Creation Time Numeric 6 Yes – time the

file was created

<CreationTime> Time

Police Force Code Alphanumeric 2 Yes <PolForceCode> DVLA Police Code Description Data Type Length Mandatory XML Tag Name ISCJIS Standard SCRO Number Alphanumeric 11 No <SCRONo>

File Creation

Date Date 8 Yes - date on which export from Anite Court System is run

<FileDate> Date Date Paid Date 8 Completed only

where fine paid <DatePaid> Date Police CO

Number

Alphanumeric 20 Yes - this is the EROS Offence Reference Number <PolOffNo> Conditional Offer Number Non-Court

Verdict Alphanumeric 3 FPD = Paid, FUD = Unpaid, FWD = Withdrawn/Cancelled, FPT = Refused Too Many Points, FCC = Paid Pending Cheque Clearance FDL= Non DVLA Driving Licence

<Verdict>

Disposal Codes

Non-Court

Verdict Date Date 8 Must be completed if verdict given. <VerdictDate> Date DVLA Licence

Number

Alphanumeric 16 No, only if paid (potentially only if

supplied by Police) <DVLADriver> DVLA Driver Number

Record 10 – Remove/Amend Undertaking Conditions JSITSREF: CX035

Description Data Type Length Comments

Value 10 Record Identifier

SCRO Number Alphanumeric 11 Agency Reference

Number Alphanumeric 13 PF Case Number Alphanumeric 10 Subject Sequence

Number Numeric 3

Undertaking Court

ID Alphanumeric 5

Undertaking Date Date 8 Undertaking Time Time 4 Undertaking

Conditions

Indicator 1 Trigger to notify SCRO to add the standard bail conditions against the accused for the undertaking Additional

Undertaking Conditions

Alphanumeric 400 Description of new/amended bail conditions

Record 9 End of File JSITSREF: CX013

Description Data Type Length Comments

Value 9 Record Identifier

Record Count Integer 99999 The number of records in the file Trailer

Identifier Alphanumeric 3 This file will contain the word “End”

Annex 3 – XML Schema Definition Files

Related documents