Return to Main Menu of Viewing Options for UMAP User Guides

UMAP ELEMENTS USER GUIDES
Option 2: Database Column Names (115)
(definitions and guidelines for individual elements listed alphabetically
by their Oracle Database Column Names/Editorial Table)

	Oracle Database Column Names			Common Names "Adminstrative Overrides" (as seen by catalogers)	Published "User Group Overrides" (e-Media)
A
	Aux 1			(Clip) Aux 1
	Aux 2			(Clip) Misc Notes
B
C
	citation_contributor			citation-Creators (other)
	citation_contributor_role			citation-Creators (other) role
	citation_creator			citation-Creator or author
	citation_creator_role			citation-Creator role
	citation_publication_place			citation-Publication place
	citation_publishing_agency			citation-Publishing agency
	citation_summary		FR	Citation	Citation
	clips_description			(Clip) Description
	content_date			(Clip) Content_date
D
	drm_contracted_licensee			drm-Contracted licensee
	drm_contributor_of_item			drm-Contributor of media item
	drm_copyright_date			drm-Copyright date
	drm_copyright_held_by			drm-Copyright held by
	drm_copyright_notice		FR	drm-Copyright notice	Copyright notice
	drm_copyright_status			drm-Copyright status
	drm_distribute_to_endusers			drm-Distribute what end users
	drm_distributed_by			drm-Distributed by
	drm_enduser_constraints			drm-End user constraints	Under these constraints
	drm_enduser_obligations			drm-End user obligations	With these obligations
	drm_enduser_permissions			drm-End user permissions	You are permitted to
	drm_funding_source			drm-Media item funding
	drm_lic_constraints_conditions			drml-With what conditions
	drm_lic_constraints_context			drml-What constraints context
	drm_lic_constraints_dateend			drml-Range of dates: end
	drm_lic_constraints_datefixed			drml-Date: fixed
	drm_lic_constraints_datestart			drml-Range of dates: start
	drm_lic_constraints_devicetype			drml-What type of device
	drm_lic_constraints_endusertype			drml-What size of audience
	drm_lic_constraints_geogextent			drml-What geographic extent
	drm_lic_constraints_numbrcount			drml-How often: fixed number
	drm_lic_constraints_numbrrange			drml-How often: min-max range
	drm_lic_constraints_timeaccum			drml-Over how much time
	drm_lic_legal_method			drml-Licensing legal method
	drm_lic_legal_method_location			drml-Lic legal method location
	drm_lic_permissions_context			drml-What permissions context
	drm_lic_permissions_reuse			drml-How can it be reused
	drm_lic_permissions_transfer			drml-How can it be transferred
	drm_lic_permissions_usage			drml-How can it be used
	drm_lic_requirements_context			drml-What requirements context
	drm_lic_requirements_type			drml-What type of requirement
	drm_vended_by			drm-Vended by
E
F
	ft_text			Content
G
H
I
J
K
	kw_activity_represented			Activity represented
	kw_affiliations_represented			Affiliations represented
	kw_covspatial_body_of_water			Body of water
	kw_covspatial_collective			Collective formation or place
	kw_covspatial_continent			Continent
	kw_covspatial_country			Country or tion
	kw_covspatial_county			County or township
	kw_covspatial_municipality			Municipality-city,town,village
	kw_covspatial_offworld			Off world location
	kw_covspatial_specific			Specific formation or place
	kw_covspatial_state			State province territory
	kw_covtemp_timeperiod			Time period
	kw_description_abstract_full			Description-Abstract (full)
	kw_description_abstract_short			Description-Abstract (short)	Description
	kw_description_anecdotal			Description-Anecdotal
	kw_description_full_summary		FR	Description-Abstract (summary)	Full description
	kw_description_tableofcontents			Description-Table of contents
	kw_genre			Genre	Genre
	kw_keyword_summary		FR	Keywords	Keywords
	kw_other_supplied_keywords			Other supplied keywords
	kw_persongroupthingrepresented			Person Group Thing represented
L
M
N
	note_date			(Notes) Date
	note_text			(Notes) Text
	note_user			(Notes) User
	NP_file_info			Info	Info (NP default)
	NP_file_size			Size	Size (NP default)
	NP_file_type			Type	Type (NP default)
O
P
Q
R
	rel_related_asset_child			Has these parts	Has these parts
	rel_related_asset_parent			Is part of	Is part of
	rel_related_asset_sibling			Is related to these parts	Is related to these parts
	rel_similar_media_items			Similar media items	Similar media items
S
	source			(Clip) Source
	subject			(Clip) Subject
T
	text_date			(Video) Text
	title			(Clip) Title
U
	umap_academic_disciplines			Subjects--academic disciplines
	umap_alternative_modes			Alternative modes	Alternative modes
	umap_collection_name			Collection me
	umap_general_subject_area			Subjects--general topics
	umap_item_id		WC	Item ID (unique key field)
	umap_item_id_designator			Item ID desigtor
	umap_media_duration		FR	Duration	Duration
	umap_media_manifestation			Is this digital or physical	Is this digital or physical
	umap_media_type_formal			Media type-Formal
	umap_media_type_informal			Media type	Media type
	umap_physical_format_location			Physical formats and locations	Physical formats and locations
	umap_subjects_defined_by			Subjects defined by
	umap_title			Title	Title
	umap_title_alternative			Alternative title
	umap_title_context_level1			Title context level 1
	umap_title_context_level2			Title context level 2
	umap_title_context_level3			Title context level 3
	umap_title_context_level4			Title context level 4
	umap_title_contextual		FR	Title (contextual)	Title (contextual)
	umap_title_type			This title is a(n)	This title is a(n)
	umap_title_working			Title (working)
	usoe_content_flags			USOE content flags
	usoe_gradelevel			Grade level	Grade level
	usoe_k12_subject_areas			Subjects--Utah Core Area	Utah Core Area
	util_audiencelevel			Audience level	Audience level
	util_content_flags_summary		FR	Content flags	Content flags
	util_csm_ratings			CSM ratings
	util_esrb_game_ratings			ESRB ratings
	util_fcc_tv_ratings			FCC-TV ratings
	util_mpaa_ratings			MPAA ratings
	util_other_ratings			Other content ratings
	util_riaa_flag			RIAA flag
	util_typical_age_range			Typical user age range
V
	vw_clipping_edl_list			Clipping EDL List
	vw_workflow_annotation			Workflow annotation
	vw_workflow_status			Workflow status
W
X
Y
Z