Icons / Login Created with Sketch.
Icons / User Created with Sketch.

Multi-source datafile CCMS datasets

ALSWH has developed the Common Conditions from Multiple Sources (CCMS) datasets, to streamline your analyses. The task of harmonising numerous sources, and ascertaining relevant diagnoses, has already been done.

The CCMS is a group of datasets indicating whether eligible ALSWH women have any of the common conditions listed in the table below (more conditions will be added over time). CCMS datasets use all available data sources (surveys, administrative information, and linked external health record collections). The datasets include detailed information on the diagnoses used to evidence the condition, the sources for this information and dates thereof.

External linked data sourcesALSWH internal sources
CCMS Dataset
Deaths
Cancer
Registries

MBS a

PBS
Hospital
admissions/
emergency
Aged
care a,b
Survey
data c
Medications
dataset d
Administrative
data e
Asthma⦿⦿⦿⦿⦿⦿⦿
Cancer⦿⦿⦿⦿
Chronic Obstructive Pulmonary Disease⦿⦿⦿⦿⦿⦿
Dementia⦿⦿⦿⦿⦿⦿⦿
Depression/ anxiety⦿⦿⦿⦿⦿⦿⦿
Diabetes⦿⦿⦿⦿⦿⦿⦿⦿
Eating Disorders⦿⦿⦿⦿⦿⦿
Essential hypertension⦿⦿⦿⦿⦿⦿⦿
Hypercholesterolaemia⦿⦿⦿⦿⦿⦿⦿
Ischaemic Heart Disease⦿⦿⦿⦿⦿⦿⦿⦿
Stroke⦿⦿⦿⦿⦿
Uterine Fibroids⦿⦿⦿⦿⦿⦿⦿
a Records from the Department of Veteran’s Affairs (DVA) are not used in the CCMS. DVA records are mainly relevant to the 1921-26 Cohort; omitting them from CCMS makes little difference to prevalence counts.
b Aged Care data sources are further classified in the CCMS dataset as: ACAP; ACFI; Home Care Packages; National Assessment Screening Form.
c Survey data is further classified as: Survey variables; Free text responses; Comments.
d The ALSWH Medications dataset is derived from survey data.
e ALSWH administrative data is further classified as: Reasons for withdrawal from surveys; Reasons why a proxy completed the survey.

The determination of whether an ALSWH participant has a particular condition is complex. The CCMS methodology was developed by the ALSWH research team for our 2020 Major Report (The impact of multiple chronic conditions).  Further work followed, to enhance the CCMS and make it available for sharing.

Collaborating researchers may not have the time and resources to accurately reproduce this work. Variation in methodologies may produce inconsistent findings.

Further, the inclusion of ALSWH administrative data in the CCMS provides additional information, such as health reasons (where stated) for being unable to complete surveys.

There are currently 55,498 ALSWH women in the CCMS datasets (women who have opted out of health record linkage are excluded).

Eligibility criteria have been developed for each condition, including:

  • ICD codes
  • MBS/PBS Item numbers
  • Answers to survey questions
  • Terms (and their context) in free text data.

The weighting of evidence from among the sources varies by condition, to minimise over-reporting due to erroneous data, or short-term conditions. For example, a Cause of Death Code may have more weight than a self-reported condition, and MBS/PBS item numbers may not be definitive, so other criteria must also be met (such as set numbers of occurrences in the data source).

CCMS datasets contain the following indicative or summary variables for each condition:

  • Presence/ absence (1/0)
  • Date first recorded (MM-YYYY)
  • Number of sources in which the condition was present.

Additional variables in the dataset provide more detailed information on case ascertainment. Comprehensive documentation is provided in the CCMS Data Dictionary (to be published online soon).

CCMS datasets rely on linked data sources, therefore they must be requested on your EoI Form in the Linked Data Section, see Applying for data.

CCMS datasets are sufficient for many analyses, rather than using the source linked data collections. (However, you may also request the source collections, if you wish to include other aspects of health service use in your analyses).

The approvals required are the same as for the source datasets, as are the Conditions of use and publishing.

CCMS datasets will be updated annually; the current CCMS version is 2022.

The applicable periods or dates of coverage differ for each data source. The tables below summarise the data sources used in the CCMS dataset, 2022 version. For comprehensive information, by condition, please see the CCMS Data Dictionary.

CCMS: Linked data sources usedCCMS: ALSWH surveys used
Data sourceFrom
Year
To
Year
CohortFrom
Year: Wave
c
To
Year: Wave
c
Deaths199620191989-952013: 12019: 6
Cancer Registry a1982-200820171973-781996: 12018: 8
MBS198420211946-511996: 12019: 9
PBS200220211921-261996: 12022: 6MF21 d
Hospital admissions/ Emergency a1970-20072017-21
Aged Care b
1997-20082015-20

a Varies by State
b Varies by Aged Care Program
(See details of all current ALSWH national and state linked data holdings).
c Not all Survey Waves are applicable to all conditions; questions on a particular condition may not be asked at every survey.
d After Wave 6 (that is, since 2011) short six-monthly surveys (‘6MF’) have been administered to the 1921-26 Cohort.
(More information on survey participation can be found here. Surveys and data books are also available).

 

ConditionAll cohorts1989-951973-78 1946-511921-26
N%N%N%N%N%
Asthma715212.9195011.5139610.3199915.4180715.0
Cancer834115.03051.87615.6322624.9404933.6
COPD30085.4170.1670.58636.7206117.1
Dementia48988.8<5<52852.2460838.1
Depression/ anxiety2494845.0778545.9662049.0581044.9473339.2
Diabetes613211.03712.26304.7233418.0233423.2
Eating disorders11252.010015.91060.880.1100.1
Essential hypertension1862733.63251.9139110.3741057.2950178.7
Hypercholesterolaemia1317123.71040.66735.0666251.4573247.5
Ischaemic Heart Disease947917.1450.32071.5238918.4683856.7
Stroke44708.0290.11110.85944.6373631.0
Uterine fibroids14832.7239.15313.98246.41050.9