This page lists responses to frequently asked questions about the Fixus MDS Aggregator.
General Questions
What is the Fixus MDS Aggregator?
The Fixus MDS Aggregator is a purpose-built module designed to support lead agencies in the collection, validation, and aggregation of Minimum Data Set compliant data from external service providers. It streamlines the process of receiving data from distributed systems, ensuring consistency, accuracy, and compliance with reporting requirements.
This module plays a central role in environments where service delivery is distributed across multiple agencies, each using their own case management systems. By acting as a central integration point, the MDS Aggregator allows the lead agency to maintain control over client and episode data, while enabling participating agencies to submit their service contact and assessment records through structured, secure uploads.
Key features include:
- Support for multiple minimum data sets
- Automated validation and error logging
- Support for distributed episode workflows and program stream mapping
- Custom field handling and advanced access controls
- End-to-end tracking of reporting periods and submissions
Who can use the Fixus MDS Aggregator?
Only agencies with the MDS Aggregator module enabled can use the MDS Aggregator. The agency must have at least one team configured for PMHC and a valid Provider Organisation Key that matches the Organisation Path in uploaded data.
What type of data does the MDS Aggregator process?
The aggregator processes a range of data which includes:
- Referrals
- Practitioners
- Clients
- Episodes
- Service contacts
- Select Assessments (K5, K10+ & SDQ)
How does the distributed episode workflow function?
- The lead agency creates a reporting period.
- Referrals are received and converted into episodes.
- Agencies manage these episodes in their own systems and record service contacts.
- Agencies submit their MDS extract to the Fixus MDS Aggregator.
- Fixus matches records using the Client Key and Episode Key.
- A combined MDS report is generated and submitted to the MDS portal.
What types of Import Modes are supported?
The Fixus MDS Aggregator supports multiple import modes to accommodate various data submission workflows and quality assurance strategies. These modes determine how incoming records are handled based on whether they already exist in the system.
Import or Update
This is the most flexible mode. It allows the system to:
- Create new records when no matching ID is found.
- Update existing records when a matching ID is found, based on the selected Duplicate ID Handling option.
Applicable Duplicate ID Handling options:
- Update – Existing records are updated with the values from the import file.
- Skip – Existing records are left unchanged; only new records are created.
- Reject – If a duplicate ID is found, the entire import is cancelled.
Import New Only
This mode is used when the goal is to only add new records. It ensures that no existing data is modified.
- If a record with a matching ID already exists, it is treated based on the selected Duplicate ID Handling option.
- No updates to existing records are allowed in this mode.
Applicable Duplicate ID Handling options:
- Skip – Duplicate records are ignored.
- Reject – The entire import is rejected if any duplicate ID is detected.
Update Existing Only
This mode strictly updates existing records and will not create any new records, even if valid data is provided for a record that doesn’t already exist in the system.
- This is typically used when correcting or re-submitting known records.
- The districted workflow process will provide this as the only option for PMHC submissions.
Applicable Duplicate ID Handling options:
- None – The system expects that all incoming records already exist. Any unmatched ID will be ignored or logged as an error.
Data Submission & Validation
What file formats are supported for uploads?
The Fixus MDS Aggregator supports ZIP (containing CSV files) and Excel (.xlsx) file types.
Are there file size limits for uploads?
Yes, uploaded files must be less than 512 MB.
What happens if a submission fails validation?
If an uploaded file fails validation:
- Errors are logged and displayed in Fixus.
- The file will not be processed until errors are resolved.
- The uploader is notified about the issues that need correction via email.
What are the validation steps for submitted data?
The aggregator validates data in the following sequence:
- Payload Check – Ensures data is present.
- Submission Upload Record – Verifies metadata and uploader details.
- Document Verification – Ensures at least one valid file is included.
- File Type & Size Check – Confirms correct file format and size limits.
- Loading the File – Reads file data into memory.
- Format-Specific Validation – Ensures required CSV files/tabs exist.
- Data Reading & Logging – Checks each record for compliance.
- Record Processing – Verifies required fields and relationships.
What data validation rules does the aggregator enforce?
- Clients must have unique Client Keys.
- Episodes must be linked to a valid Client Key.
- Service contacts must have a valid date and practitioner record.
- Assessment scores are stored as provided but not recalculated.
- Practitioners must have a matching Practitioner Key and Organisation Path.
What happens if duplicate records are found?
- If duplicate detection is enabled, processing will stop to prevent duplicate records from being added.
- If duplicate detection is not enabled, existing records may be updated based on the provided data.
Data Processing & Reporting
How does the Fixus MDS Aggregator process validated data?
Once a file passes validation, data is processed in the following order:
- Clients
- Practitioners
- Intake
- Intake Episodes
- Episodes
- Service Contacts
- Assessments
How are referral IDs assigned during episode creation?
When an episode is created through an MDS Aggregator upload:
- The Referral ID is set using the Episode Key from the upload.
- It is prepended with the Identifier Prefix from the agency configuration.
- This prevents duplicate Referral IDs from being introduced.
What is the Program Stream Mapping process?
The Program Stream Mapping process categorises incoming records based on predefined rules:
- Override Program Stream Code – If set, all records are assigned to this stream.
- Program Stream Column Check – If the uploaded record has a valid stream column, it is used.
- Mapping Table Lookup – If no stream is found, Fixus assigns one based on a pre-configured mapping.
- Default Program Stream Code – If all else fails, a default stream is assigned.
What happens if no program stream can be assigned?
If no program stream can be determined, the record is flagged for review and the process fails.
Does the Fixus platform support additional fields?
Yes, you can add additional columns to the client and episode data sets in the form of “custom_{field name}”. The “field name” must match a custom field created in the Fixus platform.
Permissions & Access Control
Can agencies update episodes in Fixus?
This depends on the lead agency’s configuration:
- Some lead agencies only allow external agencies to update service contact records but not modify episodes.
- Access control settings can restrict episode modifications while still allowing service contact data to be updated.
What are the permission requirements for submitting data?
- Agencies must have the MDS Aggregator module enabled.
- Agencies must have a valid Organisation Path configured.
- Staff submitting data must have appropriate Fixus access.
Why do practitioners need a matching Practitioner Key?
The Practitioner Key ensures that service contact records are properly linked to the correct practitioner. If no matching practitioner is found, the submission will fail validation.
Troubleshooting & Common Issues
Why is my upload failing?
- Check that your file format is ZIP or Excel (.xlsx).
- Ensure file size is under 512 MB.
- Confirm that all required columns and values are included.
- Verify that Client Keys, Episode Keys, and Practitioner Keys are correct.
- Check the validation log provided by the Fixus platform.
How can I fix validation errors?
- Review the validation logs in the Fixus platform.
- Check the column formatting in your data.
- Ensure all required fields are populated correctly.
- Ensure that your data aligns with the PMHC V4 standard (if applicable).
Can I re-upload a corrected file after an error?
Yes, you can re-upload the corrected file. The system will reprocess the data and update the dataset accordingly.
Supported MDS types
PMHC V4 – The Primary Mental Health Care Minimum Data Set (PMHC MDS) will provide the basis for PHNs and the Department of Health to monitor and report on the quantity and quality of service delivery, and to inform future improvements in the planning and funding of primary mental health care services funded by the Australian Government.