Home

(SHIPS) System Specification

1. Copyright C S Johnson 1994 2006 SHIPs System Specification Version 3 0 7 5 1 2 Screen Two contd Field Name Size Type Range Validation Notes amp Function CONTROL 1 A E Q E Q OR BLANK E RETURN TO SCRN FIELD ONE NO UPDATE Q RETURN TO MENU NO UPDATE BLANK UPDATE amp RETURN TO SCRN ONE N B A cell must have enough beds and mattresses for the number of prisoners Updates prisoner table and cell table Copyright C S Johnson 1994 2006 32 SHIPs System Specification Version 3 0 7 5 2 Find Cell Bed 7 5 2 1 Screen One Field Name Size Type Range Validation Notes amp Function PRISONER 6 N 1 OPTIONAL CHECK TO SEE IF NUMBER 999999 IN PRIS TABLE SURNAME 30 A IF NUMBER PRESENT EITHER NUMBER OR IGNORE ELSE MUST SURNAME amp FIRST BE PRESENT MUST BE PRESENT FIRST NAME 15 A IF SURNAME PRESNT CHANGED TO LOWER MANDATORY CASE j MIDDLE NAME 2 A OPTIONAL ONLY USE FIRST LETTER FOR X REF NAME TABLE CELL BLOCK 1 A A B C D MUST BE PRESENT CELL BLOCK TO E H SEARCH FOR VACANCY CONTROL 1 A Q Q OR BLANK Q RETURN TO MENU FIELD BLANK SCREEN TWO 7 5 2 2 Screen Two Field Name Size Type Range Validation Notes amp Function SEARCH 1 A YORN BLANK IS Y CELL SHOWN IS OK AGAIN ELSE LOOK AGAIN IN SAME CELL BLOCK CONTROL 1 A Q Q OR BLANK Q RETURN TO MENU FIELD BLANK SCREEN TWO N B A cell must have enou
2. 3 A B C D MAX 1 BLANK ASSUME TABLES E MAX 1 H IGNORE ZERO CELL 1 N 1 9 MUST BE PRESENT 1 BAD CONDITION 5 OK 9 GOOD LAST PAINT 6 N TODAYS MUST BE PRESENT ED DATE DATE OR_ VALID DATE LESS CELL UNDER 1 A Y N IF ABSENT THEN N INDICATES CELL REPAIR CANNOT BE USED Copyright C S Johnson 1994 2006 20 SHIPs System Specification Version 3 0 7 2 1 2 Screen Two contd Field Name Size Type Range Validation Notes amp Function COMMENT 2X30 X FREE FORMAT CONTROL 1 A E Q E Q OR BLANK E RETURN TO SCRN FIELD ONE NO UPDATE Q RETURN TO MENU NO UPDATE BLANK UPDATE amp RETURN TO SCRN ONE N B This screen will be somewhat modified if the required record is a hospital bed The comment field is not displayed for a Hospital bed as it refers to the prisoners illness 7 2 2 Change Cell Bed Details 7 2 2 1 Screen One Field Name Size Type Range Validation Notes amp Function CELL BLOCK 1 A A B C D MUST BE PRESENT A B C D NORMAL E H WINGS E HIGH SECUR H HOSPITAL CELL NUMBER 3 N 1 240 MUST BE PRESENT CELL BED MUST A B C D 1 120 BE IN TABLE E 1 240 H 1 40 CONTROL 1 A Q Q OR BLANK Q RETURN TO MENU FIELD BLANK SCREEN TWO Copyright C S Johnson 1994 2006 21 SHIPs System Specification Version 3 0 7 2 2 2 Screen Two Field Name Size Type Range Validation Notes amp Function CELL FLOOR
3. DELETE MUST BE DELETE IF DELETE THEN FIELD ELSE IGNORE DELETE RECORD ELSE NO CHANGE CONTROL 1 A E Q E Q OR BLANK E RETURN TO SCRN FIELD ONE NO UPDATE Q RETURN TO MENU NO UPDATE BLANK UPDATE amp RETURN TO SCRN ONE Copyright C S Johnson 1994 2006 30 SHIPs System Specification Version 3 0 7 5 Prisoner Allocation Sub System 7 5 1 Cell Allocation 7 5 1 1 Screen One Field Name Size Type Range Validation Notes amp Function PRISONER 6 N 1 OPTIONAL CHECK TO SEE IF NUMBER 999999 IN PRIS TABLE MUST HAVE NO CELL ALLOC SURNAME 30 A IF NUMBER PRESENT EITHER NUMBER OR IGNORE ELSE MUST h SURNAME amp FIRST BE PRESENT MUST BE PRESENT FIRST NAME 15 A IF SURNAME PRESNT CHANGED TO LOWER MANDATORY CASE j MIDDLE NAME 2 A OPTIONAL ONLY USE FIRST LETTER FOR X REF NAME TABLE CONTROL 1 A Q Q OR BLANK Q RETURN TO MENU FIELD BLANK SCREEN TWO NEW CELL 1 A A B C D MUST BE PRESENT CELL MUST BE IN BLOCK E TABLE AND MUST HAVE A VACANCY NEW CELL 3 N 1 240 MUST BE PRESENT NUMBER A B C D 1 120 E 1 240 7 5 1 2 Screen Two Field Name Size Type Range Validation Notes amp Function WORK LOC 3 X K1 10 MUST BE PRESENT K KITCHEN L1 5 UNLESS CELL BLCK L LAUNDRY M1 30 E M METAL SHOP G1 10 G GARDEN W1 5 W WOOD SHOP LI 2 LI LIBRARY NUMBERS EQUAL WORK GROUP LAST DATE 6 N TODAYS ASSIGNED BY OF ARRIVAL DATE SYSTEM CLEARS DEPART DATE
4. Name Size Type Range Validation Notes amp Function GUARD NO 6 N 1 MUST NOT BE IN GUARD NO TO BE 999999 GUARD TABLE MUST CHANGED BE PRESENT CONTROL 1 A Q Q OR BLANK Q RETURN TO MENU FIELD BLANK SCREEN TWO 7 4 2 2 Screen Two Field Name Size Type Range Validation Notes amp Function GUARD NAME 30 A FREE MUST BE PRESENT FORMAT CONTROL 1 A E Q E Q OR BLANK E RETURN TO SCRN FIELD ONE NO UPDATE Q RETURN TO MENU NO UPDATE BLANK UPDATE amp RETURN TO SCRN ONE Copyright C S Johnson 1994 2006 29 SHIPs System Specification Version 3 0 7 4 3 Enquiry On Guard 7 4 3 1 Screen One Field Name Size Type Range Validation Notes amp Function GUARD NO 6 N 1 MUST NOT BE IN GUARD NO TO BE 999999 GUARD TABLE MUST ENQUIRED IN BE PRESENT CONTROL 1 A Q Q OR BLANK Q RETURN TO MENU FIELD BLANK SCREEN TWO 7 4 3 2 Screen Two Field Name Size Type Range Validation Notes amp Function CONTROL 1 JA Q Q OR BLANK E RETURN TO MENU BLANK RETURN TO SCREEN ONE 7 4 4 Delete Guard 7 4 4 1 Screen One Field Name Size Type Range Validation Notes amp Function GUARD NO 6 N 1 MUST NOT BE IN GUARD NO TO BE 999999 GUARD TABLE MUST DELETED BE PRESENT CONTROL 1 A Q Q OR BLANK Q RETURN TO MENU FIELD BLANK SCREEN TWO 7 4 4 2 Screen Two Field Name Size Type Range Validation Notes amp Function DELETE 6 A
5. OPTIONAL ONLY SE FIRST IGNORE CASE LETTER FOR X REF NAME TABLE CONTROL 1 A Q Q OR BLANK Q RETURN TO MENU FIELD BLANK SCREEN TWO 7 1 1 2 Screen Two Field Name Size Type Range Validation Notes amp Function AGE 2 N 18 99 MUST BE PRESENT BUILD 1 A L M H MUST BE PRESENT SPECIFIES BUILD OF PRISONER L LIGHT M MEDIUM H HEAVY HEIGHT 1 A S M T MUST BE PRESENT SPECIFIES HEIGHT OF PRISONER S SHORT M MEDIUM T TALL DATE OF 6 N TODAYS NONE ASSIGNED BY RECORD DATE SYSTEM CLEARS DEPART DATE ARRIVAL DATE CONVICTION 2X30 X FREE MUST BE PRESENT DETAILS OF FORMAT OFFENSE CONVICTION 6 N DATE lt VALID DATE DATE TODAY Copyright C S Johnson 1994 2006 14 SHIPs System Specification Version 3 0 7 1 1 2 Screen Two contd Field Name Size Type Range Validation Notes amp Function SENTENCE 2 N 0 50 OPTIONAL ONE OF THESE YEARS FIELDS MUST BE GREATER THAN SENTENCE 2 N 0 12 OPTIONAL ZERO MONTHS SENTENCE 2 N 0 31 OPTIONAL DAYS INIT PAROLE 2 N 0 50 OPTIONAL ONE OF THESE YEARS FIELDS MUST BE GREATER THAN INIT PAROLE 2 N 0 12 OPTIONAL ZERO MUST BE MONTHS LESS THAN SENTENCE INIT PAROLE 2 N 0 31 OPTIONAL DAYS CURR PAROLE 2 N 0 50 OPTIONAL ONE OF THESE YEARS FIELDS MUST BE GREATER THAN CURR PAROLE 2 N 0 12 OPTIONAL ZERO MUST BE MONTHS LESS THAN SENTENCE IF CURR PAROLE 2 N 0 31 OPTIONAL BLAN
6. VALID DATE DATE DATE SENTENCE 2 N 0 50 OPTIONAL ONE OF THESE YEARS FIELDS MUST BE GREATER THAN Copyright C S Johnson 1994 2006 16 SHIPs System Specification Version 3 0 7 1 2 2 Screen Two contd Field Name Size Type Range Validation Notes amp Function SENTENCE 2 N 0 12 OPTIONAL ZERO MONTHS SENTENCE 2 N 0 31 OPTIONAL DAYS INIT PAROLE 2 N 0 50 OPTIONAL ONE OF THESE YEARS FIELDS MUST BE GREATER THAN INIT PAROLE 2 N 0 12 OPTIONAL ZERO MUST BE MONTHS LESS THAN SENTENCE INIT PAROLE 2 N 0 31 OPTIONAL DAYS CURR PAROLE 2 N 0 50 OPTIONAL ONE OF THESE YEARS FIELDS MUST BE GREATER THAN CURR PAROLE 2 N 0 12 OPTIONAL ZERO MUST BE MONTHS LESS THAN SENTENCE CURR PAROLE 2 N 0 31 OPTIONAL DAYS SECURITY 1 A L M H MUST BE PRESENT SPECIFIES HEIGHT RATING OF PRISONER L LOW M MEDIUM H HIGH COMMENT 2X30 X FREE IN CHAR POS IF CHANGED UPDATE FORMAT CLEARS COMMENT GUARD NO COMMENT 6 N TODAYS NONE ASSIGNED BY DATE DATE SYSTEM WHEN COMMENT CHANGED CONTROL 1 A E Q E Q OR BLANK E RETURN TO SCRN FIELD ONE NO UPDATE Q RETURN TO MENU NO UPDATE BLANK UPDATE amp RETURN TO SCRN ONE N B Blank inputs are interpreted as no change to existing data except for the comment Copyright C S Johnson 1994 2006 17 SHIPs System Specification Version 3 0 7 1 3 Enquiries on Prisoner 7 1 3
7. addition change delete and inquiry A password that is suspended cannot be used to gain access to the system The security rating of the password refers to the amount of information that is displayed by the various inquiry programs Security level 1 is given minimal information security level 9 has access to all information The associated cell block determines what cell block the holder of that password has access to A cell block type of Z has access to all cellblocks Thus movement of prisoners between cell blocks has to be performed by a guard with access type Z The associated sub systems determines what access a particular password has The associated functions determines whether a guard using that password can add change delete and or inquiry The Find Cell application is regarded as a change Included in this sub system are the various report listings required These are detailed in Section 8 0 Copyright C S Johnson 1994 2006 SHIPs System Specification Version 3 0 5 0 Hardware The SHIPS system will be based on MS Windows XP running under Windows 2005 Server with GUT screens The database will be SQL Server 2005 6 0 DB Design There are 7 relational tables in the system They are 1 Prisoners table 2 Prisoners name cross reference table 3 Cellblock table 4 Hospital bed table 5 Audit table 6 Password table 7 Guards table N B These tables do not necessarily have to be set up individuall
8. e g some enquires will show prisoners in the cell others will not Included in this sub system are the various report listings required These are detailed in Section 8 0 4 3 The Accommodation Sub System This sub system keeps track of the location of a prisoner It allows allocation of a prisoner to a cell moving of prisoners from one cell to another or to the hospital and the removal of a prisoner on the prisoners departure Also the Find Cell application will let the system find the most appropriate cell Cells should have the appropriate number of beds and mattresses for the number of prisoners in a cell A cell under repair cannot hold prisoners There are five online applications in this system 1 Allocation of a cell for a prisoner This function will only be carried out on arrival of a prisoner to the prison All prisoners must be assigned a cell a prisoner going straight into hospital will still be assigned a cell This application updates the last arrival date in the prisoners table as well as the prisoners cell allocation 2 Find a cell This application attempts to find a cell location for a prisoner It uses the information in the prisoners record as well as information on other prisoners in cells In attempting to find a cell a number of rules apply They are Preference is given to having three prisoners in a cell rather than two Cells should be filled from the ground up Prisoners of the same height and build
9. 0 CONTROL 1 A Q Q OR BLANK Q RETURN TO MENU FIELD BLANK SCREEN TWO 7 2 3 2 Screen Two Information for the various enquires on cells will require a number of screens displaying differing subsets according to the type of password functions and cell block access of the enquirer Field Name Size Type Range Validation Notes amp Function CONTROL 1 A Q QOR BLANK E RETURN TO MENU BLANK RETURN TO SCREEN ONE Copyright C S Johnson 1994 2006 23 SHIPs System Specification Version 3 0 7 2 4 Delete Cell Bed 7 2 4 1 Screen One Field Name Size Type Range Validation Notes amp Function CELL BLOCK 1 A A B C D MUST BE PRESENT A B C D NORMAL E H WINGS E HIGH SECUR H HOSPITAL CELL NUMBER 3 N 1 240 MUST BE PRESENT CELL BED MUST A B C D 1 120 BE IN TABLE E 1 240 H 1 40 CONTROL 1 A Q Q OR BLANK Q RETURN TO MENU FIELD BLANK SCREEN TWO N B A bed cell cannot be deleted if it has prisoners in it or it has furniture 7 2 4 2 Screen Two Field Name Size Type Range Validation Notes amp Function DELETE 6 A DELETE MUST BE DELETE IF DELETE THEN FIELD ELSE IGNORE DELETE RECORD ELSE NO CHANGE CONTROL 1 A E Q E Q OR BLANK E RETURN TO SCRN FIELD ONE NO UPDATE Q RETURN TO MENU NO UPDATE BLANK UPDATE amp RETURN TO SCRN ONE Copyright C S Johnson 1994 2006 24 SHIPs System Spe
10. 1 N 1 3 MUST BE PRESENT HOSPITAL ONLY HAS IF H THEN 1 2 2 FLOORS NO OF BEDS 1 N 0 3 A B C D MAX 3 E MAX 1 H IGNORE NO OF 1 N 0 3 A B C D MAX 3 MATTRESSES E MAX 1 H IGNORE NO OF 1 N 0 3 A B C D MAX 3 CHAIRS E MAX 1 H IGNORE NO OF 1 N 0 3 A B C D MAX 1 TABLES E MAX 1 H IGNORE CELL 1 N 1 9 MUST BE PRESENT 1 BAD CONDITION 5 OK 9 GOOD LAST PAINT 6 N TODAYS MUST BE PRESENT ED DATE DATEOR VALID DATE LESS CELL UNDER 1 A Y N IF ABSENT THEN N INDICATES CELL REPAIR CANNOT BE USED COMMENT 2X30 X FREE IN CHAR POS FORMAT l CLEARS COMMENT CONTROL 1 A E Q E Q OR BLANK E RETURN TO SCRN FIELD ONE NO UPDATE Q RETURN TO MENU NO UPDATE BLANK UPDATE amp RETURN TO SCRN ONE N B Blank inputs are interpreted as no change to existing data except for the comment This screen will be somewhat modified if the required record is a hospital bed The comment field is not displayed for a Hospital bed as it contains details on the prisoner s illness A cell cannot be under repair if there are prisoners in it Copyright C S Johnson 1994 2006 22 SHIPs System Specification Version 3 0 7 2 3 Enquiry on Cell Bed 7 2 3 1 Screen One Field Name Size Type Range Validation Notes amp Function CELL BLOCK 1 A A B C D MUST BE PRESENT A B C D NORMAL E H WINGS E HIGH SECUR H HOSPITAL CELL NUMBER 3 N 1 240 MUST BE PRESENT CELL BED MUST A B C D 1 120 BE IN TABLE E 1 240 H 1 4
11. 1 Screen One Field Name Size Type Range Validation Notes amp Function PRISONER 6 N 1 OPTIONAL CHECK TO SEE IF NUMBER 999999 IN PRIS TABLE SURNAME 30 A IF NUMBER PRESENT EITHER NUMBER OR IGNORE ELSE MUST SURNAME amp FIRST BE PRESENT MUST BE PRESENT FIRST NAME 15 A IF SURNAME PRESNT CHANGED TO LOWER MANDATORY CASE j MIDDLE NAME 2 A OPTIONAL ONLY USE FIRST LETTER FOR X REF NAME TABLE CONTROL 1 A Q Q OR BLANK Q RETURN TO MENU FIELD BLANK SCREEN TWO 7 1 3 2 Screen Two Information for the various enquires on prisoners will require a number of screens displaying differing subsets according to the type of password functions and cell block access of the enquirer Field Name Size Type Range Validation Notes amp Function CONTROL 1 lA Q Q OR BLANK E RETURN TO MENU BLANK RETURN TO SCREEN ONE Copyright C S Johnson 1994 2006 18 SHIPs System Specification Version 3 0 7 1 4 Delete Prisoner Details 7 1 4 1 Screen One Field Name Size Type Range Validation Notes amp Function PRISONER 6 N 1 OPTIONAL CHECK TO SEE IF NUMBER 999999 IN PRIS TABLE SURNAME 30 A IF NUMBER PRESENT EITHER NUMBER OR FIRST NAME 15 A MIDDLE NAME 2 A CONTROL 1 A IQ FIELD IGNORE ELSE MUST BE PRESENT IF SURNAME PRESNT MANDATORY OPTIONAL Q OR BLANK h SURNAME amp FIRST MUST BE PRESENT CHANGED TO LOWER CASE j ONLY USE F
12. 994 2006 34 SHIPs System Specification Version 3 0 7 5 4 Prisoner Departure 7 5 4 1 Screen One Field Name Size Type Range Validation Notes amp Function PRISONER 6 N 1 OPTIONAL CHECK TO SEE IF NUMBER 999999 IN PRIS TABLE MUST HAVE CELL ALLOC SURNAME 30 A IF NUMBER PRESENT EITHER NUMBER OR FIRST NAME 15 A IGNORE ELSE MUST BE PRESENT IF SURNAME PRESNT SURNAME amp FIRST MUST BE PRESENT CHANGED TO LOWER MANDATORY CASE MIDDLE NAME 2 A OPTIONAL ONLY USE FIRST LETTER FOR X REF NAME TABLE CONTROL 1 A Q Q OR BLANK Q RETURN TO MENU FIELD BLANK SCREEN TWO 7 5 4 2 Screen Two Field Name Size Type Range Validation Notes amp Function DEPART 6 A DEPART MUST BE DEPART IF DEPART THEN FIELD ELSE IGNORE PUT TODAYS DATE IN PRIS REC CLEAR CELL DATA CONTROL 1 A E Q E Q OR BLANK E RETURN TO SCRN FIELD ONE NO UPDATE Q RETURN TO MENU NO UPDATE BLANK UPDATE amp RETURN TO SCRN ONE N B Clears both cell and hospital details if the prisoner is in hospital Copyright C S Johnson 1994 2006 35 SHIPs System Specification Version 3 0 7 5 5 Enquire on Cell Prisoner Relation 7 5 5 1 Screen One Field Name Size Type Range Validation Notes amp Function PRISONER 6 N 1 OPTIONAL CHECK TO SEE IF NUMBER 999999 IN PRIS TABLE MUST HAVE CELL ALLOC SURNAME 30 A OPTIONAL EITHER NUMBER OR SU
13. IRST LETTER FOR X REF NAME FELE Q RETURN TO MENU BLANK SCREEN TWO N B Record cannot be deleted if last arrived date field has a date 7 1 4 2 Screen Two Field Name Size Type Range Validation Notes amp Function DELETE 6 A DELETE MUST BE DELETE IF DELETE THEN FIELD ELSE IGNORE DELETE RECORD ELSE NO CHANGE CONTROL 1 A E Q E Q OR BLANK E RETURN TO SCRN FIELD ONE NO UPDATE Q RETURN TO MENU NO UPDATE BLANK UPDATE amp RETURN TO SCRN ONE Copyright C S Johnson 1994 2006 19 SHIPs System Specification Version 3 0 7 2 Cell Hospital Block 7 2 1 Add Cell Bed 7 2 1 1 Screen One Field Name Size Type Range Validation Notes amp Function CELL BLOCK 1 A A B C D MUST BE PRESENT A B C D NORMAL E H WINGS E HIGH SECUR H HOSPITAL CELL NUMBER 3 N 1 240 MUST BE PRESENT CELL BED MUST A B C D 1 120 NOT BE IN TABLE E 1 240 H 1 40 CONTROL 1 A Q Q OR BLANK Q RETURN TO MENU FIELD BLANK SCREEN TWO 7 2 1 2 Screen Two Field Name Size Type Range Validation Notes amp Function CELL FLOOR 1 N 1 3 MUST BE PRESENT HOSPITAL ONLY HAS IF H THEN 1 2 2 FLOORS NO OF BEDS 1 N 0 3 A B C D MAX 3 HOSPITAL ALWAYS E MAX 1 H IGNORE HAS A BED NO OF 1 N 0 3 A B C D MAX 3 HOSPITAL ALWAYS MATTRESSES E MAX 1 H IGNORE HAS A MATTRESS NO OF 1 N 0 3 A B C D MAX 3 BLANK ASSUME CHAIRS E MAX 1 H IGNORE ZERO NO OF 1 N 0
14. K SAME AS DAYS INIT PAROLE SECURITY 1 A L M H MUST BE PRESENT SPECIFIES HEIGHT RATING OF PRISONER L LOW M MEDIUM H HIGH COMMENT 2X30 X FREE IF NOT BLANK FORMAT UPDATE GUARD NO COMMENT 6 N TODAYS NONE ASSIGNED BY DATE DATE SYSTEM WHEN COMMENT CHANGED CONTROL 1 A E Q E Q OR BLANK Q RETURN TO SCRN FIELD ONE NO UPDATE E RETURN TO MENU UPDATE RECORD BLANK UPDATE amp RETURN TO SCRN ONE Copyright C S Johnson 1994 2006 15 SHIPs System Specification Version 3 0 7 1 2 Change Prisoner Details 7 1 2 1 Screen One Field Name Size Type Range Validation Notes amp Function PRISONER 6 N 1 OPTIONAL CHECK TO SEE IF NUMBER 999999 IN PRIS TABLE SURNAME 30 A IF NUMBER PRESENT _ EITHER NUMBER OR IGNORE ELSE MUST SURNAME amp FIRST BE PRESENT MUST BE PRESENT FIRST NAME 15 A IF SURNAME PRESNT CHANGED TO LOWER MANDATORY CASE j MIDDLE NAME 2 A OPTIONAL ONLY USE FIRST LETTER FOR X REF NAME TABLE CONTROL 1 A Q Q OR BLANK Q RETURN TO MENU FIELD BLANK SCREEN TWO 7 1 2 2 Screen Two Field Name Size Type Range Validation Notes amp Function AGE 2 N 18 99 MUST BE PRESENT BUILD 1 A L M H MUST BE PRESENT SPECIFIES BUILD OF PRISONER L LIGHT M MEDIUM H HEAVY HEIGHT 1 A S M T MUST BE PRESENT SPECIFIES HEIGHT OF PRISONER S SHORT M MEDIUM T TALL CONVICTION 2X30 X FREE MUST BE PRESENT DETAILS OF FORMAT OFFENSE CONVICTION 6 N lt INIT
15. L 1 A Q Q OR BLANK Q RETURN TO MENU FIELD BLANK SCREEN TWO 7 3 2 2 Screen Two Field Name Size Type Range Validation Notes amp Function SUSPENDED 1 A Y N N IF BLANK PASSWORD CAN NOT USED SECURITY 1 N 1 9 MUST BE PRESENT LEVEL ASSOCIATED 1 A A B C D ONE MUST BE Z ALL CELL CELL BLOCKS E H Z PRSENT BLOCKS ASSOCIATED 4 A P C S A ONE MUST BE P PRISONERS SUB SYSTEMS PRESENT C CELLS S SECURITY A CELL ALLOC ASSOCIATED 4 A A C D E ONE MUST BE A ADD RECORDS FUNCTIONS PRESENT C CHANGE RECDS D DELETE RECDS E ENQUIRE RECS CONTROL 1 A E Q E Q OR BLANK E RETURN TO SCRN FIELD ONE NO UPDATE Q RETURN TO MENU NO UPDATE BLANK UPDATE amp RETURN TO SCRN ONE N B Blank inputs are interpreted as no change to existing data except for the comment Copyright C S Johnson 1994 2006 26 SHIPs System Specification Version 3 0 7 3 3 Enquiry On Password 7 3 3 1 Screen One Field Name Size Type Range Validation Notes amp Function PASSWORD 6 X FREE MUST BE PRESENT PASSWORD TO FORMAT MUST BE IN ENQUIRE OM PASSWORD TABLE CONTROL 1 A Q Q OR BLANK Q RETURN TO MENU FIELD BLANK SCREEN TWO 7 3 3 2 Screen Two Field Name Size Type Range Validation Notes amp Function CONTROL 1 JA Q Q OR BLANK E RETURN TO MENU BLANK RETURN TO SCREEN ONE 7 3 4 Delete Password 7 3 4 1 Screen One Field Name Size T
16. RNAME amp FIRST MUST BE PRESENT FIRST NAME 15 A IF SURNAME PRESNT CHANGED TO LOWER MANDATORY CASE MIDDLE NAME 2 A OPTIONAL ONLY USE FIRST LETTER FOR X REF NAME TABLE CELL BLOCK 1 A A B C D OPTIONAL CELL MUST BE IN E H TABLE CELL NUMBER 3 N 1 240 OPTIONAL IF CELL BLOCK PRESENT MUST BE PRESENT A B C D 1 120 E 1 240 H 1 40 CONTROL 1 A Q Q OR BLANK Q RETURN TO MENU FIELD BLANK SCREEN TWO N B Either a prisoner or a cell must be specified 7 5 5 2 Screen Two Field Name Size Type Range Validation Notes amp Function CONTROL 1 A Q Q OR BLANK Q RETURN TO MENU FIELD BLANK SCREEN TWO Copyright C S Johnson 1994 2006 36 SHIPs System Specification Version 3 0 8 0 Report Layouts All reports will have heading and trailing logos The reports cover 1 6 List of cells beds full not full empty under repair furniture listing blocks floors empty under repair List of prisoners no and alphabetic abbreviated or full listing not in prison not allocated served sentence in hospital by block floor due for release next month parole increased decreased by security by age by date of conviction by length in prison List of cells and prisoners full cells not full by block by floor Audit table listing by date time cell no prisoner no guard no type of transaction password access subsystem List of Passwords suspended ok List if Guards no name All p
17. The Short Bay Information on Prisoners System SHIPS System Specification By Chris S Johnson Date 7th July 1985 Revised 14th February 1994 Revised 29th August 2005 Revised 28th September 2006 SHIPs System Specification Version 3 0 TABLE OF CONTENTS 1 0 Introduction 2 0 Background 3 0 System Overview 4 0 Detailed System Specifications 5 0 Hardware 6 0 Table Designs 7 0 Screen Layouts 8 0 Report Layouts 9 0 Program Specifications 10 0 Batch Job Requirements 11 0 Acceptance Testing Copyright C S Johnson 1994 2006 SHIPs System Specification Version 3 0 1 0 Introduction This report is a specification for the computerisation of the Prisoner s records at the Short Bay Prison It was instigated by the Prison Governor who realised that the current manual system was inefficient and likely to be inaccurate with the steady increase of work caused by Government demands The Administration staff consists of a supervisor and six Guards who perform the clerical duties for the Prison Over the past few years the clerical load especially the reporting has increased to the point where the staff are unable to cope satisfactorily The Prison Governor called in a team of consultants who recommended the computerisation of the prison records It has been decided that the development will be a server based PC LAN strategy No outside communication lines are envisaged Initially there will be nine conne
18. ard no key 6 Guard name 8 30 Date of entry 6 Entered by name 30 gt Z gt zZ Copyright C S Johnson 1994 2006 12 SHIPs System Specification Version 3 0 7 0 Screen Layouts Screen layouts will be consistent throughout the system and will conform to organizational standards Errors in input fields will be high lighted by making the field blink and a specific appropriate error message 7 0 1 Log On Screen Field Name Size Type Range Validation Notes amp Function PASSWORD 6 X FREE MUST BE PRESENT ONLY 3 ATTEMPTS FORMAT MUST BE IN PASS ALLOWED NOT WORD TABLE SHOWN ON SCREEN GUARD NO 6 N 1 MUST BE IN GUARD 999999 TABLE MUST BE PRESENT 7 0 2 Menu Selection Screen Field Name Size Type Range Validation Notes amp Function MENU SELECT 4 X A Z 0 9 ION FIELD Q OR APPLICATION Q LOG UT ELSE N APPLICATION CHOICE Copyright C S Johnson 1994 2006 13 SHIPs System Specification Version 3 0 7 1 Prisoner Table 7 1 1 Add a New Prisoner Application 7 1 1 1 Screen One Field Name Size Type Range Validation Notes amp Function PRISONER 6 N 1 MUST BE PRESENT CHECK TO SEE NOT NUMBER 999999 UNIQUE ALREADY IN TABLE SURNAME 30 A CANNOT BE BLANK CHECK TO SEE NOT IGNORE CASE ALREADY IN X REF TABLE UPPER CASE FIRST NAME 15 A CANNOT BE BLANK CHANGED TO IGNORE CASE LOWER CASE j MIDDLE NAME 15 A
19. are preferred in the same cell Extreme differences are not allowed in height if only two prisoners are in the cell 5 High security prisoners must be assigned cells in cell block E Fe nt ee The relative order of importance of these rules is 5 4 1 2 3 N B In the allocation of a prisoner or the change of cell for a prisoner warning messages should be displayed if these rules are broken 3 Change a cell bed This function allows a prisoner to be moved from cell to cell or to the hospital 4 Departure of a prisoner This application has two modes one when a prisoner leaves the prison which updates the departure date in the prisoners record the second when a prisoner moves from the hospital back to his cell A prisoner in hospital must have his hospital location deleted before he can leave the prison Copyright C S Johnson 1994 2006 SHIPs System Specification Version 3 0 5 Enquires on a prisoner There will be a number of differing types of enquiries available depending on the security level of the enquirer e g some enquiries will show all prisoners in the cell others will not Included in this sub system are the various report listings required These are detailed in Section 8 0 4 4 The Security Sub System This sub system maintains records of guards and passwords and also enables the logging of all transactions The maintenance of the guards and the passwords is fairly straight forward the applications being
20. asswords to be encoded in the Password Table All prisoners names in all tables including the Audit Table and all guards names are to be encoded After three attempts at a password or a Guard No then system terminates After ten incorrect attempts in a processing run then the system terminates All change transactions to any table are to be logged in the Audit Table including all attempts to the Password table logging on details and unsuccessful attempts If possible the PC identifier that the transactions are carried out on should be included N B Initially a simple alphabetic substitution will suffice for the encoding of all information A better encoding system is currently under investigation Copyright C S Johnson 1994 2006 37 SHIPs System Specification Version 3 0 9 0 Program Specifications All table input outputs open closes will be checked The program to be terminated if any error detected with appropriate error messages Extensive reuse of code is expected e g programs will be developed from the same skeleton as will all report programs OO programming is expected o screen layouts will be laid out separately for each screen and fields will be uniquely identified throughout the whole system o handling of each screen s input output will be completely separate from every other screen o error messages will be set up as constants o testing messages must be incorporated from the beginning and genera
21. cification Version 3 0 7 3 Password Table All accesses to the Password table will be logged whether or not they are successful 7 3 1 Add Password 7 3 1 1 Screen One Field Name Size Type Range Validation Notes amp Function PASSWORD 6 X FREE MUST BE PRESENT PASSWORD TO FORMAT MUST NOT BE IN ADD PASSWORD TABLE CONTROL 1 A Q Q OR BLANK Q RETURN TO MENU FIELD BLANK SCREEN TWO 7 3 1 2 Screen Two Field Name Size Type Range Validation Notes amp Function SUSPENDED 1 A Y N N IF BLANK PASSWORD CAN NOT USED SECURITY 1 N 1 9 MUST BE PRESENT LEVEL ASSOCIATED 1 A A B C D ONE MUST BE Z ALL CELL CELL BLOCKS E H Z PRESENT BLOCKS ASSOCIATED 4 A P C S A ONE MUST BE P PRISONERS SUB SYSTEMS PRESENT C CELLS S SECURITY A CELL ALLOC ASSOCIATED 4 A A C D E ONE MUST BE A ADD RECORDS FUNCTIONS PRESENT C CHANGE RECDS D DELETE RECDS E ENQUIRE RECS PASSWORD 6 N TODAYS ASSIGNED BY PASSWORD CREATION DATE DATE SYSTEMS DATE CONTROL 1 A E Q E Q OR BLANK E RETURN TO SCRN FIELD ONE NO UPDATE Q RETURN TO MENU NO UPDATE BLANK UPDATE amp RETURN TO SCRN ONE Copyright C S Johnson 1994 2006 25 SHIPs System Specification Version 3 0 7 3 2 Change Password 7 3 2 1 Screen One Field Name Size Type Range Validation Notes amp Function PASSWORD 6 X FREE MUST BE PRESENT PASSWORD TO FORMAT MUST BE IN CHANGE PASSWORD TABLE CONTRO
22. cted PCs Three will be located in the clerical office and one in each of the five cell blocks and one in the hospital block The security of the system in regard to access to the hardware and access to the information stored has been one of the major concerns of the Prison Governor 2 0 Background Short Bay Prison is one of a number of Government operated prisons in the medium to high security classification Prisoners are interned in Short Bay from periods ranging from six months to life depending on their sentence and their security rating Prisoners are often transferred to low security prisons if they are of good behaviour Occasionally prisoners are returned from low security prisons Also troublesome prisoners are often swapped from one prison to another in the hope that the change of environment will have a beneficial effect on their behaviour Short Bay prison consists of four cellblocks called A B C amp D all medium security and a high security cellblock called E for solitary confinement of high security prisoners Also there is a hospital wing called H which has a fully equipped operating theatre where all but the most major of operations can be carried out by visiting doctors Within the prison walls there are 1 A prison kitchen all meals are actually eaten in the cellblocks A prison laundry 2 3 A metal working shop for automobile number plates 4 A garden for vegetables the prison is quite proud
23. e enquires will show cell details others will not An archive program is also required that will list all prisoners whose sentence has been served This program will also remove all of these prisoners from the prisoner table Included in this sub system are the various report listings required These are detailed in Section 8 0 4 2 The Cell Block Sub System This sub system maintains records of cells and hospital beds It keeps track of the furniture in the cell and the condition of the cell Although the prisoners in the cell are in this table the prisoners details are not maintained by this system There are four online applications in this system Copyright C S Johnson 1994 2006 SHIPs System Specification Version 3 0 1 Addition of a cell hospital bed This task should only occur when the system is being set up As well as identifying the cell to the system details of the furniture and cell condition will also be added 2 Changing of details entered in the addition application A cell cannot be placed under repair if it holds prisoners There must be an equivalent number of mattresses and beds to the number of prisoners in the cell 3 Deletion of a cell details This application is intended to be used only when an error has been made in the addition of a cell s record 4 Enquires on a cell hospital There will be a number of differing types of enquires available depending on the security level of the enquirer
24. er tables from back ups BATCH JOB to do an automatic system start from a User Id i e no user intervention BATCH JOB to copy all source programs libraries from the development directory BATCH JOB to compile all programs in the system OOF Se ON SOE a oe Le BATCH JOB to copy all the executable versions of the programs from the Production directory to the Operating directory 11 0 Acceptance Testing At each milestone testing of the user interface will be carried out and print outs of table contents expected system utilities may be used initially A final set of test data will be used to test not only the user interface but the complete workings of the system as well as print outs of all tables and reports A separate audit review will be carried out to test the security and audit logging of the system Any program that fails any of the tests will be deemed unsatisfactory If required a complete but different set of test data will be supplied at an earlier stage but only once Included for acceptance will be a Users Manual and a presentation of the system to prison management and representation from the Prison Guard s Union The User s Manual must be on line as it is planned at a latter stage to make the on line Users manual the basis of a training and Help sub system Copyright C S Johnson 1994 2006 39
25. g the metal working shop these being of lower priority This system comprises of four sub systems 1 The Prisoners Sub system which maintains records of each prisoner 2 The Cell Block Sub system which maintains records of the cells both medium and high security as well as the hospital accommodation 3 The Accommodation Sub system which maintains records of Cell Allocation of prisoners included in this sub system is the application to find a free cell space 4 The Security Access Sub System which maintains records of passwords and guards with access to the system Included in this system is the Audit module which will allow tracing of changes to the prison database giving time date before and after images Guard No and type of change Copyright C S Johnson 1994 2006 SHIPs System Specification Version 3 0 4 0 Detailed System Specification The structure of the tables in the system are outlined in Section 6 Validation of the screens are outlined in Section 7 4 1 The Prisoner Sub System This sub system maintains records of the prisoners name brief personnel details sentence parole information and information on the prisoners location in the prison As a prisoner may spend a number of periods in the prison this record is maintained online until the release date of the prisoner if the prisoner receives further convictions then his release date will be updated Prisoners must be able to be accessed either b
26. gh beds and mattresses for the number of prisoners if not display a message to screen Copyright C S Johnson 1994 2006 33 SHIPs System Specification Version 3 0 7 5 3 Change Cell Bed 7 5 3 1 Screen One Field Name Size Type Range Validation Notes amp Function PRISONER 6 N 1 OPTIONAL CHECK TO SEE IF NUMBER 999999 IN PRIS TABLE MUST HAVE CELL ALLOC SURNAME 30 A IF NUMBER PRESENT EITHER NUMBER OR IGNORE ELSE MUST SURNAME amp FIRST BE PRESENT MUST BE PRESENT FIRST NAME 15 A IF SURNAME PRESNT_ CHANGED TO LOWER MANDATORY CASE MIDDLE NAME 2 A OPTIONAL ONLY USE FIRST LETTER FOR X REF NAME TABLE CONTROL 1 A Q Q OR BLANK Q RETURN TO MENU FIELD BLANK SCREEN TWO 7 5 3 2 Screen Two Field Name Size Type Range Validation Notes amp Function NEW CELL 1 A A B C D MUST BE PRESENT CELL MUST BE IN BLOCK E H TABLE AND MUST HAVE A VACANCY NEW CELL 3 N 1 240 MUST BE PRESENT NUMBER A B C D 1 120 E 1 240 H 1 40 COMMENT 2X30 X FREE CLEARS CURRENT HOSPITAL BED FORMAT COMMENT ONLY CONTROL 1 A E Q E Q OR BLANK E RETURN TO SCRN FIELD ONE NO UPDATE Q RETURN TO MENU NO UPDATE BLANK UPDATE amp RETURN TO SCRN ONE N B A cell must have enough beds and mattresses for the number of prisoners If prisoner moved to hospital then hospital location is added to the prisoners record The prisoner can t be in hospital Copyright C S Johnson 1
27. lly should be commented out not removed o except for massive hardware faults all programs should degrade gracefully from software faults with the user being notified of the problem o at any stage the user should be able to cancel a transaction o Transactions will consist of six stages 1 choose function from menu show user blank template to collect initial call up data 2 3 validate call up data if correct show screen two else show error messages 4 show user current data form appropriate record or blank screen for new input 5 collect input validate input return with accurate meaningful error messages to the user or on valid data update the tables update the Audit table 6 Go back for next input or show menu o the working and final production version of the software must operate within one directory for the executable programs one for the source and libraries one for the development test tables one forthe system test tables and one for the production tables o the system will be menu driven o passwords will not be shown on the screen Copyright C S Johnson 1994 2006 38 SHIPs System Specification Version 3 0 10 0 Batch Job Requirements The following macros must be set up in the appropriate job control language 1 BATCH JOB to run the system from a one word command e g SHIPS BATCH JOB to run the various reporting programs BATCH JOB to take back up copies of the data tables BATCH JOB to recov
28. of its self sufficiency in vegetables 5 A wood working shop for prison furniture repair and wooden articles for charity 6 A prison library 7 An administration building between the inner and outer walls no prisoners are allowed in the administration building Except for high security prisoners all other prisoners are expected to work in one of the above areas six days a week This gives them an earning capacity to buy such things as cigarettes sweets books and personal articles The prison has provision for 480 medium security and 60 high security prisoners Each cell block has three floors with 40 cells per floor Each cell can contain a maximum of Copyright C S Johnson 1994 2006 SHIPs System Specification Version 3 0 three prisoners The high security block E has three floors also each floor has 20 single occupancy cells This cellblock is very rarely full The hospital block has 40 beds divided up over two floors There are 240 guards of which the majority work normal hours and are involved with the working activities of the prison e g kitchen metalworking shop 3 0 System Overview The main purpose of this system is to simplify the record keeping and reporting of the prison clerical staff If this system is successful then further systems will be added such as a complete record of Guards Guard shift control and allocation and the integration of costing and purchasing of the prison activities e
29. r Initials 7 2 Z gt gt Prisoners Number 6 6 3 Cellblock Table Field Name Security Size Type Cell block Key 1 Cell number Key 3 Z gt Z Cell floor 1 Cell Occupants Prisoner 1 Number 6 Cell date 6 Prisoner 2 Number 6 Cell date 6 Prisoner 3 Number 6 Cell date 6 ZZZ ZZZ Cell Furniture No of beds No of mattresses No of tables No of chairs ZZZ Z Cell condition 1 Last painted date 6 Cell under repair 1 Comments 2 gt WwW S xr ZZ Copyright C S Johnson 1994 2006 10 SHIPs System Specification Version 3 0 6 4 Hospital Bed Table Field Name Security Size Type Hospital bed no Key 3 Hospital floor 1 Bed Occupant Prisoner Number 6 Arrival date 6 Expected departure date 6 Comments 2x30 XZZZ Z z 6 5 Audit Table Field Name Security Size Type Date Time Guard s No Prisoner s No From cell no Cell block Cell number To cell no Cell block 1 Cell number 3 Type of change code 2 Type of Change 2x30 AADA ZZZZ Woe Z gt Z Z D Copyright C S Johnson 1994 2006 11 SHIPs System Specification Version 3 0 6 6 Password Table Field Name Security Size Type Password key 9 Password Suspended Security Rating Associated Cell Blocks Associated sub systems Associated functions Password date Entered by guard no NDP RRR KD ZZP ZPX 6 7 Guards Table Field Name Security Size Type Gu
30. y they may be combined as long as the index functionality is retained It should be noted that the original version of this specification was written for a COBOL transaction based system While most references have been modified menu and screen controls refer to the original In designing this system appropriate labeled GUI buttons should be designed and displayed instead Copyright C S Johnson 1994 2006 SHIPs System Specification Version 3 0 6 1 Prisoners Table Field Name Security Size Type Prisoners Number Key 6 Prisoners Name Surname First name 7 15 Middle name 7 15 Age 2 Build 1 Height 1 Date of record 6 Date of last arrival 6 6 2 6 N w Date of last departure Conviction Date of Conviction Sentence Length Years 2 Months 2 Days 2 Initial parole period Years Months Days Current parole period Years Months Days Security Rating Current Prison details Cell block Cell number Bed block Bed number Work Location Comments Date of comment Guard no ZrzZZ gt rZ gt gt gt Z NNW ZZZ Z22Z NNN ZZZ Z DAN W WR We Z ZXZ Z To be added later Psychiatric Details Psychiatrist s comment 6x60 Date of comment 6 Psychiatrist s name 20 ay Copyright C S Johnson 1994 2006 SHIPs System Specification Version 3 0 6 2 Prisoners Name Cross Reference Table Field Name Security Size Type Prisoners Name Key Surname T 30 First name 7 15 Othe
31. y their number which is assigned manually when the record is added or by their surname first name and first initial If there is a clash then the second letter of the middle name will be used to make the entry unique This should only be required on the addition of a second prisoner with the same name Provision should be made for the manual input of the second letter if there is a clash on the entry of a third prisoner with the same name This function is not required in the current system If the situation occurs then the prisoner should be rejected with an appropriate error message When a prisoner arrives the date of arrival is entered into the system and this signifies that the prisoner is in residence When a prisoner leaves the prison his departure date is entered into the system thus a prisoner whose departure date is greater than his arrival date is not in residence There are four online applications in this system 1 Addition of a new prisoners details No data on the prisoners location is entered at this stage 2 Changing of details entered in the addition application 3 Deletion of a prisoner details This can only occur if the prisoner has never entered the prison This application is intended to be used only when an error has been made in the addition of a prisoner s record 4 Enquiries on a prisoner There will be a number of differing types of enquires available depending on the security level of the enquirer e g som
32. ype Range Validation Notes amp Function PASSWORD 6 X FREE MUST BE PRESENT PASSWORD TO FORMAT MUST BE IN DELETE PASSWORD TABLE CONTROL 1 A Q Q OR BLANK Q RETURN TO MENU FIELD BLANK SCREEN TWO 7 3 4 2 Screen Two Field Name Size Type Range Validation Notes amp Function DELETE 6 A DELETE MUST BE DELETE IF DELETE THEN FIELD ELSE IGNORE DELETE RECORD ELSE NO CHANGE CONTROL 1 A E Q E Q OR BLANK E RETURN TO SCRN FIELD ONE NO UPDATE Q RETURN TO MENU NO UPDATE BLANK UPDATE amp RETURN TO SCRN ONE Copyright C S Johnson 1994 2006 27 SHIPs System Specification Version 3 0 7 4 Guard Table 7 4 1 Add Guard 7 4 1 1 Screen One Field Name Size Type Range Validation Notes amp Function GUARD NO 6 N 1 MUST NOT BE IN GUARD NO TO BE 999999 GUARD TABLE MUST ADDED BE PRESENT CONTROL 1 A Q Q OR BLANK Q RETURN TO MENU FIELD BLANK SCREEN TWO 7 4 1 2 Screen Two Field Name Size Type Range Validation Notes amp Function GUARD NAME 30 A FREE MUST BE PRESENT FORMAT GUARD 6 N TODAYS ASSIGNED BY GUARD CREATION DATE DATE SYSTEM DATE CONTROL 1 A E Q E Q OR BLANK E RETURN TO SCRN FIELD ONE NO UPDATE Q RETURN TO MENU NO UPDATE BLANK UPDATE amp RETURN TO SCRN ONE Copyright C S Johnson 1994 2006 28 SHIPs System Specification Version 3 0 7 4 2 Change Guard 7 4 2 1 Screen One Field

(SHIPS) System Specification

Contents

Download Pdf Manuals

Related Search

Related Contents