8. ATAPS MDS to PMHC MDS data mapping¶

8.1. Practitioner¶

See Practitioner for the definition of a practitioner.

The low completion rate of MHPro profile data within the ATAPS MDS results in many practitioner records being populated with mostly “missing” values.

Data Element (Field Name) Type (min,max) Format / Values

Organisation Path

(organisation_path)

string

No comparable concept in ATAPS MDS.

PHN’s will be required to populate this field.

Practitioner Key

(practitioner_key)

string (2,50)

The MHPro nickname from the ATAPS MDS

Practitioner - Category

(practitioner_category)

string

Populated from ATAPS MHPro profile profession data using the following mapping:

ATAPS MHP Profession PMHC Practitioner category

1:	Psychologist (Clinical)

1:	Clinical Psychologist

2:	Psychologist (Generalist/Other)

2:	General Psychologist

3:	Social worker

3:	Social Worker

4:	Occupational Therapist

4:	Occupational Therapist

5:	Mental Health Nurse

5:	Mental Health Nurse

6:	Aboriginal and Torres Strait Islander Health Worker

6:	Aboriginal and Torres Strait Islander Health/Mental Health Worker

7:	Other

11:	Other

8:	Aboriginal and Torres Strait Island Mental Health Worker

6:	Aboriginal and Torres Strait Islander Health/Mental Health Worker

Any other values are mapped to

99:	Not stated

Practitioner - ATSI Cultural Training

(atsi_cultural_training)

string

Not part of ATAPS MDS. All practitioner records populated with

9:	Missing / Not recorded

Practitioner - Year of Birth

(practitioner_year_of_birth)

gYear

Populated from ATAPS MHPro profile data. Missing values mapped to

9999:	Date of birth is totally unknown

Practitioner - Gender

(practitioner_gender)

string

Mapped from ATAPS to PMHC gender codes. Note that Female/Male codes are swapped between the two MDS systems.

ATAPS gender PMHC gender

0:	(Blank)

0:	Not stated/Inadequately described

1:	Female

1:	Male

2:	Male

2:	Female

Practitioner - Aboriginal and Torres Strait Islander Status

(practitioner_atsi_status)

string

Populated from ATAPS MHPro profile data. Codes 1 to 4 map to the same vaules. All other values are mapped to

9:	Not stated/inadequately described

Practitioner - Active

(practitioner_active)

string

MHPros in the ATAPS MDS are considered active practitioners for data migration. i.e. all records are mapped to

1:	Active

Practitioner - Tags

(practitioner_tags)

string

No comparable concept in the ATAPS MDS. All records will be populated with the reserved tag

!ATAPS

8.2. Client¶

See Client for the definition of a client.

Data Element (Field Name) Type (min,max) Format / Values

Organisation Path

(organisation_path)

string

No comparable concept in ATAPS MDS.

PHN’s will be required to populate this field.

Client Key

(client_key)

string (2,50)

ATAPS patient_key

Client - Statistical Linkage Key

(slk)

string (14,40)

ATAPS slk or slk_hash

Client - Date of Birth

(date_of_birth)

date

Only the patients’ year of birth is recorded in ATAPS. The date_of_birth field is populated with an estimated date of birth, being 1st January in the recorded year of birth.

For example, if a patient’s year of birth is 1975, the PMHC client date_of_birth is mapped to 01011975.

Client - Estimated Date of Birth Flag

(est_date_of_birth)

string

All clients have an estimated date of birth. Mapped to option 2 for all clients:

2:	Date of birth is an estimate

Client - Gender

(client_gender)

string

Mapped from ATAPS to PMHC gender codes. Note that Female/Male codes are swapped between the two MDS systems.

ATAPS gender PMHC gender

0:	(Blank)

0:	Not stated/Inadequately described

1:	Female

1:	Male

2:	Male

2:	Female

Client - Aboriginal and Torres Strait Islander Status

(client_atsi_status)

string

Calculated from the ATAPS patient ‘Aboriginal’ (aboriginal) and ‘Torres Strait islander’ (torres_si) fields.

ATAPS patient ‘aboriginal’ ATAPS patient ‘torres_si’ PMHC client atsi status

1:	Yes

2:	No (or Blank)

1:	Aboriginal but not Torres Strait Islander origin

2:	No (or Blank)

1:	Yes

2:	Torres Strait Islander but not Aboriginal origin

1:	Yes

1:	Yes

3:	Both Aboriginal and Torres Strait Islander origin

2:	No (or Blank)

2:	No (or Blank)

4:	Neither Aboriginal or Torres Strait Islander origin

3:	Unknown

(any value)

9:	Not stated/inadequately described

(any value)

3:	Unknown

9:	Not stated/inadequately described

Client - Country of Birth

(country_of_birth)

string (4)

Not part of ATAPS MDS. All practitioner records populated with

9999:	Unknown

Client - Main Language Spoken at Home

(main_lang_at_home)

string (4)

ATAPS patient ‘language spoken at home’ had a reduced set of options. These map to PMHC client ‘main language spoken at home’ as

ATAPS patient lang_at_home PMHC client main_lan_at_home

1:	English

1201:	English

2:	Italian

2401:	Italian

3:	Greek

2201:	Greek

4:	Cantonese

7101:	Cantonese

5:	Mandarin

7104:	Mandarin

6:	Arabic

4202:	Arabic

7:	Vietnamese

6302:	Vietnamese

8:	Other (or blank)

9999:	Unknown

Client - Proficiency in Spoken English

(prof_english)

string

Mapped from ATAPS patient english level:

ATAPS patient english level PMHC client proficiency in spoken english

1:	Very Well

1:	Very well

2:	Well

2:	Well

3:	Not Well

3:	Not well

4:	Not at All

4:	Not at all

5:	Unknown

9:	Not stated/inadequately described

0:	(blank)

9:	Not stated/inadequately described

Client - Tags

(client_tags)

string

No comparable concept in the ATAPS MDS. All records will be populated with the reserved tag

!ATAPS

8.3. Episode¶

See Episode for the definition of a episode.

Data Element (Field Name) Type (min,max) Format / Values

Organisation Path

(organisation_path)

string

No comparable concept in ATAPS MDS.

PHN’s will be required to populate this field.

Episode Key

(episode_key)

string (2,50)

A unique identifier for each episode generated by concatenating the string ‘E’, an internal ATAPS identifier (integer), and the string ‘ATAPS’. For example

E12345ATAPS

Client Key

(client_key)

string (2,50)

ATAPS patient_key

Episode - End Date

(episode_end_date)

date

When the ATAPS referral has a conclusion, the date of the most recent session date for this referral.

Episode - Client Consent to Anonymised Data

(client_consent)

string

All ATAPS patients are assumed to have consented to their data being collected. Mapped to option 1 for all episodes:

1:	Yes

Episode - Completion Status

(episode_completion_status)

string

Mapped from ATAPS referral conclusion

ATAPS referral conclusion PMHC episode completion status

1:	Treatment complete

1:	Episode closed - treatment concluded

2:	Patient could not be contacted

3:	Episode closed administratively - client declined further contact

3:	Patient refused treatment

3:	Episode closed administratively - client declined further contact

4:	Patient referred elsewhere

5:	Episode closed administratively - client referred elsewhere

5:	Treatment incomplete but referral closed

6:	Episode closed administratively - other reason

6:	Patient ineligible

6:	Episode closed administratively - other reason

Episode - Referral Date

(referral_date)

date

ATAPS referral_date

Episode - Principal Focus of Treatment Plan

(principal_focus)

string

Determined from ATAPS referral type using the following mapping:

ATAPS referral type PMHC episode principal focus

1:	General ATAPS

1:	Psychological therapy

2:	Telephone CBT

7:	Other

3:	Suicide Prevention

7:	Other

4:	Perinatal Depression

7:	Other

5:	Bushfire

7:	Other

6:	Homelessness

7:	Other

7:	Aboriginal & TSI

6:	Indigenous-specific mental health services

8:	Rural & remote

1:	Psychological therapy

9:	Children

5:	Child and youth-specific mental health services

10:	2010-11 Floods and Cyclone Yasi

7:	Other

11:	ATSI Suicide prevention

6:	Indigenous-specific mental health services

12:	Tier 2 ECE - Flood/Cyclone

7:	Other

13:	Tier 2 ECE - Bushfire

7:	Other

14:	Tier 2 ECE - Other

7:	Other

15:	MHSRRA

1:	Psychological therapy

Episode - GP Mental Health Treatment Plan Flag

(mental_health_treatment_plan)

string

Not part of ATAPS MDS. All episode records populated with

9:	Not stated/inadequately described

Episode - Homelessness Flag

(homelessness)

string

Not part of ATAPS MDS. All episode records populated with

9:	Not stated / Missing

Episode - Area of usual residence, postcode

(client_postcode)

string

ATAPS referral postcode

Episode - Labour Force Status

(labour_force_status)

string

Not part of ATAPS MDS. All episode records populated with

9:	Not stated/inadequately described

Episode - Employment Participation

(employment_participation)

string

Not part of ATAPS MDS. All episode records populated with

9:	Not stated/inadequately described

Episode - Source of Cash Income

(income_source)

string

Not part of ATAPS MDS. All episode records populated with

9:	Not stated/inadequately described

Episode - Health Care Card

(health_care_card)

string

Not part of ATAPS MDS. All episode records populated with

9:	Not stated

Episode - NDIS Participant

(ndis_participant)

string

Not part of ATAPS MDS. All episode records populated with

9:	Not stated/inadequately described

Episode - Marital Status

(marital_status)

string

Not part of ATAPS MDS. All episode records populated with

6:	Not stated/inadequately described

Episode - Suicide Referral Flag

(suicide_referral_flag)

string

Derived from the ATAPS referral type.

Referrals with an ATAPS referral_type of either ‘Suicide Prevention (3)’ or ‘ATSI Suicide prevention (11)’ are coded as

1:	Yes

All other referral types map to

2:	No

Episode - Principal Diagnosis

(principal_diagnosis)

string

The ATAPS specifications allowed multiple diagnosis to be specified for a referral. Those referrals where no diagnosis or a single diagnosis were specified are mapped as follows:

ATAPS referral diagnosis PMHC episode principal diagnosis

No diagnosis field defined

999:	Missing

icd_f1:	Alcohol & Drug Use

300:	Substance use disorders (ATAPS)

icd_f2:	Psychotic Disorders

400:	Psychotic disorders (ATAPS)

icd_f3:	Depression

200:	Affective (Mood) disorders (ATAPS)

icd_f4:	Anxiety Disorders

100:	Anxiety disorders (ATAPS)

icd_f5:	Unexplained Somatic

603:	Somatoform disorder

icd_no_formal_diagnosis:
	No formal diagnosis

905:	Other

icd_unknown:	Unknown

999:	Missing

icd_other:	Other

905:	Other

icd_f10_f11:	F10 & F11 Substance use disorders

300:	Substance use disorders

icd_f32:	F32 Depression

200:	Affective (Mood) disorders

icd_f40_f41_f41_1:
	F40, F41, F41.1 Anxiety

100:	Anxiety disorders

icd_f43_2:	F43.2 Adjustment disorder

601:	Adjustment disorder

icd_f44:	F44 Dissociative (conversion) disorder

605:	Other mental disorder

icd_f45:	F45 Unexplained somatic disorder

603:	Somatoform disorder

icd_f48:	F48 Neurasthenia (chronic fatigue syndrome)

605:	Other mental disorder

icd_f50:	F50 Eating disorders

602:	Eating disorder

icd_f51:	F51 Sleep problems

605:	Other mental disorder

icd_f52:	F52 Sexual disorders

605:	Other mental disorder

icd_f90:	F90 Hyperkinetic (attention deficit) disorder

502:	Attention deficit hyperactivity disorder (ADHD)

icd_f91:	F91 Conduct disorder

503:	Conduct disorder

icd_f98:	F98 Enuresis

506:	Other disorder of childhood and adolescence

Referrals where TWO diagnosis fields were specified, the principal diagnosis is determined using the following hierarchies.

ATAPS referral diagnosis hierarchy:

icd_f3:	Depression, then
icd_f4:	Anxiety Disorders, then
icd_f5:	Unexplained Somatic.

For pairs of children diagnoses

ATAPS children referral diagnosis hierarchy:

icd_f40_f41_f41_1:
icd_f32:	F32 Depression, then
	F40, F41, F41.1 Anxiety, then
icd_f43_2:	F43.2 Adjustment disorder, then
icd_f44:	F44 Dissociative (conversion) disorder, then
icd_f50:	F50 Eating disorders, then
icd_f51:	F51 Sleep problems, then
icd_f90:	F90 Hyperkinetic (attention deficit) disorder, then
icd_f91:	F91 Conduct disorder.

For example, if a referral was flagged as being for Depression and Unexplained Somatic, the principal diagnosis would be Depression and mapped to code 200, as if specified as a single diagnosis above.

All other referrals will be mapped to

905:	Other

Episode - Additional Diagnosis

(additional_diagnosis)

string

Mapped from ATAPS referral diagnosis fields

For referrals where NO diagnosis field was specified, the additional diagnosis is mapped to

999:	Missing

Referrals where exactly ONE diagnosis field was specified, the additional diagnosis is mapped to

000:	No additional diagnosis

For referrals where TWO diagnosis fields were specified, the additional diagnosis is determined using the same hierarchies as described in the principal diagnosis when two diagnoses were specified for the referral. The diagnosis NOT selected as the principal diagnosis is mapped as the additional diagnosis.

For example, if a referral was flagged as being for Depression and Unexplained Somatic, the additional diagnosis would be Unexplained Somatic and mapped to code 603, using the table above for a single principal diagnosis.

Similarlly for the children diagnosis options. If a referral was recorded with F32 Depression and F43.2 Adjustment disorder, the principal diagnosis would be F32 Depression and mapped to code 200, while the additional diagnosis would be F43.2 Adjustment disorder and mapped to code 601.

For all other referrals, the additional diagnosis is mapped to

905:	Other

Episode - Medication - Antipsychotics (N05A)

(medication_antipsychotics)

string

If ATAPS referral med_pheno is TRUE (or 1) then

1:	Yes

Otherwise

2:	No

Episode - Medication - Anxiolytics (N05B)

(medication_anxiolytics)

string

If ATAPS referral med_benzo is TRUE (or 1) then

1:	Yes

Otherwise

2:	No

Episode - Medication - Hypnotics and sedatives (N05C)

(medication_hypnotics)

string

If ATAPS referral med_mood is TRUE (or 1) then

1:	Yes

Otherwise

2:	No

Episode - Medication - Antidepressants (N06A)

(medication_antidepressants)

string

If ATAPS referral med_antidep is TRUE (or 1) then

1:	Yes

Otherwise

2:	No

Episode - Medication - Psychostimulants and nootropics (N06B)

(medication_psychostimulants)

string

Not part of ATAPS MDS. All episode records populated with

9:	Unknown

Episode - Referrer Profession

(referrer_profession)

string

Mapped from ATAPS referral referrer type:

ATAPS referral referrer type PMHC episode referrer profession

1:	GP

1:	General Practitioner

2:	Psychiatrist

2:	Psychiatrist

5:	Case Manager

10:	Social Worker

7:	Midwife

6:	Midwife

8:	Obstetrician

3:	Obstetrician

9:	Maternal health nurse

7:	Maternal Health Nurse

10:	Self

98:	N/A - Self referral

11:	Centrelink Social Workers

10:	Social Worker

14:	Paediatrician

4:	Paediatrician

17:	Medical officers in NGOs

10:	Social Worker

18:	School psychologist / counsellor

8:	Psychologist

19:	Deputy principals or principals

13:	Educational professional

20:	Director of early childhood services or equivalent

14:	Early childhood service worker

All other referrer types are mapped to the referrer profession

99:	Not stated

Episode - Referrer Organisation Type

(referrer_organisation_type)

string

Mapped from ATAPS referral referrer type:

ATAPS referral referrer type PMHC episode referrer organisation type

3:	Community Mental Health

8:	Community Health Centre

4:	Emergency Department

7:	Emergency Department

6:	NGO

10:	Community Support Organisation NFP

10:	Self

98:	N/A - Self referral

11:	Centrelink Social Workers

20:	Centrelink

16:	ATSI health organisation / ACCHS (Aboriginal Controlled Community Health Service)

11:	Indigenous Health Organisation

17:	Medical officers in NGOs

10:	Community Support Organisation NFP

18:	School psychologist / counsellor

17:	School

19:	Deputy principals or principals

17:	School

21:	Drug and alcohol service

9:	Drug and Alcohol Service

22:	Acute mental health team

4:	Public mental health service

All other referrer types are mapped to the referrer organisation type

99:	Not stated

Episode - Tags

(episode_tags)

string

No comparable concept in the ATAPS MDS. All records will be populated with the reserved tag

!ATAPS

8.4. Service Contact¶

See Service Contact for the definition of a service contact.

Data Element (Field Name) Type (min,max) Format / Values

Organisation Path

(organisation_path)

string

No comparable concept in ATAPS MDS.

PHN’s will be required to populate this field.

Service Contact Key

(service_contact_key)

string (2,50)

A unique identifier for each service contact generated by concatenating the string ‘SC’, an internal ATAPS identifier (integer), and the string ‘ATAPS’. For example

SC12345ATAPS

Episode Key

(episode_key)

string (2,50)

A unique identifier for each episode generated by concatenating the string ‘E’, an internal ATAPS identifier (integer), and the string ‘ATAPS’. For example

E12345ATAPS

Practitioner Key

(practitioner_key)

string (2,50)

The MHPro nickname from the ATAPS MDS

Service Contact - Date

(service_contact_date)

date

ATAPS session date (ses_date).

Service Contact - Type

(service_contact_type)

string

Mapped from ATAPS session strategy (st_*) and no_show fields.

Where the session no_show field is TRUE (or 1), the contact type is mapped to

0:	No contact took place

If the session st_diagnosis field is true, and NO other strategy field is TRUE, the contact type is mapped to

1:	Assessment

If the session st_other field has a non-zero length and NO other strategy field is TRUE, the contact type is mapped to

3:	Other psychological intervention

After the above options have been excluded, if any combination of the following session strategy fields is TRUE or st_cbt_other has a non-zero length

st_psycho_ed
st_interpersonal
st_narrative
st_cbt_behaviour
st_cbt_cognitive
st_cbt_relaxation
st_cbt_skills

the contact type is mapped to

2:	Structured psychological intervention

Any remaining session will be mapped to the restricted response

98:	ATAPS

Service Contact - Postcode

(service_contact_postcode)

string

No postcode was recorded for ATAPS sessions.

If the ATAPS session modality is recorded as Face to Face and the ATAPS session no_show field is FALSE, a valid Australian postcode is required. Where this is unavailable, the postcode may be recorded as

9998:	Other

All other service contact records will be populated with the postcode

9999:	Unknown

Service Contact - Modality

(service_contact_modality)

string

Mapped from ATAPS session no_show and modality fields.

If the ATAPS session was flagged as a no_show, the PMHC service contact modaility is

0:	No contact took place

Otherwise the ATAPS session modality is used. These are the equivilent codes in PMHC:

ATAPS session modality PMHC service contact modality

1:	Face to Face

1:	Face to Face

2:	Telephone

2:	Telephone

3:	Video Conference

3:	Video

4:	Web-based

4:	Internet-based

Service Contact - Participants

(service_contact_participants)

string

Derived from the ATAPS session type

ATAPS session type PMHC service contact participants

1:	Individual

1:	Individual client

2:	Group

2:	Client group

3:	Child

1:	Individual client

4:	Parent(s)/family

3:	Family / Client Support Network

5:	Child & parent(s)/family

3:	Family / Client Support Network

6:	Child, in group

2:	Client group

7:	Parent(s)/family, in group

3:	Family / Client Support Network

8:	Child & parent(s)/family, in group

3:	Family / Client Support Network

9:	Family

3:	Family / Client Support Network

Any ATAPS sessions with a missing value for session type are mapped to

9:	Not stated

Service Contact - Venue

(service_contact_venue)

string

No comparable concept in ATAPS MDS.

Sessions that were delivered with a modality of Telephone, Video or Internet-based (session.modailty > 1 ) are mapped to

98:	Not applicable (Service Contact Modality is not face to face)

All other sessions are mapped to the response

99:	Not stated

Service Contact - Duration

(service_contact_duration)

string

Its not possible to construct a one-to-one mapping between ATAPS session duration and PMHC service contact duration. The following mapping will be applied for data conversion:

ATAPS session duration PMHC service contact duration

1:	0-30 mins

2:	16-30 mins

2:	31-45 mins

3:	31-45 mins

3:	46-60 mins

4:	46-60 mins

4:	over 60 mins

5:	61-75 mins

If the duration was not mapped by the above and ATAPS session was a no_show, the duration is mapped to

0:	No contact took place

All other session durations values are mapped to

1:	1-15 mins

Service Contact - Copayment

(service_contact_copayment)

number

Where ATAPS session copayment > 0, the service contact copayment is the session copayment rounded (cast) to the nearest integer.

All other responses are mapped to 0.

Service Contact - Client Participation Indicator

(service_contact_participation_indicator)

string

Derived from the ATAPS session type.

The participation indicator

2:	No

is used when the session type is either

4:	Parent(s)/family
7:	Parent(s)/family, in group

All other session types are mapped to the participation indicator

1:	Yes

Service Contact - Interpreter Used

(service_contact_interpreter)

string

Not part of ATAPS MDS. All episode records populated with

9:	Not stated

Service Contact - No Show

(service_contact_no_show)

string

If ATAPS session.no_show is TRUE (or 1) then

1:	Yes

Otherwise

2:	No

Service Contact - Final

(service_contact_final)

string

No comparable concept in ATAPS MDS. All service contacts will be populated with

3:	Not known at this stage

Service Contact - Tags

(service_contact_tags)

string

No comparable concept in the ATAPS MDS. All records will be populated with the reserved tag

!ATAPS

8.5. Outcome Collection Occasion¶

See Outcome Collection Occasion for definition of an outcome collection occasion.

8.5.1. K10+¶

Data Element (Field Name) Type (min,max) Format / Values

Organisation Path

(organisation_path)

string

No comparable concept in ATAPS MDS.

PHN’s will be required to populate this field.

Collection Occasion Key

(collection_occasion_key)

string (2,50)

A unique identifier for each collection occasion generated by concatenating the string ‘CO’, an internal ATAPS identifier (integer), and the string ‘ATAPS’. For example

CO12345ATAPS

Episode Key

(episode_key)

string (2,50)

A unique identifier for each episode generated by concatenating the string ‘E’, an internal ATAPS identifier (integer), and the string ‘ATAPS’. For example

E12345ATAPS

Collection Occasion - Measure Date

(measure_date)

date

The ATAPS collection occasion date (measure_taken), or the date 09099999 when missing

Collection Occasion - Reason

(reason_for_collection)

string

ATAPS only collected ‘initial’ and/or ‘final’ measures for an episode.

Any K10+ ‘initial’ measures are mapped to

1:	Episode start

while ‘final’ K10+ measures are mapped to

3:	Episode end

K10+ - Question 1

(k10p_item1)

string

ATAPS K10+ collection occasion item 1 score (k01)

K10+ - Question 2

(k10p_item2)

string

ATAPS K10+ collection occasion item 2 score (k02)

K10+ - Question 3

(k10p_item3)

string

ATAPS K10+ collection occasion item 3 score (k03)

K10+ - Question 4

(k10p_item4)

string

ATAPS K10+ collection occasion item 4 score (k04)

K10+ - Question 5

(k10p_item5)

string

ATAPS K10+ collection occasion item 5 score (k05)

K10+ - Question 6

(k10p_item6)

string

ATAPS K10+ collection occasion item 6 score (k06)

K10+ - Question 7

(k10p_item7)

string

ATAPS K10+ collection occasion item 7 score (k07)

K10+ - Question 8

(k10p_item8)

string

ATAPS K10+ collection occasion item 8 score (k08)

K10+ - Question 9

(k10p_item9)

string

ATAPS K10+ collection occasion item 9 score (k09)

K10+ - Question 10

(k10p_item10)

string

ATAPS K10+ collection occasion item 10 score (k10)

K10+ - Question 11

(k10p_item11)

integer

Item score not recorded in ATAPS. All K10+ collection occasions mapped to

99:	Not stated / Missing

K10+ - Question 12

(k10p_item12)

integer

Item score not recorded in ATAPS. All K10+ collection occasions mapped to

99:	Not stated / Missing

K10+ - Question 13

(k10p_item13)

integer

Item score not recorded in ATAPS. All K10+ collection occasions mapped to

99:	Not stated / Missing

K10+ - Question 14

(k10p_item14)

string

Item score not recorded in ATAPS. All K10+ collection occasions mapped to

9:	Not stated / Missing

K10+ - Score

(k10p_score)

integer

ATAPS K10+ collection occasion total score (ktot10)

K10+ - Tags

(k10p_tags)

string

No comparable concept in the ATAPS MDS. All records will be populated with the reserved tag

!ATAPS

8.5.2. K5¶

Data Element (Field Name) Type (min,max) Format / Values

Organisation Path

(organisation_path)

string

No comparable concept in ATAPS MDS.

PHN’s will be required to populate this field.

Collection Occasion Key

(collection_occasion_key)

string (2,50)

A unique identifier for each collection occasion generated by concatenating the string ‘CO’, an internal ATAPS identifier (integer), and the string ‘ATAPS’. For example

CO12345ATAPS

Episode Key

(episode_key)

string (2,50)

A unique identifier for each episode generated by concatenating the string ‘E’, an internal ATAPS identifier (integer), and the string ‘ATAPS’. For example

E12345ATAPS

Collection Occasion - Measure Date

(measure_date)

date

The ATAPS collection occasion date (measure_taken), or the date 09099999 when missing

Collection Occasion - Reason

(reason_for_collection)

string

ATAPS only collected ‘initial’ and/or ‘final’ measures for an episode.

Any K5 ‘initial’ measures are mapped to

1:	Episode start

while ‘final’ K5 measures are mapped to

3:	Episode end

K5 - Question 1

(k5_item1)

string

ATAPS K5 collection occasion item 1 score (k01)

K5 - Question 2

(k5_item2)

string

ATAPS K5 collection occasion item 2 score (k02)

K5 - Question 3

(k5_item3)

string

ATAPS K5 collection occasion item 3 score (k03)

K5 - Question 4

(k5_item4)

string

ATAPS K5 collection occasion item 4 score (k04)

K5 - Question 5

(k5_item5)

string

ATAPS K5 collection occasion item 5 score (k05)

K5 - Score

(k5_score)

integer

ATAPS K5 collection occasion total score (ktot5)

K5 - Tags

(k5_tags)

string

No comparable concept in the ATAPS MDS. All records will be populated with the reserved tag

!ATAPS

8.5.3. SDQ¶

Data Element (Field Name) Type (min,max) Format / Values

Organisation Path

(organisation_path)

string

No comparable concept in ATAPS MDS.

PHN’s will be required to populate this field.

Collection Occasion Key

(collection_occasion_key)

string (2,50)

A unique identifier for each collection occasion generated by concatenating the string ‘CO’, an internal ATAPS identifier (integer), and the string ‘ATAPS’. For example

CO12345ATAPS

Episode Key

(episode_key)

string (2,50)

A unique identifier for each episode generated by concatenating the string ‘E’, an internal ATAPS identifier (integer), and the string ‘ATAPS’. For example

E12345ATAPS

Collection Occasion - Measure Date

(measure_date)

date

The ATAPS collection occasion date (measure_taken), or the date 09099999 when missing

Collection Occasion - Reason

(reason_for_collection)

string

ATAPS only collected ‘initial’ and/or ‘final’ measures for an episode.

Any SDQ ‘initial’ measures are mapped to

1:	Episode start

while ‘final’ SDQ measures are mapped to

3:	Episode end

SDQ Collection Occasion - Version

(sdq_version)

string

ATAPS recorded the three variants of SDQ as seperate measures.

The SDQ version is mapped from the SDQ measure type and the reason for collection:

ATAPS measure + collection PMHC SDQ version

SDQ PC + Initial collection

PC101:	Parent Report Measure 4-10 yrs, Baseline version, Australian Version 1

SDQ PC + Final collection

PC201:	Parent Report Measure 4-10 yrs, Follow Up version, Australian Version 1

SDQ PY + Initial collection

PY101:	Parent Report Measure 11-17 yrs, Baseline version, Australian Version 1

SDQ PY + Final collection

PY201:	Parent Report Measure 11-17 yrs, Follow Up version, Australian Version 1

SDQ YR + Initial collection

YR101:	Self report Version, 11-17 years, Baseline version, Australian Version 1

SDQ YP + Final collection

YR201:	Self report Version, 11-17 years, Follow Up version, Australian Version 1

SDQ - Question 1

(sdq_item1)

string

ATAPS SDQ collection occasion item 1 score (s01)

SDQ - Question 2

(sdq_item2)

string

ATAPS SDQ collection occasion item 2 score (s02)

SDQ - Question 3

(sdq_item3)

string

ATAPS SDQ collection occasion item 3 score (s03)

SDQ - Question 4

(sdq_item4)

string

ATAPS SDQ collection occasion item 4 score (s04)

SDQ - Question 5

(sdq_item5)

string

ATAPS SDQ collection occasion item 5 score (s05)

SDQ - Question 6

(sdq_item6)

string

ATAPS SDQ collection occasion item 6 score (s06)

SDQ - Question 7

(sdq_item7)

string

ATAPS SDQ collection occasion item 7 score (s07)

SDQ - Question 8

(sdq_item8)

string

ATAPS SDQ collection occasion item 8 score (s08)

SDQ - Question 9

(sdq_item9)

string

ATAPS SDQ collection occasion item 9 score (s09)

SDQ - Question 10

(sdq_item10)

string

ATAPS SDQ collection occasion item 10 score (s10)

SDQ - Question 11

(sdq_item11)

string

ATAPS SDQ collection occasion item 11 score (s11)

SDQ - Question 12

(sdq_item12)

string

ATAPS SDQ collection occasion item 12 score (s12)

SDQ - Question 13

(sdq_item13)

string

ATAPS SDQ collection occasion item 13 score (s13)

SDQ - Question 14

(sdq_item14)

string

ATAPS SDQ collection occasion item 14 score (s14)

SDQ - Question 15

(sdq_item15)

string

ATAPS SDQ collection occasion item 15 score (s15)

SDQ - Question 16

(sdq_item16)

string

ATAPS SDQ collection occasion item 16 score (s16)

SDQ - Question 17

(sdq_item17)

string

ATAPS SDQ collection occasion item 17 score (s17)

SDQ - Question 18

(sdq_item18)

string

ATAPS SDQ collection occasion item 18 score (s18)

SDQ - Question 19

(sdq_item19)

string

ATAPS SDQ collection occasion item 19 score (s19)

SDQ - Question 20

(sdq_item20)

string

ATAPS SDQ collection occasion item 20 score (s20)

SDQ - Question 21

(sdq_item21)

string

ATAPS SDQ collection occasion item 21 score (s21)

SDQ - Question 22

(sdq_item22)

string

ATAPS SDQ collection occasion item 22 score (s22)

SDQ - Question 23

(sdq_item23)

string

ATAPS SDQ collection occasion item 23 score (s23)

SDQ - Question 24

(sdq_item24)

string

ATAPS SDQ collection occasion item 24 score (s24)

SDQ - Question 25

(sdq_item25)

string

ATAPS SDQ collection occasion item 25 score (s25)

SDQ - Question 26

(sdq_item26)

string

ATAPS SDQ collection occasion item 26 score (s26)

SDQ - Question 27

(sdq_item27)

string

ATAPS SDQ collection occasion item 27 score (s27)

SDQ - Question 28

(sdq_item28)

string

ATAPS SDQ collection occasion item 28 score (s28)

SDQ - Question 29

(sdq_item29)

string

ATAPS SDQ collection occasion item 29 score (s29)

SDQ - Question 30

(sdq_item30)

string

ATAPS SDQ collection occasion item 30 score (s30)

SDQ - Question 31

(sdq_item31)

string

ATAPS SDQ collection occasion item 31 score (s31)

SDQ - Question 32

(sdq_item32)

string

ATAPS SDQ collection occasion item 32 score (s32)

SDQ - Question 33

(sdq_item33)

string

Item score not recorded in ATAPS. All SDQ collection occasions mapped to

9:	Not stated / Missing

SDQ - Question 34

(sdq_item34)

string

Item score not recorded in ATAPS. All SDQ collection occasions mapped to

9:	Not stated / Missing

SDQ - Question 35

(sdq_item35)

string

Item score not recorded in ATAPS. All SDQ collection occasions mapped to

9:	Not stated / Missing

SDQ - Question 36

(sdq_item36)

string

Item score not recorded in ATAPS. All SDQ collection occasions mapped to

9:	Not stated / Missing

SDQ - Question 37

(sdq_item37)

string

Item score not recorded in ATAPS. All SDQ collection occasions mapped to

9:	Not stated / Missing

SDQ - Question 38

(sdq_item38)

string

Item score not recorded in ATAPS. All SDQ collection occasions mapped to

9:	Not stated / Missing

SDQ - Question 39

(sdq_item39)

string

Item score not recorded in ATAPS. All SDQ collection occasions mapped to

9:	Not stated / Missing

SDQ - Question 40

(sdq_item40)

string

Item score not recorded in ATAPS. All SDQ collection occasions mapped to

9:	Not stated / Missing

SDQ - Question 41

(sdq_item41)

string

Item score not recorded in ATAPS. All SDQ collection occasions mapped to

9:	Not stated / Missing

SDQ - Question 42

(sdq_item42)

string

Item score not recorded in ATAPS. All SDQ collection occasions mapped to

9:	Not stated / Missing

SDQ - Emotional Symptoms Scale

(sdq_emotional_symptoms)

integer

ATAPS SDQ collection occasion emotional symptoms scale (sess)

SDQ - Conduct Problem Scale

(sdq_conduct_problem)

integer

ATAPS SDQ collection occasion conduct problem scale (scps)

SDQ - Hyperactivity Scale

(sdq_hyperactivity)

integer

ATAPS SDQ collection occasion hyperactivity scale (shs)

SDQ - Peer Problem Scale

(sdq_peer_problem)

integer

ATAPS SDQ collection occasion peer problem scale (spps)

SDQ - Prosocial Scale

(sdq_prosocial)

integer

ATAPS SDQ collection occasion prosocial scale (sps)

SDQ - Total Difficulties Score

(sdq_total)

integer

ATAPS SDQ collection occasion total difficulties score (stds)

SDQ - Impact Score

(sdq_impact)

integer

ATAPS SDQ collection occasion impact score (sis)

SDQ - Tags

(sdq_tags)

string

No comparable concept in the ATAPS MDS. All records will be populated with the reserved tag

!ATAPS