Search



Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The effectiveTime (field) andfields in theenable the use of a "log style" append-only data model to track all changes to each, providing full traceability. Once released, a row in any of these files will always remain unchanged. Historic data is supplied in the, dating thedating back to the first release informat in 2002.

In order to change the properties of a current(and, therefore, to create a new version of it), a new row is added to the applicable file, containing the updated fields, with thefield set to true and the timestamp in the effectiveTime (field) field indicating the nominal date on which the new version was released.

To inactivate a, a aa new row is added, containing the same data as the final valid version of the, but thebut with thefield set to false and the timestamp in the effectiveTime (field) field indicating the nominal date of the release in which the final version ceased being valid.

Where editorial policy does not allow a particular property of ato be changed whilst keeping the same, theas sametheas a whole is inactivated (as described above), and a new row added with a new id, the effectiveTime (field) set to the nominal date of the release in which this version of thebecame valid, and thefield set to true.

...

Content will not be future dated with respect to the release that it appears in, although a release itself may be released a few days before its nominal release date. Where there is a business requirement for specifying a future activation date for some, this somethis may be modeled using.
The following example demonstrates how the history mechanism works on the Concept file, but the same rules apply equally well to the,andmember theandmember files. In this example, theassociated with the moduleId (field) and definitionStatusId (field) have been shown in place of their SCTID (data type) values.

A new(101291009) is added on the 1st July 2007:

...

 

 

 

 

Id

effectiveTime (field)

  

moduleId (field)

definitionStatusId (field)

101291009

20070701

1

Scg expression
ShowPartsterm
|Module 1|

Scg expression
ShowPartsid+term
900000000000074008|Primitive|

In the next release (on 1 st January 2008), theis moved from |Module 1| to |Module 2|. Because the moduleIdfield moduleId field is not immutable, themay be updated simply by adding a new record with the same Id.

Table 5. History Example - Module Change
Anchor
_5d98c53f-d493-4e95-b096-c42ccaf12d93__a_5d98c53f-d493-4e95-b096-c42ccaf12d93__a

 

 

 

 

Id

effectiveTime (field)

  

moduleId (field)

definitionStatusId (field)

101291009

20070701

1

Scg expression
ShowPartsterm
|Module 1|

Scg expression
ShowPartsid+term
900000000000074008|Primitive|

101291009

20080101

1

Scg expression
ShowPartsterm
|Module 2|

Scg expression
ShowPartsid+term
900000000000074008|Primitive|

In the next release (on 1st July 2008), theis changed from being || to being ||.beingto being

Table 6. History Example - Definition Status Changed
Anchor
_5d98c53f-d493-4e95-b096-c42ccaf12d93__0_5d98c53f-d493-4e95-b096-c42ccaf12d93__0

 

 

 

 

Id

effectiveTime (field)

  

moduleId (field)

definitionStatusId (field)

 

101291009

20070701

1

Scg expression
ShowPartsterm
|Module 1|

 

Scg expression
ShowPartsid+term
900000000000074008|Primitive|
 

 

101291009

20080101

1

Scg expression
ShowPartsterm
|Module 2|

Scg expression
ShowPartsid+term
900000000000074008|Primitive|

 

101291009

20080701

1

Scg expression
ShowPartsterm
|Module 2|

Scg expression
ShowPartsid+term
900000000000073002|Defined|

 

In the next release (on 1 st January 2009), theis deactivated:

...

 

...

 

...

 

Id

effectiveTime (field)

  

moduleId (field)

definitionStatusId (field)

 

101291009

20070701

1

Scg expression
ShowPartsterm
|Module 1|

Scg expression
ShowPartsid+term
900000000000074008|Primitive|

 

101291009

20080101

1

Scg expression
ShowPartsterm
|Module 2|

Scg expression
ShowPartsid+term
900000000000074008|Primitive|

 

101291009

20080701

1

Scg expression
ShowPartsterm
|Module 2|

Scg expression
ShowPartsid+term
900000000000073002|Defined|

 

101291009

20090101

0

Scg expression
ShowPartsterm
|Module 2|

Scg expression
ShowPartsid+term
900000000000074008|Primitive|

 

Notes

...

...

  1. At no stage in this process are previously written records ever amended. Once a record has been released in a, it ait will continue to be released in exactly the same form in future.

  2. Changes are only recorded at the point of release in the. If theIf arecord is changed a number of times between releases (during an edit and review process), only the most recently amended record will be appended to the, not thenot individual records showing each separate edit to the released.

  3. In the last example, as well as inactivating the concept (active=0), the definitionStatusId (field) is changed from

    Scg expression
    ShowPartsid+term
    900000000000073002|Defined|
    to
    Scg expression
    ShowPartsShowFormatid+termnospace
    900000000000074008|Primitive|
    . In practice this change is not essential since the value of data columns is ignored when ais inactive. Although the change is unnecessary and insignificant, it typically occurs since all the relationships of an inactive concept must also be inactive, and as a result, from the perspective of the authoring environment the concept cannot be regarded as
    Scg expression
    ShowPartsShowFormatid+termnospace
    900000000000073002|Defined|
    .

Related Links