Data scoping conventions - adult
- Samuel Allingham (Unlicensed)
The following outlines the process by which epiCentre takes scoping dates (i.e. a start date and end date) and determines which records will be extracted from the database. Throughout, the date entered in the start date field will be referred to as [START_DATE] and the end date as [END_DATE].
Step 1:
1a. Determine which service event records meet the following criteria:
[START_DATE] <= [DATE_OF_SERVICE] <= [END_DATE]
These service events are considered “IN SCOPE”
1b. Determine which questionnaires meet the following criteria:
([START_DATE] <= [GENERATION_DATE] <= [END_DATE]) OR
(([START_DATE] <= [COMPLETION_DATE] <= [END_DATE]))
These questionnaires are considered “IN SCOPE”
Step 2:
Any episodes associated with an “IN SCOPE” service event or questionnaire are also marked as being "IN SCOPE".
Step 3: Using the list of episodes identified as being “IN SCOPE” from step 2, mark the following records as “IN SCOPE”:
- Patient record (Link via ePPOC Patient Identifier field)
- All associated Pathways (Link via ePPOC Patient Identifier and Episode ID fields)
- All associated Service event records (Link via ePPOC Patient Identifier and Episode ID fields) i.e. not just those originally identified as IN_SCOPE in Step 1.
- All associated Questionnaire records (Link via ePPOC Patient Identifier and Episode ID fields) i.e. not just those originally identified as IN_SCOPE in Step 1.