DDI Lifecycle in Colectica Curation Tools

The curation system creates DDI 3.2 according the following mappings.

See also

See http://www.ddialliance.org/ for complete documentation on the DDI standard.

StudyUnit

Catalog Record properties map to DDI StudyUnit elements according to the table below.

Catalog Record Property

StudyUnit Element

Id

Identifier

Title

Citation/Title

StudyId

UserID typeOfUserID = StudyId

Number

UserID typeOfUserID = StudyNumber

Authors

Citation/Creator

Description

Citation/Description

Organization

UserAttributePair (AttributeKey = OrganizationName)

Organization.AgencyID

AgencyId

Keywords

Coverage/TopicalCoverage/Keyword

CreatedBy

Citation/Contributor

CreatedDate

UserAttributePair (AttributeKey = CreatedDate)

Version

Version

LastUpdatedDate

VersionDate

Owner

Citation/Publisher

PersistentId

UserID typeOfUserID = Handle

Funding

FundingInformation/Description

ArchiveDate

UserAttributePair (AttributeKey = ArchiveDate)

PublishDate

Citation/Date

DepositAgreement

UserAttributePair (AttributeKey = DepositAgreement)

AccessStatement

UserAttributePair (AttributeKey = AccessStatement)

ConfidentialityStatement

UserAttributePair (AttributeKey = ConfidentialityStatement)

EmbargoStatement

Embargo/Description

RelatedDatabase

UserAttributePair (AttributeKey = RelatedDatabase)

RelatedPublications

UserAttributePair (AttributeKey = RelatedPublications)

RelatedProjects

UserAttributePair (AttributeKey = RelatedProjects)

ResearchDesign

DataCollection/Methodology/Methodology/Description

ModeOfDataCollection

DataCollection/CollectionEvent/ModeOfCollection/Description

FieldDates

DataCollection/CollectionEvent/DataCollectionDate

StudyTimePeriod

Coverage/TemporalCoverage/Dates

Location

Coverage/SpatialCoverage/HighestLevel

LocationDetails

Coverage/SpatialCoverage/Description

UnitOfObservation

AnalysisUnits

SampleSize

UserAttributePair (AttributeKey = SampleSize)

InclusionExclusionCriteria

DataCollection/Methodology/SamplingProcedure/Description

RandomizationProcedure

UserAttributePair (AttributeKey = RandomizationProcedure)

UnitOfRandomization

UserAttributePair (AttribueKey = UnitOfRandomization)

Treatment

UserAttributePair (AttribueKey = Treatment)

TreatmentAdministration

UserAttributePair (AttribueKey = TreatmentAdministration)

OutcomeMeasures

UserAttributePair (AttribueKey = OutcomeMeasures)

Files

PhysicalInstance (for data files) or OtherMaterial (non-data files)

ReviewType

UserAttributePair (AttributeKey = ReviewType)

CertifiedDate

UserAttributePair (AttributeKey = CertifiedDate)

PhysicalInstance

Data file properties map to DDI PhysicalInstance elements according to the table below.

File Property

PhysicalInstance Element

Id

Identifier

Number

UserID TypeOfUserID = FileNumber

Title

Citation/Title

Name

N/A

PublicName

Citation/AlternateTitle

PersistentLink

FileIdentification/Uri

PersistentLinkDate

UserAttributePair (AttributeKey = PersistentLinkDate)

Version

Version

Type

UserAttributePair (AttributeKey = FileType)

FormatName

UserAttributePair (AttributeKey = FormatName)

FormatId

UserAttributePair (AttributeKey = FormatId)

Size

UserAttributePair (AttributeKey = Size)

CreationDate

UserAttributePair (AttributeKey = CreationDate)

KindOfData

UserAttributePair (AttributeKey = KindOfData)

Source

Citation/Source

SourceInformation

UserAttributePair (AttributeKey = SourceInformation)

Rights

Citation/Rights

IsPublicAccess

FileIdentification/IsPublic

UploadedDate

UserAttributePair (AttributeKey = UploadedDate)

ExternalDatabase

UserAttributePair (AttributeKey = ExternalDatabase)

Software

UserAttributePair (AttributeKey = Software)

SoftwareVersion

UserAttributePair (AttributeKey = SoftwareVersion)

Hardware

UserAttributePair (AttributeKey = Hardware)

Checksum

Fingerprint/FingerprintValue

ChecksumMethod

Fingerprint/AlgorithmSpecification

ChecksumDate

UserAttributePair (AttributeKey = ChecksumDate)

VirusCheckOutcome

UserAttributePair (AttributeKey = VirusCheckOutcome)

VirusCheckMethod

UserAttributePair (AttributeKey = VirusCheckMethod)

VirusCheckDate

UserAttributePair (AttributeKey = VirusCheckDate)

AcceptedDate

UserAttributePair (AttributeKey = AcceptedDate)

CertifiedDate

UserAttributePair (AttributeKey = CertifiedDate)

OtherMaterial

Non-data file properties map to DDI OtherMaterial elements according to the table below.

Note

In DDI, the OtherMaterial type does not support UserAttributes. Therefore, to store information not built in to the OtherMaterial type, this mapping uses the UserID as a key-value store. This is not semantically ideal, but is an interim solution until a future version of DDI supports saving extended information about OtherMaterial items.

File Property

OtherMaterial Element

Id

Identifier

Number

UserID TypeOfUserID = FileNumber

Title

Citation/Title

Name

N/A

PublicName

Citation/AlternateTitle

PersistentLink

URL

PersistentLinkDate

UserID TypeOfUserID = PersistentLinkDate

Version

UserID TypeOfUserID = Version

Type

UserID TypeOfUserID = Type

FormatName

UserID TypeOfUserID = FormatName

FormatId

UserID TypeOfUserID = FormatId

Size

UserID TypeOfUserID = Size

CreationDate

UserID TypeOfUserID = CreationDate

KindOfData

UserID TypeOfUserID = KindOfData

Source

Citation/Source

SourceInformation

UserID TypeOfUserID = SourceInformation

Rights

Citation/Rights

IsPublicAccess

UserID TypeOfUserID = IsPublicAccess

UploadedDate

UserID TypeOfUserID = UploadedDate

ExternalDatabase

UserID TypeOfUserID = ExternalDatabase

Software

UserID TypeOfUserID = Software

SoftwareVersion

UserID TypeOfUserID = SoftwareVersion

Hardware

UserID TypeOfUserID = Hardware

Checksum

UserID TypeOfUserID = Checksum

ChecksumMethod

UserID TypeOfUserID = ChecksumMethod

ChecksumDate

UserID TypeOfUserID = ChecksumDate

VirusCheckOutcome

UserID TypeOfUserID = VirusCheckOutcome

VirusCheckMethod

UserID TypeOfUserID = VirusCheckMethod

VirusCheckDate

UserID TypeOfUserID = VirusCheckDate

AcceptedDate

UserID TypeOfUserID = AcceptedDate

CertifiedDate

UserID TypeOfUserID = CertifiedDate

Variable

Variable properties map to DDI Variable elements according to the table below.

Variable Property

Variable Element

Id

Id

Agency

Agency

Version

Version

LastUpdated

VersionDate

Name

ItemName

Label

Label

Description

Description

ResponseUnit

ResponseUnit

AnalysisUnit

AnalysisUnit

ClassificationLevel

Representation/ClassificationLevel

RepresentationType

Representation

Valid

VariableStatistic/Valid

Invalid

VariableStatistic/Invalid

Minimum

VariableStatistic/Minimum

Maximum

VariableStatistic/Maximum

Mean

VariableStatistic/Mean

StandardDeviation

VariableStatistic/StandardDeviation

Category

VariableStatistic/UnfilteredCategoryStatistic/Category

Frequency

VariableStatistic/UnfilteredCategoryStatistic/Frequency