Table 2

Data sets and variables

Health data setData descriptionData providerData typeGeographical coverageAvailable fromKey variables
Admitted Patients Data CollectionNSW—all admitted patient services provided by public and private hospitals and day procedure centres
ACT—inpatient separations from all public and private hospitals
NSW Health
ACT Health
Administrative (mandatory)NSW
ACT
2001
2004
Date of admission
Date of separationi
Length of stay
Primary and additional diagnoses
Admitted to and days in psychiatry ward
Separation mode
Demographics (age, sex, SLA of residence)
Death registrations
Cause of Death Unit Record File
Mortality information for deaths occurring in NSW and ACTNSW Registry of Births, Deaths and Marriages
ACT Registry of Births, Deaths and Marriages
Registry (mandatory)NSW
ACT
1985
1997
Date of birth
Date of death
Age at death
Year of death registration
Cause of death
Emergency Department Data CollectionProvides information about patient presentations to the emergency departments of public hospitals in NSW and ACTNSW Health
ACT Health
Administrative (mandatory)NSW
ACT
2005
2004
Arrival and triage date
Doctor seen date
Mode of arrival and referral source
Diagnosis Mode of separation
Departure date
Demographics (age, sex, SLA)
Mental Health Ambulatory Data CollectionIncludes assessment, treatment, rehabilitation or care of non-admitted patients. It may include mental health day programmes, psychiatric outpatients and outreach services (eg, home visits).NSW HealthAdministrativeNSW2001Activity type and duration
Activity start date
Group session identifier
Mental health additional diagnosis
Mental health provider role and type
Demographics (age, area of usual residence, country of birth)
Notifiable Conditions/DiseasesDiagnoses of certain infectious diseases and adverse events following immunisation. Notified by laboratories, hospitals, medical practitioners, schools and child care centresNSW Health
ACT Health
Administrative (mandatory)NSW
ACT
1993
2000
Disease name/condition notified
Diagnosis method
Recorded date
Laboratory confirmed
Demographics (age, sex, SLA)
Criminal justice data sets
Data description

Data provider

Data type
Geographical coverageAvailable from
Key variables
PROMISCentral recording system for all crime, incidents and offences committed in the ACTACT PoliceAdministrativeACT1998Date arrested
Date of offence for which arrested
Offence committed—Australian Standard Offence Classification
Method used to clear an offence or chargeii and date cleared
Date released following apprehension
Family violence related
Re-offending Database (ROD)Contains information on each person who has been convicted of a criminal offence in NSW since 1994 and is used by the Bureau of Crime Statistics and Research to determine the proportion of offenders who have been re-convicted for a further offenceNSW BOCSARAdministrativeNSW1994Court appearances
Principal offence—Australian Standard Offence Classification
Date offence occurred
Date accused was arrested/charged for offence
Plea and outcome of the charge
Drug associated with offence
Year and jurisdiction case was finalised
Type and duration or value of penalty
Duration of total term for prison sentence
Custody—those in custody (date of reception, type of custody, sentence type, date of discharge, discharged type)
Reference data set
Data description

Data provider

Data type
Geographical coverageAvailable from
Key variables
TED DatabaseTED is the Ted Noffs Foundation Client Information System for young people referred for residential drug treatment in NSW and the ACT since 2001. Includes all variables in a pretreatment referral questionnaire administered by staff over the phone or in personTed Noffs FoundationAdministrativeNSW
ACT
2000Admission to PALM (referral source, date of admission, date of discharge, reason for departure)
Demographics (age, Indigenous status, education, occupation, housing)
Substance use (age first use, current use, route of administration)
Severity of Dependence Scale (table 3)
Occasions of Drug Use Scale (table 3)
Blood Borne Virus Exposure Risk Scale (table 3)
Treatment history and motivation to attend treatment
Psychological Wellbeing Scale (table 3)
Suicide and self-harm attempts (ever attempted, attempted 3 months)
Social Functioning Scale (table 3)
Family Assessment Device (General Functioning Scale; table 3)
Past criminal activity (times arrested 3 months prior to screening, times in custody, type and number of crimes committed, under the influence of alcohol or any other drugs during any offences)
  • iA separation is the administrative process by which a hospital records the cessation of an episode of care for a patient within the one hospital stay e.g. discharge to home, discharge to another hospital or nursing home, or death

  • iiMethod could include caution, summons, charge withdrawn, unfounded, court, attendance notice, charge before the court, diversionary conference, simple Cannabis Offence Notice.

  • ACT, Australian Capital Territory; BOCSAR, Bureau of Crime Statistics and Research; NSW, New South Wales; PALM, Program for Adolescent Life Management; PROMIS, Police Real Time Online Management Information System; SLA, Statistical Local Area.