Transfer/Upload requirements for Seattle Municipal Court to get Seattle Municpal Laws into JIS local law table so that the Seattle Police Department (SPD) can use SECTOR (e-ticketing).
SECTOR only uses laws found in the JIS local and statewide law tables. Therefore, in order for SPD to use SECTOR there needs to be a file transfer of Seattle Municipal law codes into JIS local law table for Seattle Municipal Court (SMC).  This upload will need to be received from SMC in the format required by JIS and acceptable for use with the SECTOR system. SPD has federal grant money to get them using SECTOR and if the interfaces between agencies are not in place by the end of August 2013, then there is the potential of SPD loosing funding and not being able to use SECTOR.
The laws currently in the SMC local law table which are not usuable in SECTOR becasue the current data exchange does not store SMC laws in a way that is compatible with use for SECTOR requirements. JIS and SMC will have to modify the current SMC data exchange to allow processing of new law data. Laws recived will need to match requirements of JIS and SECTOR use.
Data Elements needed for upload of SMC laws. Bolded elements ones need info from Seattle for upload.
1   Court Initials- All will be SMC
2   Law Format- This should include “SMC” at the start of the law number so that SPD will know that it is a Seattle Municipal code and separate it from the statewide RCWs.
3   End date- this will be left blank for active laws.
4   Begin Date- This will need to be the actual date the Seattle Municipal Code was enacted or may be a set specific date for when SPD will start using SECTOR. Discussion needed.
If end date all current SMC laws exisisting then new laws have SMC and begin effective date when actual use beings?
5   Law Title- because of space limitation in JIS for Display of Criminal history, title should have as much info on violation at beginning (only 25 characters in DCH screen) Conflicting length in SECTOR vs what see in JIS for DCH
6   Case Type- JIS has set codes for different types of violations. A “translation sheet” will be provided. (IT, IN, CT, CN)
7   Caseload Type- JIS has set codes for different types of violations. A “translation sheet” will be provided. (IT, IN, CT, CM)
8   DOL FTA Flag- this will always be set to “N”
9   Mandatory Court Appearance- All criminal violations (CN or CT casetype) must be set to “Y” and all infractions must be set to “N”
10 Penalty amount (bail)- this will need to be a specific amount for infractions that includes base penalty and assessment amounts. For criminal cases, an amount will not show on the citation but it is recommended that if misdemeanor set at $500 and gross misdemeanor $1000.
11  BARS code- JIS requires set codes for this. A “translation sheet” will be given with codes for specific case types from #6 above.
12  Warrant Flag- this will always be set to “N”
13  Accident Fee- this will always be set to “N”
14  Parking Delinquent fee- leave blank
15 last update filed- default entry; does not need entry
16  DOL report e-dispo- this will always be set to “N”
17  Law key- default entry; does not need entry
18  Severity Code- JIS has set codes for different types of violations. A “translation sheet” willneed to be provided.
#6 & #7 Case Type & Caseload Type
Case Type        Caseload Type
CT                    CD (DUI cases only)
#11 BARS CODES FOR CASE TYPE (testing will need to be done to see if begin effective dates cause issues with the older BARS codes)