recall

-1 rows


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('recall_id_seq'::regclass)
recall_sentence.recall_id fk_recall_sentence_to_recall R

Description: The unique id for the overarching recall. Source System: Record a Recall
recall_uuid uuid 2147483647 null

Description: The unique id of the overarching recall which is displayed on the UI. Source System: Record a Recall
prisoner_id varchar 2147483647 null

Description: The id of the prisoner that is being recalled. Source System: NOMIS
revocation_date date 13 √ null

Description: The date when the probation service approved the recall for the prisoner. Source System: Consider a Recall
return_to_custody_date date 13 √ null

Description: The date the prisoner was arrested. If the prisoner was already in custody at the time of the recall then this will be the same as the revocation_date. Source System: Record a Recall
recall_type_id int4 10 null
recall_type.id recall_type_id_fk R

Description: Which kind of recall was selected by the probation service, this can be restricted based on the kinds of sentences being recalled. Source System: Consider a Recall
created_at timestamptz 35,6 null

Description: The timestamp of when the overarching recall was created. Source System: Record a Recall
created_by_username varchar 2147483647 null

Description: The username that initially created the overarching recall. Source System: Record a Recall
created_prison varchar 2147483647 √ null
updated_at timestamptz 35,6 √ null
updated_by varchar 2147483647 √ null
updated_prison varchar 2147483647 √ null
in_prison_on_revocation_date bool 1 √ null
source varchar 2147483647 'DPS'::character varying
calculation_request_id int4 10 √ null
status varchar 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
recall_pkey Primary key Asc id
idx_recall_prisoner_id Performance Asc prisoner_id
idx_recall_uuid Must be unique Asc recall_uuid

Relationships

Close relationships within degrees of separation