Class: WhereClause
A conditional element that describes the circumstances under which a containing context applies, linking conditions to structures where they are used
erDiagram
WhereClause {
string OID
string uuid
string name
string description
string label
stringList aliases
boolean mandatory
string purpose
datetime lastUpdated
string owner
string wasDerivedFrom
}
SiteOrSponsorComment {
string text
OriginSource sourceType
string source
string OID
string uuid
string name
string description
string label
stringList aliases
boolean mandatory
string purpose
datetime lastUpdated
string owner
string wasDerivedFrom
}
Comment {
string text
string OID
string uuid
string name
string description
string label
stringList aliases
boolean mandatory
string purpose
datetime lastUpdated
string owner
string wasDerivedFrom
}
Coding {
string code
string decode
string codeSystem
string codeSystemVersion
AliasPredicate aliasType
}
Condition {
string implementsCondition
LogicalOperator operator
string OID
string uuid
string name
string description
string label
stringList aliases
boolean mandatory
string purpose
datetime lastUpdated
string owner
string wasDerivedFrom
}
FormalExpression {
string context
string expression
string returnType
string OID
string uuid
string name
string description
string label
stringList aliases
}
RangeCheck {
Comparator comparator
stringList checkValues
string item
SoftHard softHard
LogicalOperator operator
}
WhereClause ||--}o Condition : "conditions"
WhereClause ||--}o Coding : "coding"
WhereClause ||--}o Comment : "comments"
WhereClause ||--}o SiteOrSponsorComment : "siteOrSponsorComments"
SiteOrSponsorComment ||--}o Coding : "coding"
SiteOrSponsorComment ||--}o Comment : "comments"
SiteOrSponsorComment ||--}o SiteOrSponsorComment : "siteOrSponsorComments"
Comment ||--}o DocumentReference : "documents"
Comment ||--}o Coding : "coding"
Comment ||--}o Comment : "comments"
Comment ||--}o SiteOrSponsorComment : "siteOrSponsorComments"
Condition ||--}o RangeCheck : "rangeChecks"
Condition ||--}o FormalExpression : "expressions"
Condition ||--}o Condition : "conditions"
Condition ||--}o Coding : "coding"
Condition ||--}o Comment : "comments"
Condition ||--}o SiteOrSponsorComment : "siteOrSponsorComments"
FormalExpression ||--}o Parameter : "parameters"
FormalExpression ||--|o ReturnValue : "returnValue"
FormalExpression ||--}o Resource : "externalCodeLibs"
FormalExpression ||--}o Coding : "coding"
RangeCheck ||--}o FormalExpression : "expressions"
Inheritance
- GovernedElement [ Identifiable Labelled Governed]
- WhereClause
Slots
| Name | Cardinality and Range | Description | Inheritance |
|---|---|---|---|
| conditions | * Condition |
Logical conditions that apply in this context (combined with AND) | direct |
| OID | 1 String |
Local identifier within this study/context. Use CDISC OID format for regulatory submissions, or simple strings for internal use. | Identifiable |
| uuid | 0..1 String |
Universal unique identifier | Identifiable |
| name | 0..1 String |
Short name or identifier, used for field names | Labelled |
| description | 0..1 String or String or TranslatedText |
Detailed description, shown in tooltips | Labelled |
| coding | * Coding |
Semantic tags for this element | Labelled |
| label | 0..1 String or String or TranslatedText |
Human-readable label, shown in UIs | Labelled |
| aliases | * String or String or TranslatedText |
Alternative name or identifier | Labelled |
| mandatory | 0..1 Boolean |
Is this element required? | Governed |
| comments | * Comment |
Comment on the element, such as a rationale for its inclusion or exclusion | Governed |
| siteOrSponsorComments | * SiteOrSponsorComment |
Comment on the element, such as a rationale for its inclusion or exclusion | Governed |
| purpose | 0..1 String or String or TranslatedText |
Purpose or rationale for this data element | Governed |
| lastUpdated | 0..1 Datetime |
When the resource was last updated | Governed |
| owner | 0..1 String or User or Organization or String |
Party responsible for this element | Governed |
| wasDerivedFrom | 0..1 String or Item or ItemGroup or MetaDataVersion or CodeList or ReifiedConcept or ConceptProperty or Condition or Method or NominalOccurrence or Dataflow or CubeComponent or DataProduct or ProvisionAgreement |
Reference to another item that this item implements or extends, e.g. a template Item definition. | Governed |
Usages
| used by | used in | type | used |
|---|---|---|---|
| MetaDataVersion | whereClauses | range | WhereClause |
| Item | applicableWhen | range | WhereClause |
| ItemGroup | applicableWhen | range | WhereClause |
| Parameter | applicableWhen | range | WhereClause |
| DataStructureDefinition | applicableWhen | range | WhereClause |
| Analysis | applicableWhen | range | WhereClause |
Identifier and Mapping Information
Schema Source
- from schema: https://cdisc.org/define-json
Mappings
| Mapping Type | Mapped Value |
|---|---|
| self | odm:WhereClause |
| native | odm:WhereClause |
| related | fhir:StructureDefinition/context, qb:ObservationGroup, qb:Slice, sdmx:CubeRegion, sdmx:MetadataTargetRegion |
| close | sdmx:AttachmentConstraint |
LinkML Source
Direct
name: WhereClause
description: A conditional element that describes the circumstances under which a
containing context applies, linking conditions to structures where they are used
from_schema: https://cdisc.org/define-json
close_mappings:
- sdmx:AttachmentConstraint
related_mappings:
- fhir:StructureDefinition/context
- qb:ObservationGroup
- qb:Slice
- sdmx:CubeRegion
- sdmx:MetadataTargetRegion
is_a: GovernedElement
attributes:
conditions:
name: conditions
description: Logical conditions that apply in this context (combined with AND)
from_schema: https://cdisc.org/define-json
domain_of:
- MetaDataVersion
- WhereClause
- Condition
- Parameter
range: Condition
multivalued: true
inlined: false
Induced
name: WhereClause
description: A conditional element that describes the circumstances under which a
containing context applies, linking conditions to structures where they are used
from_schema: https://cdisc.org/define-json
close_mappings:
- sdmx:AttachmentConstraint
related_mappings:
- fhir:StructureDefinition/context
- qb:ObservationGroup
- qb:Slice
- sdmx:CubeRegion
- sdmx:MetadataTargetRegion
is_a: GovernedElement
attributes:
conditions:
name: conditions
description: Logical conditions that apply in this context (combined with AND)
from_schema: https://cdisc.org/define-json
alias: conditions
owner: WhereClause
domain_of:
- MetaDataVersion
- WhereClause
- Condition
- Parameter
range: Condition
multivalued: true
inlined: false
OID:
name: OID
description: Local identifier within this study/context. Use CDISC OID format
for regulatory submissions, or simple strings for internal use.
from_schema: https://cdisc.org/define-json
rank: 1000
identifier: true
alias: OID
owner: WhereClause
domain_of:
- Identifiable
range: string
required: true
pattern: ^[A-Za-z][A-Za-z0-9._-]*$
uuid:
name: uuid
description: Universal unique identifier
from_schema: https://cdisc.org/define-json
rank: 1000
alias: uuid
owner: WhereClause
domain_of:
- Identifiable
range: string
name:
name: name
description: Short name or identifier, used for field names
from_schema: https://cdisc.org/define-json
rank: 1000
alias: name
owner: WhereClause
domain_of:
- Labelled
- Standard
range: string
description:
name: description
description: Detailed description, shown in tooltips
from_schema: https://cdisc.org/define-json
rank: 1000
alias: description
owner: WhereClause
domain_of:
- Labelled
- CodeListItem
range: string
any_of:
- range: string
- range: TranslatedText
coding:
name: coding
description: Semantic tags for this element
from_schema: https://cdisc.org/define-json
rank: 1000
alias: coding
owner: WhereClause
domain_of:
- Labelled
- CodeListItem
- SourceItem
range: Coding
multivalued: true
inlined: true
inlined_as_list: true
label:
name: label
description: Human-readable label, shown in UIs
from_schema: https://cdisc.org/define-json
exact_mappings:
- skos:prefLabel
rank: 1000
alias: label
owner: WhereClause
domain_of:
- Labelled
range: string
any_of:
- range: string
- range: TranslatedText
aliases:
name: aliases
description: Alternative name or identifier
from_schema: https://cdisc.org/define-json
exact_mappings:
- skos:altLabel
rank: 1000
alias: aliases
owner: WhereClause
domain_of:
- Labelled
- CodeListItem
range: string
multivalued: true
inlined: true
inlined_as_list: true
any_of:
- range: string
- range: TranslatedText
mandatory:
name: mandatory
description: Is this element required?
from_schema: https://cdisc.org/define-json
rank: 1000
alias: mandatory
owner: WhereClause
domain_of:
- Governed
range: boolean
comments:
name: comments
description: Comment on the element, such as a rationale for its inclusion or
exclusion
from_schema: https://cdisc.org/define-json
rank: 1000
alias: comments
owner: WhereClause
domain_of:
- Governed
range: Comment
multivalued: true
inlined: false
siteOrSponsorComments:
name: siteOrSponsorComments
description: Comment on the element, such as a rationale for its inclusion or
exclusion
from_schema: https://cdisc.org/define-json
rank: 1000
alias: siteOrSponsorComments
owner: WhereClause
domain_of:
- Governed
range: SiteOrSponsorComment
multivalued: true
inlined: false
purpose:
name: purpose
description: Purpose or rationale for this data element
from_schema: https://cdisc.org/define-json
rank: 1000
alias: purpose
owner: WhereClause
domain_of:
- Governed
range: string
any_of:
- range: string
- range: TranslatedText
lastUpdated:
name: lastUpdated
description: When the resource was last updated
from_schema: https://cdisc.org/define-json
rank: 1000
alias: lastUpdated
owner: WhereClause
domain_of:
- Governed
range: datetime
owner:
name: owner
description: Party responsible for this element
from_schema: https://cdisc.org/define-json
narrow_mappings:
- prov:wasAttributedTo
- prov:wasAssociatedBy
rank: 1000
alias: owner
owner: WhereClause
domain_of:
- Governed
range: string
any_of:
- range: User
- range: Organization
- range: string
wasDerivedFrom:
name: wasDerivedFrom
description: Reference to another item that this item implements or extends, e.g.
a template Item definition.
from_schema: https://cdisc.org/define-json
exact_mappings:
- prov:wasDerivedFrom
rank: 1000
alias: wasDerivedFrom
owner: WhereClause
domain_of:
- Governed
range: string
any_of:
- range: Item
- range: ItemGroup
- range: MetaDataVersion
- range: CodeList
- range: ReifiedConcept
- range: ConceptProperty
- range: Condition
- range: Method
- range: NominalOccurrence
- range: Dataflow
- range: CubeComponent
- range: DataProduct
- range: ProvisionAgreement