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 AnalysisUnit
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