Oracle® Health Sciences Cohort Explorer User's Guide Release 1.0 E24437-01 |
|
|
PDF · Mobi · ePub |
This section describes predefined dashboards and reports delivered with Oracle Health Sciences Cohort Explorer (OHSCE):
See Also:
OHSCE is delivered with one dashboard and seven dashboard pages. These dashboard pages can be accessed by users with a specific job responsibility and security privileges. Each dashboard page displays different set of reports.
Each Cohort Explorer user has a unique username and password. Each username will have one or more roles associated with it. These roles will indicate which reports you can access. The available roles are as follows:
CE-Physician
CE-Researcher
CE-Limited Access
CE-Developer
CE-Administrator
After logging in to Cohort Explorer, you will be automatically directed to the Summary dashboard. From here, depending on the access provided to your user role, you can navigate to any of the five available pages at any point during the session. The available dashboard pages are as follows:
The following sections describe the content of each available dashboard page of the Cohort Explorer.
The Summary dashboard page displays seven reports at a time. All the reports are driven by time range (from-to) filtering criteria, which you can configure. By default, all reports display data for 1 month dating back from the current date. There is also an option to view data for a time range of your choice.
Ethnicity or Race of Newly Diagnosed Patients (TRC-CER-004) Details
Age or Gender of Newly Diagnosed Patients (TRC-CER-005) Details
The Patients Diagnosed and Treated report displays data for patients for the user-defined time period, default time period being 1 month back from the current date.
It is preconfigured during the initial setup or installation phase and can later be configured or altered only by CE-Administrator or CE-Developer during the initial install phase. The columns of the resulting patient count table are:
Number of diagnosed patients - how many patients have been diagnosed with a specific disease during the time period specified.
Number of patients who consented - how many patients have consented to specific treatments (type of consent considered is customized based on your requirements) during the specified time period.
Number of patients successfully treated – how many patients have been treated successfully during this time period.
Number of patients undergoing treatment – how many patients are or have been undergoing any type of treatment during the specified period of time.
For more information, see the report details in Patients Diagnosed and Treated (Report TRC-CER-001)
The Number of Treatments Performed report counts the number of treatments performed during the specified from-to time period (default being 1month back from current date).
Treatments are categorized according to types and include Surgery, Chemotherapy, Radiation, Gene Therapy, and so on. The selection of treatment types is done during the configuration phase by either CE-Administrator or CE-Developer roles and cannot be modified by other users.
For more information, see the report details in Number of Treatments Performed (Report TRC-CER-003)
The Ethnicity or Race of Newly Diagnosed Patients report is a pie-chart view of how many patients of a particular race or ethnicity have been diagnosed with a disease during the specified time period (default 1 month back from current date). You can toggle between Ethnicity (default) and Race, to see the counts and percentages of patients.
For more information, see the report details in Ethnicity or Race of Newly Diagnosed Patients (Report TRC-CER-004)
The Age or Gender of Newly Diagnosed Patients report displays how many patients within a particular age category and gender have been diagnosed in the facility during the user specified time period (default time is 1 month back from current date). There following five age categories are configured:
0-18 years old
19-35
36-50
51-65
66+
Only users with CE-Administrator or CE-Developer roles can modify age ranges and number of age categories.
For more information, see the report details in Age or Gender of Newly Diagnosed Patients (Report TRC-CER-005)
The Biospecimen Samples Status report displays the counts of specimen samples that have been collected during the specified time period, default 1 month back from today. The counts are broken down by the Anatomical Site, and anatomical sites are listed along the rows.
The list of available sites is configured by the customer during the system install. Anatomical Site is a hierarchy, thus the end user can drill into each Anatomical site and see its subcategories along with associated counts. The subsequent columns display:
Type of specimen - for each anatomical site, there may be multiple types of specimen collected for example, tissue, cell culture, liquid, and so on. All of the available types of specimen are listed for each site.
Number of Specimen Collected in Facility - for each listed Anatomical Site and Type, displays how many specimen have been collected during the specified time period (default 1 month back from the current date).
Number of Patients Corresponding to Collected Specimen - how many unique patients correspond to the specimen collected in the previous column.
Number of Patients providing Specimen who Consented - how many of these patients have signed consent forms allowing usage of their samples for research. The exact type of consent considered will vary by the facility and is configured during the initial system install.
For more information, see the report details in Biospecimen Samples Status (Report TRC-CER-006)
Query Patients page is the user interface to querying for cohorts. This page contains over 300 filtering criteria, grouped into ten prompt set categories listed below.
Each prompt set category represents a logical grouping of various attributes relevant to a patient. Additionally, within each grouping there may be additional sub-categories, which are placed in different category pages. You can navigate to these pages via the Next and Previous buttons. Following are the patient attribute categories grouped into prompt sets:
This set of prompts consists of two pages. On the first page, you can enter demographics and consent criteria to be present in the patient cohort. On the second page, you can enter patient geographic location criteria.
For more information, see the prompt details in Statistics from-to (Prompt Set TRC-CEP-001)
You can select users that qualify for specific protocols by selecting either Protocol Name(s) or Protocol Code(s). You can select multiple protocols which will return all patients that qualify for any of the selected protocols.
For more information, see the prompt details in Protocol Prompts (Prompt Set TRC-CEP-S02)
The Patient History set of prompts consists of three pages. Patient history is used to select any type of risks or patient characteristics that may be relevant to the patient treatment, for example smoking, alcohol use, obesity, and so on.
The selection criteria are repeated on each of the three pages in order to allow the end user to make queries where all (up to 3) of the risk factors or patient history events must characterize a given patient.
For example, patients who smoke AND drink alcohol AND are overweight would need to be specified as one criteria per prompt page (for example, smoke in History (page 1), drink alcohol in History (page 2) and overweight in History (page 3)) to be able to express the AND condition between the criteria. To get patients who smoke OR drink alcohol OR who are overweight (any of these risk factors would suffice to qualify), these risk factors can be selected within a single multi select prompt in History (page 1).
For more information, see the prompt details in Patient History Prompts (Prompt Set TRC-CEP-S03)
Diagnosis set of prompts consists of three pages. Pages two and three contain identical filtering criteria as page one and are used to perform AND condition queries, similar to those within Patient History set of prompts.
For example, to know how many patients have been diagnosed with Lung Cancer AND Breast Cancer, you need to select Lung Cancer in Diagnosis (page 1) and Breast Cancer in Diagnosis (page 2). To ascertain how many patients have been diagnosed with Lung Cancer OR Breast Cancer, you can select both of these diagnoses on a single Diagnosis (page number).
Diagnosis is organized as a multi-level hierarchy, and, depending on the coding system for diagnosis, different number of levels may be necessary to support all hierarchy levels (for example, 8 levels for ICD-10 coding system, 6 levels for ICD-9 coding system).
The number of hierarchy levels to be exposed is customized during the installation phase of Cohort Explorer. You can drill down from the top level of the hierarchy, either via Diagnosis Names or Codes. You can stop at any level to get the count of patients who qualify under this diagnosis level (the count includes all of a given diagnosis' subcategories).
You may want to query for patients who have a specific Anatomical Site associated with the Diagnosis as well. Anatomical site is also organized as a hierarchy, and, similar to Diagnosis, the number of hierarchy levels depends on the coding system used. You may choose to query for patient counts at any level of the Anatomical Site hierarchy.
You can select additional attributes selected pertaining to the diagnosis, including temporal information such as Onset Date (when the patient reported symptoms of the disease), Date Reported (when the doctor determines the disease and enters the diagnosis into the system) and End Date (when the disease is assessed as cured or in remission).
For more information, see the prompt details in Diagnosis Prompts (Prompt Set TRC-CEP-S04)
Procedure or Treatment set of prompts consists of three pages. Pages two and three contain identical filtering criteria as page one and are used to perform AND condition queries, similar to those within Patient History set of prompts.
For example, to determine how many patients have undergone both Surgery and Chemotherapy, you would select Surgery in Procedure or Treatment (page 1) and Chemotherapy in Procedure or Treatment (page 2).
To determine how many patients have undergone either Surgery OR Chemotherapy, you can select both of these treatment types within a single Procedure or Treatment (page number).
Procedures can be selected either through name or procedure code. Each Procedure belongs to one or more Procedure Types, which are customized based on your organization's needs. In addition, patients can be selected based on the dates on which they have undergone procedures.
For more information, see the prompt details in Procedure Prompts (Prompt Set TRC-CEP-S05)
Medication set of prompts consists of three pages. Pages two and three contain identical filtering criteria as page one and are used to perform AND condition queries, similar to those within Patient History set of prompts.
For example, to know how many patients have been administered Medication MedA AND MedB, you would select MedA in Medication (page 1) and MedB in Medication (page 2).
To identify how many patients have been administered either MedA OR MedB, you can select both of these medications within a single Medication (page number). You can also select other attributes relevant to Medication including the Dosage amount, and the Start and End dates during which the medication has been administered to or taken by the patient.
For more information, see the prompt details in Medication Prompts (Prompt Set TRC-CEP-S06)
Diagnostic Test set of prompts consists of three pages. Pages two and three contain identical filtering criteria as page one and are used to perform AND condition queries, similar to those within Patient History set of prompts.
For example, to identify how many patients have undergone both TestY AND TestZ, you would select TestY in Test (page 1) and TestZ in Test (page 2). However, to identify how many patients have taken either TestY OR TestZ, you can select both of these tests within a single Test (page number).
A test can be specified either by its name or code. Other available attributes for selection include date the test was performed and its results, either numeric or textual.
For more information, see the prompt details in Diagnostic Test Prompts (Prompt Set TRC-CEP-S07)
This set of prompts consists of four pages, each page focusing on relationships between a pair of patient dimensions. It lets you query Medication administered with relation to a specific Procedure or Treatment (page 1), Diagnostic Tests performed in relation to a specific Treatment or Procedure and Test results (page 2), Diagnostic Tests performed in relation to administering a specific Medication (page 3), and Specimen collected as part of a specific Diagnostic Test performed (page 4).
For more information, see the prompt details in Filter Patients with Specific Combinations of Medication-Procedure, Diagnostic Tests-Procedure, Diagnostic Tests-Medication, Diagnostic Tests-Specimen Prompts (Prompt Set TRC-CEP-S08)
Exclusion Criteria set of prompts works differently from the other prompts since its filtering criteria are intended to exclude patients from a cohort, rather than include them. The filtering criteria within each Exclusion prompt set page are logically connected with AND, while pages within exclusions are connected with OR.
For example, if you select Gender to be Female and Age (in Years) between 18 and 25 in Patient Information (page 1), Smoking as Risk on History or Risks (page2), and Breast Cancer on Diagnosis (page 3), the resulting filter will be to: Exclude all female patients who are between 18 and 25 years old, and also exclude patients who smoke, and exclude all patients who have Breast Cancer.
Exclusion Criteria set of prompts consists of six pages and each page is designated to focus on a different patient dimension. You can exclude patients based on attributes from categories such as Patient Information, History or Risks, Diagnosis, Diagnostic Test, Procedure or Treatment, and Medication.
For more information, see the prompt details in Exclusion Criteria Prompts (Prompt Set TRC-CEP-S09)
Specimen set of prompts consists of three pages. Pages two and three contain identical filtering criteria as page one and are used to perform AND condition queries, similar to those within Patient History set of prompts.
For example, to identify how many patients have provided both Specimen Type SpecK AND SpecL, you would select SpecK in Specimen (page 1) and SpecL in Specimen (page 2). However, to ascertain how many patients have provided either SpecK OR SpecL, you can select both of these values within a single Specimen (page number).
Additionally, Specimen set of prompts supports filtering on the corresponding Anatomical Site hierarchy. You can specify any level within the hierarchy and filter on the specimen corresponding to this level and all of its subcategories. Additional filtering criteria are available including the date the specimen was collected and the amount.
For more information, see the prompt details in Specimen Prompts (Prompt Set TRC-CEP-S10)
After the user-specified filtering criteria for each prompt set are executed, a report is generated with the resulting patient counts. This report appears on the right hand side of each prompt set. The first report, Starting with Patient Count: (Report TRC-CER-101) lists the starting count of patients in the database.
The next report, Patient Information (Report TRC-CER-102), lists the count of patients after Patient Information filtering criteria is applied. Below that, Protocol (Report TRC-CER-103) which is to the right of the Protocol prompt set, reports on the count of patients after both Patient Information and Protocol criteria has been applied and so on. To summarize, every subsequent report considers selections in all of the prompt sets up to and including the prompt set on the left hand side of the report.
Specimen or Specimen Count (Report TRC-CER-125)report computes the number of specimen corresponding to the Specimen filtering criteria as applicable to the patient cohort.
Below the specimen report is the, Total Patient Count (Report TRC-CER-112), which gives the final count of patients satisfying all of the filtering criteria specified by you.
When you hover over the patient count, a pop up displays List Patients in Cohort or Timelines of Patients in Cohort dashboard page. Patients corresponding to the selected patient cohort are listed. The final report on the Query Patients page is the Summary of Filtering Criteria Applied (Report TRC-CER-113) which gives you an opportunity to see which selection criteria are currently in effect.
You need to click Apply after making selections within each prompt set for the selections to be applied. If you are navigating using Next or Previous buttons, you need to click Apply prior to navigating to each page within the prompt set.
Reset button only reset attributes relevant to a specific prompt set page.
Criteria filter selections within prompt sets, except for Exclusions prompt set, are connected by logical AND both within a prompt set page as well as between prompt set pages.
Criteria filter selections within Exclusions prompt set are connected by logical AND if they are on the same page. However, Exclusion criteria pages are connected by OR.
If you make multiple selections within a specific filter, for example, selects multiple medications, the selections are connected through a logical OR. For example, if you select Medications: A, B, Z within the same filtering prompt, the logical meaning is (Medication = A OR Medication=B OR Medication=Z)
For patient dimensions that are utilizing the hierarchy structure, namely Diagnosis and Anatomical Site, you need to drill through each level of the available codes. Each level is available through a separate filter, organized from the top level down.
If OR functionality is desired for multiple Diagnoses (or multiple Anatomical Sites), you may only select entities within the same hierarchy level. For example, if you want to see patients that have been given either DiagnosisA OR DiagnosisB, these two diagnoses need to be at the same level in the hierarchy.
List Patients in Cohort dashboard page lists members of a patient cohort in a tabular format. This page is accessible only through a link from Total Patient Count report in Query Patients page.
At the top of the List Patients page, there are two reports, TRC-CER-113 and TRC-CER-112, which are identical to the reports on the Query Patients page. TRC-CER-113 summarizes the filtering criteria applied within Query Patients page to obtain the list of patients in a cohort. TRC-CER-112 displays the Final patient count corresponding to all filtering criteria selected in Query Patients page. When you hover over the patient count, a pop up displays two links: List Patients in Cohort and Timelines of Patients in Cohort which, when clicked, take you to the corresponding dashboard pages.
Below the reports is a set of two filters, letting you either add or remove patients to or from a cohort. You can select multiple Patient IDs to add or remove them from the cohort. Below that is List Patients report, which displays two views of the patient list; view on the left listing only Patient IDs and view on the right displaying Patient ID, Age, Gender, Type of Events that pertain to each patient. Types include Diagnosis, Procedure, Medication, Diagnostic Test, Specimen, Patient History, and Consent. It also includes name of each specific event (for example, Lung Cancer, Chemotherapy, Gleevec, Urine Test, Blood sample, Smoking, TCC, and so on). You can drill-down into individual patient's details by clicking on the Patient ID which will navigate to Individual Patient Details tab.
Timelines of Patients in Cohort dashboard page lists temporal events for each patient in a cohort as bars within a table. This page is accessible only through a link from Total Patient Count report in Query Patients page.
At the top of the page, there are two reports, TRC-CER-113 and TRC-CER-112, which are identical to the reports on the Query Patients page. TRC-CER-113 summarizes the filtering criteria applied within Query Patients page to obtain the list of patients in a cohort. TRC-CER-112 displays the Final patient count corresponding to all filtering criteria selected in Query Patients page. When you hover over the patient count, a pop up displays two links: List Patients in Cohort and Timelines of Patients in Cohort, which when clicked, takes you to the corresponding dashboard pages.
Below the reports is a set of three filtering criteria, letting you add or remove patients to or from a cohort as well as select the time range to consider when displaying events for patients. You can select multiple Patient IDs at a time to add to or remove from the cohort. The default time range includes all of the Patient Events, but by specifying other From-To dates, some patient events (and subsequently Patient IDs which have no corresponding events) may be excluded from the Patient Timelines report table(s).
Patient Timelines report displays two views of the patient cohort, view on the left listing only Patient IDs and view on the right displaying Patient ID, Event Start and End Dates, whether the event is currently Ongoing, Duration (in days), Patient Even Type and Event Name, and Event Timeline Bar Plot. The bar plot displays each event timeline as a bar relative the earliest event on the time scale. You can drill-down into each individual patient's details by clicking on the Patient ID, which will navigate to Individual Patient Details tab. You can also select to print or export Patient Timelines report into a variety of formats including csv, Excel, and so on.
List Patients dashboard lets you select any set of patients for a cohort using the Select Patient IDs prompt. Selected patients are displayed along with their demographics and medical events in a tabular format.Select Patient IDs prompt is used to select or deselect patients to be displayed in the report below. You can select multiple Patient IDs to add or remove them from the cohort. Below that is List Patients report, which displays two views of the patient list; view on the left listing only Patient IDs and view on the right displaying Patient ID, Age, Gender, Type of Events that pertain to each patient. Types include Diagnosis, Procedure, Medication, Diagnostic Test, Specimen, Patient History, and Consent. It also includes name of each specific event (for example, Lung Cancer, Chemotherapy, Gleevec, Urine Test, Blood sample, Smoking, TCC, and so on). You can drill-down into individual patient's details by clicking on the Patient ID which will navigate to Individual Patient Details tab.The user can either print or export List Patients report into a variety of formats including csv, Excel, and so on.
Patient Timelines dashboard page lists temporal events for each patient in a cohort as bars within a table.
At the top of the page there are two filtering criteria, letting you add or remove patients to or from a cohort as well as select the time range to consider when displaying events for patients. You can select multiple Patient IDs at a time to add to or remove from the cohort. The default time range includes all of the Patient Events, but by specifying other From-To dates, some patient events (and subsequently Patient IDs which have no corresponding events) may be excluded from the Patient Timelines report table(s).
Patient Timelines report displays two views of the patient cohort, view on the left listing only Patient IDs and view on the right displaying Patient ID, Event Start and End Dates, whether the event is currently Ongoing, Duration (in days), Patient Even Type and Event Name, and Event Timeline Bar Plot. The bar plot displays each event timeline as a bar relative the earliest event on the time scale. You can drill-down into each individual patient's details by clicking on the Patient ID, which will navigate to Individual Patient Details tab. You can also select to print or export Patient Timelines report into a variety of formats including csv, Excel, and so on.
The Individual Patient Details dashboard page lists all the data available for a single selected patient. This tab can be accessed in one of two ways:
By clicking on a specific Patient ID in List Patients in Cohort, Timelines of Patients in Cohort, List Patients or Patient Timelines to drill-down into patient details
By clicking on the Individual Patient Details tab to navigate there directly
At the top of the page you can select a specific Patient ID seabed view the corresponding patient data. Patient ID is preselected if you navigated to the page by drilling into patient details. You can select a different patient ID by selecting another one from the drop-down list. Once a specific Patient ID is selected, the following reports are generated with patient details:
Patient Profile - displays Demographics and Address information for selected Patient ID.
For more information, see the report details in Patient Profile (Report TRC-CER-116)
Consent Forms Signed - lists all Consents that the patient has given in the past, including ones that may have been revoked since along with dates corresponding to each Consent.
For more information, see the report details in Consent Forms Signed (Report TRC-CER-117)
Qualifies for Protocols - lists protocols for which a given patient qualifies.
For more information, see the report details in Qualifies for Protocols (Report TRC-CER-118)
Patient History - lists tracked patient characteristics. These may include noted risks such as smoking, alcohol abuse, obesity, as well as things like past pregnancies, miscarriages and so on.
For more information, see the report details in Patient History (Report TRC-CER-119)
Patient Diagnosis - lists all Diagnoses in the patient's medical history, including those which are no longer active. The table includes Diagnosis temporal information and Anatomical Site.
For more information, see the report details in Patient Diagnosis (Report TRC-CER-120)
Procedures or Treatments Undergone - list of all Procedures performed in the patient's medical history along with temporal information about each procedure.
For more information, see the report details in Procedures or Treatments Undergone (Report TRC-CER-121)
Medications Taken - list of all the medications, dosage amounts, and dates that these procedures have been administered to or taken by the patient.
For more information, see the report details in Medications Taken (Report TRC-CER-122)
Diagnostic Tests - list of all diagnostic tests that have been given to the patient, including test's temporal information and results, either numeric or textual.
For more information, see the report details in Diagnostic Tests (Report TRC-CER-123)
Specimen Samples Collected - list of all biospecimen samples that have been collected from the patient, the date when each sample was collected and the amount for each sample.
For more information, see the report details in Specimen Samples Collected (Report TRC-CER-124)
OHSCE includes the following reports:
Ethnicity or Race of Newly Diagnosed Patients (Report TRC-CER-004)
Age or Gender of Newly Diagnosed Patients (Report TRC-CER-005)
To locate a report, you need to select a dashboard and access a page that contains the report.
Statistics on patients in facility for the time period specified, default being the last 1 month. These statistics include the number of Patients Diagnosed and Treated with disease during the time interval and how many have given consent to medical care.
Table A-1 describes the columns in the Patients Diagnosed and Treated report
Table A-1 Patients Diagnosed and Treated (Report TRC-CER-001)
Table Heading | Column Heading | Measure or Dimension in Presentation Layer |
---|---|---|
NA |
Number of Diagnosed Patients |
TRC-CEM-003 |
NA |
Number of Patients Successfully Treated |
TRC-CEM-006 |
NA |
Number of Patients who Consented |
TRC-CEM-005 |
NA |
Number of Patients Undergoing Treatment |
TRC-CEM-007 |
Statistics on the number of different types of procedures or treatments that have been performed during specified time period in the prompt, default being last 1 month.
Ethinicity and race statistics for the patients in the facility who have been diagnosed during time period specified in the dashboard prompt, default 1 month back from today. Total count of patients in this report is based on the patients diagnosed during the period specified by the end user (default 1 month back from today).
Age and gender statistics for patients in the facility who have been diagnosed during time period specified in the dashboard prompt, default 1 month back from today. Total count of patients in this report is based on the patients diagnosed during the period specified by the end user (default 1 month back from today).
Table A-4 describes the columns in the Age or Gender of Newly Diagnosed Patients report
Table A-4 Age or Gender of Newly Diagnosed Patients (Report TRC-CER-005)
Table Heading | Column Heading | Measure or Dimension in Presentation Layer |
---|---|---|
NA |
% Total Patients |
TRC-CEM-017 |
NA |
Number of Diagnosed Patients |
TRC-CEM-016 |
NA |
Male |
Patient.Gender |
NA |
Female |
Patient.Gender |
0-18 |
NA |
Patient.Age |
19-35 |
NA |
Patient.Age |
36-50 |
NA |
Patient.Age |
51-65 |
NA |
Patient.Age |
66+ |
NA |
Patient.Age |
Statistics on biospecimen collected during the time period specified, default being the last 1 month. These statistics include the number of samples collected, the types of samples and their anatomical site, the number of patients corresponding to these specimen and the number of patients that consented for these specimen to be utilized.
Table A-5 describes the columns in the Biospecimen Samples Status report
Table A-5 Biospecimen Samples Status (Report TRC-CER-006)
Table Heading | Column Heading | Measure or Dimension in Presentation Layer |
---|---|---|
NA |
Anatomical Site |
Specimen.Anatomical Site Name |
NA |
Type of Specimen |
Specimen.Specimen Type Name |
NA |
Number of Specimen Collected in Facility |
TRC-CEM-018 |
NA |
Number of Patients Corresponding to Collected Specimen |
TRC-CEM-019 |
NA |
Number of Patients providing Specimen who Consented |
TRC-CEM-020 |
Count of patients satisfying selected criteria in the Patient Information section.
Count of patients satisfying selected criteria in the Patient Information, Protocol sections.
Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History sections.
Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis sections.
Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure or Treatment sections.
Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure or Treatment, Medication sections.
Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure or Treatment, Medication, Diagnostic Test sections.
Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure or Treatment, Medication, Diagnostic Test, Filter Patients with specific combinations of Medication-Procedure, Diagnostic Tests-Procedure, Diagnostic Tests-Medication, Diagnostic Tests-Specimen sections.
Count of patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure or Treatment, Medication, Diagnostic Test, Filter Patients with specific combinations of Medication-Procedure, Diagnostic Tests-Procedure, Diagnostic Tests-Medication, Diagnostic Tests-Specimen, Exclusions sections.
Final count of patients when applying all above filters. Count of patients and List Patients in Cohort link to List Patients in Cohort page where corresponding patients are displayed in a table, additionally Timelines of Patients in Cohort link navigates to Timelines of Patients in Cohort Page where the patients temporal events are displayed.
Cohort Explorer dashboard, Query Patients page
Cohort Explorer dashboard, Timelines of Patients in Cohort page
Cohort Explorer dashboard, List Patients in Cohort page
List of all filtering criteria applied when getting the final count of patients. This list can be printed or exported as text file.
Cohort Explorer dashboard, Query Patients page
Cohort Explorer dashboard, Timelines of Patients in Cohort page
Cohort Explorer dashboard, List Patients in Cohort page
Tabulated Bar Plot of Patient Events. The first table consists of selected Patient IDs only, the second table hold Patient ID, Event type, Event Name, Event Start Date, Event End Date, Ongoing, Duration (days), Event Timeline Bar Plot. Patients can be added or removed using the Patient ID selection filter on the Timelines of Patients in Cohort page. The end user can sort on any column in the result table. Additionally, the end user can click on Patient ID which links to the patient details on a separate tab. Timelines of Patients in Cohort can be printed or exported in multiple formats.
Table A-19 describes the columns in the Timelines of Patients in Cohort report
Table A-18 Timelines of Patients in Cohort (Report TRC-CER-114)
Table Heading | Column Heading | Measure or Dimension in Presentation Layer |
---|---|---|
NA |
Patient IDs Selected |
Patient.PatientID |
NA |
Patient ID |
Patient.PatientID |
NA |
Event Start Date |
union (Diagnosis.Diagnosis Reported Date, Procedure.Procedure Start Date, Specimen.Specimen Collection Date, Medication.Medication Start Date, Diagnostic Test.Test Date, Patient History.Patient History Start Date, Patient.Consent Start Date) |
NA |
Event End Date |
union (Diagnosis.Diagnosis End Date, Procedure.Procedure End Date, Specimen.Specimen Collection Date, Medication.Medication End Date, Diagnostic Test.Test Date, Patient History.Patient History End Date, Patient.Consent End Date) |
NA |
Ongoing |
TRC-CEM-031 |
NA |
Duration (days) |
TRC-CEM-032 |
NA |
Patient Event Type |
Diagnosis, Procedure, Specimen, Medication, Diagnostic Test, Patient History, Consent |
NA |
Patient Event |
union (Diagnosis.Diagnosis Name, Procedure.Procedure Name, Specimen.Specimen Type Name, Medication.Medication Name, Diagnostic Test.Diagnostic Test Name, Patient History.Patient History Name, Patient.Consent Type Name) |
NA |
Event Timeline Bar Plot |
TRC-CEM-033 |
Tabulated Bar Plot of Patient Events. The first table consists of selected Patient IDs only, the second table hold Patient ID, Event type, Event Name, Event Start Date, Event End Date, Ongoing, Duration (days), Event Timeline Bar Plot. Patients can be selected using the Patient ID selection filter on the Patient Timelines page. The end user can sort on any column in the result table. Additionally, the end user can click on Patient ID which links to the patient details on a separate tab. Patient Timelines can be printed or exported in multiple formats.
Table A-20 describes the columns in the Patient Timelines report
Table A-19 Patient Timelines (Report TRC-CER-114-2)
Table Heading | Column Heading | Measure or Dimension in Presentation Layer |
---|---|---|
NA |
Patient IDs Selected |
Patient.PatientID |
NA |
Patient ID |
Patient.PatientID |
NA |
Event Start Date |
union (Diagnosis.Diagnosis Reported Date, Procedure.Procedure Start Date, Specimen.Specimen Collection Date, Medication.Medication Start Date, Diagnostic Test.Test Date, Patient History.Patient History Start Date, Patient.Consent Start Date) |
NA |
Event End Date |
union (Diagnosis.Diagnosis End Date, Procedure.Procedure End Date, Specimen.Specimen Collection Date, Medication.Medication End Date, Diagnostic Test.Test Date, Patient History.Patient History End Date, Patient.Consent End Date) |
NA |
Ongoing |
TRC-CEM-031 |
NA |
Duration (days) |
TRC-CEM-032 |
NA |
Patient Event Type |
Diagnosis, Procedure, Specimen, Medication, Diagnostic Test, Patient History, Consent |
NA |
Patient Event |
union (Diagnosis.Diagnosis Name, Procedure.Procedure Name, Specimen.Specimen Type Name, Medication.Medication Name, Diagnostic Test.Diagnostic Test Name, Patient History.Patient History Name, Patient.Consent Type Name) |
NA |
Event Timeline Bar Plot |
TRC-CEM-033 |
Tabular list of patients corresponding to the patient cohort selected from Query Patients tab. Patients can be added or removed using the Patient ID selection filter on the List Patients in Cohort page. Two tables are displayed, first with only the selected Patient IDs, second with Patient ID, Age, Event type, and the actual event. The end user can sort on any column in the result table. Additionally, the end user can click on Patient ID which links to the patient details on a separate tab. Patient list can be printed or exported in a variety of formats.
Table A-21 describes the columns in the List Patients in Cohort report
Table A-20 List Patients in Cohort (Report TRC-CER-115)
Table Heading | Column Heading | Measure or Dimension in Presentation Layer |
---|---|---|
NA |
Patient IDs Selected |
Patient.PatientID |
NA |
Patient ID |
Patient.PatientID |
NA |
Age (Years) |
Patient.Age (in Years) |
NA |
Gender |
Patient.Gender |
NA |
Patient Event Type |
union (Diagnosis, Procedure, Specimen, Medication, Diagnostic Test, Patient History, Consent) |
NA |
Patient Event |
union (Diagnosis.Diagnosis Name, Procedure.Procedure Name, Specimen.Specimen Type Name, Medication.Medication Name, Diagnostic Test.Diagnostic Test Name, Patient History.Patient History Name, Patient.Consent Type Name) |
Tabular list of patients corresponding to the patients selected using the Patient ID selection filter on the List Patients page. Two tables are displayed, first with only the selected Patient IDs, second with Patient ID, Age, Event type, and the actual event. The end user can sort on any column in the result table. Additionally, the end user can click on Patient ID which links to the patient details on a separate tab. Patient list can be printed or exported in a variety of formats.
Table A-22 describes the columns in the List Patients report
Table A-21 List Patients (Report TRC-CER-115-2)
Table Heading | Column Heading | Measure or Dimension in Presentation Layer |
---|---|---|
NA |
Patient IDs Selected |
Patient.PatientID |
NA |
Patient ID |
Patient.PatientID |
NA |
Age (Years) |
Patient.Age (in Years) |
NA |
Gender |
Patient.Gender |
NA |
Patient Event Type |
union (Diagnosis, Procedure, Specimen, Medication, Diagnostic Test, Patient History, Consent) |
NA |
Patient Event |
union (Diagnosis.Diagnosis Name, Procedure.Procedure Name, Specimen.Specimen Type Name, Medication.Medication Name, Diagnostic Test.Diagnostic Test Name, Patient History.Patient History Name, Patient.Consent Type Name) |
List of patient attributes including demographics, address, and so on for the Patient ID. Patient ID is obtained by selecting single patient identifier from List Patients or Patient Timelines Page or via the dashboard prompt at the top of the page.
Table A-23 describes the columns in the Patient Profile report
Table A-22 Patient Profile (Report TRC-CER-116)
Table Heading | Column Heading | Measure or Dimension in Presentation Layer |
---|---|---|
Patient Profile |
Patient ID |
Patient.PatientID |
Patient Profile |
Gender |
Patient.Gender |
Patient Profile |
Marital Status |
Patient.Marital Status |
Patient Profile |
Age (in Years) |
Patient. Age (in Years) |
Patient Profile |
Birth Date |
Patient.Date of Birth |
Patient Profile |
Deceased Date |
Patient.Date Deceased |
Patient Profile |
Ethnicity |
Patient.Ethnicity Name |
Patient Profile |
Race |
Patient.Race Name |
Patient Profile |
City |
Patient.City |
Patient Profile |
Zipcode |
Patient.Zipcode |
Patient Profile |
County |
Patient.County |
Patient Profile |
State |
Patient.State |
Patient Profile |
Country |
Patient.Country |
List of consents given by the patient for the Patient ID specified.
Table A-24 describes the columns in the Consent Forms Signed report
Table A-23 Consent Forms Signed (Report TRC-CER-117)
Table Heading | Column Heading | Measure or Dimension in Presentation Layer |
---|---|---|
Consent Forms Signed |
Consent Type Name |
Patient.Consent Type Name |
Consent Forms Signed |
Consent Type Code |
Patient.Consent Type Code |
Consent Forms Signed |
Description |
Patient.ConsentType Description |
Consent Forms Signed |
Consent Status Name |
Patient.Consent Status Name |
Consent Forms Signed |
Status Code |
Patient.Consent Status Code |
Consent Forms Signed |
Start Date |
Patient.Consent Start Date |
Consent Forms Signed |
End Date |
Patient.Consent End Date |
List of protocols which patient satisfies for the Patient ID specified.
Table A-25 describes the columns in the Qualifies for Protocols report
Table A-24 Qualifies for Protocols (Report TRC-CER-118)
Table Heading | Column Heading | Measure or Dimension in Presentation Layer |
---|---|---|
Qualifies for Protocols |
Protocol Name |
Protocol.Protocol Name |
Qualifies for Protocols |
Code |
Protocol.Protocol Code |
Qualifies for Protocols |
Description |
Protocol.Protocol Description |
Patient history including any risk factors, or relevant patient events for the Patient ID specified.
Table A-26 describes the columns in the Patient History report
Table A-25 Patient History (Report TRC-CER-119)
Table Heading | Column Heading | Measure or Dimension in Presentation Layer |
---|---|---|
Patient History |
History or Risk Name |
Patient History.Patient History Name |
Patient History |
History or Risk Code |
Patient History.Patient History Code |
Patient History |
Start Date |
Patient History.Start Date |
Patient History |
End Date |
Patient History.End Date |
Patient History |
Frequency |
Patient History.Frequency |
Patient History |
Frequency Units |
Patient History.Frequency UoM |
Patient History |
Amount |
Patient History.Amount |
Patient History |
Amount Units |
Patient History.Amount UoM |
All diagnoses associated with a patient along with related history for each diagnosis for the Patient ID specified.
Table A-27 describes the columns in the Patient Diagnosis report
Table A-26 Patient Diagnosis (Report TRC-CER-120)
Table Heading | Column Heading | Measure or Dimension in Presentation Layer |
---|---|---|
Patient Diagnosis |
Diagnosis Name |
Diagnosis.Diagnosis Name |
Patient Diagnosis |
Code |
Diagnosis.Diagnosis Code |
Patient Diagnosis |
Age at First Onset (Years) |
Diagnosis.Age at First Onset |
Patient Diagnosis |
Onset Date |
Diagnosis.Onset Date |
Patient Diagnosis |
Date Reported |
Diagnosis.Reported Date |
Patient Diagnosis |
End Date |
Diagnosis.End Date |
Patient Diagnosis |
Status |
Diagnosis.Diagnosis Status Name |
Patient Diagnosis |
Anatomical Site Name |
Diagnosis.Anatomical Site Name |
Patient Diagnosis |
Anatomical Site Code |
Diagnosis.Anatomical Site Code |
All procedures or treatments a given patient has undergone or is undergoing along with relevant dates, and so on for the Patient ID specified.
Table A-28 describes the columns in the Procedures or Treatments Undergone report
Table A-27 Procedures or Treatments Undergone (Report TRC-CER-121)
Table Heading | Column Heading | Measure or Dimension in Presentation Layer |
---|---|---|
Procedures or Treatments Undergone |
Procedure Name |
Procedure.Procedure Name |
Procedures or Treatments Undergone |
Procedure Code |
Procedure.Procedure Code |
Procedures or Treatments Undergone |
Procedure Type |
Procedure.Procedure Type Name |
Procedures or Treatments Undergone |
Type Code |
Procedure.Procedure Type Code |
Procedures or Treatments Undergone |
Start Date |
Procedure.Start Date |
Procedures or Treatments Undergone |
End Date |
Procedure.End Date |
All medications that a given patient has taken or is currently taking along with related information for the Patient ID specified.
Table A-29 describes the columns in the Medications Taken report
Table A-28 Medications Taken (Report TRC-CER-122)
Table Heading | Column Heading | Measure or Dimension in Presentation Layer |
---|---|---|
Medications Taken |
Medication Name |
Medication.Medication Name |
Medications Taken |
Medication Code |
Medication.Medication Code |
Medications Taken |
Description |
Medication.Medication Description |
Medications Taken |
Start Date |
Medication.Start Date |
Medications Taken |
End Date |
Medication.End Date |
Medications Taken |
Dosage |
Medication.Dosage |
Medications Taken |
Dosage Units |
Medication.Dosage UoM |
All diagnostic tests that have been performed or are performed for a given patient for the Patient ID specified.
Table A-30 describes the columns in the Diagnostic Tests report
Table A-29 Diagnostic Tests (Report TRC-CER-123)
Table Heading | Column Heading | Measure or Dimension in Presentation Layer |
---|---|---|
Diagnostic Tests |
Test Name |
Diagnostic Test.Diagnostic Test Name |
Diagnostic Tests |
Test Code |
Diagnostic Test.Diagnostic Test Code |
Diagnostic Tests |
Test Date |
Diagnostic Test.Test Date |
Diagnostic Tests |
Result (numeric) |
Diagnostic Test.Test Result (numeric) |
Diagnostic Tests |
Units |
Diagnostic Test.Numeric Result UoM |
Diagnostic Tests |
Result (text) |
Diagnostic Test.Test Result (string) |
List of specimen collected along with related information for the Patient ID selected when navigating from List Patients or Patient Timelines Page or selected in the Patient ID prompt.
Table A-31 describes the columns in the Specimen Samples Collected report
Table A-30 Specimen Samples Collected (Report TRC-CER-124)
Table Heading | Column Heading | Measure or Dimension in Presentation Layer |
---|---|---|
Specimen Samples Collected |
Specimen Type Name |
Specimen.Specimen Name |
Specimen Samples Collected |
Specimen Type Code |
Specimen.Specimen Code |
Specimen Samples Collected |
Date Collected |
Specimen.Collection Date |
Specimen Samples Collected |
Anatomical Site Name |
Specimen.Anatomical Site Name |
Specimen Samples Collected |
Anatomical Site Code |
Specimen.Anatomical Site Code |
Specimen Samples Collected |
Amount |
Specimen.Specimen Amount |
Specimen Samples Collected |
Units |
Specimen.Specimen Amount UoM |
Table Heading |
Column Heading |
Measure or Dimension in PL Layer |
NA |
NA |
PL Layer Query to obtain TRC-CEM-030 |
Count of specimen for patients satisfying selected criteria in the Patient Information, Protocol, Patient History, Diagnosis, Procedure or Treatment, Medication, Diagnostic Test, Filter Patients with specific combinations of Medication-Procedure, Diagnostic Tests-Procedure, Diagnostic Tests-Medication, Diagnostic Tests-Specimen, Exclusions, Specimen sections. Specimen satisfy the criteria selected in Specimen tab.
OHSCE includes the following prompt sets:
Display Detailed Information for a Given Patient (Prompt Set TRC-CEP-003)
Add or Remove Patient IDs and Time Range (Prompt Set TRC-CEP-S11)
Prompt end user for time period, default being last 1 month back from today. This prompt is used to filter all reports on the Summary page.
Diagnosis.Diagnosis Start Date
Diagnosis End Date, Procedure. Procedure Start Date
Procedure. Procedure End Date
Specimen.Specimen Collection Date
Medication. Medication Start Date
Medication.Medication End Date
Consent.Consent Start Date, Consent. Consent End Date
Specimen.Anatomical Site Name
You can navigate to the following reports from this Prompt:
TRC-CER-001
TRC-CER-003
TRC-CER-004
TRC-CER-005
TRC-CER-006
Table A-32 describes the prompts in the Statistics from-to Prompt Set
Table A-32 Statistics from-to (Prompt Set TRC-CEP-001)
Prompt Page Number, Prompt Page Heading | Prompt Heading | Prompt Type or Default Value(s) Layer | Measure or Dimension in PL Layer |
---|---|---|---|
1, NA |
Statistics from to |
Text Field or FROM 1 month back from current date TO current date |
Diagnosis.Diagnosis Start Date, Diagnosis End Date, Procedure. Procedure Start Date, Procedure. Procedure End Date, Specimen.Specimen Collection Date, Medication. Medication Start Date, Medication.Medication End Date, Consent.Consent Start Date, Consent. Consent End Date |
Multiple IDs can be selected for patients. Selected patients are displayed in the table or list below. By default, selected patients are displayed when the user navigates by clicking on final patient count in Query Patients. The end user can add or remove Patient IDs using this prompt.
Table A-33 describes the prompts in the Add or Remove Patient IDs Prompt Set
Table A-33 Add or Remove Patient IDs (Prompt Set TRC-CEP-002)
Prompt Page Number, Prompt Page Heading | Prompt Heading | Prompt Type or Default Value(s) Layer | Measure or Dimension in PL Layer |
---|---|---|---|
1, NA |
Add Patient IDs |
Choice List or none |
Patient 1.Patient ID |
1, NA |
Remove Patient IDs |
Choice List or none |
Patient 2.Patient ID |
Prompt requesting the user to select one Patient ID to view data associated with a given patient. If the end user navigated from List Patients or Patient Timelines pages, Patient ID is populated automatically with the user selection.
You can navigate to the following reports from this Prompt:
TRC-CER-116
TRC-CER-117
TRC-CER-118
TRC-CER-119
TRC-CER-120
TRC-CER-121
TRC-CER-122
TRC-CER-123
TRC-CER-124
Set of prompts (filtering criteria) relevant to Patient Information such as demographics, consent, address that the end user can select to filter out a desired patient cohort satisfying these criteria.
You can navigate to the following reports from this Prompt:
TRC-CER-102
TRC-CER-103
TRC-CER-104
TRC-CER-105
TRC-CER-106
TRC-CER-108
TRC-CER-109
TRC-CER-110
TRC-CER-112
TRC-CER-113
TRC-CER-125
Table A-35 describes the prompts in the Patient Information Prompts Prompt Set
Table A-35 Patient Information Prompts (Prompt Set TRC-CEP-S01)
Prompt Page Number, Prompt Page Heading | Prompt Heading | Prompt Type or Default Value(s) Layer | Measure or Dimension in PL Layer |
---|---|---|---|
1, none |
Patient ID |
Choice List or none |
Patient.Patient ID |
1, none |
Gender |
Choice List or none |
Patient.Gender |
1, none |
Marital Status |
Choice List or none |
Patient.Marital Status |
1, none |
Age (in Years) |
Text Field or none |
Patient.Age (in Years) |
1, none |
Date of Birth |
Calendar or none |
Patient.Date of Birth |
1, none |
Deceased Date |
Calendar or none |
Patient.Date Deceased |
1, none |
Euthanasic |
Choice List or none |
Patient.Ethnicity Name |
1, none |
Race |
Choice List or none |
Patient.Race Name |
1, none |
Consent Type Code |
Choice List or none |
Consent.Consent Type Code |
1, none |
Consent Type Name |
Choice List or none |
Consent.Consent Type Name |
1, none |
Consent Status |
Choice List or none |
Consent.Consent Status Name |
1, none |
Consent Start Date |
Calendar or none |
Consent.Consent Start Date |
1, none |
Consent End Date |
Calendar or none |
Consent.Consent End Date |
2, Address |
City |
Choice List or none |
Patient.City |
2, Address |
State |
Choice List or none |
Patient.State |
2, Address |
Zipped |
Choice List or none |
Patient.Zipcode |
2, Address |
County |
Choice List or none |
Patient.County |
2, Address |
Country |
Choice List or none |
Patient.Country |
Set of prompts (filtering criteria) relevant to Protocols that the patients qualify for. The end user can select to filter out a desired patient cohort satisfying these criteria.
You can navigate to the following reports from this Prompt:
TRC-CER-103
TRC-CER-104
TRC-CER-105
TRC-CER-106
TRC-CER-108
TRC-CER-109
TRC-CER-110
TRC-CER-112
TRC-CER-113
TRC-CER-125
Table A-36 describes the prompts in the Protocol Prompts Prompt Set
Table A-36 Protocol Prompts (Prompt Set TRC-CEP-S02)
Prompt Page Number, Prompt Page Heading | Prompt Heading | Prompt Type or Default Value(s) Layer | Measure or Dimension in PL Layer |
---|---|---|---|
1, none |
Protocol Name |
Choice List or none |
Protocol.Protocol Name |
1, none |
Protocol Code |
Choice List or none |
Protocol.Protocol Code |
Set of prompts (filtering criteria) relevant to Patient History or Risk factors that the end user can select to filter out a desired patient cohort satisfying these criteria.
You can navigate to the following reports from this Prompt:
TRC-CER-104
TRC-CER-105
TRC-CER-106
TRC-CER-108
TRC-CER-109
TRC-CER-110
TRC-CER-112
TRC-CER-113
TRC-CER-125
Table A-37 describes the prompts in the Patient History Prompts Prompt Set
Table A-37 Patient History Prompts (Prompt Set TRC-CEP-S03)
Prompt Page Number, Prompt Page Heading | Prompt Heading | Prompt Type or Default Value(s) Layer | Measure or Dimension in PL Layer |
---|---|---|---|
1, History (page 1) |
History or Risk Name |
Choice List or none |
Patient History.Patient History Name |
1, History (page 1) |
History or Risk Code |
Choice List or none |
Patient History.Patient History Code |
1, History (page 1) |
Amount |
Text Field or none |
Patient History.Amount |
1, History (page 1) |
Amount Units |
Choice List or none |
Patient History.Amount UoM |
1, History (page 1) |
Start Date |
Calendar or none |
Patient History.Start Date |
1, History (page 1) |
End Date |
Calendar or none |
Patient History.End Date |
1, History (page 1) |
Frequency |
Text Field or none |
Patient History.Frequency |
1, History (page 1) |
Frequency Units |
Choice List or none |
Patient History.Frequency UoM |
2, History (page 2) |
History or Risk Name |
Choice List or none |
Patient History 1.Patient History Name 1 |
2, History (page 2) |
History or Risk Code |
Choice List or none |
Patient History 1.Patient History Code 1 |
2, History (page 2) |
Amount |
Text Field or none |
Patient History 1.Amount 1 |
2, History (page 2) |
Amount Units |
Choice List or none |
Patient History 1.Amount UoM 1 |
2, History (page 2) |
Start Date |
Calendar or none |
Patient History 1.Start Date 1 |
2, History (page 2) |
End Date |
Calendar or none |
Patient History 1.End Date 1 |
2, History (page 2) |
Frequency |
Text Field or none |
Patient History 1.Frequency 1 |
2, History (page 2) |
Frequency Units |
Choice List or none |
Patient History 1.Frequency UoM 1 |
3, History (page 3) |
History or Risk Name |
Choice List or none |
Patient History 2.Patient History Name 2 |
3, History (page 3) |
History or Risk Code |
Choice List or none |
Patient History 2.Patient History Code 2 |
3, History (page 3) |
Amount |
Text Field or none |
Patient History 2.Amount 2 |
3, History (page 3) |
Amount Units |
Choice List or none |
Patient History 2.Amount UoM 2 |
3, History (page 3) |
Start Date |
Calendar or none |
Patient History 2.Start Date 2 |
3, History (page 3) |
End Date |
Calendar or none |
Patient History 2.End Date 2 |
3, History (page 3) |
Frequency |
Text Field or none |
Patient History 2.Frequency 2 |
3, History (page 3) |
Frequency Units |
Choice List or none |
Patient History 2.Frequency UoM 2 |
Set of prompts (filtering criteria) relevant to diseases Diagnosed that the end user can select to filter out a desired patient cohort satisfying these criteria.
You can navigate to the following reports from this Prompt:
TRC-CER-105
TRC-CER-106
TRC-CER-108
TRC-CER-109
TRC-CER-110
TRC-CER-112
TRC-CER-113
TRC-CER-125
Table A-38 describes the prompts in the Diagnosis Prompts Prompt Set
Table A-38 Diagnosis Prompts (Prompt Set TRC-CEP-S04)
Prompt Page Number, Prompt Page Heading | Prompt Heading | Prompt Type or Default Value(s) Layer | Measure or Dimension in PL Layer |
---|---|---|---|
1, Diagnosis (page 1) |
Diagnosis Top Level Name |
Choice List or none |
Diagnosis.Diagnosis Level 7 Name |
1, Diagnosis (page 1) |
Level 6 Name |
Choice List or none |
Diagnosis.Diagnosis Level 6 Name |
1, Diagnosis (page 1) |
Level 5 Name |
Choice List or none |
Diagnosis.Diagnosis Level 5 Name |
1, Diagnosis (page 1) |
Level 4 Name |
Choice List or none |
Diagnosis.Diagnosis Level 4 Name |
1, Diagnosis (page 1) |
Level 3 Name |
Choice List or none |
Diagnosis.Diagnosis Level 3 Name |
1, Diagnosis (page 1) |
Level 2 Name |
Choice List or none |
Diagnosis.Diagnosis Level 2 Name |
1, Diagnosis (page 1) |
Level 1 Name |
Choice List or none |
Diagnosis.Diagnosis Level 1 Name |
1, Diagnosis (page 1) |
Diagnosis Name |
Choice List or none |
Diagnosis.Diagnosis Name |
1, Diagnosis (page 1) |
Anatomical Site Top Level Name |
Choice List or none |
Diagnosis.Anatomical Site Level 5 Name |
1, Diagnosis (page 1) |
Anatomical Site Level 4 Name |
Choice List or none |
Diagnosis.Anatomical Site Level 4 Name |
1, Diagnosis (page 1) |
Anatomical Site Level 3 Name |
Choice List or none |
Diagnosis.Anatomical Site Level 3 Name |
1, Diagnosis (page 1) |
Anatomical Site Level 2 Name |
Choice List or none |
Diagnosis.Anatomical Site Level 2 Name |
1, Diagnosis (page 1) |
Anatomical Site Level 1 Name |
Choice List or none |
Diagnosis.Anatomical Site Level 1 Name |
1, Diagnosis (page 1) |
Anatomical Site Name |
Choice List or none |
Diagnosis.Anatomical Site Name |
1, Diagnosis (page 1) |
Status |
Choice List or none |
Diagnosis.Diagnosis Status Name |
1, Diagnosis (page 1) |
Age at First Onset (in Years) |
Text Field or none |
Diagnosis.Age at First Onset (in Years) |
1, Diagnosis (page 1) |
Onset Date |
Calendar or none |
Diagnosis.Onset Date |
1, Diagnosis (page 1) |
Date Reported |
Calendar or none |
Diagnosis.Reported Date |
1, Diagnosis (page 1) |
End Date |
Calendar or none |
Diagnosis.End Date |
1, Diagnosis (page 1) |
Diagnosis Top Level Code |
Choice List or none |
Diagnosis.Diagnosis Level 7 Code |
1, Diagnosis (page 1) |
Level 6 Code |
Choice List or none |
Diagnosis.Diagnosis Level 6 Code |
1, Diagnosis (page 1) |
Level 5 Code |
Choice List or none |
Diagnosis.Diagnosis Level 5 Code |
1, Diagnosis (page 1) |
Level 4 Code |
Choice List or none |
Diagnosis.Diagnosis Level 4 Code |
1, Diagnosis (page 1) |
Level 3 Code |
Choice List or none |
Diagnosis.Diagnosis Level 3 Code |
1, Diagnosis (page 1) |
Level 2 Code |
Choice List or none |
Diagnosis.Diagnosis Level 2 Code |
1, Diagnosis (page 1) |
Level 1 Code |
Choice List or none |
Diagnosis.Diagnosis Level 1 Code |
1, Diagnosis (page 1) |
Diagnosis Code |
Choice List or none |
Diagnosis.Diagnosis Code |
1, Diagnosis (page 1) |
Anatomical Site Top Level Code |
Choice List or none |
Diagnosis.Anatomical Site Level 5 Code |
1, Diagnosis (page 1) |
Anatomical Site Level 4 Code |
Choice List or none |
Diagnosis.Anatomical Site Level 4 Code |
1, Diagnosis (page 1) |
Anatomical Site Level 3 Code |
Choice List or none |
Diagnosis.Anatomical Site Level 3 Code |
1, Diagnosis (page 1) |
Anatomical Site Level 2 Code |
Choice List or none |
Diagnosis.Anatomical Site Level 2 Code |
1, Diagnosis (page 1) |
Anatomical Site Level 1 Code |
Choice List or none |
Diagnosis.Anatomical Site Level 1 Code |
1, Diagnosis (page 1) |
Anatomical Site Code |
Choice List or none |
Diagnosis.Anatomical Site Code |
2, Diagnosis (page 2) |
Diagnosis Top Level Name |
Choice List or none |
Diagnosis 1.Diagnosis Level 7 Name |
2, Diagnosis (page 2) |
Level 6 Name |
Choice List or none |
Diagnosis 1.Diagnosis Level 6 Name |
2, Diagnosis (page 2) |
Level 5 Name |
Choice List or none |
Diagnosis 1.Diagnosis Level 5 Name |
2, Diagnosis (page 2) |
Level 4 Name |
Choice List or none |
Diagnosis 1.Diagnosis Level 4 Name |
2, Diagnosis (page 2) |
Level 3 Name |
Choice List or none |
Diagnosis 1.Diagnosis Level 3 Name |
2, Diagnosis (page 2) |
Level 2 Name |
Choice List or none |
Diagnosis 1.Diagnosis Level 2 Name |
2, Diagnosis (page 2) |
Level 1 Name |
Choice List or none |
Diagnosis 1.Diagnosis Level 1 Name |
2, Diagnosis (page 2) |
Diagnosis Name |
Choice List or none |
Diagnosis 1.Diagnosis Name 1 |
2, Diagnosis (page 2) |
Anatomical Site Top Level Name |
Choice List or none |
Diagnosis 1.Anatomical Site Level 5 Name |
2, Diagnosis (page 2) |
Anatomical Site Level 4 Name |
Choice List or none |
Diagnosis 1.Anatomical Site Level 4 Name |
2, Diagnosis (page 2) |
Anatomical Site Level 3 Name |
Choice List or none |
Diagnosis 1.Anatomical Site Level 3 Name |
2, Diagnosis (page 2) |
Anatomical Site Level 2 Name |
Choice List or none |
Diagnosis 1.Anatomical Site Level 2 Name |
2, Diagnosis (page 2) |
Anatomical Site Level 1 Name |
Choice List or none |
Diagnosis 1.Anatomical Site Level 1 Name |
2, Diagnosis (page 2) |
Anatomical Site Name |
Choice List or none |
Diagnosis 1.Anatomical Site Name 1 |
2, Diagnosis (page 2) |
Status |
Choice List or none |
Diagnosis 1.Diagnosis Status Name 1 |
2, Diagnosis (page 2) |
Age at First Onset (in Years) |
Text Field or none |
Diagnosis 1.Age at First Onset 1 (in Years) |
2, Diagnosis (page 2) |
Onset Date |
Calendar or none |
Diagnosis 1.Onset Date 1 |
2, Diagnosis (page 2) |
Date Reported |
Calendar or none |
Diagnosis 1.Reported Date 1 |
2, Diagnosis (page 2) |
End Date |
Calendar or none |
Diagnosis 1.End Date 1 |
2, Diagnosis (page 2) |
Diagnosis Top Level Code |
Choice List or none |
Diagnosis 1.Diagnosis Level 7 Code |
2, Diagnosis (page 2) |
Level 6 Code |
Choice List or none |
Diagnosis 1.Diagnosis Level 6 Code |
2, Diagnosis (page 2) |
Level 5 Code |
Choice List or none |
Diagnosis 1.Diagnosis Level 5 Code |
2, Diagnosis (page 2) |
Level 4 Code |
Choice List or none |
Diagnosis 1.Diagnosis Level 4 Code |
2, Diagnosis (page 2) |
Level 3 Code |
Choice List or none |
Diagnosis 1.Diagnosis Level 3 Code |
2, Diagnosis (page 2) |
Level 2 Code |
Choice List or none |
Diagnosis 1.Diagnosis Level 2 Code |
2, Diagnosis (page 2) |
Level 1 Code |
Choice List or none |
Diagnosis 1.Diagnosis Level 1 Code |
2, Diagnosis (page 2) |
Diagnosis Code |
Choice List or none |
Diagnosis 1.Diagnosis Code 1 |
2, Diagnosis (page 2) |
Anatomical Site Top Level Code |
Choice List or none |
Diagnosis 1.Anatomical Site Level 5 Code |
2, Diagnosis (page 2) |
Anatomical Site Level 4 Code |
Choice List or none |
Diagnosis 1.Anatomical Site Level 4 Code |
2, Diagnosis (page 2) |
Anatomical Site Level 3 Code |
Choice List or none |
Diagnosis 1.Anatomical Site Level 3 Code |
2, Diagnosis (page 2) |
Anatomical Site Level 2 Code |
Choice List or none |
Diagnosis 1.Anatomical Site Level 2 Code |
2, Diagnosis (page 2) |
Anatomical Site Level 1 Code |
Choice List or none |
Diagnosis 1.Anatomical Site Level 1 Code |
2, Diagnosis (page 2) |
Anatomical Site Code |
Choice List or none |
Diagnosis 1.Anatomical Site Code 1 |
3, Diagnosis (page 3) |
Diagnosis Top Level Name |
Choice List or none |
Diagnosis 2.Diagnosis Level 7 Name |
3, Diagnosis (page 3) |
Level 6 Name |
Choice List or none |
Diagnosis 2.Diagnosis Level 6 Name |
3, Diagnosis (page 3) |
Level 5 Name |
Choice List or none |
Diagnosis 2.Diagnosis Level 5 Name |
3, Diagnosis (page 3) |
Level 4 Name |
Choice List or none |
Diagnosis 2.Diagnosis Level 4 Name |
3, Diagnosis (page 3) |
Level 3 Name |
Choice List or none |
Diagnosis 2.Diagnosis Level 3 Name |
3, Diagnosis (page 3) |
Level 2 Name |
Choice List or none |
Diagnosis 2.Diagnosis Level 2 Name |
3, Diagnosis (page 3) |
Level 1 Name |
Choice List or none |
Diagnosis 2.Diagnosis Level 1 Name |
3, Diagnosis (page 3) |
Diagnosis Name |
Choice List or none |
Diagnosis 2.Diagnosis Name 2 |
3, Diagnosis (page 3) |
Anatomical Site Top Level Name |
Choice List or none |
Diagnosis 2.Anatomical Site Level 5 Name |
3, Diagnosis (page 3) |
Anatomical Site Level 4 Name |
Choice List or none |
Diagnosis 2.Anatomical Site Level 4 Name |
3, Diagnosis (page 3) |
Anatomical Site Level 3 Name |
Choice List or none |
Diagnosis 2.Anatomical Site Level 3 Name |
3, Diagnosis (page 3) |
Anatomical Site Level 2 Name |
Choice List or none |
Diagnosis 2.Anatomical Site Level 2 Name |
3, Diagnosis (page 3) |
Anatomical Site Level 1 Name |
Choice List or none |
Diagnosis 2.Anatomical Site Level 1 Name |
3, Diagnosis (page 3) |
Anatomical Site Name |
Choice List or none |
Diagnosis 2.Anatomical Site Name 2 |
3, Diagnosis (page 3) |
Status |
Choice List or none |
Diagnosis 2.Diagnosis Status Name 2 |
3, Diagnosis (page 3) |
Age at First Onset (in Years) |
Text Field or none |
Diagnosis 2.Age at First Onset 2 (in Years) |
3, Diagnosis (page 3) |
Onset Date |
Calendar or none |
Diagnosis 2.Onset Date 2 |
3, Diagnosis (page 3) |
Date Reported |
Calendar or none |
Diagnosis 2.Reported Date 2 |
3, Diagnosis (page 3) |
End Date |
Calendar or none |
Diagnosis 2.End Date 2 |
3, Diagnosis (page 3) |
Diagnosis Top Level Code |
Choice List or none |
Diagnosis 2.Diagnosis Level 7 Code |
3, Diagnosis (page 3) |
Level 6 Code |
Choice List or none |
Diagnosis 2.Diagnosis Level 6 Code |
3, Diagnosis (page 3) |
Level 5 Code |
Choice List or none |
Diagnosis 2.Diagnosis Level 5 Code |
3, Diagnosis (page 3) |
Level 4 Code |
Choice List or none |
Diagnosis 2.Diagnosis Level 4 Code |
3, Diagnosis (page 3) |
Level 3 Code |
Choice List or none |
Diagnosis 2.Diagnosis Level 3 Code |
3, Diagnosis (page 3) |
Level 2 Code |
Choice List or none |
Diagnosis 2.Diagnosis Level 2 Code |
3, Diagnosis (page 3) |
Level 1 Code |
Choice List or none |
Diagnosis 2.Diagnosis Level 1 Code |
3, Diagnosis (page 3) |
Diagnosis Code |
Choice List or none |
Diagnosis 2.Diagnosis Code 2 |
3, Diagnosis (page 3) |
Anatomical Site Top Level Code |
Choice List or none |
Diagnosis 2.Anatomical Site Level 5 Code |
3, Diagnosis (page 3) |
Anatomical Site Level 4 Code |
Choice List or none |
Diagnosis 2.Anatomical Site Level 4 Code |
3, Diagnosis (page 3) |
Anatomical Site Level 3 Code |
Choice List or none |
Diagnosis 2.Anatomical Site Level 3 Code |
3, Diagnosis (page 3) |
Anatomical Site Level 2 Code |
Choice List or none |
Diagnosis 2.Anatomical Site Level 2 Code |
3, Diagnosis (page 3) |
Anatomical Site Level 1 Code |
Choice List or none |
Diagnosis 2.Anatomical Site Level 1 Code |
3, Diagnosis (page 3) |
Anatomical Site Code |
Choice List or none |
Diagnosis 2.Anatomical Site Code 2 |
Set of prompts (filtering criteria) relevant to Procedures or Treatments performed on patients that the end user can select to filter out a desired patient cohort satisfying these criteria.
You can navigate to the following reports from this Prompt:
TRC-CER-106
TRC-CER-108
TRC-CER-109
TRC-CER-110
TRC-CER-112
TRC-CER-113
TRC-CER-125
Table A-39 describes the prompts in the Procedure Prompts Prompt Set
Table A-39 Procedure Prompts (Prompt Set TRC-CEP-S05)
Prompt Page Number, Prompt Page Heading | Prompt Heading | Prompt Type or Default Value(s) Layer | Measure or Dimension in PL Layer |
---|---|---|---|
1, Procedure (page 1) |
Procedure Name |
Choice List or none |
Procedure.Procedure Name |
1, Procedure (page 1) |
Code |
Choice List or none |
Procedure.Procedure Code |
1, Procedure (page 1) |
Type |
Choice List or none |
Procedure.Procedure Type Name |
1, Procedure (page 1) |
Start Date |
Calendar or none |
Procedure.Start Date |
1, Procedure (page 1) |
End Date |
Calendar or none |
Procedure.End Date |
2, Procedure (page 2) |
Procedure Name |
Choice List or none |
Procedure 1.Procedure Name 1 |
2, Procedure (page 2) |
Code |
Choice List or none |
Procedure 1.Procedure Code 1 |
2, Procedure (page 2) |
Type |
Choice List or none |
Procedure 1.Procedure Type Name 1 |
2, Procedure (page 2) |
Start Date |
Calendar or none |
Procedure 1.Start Date 1 |
2, Procedure (page 2) |
End Date |
Calendar or none |
Procedure 1.End Date 1 |
3, Procedure (page 3) |
Procedure Name |
Choice List or none |
Procedure 2.Procedure Name 2 |
3, Procedure (page 3) |
Code |
Choice List or none |
Procedure 2.Procedure Code 2 |
3, Procedure (page 3) |
Type |
Choice List or none |
Procedure 2.Procedure Type Name 2 |
3, Procedure (page 3) |
Start Date |
Calendar or none |
Procedure 2.Start Date 2 |
3, Procedure (page 3) |
End Date |
Calendar or none |
Procedure 2.End Date 2 |
Set of prompts (filtering criteria) relevant to Medications taken that the end user can select to filter out a desired patient cohort satisfying these criteria.
You can navigate to the following reports from this Prompt:
TRC-CER-108
TRC-CER-109
TRC-CER-110
TRC-CER-112
TRC-CER-113
TRC-CER-125
Table A-40 describes the prompts in the Medication Prompts Prompt Set
Table A-40 Medication Prompts (Prompt Set TRC-CEP-S06)
Prompt Page Number, Prompt Page Heading | Prompt Heading | Prompt Type or Default Value(s) Layer | Measure or Dimension in PL Layer |
---|---|---|---|
1, Medication (page 1) |
Medication Name |
Choice List or none |
Medication.Medication Name |
1, Medication (page 1) |
Code |
Choice List or none |
Medication.Medication Code |
1, Medication (page 1) |
Dosage |
Text Field or none |
Medication.Dosage |
1, Medication (page 1) |
Dosage Units |
Choice List or none |
Medication.Dosage UoM |
1, Medication (page 1) |
Start Date |
Calendar or none |
Medication.Start Date |
1, Medication (page 1) |
End Date |
Calendar or none |
Medication.End Date |
2, Medication (page 2) |
Medication Name |
Choice List or none |
Medication 1.Medication Name 1 |
2, Medication (page 2) |
Code |
Choice List or none |
Medication 1.Medication Code 1 |
2, Medication (page 2) |
Dosage |
Text Field or none |
Medication 1.Dosage 1 |
2, Medication (page 2) |
Dosage Units |
Choice List or none |
Medication 1.Dosage UoM 1 |
2, Medication (page 2) |
Start Date |
Calendar or none |
Medication 1.Start Date 1 |
2, Medication (page 2) |
End Date |
Calendar or none |
Medication 1.End Date 1 |
3, Medication (page 3) |
Medication Name |
Choice List or none |
Medication 2.Medication Name 2 |
3, Medication (page 3) |
Code |
Choice List or none |
Medication 2.Medication Code 2 |
3, Medication (page 3) |
Dosage |
Text Field or none |
Medication 2.Dosage 2 |
3, Medication (page 3) |
Dosage Units |
Choice List or none |
Medication 2.Dosage UoM 2 |
3, Medication (page 3) |
Start Date |
Calendar or none |
Medication 2.Start Date 2 |
3, Medication (page 3) |
End Date |
Calendar or none |
Medication 2.End Date 2 |
Set of prompts (filtering criteria) relevant to Diagnostic Tests performed on a patient that the end user can select to filter out a desired patient cohort satisfying these criteria.
You can navigate to the following reports from this Prompt:
TRC-CER-108
TRC-CER-109
TRC-CER-110
TRC-CER-112
TRC-CER-113
TRC-CER-125
Table A-41 describes the prompts in the Diagnostic Test Prompts Prompt Set
Table A-41 Diagnostic Test Prompts (Prompt Set TRC-CEP-S07)
Prompt Page Number, Prompt Page Heading | Prompt Heading | Prompt Type or Default Value(s) Layer | Measure or Dimension in PL Layer |
---|---|---|---|
1, Test (page 1) |
Test Name |
Choice List or none |
Diagnostic Test.Diagnostic Test Name |
1, Test (page 1) |
Test Code |
Choice List or none |
Diagnostic Test.Diagnostic Test Code |
1, Test (page 1) |
Test Date |
Calendar or none |
Diagnostic Test.Test Date |
1, Test (page 1) |
Result (numeric) |
Text Field or none |
Diagnostic Test.Test Result (numeric) |
1, Test (page 1) |
Result (numeric) Units |
Choice List or none |
Diagnostic Test.Numeric Result UoM |
1, Test (page 1) |
Result (text) |
Choice List or none |
Diagnostic Test.Test Result (string) |
2, Test (page 2) |
Test Name |
Choice List or none |
Diagnostic Test 1.Diagnostic Test Name 1 |
2, Test (page 2) |
Test Code |
Choice List or none |
Diagnostic Test 1.Diagnostic Test Code 1 |
2, Test (page 2) |
Test Date |
Calendar or none |
Diagnostic Test 1.Test Date 1 |
2, Test (page 2) |
Result (numeric) |
Text Field or none |
Diagnostic Test 1.Test Result (numeric) 1 |
2, Test (page 2) |
Result (numeric) Units |
Choice List or none |
Diagnostic Test 1.Numeric Result UoM 1 |
2, Test (page 2) |
Result (text) |
Choice List or none |
Diagnostic Test 1.Test Result (string) 1 |
3, Test (page 3) |
Test Name |
Choice List or none |
Diagnostic Test 2.Diagnostic Test Name 2 |
3, Test (page 3) |
Test Code |
Choice List or none |
Diagnostic Test 2.Diagnostic Test Code 2 |
3, Test (page 3) |
Test Date |
Calendar or none |
Diagnostic Test 2.Test Date 2 |
3, Test (page 3) |
Result (numeric) |
Text Field or none |
Diagnostic Test 2.Test Result (numeric) 2 |
3, Test (page 3) |
Result (numeric) Units |
Choice List or none |
Diagnostic Test 2.Numeric Result UoM 2 |
3, Test (page 3) |
Result (text) |
Choice List or none |
Diagnostic Test 2.Test Result (string) 2 |
Set of prompts (filtering criteria) relevant to Combinations of procedures-medications and other related patient event pairs that the end user can select to filter out a desired patient cohort satisfying these criteria.
Procedure - Medication
Diagnostic Test - Procedure
Diagnostic Test - Medication
Diagnostic Test - Specimen
You can navigate to the following reports from this Prompt:
TRC-CER-109
TRC-CER-110
TRC-CER-112
TRC-CER-113
TRC-CER-125
Table A-42 describes the prompts in the Filter Patients with specific combinations of Medication-Procedure, Diagnostic Tests-Procedure, Diagnostic Tests-Medication, Diagnostic Tests-Specimen Prompt Set
Table A-42 Filter Patients with Specific Combinations of Medication-Procedure, Diagnostic Tests-Procedure, Diagnostic Tests-Medication, Diagnostic Tests-Specimen Prompts (Prompt Set TRC-CEP-S08)
Prompt Page Number, Prompt Page Heading | Prompt Heading | Prompt Type or Default Value(s) Layer | Measure or Dimension in PL Layer |
---|---|---|---|
1, Medications taken with relation to specific Treatment or Procedure |
Procedure Name |
Choice List or none |
Procedure - Medication.Procedure Name |
1, Medications taken with relation to specific Treatment or Procedure |
Procedure Code |
Choice List or none |
Procedure - Medication.Procedure Code |
1, Medications taken with relation to specific Treatment or Procedure |
Medication Name |
Choice List or none |
Procedure - Medication.Medication Name |
1, Medications taken with relation to specific Treatment or Procedure |
Medication Code |
Choice List or none |
Procedure - Medication.Medication Code |
2, Diagnostic Tests performed in relation to specific Treatment or Procedure |
Procedure Name |
Choice List or none |
Diagnostic Test - Procedure.Procedure Name |
2, Diagnostic Tests performed in relation to specific Treatment or Procedure |
Procedure Code |
Choice List or none |
Diagnostic Test - Procedure.Procedure Code |
2, Diagnostic Tests performed in relation to specific Treatment or Procedure |
Diagnostic Test Name |
Choice List or none |
Diagnostic Test - Procedure.Diagnostic Test Name |
2, Diagnostic Tests performed in relation to specific Treatment or Procedure |
Diagnostic Test Code |
Choice List or none |
Diagnostic Test - Procedure.Diagnostic Test Code |
2, Diagnostic Tests performed in relation to specific Treatment or Procedure |
Test Result (numeric) |
Text Field or none |
Diagnostic Test - Procedure.Test Result (numeric) |
2, Diagnostic Tests performed in relation to specific Treatment or Procedure |
Result (numeric) Units |
Choice List or none |
Diagnostic Test - Procedure.Numeric Result UoM |
2, Diagnostic Tests performed in relation to specific Treatment or Procedure |
Test Result (text) |
Choice List or none |
Diagnostic Test - Procedure.Test Result (string) |
3, Diagnostic Tests performed in relation to administering specific Medication |
Diagnostic Test Name |
Choice List or none |
Diagnostic Test - Medication.Diagnostic Test Name |
3, Diagnostic Tests performed in relation to administering specific Medication |
Diagnostic Test Code |
Choice List or none |
Diagnostic Test - Medication.Diagnostic Test Code |
3, Diagnostic Tests performed in relation to administering specific Medication |
Medication Name |
Choice List or none |
Diagnostic Test - Medication.Medication Name |
3, Diagnostic Tests performed in relation to administering specific Medication |
Medication Code |
Choice List or none |
Diagnostic Test - Medication.Medication Code |
4, Specimen collected as part of Diagnostic Test |
Diagnostic Test Name |
Choice List or none |
Diagnostic Test - Specimen.Diagnostic Test Name |
4, Specimen collected as part of Diagnostic Test |
Diagnostic Test Code |
Choice List or none |
Diagnostic Test - Specimen.Diagnostic Test Code |
4, Specimen collected as part of Diagnostic Test |
Specimen Name |
Choice List or none |
Diagnostic Test - Specimen.Specimen Name |
4, Specimen collected as part of Diagnostic Test |
Specimen Code |
Choice List or none |
Diagnostic Test - Specimen.Specimen Code |
Set of prompts (filtering criteria) for Excluding Patients that have any of the criteria specified. Note that each page within Exclusion criteria specifies additional group of patients that are to be excluded from the cohort.
You can navigate to the following reports from this Prompt:
TRC-CER-110
TRC-CER-112
TRC-CER-113
TRC-CER-125
Table A-43 describes the prompts in the Exclusion Criteria Prompts Prompt Set
Table A-43 Exclusion Criteria Prompts (Prompt Set TRC-CEP-S09)
Prompt Page Number, Prompt Page Heading | Prompt Heading | Prompt Type or Default Value(s) Layer | Measure or Dimension in PL Layer |
---|---|---|---|
1, Patient Information (page 1) |
Gender |
Choice List or Not Applicable |
Patient 1.Gender |
1, Patient Information (page 1) |
Marital Status |
Choice List or Not Applicable |
Patient 1.Marital Status |
1, Patient Information (page 1) |
Age (in Years) |
Text Field or none |
Patient 1.Age (in Years) |
1, Patient Information (page 1) |
Euthanasic |
Choice List or Not Applicable |
Patient 1.Ethnicity Name |
1, Patient Information (page 1) |
Race |
Choice List or Not Applicable |
Patient 1.Race Name |
1, Patient Information (page 1) |
Protocol |
Choice List or Not Applicable |
Protocol 3.Protocol Name 3 |
2, History or Risks (page 2) |
History or Risk |
Choice List or Not Applicable |
Patient History 3.Patient History Name 3 |
2, History or Risks (page 2) |
Start Date |
Calendar or none |
Patient History 3.Start Date 3 |
2, History or Risks (page 2) |
End Date |
Calendar or none |
Patient History 3.End Date 3 |
2, History or Risks (page 2) |
Amount |
Text Field or none |
Patient History 3.Amount 3 |
2, History or Risks (page 2) |
Amount Units |
Choice List or none |
Patient History 3.Amount UoM 3 |
2, History or Risks (page 2) |
Frequency |
Text Field or none |
Patient History 3.Frequency 3 |
2, History or Risks (page 2) |
Frequency Units |
Choice List or none |
Patient History 3.Frequency UoM 3 |
3, Diagnosis (page 3) |
Diagnosis Top Level Name |
Choice List or none |
Diagnosis 3.Diagnosis Level 7 Name |
3, Diagnosis (page 3) |
Level 6 Name |
Choice List or none |
Diagnosis 3.Diagnosis Level 6 Name |
3, Diagnosis (page 3) |
Level 5 Name |
Choice List or none |
Diagnosis 3.Diagnosis Level 5 Name |
3, Diagnosis (page 3) |
Level 4 Name |
Choice List or none |
Diagnosis 3.Diagnosis Level 4 Name |
3, Diagnosis (page 3) |
Level 3 Name |
Choice List or none |
Diagnosis 3.Diagnosis Level 3 Name |
3, Diagnosis (page 3) |
Level 2 Name |
Choice List or none |
Diagnosis 3.Diagnosis Level 2 Name |
3, Diagnosis (page 3) |
Level 1 Name |
Choice List or none |
Diagnosis 3.Diagnosis Level 1 Name |
3, Diagnosis (page 3) |
Diagnosis Name |
Choice List or Not Applicable |
Diagnosis 3.Diagnosis Name 3 |
3, Diagnosis (page 3) |
Diagnosis Reported |
Calendar or none |
Diagnosis 3.Reported Date 3 |
3, Diagnosis (page 3) |
Diagnosis Ended (in remission) |
Calendar or none |
Diagnosis 3.End Date 3 |
3, Diagnosis (page 3) |
Diagnosis Top Level Code |
Choice List or none |
Diagnosis 3.Diagnosis Level 7 Code |
3, Diagnosis (page 3) |
Level 6 Code |
Choice List or none |
Diagnosis 3.Diagnosis Level 6 Code |
3, Diagnosis (page 3) |
Level 5 Code |
Choice List or none |
Diagnosis 3.Diagnosis Level 5 Code |
3, Diagnosis (page 3) |
Level 4 Code |
Choice List or none |
Diagnosis 3.Diagnosis Level 4 Code |
3, Diagnosis (page 3) |
Level 3 Code |
Choice List or none |
Diagnosis 3.Diagnosis Level 3 Code |
3, Diagnosis (page 3) |
Level 2 Code |
Choice List or none |
Diagnosis 3.Diagnosis Level 2 Code |
3, Diagnosis (page 3) |
Level 1 Code |
Choice List or none |
Diagnosis 3.Diagnosis Level 1 Code |
3, Diagnosis (page 3) |
Diagnosis Code |
Choice List or Not Applicable |
Diagnosis 3.Diagnosis Code 3 |
3, Diagnosis (page 3) |
Status |
Choice List or Not Applicable |
Diagnosis 3.Diagnosis Status Name 3 |
4, Diagnostic Test (page 4) |
Test Name |
Choice List or Not Applicable |
Diagnostic Test 3.Diagnostic Test Name 3 |
4, Diagnostic Test (page 4) |
Test Code |
Choice List or Not Applicable |
Diagnostic Test 3.Diagnostic Test Code 3 |
4, Diagnostic Test (page 4) |
Test Date |
Calendar or none |
Diagnostic Test 3.Test Date 3 |
4, Diagnostic Test (page 4) |
Result (numeric) |
Text Field or none |
Diagnostic Test 3.Test Result (numeric) 3 |
4, Diagnostic Test (page 4) |
Result (numeric) Units |
Choice List or none |
Diagnostic Test 3.Numeric Result UoM 3 |
4, Diagnostic Test (page 4) |
Result (text) |
Choice List or Not Applicable |
Diagnostic Test 3.Test Result (string) 3 |
5, Procedure or Treatment (page 5) |
Procedure Name |
Choice List or Not Applicable |
Procedure 3.Procedure Name 3 |
5, Procedure or Treatment (page 5) |
Procedure Code |
Choice List or Not Applicable |
Procedure 3.Procedure Code 3 |
5, Procedure or Treatment (page 5) |
Procedure Type |
Choice List or Not Applicable |
Procedure 3.Procedure Type Name 3 |
5, Procedure or Treatment (page 5) |
Procedure Started |
Calendar or none |
Procedure 3.Start Date 3 |
5, Procedure or Treatment (page 5) |
Ended |
Calendar or none |
Procedure 3.End Date 3 |
6, Medication (page 6) |
Medication Name |
Choice List or Not Applicable |
Medication 3.Medication Name 3 |
6, Medication (page 6) |
Medication Code |
Choice List or Not Applicable |
Medication 3.Medication Code 3 |
6, Medication (page 6) |
Medication Started |
Calendar or none |
Medication 3.Start Date 3 |
6, Medication (page 6) |
Medication Ended |
Calendar or none |
Medication 3.End Date 3 |
Set of prompts (filtering criteria) relevant to specimen collected that the end user can select to filter out a desired patient cohort satisfying these criteria as well as a count of specimen corresponding to this patient cohort and the selected criteria.
You can navigate to the following reports from this Prompt:
TRC-CER-112
TRC-CER-113
TRC-CER-125
Table A-44 describes the prompts in the Specimen Prompts Prompt Set
Table A-44 Specimen Prompts (Prompt Set TRC-CEP-S10)
Prompt Page Number, Prompt Page Heading | Prompt Heading | Prompt Type or Default Value(s) Layer | Measure or Dimension in PL Layer |
---|---|---|---|
1, Specimen (page 1) |
Specimen Type Name |
Choice List or none |
Specimen.Specimen Name |
1, Specimen (page 1) |
Anatomical Site Top Level Name |
Choice List or none |
Specimen.Anatomical Site Level 5 Name |
1, Specimen (page 1) |
Anatomical Site Level 4 Name |
Choice List or none |
Specimen.Anatomical Site Level 4 Name |
1, Specimen (page 1) |
Anatomical Site Level 3 Name |
Choice List or none |
Specimen.Anatomical Site Level 3 Name |
1, Specimen (page 1) |
Anatomical Site Level 2 Name |
Choice List or none |
Specimen.Anatomical Site Level 2 Name |
1, Specimen (page 1) |
Anatomical Site Level 1 Name |
Choice List or none |
Specimen.Anatomical Site Level 1 Name |
1, Specimen (page 1) |
Anatomical Site Name |
Choice List or none |
Specimen.Anatomical Site Name |
1, Specimen (page 1) |
Date Collected |
Calendar or none |
Specimen.Collection Date |
1, Specimen (page 1) |
Amount |
Text Field or none |
Specimen.Specimen Amount |
1, Specimen (page 1) |
Units |
Choice List or none |
Specimen.Specimen Amount UoM |
1, Specimen (page 1) |
Specimen Type Code |
Choice List or none |
Specimen.Specimen Code |
1, Specimen (page 1) |
Anatomical Site Top Level Code |
Choice List or none |
Specimen.Anatomical Site Level 5 Code |
1, Specimen (page 1) |
Anatomical Site Level 4 Code |
Choice List or none |
Specimen.Anatomical Site Level 4 Code |
1, Specimen (page 1) |
Anatomical Site Level 3 Code |
Choice List or none |
Specimen.Anatomical Site Level 3 Code |
1, Specimen (page 1) |
Anatomical Site Level 2 Code |
Choice List or none |
Specimen.Anatomical Site Level 2 Code |
1, Specimen (page 1) |
Anatomical Site Level 1 Code |
Choice List or none |
Specimen.Anatomical Site Level 1 Code |
1, Specimen (page 1) |
Anatomical Site Code |
Choice List or none |
Specimen.Anatomical Site Code |
2, Specimen (page 2) |
Specimen Type Name |
Choice List or none |
Specimen 1.Specimen Name 1 |
2, Specimen (page 2) |
Anatomical Site Top Level Name |
Choice List or none |
Specimen 1.Anatomical Site Level 5 Name |
2, Specimen (page 2) |
Anatomical Site Level 4 Name |
Choice List or none |
Specimen 1.Anatomical Site Level 4 Name |
2, Specimen (page 2) |
Anatomical Site Level 3 Name |
Choice List or none |
Specimen 1.Anatomical Site Level 3 Name |
2, Specimen (page 2) |
Anatomical Site Level 2 Name |
Choice List or none |
Specimen 1.Anatomical Site Level 2 Name |
2, Specimen (page 2) |
Anatomical Site Level 1 Name |
Choice List or none |
Specimen 1.Anatomical Site Level 1 Name |
2, Specimen (page 2) |
Anatomical Site Name |
Choice List or none |
Specimen 1.Anatomical Site Name 1 |
2, Specimen (page 2) |
Date Collected |
Calendar or none |
Specimen 1.Collection Date 1 |
2, Specimen (page 2) |
Amount |
Text Field or none |
Specimen 1.Specimen Amount 1 |
2, Specimen (page 2) |
Units |
Choice List or none |
Specimen 1.Specimen Amount UoM 1 |
2, Specimen (page 2) |
Specimen Type Code |
Choice List or none |
Specimen 1.Specimen Code 1 |
2, Specimen (page 2) |
Anatomical Site Top Level Code |
Choice List or none |
Specimen 1.Anatomical Site Level 5 Code |
2, Specimen (page 2) |
Anatomical Site Level 4 Code |
Choice List or none |
Specimen 1.Anatomical Site Level 4 Code |
2, Specimen (page 2) |
Anatomical Site Level 3 Code |
Choice List or none |
Specimen 1.Anatomical Site Level 3 Code |
2, Specimen (page 2) |
Anatomical Site Level 2 Code |
Choice List or none |
Specimen 1.Anatomical Site Level 2 Code |
2, Specimen (page 2) |
Anatomical Site Level 1 Code |
Choice List or none |
Specimen 1.Anatomical Site Level 1 Code |
2, Specimen (page 2) |
Anatomical Site Code |
Choice List or none |
Specimen 1.Anatomical Site Code 1 |
3, Specimen (page 3) |
Specimen Type Name |
Choice List or none |
Specimen 2.Specimen Name 2 |
3, Specimen (page 3) |
Anatomical Site Top Level Name |
Choice List or none |
Specimen 2.Anatomical Site Level 5 Name |
3, Specimen (page 3) |
Anatomical Site Level 4 Name |
Choice List or none |
Specimen 2.Anatomical Site Level 4 Name |
3, Specimen (page 3) |
Anatomical Site Level 3 Name |
Choice List or none |
Specimen 2.Anatomical Site Level 3 Name |
3, Specimen (page 3) |
Anatomical Site Level 2 Name |
Choice List or none |
Specimen 2.Anatomical Site Level 2 Name |
3, Specimen (page 3) |
Anatomical Site Level 1 Name |
Choice List or none |
Specimen 2.Anatomical Site Level 1 Name |
3, Specimen (page 3) |
Anatomical Site Name |
Choice List or none |
Specimen 2.Anatomical Site Name 2 |
3, Specimen (page 3) |
Date Collected |
Calendar or none |
Specimen 2.Collection Date 2 |
3, Specimen (page 3) |
Amount |
Text Field or none |
Specimen 2.Specimen Amount 2 |
3, Specimen (page 3) |
Units |
Choice List or none |
Specimen 2.Specimen Amount UoM 2 |
3, Specimen (page 3) |
Specimen Type Code |
Choice List or none |
Specimen 2.Specimen Code 2 |
3, Specimen (page 3) |
Anatomical Site Top Level Code |
Choice List or none |
Specimen 2.Anatomical Site Level 5 Code |
3, Specimen (page 3) |
Anatomical Site Level 4 Code |
Choice List or none |
Specimen 2.Anatomical Site Level 4 Code |
3, Specimen (page 3) |
Anatomical Site Level 3 Code |
Choice List or none |
Specimen 2.Anatomical Site Level 3 Code |
3, Specimen (page 3) |
Anatomical Site Level 2 Code |
Choice List or none |
Specimen 2.Anatomical Site Level 2 Code |
3, Specimen (page 3) |
Anatomical Site Level 1 Code |
Choice List or none |
Specimen 2.Anatomical Site Level 1 Code |
3, Specimen (page 3) |
Anatomical Site Code |
Choice List or none |
Specimen 2.Anatomical Site Code 2 |
Prompt end user for patient IDs to add or remove and time range to consider when selecting Events (Diagnosis, Medications, Tests, Procedures, Patient History, Specimen, Consent) corresponding to each patient. If time range is not specified, all patient events are displayed (default). Multiple Patient IDs can be added or removed and corresponding date range can be selected to be displayed.
Table A-45 describes the prompts in the Add or Remove Patient IDs and Time Range Prompt Set
Table A-45 Add or Remove Patient IDs and Time Range (Prompt Set TRC-CEP-S11)
Prompt Page Number, Prompt Page Heading | Prompt Heading | Prompt Type or Default Value(s) Layer | Measure or Dimension in PL Layer |
---|---|---|---|
1, NA |
Add Patient IDs |
Choice List or none |
Patient 1.Patient ID |
1, NA |
Remove Patient IDs |
Choice List or none |
Patient 2.Patient ID |
1, NA |
Patient Event From (MM/DD/YYYY) To (MM/DD/YYYY) |
Text Field or none |
TRC-CEM-034 |
Multiple IDs can be selected for patients. Selected patients are displayed in the table or list below.
Prompt end user for patient IDs to select and time range to consider when selecting Events (Diagnosis, Medications, Tests, Procedures, Patient History, Specimen, Consent) corresponding to each patient. If time range is not specified, all patient events are displayed (default). Multiple Patient IDs can be selected and corresponding date range can be selected to be displayed.
Table A-47 describes the prompts in the Select Patient IDs Prompt Set
Table A-47 Select Patient IDs and Time Range (Prompt Set TRC-CEP-S13)
Prompt Page Number, Prompt Page Heading | Prompt Heading | Prompt Type or Default Value(s) Layer | Measure or Dimension in PL Layer |
---|---|---|---|
1, NA |
Select Patient IDs |
Choice List or none |
Patient 3.Patient ID |
1, NA |
Patient Event From (MM/DD/YYYY) To (MM/DD/YYYY) |
Text Field or none |
TRC-CEM-034 |