Data Set Structure

 

Client Details

Format

NHS Number

10 digit numeric

First Letter of Surname

1 alpha character

First Letter of Forename

1 alpha character

Date of Birth

CCYY-MM-DD

Gender

1 digit numeric

Ethnic Category

1 character alpha numeric

Reduced Postcode

6 character alpha numeric

Local Authority

3 digit numeric

 

Referral Details

Format

Agency Code

 

Agency Client Number

15 digit numeric

Date of Referral

CCYY-MM-DD

Source of Referral

2 character alpha numeric

 

Assessment Details

Format

Assessment Date

CCYY-MM-DD

Previously Treated

1 digit numeric

Ex Services Personnel

1 digit numeric

Parental Responsibility

2 character alpha numeric

Children Living in Household

2 character alpha numeric

Problem Substance 1

4 digit numeric

Problem Substance 2

4 digit numeric

Problem Substance 3

4 digit numeric

Injecting Status

2 character alpha numeric

Hepatitis B Vaccination Status

2 character alpha numeric

Blood Borne Virus Test Status

2 character alpha numeric

Co-occurring Mental Health Issues

1 digit numeric

Accommodation Need

2 character alpha numeric

Employment Status

2 character alpha numeric

 

Treatment Modality Details

Format

Treatment Modality

2 character alpha numeric

Modality Referral Date

CCYY-MM-DD

Modality First Appointment Offered Date

CCYY-MM-DD

Modality Start Date

CCYY-MM-DD

Modality End Date

CCYY-MM-DD

Modality Exit Status

2 character alpha numeric

 

Treatment Outcome Profile (TOP) Details

Format

TOP Number

6 digit numeric

TOP Interview Date

CCYY-MM-DD

Treatment Stage

2 character alpha numeric

Number of Days Alcohol Used

2 character alpha numeric

Number of Days Opiate Used

2 character alpha numeric

Number of Days Crack Used

2 character alpha numeric

Number of Days Cocaine Used

2 character alpha numeric

Number of Days Amphetamines Used

2 character alpha numeric

Number of Days Cannabis Used

2 character alpha numeric

Other Problem Substance Used

4 digit numeric

Number of Days Other Substance Used

2 character alpha numeric

Number of Days Non-Prescribed Drugs Injected

2 character alpha numeric

Injected with Needle or Syringe used by Someone else

1 digit numeric

Number of Days Shoplifting

2 character alpha numeric

Number of Days Selling Drugs

2 character alpha numeric

Criminal Offence Status

2 character alpha numeric

Assault or Violence Status

2 character alpha numeric

Psychological Health Status

2 character alpha numeric

Number of Days Paid Work

2 character alpha numeric

Number of Days Attended College or School

2 character alpha numeric

Physical Health Status

2 character alpha numeric

Urgent Housing Problem Status

2 character alpha numeric

Risk of Eviction Status

2 character alpha numeric

Quality of Life Status

2 character alpha numeric

 

Discharge Details

Format

Date Contact Ended

CCYY-MM-DD

Reason Contact Ended

2 character alpha numeric