2.8. ATAPS MDS to PMHC MDS data mapping

2.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.

Table 2.11 Practitioner record mapping
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

2.8.2. Client

See Client for the definition of a client.

Table 2.12 Client record mapping
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

2.8.3. Episode

See Episode for the definition of a episode.

Table 2.13 Episode record mapping
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_f32:F32 Depression, then
icd_f40_f41_f41_1:
 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

2.8.4. Service Contact

See Service Contact for the definition of a service contact.

Table 2.14 Service contact record mapping
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

2.8.5. Outcome Collection Occasion

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

2.8.5.1. K10+

Table 2.15 K10+ record mapping
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

2.8.5.2. K5

Table 2.16 K5 record mapping
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

2.8.5.3. SDQ

Table 2.17 SDQ record mapping
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