Example queries
Generated by scripts/run_queries.py over usdm-rdf v0.7.1 plus the overlay graphs. Do not edit by hand.
Each query uses the effective assessment of a term: the one no other assessment refines.
01_class_roles.rq
Effective role of every USDM class, with its profile. Effective = the assessment that no other assessment refines (authored if present, else derived).
86 rows.
| role | class | tier | readText | value | reference | part | composedIn | referenced |
|---|---|---|---|---|---|---|---|---|
| Aggregate | InterventionalStudyDesign | Model-stated | 1 | 8 | 2 | 15 | 1 | true |
| Aggregate | ObservationalStudyDesign | Model-stated | 1 | 8 | 2 | 15 | 1 | true |
| Aggregate | ScheduleTimeline | Model-stated | 1 | 1 | 1 | 4 | 1 | true |
| Aggregate | Study | Model-stated | 0 | 0 | 0 | 2 | 0 | false |
| Aggregate | StudyAmendment | Model-stated | 1 | 1 | 1 | 6 | 1 | true |
| Aggregate | StudyDefinitionDocumentVersion | Authored | 0 | 1 | 0 | 2 | 1 | true |
| Aggregate | StudyDesign | Model-stated | 1 | 4 | 2 | 14 | 1 | true |
| Aggregate | StudyVersion | Model-stated | 1 | 2 | 1 | 19 | 1 | true |
| Extension | ExtensionAttribute | Model-stated | 0 | 6 | 0 | 1 | 80 | false |
| Extension | ExtensionClass | Model-stated | 0 | 0 | 0 | 0 | 1 | false |
| Structured entity | Activity | Model-stated | 0 | 0 | 7 | 1 | 1 | true |
| Structured entity | AdministrableProduct | Model-stated | 0 | 4 | 0 | 3 | 1 | true |
| Structured entity | AdministrableProductIdentifier | Model-stated | 0 | 0 | 1 | 0 | 1 | false |
| Structured entity | AdministrableProductProperty | Model-stated | 1 | 2 | 0 | 0 | 1 | false |
| Structured entity | Administration | Model-stated | 0 | 3 | 2 | 1 | 1 | false |
| Structured entity | AssignedPerson | Model-stated | 0 | 1 | 1 | 0 | 1 | false |
| Structured entity | BiomedicalConcept | Model-stated | 0 | 1 | 0 | 1 | 1 | true |
| Structured entity | BiomedicalConceptCategory | Model-stated | 0 | 1 | 2 | 0 | 1 | true |
| Structured entity | BiomedicalConceptProperty | Model-stated | 1 | 3 | 0 | 1 | 1 | false |
| Structured entity | BiomedicalConceptSurrogate | Model-stated | 0 | 0 | 0 | 0 | 1 | true |
| Structured entity | BiospecimenRetention | Model-stated | 0 | 2 | 0 | 0 | 1 | false |
| Structured entity | DocumentContentReference | Model-stated | 0 | 0 | 1 | 0 | 1 | false |
| Structured entity | Duration | Authored | 2 | 2 | 0 | 0 | 2 | false |
| Structured entity | EligibilityCriterion | Model-stated | 0 | 1 | 3 | 0 | 1 | true |
| Structured entity | Encounter | Model-stated | 0 | 3 | 3 | 2 | 1 | true |
| Structured entity | Estimand | Model-stated | 1 | 0 | 3 | 1 | 1 | false |
| Structured entity | GovernanceDate | Model-stated | 0 | 3 | 0 | 0 | 3 | false |
| Structured entity | Identifier | Model-stated | 0 | 0 | 1 | 0 | 0 | false |
| Structured entity | Indication | Model-stated | 0 | 2 | 0 | 0 | 1 | true |
| Structured entity | Ingredient | Model-stated | 0 | 1 | 0 | 1 | 1 | false |
| Structured entity | MedicalDevice | Model-stated | 0 | 1 | 1 | 1 | 1 | true |
| Structured entity | MedicalDeviceIdentifier | Model-stated | 0 | 1 | 1 | 0 | 1 | false |
| Structured entity | NarrativeContent | Model-stated | 0 | 2 | 4 | 0 | 1 | true |
| Structured entity | Organization | Model-stated | 1 | 2 | 0 | 1 | 1 | true |
| Structured entity | PopulationDefinition | Model-stated | 0 | 5 | 1 | 0 | 0 | true |
| Structured entity | Procedure | Model-stated | 1 | 1 | 1 | 0 | 1 | true |
| Structured entity | ProductOrganizationRole | Model-stated | 0 | 1 | 2 | 0 | 1 | false |
| Structured entity | ReferenceIdentifier | Model-stated | 0 | 1 | 1 | 0 | 1 | false |
| Structured entity | ResponseCode | Model-stated | 0 | 2 | 0 | 0 | 1 | false |
| Structured entity | ScheduleTimelineExit | Authored | 0 | 0 | 0 | 0 | 1 | true |
| Structured entity | ScheduledActivityInstance | Model-stated | 0 | 0 | 6 | 0 | 1 | true |
| Structured entity | ScheduledDecisionInstance | Model-stated | 0 | 0 | 2 | 1 | 1 | true |
| Structured entity | ScheduledInstance | Model-stated | 0 | 0 | 2 | 0 | 1 | true |
| Structured entity | Strength | Model-stated | 0 | 2 | 0 | 0 | 1 | false |
| Structured entity | StudyAmendmentImpact | Model-stated | 1 | 2 | 0 | 0 | 1 | false |
| Structured entity | StudyArm | Model-stated | 1 | 2 | 1 | 0 | 1 | true |
| Structured entity | StudyCell | Model-stated | 0 | 0 | 3 | 0 | 1 | false |
| Structured entity | StudyCohort | Model-stated | 0 | 5 | 2 | 1 | 1 | true |
| Structured entity | StudyDefinitionDocument | Model-stated | 0 | 2 | 1 | 1 | 1 | true |
| Structured entity | StudyDesignPopulation | Model-stated | 0 | 5 | 1 | 1 | 1 | true |
| Structured entity | StudyEpoch | Model-stated | 0 | 1 | 2 | 0 | 1 | true |
| Structured entity | StudyIdentifier | Model-stated | 0 | 0 | 1 | 0 | 1 | false |
| Structured entity | StudyIntervention | Model-stated | 0 | 4 | 0 | 1 | 1 | true |
| Structured entity | StudyRole | Model-stated | 0 | 1 | 2 | 2 | 1 | false |
| Structured entity | StudySite | Model-stated | 0 | 1 | 0 | 0 | 1 | true |
| Structured entity | SubjectEnrollment | Model-stated | 0 | 2 | 2 | 0 | 1 | false |
| Structured entity | Substance | Authored | 0 | 1 | 0 | 2 | 2 | false |
| Structured entity | SyntaxTemplateDictionary | Model-stated | 0 | 1 | 0 | 0 | 1 | true |
| Structured entity | Timing | Model-stated | 0 | 2 | 2 | 0 | 1 | true |
| Templated text | Characteristic | Model-stated | 1 | 0 | 1 | 0 | 1 | false |
| Templated text | Condition | Model-stated | 1 | 0 | 3 | 0 | 1 | false |
| Templated text | EligibilityCriterionItem | Model-stated | 1 | 0 | 1 | 0 | 1 | true |
| Templated text | Endpoint | Model-stated | 2 | 1 | 1 | 0 | 1 | true |
| Templated text | IntercurrentEvent | Model-stated | 2 | 0 | 1 | 0 | 1 | false |
| Templated text | Objective | Model-stated | 1 | 1 | 1 | 1 | 1 | false |
| Templated text | SyntaxTemplate | Model-stated | 1 | 0 | 1 | 0 | 0 | false |
| Text carrier | AnalysisPopulation | Model-stated | 1 | 0 | 1 | 0 | 3 | true |
| Text carrier | CommentAnnotation | Model-stated | 1 | 1 | 0 | 0 | 28 | false |
| Text carrier | ConditionAssignment | Model-stated | 1 | 0 | 1 | 0 | 1 | false |
| Text carrier | Masking | Model-stated | 1 | 1 | 0 | 0 | 1 | false |
| Text carrier | NarrativeContentItem | Model-stated | 1 | 0 | 0 | 0 | 1 | true |
| Text carrier | StudyAmendmentReason | Model-stated | 1 | 1 | 0 | 0 | 1 | false |
| Text carrier | StudyChange | Model-stated | 2 | 0 | 0 | 1 | 1 | false |
| Text carrier | StudyElement | Authored | 0 | 0 | 1 | 2 | 1 | true |
| Text carrier | StudyTitle | Model-stated | 1 | 1 | 0 | 0 | 1 | false |
| Text carrier | TransitionRule | Model-stated | 1 | 0 | 0 | 0 | 2 | false |
| Value type | Abbreviation | Model-stated | 0 | 0 | 0 | 0 | 1 | false |
| Value type | Address | Model-stated | 0 | 1 | 0 | 0 | 1 | false |
| Value type | AliasCode | Model-stated | 0 | 2 | 0 | 0 | 10 | false |
| Value type | Code | Model-stated | 0 | 0 | 0 | 0 | 38 | false |
| Value type | GeographicScope | Model-stated | 0 | 2 | 0 | 0 | 3 | false |
| Value type | ParameterMap | Model-stated | 0 | 0 | 0 | 0 | 1 | false |
| Value type | PersonName | Model-stated | 0 | 0 | 0 | 0 | 1 | false |
| Value type | Quantity | Model-stated | 0 | 2 | 0 | 0 | 9 | false |
| Value type | QuantityRange | Model-stated | 0 | 0 | 0 | 0 | 3 | false |
| Value type | Range | Model-stated | 0 | 3 | 0 | 0 | 4 | false |
02_text_in_structured_classes.rq
Read text held inside classes whose role is not text: where narrative sits in otherwise structured parts of the model.
13 rows.
| class | classRole | attribute | kind |
|---|---|---|---|
| ScheduleTimeline | Aggregate | ScheduleTimeline-entryCondition | Logic as text |
| StudyAmendment | Aggregate | StudyAmendment-summary | Narrative text (definition-stated) |
| StudyDesign | Aggregate | StudyDesign-rationale | Prose |
| StudyVersion | Aggregate | StudyVersion-rationale | Prose |
| AdministrableProductProperty | Structured entity | AdministrableProductProperty-text | Structured text (definition-stated) |
| BiomedicalConceptProperty | Structured entity | BiomedicalConceptProperty-datatype | Classification as text |
| Duration | Structured entity | Duration-reasonDurationWillVary | Companion text |
| Duration | Structured entity | Duration-text | Unstructured text (definition-stated) |
| Estimand | Structured entity | Estimand-populationSummary | Unclassified string |
| Organization | Structured entity | Organization-identifierScheme | Classification as text |
| Procedure | Structured entity | Procedure-procedureType | Classification as text |
| StudyAmendmentImpact | Structured entity | StudyAmendmentImpact-text | Unstructured text (definition-stated) |
| StudyArm | Structured entity | StudyArm-dataOriginDescription | Companion text |
03_logic_and_classification_as_text.rq
Attributes that hold a condition or a classification as text: candidates for a structured or coded representation.
6 rows.
| kind | attribute | rationale |
|---|---|---|
| Classification as text | BiomedicalConceptProperty-datatype | The value names a datatype for the response value. The published examples use a small set of datatype names, and USDM_CT.xlsx gives no value list. See finding bc-property-datatype-names. |
| Classification as text | IntercurrentEvent-strategy | ICH E9(R1) names a fixed set of strategies for intercurrent events, so the substance is a classification. The definition asks for a textual description and USDM_CT.xlsx gives no value list. Classified by substance; the conflict is recorded as finding intercurrent-event-strategy-textual. |
| Classification as text | Organization-identifierScheme | Names the organization that issues the identifier. The published examples use a small set of issuer names, and USDM_CT.xlsx gives no value list. |
| Classification as text | Procedure-procedureType | The definition calls the value a classification, but USDM_CT.xlsx gives no value list and the range is xsd:string. The same definition pattern is coded elsewhere in the model, see finding procedure-type-uncoded. |
| Logic as text | ConditionAssignment-condition | The attribute holds the condition under which the decision instance moves to its target scheduled instance. The range is xsd:string and USDM_CT.xlsx gives no value list. The model has a Condition class, but this attribute does not reference it; the logic is held as text. |
| Logic as text | ScheduleTimeline-entryCondition | The definition describes a logical evaluation. The range is xsd:string, USDM_CT.xlsx gives no value list, and the attribute does not reference the Condition class. The logic is held as text. |
04_study_design_parts.rq
What a study design is made of: the classes StudyDesign composes directly (content kind Composition, notes excluded), with their roles.
14 rows.
| role | part | attribute |
|---|---|---|
| Aggregate | ScheduleTimeline | StudyDesign-scheduleTimelines |
| Structured entity | Activity | StudyDesign-activities |
| Structured entity | BiospecimenRetention | StudyDesign-biospecimenRetentions |
| Structured entity | EligibilityCriterion | StudyDesign-eligibilityCriteria |
| Structured entity | Encounter | StudyDesign-encounters |
| Structured entity | Estimand | StudyDesign-estimands |
| Structured entity | Indication | StudyDesign-indications |
| Structured entity | StudyArm | StudyDesign-arms |
| Structured entity | StudyCell | StudyDesign-studyCells |
| Structured entity | StudyDesignPopulation | StudyDesign-population |
| Structured entity | StudyEpoch | StudyDesign-epochs |
| Templated text | Objective | StudyDesign-objectives |
| Text carrier | AnalysisPopulation | StudyDesign-analysisPopulations |
| Text carrier | StudyElement | StudyDesign-elements |