10. Data Specification Change log¶

10.1. 14/8/2019¶

Validation Rules

Service Contact Current Validations

Added individual notes where ‘0: No contact took place’ is selected in any field,

that Service Contact - No Show must be ‘1: Yes’

10.2. 21/6/2019¶

Validation Rules
- Moved SDQ Future Validations to the SDQ Current Validations.
  - Subscale and total difficulties scores are now calculated/validated against item scores provided, as per Scoring the SDQ.

10.3. 14/3/2019¶

Upload specification
- Updated Files or worksheets to upload to specify that the Organisations worksheet/file is optional and is only available if the user has Organisation Management role.

10.4. 1/1/2019 - Version 1.0.13¶

Data model and specifications
- Record formats
  - Practitioner
    - Updated Practitioner - Category to add response 12 - Psychosocial Support Worker.
    - Updated Practitioner - Category to add response 13 - Peer Support Worker.
  - Episode
    - Updated Episode - Principal Focus of Treatment Plan to add response 8 - Psychosocial Support.
  - Service Contact
    - Updated Service Contact - Type to add response 9 - Psychosocial support.
    - Updated Service Contact - Venue to change response 8 from ‘Aged care centre’ to ‘Residential aged care facility’.
    - Updated Service Contact - Venue to add response 12 - Aged care centre - non-residential.

10.5. 24/9/2018¶

Episode - Principal Diagnosis to update the major diagnosis groupings.

10.6. 10/9/2018¶

Data model and specifications
- Record formats
  - Outcome Collection Occasion
    - Updated Collection Occasion - Measure Date to specify that the measure date must not be before Episode - Referral Date and must not be after Episode - End Date

10.7. 24/8/2018¶

Validation Rules
- Updated Client to specify that the date of birth must not be in the future.
- Updated Episode to specify that the episode end date must not be in the future.
- Updated Episode to specify that the episode referral date must not be in the future.
- Updated Service Contact to specify that the service contact date must not be in the future.
- Updated K10+ to specify that the measure date must not be in the future.
- Updated K5 to specify that the measure date must not be in the future.
- Updated SDQ to specify that the measure date must not be in the future.

10.8. 25/7/2018¶

Episode - Principal Diagnosis to make plurality of the 7 major categories consistent.

10.9. 25/6/2018¶

Upload specification
- Updated to use ‘must’ and ‘should’ as defined in RFC 2119.

10.10. 30/5/2018¶

Download Specification Files
- Added a zip download of PMHC MDS Specification files for developers to access.

10.11. 13/3/2018¶

Upload specification
- Updated File format to specify that ‘… you should include ALL service contacts and measures for that episode’ and removing the text ‘Any service contacts and measures that are not included will be removed from the PMHC MDS’
Validation Rules
- Updated Client to remove the age based validations for Client - Proficiency in Spoken English. These validations will be replaced with data quality reports.

10.12. 19/1/2018 - Version 1.0.12¶

Data model and specifications
- Record formats
  - Client
    - Updated Client - Date of Birth to specify that the date of birth must not be before 1 January 1900.
  - Episode
    - Updated Episode - End Date to specify that the episode end date must not be before 1 January 2016.
    - Updated Episode - Referral Date to specify that the episode referral date must not be before 1 January 2014.
  - Service Contact
    - Updated Service Contact - Date to specify that the service contact date must not be before 1 January 2014.
  - Outcome Collection Occasion
    - Updated Collection Occasion - Measure Date to specify that the measure date must not be before 1 January 2016.
Validation Rules
- Updated Client to specify that the date of birth must not be before 1 January 1900.
- Updated Episode to specify that the episode end date must not be before 1 January 2016.
- Updated Episode to specify that the episode referral date must not be before 1 January 2014.
- Updated Service Contact to specify that the service contact date must not be before 1 January 2014.
- Updated K10+ to specify that the measure date must not be before 1 January 2016.
- Updated K5 to specify that the measure date must not be before 1 January 2016.
- Updated SDQ to specify that the measure date must not be before 1 January 2016.

10.13. 29/11/2017¶

Validation Rules
- Fixed spelling error in Practitioner point 1.

10.14. 28/11/2017¶

Validation Rules
- Rewrote the validation rules to follow the guidelines in RFC 2119.
- Changed bullet lists to enumerated lists to make rules easier to identify.
- Updated Episode to clarify how Episode - Completion Status and Episode - End Date interact (Point 4.)

10.15. 25/10/2017¶

Upload specification
- Updated Deleting records

10.16. 16/10/2017¶

Validation Rules
- Updated Episode to clarify which episode closed responses are allowed to be recorded when Service Contact - Final is recorded as ‘1: No further services are planned for the client in the current episode’
- Updated Client to make the final point clearer.

10.17. 11/10/2017¶

Identifier management
- Updated Managing Practitioner, Episode, Service Contact and Outcome Collection Occasion Keys
Data model and specifications
- Record formats
  - Service Contact
    - Added notes for Service Contact - Modality response code 4: ‘Internet-based’

10.18. 03/10/2017¶

Added Test Data Sets
Validation Rules
- Updated Episode to specify when the !ATAPS flag can be used in Episode - Tags
- Updated Service Contact to remove the validation ‘Where an Episode - End Date has been recorded, there must be a service contact with Service Contact - Final set to ‘1: No further services are planned for the client in the current episode’’
- Updated Service Contact to specify when the !ATAPS flag can be used in Service Contact - Tags
- Updated K10+ to specify that Collection Occasion - Measure Date must not be after Episode - End Date
- Updated K5 to specify that Collection Occasion - Measure Date must not be after Episode - End Date
- Updated SDQ to specify that Collection Occasion - Measure Date must not be after Episode - End Date

10.19. 25/9/2017 - Version 1.0.11¶

Upload specification
- Added Deleting records
Data model and specifications
- Record formats
  - Episode
    - Updated Episode - Completion Status to allow either 0 or blank to represent ‘Episode open’
  - Service Contact
    - Clarified that the upper bound for Service Contact - Copayment is 999999.99
    - Updated Service Contact - Participants and Service Contact - Client Participation Indicator to clarify how Service Contact - Participants and Service Contact - Client Participation Indicator interact
Validation Rules
- Updated Validation Rules to clarify how Service Contact - Participants and Service Contact - Client Participation Indicator interact

10.20. 29/8/2017¶

Identifier management
- Updated Managing Client Keys reference to clarify future development
- Updated Managing Practitioner, Episode, Service Contact and Outcome Collection Occasion Keys and specification links

10.21. 25/8/2017¶

Upload specification
- Updated Upload specification to include provider organisations.

10.22. 23/8/2017¶

Added Validation Rules
Data model and specifications
- Record formats
  - Practitioner
    - Updated Practitioner - Year of Birth to clarify which years are valid.
  - Client
    - Updated Client - Date of Birth to clarify that future dates are not valid.
  - Episode
    - Updated Episode - End Date to clarify that future dates are not valid.
    - Updated Episode - Area of usual residence, postcode to clarify which postcodes are valid.
    - Updated Episode - Referral Date to clarify that future dates are not valid.
  - Service Contact
    - Updated Service Contact - Date to clarify that future dates are not valid.
    - Updated Service Contact - Postcode to clarify the ranges of postcodes that are valid.
  - Outcome Collection Occasion
    - Updated Collection Occasion - Measure Date to clarify that future dates are not valid.

10.23. 28/7/2017¶

ATAPS MDS to PMHC MDS data mapping
- Updated to show the mapping of ATAPS MDS diagnosis fields to PMHC Principal Diagnosis and Additional Diagnsis where two ATAPS diagnosis fields have been specified

10.24. 24/7/2017¶

Data model and specifications
- Upload specification
  - Example file updated so that practitioners file/worksheet validates correctly

10.25. 6/7/2017 - Version 1.0.10¶

Data model and specifications
- Data model
  - Updated data model diagram following Department of Health communication on 21 June, 2017 regarding the Master Client Index

10.26. 30/6/2017 - Version 1.0.9¶

Data model and specifications
- Record formats
  - Provider Organisation
    - Updated Provider Organisation to add the following field:
      - Provider Organisation - Status

10.27. 26/6/2017 - Version 1.0.8¶

Data model and specifications
- Record formats
  - Episode
    - Updated Episode - Additional Diagnosis to add the following response codes:
      - 000: No additional diagnosis
      - 100: Anxiety disorders (ATAPS)
      - 200: Affective (Mood) disorders (ATAPS)
      - 300: Substance use disorders (ATAPS)
      - 400: Psychotic disorders (ATAPS)
    - Updated Episode - Principal Diagnosis to add the following response codes:
      - 100: Anxiety disorders (ATAPS)
      - 200: Affective (Mood) disorders (ATAPS)
      - 300: Substance use disorders (ATAPS)
      - 400: Psychotic disorders (ATAPS)
  - Service Contact
    - Updated Service Contact - Type to add the following response code:
      - 98: ATAPS
- Added ATAPS MDS to PMHC MDS data mapping

10.28. 14/6/2017 - Version 1.0.7¶

Data model and specifications
- Record formats
  - Service Contact
    - Updated Service Contact - Duration to add response 0: ‘No contact took place’.
    - Updated Service Contact - Duration response 1 from ‘0-15 mins’ to ‘1-15 mins’.
    - Updated Service Contact - Type to add response 0: ‘No contact took place’.
    - Updated Service Contact - Modality to add response 0: ‘No contact took place’.

10.29. 18/5/2017 - Version 1.0.6¶

Data model and specifications
- Record formats
  - Practitioner
    - Updated Organisation Path to specify the Provider Organisation providing a service to the client.
    - Updated Organisation Key to specify the key uniquely identifies the Provider Organisation to the Primary Health Network.
  - Client
    - Updated Organisation Path to specify the Provider Organisation providing a service to the client.
    - Updated Organisation Key to specify the key uniquely identifies the Provider Organisation to the Primary Health Network.
  - Episode
    - Updated Organisation Path to specify the Provider Organisation providing a service to the client.
    - Updated Organisation Key to specify the key uniquely identifies the Provider Organisation to the Primary Health Network.
  - Collection Occasion
    - Updated Organisation Path to specify the Provider Organisation providing a service to the client.
    - Updated Organisation Key to specify the key uniquely identifies the Provider Organisation to the Primary Health Network.
  - Service Contact
    - Updated Organisation Path to specify the Provider Organisation providing a service to the client.
    - Updated Organisation Key to specify the key uniquely identifies the Provider Organisation to the Primary Health Network.
Upload specification
- File types
  - Updated Upload specification to specify practitioners.csv filename in zipped CSV uploads.

10.30. 1/5/2017 - Version 1.0.5¶

Data model and specifications
- Record formats
  - Episode
    - Added more description to Episode - Client Consent to Anonymised Data
  - Service Contact
    - Changed wording of Service Contact - No Show to specify ‘intended participant(s)’ instead of ‘client’
  - Outcome Collection Occasion
    - K10+ updated reference to Q11-14 ‘missing’ replacing ‘not applicable’.

10.31. 8/2/2017 - Version 1.0.4¶

Data model and specifications
- Data model - Updated the data model diagram to explicitly show Primary Health Organisations and Provider Organisations.
- Record formats
  - Client
    - Added more description to Organisation Path
  - Episode
    - Added more description to Organisation Path
    - Episode - Homelessness Flag updated to include missing/not stated value of 9
  - Service Contact
    - Added more description to Organisation Path
  - Collection Occasion
    - Added more description to Organisation Path
  - Practitioner
    - Added more description to Organisation Path

10.32. 21/10/2016 - Version 1.0.3¶

Data model and specifications
- Record formats
  - Outcome Collection Occasion
    - Collection Occasion - Measure Date updated to include missing value of 09099999

10.33. 14/10/2016 - Version 1.0.2¶

Data model and specifications
- Record formats
  - Outcome Collection Occasion
    - Updated SDQ by adding SDQ items and Scale Summary scores subsection

10.34. 6/10/2016 - Version 1.0.1¶

Data model and specifications
- Record formats
  - Episode - Principal Focus of Treatment Plan - Updated response 4 from ‘Complex care package for adults’ to ‘Complex care package’
  - Episode - Source of Cash Income - Added 0 as a valid response for when the client is aged less than 16 years
- Definitions
  - Added required field to all definitions

10.35. 18/9/2016 - Updates between final draft version and Version 1¶

Reporting arrangements
- Uploading data section expanded
- ‘Upload frequency’ section renamed Reporting timeliness and expanded
Data model and specifications
- Updated Data model diagrams including addition of collection occasion total and sub scores
- Added Key concepts section
- Record formats
  - Added lengths to all string types
  - Added minimum and maximum values to number types
  - Added links to Australian Bureau of Statistics (ABS) definitions
  - Provider Organisation - Type updated domain
  - Client - Country of Birth - Fully specified domain
  - Client - Main Language Spoken at Home - Fully specified domain
  - Episode - Client Consent to De-identified Data renamed Episode - Client Consent to Anonymised Data
  - Episode - Completion Status - Added blank as a valid response to mean that the episode is still open
  - Episode - Principal Focus of Treatment Plan - 4 = ‘Complex care package for adults’ renamed ‘Complex Care Package’ and notes updated.
  - Episode - Principal Diagnosis - 999 = ‘Missing’ response option added
  - Service Contact - Participants - 4 = ‘Other health professional or service provider’ response option added
  - Service Contact - Participants - 5 = ‘Other’ response option added
  - Service Contact - Venue - 99 = ‘Not stated’ response option added
  - Outcome Collection Occasion
    - Total scores and sub scores will be accepted in the short term Individual item scores will eventually be required
    - K10+ - Score added
    - K5 - Score added
    - SDQ - Emotional Symptoms Scale added
    - SDQ - Conduct Problem Scale added
    - SDQ - Hyperactivity Scale added
    - SDQ - Peer Problem Scale added
    - SDQ - Prosocial Scale added
    - SDQ - Total Difficulties Score added
    - SDQ - Impact Score added
Upload specification
- CSV files must be compressed into a single zip file before uploading
- Example organisation structure added
- All files/worksheet must be internally consistent
Added Using the data specification to create client forms

10.36. 9/8/2016 - Updates since last release¶

Updated Data model diagrams including addition of collection occasions
Renumbered Provider Organisation - Type response options
Updated description of Practitioner record type
Removal of Episode - Start Date from the Episode record layout as it is derived from the first service contact
Added Episode - Client Consent to Anonymised Data field
Episode - Completion Status:
- Added option Episode closed administratively - client referred elsewhere
- Recoded Episode closed administratively - other reason
- Updated explanations of response options.
Added Episode - GP Mental Health Treatment Plan Flag
Service Contact - Duration added response options
Outcome Collection Occasion
- Updated definition
- Added explicit record types for K10+, K5, and SDQ
Client - Country of Birth now refers to recently released ABS 2016 release
Client Key - Updated definition
Client - Main Language Spoken at Home now refers to recently released ABS 2016 release
Episode Key - Updated definition
Organisation Path - Added definition
Practitioner - ATSI Cultural Training - updated definition
Service Contact - Type - 8 = ‘Cultural specific assistance NEC’ response option updated definition
Added “tags” field to all record types. e.g. Client - Tags.