Mapping Spreadsheet

Note that this content was used in the discussion and exploration of optional approaches. It lead to the decision to create a database to support multiple presentations of content mapping that would support multiple uses.

GENERIC OBJECT NAME	Generic Object Type	Included in	Type	DDI LIFECYCLE	Type	CODEBOOK	CDI	CDI component
	Package		DataRelationship	DataRelationship	xs:string	fileDscr/fileTxt/fileStrc/recGrp/@keyvar	AttributeComponent	DataStructureComponentType (base)
	Group		LogicalRecordType	LogicalRecord	xs:string	fileDscr/fileTxt/fileStrc/recGrp/@keyvar	CodeList	Code_denotes_Category (ref)
	Group		RecordRelationshipType	RecordRelationship	xs:string	fileDscr/fileTxt/fileStrc/recGrp/@recidvar	CodeList	Code_uses_Notation(ref)
	Class	Variable	Variable	Variable	varType	var	CodeList	Notation
	Sub class	Variable	RepresentationType	ValueRepresentation	catgryType	catgry	ConceptualDomain	ConceptualDomain_isDescribedBy_ValueAndConceptDescription (Ref)
	Sub class		Universe	Universe	conceptualTextType	universe	ConceptualDomain	ConceptualDomain_takesConceptsFrom_ConceptSystem (Ref)
	Sub class		MeasurementItem	Measurement	xs:string	var@measUnit	ConceptualDomain	ConceptualVariable_measures_UnitType (Ref)
	Sub class	Represented Variable	RepresentedVariable	Represented Variable		n/a	ConceptualDomain	ConceptualVariable_takesSentinelConceptsFrom_SentinelConceptualDomain (Ref)
	Sub class	Conceptual Variable	ConceptualVariable	Conceptual Variable		n/a	ConceptualDomain	ConceptualVariable_takesSubstantiveConceptsFrom_SubstantiveConceptualDomain (Ref)
	Sub class		CodeValueType	Analysis Unit	conceptType	anlysUnit	ConceptualDomain	DisplayLabel
	Sub class		Concept	ConceptReference	conceptType	concept	ConceptualValue	ConceptualValue_hasConceptFrom_ConceptualDomain
	Sub class		CodeValueType	Source Unit	conceptType	respUnit	ConceptualValue	Defnition (InternaltionStructureedStringType
	Sub class		NameType	VariableName		n/a	ConceptualValue	DisplayLabel (LabelForDisplayType)
	Sub class		LabelType	Label	lablType	labl	ConceptualValue	Name (ObjectNameType)
	Sub class		StructuredStringType	Description		n/a	ConceptualVariable	ConceptType (base)
	Sub class		ParameterType	OutParameter		n/a	ConceptualVariable	ConceptualVariable_uses_Concept (Ref)
	Sub class		ParameterType	SourceParameter		n/a	ConceptualVariable	DescriptiveText (IntString)
	Sub class		Variable	SourceVariable			DataStructureComponenent/InstanceVariable	PhysicalDataType (CV)
	Sub class		Weighting	WeightingProcessReference		(check 2.6)	DataStructureComponenent/InstanceVariable	PlatformType (CV)
	Sub class		Question	QuestionReference	qstnType	qstn	DataStructureComponenent/InstanceVariable	RepresentedVariableType (base)
	Sub class		EmbargoType	EmbargoReference	embargoType	embargo	DataStructureComponentType	DataStructureComponent_isDefinedBy_Represen(ref)
	Sub class		UnitType	UnitTypeReference	unitType	unit	IdentifierComponent	DataStructureComponentType (base)
	Sub class		boolean	IsTemporal	boolean	temporal	InstanceVariable	InstanceVariable_isBasedOn_RepresentedVariable (Ref)
	Sub class		boolean	IsGeographic	boolean	geog	InstanceVariable	InstanceVariable_measures_Population (Ref)
	Sub class		boolean	IsWeight	boolean	wgt	InstanceVariable	VariableFunction (CV)
	Package		VariableRepresentationType	VariableRepresentation		n/a	KeyValueDataStore	InformationObjectType (base)
	Sub class		CodeValueType	VariableRole		var@temporal; var@wgt; var@geog	KeyValueDataStore	KeyValueDataStore_has_DataPoint (ref)
	Sub class		Variable	WeightVariableReference	var	wgt-var	KeyValueDataStore	KeyValueDataStore_has_InstanceKey (ref)
	Sub class		StandardWeightType	StandardWeightReference		var@weight	KeyValueDataStore	KeyValueDataStore_isStructuredBy_KeyValueStructure (ref)
	Sub class		VariableAttributeType	VariableAttribute		n/a	KeyValueStructure	KeyValueStructure_has_ContextualComponent (ref)
	Sub class		VariableAttributeType	ImputationReference		derivation	KeyValueStructure	KeyValueStructure_has_DimensionComponent (ref)
	Sub class		ConcatenatedValueType	ConcatenatedValue		n/a	KeyValueStructure	KeyValueStructure_has_IdentifierComponent (Ref)
	Sub class		ProcessingInstruction	ProcessingInstructionReference		n/a	KeyValueStructure	KeyValueStructure_has_SyntheticIdComponent (ref)
	Sub class		RepresentationType	ValueRepresentation	[see individual entries]	catgry; valRange; stdCatgy	KeyValueStructure	KeyValueStructure_has_TimeComponent (ref)
	Sub class		ManagedMissingValuesRepresentation	MissingValuesReference	xs:boolean	catgry@missing	KeyValueStructure	KeyValueStructure_has_VariableDescriptorComponent (ref)
	Sub class		ContentDateOffsetType	ContentDateOffset		n/a	MeasureComponent	DataStructureComponentType (base)
	Sub class		CodeValueType	AggregationMethod		n/a	MeasureComponent	Name (ObjectNameType)
	Sub class		[stock \| flow \| nonadditive]	Additivity		n/a	Population	Populaiton_isComposedOf_Unit (Ref)
	Sub class		CodeValueType	MeasurementUnit	xs:string	var@measUnit	Population	Population_narrows_Universe (Ref)
			Identifier (of Variable)	LogicalRecord/Variable	IDREF	var@rectype	Population	TimePeriodOfPopulation (DateRangeType)
			Identifier (of LogicalRecord)	LogicalRecord	recGrpType	recGrp	Population	UniverseType (base)
	Group		VariableValueReferenceType	VariableValueReference	IDREF	fileDscr/fileTxt/fileStrc/recGrp/@keyvar	RepresentedVariable	ConceptualVariableType (base)
			Identifier (of Varaible)	VariableValueReference/Variable	IDREF	fileDscr/fileTxt/fileStrc/recGrp/@keyvar	RepresentedVariable	HasIntendedDataType (CV)
			Value	VariableValueReference/RelatedValue	IDREF	fileDscr/fileTxt/fileStrc/recGrp/@recidvar	RepresentedVariable	HasIntendedDataType (CV)
			VariableValueReferenceType	SupportForMultipleSegments		recGrp	RepresentedVariable	RepresentedVariable_isBasedOn_ConceptualVariable (Ref)
			RecordRelationshipType	RecordRelationship		n/a	RepresentedVariable	RepresentedVariable_isBasedOn_ConceptualVariable (Ref)
			Identifier (LogicalRecord)	SourceLogicalRecordReference		n/a	RepresentedVariable	RepresentedVariable_measures_Universe (Ref)
			Identifer (LogicalRecord)	TargetLogicalRecordReference		n/a	RepresentedVariable	RepresentedVariable_measures_Universe (Ref)
			[parent \| child \| sibling \| unkown]	RelationshipCode		n/a	RepresentedVariable	RepresentedVariable_takesSentinelValuesFrom_SentinelValueDomain (Ref)
			SourceTargetLinkType	SourceTargetLink		n/a	RepresentedVariable	RepresentedVariable_takesSentinelValuesFrom_SentinelValueDomain (Ref)
			Identifier (of Variable)	SourceLinkVariableReference		n/a	RepresentedVariable	RepresentedVariable_takesSubstantiveValuesFrom_SubstantiveValueDomain (Ref)
			Identifier (of Variable)	TargetLinkVariableReference		n/a	RepresentedVariable	RepresentedVariable_takesSubstantiveValuesFrom_SubstantiveValueDomain (Ref)
ValueReps	CodeValueType		RecommendedDataType		valRangType	valRange	RepresentedVariable	SentinelConceptualDomain
ValueReps	CodeValueType		MeasurementUnit		stdCatgryType	stdCatgry	RepresentedVariable	UnitOfMeasurement (xs:string)
ValueReps	CodeValueType		GenericOutputFormat				RepresentedVariable	UnitOfMeasurement (xs:string)
ValueReps	xs:boolean		missingValue				SentinelConceptualDomain	ConceptualDomainType
ValueReps	xs:boolean		blankIsMissing				SentinelConceptualDomain	Unit
ValueReps	[nominal \| ordinal \| interval \| ratio \| continuous]		classificaitonLevel				SentinelValueDomain	PlatformType (CV)
ValueReps			CategorySchemeReference				SentinelValueDomain	SentinelValueDomain_isDescribedBy_ValueAndConceptDescription (Ref)
ValueReps			CodeListReference				SentinelValueDomain	SentinelValueDomain_takesValuesFrom_EnumerationDomain (Ref)
ValueReps			StatisticalClassificationReference				SentinelValueDomain	ValueDomainType (base)
ValueReps			CodeSubsetInformation				SubstantiveConceptualDomain	ConceptualDomainType
ValueReps			DateFieldFormat				SubstantiveConceptualDomain	Unit
ValueReps			DateTypeCode				SubstantiveValueDomain	SubstantiveValueDomain_isDescribedBy_ValueAndConceptDescription (Ref)
ValueReps			Range				SubstantiveValueDomain	SubstantiveValueDomain_takesConceptsFrom_SubstantiveConceptualDomain (Ref)
ValueReps			regExp				SubstantiveValueDomain	SubstantiveValueDomain_takesValuesFrom_EnumerationDomain (Ref)
ValueReps			ExternalCategoryReference				SubstantiveValueDomain	ValueDomainType (bse)
ValueReps			UsageDirections				Unit	DisplayLabel
ValueReps			IncludedGeographicLocationCodes				Unit	Name
ValueReps			LimitedCodeSegmentCaptured				Unit	Unit_has_UnitType (Ref)
ValueReps			IncludedGeographicStructureCodes				UnitType	ConceptType (base)
ValueReps			NumberRange				UnitType	DescrptiveText (InterlString)
ValueReps			NumericTypeCode				UnitType	UnitType_uses_Concept (ref)
ValueReps			format				Universe	ConceptType (base)
ValueReps			interval				Universe	DescriptiveText (IntlString)
ValueReps			scale				Universe	IsInclusive (xs:boolean)
ValueReps			decimalPosition				Universe	Universe_narrows_UnitType (ref)
ValueReps			accuracy				Universe	Universe_uses_Concept (ref)
ValueReps			maxLength				ValueAndConceptDescription	ClassificationLevel (CategoryRelationCodeType)
ValueReps			minLength				ValueAndConceptDescription	Description (IntlString)
CodeList			CategoryReference				ValueAndConceptDescription	FormatPAttern (CV)
CodeList			CodeValueType				ValueAndConceptDescription	LogicalExpression (CV)
CodeList			Level				ValueAndConceptDescription	MaximumValueExclusive (xs:string)
CodeList			HierarchyType				ValueAndConceptDescription	MaximumValueInclusive (xs:string)
CodeList			isSystemMissingValue				ValueAndConceptDescription	MinimumValueExclusive (xs:string)
							ValueAndConceptDescription	MinimumValueInclusive (xs:string)
							ValueAndConceptDescription	RegularExpression (typedStringType)
							ValueDomain	DisplayLabel
							ValueDomain	RecommendedDataType (CV)
							VariableValueComponent	DataStructureComponentType (base)