Database Properties
Database Type: PostgreSQL - 17.9 (Debian 17.9-1.pgdg13+1)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| period_length_history | 0 | 1 | 20 | -1 | Table | |
| court_appearance_subtype | 1 | 1 | 7 | -1 | Table | |
| charge_history | 0 | 1 | 22 | -1 | Table | |
| sentence_type | 2 | 0 | 16 | 56 | Table | Description: Holds meta data that defines the properties of different sentence types. NOMIS Equivalent Entity: sentence_calc_types Domain: Court results including person sentences |
| recall | 1 | 1 | 16 | -1 | Table | Description: Holds recall information at a parent level, where multiple sentences may be affected by a recall. A recall is where an offender is out on licence and their licence is then revoked, requiring them to return to prison. Data Quality Issues: NOMIS only stores the most recent recall for an offender, the history of an offenders sentences prior to the latest recall cannot be seen. In RaS, all recalls and recall history are stored. It is not possible to look back retrospectively at recalls that have been made in the past through NOMIS. If a recall has been synced from NOMIS, then revocation will not be populated as this information is not recorded in NOMIS. Data Quality Parameter: Accuracy Source of Data Quality Issue: NOMIS NOMIS Equivalent Entity: offender_sentences Domain: Person Recalls |
| uploaded_document | 0 | 1 | 9 | -1 | Table | |
| sentence | 5 | 4 | 18 | -1 | Table | Description: Holds each instance of a sentence. NOMIS Equivalent Entity: offender_sentences Domain: Court results including person sentences |
| flyway_schema_history | 0 | 0 | 10 | 154 | Table | |
| court_appearance_history | 0 | 1 | 21 | -1 | Table | |
| sentence_history | 0 | 1 | 20 | -1 | Table | |
| court_case | 4 | 2 | 13 | -1 | Table | Description: Holds each instance of a court case. NOMIS Equivalent Entity: offender_cases Domain: Person Court Schedules |
| immigration_detention_history | 0 | 0 | 18 | -1 | Table | |
| appearance_charge | 0 | 2 | 5 | -1 | Table | Description: Holds the charge related to each court appearance. NOMIS Equivalent Entity: court_event_charges Domain: Person offences/convictions |
| court_appearance | 6 | 2 | 19 | -1 | Table | Description: Holds each instance of a court appearance. NOMIS Equivalent Entity: court_events, offender_cases, offender_case_identifiers Domain: Person Court Schedules |
| immigration_detention | 0 | 0 | 17 | -1 | Table | |
| recall_sentence_history | 0 | 1 | 12 | -1 | Table | |
| court_case_history | 0 | 1 | 15 | -1 | Table | |
| charge | 4 | 3 | 20 | -1 | Table | Description: Holds each instance of a charge. A charge is the offence a person as committed and is being charged for. Data Quality Issues: offence_date is a mandatory field in RaS and NOMIS but historically has not been in NOMIS so will be missing on some legacy cases. Data Quality Parameter: Completeness Source of Data Quality Issue: NOMIS NOMIS Equivalent Entity: offender_charges Domain: Person offences/convictions |
| charge_outcome | 1 | 0 | 8 | 34 | Table | Description: Holds metadata of the charge outcome. Data Quality Issues: The outcome_name list contained within NOMIS is extensive leading to user error in selection, they are also not mutually exclusive. RaS has reduced this list down as it was overly extensive and led to user error in selections. Thus, in the bidirectional sync, this is not a 1-to-1 mapping between the lists in NOMIS and RaS. Data Quality Parameter: Accuracy Source of Data Quality Issue: NOMIS NOMIS Equivalent Entity: offence_result_codes Domain: Person offences/convictions |
| next_court_appearance | 0 | 3 | 7 | -1 | Table | Description: Holds details of the next planned court appearance. This is a supplementary entity in the data model. NOMIS Equivalent Entity: court_events Domain: Person Court Schedules |
| period_length | 1 | 2 | 18 | -1 | Table | Description: Holds details of the duration of a sentence. This is a suplementary entity in the data model. NOMIS Equivalent Entity: offender_sentence_terms Domain: Court results including person sentences |
| recall_history | 1 | 0 | 18 | -1 | Table | |
| legacy_sentence_types | 0 | 2 | 12 | 199 | Table | |
| recall_type | 2 | 0 | 3 | -1 | Table | Description: Holds information about the different types of recall that can be chosen by the probation service depending on the sentences being recalled. NOMIS Equivalent Entity: sentence_calc_types Domain: Person Recalls |
| recall_sentence | 0 | 2 | 9 | -1 | Table | Description: Holds recall information at a child level, where the recall information affects a specific sentence. NOMIS Equivalent Entity: offender_sentences Domain: Court results including person sentences |
| appearance_charge_history | 0 | 0 | 10 | -1 | Table | |
| appearance_outcome | 1 | 0 | 11 | 33 | Table | Description: Holds metadata of the outcome from a court appearance. NOMIS Equivalent Entity: offence_result_codes Domain: Person offences/convictions |
| appearance_type | 2 | 0 | 7 | 2 | Table |