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