Welfare Reference Number

This pattern was last updated 30/04/2020, this is version 1.0

Stable

Pattern created

23/04/2020

Description

The Welfare Reference number is used as a unique identifier for animal welfare incidents. The reference number is used by the Animal Plant Health Authority (APHA) when investigating incidents relating to animal welfare. The reference number is constructed by the Official Veterinarian (OV) at the time of the incident and it is not uncommon for there to be several incidents on the same date.

These incidents are also recorded on Chronos which generates a common Chronos incident number, however the APHA use the OV generated reference number for their investigations and for communications back to the FSA.

Field formats, data types, and patterns

The Welfare Reference Number is made up of three parts separated by forward slashes with no spaces. A four digit Plant Approval Number, followed by a numeric representation of the date in format ddmmyy, followed by 4 numerical digits representing the time of the incident using the 24 hour clock - NNNN/ddmmyy/hhmm eg 3456/280420/0830, 4562/010220/1224.

Regex validation

([0-9]{4}\/[0-9]{6}\/[0-9]{4})

SQL snippet

CREATE TABLE welfareReferenceNumber (
  welfare-reference-number    VARCHAR(16)
);