Part of Lung Cancer Screening Data Set user guidance
Repeating data items
Linkage data items
Linkage data items appear in more than one table and allow the relationship between records within different tables to be identified.
The linkage data items below are fully described within the ETOS. The following information should be referenced in conjunction with the Data Model, available on the Lung Cancer Data Set and the Data Linkage tab in the ETOS.
| Data item name | Additional notes |
|---|---|
| Local Patient Identifier (Extended) |
The Local Patient Identifier (Extended) is used to uniquely identify a participant within the Health Care Provider. It may be different from the participant’s casenote number and may be assigned automatically by the computer system. This item is a primary key in the LCS001 Patient Demographics table and must be unique to this table, within submission. No patient can have more than one Local Patient Identifier (Extended). This can be checked by looking at data items such as NHS number, postcode and date of birth. The Local Patient Identifier (Extended) provides a link between records in the LCS001 Patient Demographics table, and associated tables. Please refer to the LCSDS Data Model for details. To avoid the incorrect linkage of records the Local Patient Identifier (Extended) must not be reused it should only ever relate to one participant. This ensures that data relating to more than one participant does not get incorrectly identified as belonging to a single participant in Lung Cancer Screening Data Set (LCSDS). |
| SCREENING ELIGIBILTY IDENTIFIER |
The unique identifier for the SCREENING ELIGIBILITY period. This is needed for each distinct eligibility assessment period. Most participants may only have one eligibility period at the same lung cancer screening provider. If a participant moves address, then they may then have a new eligibility period at a different lung cancer screening provider. A screening eligibility period could last for many years, from the point that a participant first becomes eligible for screening with a provider until the point the participant is discharged from a screening provider (for example. they have aged out of the programme). This is a primary key in the LCS101 Screening Eligibility table and must be unique to this table within submission. It provides a link between records in the LCS102 Onward Referral and LCS103 Screening Offer tables. |
| SCREENING OFFER IDENTIFIER |
A screening offer is essentially an invite and can be defined as a lung health check or a scan, etc. This will be a unique identifier to identify the screening offer. This is a primary key in the LCS103 Screening Offer table and must be unique to this table within submission. It provides a link between records in the LCS104 Invitation Reminder, LCS105 Screening Outcome, LCS106 Signposting, LCS107 Coded Scored Assessment (Screening Offer) and LCS201 Care Contact tables.A new identifier is required each time a new screening offer is created. Each screening offer should be treated separately and have their own identifier, for example. a screening offer identifier for the Lung Health Check offer and a separate screening offer identifier for the low dose CT scan offer. Note: Reminders are captured separately and should not result in a new identifier being created |
| ORGANISATION IDENTIFIER (CODE OF COMMISSIONER) | This is the organisation identifier of the organisation commissioning the provision of health care from the provider that initiated or commissioned the provision of care bound by the LCS101 Screening Eligibility table. It is this table which identifies the commissioner who has paid for those services. In LCSDS this should capture the ODS code of the Cancer Alliance (for example ‘N63’ for ‘West Yorkshire and Harrogate Cancer Alliance’, ‘N45’ for ‘West Midlands Cancer Alliance’. |
| CARE CONTACT IDENTIFIER |
The Care Contact Identifier is the unique identifier for a care contact. It would normally be automatically generated by the local system upon recording a new care contact (like an appointment), although could be manually assigned. This item is a primary key in the LCS201 Care Contact table and must be unique to this table. The Care Contact Identifier provides a links between records in the LCS201 Care Contact table and associated care activity carried out during a care contact. We would like to remind providers of the importance of ensuring that the Care Contact Identifier is truly a unique data item, both within the same submission file and across multiple submission files. The Care Contact Identifier is a primary key for its respective table and is based upon the Activity Identifier data attribute which is defined as “A unique number or set of characters that is applicable to only one activity for a participant within an Organisation”. This reiterates that these identifiers should be unique across submissions. These identifiers will typically be auto generated by the system in use, so will prevent duplicates when using the same system. Where multiple systems are used it is acceptable to include a prefix to the Care Contact Identifier, which relates to the system. The prefix enables each identifier to remain truly unique for all submissions from an organisation. Every distinct care contact (like an appointment) should have its own record and as such have its own Care Contact identifier. A participant may be invited to several different care contacts by the lung cancer screening provider, for example lung health check, low dose CT scan, screening outcome appointment to discuss the results of a scan. There are data items that are designed to capture DNAs within the LCS201 Care Contact group. The Care Contact Identifier is primarily to identify the appointment itself. There is a separate group LCS202 Care Activity, with its own identifier that is used to capture the activity being carried out by the clinician. |
| CARE ACTIVITY IDENTIFIER |
The Care Activity Identifier is used to uniquely identify the care activity. It would normally be automatically generated by the local system upon recording a new activity, although could be manually assigned. This item is a primary key in the LCS202 Care Activity table and must be unique to this table. The Care Activity Identifier provides a link between records in the LCS202 Care Activity table and associated Coded Scored Assessments carried out during a care contact. We would like to remind providers of the importance of ensuring that the Care Activity Identifier is truly a unique data item, both within the same submission file and across multiple submission files. The Care Activity Identifier is a primary key for its respective table and is based upon the Activity Identifier data attributed which is defined as “A unique number or set of characters that is applicable to only one activity for a patient within an Organisation”. This reiterates that these identifiers should be unique across submissions. These identifiers will typically be auto generated by the system in use, so will prevent duplicates when using the same system. Where multiple systems are used it is acceptable to include a prefix to the Care Activity Identifier, which relates to the system. The prefix enables each identifier to remain truly unique for all submissions from an organisation. In the LCSDS, it provides a link between records in the LCS202 Care Activity table and the associated Coded Scored Assessments carried out during a care contact - The LCS203 Coded Scored Assessment (Contact) table. |
Last edited: 4 March 2026 9:21 am