Data Mapping from Filemaker Pro DB to OCW Metadata Elements
Some questions about this mapping (link)
BaseTable name |
name |
Course Record |
Source |
|---|---|---|---|
|
|
Identifier |
|
d_Course |
zzd_courseTitle |
Title |
|
|
|
Description |
|
|
|
Contributor Role |
|
d_FacultyCourseContribution |
zz_kb_contributorID |
Contributor |
|
|
|
Publisher |
Auto-population |
|
|
Publication Date |
|
d_Course |
zzd_semester |
Semester |
|
d_Course |
zzd_year |
|
|
d_Course |
zzd_courseNumberSuffix |
Master Course Number |
|
d_Course |
zzd_otherCourseNumbers |
Cross-Listed Course Number |
|
|
|
Language |
|
|
|
Aggregation Level |
|
|
|
Metadata Contributor Role |
|
|
|
Metadata Contributor |
|
d_Course |
zzd_urlCurrentSite |
Location |
|
|
|
Technical Requirements |
|
d_Course |
zzd_courseLevel |
Educational Context |
|
|
|
Rights |
|
|
|
Relation Kind |
|
d_Course |
zz_kb_updateCourseID |
Relation (to other Course) |
|
d_Course |
zzd_update |
|
|
d_Course |
zzd_audit_IsDepartmentCore |
|
|
d_Course |
zzd_audit_IsGIR |
|
|
d_Course |
zzd_isHighlightsforHighschool |
|
|
|
|
License |
|
|
|
Classification |
|
|
|
Category (iTunes) |
|
d_Course |
zzd_keywords |
Keywords |
|
|
|
|
|
|
|
Section Record |
|
|
|
Identifier |
|
d_Section |
zzd_sectionDescription |
Title |
|
d_Course |
zzd_zciAsgNotes |
Description |
|
d_Course |
zzd_zciExamsNotes |
|
|
d_Course |
zzd_zciLabsNotes |
|
|
d_Course |
zzd_zciLectureNotesNotes |
|
|
d_Course |
zzd_zciLectureNotesType |
|
|
d_Course |
zzd_zciOtherSections |
|
|
d_Course |
zzd_zciProjectsNotes |
|
|
d_Course |
zzd_zciReadingsNotes |
|
|
d_Course |
zzd_zciRecitationsNotes |
|
|
d_Course |
zzd_zciRelatedResourcesNotes |
|
|
d_Course |
zzd_zciStudyMaterialsNotes |
|
|
d_Course |
zzd_zciToolsNotes |
|
|
|
|
Contributor Role |
|
|
|
Contributor |
|
|
|
Publisher |
|
|
|
Publication Date |
|
|
|
Semester |
|
|
|
Master Course Number |
|
|
|
Cross-Listed Course Number |
|
|
|
Language |
|
|
|
Aggregation Level |
|
|
|
Metadata Contributor Role |
|
|
|
Metadata Contributor |
|
|
|
Location |
|
|
|
Technical Requirements |
|
|
|
Educational Context |
|
|
|
Rights |
|
|
|
License |
|
|
|
Relation Kind |
|
d_Section |
zz_kb_courseID |
Relation (to Course) |
|
|
|
Relation (to other Sections and Resources) |
|
|
|
Classification |
|
|
|
Keywords |
|
|
|
|
|
|
|
Resource Record |
|
|
|
Identifier |
|
d_Resource |
zzd_title |
Title |
|
d_Resource |
zzd_resourceName |
|
|
|
|
Description |
|
|
|
Contributor Role |
|
d_Resource |
zzd_author |
Contributor |
|
|
|
Publisher |
|
|
|
Publication Date |
|
|
|
Credit |
|
|
|
Language |
|
|
|
Aggregation Level |
|
|
|
Metadata Contributor Role |
|
|
|
Metadata Contributor |
|
d_Resource |
zzd_location |
Location |
|
|
|
Format |
|
|
|
Size |
|
|
|
Technical Requirements |
|
|
|
Educational Context |
|
|
|
Learning Resource Type |
|
|
|
Rights |
|
|
|
License |
|
|
|
Course |
|
d_Resource |
zz_kb_sectionID |
Section |
|
|
|
Relation (to other Resources) |
|
|
|
Album (Relation) |
|
|
|
Grouping (Classification) |
|
|
|
Compilation (Relation) |
|
|
|
Genre |
|
|
|
Duration |
|
|
|
Track |
|
|
|
Comment |
|
|
|
Album Art |
|
|
|
Performers |
|
|
|
Transcription |
|
|
|
Checksum |
|