The

Specref

RefType	file
t	Relationship file

holds one

Gloss

SpacePreSpace	truefalse
t	relationship

per row. Each

Gloss

SpacePreSpace	truefalse
t	relationship

is of a particular type, and has a source

Gloss

SpacePreSpace	truefalse
t	concept

and a destination

Gloss

SpacePreSpace	truefalse
t	concept.

An example of a

Gloss

SpacePreSpace	truefalse
t	relationship

is given below:

Concept

t	371883000\|Outpatient procedure\|
ShowFormat	inline

Concept

t	116680003\|Is a\|
ShowFormat	inline

Concept

t	71388002\|Procedure\|
ShowFormat	inline

where:

Concept
t 371883000|Outpatient procedure|
ShowFormat inline
is the source
Gloss
PreSpace false
t concept;
Concept
t 116680003|Is a|
ShowFormat inline
is the
Gloss
SpacePreSpace truefalse
t relationship type

Gloss
SpacePreSpace truefalse
t concept
and;
Concept
t 71388002|Procedure|
ShowFormat inline
is the destination
Gloss
t concept.

Bookmarker

Type	start
Name	filespec

...

Field

...

Data type

...

Purpose

...

Gloss

t	Mutable
LinkType	subtle

...

id

...

Specref

RefType	data type
t	SCTID

...

Uniquely identifies the

Gloss

t	relationship.

...

NO

...

Specref

RefType	field
t	effectiveTime

...

Specref

RefType	data type
t	Time

...

Specifies the inclusive date at which the component version's state became the then current valid state of the component

...

YES

...

YES (Full)

Optional (Snapshot)

...

Specref

RefType	field
t	active

...

Specref

RefType	data type
t	Boolean

...

Specifies whether the state of the

Gloss

Space	true
t	relationship

was

Gloss

Space	true
t	active

or

Gloss

Space	true
t	inactive

from the nominal release date specified by the

Specref

RefType	field
t	effectiveTime

field.

...

YES

...

Specref

RefType	field
t	moduleId

...

Specref

RefType	data type
t	SCTID

...

Identifies the

Gloss

Space	true
t	relationship

version's module. Set to a

Gloss

Space	true
t	child

of

Concept

t	900000000000443000\|Module\|
ShowFormat	inline

within the metadata

Gloss

t	hierarchy.

...

YES

...

Specref

RefType	field
t	sourceId

...

Specref

RefType	data type
t	SCTID

...

Identifies the source

Gloss

Space	true
t	concept

of the

Gloss

Space	true
t	relationship

version. That is the

Gloss

Space	true
t	concept

defined by this

Gloss

Space	true
t	relationship.

Set to the

Gloss

Space	true
t	identifier

of a

Gloss

Space	true
t	concept.

in the Concept File.

...

NO

...

Specref

RefType	field
t	destinationId

...

Specref

RefType	data type
t	SCTID

...

Identifies the

Gloss

Space	true
t	concept

that is the destination of the

Gloss

Space	true
t	relationship

version.

That is the

Gloss

Space	true
t	concept

representing the value of the attribute represented by the

Specref

RefType	field
t	typeId

column.

Set to the

Gloss

Space	true
t	identifier

of a

Gloss

Space	true
t	concept.

in the Concept File.

Note that the values that can be applied to particular attributes are formally defined by the SNOMED CT Machine Readable Concept Model .

...

NO

...

Specref

RefType	field
t	relationshipGroup

...

Integer

...

Groups together

Gloss

Space	true
t	relationship

versions that are part of a logically associated

Specref

RefType	field
t	relationshipGroup

. All

Gloss

Space	true
t	active

Gloss

Space	true
t	Relationship

records with the same

Specref

RefType	field
t	relationshipGroup

number and

Specref

RefType	field
t	sourceId

are grouped in this way.

...

YES

...

Specref

RefType	field
t	typeId

...

Specref

RefType	data type
t	SCTID

Identifies the

Gloss

Space	true
t	concept

that represent the defining attribute (or relationship type) represented by this

Gloss

Space	true
t	relationship

version.

That is the

Gloss

Space	true
t	concept

representing the value of the attribute represented by the

Specref

RefType	field
t	typeId

column.

Set to the

Gloss

Space	true
t	identifier

of a

Gloss

Space	true
t	concept

in the Concept File. The concept identified must be either

Concept

t	116680003\|Is a\|
ShowFormat	inline

or a subtype of

Concept

t	410662002\|Concept model attribute\|

. The concepts that can be used as in the typeId column are formally defined as follows:

Scg expression

Border	ridge
ShowFormat	block

116680003|is a| OR <410662002|concept model attribute|

...

NO

...

Specref

RefType	field
t	characteristicTypeId

...

Specref

RefType	data type
t	SCTID

...

A

Gloss

Space	true
t	concept

enumeration value that identifies the characteristic type of the

Gloss

Space	true
t	relationship

version (i.e. whether the

Gloss

Space	true
t	relationship

version is defining, qualifying, etc.) This field is set to a

Gloss

Space	true
t	descendant

of

Concept

t	900000000000449001\|Characteristic type\|
ShowFormat	inline

in the metadata

Gloss

t	hierarchy

.

...

YES

...

Specref

RefType	field
t	modifierId

...

Specref

RefType	data type
t	SCTID

A

Gloss

Space	true
t	concept

enumeration value that identifies the type of

Gloss

t	Description Logic

(DL) restriction (some, all, etc.). Set to a

Gloss

Space	true
t	child

of

Concept

t	900000000000450001\|Modifier\|
ShowFormat	inline

in the metadata

Gloss

t	hierarchy.

Note

Currently the only value used in this column is

Concept

t	900000000000451002\|Some\|
ShowFormat	inline

and thus in practical terms this column can be ignored. For further clarification please see notes on modifierId .

PreSpace false
t concept.

Bookmarked content insert

Start	filespec
Page	REUSE:Relationship File

Only one

Gloss

PreSpace	false

...

YES

...

NO

Bookmarker

Type	end
Name	filespec

Only one

Gloss

Space	true
t	relationship

record with the same id field will be current at any point in time. The current record will be the one with the most recent effectiveTime before or equal to the point in time under consideration.

If the

Gloss

SpacePreSpace	truefalse
t	active

field of this record is false ('0'), then the

Gloss

SpacePreSpace	truefalse
t	relationship

is

Gloss

SpacePreSpace	truefalse
t	inactive

at that point in time. If the

Gloss

SpacePreSpace	truefalse
t	active

field is true ('1'), then there is a

Gloss

SpacePreSpace	truefalse
t	relationship

between the

Gloss

SpacePreSpace	truefalse
t	SNOMED CT concepts

identified by

Specref

RefType	field
t	sourceId

and

Specref

RefType	field
t	destinationId

.

The

Specref

RefType	field
t	sourceId

,

Specref

RefType	field
t	destinationId

,

Specref

RefType	field
t	relationshipGroup

,

Specref

RefType	field
t	typeId

, characteristicTypeIdand

Specref

RefType	field
t	modifierId

will not change between two rows with the same id, in other words they are immutable. Where a change is required to one of these fields, then the current row will be de-activated (by appending a row with the same id and the

Gloss

SpacePreSpace	truefalse
t	active

field set to false) and a new row with a new id will be appended.

The

Specref

RefType	field
t	relationshipGroup

field is used to group

Gloss

SpacePreSpace	truefalse
t	relationships

with the same

Specref

RefType	field
t	sourceId

field into one or more logical sets. A

Gloss

SpacePreSpace	truefalse
t	relationship

with a

Specref

RefType	field
t	relationshipGroup

field value of '0' is considered not to be grouped. All

Gloss

SpacePreSpace	truefalse
t	relationships

with the same

Specref

RefType	field
t	sourceId

and non-zero

Specref

RefType	field
t	relationshipGroup

are considered to be logically grouped.

The

Specref

RefType	field
t	relationshipGroup

field will be an unsigned

Specref

RefType	data type
t	Integer

, and will not be limited to a single digit value. There is no guarantee that they will be assigned sequentially, and the values will not be unique across

Gloss

PreSpace	false
t	concepts.

Search

Versions Compared

Old Version 10

New Version Current

Key

Related Links

Search

Page History

Versions Compared

Old Version 10

New Version Current

Key

Related Links