Biotics 4.1 Data Dictionary V2.0
last updated: 07/02/2009
Table Name	Column Name	Datatype	Null Option	Is PK	Is FK	In Subject Areas
ALLIANCE	add_to_std_authorized_by	VARCHAR2(50)	NULL	No	No
ALLIANCE	add_to_std_com	VARCHAR2(2000)	NULL	No	No	Alliances
ALLIANCE	alliance_add_to_std_date	DATE	NULL	No	No
ALLIANCE	alliance_com	VARCHAR2(2000)	NULL	No	No	Biotics Data Model Overview
ALLIANCE	alliance_key_bcd	VARCHAR2(20)	NULL	No	No	Ecoregions: Alliances
ALLIANCE	alliance_master	VARCHAR2(100)	NULL	No	No	Element Tracking
ALLIANCE	alliance_num	NUMBER	NULL	No	No	Higher Taxonomy
ALLIANCE	alliance_origin_date	DATE	NOT NULL	No	No
ALLIANCE	alliance_summary	VARCHAR2(4000)	NULL	No	No
ALLIANCE	associations_defined_ind	CHAR(1)	NOT NULL	No	No
ALLIANCE	classif_resp_id	NUMBER	NULL	No	Yes
ALLIANCE	classification_com	VARCHAR2(4000)	NULL	No	No
ALLIANCE	d_classification_status_id	NUMBER	NOT NULL	No	Yes
ALLIANCE	dynamics	VARCHAR2(4000)	NULL	No	No
ALLIANCE	environment	VARCHAR2(4000)	NULL	No	No
ALLIANCE	formatted_name	VARCHAR2(500)	NULL	No	No
ALLIANCE	higher_class_unit_id	NUMBER	NOT NULL	Yes	Yes
ALLIANCE	inactive_ind	CHAR(1)	NOT NULL	No	No
ALLIANCE	interal_alliance_notes	VARCHAR2(4000)	NULL	No	No
ALLIANCE	key_field_characteristics	VARCHAR2(2000)	NULL	No	No
ALLIANCE	maint_resp_id	NUMBER	NULL	No	Yes
ALLIANCE	nations_of_occurrence	VARCHAR2(200)	NULL	No	No
ALLIANCE	optional_1	VARCHAR2(4000)	NULL	No	No
ALLIANCE	optional_2	VARCHAR2(4000)	NULL	No	No
ALLIANCE	optional_3	VARCHAR2(4000)	NULL	No	No
ALLIANCE	optional_4	VARCHAR2(4000)	NULL	No	No
ALLIANCE	optional_5	VARCHAR2(4000)	NULL	No	No
ALLIANCE	physiognomic_summary	VARCHAR2(4000)	NULL	No	No
ALLIANCE	range_com	VARCHAR2(4000)	NULL	No	No
ALLIANCE	rec_create_date	DATE	NOT NULL	No	No
ALLIANCE	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ALLIANCE	rec_last_mod_date	DATE	NULL	No	No
ALLIANCE	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ALLIANCE	related_community_com	VARCHAR2(2000)	NULL	No	No
ALLIANCE	remove_from_std_authorized_by	VARCHAR2(50)	NULL	No	No
ALLIANCE	remove_from_std_com	VARCHAR2(2000)	NULL	No	No
ALLIANCE	remove_from_std_date	DATE	NULL	No	No
ALLIANCE	similar_alliance_com	VARCHAR2(2000)	NULL	No	No
ALLIANCE	translated_name	VARCHAR2(200)	NULL	No	No
ALLIANCE	vegetation	CLOB	NULL	No	No
ALLIANCE	version_author	VARCHAR2(100)	NULL	No	No
ALLIANCE	version_date	DATE	NULL	No	No
ALLIANCE_COMPOSITION	alliance_composition_id	NUMBER	NOT NULL	Yes	No
ALLIANCE_COMPOSITION	characteristic_ind	CHAR(1)	NOT NULL	No	No	Alliances
ALLIANCE_COMPOSITION	composition_note	VARCHAR2(2000)	NULL	No	No
ALLIANCE_COMPOSITION	constant_ind	CHAR(1)	NOT NULL	No	No
ALLIANCE_COMPOSITION	d_constancy_id	NUMBER	NULL	No	Yes
ALLIANCE_COMPOSITION	d_lifeform_id	NUMBER	NULL	No	Yes
ALLIANCE_COMPOSITION	d_stratum_id	NUMBER	NULL	No	Yes
ALLIANCE_COMPOSITION	display_order	NUMBER	NULL	No	No
ALLIANCE_COMPOSITION	dominant_ind	CHAR(1)	NOT NULL	No	No
ALLIANCE_COMPOSITION	element_global_id	NUMBER	NOT NULL	No	Yes
ALLIANCE_COMPOSITION	higher_class_unit_id	NUMBER	NOT NULL	No	Yes
ALLIANCE_COMPOSITION	max_percent_cover	VARCHAR2(20)	NULL	No	No
ALLIANCE_COMPOSITION	min_percent_cover	VARCHAR2(20)	NULL	No	No
ALLIANCE_COMPOSITION	modal_percent_cover	NUMBER	NULL	No	Yes
ALLIANCE_COMPOSITION	rec_create_date	DATE	NOT NULL	No	No
ALLIANCE_COMPOSITION	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ALLIANCE_COMPOSITION	rec_last_mod_date	DATE	NULL	No	No
ALLIANCE_COMPOSITION	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ALLIANCE_ECOREGION	higher_class_unit_id	NUMBER	NOT NULL	Yes	Yes
ALLIANCE_ECOREGION	rec_create_date	DATE	NOT NULL	No	No
ALLIANCE_ECOREGION	rec_create_user	VARCHAR2(30)	NOT NULL	No	No	Ecoregions: Alliances
ALLIANCE_ECOREGION	rec_last_mod_date	DATE	NULL	No	No
ALLIANCE_ECOREGION	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ALLIANCE_ECOREGION	tnc_ecoregion_com	VARCHAR2(2000)	NULL	No	No
ALLIANCE_ECOREGION	usfs_ecoregion_com	VARCHAR2(2000)	NULL	No	No
ALLIANCE_HIGHER_TAXON	alliance_higher_taxon_id	NUMBER	NOT NULL	Yes	No
ALLIANCE_HIGHER_TAXON	alliance_higher_taxon_name	VARCHAR2(50)	NOT NULL	No	No	Alliances
ALLIANCE_HIGHER_TAXON	alliance_higher_taxon_note	VARCHAR2(2000)	NULL	No	No
ALLIANCE_HIGHER_TAXON	display_order	NUMBER	NULL	No	No
ALLIANCE_HIGHER_TAXON	higher_class_unit_id	NUMBER	NOT NULL	No	Yes
ALLIANCE_HIGHER_TAXON	rec_create_date	DATE	NOT NULL	No	No
ALLIANCE_HIGHER_TAXON	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ALLIANCE_HIGHER_TAXON	rec_last_mod_date	DATE	NULL	No	No
ALLIANCE_HIGHER_TAXON	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ALLIANCE_LINEAGE	alliance_lineage_id	NUMBER	NOT NULL	Yes	No
ALLIANCE_LINEAGE	display_order	NUMBER	NULL	No	No	Alliances
ALLIANCE_LINEAGE	predecessor_id	NUMBER	NOT NULL	No	Yes
ALLIANCE_LINEAGE	rec_create_date	DATE	NOT NULL	No	No
ALLIANCE_LINEAGE	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ALLIANCE_LINEAGE	rec_last_mod_date	DATE	NULL	No	No
ALLIANCE_LINEAGE	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ALLIANCE_LINEAGE	successor_id	NUMBER	NOT NULL	No	Yes
ALLIANCE_MANAGED_AREA	alliance_managed_area_id	NUMBER	NOT NULL	Yes	No
ALLIANCE_MANAGED_AREA	display_order	NUMBER	NULL	No	No	Alliances
ALLIANCE_MANAGED_AREA	higher_class_unit_id	NUMBER	NOT NULL	No	Yes
ALLIANCE_MANAGED_AREA	managed_area_agency_name	VARCHAR2(50)	NULL	No	No
ALLIANCE_MANAGED_AREA	managed_area_id	NUMBER	NOT NULL	No	Yes
ALLIANCE_MANAGED_AREA	presence_uncertain_ind	CHAR(1)	NOT NULL	No	No
ALLIANCE_MANAGED_AREA	rec_create_date	DATE	NOT NULL	No	No
ALLIANCE_MANAGED_AREA	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ALLIANCE_MANAGED_AREA	rec_last_mod_date	DATE	NULL	No	No
ALLIANCE_MANAGED_AREA	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ALLIANCE_NATION	alliance_nation_id	NUMBER	NOT NULL	Yes	No
ALLIANCE_NATION	display_order	NUMBER	NULL	No	No	Alliances
ALLIANCE_NATION	higher_class_unit_id	NUMBER	NOT NULL	No	Yes
ALLIANCE_NATION	nation_id	NUMBER	NOT NULL	No	Yes
ALLIANCE_NATION	presence_uncertain_ind	CHAR(1)	NOT NULL	No	No
ALLIANCE_NATION	rec_create_date	DATE	NOT NULL	No	No
ALLIANCE_NATION	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ALLIANCE_NATION	rec_last_mod_date	DATE	NULL	No	No
ALLIANCE_NATION	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ALLIANCE_OBS_MEMBERSHIP	alliance_obs_membership_id	NUMBER	NOT NULL	Yes	No
ALLIANCE_OBS_MEMBERSHIP	change_authority	VARCHAR2(100)	NULL	No	No	Alliances
ALLIANCE_OBS_MEMBERSHIP	change_date	DATE	NULL	No	No
ALLIANCE_OBS_MEMBERSHIP	change_reason	VARCHAR2(1000)	NULL	No	No
ALLIANCE_OBS_MEMBERSHIP	display_order	NUMBER	NULL	No	No
ALLIANCE_OBS_MEMBERSHIP	higher_class_unit_id	NUMBER	NOT NULL	No	Yes
ALLIANCE_OBS_MEMBERSHIP	obsolete_formation	VARCHAR2(100)	NOT NULL	No	No
ALLIANCE_OBS_MEMBERSHIP	rec_create_date	DATE	NOT NULL	No	No
ALLIANCE_OBS_MEMBERSHIP	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ALLIANCE_OBS_MEMBERSHIP	rec_last_mod_date	DATE	NULL	No	No
ALLIANCE_OBS_MEMBERSHIP	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ALLIANCE_OBS_NAME	alliance_obs_name_id	NUMBER	NOT NULL	Yes	No
ALLIANCE_OBS_NAME	change_authority	VARCHAR2(100)	NULL	No	No	Alliances
ALLIANCE_OBS_NAME	change_date	DATE	NULL	No	No
ALLIANCE_OBS_NAME	change_reason	VARCHAR2(1000)	NULL	No	No
ALLIANCE_OBS_NAME	display_order	NUMBER	NULL	No	No
ALLIANCE_OBS_NAME	higher_class_unit_id	NUMBER	NOT NULL	No	Yes
ALLIANCE_OBS_NAME	obsolete_name	VARCHAR2(250)	NOT NULL	No	No
ALLIANCE_OBS_NAME	rec_create_date	DATE	NOT NULL	No	No
ALLIANCE_OBS_NAME	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ALLIANCE_OBS_NAME	rec_last_mod_date	DATE	NULL	No	No
ALLIANCE_OBS_NAME	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ALLIANCE_STAKEHOLDER	alliance_stakeholder_id	NUMBER	NOT NULL	Yes	No
ALLIANCE_STAKEHOLDER	d_stakeholder_comm_id	NUMBER	NOT NULL	No	Yes	Alliances
ALLIANCE_STAKEHOLDER	display_order	NUMBER	NULL	No	No
ALLIANCE_STAKEHOLDER	higher_class_unit_id	NUMBER	NOT NULL	No	Yes
ALLIANCE_STAKEHOLDER	rec_create_date	DATE	NOT NULL	No	No
ALLIANCE_STAKEHOLDER	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ALLIANCE_STAKEHOLDER	rec_last_mod_date	DATE	NULL	No	No
ALLIANCE_STAKEHOLDER	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ALLIANCE_STRUCTURE	alliance_structure_id	NUMBER	NOT NULL	Yes	No
ALLIANCE_STRUCTURE	d_height_class_id	NUMBER	NULL	No	Yes	Alliances
ALLIANCE_STRUCTURE	d_lifeform_id	NUMBER	NULL	No	Yes
ALLIANCE_STRUCTURE	d_stratum_id	NUMBER	NULL	No	Yes
ALLIANCE_STRUCTURE	display_order	NUMBER	NULL	No	No
ALLIANCE_STRUCTURE	higher_class_unit_id	NUMBER	NOT NULL	No	Yes
ALLIANCE_STRUCTURE	max_percent_cover	VARCHAR2(20)	NULL	No	No
ALLIANCE_STRUCTURE	min_percent_cover	VARCHAR2(20)	NULL	No	No
ALLIANCE_STRUCTURE	modal_percent_cover	NUMBER	NULL	No	Yes
ALLIANCE_STRUCTURE	rec_create_date	DATE	NOT NULL	No	No
ALLIANCE_STRUCTURE	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ALLIANCE_STRUCTURE	rec_last_mod_date	DATE	NULL	No	No
ALLIANCE_STRUCTURE	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ALLIANCE_TNC_ECOREG	alliance_tnc_ecoreg_id	NUMBER	NOT NULL	Yes	No
ALLIANCE_TNC_ECOREG	alliance_tnc_ecoreg_note	VARCHAR2(2000)	NULL	No	No
ALLIANCE_TNC_ECOREG	d_occurrence_status_id	NUMBER	NULL	No	Yes	Ecoregions: Alliances
ALLIANCE_TNC_ECOREG	d_tnc_ecoregion_id	NUMBER	NOT NULL	No	Yes
ALLIANCE_TNC_ECOREG	display_order	NUMBER	NULL	No	No
ALLIANCE_TNC_ECOREG	higher_class_unit_id	NUMBER	NOT NULL	No	Yes
ALLIANCE_TNC_ECOREG	rec_create_date	DATE	NOT NULL	No	No
ALLIANCE_TNC_ECOREG	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ALLIANCE_TNC_ECOREG	rec_last_mod_date	DATE	NULL	No	No
ALLIANCE_TNC_ECOREG	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ALLIANCE_USFS_ECOREG	alliance_usfs_ecoreg_id	NUMBER	NOT NULL	Yes	No
ALLIANCE_USFS_ECOREG	alliance_usfs_ecoreg_note	VARCHAR2(2000)	NULL	No	No
ALLIANCE_USFS_ECOREG	d_occurrence_status_id	NUMBER	NULL	No	Yes	Ecoregions: Alliances
ALLIANCE_USFS_ECOREG	display_order	NUMBER	NULL	No	No
ALLIANCE_USFS_ECOREG	higher_class_unit_id	NUMBER	NOT NULL	No	Yes
ALLIANCE_USFS_ECOREG	rec_create_date	DATE	NOT NULL	No	No
ALLIANCE_USFS_ECOREG	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ALLIANCE_USFS_ECOREG	rec_last_mod_date	DATE	NULL	No	No
ALLIANCE_USFS_ECOREG	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ALLIANCE_USFS_ECOREG	usfs_ecoregion_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAG	d_major_habitat_id	NUMBER	NULL	No	Yes
ANIMAL_CAG	element_global_id	NUMBER	NOT NULL	Yes	Yes	Animal Characterization: Global
ANIMAL_CAG	g_animal_general_desc	CLOB	NULL	No	No
ANIMAL_CAG	g_colonial_breeder_ind	CHAR(1)	NOT NULL	No	No	Biotics Data Model Overview
ANIMAL_CAG	g_diagnostic_characteristics	VARCHAR2(4000)	NULL	No	No	Element Occurrences: Views
ANIMAL_CAG	g_distant_migrant_ind	CHAR(1)	NOT NULL	No	No
ANIMAL_CAG	g_ecology_com	CLOB	NULL	No	No
ANIMAL_CAG	g_economic_com	VARCHAR2(4000)	NULL	No	No
ANIMAL_CAG	g_food_habits_com	VARCHAR2(4000)	NULL	No	No
ANIMAL_CAG	g_habitat_com	CLOB	NULL	No	No
ANIMAL_CAG	g_length	NUMBER	NULL	No	No
ANIMAL_CAG	g_local_migrant_ind	CHAR(1)	NOT NULL	No	No
ANIMAL_CAG	g_max_elev_feet	NUMBER	NULL	No	No
ANIMAL_CAG	g_max_elev_meters	NUMBER	NULL	No	No
ANIMAL_CAG	g_min_elev_feet	NUMBER	NULL	No	No
ANIMAL_CAG	g_min_elev_meters	NUMBER	NULL	No	No
ANIMAL_CAG	g_mobility_migration_com	VARCHAR2(4000)	NULL	No	No
ANIMAL_CAG	g_non_migrant_ind	CHAR(1)	NOT NULL	No	No
ANIMAL_CAG	g_phenology_com	VARCHAR2(4000)	NULL	No	No
ANIMAL_CAG	g_reproduction_com	CLOB	NULL	No	No
ANIMAL_CAG	g_weight	NUMBER	NULL	No	No
ANIMAL_CAG	g_width	NUMBER	NULL	No	No
ANIMAL_CAG	internal_notes	VARCHAR2(4000)	NULL	No	No
ANIMAL_CAG	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAG	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAG	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAG	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAG	version_author_name	VARCHAR2(100)	NULL	No	No
ANIMAL_CAG	version_date	DATE	NULL	No	No
ANIMAL_CAG_ESTUARINE_HAB	animal_cag_estuarine_hab_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAG_ESTUARINE_HAB	d_estuarine_habitat_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: Global
ANIMAL_CAG_ESTUARINE_HAB	display_order	NUMBER	NULL	No	No
ANIMAL_CAG_ESTUARINE_HAB	element_global_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAG_ESTUARINE_HAB	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAG_ESTUARINE_HAB	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAG_ESTUARINE_HAB	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAG_ESTUARINE_HAB	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAG_FOOD_HABITS	adult_ind	CHAR(1)	NOT NULL	No	No
ANIMAL_CAG_FOOD_HABITS	animal_cag_food_habits_id	NUMBER	NOT NULL	Yes	No	Animal Characterization: Global
ANIMAL_CAG_FOOD_HABITS	d_food_habits_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAG_FOOD_HABITS	display_order	NUMBER	NULL	No	No
ANIMAL_CAG_FOOD_HABITS	element_global_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAG_FOOD_HABITS	immature_ind	CHAR(1)	NOT NULL	No	No
ANIMAL_CAG_FOOD_HABITS	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAG_FOOD_HABITS	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAG_FOOD_HABITS	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAG_FOOD_HABITS	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAG_LACUS_HAB	animal_cag_lacus_hab_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAG_LACUS_HAB	d_lacustrine_habitat_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: Global
ANIMAL_CAG_LACUS_HAB	display_order	NUMBER	NULL	No	No
ANIMAL_CAG_LACUS_HAB	element_global_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAG_LACUS_HAB	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAG_LACUS_HAB	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAG_LACUS_HAB	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAG_LACUS_HAB	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAG_MARINE_HAB	animal_cag_marine_hab_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAG_MARINE_HAB	d_marine_habitat_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: Global
ANIMAL_CAG_MARINE_HAB	display_order	NUMBER	NULL	No	No
ANIMAL_CAG_MARINE_HAB	element_global_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAG_MARINE_HAB	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAG_MARINE_HAB	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAG_MARINE_HAB	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAG_MARINE_HAB	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAG_PALUS_HAB	animal_cag_palus_hab_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAG_PALUS_HAB	d_palustrine_habitat_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: Global
ANIMAL_CAG_PALUS_HAB	display_order	NUMBER	NULL	No	No
ANIMAL_CAG_PALUS_HAB	element_global_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAG_PALUS_HAB	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAG_PALUS_HAB	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAG_PALUS_HAB	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAG_PALUS_HAB	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAG_PHENOLOGY	adult_ind	CHAR(1)	NOT NULL	No	No
ANIMAL_CAG_PHENOLOGY	animal_cag_phenology_id	NUMBER	NOT NULL	Yes	No	Animal Characterization: Global
ANIMAL_CAG_PHENOLOGY	d_animal_phenology_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAG_PHENOLOGY	display_order	NUMBER	NULL	No	No
ANIMAL_CAG_PHENOLOGY	element_global_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAG_PHENOLOGY	immature_ind	CHAR(1)	NOT NULL	No	No
ANIMAL_CAG_PHENOLOGY	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAG_PHENOLOGY	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAG_PHENOLOGY	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAG_PHENOLOGY	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAG_RIVERINE_HAB	animal_cag_riverine_hab_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAG_RIVERINE_HAB	d_riverine_habitat_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: Global
ANIMAL_CAG_RIVERINE_HAB	display_order	NUMBER	NULL	No	No
ANIMAL_CAG_RIVERINE_HAB	element_global_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAG_RIVERINE_HAB	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAG_RIVERINE_HAB	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAG_RIVERINE_HAB	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAG_RIVERINE_HAB	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAG_SPEC_FACTOR	animal_cag_spec_factor_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAG_SPEC_FACTOR	d_special_hab_factor_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: Global
ANIMAL_CAG_SPEC_FACTOR	display_order	NUMBER	NULL	No	No
ANIMAL_CAG_SPEC_FACTOR	element_global_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAG_SPEC_FACTOR	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAG_SPEC_FACTOR	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAG_SPEC_FACTOR	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAG_SPEC_FACTOR	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAG_SUBTERR_HAB	animal_cag_subterr_hab_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAG_SUBTERR_HAB	d_subterranean_habitat_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: Global
ANIMAL_CAG_SUBTERR_HAB	display_order	NUMBER	NULL	No	No
ANIMAL_CAG_SUBTERR_HAB	element_global_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAG_SUBTERR_HAB	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAG_SUBTERR_HAB	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAG_SUBTERR_HAB	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAG_SUBTERR_HAB	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAG_TERR_HAB	animal_cag_terr_hab_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAG_TERR_HAB	d_terrestrial_habitat_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: Global
ANIMAL_CAG_TERR_HAB	display_order	NUMBER	NULL	No	No
ANIMAL_CAG_TERR_HAB	element_global_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAG_TERR_HAB	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAG_TERR_HAB	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAG_TERR_HAB	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAG_TERR_HAB	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAN	additional_topics	VARCHAR2(2000)	NULL	No	No
ANIMAL_CAN	element_national_id	NUMBER	NOT NULL	Yes	Yes	Animal Characterization: National
ANIMAL_CAN	internal_notes	VARCHAR2(4000)	NULL	No	No
ANIMAL_CAN	n_commercial_species_ind	CHAR(1)	NOT NULL	No	No	Biotics Data Model Overview
ANIMAL_CAN	n_distant_migrant_ind	CHAR(1)	NOT NULL	No	No
ANIMAL_CAN	n_ecology_com	CLOB	NULL	No	No
ANIMAL_CAN	n_economic_com	VARCHAR2(4000)	NULL	No	No
ANIMAL_CAN	n_food_habits_com	VARCHAR2(4000)	NULL	No	No
ANIMAL_CAN	n_fur_bearer_ind	CHAR(1)	NOT NULL	No	No
ANIMAL_CAN	n_game_species_ind	CHAR(1)	NOT NULL	No	No
ANIMAL_CAN	n_habitat_com	CLOB	NULL	No	No
ANIMAL_CAN	n_id_com	VARCHAR2(4000)	NULL	No	No
ANIMAL_CAN	n_local_migrant_ind	CHAR(1)	NOT NULL	No	No
ANIMAL_CAN	n_max_elev_feet	NUMBER	NULL	No	No
ANIMAL_CAN	n_max_elev_meters	NUMBER	NULL	No	No
ANIMAL_CAN	n_migration_mobility_com	VARCHAR2(4000)	NULL	No	No
ANIMAL_CAN	n_min_elev_feet	NUMBER	NULL	No	No
ANIMAL_CAN	n_min_elev_meters	NUMBER	NULL	No	No
ANIMAL_CAN	n_non_migrant_ind	CHAR(1)	NULL	No	No
ANIMAL_CAN	n_phenology_com	VARCHAR2(4000)	NULL	No	No
ANIMAL_CAN	n_prot_nongame_species_ind	CHAR(1)	NOT NULL	No	No
ANIMAL_CAN	n_reproduction_com	CLOB	NULL	No	No
ANIMAL_CAN	n_sport_fish_ind	CHAR(1)	NOT NULL	No	No
ANIMAL_CAN	n_subspecies_com	VARCHAR2(4000)	NULL	No	No
ANIMAL_CAN	n_within_borders_migrant_ind	CHAR(1)	NOT NULL	No	No
ANIMAL_CAN	nbreed_bcd	CHAR(1)	NULL	No	No
ANIMAL_CAN	nirregapp_bcd	CHAR(1)	NULL	No	No
ANIMAL_CAN	nmigrant_trans_bcd	CHAR(1)	NULL	No	No
ANIMAL_CAN	nwinter_bcd	CHAR(1)	NULL	No	No
ANIMAL_CAN	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAN	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAN	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAN	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAN	version_author_name	VARCHAR2(100)	NULL	No	No
ANIMAL_CAN	version_date	DATE	NULL	No	No
ANIMAL_CAN_ECOREGION	animal_can_ecoregion_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAN_ECOREGION	animal_can_ecoregion_note	VARCHAR2(2000)	NULL	No	No	Animal Characterization: National
ANIMAL_CAN_ECOREGION	d_migrant_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAN_ECOREGION	d_national_ecoregion_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAN_ECOREGION	d_occurrence_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAN_ECOREGION	d_origin_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAN_ECOREGION	date_assessed	DATE	NULL	No	No
ANIMAL_CAN_ECOREGION	display_order	NUMBER	NULL	No	No
ANIMAL_CAN_ECOREGION	element_national_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAN_ECOREGION	rec_create_date	DATE	NULL	No	No
ANIMAL_CAN_ECOREGION	rec_create_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAN_ECOREGION	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAN_ECOREGION	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAN_ECOREGION	reference_id	NUMBER	NULL	No	Yes
ANIMAL_CAN_EMAP	animal_can_emap_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAN_EMAP	animal_can_emap_note	VARCHAR2(2000)	NULL	No	No	Animal Characterization: National
ANIMAL_CAN_EMAP	d_migrant_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAN_EMAP	d_occurrence_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAN_EMAP	d_origin_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAN_EMAP	date_assessed	DATE	NULL	No	No
ANIMAL_CAN_EMAP	display_order	NUMBER	NULL	No	No
ANIMAL_CAN_EMAP	element_national_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAN_EMAP	emap_hexcode	VARCHAR2(20)	NOT NULL	No	No
ANIMAL_CAN_EMAP	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAN_EMAP	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAN_EMAP	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAN_EMAP	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAN_EMAP	reference_id	NUMBER	NULL	No	Yes
ANIMAL_CAN_ESTUARINE_HAB	animal_can_estuarine_hab_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAN_ESTUARINE_HAB	d_estuarine_habitat_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: National
ANIMAL_CAN_ESTUARINE_HAB	display_order	NUMBER	NULL	No	No
ANIMAL_CAN_ESTUARINE_HAB	element_national_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAN_ESTUARINE_HAB	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAN_ESTUARINE_HAB	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAN_ESTUARINE_HAB	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAN_ESTUARINE_HAB	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAN_KEYWORD	animal_can_keyword_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAN_KEYWORD	d_ca_keyword_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: National
ANIMAL_CAN_KEYWORD	display_order	NUMBER	NULL	No	No
ANIMAL_CAN_KEYWORD	element_national_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAN_KEYWORD	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAN_KEYWORD	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAN_KEYWORD	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAN_KEYWORD	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAN_LACUS_HAB	animal_can_lacus_hab_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAN_LACUS_HAB	d_lacustrine_habitat_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: National
ANIMAL_CAN_LACUS_HAB	display_order	NUMBER	NULL	No	No
ANIMAL_CAN_LACUS_HAB	element_national_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAN_LACUS_HAB	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAN_LACUS_HAB	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAN_LACUS_HAB	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAN_LACUS_HAB	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAN_LOCAL_JURIS	animal_can_local_juris_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAN_LOCAL_JURIS	animal_can_local_juris_note	VARCHAR2(2000)	NULL	No	No	Animal Characterization: National
ANIMAL_CAN_LOCAL_JURIS	d_local_jurisdiction_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAN_LOCAL_JURIS	d_migrant_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAN_LOCAL_JURIS	d_occurrence_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAN_LOCAL_JURIS	d_origin_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAN_LOCAL_JURIS	date_assessed	DATE	NULL	No	No
ANIMAL_CAN_LOCAL_JURIS	display_order	NUMBER	NULL	No	No
ANIMAL_CAN_LOCAL_JURIS	element_national_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAN_LOCAL_JURIS	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAN_LOCAL_JURIS	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAN_LOCAL_JURIS	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAN_LOCAL_JURIS	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAN_LOCAL_JURIS	reference_id	NUMBER	NULL	No	Yes
ANIMAL_CAN_MARINE_HAB	animal_marine_hab_id	VARCHAR2(20)	NOT NULL	Yes	No
ANIMAL_CAN_MARINE_HAB	d_marine_habitat_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: National
ANIMAL_CAN_MARINE_HAB	display_order	NUMBER	NULL	No	No
ANIMAL_CAN_MARINE_HAB	element_national_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAN_MARINE_HAB	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAN_MARINE_HAB	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAN_MARINE_HAB	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAN_MARINE_HAB	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAN_PALUS_HAB	animal_can_palus_hab_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAN_PALUS_HAB	d_palustrine_habitat_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: National
ANIMAL_CAN_PALUS_HAB	display_order	NUMBER	NULL	No	No
ANIMAL_CAN_PALUS_HAB	element_national_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAN_PALUS_HAB	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAN_PALUS_HAB	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAN_PALUS_HAB	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAN_PALUS_HAB	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAN_RIVERINE_HAB	animal_can_riverine_hab_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAN_RIVERINE_HAB	d_riverine_habitat_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: National
ANIMAL_CAN_RIVERINE_HAB	display_order	NUMBER	NULL	No	No
ANIMAL_CAN_RIVERINE_HAB	element_national_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAN_RIVERINE_HAB	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAN_RIVERINE_HAB	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAN_RIVERINE_HAB	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAN_RIVERINE_HAB	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAN_SEAS_PHEN	animal_can_seas_phen_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAN_SEAS_PHEN	d_animal_phen_season_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: National
ANIMAL_CAN_SEAS_PHEN	d_animal_seasonal_phen_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAN_SEAS_PHEN	display_order	NUMBER	NULL	No	No
ANIMAL_CAN_SEAS_PHEN	element_national_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAN_SEAS_PHEN	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAN_SEAS_PHEN	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAN_SEAS_PHEN	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAN_SEAS_PHEN	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAN_SPEC_FACTOR	animal_can_spec_factor_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAN_SPEC_FACTOR	d_special_hab_factor_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: National
ANIMAL_CAN_SPEC_FACTOR	display_order	NUMBER	NULL	No	No
ANIMAL_CAN_SPEC_FACTOR	element_national_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAN_SPEC_FACTOR	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAN_SPEC_FACTOR	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAN_SPEC_FACTOR	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAN_SPEC_FACTOR	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAN_STATE	animal_can_state_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAN_STATE	animal_can_state_note	VARCHAR2(2000)	NULL	No	No	Animal Characterization: National
ANIMAL_CAN_STATE	d_migrant_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAN_STATE	d_occurrence_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAN_STATE	d_origin_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAN_STATE	d_state_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAN_STATE	date_assessed	DATE	NULL	No	No
ANIMAL_CAN_STATE	display_order	NUMBER	NULL	No	No
ANIMAL_CAN_STATE	element_national_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAN_STATE	rec_create_date	DATE	NULL	No	No
ANIMAL_CAN_STATE	rec_create_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAN_STATE	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAN_STATE	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAN_STATE	reference_id	NUMBER	NULL	No	Yes
ANIMAL_CAN_SUBTERR_HAB	animal_can_subterr_hab_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAN_SUBTERR_HAB	d_subterranean_habitat_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: National
ANIMAL_CAN_SUBTERR_HAB	display_order	NUMBER	NULL	No	No
ANIMAL_CAN_SUBTERR_HAB	element_national_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAN_SUBTERR_HAB	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAN_SUBTERR_HAB	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAN_SUBTERR_HAB	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAN_SUBTERR_HAB	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAN_TERR_HAB	animal_can_terr_hab	NUMBER	NOT NULL	Yes	No
ANIMAL_CAN_TERR_HAB	d_terrestrial_habitat_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: National
ANIMAL_CAN_TERR_HAB	display_order	NUMBER	NULL	No	No
ANIMAL_CAN_TERR_HAB	element_national_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAN_TERR_HAB	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAN_TERR_HAB	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAN_TERR_HAB	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAN_TERR_HAB	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAN_WATERSHED	animal_can_watershed_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAN_WATERSHED	animal_can_watershed_note	VARCHAR2(2000)	NULL	No	No	Animal Characterization: National
ANIMAL_CAN_WATERSHED	d_migrant_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAN_WATERSHED	d_occurrence_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAN_WATERSHED	d_origin_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAN_WATERSHED	d_watershed_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAN_WATERSHED	date_assessed	DATE	NULL	No	No
ANIMAL_CAN_WATERSHED	display_order	NUMBER	NULL	No	No
ANIMAL_CAN_WATERSHED	element_national_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAN_WATERSHED	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAN_WATERSHED	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAN_WATERSHED	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAN_WATERSHED	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAN_WATERSHED	reference_id	NUMBER	NULL	No	Yes
ANIMAL_CAS	additional_topics	VARCHAR2(2000)	NULL	No	No
ANIMAL_CAS	element_subnational_id	NUMBER	NOT NULL	Yes	Yes	Animal Characterization: Subnational
ANIMAL_CAS	internal_notes	VARCHAR2(4000)	NULL	No	No
ANIMAL_CAS	rec_create_date	DATE	NOT NULL	No	No	Biotics Data Model Overview
ANIMAL_CAS	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAS	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAS	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAS	s_commercial_species_ind	CHAR(1)	NOT NULL	No	No
ANIMAL_CAS	s_distant_migrant_ind	CHAR(1)	NOT NULL	No	No
ANIMAL_CAS	s_ecology_com	CLOB	NULL	No	No
ANIMAL_CAS	s_economic_com	VARCHAR2(4000)	NULL	No	No
ANIMAL_CAS	s_food_habits_com	VARCHAR2(4000)	NULL	No	No
ANIMAL_CAS	s_fur_bearer_ind	CHAR(1)	NOT NULL	No	No
ANIMAL_CAS	s_game_species_ind	CHAR(1)	NOT NULL	No	No
ANIMAL_CAS	s_habitat_com	CLOB	NULL	No	No
ANIMAL_CAS	s_id_com	VARCHAR2(4000)	NULL	No	No
ANIMAL_CAS	s_local_migrant_ind	CHAR(1)	NOT NULL	No	No
ANIMAL_CAS	s_max_elev_feet	NUMBER	NULL	No	No
ANIMAL_CAS	s_max_elev_meters	NUMBER	NULL	No	No
ANIMAL_CAS	s_migration_mobility_com	VARCHAR2(4000)	NULL	No	No
ANIMAL_CAS	s_min_elev_feet	NUMBER	NULL	No	No
ANIMAL_CAS	s_min_level_meters	NUMBER	NULL	No	No
ANIMAL_CAS	s_non_migrant_ind	CHAR(1)	NOT NULL	No	No
ANIMAL_CAS	s_nongame_prot_species_ind	CHAR(1)	NOT NULL	No	No
ANIMAL_CAS	s_phenology_com	VARCHAR2(4000)	NULL	No	No
ANIMAL_CAS	s_reproduction_com	CLOB	NULL	No	No
ANIMAL_CAS	s_sport_fish_ind	CHAR(1)	NOT NULL	No	No
ANIMAL_CAS	s_subspecies_com	VARCHAR2(4000)	NULL	No	No
ANIMAL_CAS	s_within_borders_migrant_ind	CHAR(1)	NOT NULL	No	No
ANIMAL_CAS	sbreed_bcd	CHAR(1)	NULL	No	No
ANIMAL_CAS	sirregapp_bcd	CHAR(1)	NULL	No	No
ANIMAL_CAS	smigtrans_bcd	CHAR(1)	NULL	No	No
ANIMAL_CAS	swinter_bcd	CHAR(1)	NULL	No	No
ANIMAL_CAS	version_author_name	VARCHAR2(100)	NULL	No	No
ANIMAL_CAS	version_date	DATE	NULL	No	No
ANIMAL_CAS_COUNTY	animal_cas_county_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAS_COUNTY	animal_cas_county_note	VARCHAR2(2000)	NULL	No	No	Animal Characterization: Subnational
ANIMAL_CAS_COUNTY	d_county_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAS_COUNTY	d_migrant_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAS_COUNTY	d_occurrence_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAS_COUNTY	d_origin_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAS_COUNTY	date_assessed	DATE	NULL	No	No
ANIMAL_CAS_COUNTY	display_order	NUMBER	NULL	No	No
ANIMAL_CAS_COUNTY	element_subnational_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAS_COUNTY	rec_create_date	DATE	NULL	No	No
ANIMAL_CAS_COUNTY	rec_create_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAS_COUNTY	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAS_COUNTY	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAS_COUNTY	reference_id	NUMBER	NULL	No	Yes
ANIMAL_CAS_ECOREGION	animal_cas_ecoregion_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAS_ECOREGION	animal_cas_ecoregion_note	VARCHAR2(2000)	NULL	No	No	Animal Characterization: Subnational
ANIMAL_CAS_ECOREGION	d_migrant_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAS_ECOREGION	d_occurrence_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAS_ECOREGION	d_origin_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAS_ECOREGION	d_subnational_ecoregion_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAS_ECOREGION	date_assessed	DATE	NULL	No	No
ANIMAL_CAS_ECOREGION	display_order	NUMBER	NULL	No	No
ANIMAL_CAS_ECOREGION	element_subnational_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAS_ECOREGION	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAS_ECOREGION	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAS_ECOREGION	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAS_ECOREGION	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAS_ECOREGION	reference_id	NUMBER	NULL	No	Yes
ANIMAL_CAS_EMAP	animal_cas_emap_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAS_EMAP	animal_cas_emap_note	VARCHAR2(2000)	NULL	No	No	Animal Characterization: Subnational
ANIMAL_CAS_EMAP	d_migrant_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAS_EMAP	d_occurrence_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAS_EMAP	d_origin_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAS_EMAP	date_assessed	DATE	NULL	No	No
ANIMAL_CAS_EMAP	display_order	NUMBER	NULL	No	No
ANIMAL_CAS_EMAP	element_subnational_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAS_EMAP	emap_hexcode	VARCHAR2(20)	NOT NULL	No	No
ANIMAL_CAS_EMAP	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAS_EMAP	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAS_EMAP	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAS_EMAP	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAS_EMAP	reference_id	NUMBER	NULL	No	Yes
ANIMAL_CAS_ESTUARINE_HAB	animal_cas_estuarine_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAS_ESTUARINE_HAB	d_estuarine_habitat_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: Subnational
ANIMAL_CAS_ESTUARINE_HAB	display_order	NUMBER	NULL	No	No
ANIMAL_CAS_ESTUARINE_HAB	element_subnational_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAS_ESTUARINE_HAB	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAS_ESTUARINE_HAB	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAS_ESTUARINE_HAB	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAS_ESTUARINE_HAB	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAS_KEYWORD	animal_cas_keyword_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAS_KEYWORD	d_ca_keyword_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: Subnational
ANIMAL_CAS_KEYWORD	display_order	NUMBER	NULL	No	No
ANIMAL_CAS_KEYWORD	element_subnational_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAS_KEYWORD	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAS_KEYWORD	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAS_KEYWORD	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAS_KEYWORD	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAS_LACUS_HAB	animal_cas_lacus_hab_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAS_LACUS_HAB	d_lacustrine_habitat_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: Subnational
ANIMAL_CAS_LACUS_HAB	display_order	NUMBER	NULL	No	No
ANIMAL_CAS_LACUS_HAB	element_subnational_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAS_LACUS_HAB	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAS_LACUS_HAB	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAS_LACUS_HAB	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAS_LACUS_HAB	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAS_LOCAL_JURIS	animal_cas_local_juris_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAS_LOCAL_JURIS	animal_cas_local_juris_note	VARCHAR2(2000)	NULL	No	No	Animal Characterization: Subnational
ANIMAL_CAS_LOCAL_JURIS	d_local_jurisdiction_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAS_LOCAL_JURIS	d_migrant_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAS_LOCAL_JURIS	d_occurrence_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAS_LOCAL_JURIS	d_origin_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAS_LOCAL_JURIS	date_assessed	DATE	NULL	No	No
ANIMAL_CAS_LOCAL_JURIS	display_order	NUMBER	NULL	No	No
ANIMAL_CAS_LOCAL_JURIS	element_subnational_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAS_LOCAL_JURIS	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAS_LOCAL_JURIS	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAS_LOCAL_JURIS	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAS_LOCAL_JURIS	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAS_LOCAL_JURIS	reference_id	NUMBER	NULL	No	Yes
ANIMAL_CAS_MARINE_HAB	animal_cas_marine_hab_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAS_MARINE_HAB	d_marine_habitat_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: Subnational
ANIMAL_CAS_MARINE_HAB	display_order	NUMBER	NULL	No	No
ANIMAL_CAS_MARINE_HAB	element_subnational_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAS_MARINE_HAB	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAS_MARINE_HAB	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAS_MARINE_HAB	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAS_MARINE_HAB	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAS_PALUS_HAB	animal_cas_palus_hab_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAS_PALUS_HAB	d_palustrine_habitat_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: Subnational
ANIMAL_CAS_PALUS_HAB	display_order	NUMBER	NULL	No	No
ANIMAL_CAS_PALUS_HAB	element_subnational_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAS_PALUS_HAB	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAS_PALUS_HAB	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAS_PALUS_HAB	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAS_PALUS_HAB	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAS_RIVERINE_HAB	animal_cas_riverine_hab_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAS_RIVERINE_HAB	d_riverine_habitat_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: Subnational
ANIMAL_CAS_RIVERINE_HAB	display_order	NUMBER	NULL	No	No
ANIMAL_CAS_RIVERINE_HAB	element_subnational_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAS_RIVERINE_HAB	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAS_RIVERINE_HAB	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAS_RIVERINE_HAB	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAS_RIVERINE_HAB	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAS_SEAS_PHEN	animal_cas_seas_phen_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAS_SEAS_PHEN	d_animal_phen_season_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: Subnational
ANIMAL_CAS_SEAS_PHEN	d_animal_seasonal_phen_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAS_SEAS_PHEN	display_order	NUMBER	NULL	No	No
ANIMAL_CAS_SEAS_PHEN	element_subnational_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAS_SEAS_PHEN	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAS_SEAS_PHEN	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAS_SEAS_PHEN	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAS_SEAS_PHEN	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAS_SPEC_FACTOR	animal_cas_spec_factor_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAS_SPEC_FACTOR	d_special_hab_factor_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: Subnational
ANIMAL_CAS_SPEC_FACTOR	display_order	NUMBER	NULL	No	No
ANIMAL_CAS_SPEC_FACTOR	element_subnational_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAS_SPEC_FACTOR	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAS_SPEC_FACTOR	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAS_SPEC_FACTOR	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAS_SPEC_FACTOR	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAS_SUBTERR_HAB	animal_cas_subterr_hab_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAS_SUBTERR_HAB	d_subterranean_habitat_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: Subnational
ANIMAL_CAS_SUBTERR_HAB	display_order	NUMBER	NULL	No	No
ANIMAL_CAS_SUBTERR_HAB	element_subnational_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAS_SUBTERR_HAB	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAS_SUBTERR_HAB	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAS_SUBTERR_HAB	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAS_SUBTERR_HAB	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAS_TERR_HAB	animal_cas_terr_hab_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAS_TERR_HAB	d_terrestrial_habitat_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: Subnational
ANIMAL_CAS_TERR_HAB	display_order	NUMBER	NULL	No	No
ANIMAL_CAS_TERR_HAB	element_subnational_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAS_TERR_HAB	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAS_TERR_HAB	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAS_TERR_HAB	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAS_TERR_HAB	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAS_WATERSHED	animal_cas_watershed_id	NUMBER	NOT NULL	Yes	No
ANIMAL_CAS_WATERSHED	animal_cas_watershed_note	VARCHAR2(2000)	NULL	No	No	Animal Characterization: Subnational
ANIMAL_CAS_WATERSHED	d_migrant_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAS_WATERSHED	d_occurrence_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAS_WATERSHED	d_origin_status_id	NUMBER	NULL	No	Yes
ANIMAL_CAS_WATERSHED	d_watershed_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAS_WATERSHED	date_assessed	VARCHAR2(20)	NULL	No	No
ANIMAL_CAS_WATERSHED	display_order	NUMBER	NULL	No	No
ANIMAL_CAS_WATERSHED	element_subnational_id	NUMBER	NOT NULL	No	Yes
ANIMAL_CAS_WATERSHED	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_CAS_WATERSHED	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_CAS_WATERSHED	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_CAS_WATERSHED	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_CAS_WATERSHED	reference_id	NUMBER	NULL	No	Yes
ANIMAL_EO_SPECS	eo_specs_detail_id	NUMBER	NOT NULL	Yes	Yes
ANIMAL_EO_SPECS	inferred_extent_distance	NUMBER	NULL	No	No
ANIMAL_EO_SPECS	inferred_extent_notes	VARCHAR2(4000)	NULL	No	No	EO Specs
ANIMAL_EO_SPECS	rec_create_date	DATE	NOT NULL	No	No
ANIMAL_EO_SPECS	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
ANIMAL_EO_SPECS	rec_last_mod_date	DATE	NULL	No	No
ANIMAL_EO_SPECS	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
ANIMAL_EO_SPECS	sep_dist_suitable_habitat	NUMBER	NULL	No	No
ANIMAL_EO_SPECS	sep_dist_unsuitable_habitat	NUMBER	NULL	No	No
AUDIT_LOG	action_code	CHAR(1)	NOT NULL	No	No
AUDIT_LOG	audit_date	DATE	NOT NULL	No	No	System Tables: Audit Tracking
AUDIT_LOG	audit_log_id	NUMBER	NOT NULL	Yes	No
AUDIT_LOG	org_unit_id	NUMBER	NOT NULL	No	No
AUDIT_LOG	primary_key_id	NUMBER	NOT NULL	No	No
AUDIT_LOG	table_name	VARCHAR2(30)	NOT NULL	No	No
AUDIT_LOG	user_name	VARCHAR2(30)	NOT NULL	No	No
AUDIT_LOG_COLUMN	audit_log_column_id	NUMBER	NOT NULL	Yes	No
AUDIT_LOG_COLUMN	audit_log_id	NUMBER	NOT NULL	No	Yes	System Tables: Audit Tracking
AUDIT_LOG_COLUMN	column_name	VARCHAR2(30)	NULL	No	No
AUDIT_LOG_COLUMN	comments	VARCHAR2(2000)	NULL	No	No
AUDIT_LOG_COLUMN	old_value	VARCHAR2(4000)	NULL	No	No
AUDIT_LOG_FK	audit_log_fk_id	NUMBER	NOT NULL	Yes	No
AUDIT_LOG_FK	audit_log_id	NUMBER	NULL	No	Yes	System Tables: Audit Tracking
AUDIT_LOG_FK	fk_id	NUMBER	NULL	No	No
AUDIT_LOG_FK	fk_table_name	VARCHAR2(30)	NOT NULL	No	No
AUDIT_LOG_GUI	action_code	CHAR(1)	NOT NULL	No	No
AUDIT_LOG_GUI	audit_date	DATE	NOT NULL	No	No	System Tables: Audit Tracking
AUDIT_LOG_GUI	audit_log_column_id	NUMBER	NULL	No	No
AUDIT_LOG_GUI	audit_log_id	NUMBER	NOT NULL	No	No
AUDIT_LOG_GUI	audit_seq	NUMBER	NOT NULL	No	No
AUDIT_LOG_GUI	column_name	VARCHAR2(30)	NULL	No	No
AUDIT_LOG_GUI	comments	VARCHAR2(2000)	NULL	No	No
AUDIT_LOG_GUI	old_value	VARCHAR2(4000)	NULL	No	No
AUDIT_LOG_GUI	org_unit_id	NUMBER	NOT NULL	No	No
AUDIT_LOG_GUI	primary_key_id	NUMBER	NOT NULL	No	No
AUDIT_LOG_GUI	table_name	VARCHAR2(30)	NOT NULL	No	No
AUDIT_LOG_GUI	user_name	VARCHAR2(30)	NOT NULL	No	No
BCD_CODE_BCD	bcd_code_bcd	VARCHAR2(20)	NOT NULL	No	No
BCD_CODE_BCD	bcd_code_bcd_id	NUMBER	NOT NULL	Yes	No
BCD_CODE_BCD	shape_id	NUMBER	NOT NULL	No	No	Source Features
CA_KEYWORD_USED_BY	ca_keyword_used_by_id	NUMBER	NOT NULL	Yes	No
CA_KEYWORD_USED_BY	d_ca_keyword_id	NUMBER	NOT NULL	No	Yes	Animal Characterization: National
CA_KEYWORD_USED_BY	d_used_by_id	NUMBER	NOT NULL	No	Yes
CA_KEYWORD_USED_BY	display_order	NUMBER	NULL	No	No
CA_KEYWORD_USED_BY	rec_create_date	DATE	NOT NULL	No	No
CA_KEYWORD_USED_BY	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
CA_KEYWORD_USED_BY	rec_last_mod_date	DATE	NULL	No	No
CA_KEYWORD_USED_BY	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAG	characterization_resp	VARCHAR2(50)	NULL	No	No
COMM_CAG	d_ca_completeness_id	NUMBER	NULL	No	Yes
COMM_CAG	d_leaf_phenology_id	NUMBER	NULL	No	Yes	Biotics Data Model Overview
COMM_CAG	d_leaf_type_id	NUMBER	NULL	No	Yes	Community Characterization: Global
COMM_CAG	d_succession_stage_id	NUMBER	NULL	No	Yes
COMM_CAG	element_global_id	NUMBER	NOT NULL	Yes	Yes
COMM_CAG	g_adjacent_assoc_com	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_community_com	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_component_species_tax_com	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_data_analysis_methods	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_data_location	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_dynamic_processes_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_economic_com	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_environmental_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_geology	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_heterogeneity	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_hydrologic_influence	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_imagery_com	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_inv_sampling_analysis_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_key_environmental_factors	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_key_field_characteristics	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_max_elev_feet	NUMBER	NULL	No	No
COMM_CAG	g_max_elev_meters	NUMBER	NULL	No	No
COMM_CAG	g_mgmt_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_min_elev_feet	NUMBER	NULL	No	No
COMM_CAG	g_min_elev_meters	NUMBER	NULL	No	No
COMM_CAG	g_natural_disturbances	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_other_notable_species_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_permanent_plot_location	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_physiognomy_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_sampling_com	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_seasonal_variation	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_similar_association_com	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_size_com	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_soil_com	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_spatial_relations_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_succession_com	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_variability	VARCHAR2(4000)	NULL	No	No
COMM_CAG	g_vegetation_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAG	internal_notes	VARCHAR2(4000)	NULL	No	No
COMM_CAG	rec_create_date	DATE	NOT NULL	No	No
COMM_CAG	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAG	rec_last_mod_date	DATE	NULL	No	No
COMM_CAG	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAG	version_author_name	VARCHAR2(100)	NULL	No	No
COMM_CAG	version_date	DATE	NULL	No	No
COMM_CAG_ADJACENT_ASSOC	adjacent_assoc_comm_gbl_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_ADJACENT_ASSOC	adjacent_assoc_note	VARCHAR2(2000)	NULL	No	No
COMM_CAG_ADJACENT_ASSOC	comm_cag_adjacent_assoc_id	NUMBER	NOT NULL	Yes	No	Community Characterization: Global
COMM_CAG_ADJACENT_ASSOC	display_order	NUMBER	NULL	No	No
COMM_CAG_ADJACENT_ASSOC	element_global_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_ADJACENT_ASSOC	rec_create_date	DATE	NOT NULL	No	No
COMM_CAG_ADJACENT_ASSOC	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAG_ADJACENT_ASSOC	rec_last_mod_date	DATE	NULL	No	No
COMM_CAG_ADJACENT_ASSOC	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAG_ASPECT	comm_cag_aspect_id	NUMBER	NOT NULL	Yes	No
COMM_CAG_ASPECT	d_aspect_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_ASPECT	display_order	NUMBER	NULL	No	No	Community Characterization: Global
COMM_CAG_ASPECT	element_global_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_ASPECT	rec_create_date	DATE	NOT NULL	No	No
COMM_CAG_ASPECT	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAG_ASPECT	rec_last_mod_date	DATE	NULL	No	No
COMM_CAG_ASPECT	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAG_CLASSIFIERS	classifier_note	VARCHAR2(4000)	NULL	No	No
COMM_CAG_CLASSIFIERS	comm_cag_classifiers_id	NUMBER	NOT NULL	Yes	No
COMM_CAG_CLASSIFIERS	d_classifier_critierion_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_CLASSIFIERS	d_classifier_primary_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_CLASSIFIERS	d_classifier_secondary_id	NUMBER	NULL	No	Yes
COMM_CAG_CLASSIFIERS	diagnostic_ind	CHAR(1)	NOT NULL	No	No
COMM_CAG_CLASSIFIERS	display_order	NUMBER	NULL	No	No
COMM_CAG_CLASSIFIERS	element_global_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_CLASSIFIERS_REQ	classifiers_com	VARCHAR2(4000)	NULL	No	No
COMM_CAG_CLASSIFIERS_REQ	comm_cag_classifiers_req_id	NUMBER	NOT NULL	Yes	No
COMM_CAG_CLASSIFIERS_REQ	cultivated_ind	CHAR(1)	NOT NULL	No	No
COMM_CAG_CLASSIFIERS_REQ	d_isolated_regions_wetland_id	NUMBER	NULL	No	Yes
COMM_CAG_CLASSIFIERS_REQ	d_land_cover_class_id	NUMBER	NULL	No	Yes
COMM_CAG_CLASSIFIERS_REQ	element_global_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_CLASSIFIERS_REQ	not_vascular_ind	CHAR(1)	NOT NULL	No	No
COMM_CAG_CLASSIFIERS_REQ	upland_ind	CHAR(1)	NOT NULL	No	No
COMM_CAG_CLASSIFIERS_REQ	wetland_ind	CHAR(1)	NOT NULL	No	No
COMM_CAG_COMPOSITION	characteristic_ind	CHAR(1)	NOT NULL	No	No
COMM_CAG_COMPOSITION	comm_cag_composition_id	NUMBER	NOT NULL	Yes	No
COMM_CAG_COMPOSITION	composition_note	VARCHAR2(2000)	NULL	No	No	Community Characterization: Global
COMM_CAG_COMPOSITION	constant_ind	CHAR(1)	NOT NULL	No	No
COMM_CAG_COMPOSITION	d_constancy_id	NUMBER	NULL	No	Yes
COMM_CAG_COMPOSITION	d_lifeform_id	NUMBER	NULL	No	Yes
COMM_CAG_COMPOSITION	d_stratum_id	NUMBER	NULL	No	Yes
COMM_CAG_COMPOSITION	display_order	NUMBER	NULL	No	No
COMM_CAG_COMPOSITION	dominant_ind	CHAR(1)	NOT NULL	No	No
COMM_CAG_COMPOSITION	element_global_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_COMPOSITION	element_taxon_gbl_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_COMPOSITION	max_percent_cover	VARCHAR2(20)	NULL	No	No
COMM_CAG_COMPOSITION	min_percent_cover	VARCHAR2(20)	NULL	No	No
COMM_CAG_COMPOSITION	modal_percent_cover_id	NUMBER	NULL	No	Yes
COMM_CAG_COMPOSITION	rec_create_date	DATE	NOT NULL	No	No
COMM_CAG_COMPOSITION	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAG_COMPOSITION	rec_last_mod_date	DATE	NULL	No	No
COMM_CAG_COMPOSITION	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAG_EXT_PLOT	assignment_date	DATE	NULL	No	No
COMM_CAG_EXT_PLOT	comm_cag_ext_plot_id	NUMBER	NOT NULL	Yes	No
COMM_CAG_EXT_PLOT	county_name	VARCHAR2(60)	NULL	No	No
COMM_CAG_EXT_PLOT	d_element_rel_confidence_id	NUMBER	NULL	No	Yes
COMM_CAG_EXT_PLOT	d_plot_type_id	NUMBER	NULL	No	Yes
COMM_CAG_EXT_PLOT	electronic_ind	CHAR(1)	NULL	No	No
COMM_CAG_EXT_PLOT	element_global_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_EXT_PLOT	managed_area_alias	VARCHAR2(100)	NULL	No	No
COMM_CAG_EXT_PLOT	plot_cd	VARCHAR2(20)	NULL	No	No
COMM_CAG_EXT_PLOT	plot_notes	VARCHAR2(4000)	NULL	No	No
COMM_CAG_EXT_PLOT	reference_cd	CHAR(12)	NULL	No	No
COMM_CAG_EXT_PLOT	shelf_note	VARCHAR2(1000)	NULL	No	No
COMM_CAG_EXT_PLOT	subnation_id	NUMBER	NULL	No	Yes
COMM_CAG_EXT_PLOT	survey_date	DATE	NULL	No	No
COMM_CAG_EXT_PLOT	survey_site	VARCHAR2(250)	NULL	No	No
COMM_CAG_HIGHER_TAXON	comm_cag_higher_taxon_id	NUMBER	NOT NULL	Yes	No
COMM_CAG_HIGHER_TAXON	display_order	NUMBER	NULL	No	No
COMM_CAG_HIGHER_TAXON	element_global_id	NUMBER	NOT NULL	No	Yes	Community Characterization: Global
COMM_CAG_HIGHER_TAXON	higher_taxon_name	VARCHAR2(50)	NOT NULL	No	No
COMM_CAG_HIGHER_TAXON	higher_taxon_note	VARCHAR2(2000)	NULL	No	No
COMM_CAG_HIGHER_TAXON	rec_create_date	DATE	NOT NULL	No	No
COMM_CAG_HIGHER_TAXON	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAG_HIGHER_TAXON	rec_last_mod_date	DATE	NULL	No	No
COMM_CAG_HIGHER_TAXON	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAG_HYDRO_MODIFIER	comm_cag_hydro_modifier_id	NUMBER	NOT NULL	Yes	No
COMM_CAG_HYDRO_MODIFIER	d_hydrologic_modifier_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_HYDRO_MODIFIER	display_order	NUMBER	NULL	No	No	Community Characterization: Global
COMM_CAG_HYDRO_MODIFIER	element_global_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_HYDRO_MODIFIER	rec_create_date	DATE	NOT NULL	No	No
COMM_CAG_HYDRO_MODIFIER	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAG_HYDRO_MODIFIER	rec_last_mod_date	DATE	NULL	No	No
COMM_CAG_HYDRO_MODIFIER	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAG_LANDFIRE	bps_cd	NUMBER	NULL	No	No
COMM_CAG_LANDFIRE	comm_cag_landfire_id	NUMBER	NOT NULL	Yes	No
COMM_CAG_LANDFIRE	d_fgdc_class_id	NUMBER	NULL	No	Yes
COMM_CAG_LANDFIRE	d_fgdc_division_id	NUMBER	NULL	No	Yes
COMM_CAG_LANDFIRE	d_fgdc_order_id	NUMBER	NULL	No	Yes
COMM_CAG_LANDFIRE	d_fgdc_subclass_id	NUMBER	NULL	No	Yes
COMM_CAG_LANDFIRE	d_landfire_category_id	NUMBER	NULL	No	Yes
COMM_CAG_LANDFIRE	d_lifeform_group_id	NUMBER	NULL	No	Yes
COMM_CAG_LANDFIRE	east_legend_ind	CHAR(1)	NULL	No	No
COMM_CAG_LANDFIRE	element_global_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_LANDFIRE	eslf_cd	NUMBER	NULL	No	No
COMM_CAG_LANDFIRE	evt_cd	NUMBER	NULL	No	No
COMM_CAG_LANDFIRE	landfire_com	VARCHAR2(4000)	NULL	No	No
COMM_CAG_LANDFIRE	west_legend_ind	CHAR(1)	NULL	No	No
COMM_CAG_LANDFORM	comm_cag_landform_id	NUMBER	NOT NULL	Yes	No
COMM_CAG_LANDFORM	d_landform_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_LANDFORM	display_order	NUMBER	NULL	No	No	Community Characterization: Global
COMM_CAG_LANDFORM	element_global_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_LANDFORM	rec_create_date	DATE	NOT NULL	No	No
COMM_CAG_LANDFORM	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAG_LANDFORM	rec_last_mod_date	DATE	NULL	No	No
COMM_CAG_LANDFORM	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAG_LATITUDE_ZONE	comm_cag_latitude_zone_id	NUMBER	NOT NULL	Yes	No
COMM_CAG_LATITUDE_ZONE	d_latitude_zone_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_LATITUDE_ZONE	display_order	NUMBER	NULL	No	No	Community Characterization: Global
COMM_CAG_LATITUDE_ZONE	element_global_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_LATITUDE_ZONE	rec_create_date	DATE	NOT NULL	No	No
COMM_CAG_LATITUDE_ZONE	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAG_LATITUDE_ZONE	rec_last_mod_date	DATE	NULL	No	No
COMM_CAG_LATITUDE_ZONE	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAG_OTHER_SPECIES	comm_cag_other_species_id	NUMBER	NOT NULL	Yes	No
COMM_CAG_OTHER_SPECIES	display_order	NUMBER	NULL	No	No
COMM_CAG_OTHER_SPECIES	element_global_id	NUMBER	NOT NULL	No	Yes	Community Characterization: Global
COMM_CAG_OTHER_SPECIES	other_notable_species_note	VARCHAR2(2000)	NULL	No	No
COMM_CAG_OTHER_SPECIES	other_species_taxon_gbl_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_OTHER_SPECIES	rec_create_date	DATE	NOT NULL	No	No
COMM_CAG_OTHER_SPECIES	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAG_OTHER_SPECIES	rec_last_mod_date	DATE	NULL	No	No
COMM_CAG_OTHER_SPECIES	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAG_SIMILAR_ASSOC	comm_cag_similar_assoc_id	NUMBER	NOT NULL	Yes	No
COMM_CAG_SIMILAR_ASSOC	display_order	NUMBER	NULL	No	No
COMM_CAG_SIMILAR_ASSOC	element_global_id	NUMBER	NOT NULL	No	Yes	Community Characterization: Global
COMM_CAG_SIMILAR_ASSOC	rec_create_date	DATE	NOT NULL	No	No
COMM_CAG_SIMILAR_ASSOC	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAG_SIMILAR_ASSOC	rec_last_mod_date	DATE	NULL	No	No
COMM_CAG_SIMILAR_ASSOC	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAG_SIMILAR_ASSOC	similar_assoc_comm_gbl_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_SIMILAR_ASSOC	similar_association_note	VARCHAR2(4000)	NULL	No	No
COMM_CAG_SLOPE	comm_cag_slope_id	NUMBER	NOT NULL	Yes	No
COMM_CAG_SLOPE	d_slope_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_SLOPE	display_order	NUMBER	NULL	No	No	Community Characterization: Global
COMM_CAG_SLOPE	element_global_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_SLOPE	rec_create_date	DATE	NOT NULL	No	No
COMM_CAG_SLOPE	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAG_SLOPE	rec_last_mod_date	DATE	NULL	No	No
COMM_CAG_SLOPE	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAG_SOIL_MOISTURE	comm_cag_soil_moisture_id	NUMBER	NOT NULL	Yes	No
COMM_CAG_SOIL_MOISTURE	d_comm_soil_moisture_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_SOIL_MOISTURE	display_order	NUMBER	NULL	No	No	Community Characterization: Global
COMM_CAG_SOIL_MOISTURE	element_global_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_SOIL_MOISTURE	rec_create_date	DATE	NOT NULL	No	No
COMM_CAG_SOIL_MOISTURE	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAG_SOIL_MOISTURE	rec_last_mod_date	DATE	NULL	No	No
COMM_CAG_SOIL_MOISTURE	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAG_SOIL_TYPE	comm_cag_soil_type_id	NUMBER	NOT NULL	Yes	No
COMM_CAG_SOIL_TYPE	display_order	NUMBER	NULL	No	No
COMM_CAG_SOIL_TYPE	element_global_id	NUMBER	NOT NULL	No	Yes	Community Characterization: Global
COMM_CAG_SOIL_TYPE	rec_create_date	DATE	NOT NULL	No	No
COMM_CAG_SOIL_TYPE	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAG_SOIL_TYPE	rec_last_mod_date	DATE	NULL	No	No
COMM_CAG_SOIL_TYPE	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAG_SOIL_TYPE	soil_type_desc	VARCHAR2(100)	NULL	No	No
COMM_CAG_SPATIAL_PATTERN	comm_cag_spatial_pattern_id	NUMBER	NOT NULL	Yes	No
COMM_CAG_SPATIAL_PATTERN	d_spatial_pattern_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_SPATIAL_PATTERN	display_order	NUMBER	NULL	No	No	Community Characterization: Global
COMM_CAG_SPATIAL_PATTERN	element_global_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_SPATIAL_PATTERN	rec_create_date	DATE	NOT NULL	No	No
COMM_CAG_SPATIAL_PATTERN	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAG_SPATIAL_PATTERN	rec_last_mod_date	DATE	NULL	No	No
COMM_CAG_SPATIAL_PATTERN	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAG_STRUCTURE	comm_cag_structure_id	NUMBER	NOT NULL	Yes	No
COMM_CAG_STRUCTURE	d_height_class_id	NUMBER	NULL	No	Yes
COMM_CAG_STRUCTURE	d_lifeform_id	NUMBER	NULL	No	Yes	Community Characterization: Global
COMM_CAG_STRUCTURE	d_stratum_id	NUMBER	NULL	No	Yes
COMM_CAG_STRUCTURE	display_order	NUMBER	NULL	No	No
COMM_CAG_STRUCTURE	element_global_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_STRUCTURE	max_percent_cover	VARCHAR2(20)	NULL	No	No
COMM_CAG_STRUCTURE	min_percent_cover	VARCHAR2(20)	NULL	No	No
COMM_CAG_STRUCTURE	modal_percent_cover_id	NUMBER	NULL	No	Yes
COMM_CAG_STRUCTURE	rec_create_date	DATE	NOT NULL	No	No
COMM_CAG_STRUCTURE	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAG_STRUCTURE	rec_last_mod_date	DATE	NULL	No	No
COMM_CAG_STRUCTURE	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAG_SUB_ASSOC	comm_cag_sub_assoc_id	NUMBER	NOT NULL	Yes	No
COMM_CAG_SUB_ASSOC	display_order	NUMBER	NULL	No	No
COMM_CAG_SUB_ASSOC	element_global_id	NUMBER	NOT NULL	No	Yes	Community Characterization: Global
COMM_CAG_SUB_ASSOC	rec_create_date	DATE	NOT NULL	No	No
COMM_CAG_SUB_ASSOC	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAG_SUB_ASSOC	rec_last_mod_date	DATE	NULL	No	No
COMM_CAG_SUB_ASSOC	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAG_SUB_ASSOC	sub_association_name	VARCHAR2(200)	NULL	No	No
COMM_CAG_SUB_ASSOC	sub_association_note	VARCHAR2(2000)	NULL	No	No
COMM_CAG_TOPO_POSITION	comm_cag_topo_position_id	NUMBER	NOT NULL	Yes	No
COMM_CAG_TOPO_POSITION	d_topo_position_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_TOPO_POSITION	display_order	NUMBER	NULL	No	No	Community Characterization: Global
COMM_CAG_TOPO_POSITION	element_global_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_TOPO_POSITION	rec_create_date	DATE	NOT NULL	No	No
COMM_CAG_TOPO_POSITION	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAG_TOPO_POSITION	rec_last_mod_date	DATE	NULL	No	No
COMM_CAG_TOPO_POSITION	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAG_UNVEG_SURF	comm_cag_unveg_surf_id	NUMBER	NOT NULL	Yes	No
COMM_CAG_UNVEG_SURF	d_unvegetated_surface_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_UNVEG_SURF	display_order	NUMBER	NULL	No	No	Community Characterization: Global
COMM_CAG_UNVEG_SURF	element_global_id	NUMBER	NOT NULL	No	Yes
COMM_CAG_UNVEG_SURF	max_percent_cover	VARCHAR2(20)	NULL	No	No
COMM_CAG_UNVEG_SURF	min_percent_cover	VARCHAR2(20)	NULL	No	No
COMM_CAG_UNVEG_SURF	modal_percent_cover_id	NUMBER	NULL	No	Yes
COMM_CAG_UNVEG_SURF	rec_create_date	DATE	NOT NULL	No	No
COMM_CAG_UNVEG_SURF	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAG_UNVEG_SURF	rec_last_mod_date	DATE	NULL	No	No
COMM_CAG_UNVEG_SURF	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAL	additional_topics	VARCHAR2(2000)	NULL	No	No
COMM_CAL	classification_com	VARCHAR2(4000)	NULL	No	No
COMM_CAL	comm_cal_id	NUMBER	NOT NULL	Yes	No	Biotics Data Model Overview
COMM_CAL	comm_cal_ou_uid	NUMBER	NOT NULL	No	No	Community Characterization: Local
COMM_CAL	comm_cal_seq_uid	NUMBER	NOT NULL	No	No	Community Characterization: Local/Geog Area
COMM_CAL	conservation_site_id	NUMBER	NULL	No	Yes
COMM_CAL	d_county_id	NUMBER	NULL	No	Yes
COMM_CAL	d_leaf_phenology_id	NUMBER	NULL	No	Yes
COMM_CAL	d_leaf_type_id	NUMBER	NULL	No	Yes
COMM_CAL	d_occurrence_status_id	NUMBER	NULL	No	Yes
COMM_CAL	d_succession_stage_id	NUMBER	NULL	No	Yes
COMM_CAL	d_tnc_ecoregion_id	NUMBER	NULL	No	Yes
COMM_CAL	distribution_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAL	element_global_id	NUMBER	NOT NULL	No	Yes
COMM_CAL	internal_notes	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_adjacent_assoc_com	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_community_com	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_component_species_tax_com	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_data_analysis_methods	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_data_location	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_dynamic_processes_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_economic_com	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_environmental_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_geology	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_heterogeneity	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_hydrologic_influence	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_imagery_com	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_inv_sampling_analysis_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_key_environmental_factors	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_key_field_characteristics	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_max_elev_feet	NUMBER	NULL	No	No
COMM_CAL	l_max_elev_meters	NUMBER	NULL	No	No
COMM_CAL	l_mgmt_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_min_elev_feet	NUMBER	NULL	No	No
COMM_CAL	l_min_elev_meters	NUMBER	NULL	No	No
COMM_CAL	l_natural_disturbances_com	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_other_notable_species_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_permanent_plot_location	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_physiognomy_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_sampling_com	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_seasonal_variation	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_similar_association_com	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_size_com	VARCHAR2(2000)	NULL	No	No
COMM_CAL	l_soil_com	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_spatial_relations_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_succession_com	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_variability	VARCHAR2(4000)	NULL	No	No
COMM_CAL	l_vegetation_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAL	local_scientific_name	VARCHAR2(200)	NULL	No	No
COMM_CAL	managed_area_id	NUMBER	NULL	No	Yes
COMM_CAL	map_unit_sum	VARCHAR2(2000)	NULL	No	No
COMM_CAL	rec_create_date	DATE	NOT NULL	No	No
COMM_CAL	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAL	rec_last_mod_date	DATE	NULL	No	No
COMM_CAL	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAL	usfs_ecoregion_id	NUMBER	NULL	No	Yes
COMM_CAL	version_author_name	VARCHAR2(100)	NULL	No	No
COMM_CAL	version_date	DATE	NULL	No	No
COMM_CAL_ADJACENT_ASSOC	adjacent_assoc_comm_gbl_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_ADJACENT_ASSOC	adjacent_assoc_note	VARCHAR2(2000)	NULL	No	No
COMM_CAL_ADJACENT_ASSOC	comm_cal_adjacent_assoc_id	NUMBER	NOT NULL	Yes	No	Community Characterization: Local
COMM_CAL_ADJACENT_ASSOC	comm_cal_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_ADJACENT_ASSOC	display_order	NUMBER	NULL	No	No
COMM_CAL_ADJACENT_ASSOC	rec_create_date	DATE	NOT NULL	No	No
COMM_CAL_ADJACENT_ASSOC	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAL_ADJACENT_ASSOC	rec_last_mod_date	DATE	NULL	No	No
COMM_CAL_ADJACENT_ASSOC	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAL_ASPECT	comm_cal_aspect_id	NUMBER	NOT NULL	Yes	No
COMM_CAL_ASPECT	comm_cal_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_ASPECT	d_aspect_id	NUMBER	NOT NULL	No	Yes	Community Characterization: Local
COMM_CAL_ASPECT	display_order	NUMBER	NULL	No	No
COMM_CAL_ASPECT	rec_create_date	DATE	NOT NULL	No	No
COMM_CAL_ASPECT	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAL_ASPECT	rec_last_mod_date	DATE	NULL	No	No
COMM_CAL_ASPECT	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAL_COMPOSITION	characteristic_ind	CHAR(1)	NOT NULL	No	No
COMM_CAL_COMPOSITION	comm_cal_composition_id	NUMBER	NOT NULL	Yes	No
COMM_CAL_COMPOSITION	comm_cal_composition_note	VARCHAR2(2000)	NULL	No	No	Community Characterization: Local
COMM_CAL_COMPOSITION	comm_cal_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_COMPOSITION	constant_ind	CHAR(1)	NOT NULL	No	No
COMM_CAL_COMPOSITION	d_constancy_id	NUMBER	NULL	No	Yes
COMM_CAL_COMPOSITION	d_lifeform_id	NUMBER	NULL	No	Yes
COMM_CAL_COMPOSITION	d_stratum_id	NUMBER	NULL	No	Yes
COMM_CAL_COMPOSITION	display_order	NUMBER	NULL	No	No
COMM_CAL_COMPOSITION	dominant_ind	CHAR(1)	NOT NULL	No	No
COMM_CAL_COMPOSITION	element_taxon_gbl_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_COMPOSITION	max_percent_cover	VARCHAR2(20)	NULL	No	No
COMM_CAL_COMPOSITION	min_percent_cover	VARCHAR2(20)	NULL	No	No
COMM_CAL_COMPOSITION	modal_percent_cover_id	NUMBER	NULL	No	Yes
COMM_CAL_COMPOSITION	rec_create_date	DATE	NOT NULL	No	No
COMM_CAL_COMPOSITION	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAL_COMPOSITION	rec_last_mod_date	DATE	NULL	No	No
COMM_CAL_COMPOSITION	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAL_EMAP	comm_cal_emap_id	NUMBER	NOT NULL	Yes	No
COMM_CAL_EMAP	comm_cal_emap_note	VARCHAR2(2000)	NULL	No	No
COMM_CAL_EMAP	comm_cal_id	NUMBER	NOT NULL	No	Yes	Community Characterization: Local
COMM_CAL_EMAP	d_occurrence_status_id	NUMBER	NULL	No	Yes
COMM_CAL_EMAP	date_assessed	DATE	NULL	No	No
COMM_CAL_EMAP	display_order	NUMBER	NULL	No	No
COMM_CAL_EMAP	emap_hexcode	VARCHAR2(20)	NOT NULL	No	No
COMM_CAL_EMAP	rec_create_date	DATE	NOT NULL	No	No
COMM_CAL_EMAP	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAL_EMAP	rec_last_mod_date	DATE	NULL	No	No
COMM_CAL_EMAP	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAL_EMAP	reference_id	NUMBER	NULL	No	Yes
COMM_CAL_EXT	comm_cal_ext_id	NUMBER	NOT NULL	Yes	No
COMM_CAL_EXT	comm_cal_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_EXT	occurrence_status_com	VARCHAR2(4000)	NULL	No	No
COMM_CAL_HIGHER_TAXON	comm_cal_higher_taxon_id	NUMBER	NOT NULL	Yes	No
COMM_CAL_HIGHER_TAXON	comm_cal_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_HIGHER_TAXON	display_order	NUMBER	NULL	No	No	Community Characterization: Local
COMM_CAL_HIGHER_TAXON	higher_taxon_name	VARCHAR2(50)	NOT NULL	No	No
COMM_CAL_HIGHER_TAXON	higher_taxon_note	VARCHAR2(2000)	NULL	No	No
COMM_CAL_HIGHER_TAXON	rec_create_date	DATE	NOT NULL	No	No
COMM_CAL_HIGHER_TAXON	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAL_HIGHER_TAXON	rec_last_mod_date	DATE	NULL	No	No
COMM_CAL_HIGHER_TAXON	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAL_HYDRO_MODIFIER	comm_cal_hydro_modifier_id	NUMBER	NOT NULL	Yes	No
COMM_CAL_HYDRO_MODIFIER	comm_cal_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_HYDRO_MODIFIER	d_hydrologic_modifier_id	NUMBER	NOT NULL	No	Yes	Community Characterization: Local
COMM_CAL_HYDRO_MODIFIER	display_order	NUMBER	NULL	No	No
COMM_CAL_HYDRO_MODIFIER	rec_create_date	DATE	NOT NULL	No	No
COMM_CAL_HYDRO_MODIFIER	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAL_HYDRO_MODIFIER	rec_last_mod_date	DATE	NULL	No	No
COMM_CAL_HYDRO_MODIFIER	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAL_KEYWORD	comm_cal_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_KEYWORD	comm_cal_keyword_id	NUMBER	NOT NULL	Yes	No
COMM_CAL_KEYWORD	d_ca_keyword_id	NUMBER	NOT NULL	No	Yes	Community Characterization: Local
COMM_CAL_KEYWORD	display_order	NUMBER	NULL	No	No
COMM_CAL_KEYWORD	rec_create_date	DATE	NOT NULL	No	No
COMM_CAL_KEYWORD	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAL_KEYWORD	rec_last_mod_date	DATE	NULL	No	No
COMM_CAL_KEYWORD	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAL_LANDFORM	comm_cal_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_LANDFORM	comm_cal_landform_id	NUMBER	NOT NULL	Yes	No
COMM_CAL_LANDFORM	d_landform_id	NUMBER	NOT NULL	No	Yes	Community Characterization: Local
COMM_CAL_LANDFORM	display_order	NUMBER	NULL	No	No
COMM_CAL_LANDFORM	rec_create_date	DATE	NOT NULL	No	No
COMM_CAL_LANDFORM	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAL_LANDFORM	rec_last_mod_date	DATE	NULL	No	No
COMM_CAL_LANDFORM	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAL_LATITUDE_ZONE	comm_cal_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_LATITUDE_ZONE	comm_cal_latitude_zone_id	NUMBER	NOT NULL	Yes	No
COMM_CAL_LATITUDE_ZONE	d_latitude_zone_id	NUMBER	NOT NULL	No	Yes	Community Characterization: Local
COMM_CAL_LATITUDE_ZONE	display_order	NUMBER	NULL	No	No
COMM_CAL_LATITUDE_ZONE	rec_create_date	DATE	NOT NULL	No	No
COMM_CAL_LATITUDE_ZONE	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAL_LATITUDE_ZONE	rec_last_mod_date	DATE	NULL	No	No
COMM_CAL_LATITUDE_ZONE	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAL_MAP_UNIT	comm_cal_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_MAP_UNIT	comm_cal_map_unit_id	NUMBER	NOT NULL	Yes	No
COMM_CAL_MAP_UNIT	d_relationship_role_id	NUMBER	NOT NULL	No	Yes	Community Characterization: Local
COMM_CAL_MAP_UNIT	display_order	NUMBER	NULL	No	No
COMM_CAL_MAP_UNIT	map_unit	VARCHAR2(100)	NULL	No	No
COMM_CAL_MAP_UNIT	map_unit_note	VARCHAR2(2000	NULL	No	No
COMM_CAL_MAP_UNIT	rec_create_date	DATE	NOT NULL	No	No
COMM_CAL_MAP_UNIT	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAL_MAP_UNIT	rec_last_mod_date	DATE	NULL	No	No
COMM_CAL_MAP_UNIT	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAL_OTHER_SPECIES	comm_cal_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_OTHER_SPECIES	comm_cal_other_species_id	NUMBER	NOT NULL	Yes	No
COMM_CAL_OTHER_SPECIES	comm_cal_other_species_note	VARCHAR2(2000)	NULL	No	No	Community Characterization: Local
COMM_CAL_OTHER_SPECIES	display_order	NUMBER	NULL	No	No
COMM_CAL_OTHER_SPECIES	other_species_taxon_gbl_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_OTHER_SPECIES	rec_create_date	DATE	NOT NULL	No	No
COMM_CAL_OTHER_SPECIES	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAL_OTHER_SPECIES	rec_last_mod_date	DATE	NULL	No	No
COMM_CAL_OTHER_SPECIES	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAL_REF	comm_cal_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_REF	comm_cal_ref_id	NUMBER	NOT NULL	Yes	No
COMM_CAL_REF	display_order	NUMBER	NULL	No	No	Community Characterization: Local
COMM_CAL_REF	rec_create_date	DATE	NOT NULL	No	No
COMM_CAL_REF	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAL_REF	rec_last_mod_date	DATE	NULL	No	No
COMM_CAL_REF	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAL_REF	reference_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_SIMILAR_ASSOC	comm_cal_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_SIMILAR_ASSOC	comm_cal_similar_assoc_id	NUMBER	NOT NULL	Yes	No
COMM_CAL_SIMILAR_ASSOC	display_order	NUMBER	NULL	No	No	Community Characterization: Local
COMM_CAL_SIMILAR_ASSOC	rec_create_date	DATE	NOT NULL	No	No
COMM_CAL_SIMILAR_ASSOC	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAL_SIMILAR_ASSOC	rec_last_mod_date	DATE	NULL	No	No
COMM_CAL_SIMILAR_ASSOC	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAL_SIMILAR_ASSOC	similar_assoc_comm_gbl_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_SIMILAR_ASSOC	similar_assoc_note	VARCHAR2(2000)	NULL	No	No
COMM_CAL_SLOPE	comm_cal_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_SLOPE	comm_cal_slope_id	NUMBER	NOT NULL	Yes	No
COMM_CAL_SLOPE	d_slope_id	NUMBER	NOT NULL	No	Yes	Community Characterization: Local
COMM_CAL_SLOPE	display_order	NUMBER	NULL	No	No
COMM_CAL_SLOPE	rec_create_date	DATE	NOT NULL	No	No
COMM_CAL_SLOPE	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAL_SLOPE	rec_last_mod_date	DATE	NULL	No	No
COMM_CAL_SLOPE	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAL_SOIL_MOISTURE	comm_cal_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_SOIL_MOISTURE	comm_cal_soil_moisture_id	NUMBER	NOT NULL	Yes	No
COMM_CAL_SOIL_MOISTURE	d_comm_soil_moisture_id	NUMBER	NOT NULL	No	Yes	Community Characterization: Local
COMM_CAL_SOIL_MOISTURE	display_order	NUMBER	NULL	No	No
COMM_CAL_SOIL_MOISTURE	rec_create_date	DATE	NOT NULL	No	No
COMM_CAL_SOIL_MOISTURE	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAL_SOIL_MOISTURE	rec_last_mod_date	DATE	NULL	No	No
COMM_CAL_SOIL_MOISTURE	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAL_SOIL_TYPE	comm_cal_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_SOIL_TYPE	comm_cal_soil_type_id	NUMBER	NOT NULL	Yes	No
COMM_CAL_SOIL_TYPE	display_order	NUMBER	NULL	No	No	Community Characterization: Local
COMM_CAL_SOIL_TYPE	rec_create_date	DATE	NOT NULL	No	No
COMM_CAL_SOIL_TYPE	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAL_SOIL_TYPE	rec_last_mod_date	DATE	NULL	No	No
COMM_CAL_SOIL_TYPE	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAL_SOIL_TYPE	soil_type_desc	VARCHAR2(100)	NOT NULL	No	No
COMM_CAL_SPATIAL_PATTERN	comm_cal_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_SPATIAL_PATTERN	comm_cal_spatial_pattern_id	NUMBER	NOT NULL	Yes	No
COMM_CAL_SPATIAL_PATTERN	d_spatial_pattern_id	NUMBER	NOT NULL	No	Yes	Community Characterization: Local
COMM_CAL_SPATIAL_PATTERN	display_order	NUMBER	NULL	No	No
COMM_CAL_SPATIAL_PATTERN	rec_create_date	DATE	NOT NULL	No	No
COMM_CAL_SPATIAL_PATTERN	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAL_SPATIAL_PATTERN	rec_last_mod_date	DATE	NULL	No	No
COMM_CAL_SPATIAL_PATTERN	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAL_STRUCTURE	comm_cal_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_STRUCTURE	comm_cal_structure_id	NUMBER	NOT NULL	Yes	No
COMM_CAL_STRUCTURE	d_height_class_id	NUMBER	NULL	No	Yes	Community Characterization: Local
COMM_CAL_STRUCTURE	d_lifeform_id	NUMBER	NULL	No	Yes
COMM_CAL_STRUCTURE	d_stratum_id	NUMBER	NULL	No	Yes
COMM_CAL_STRUCTURE	display_order	NUMBER	NULL	No	No
COMM_CAL_STRUCTURE	max_percent_cover	VARCHAR2(20)	NULL	No	No
COMM_CAL_STRUCTURE	min_percent_cover	VARCHAR2(20)	NULL	No	No
COMM_CAL_STRUCTURE	modal_percent_cover_id	NUMBER	NULL	No	Yes
COMM_CAL_STRUCTURE	rec_create_date	DATE	NOT NULL	No	No
COMM_CAL_STRUCTURE	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAL_STRUCTURE	rec_last_mod_date	DATE	NULL	No	No
COMM_CAL_STRUCTURE	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAL_TOPO_POSITION	comm_cal_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_TOPO_POSITION	comm_cal_topo_position_id	NUMBER	NOT NULL	Yes	No
COMM_CAL_TOPO_POSITION	d_topo_position_id	NUMBER	NOT NULL	No	Yes	Community Characterization: Local
COMM_CAL_TOPO_POSITION	display_order	NUMBER	NULL	No	No
COMM_CAL_TOPO_POSITION	rec_create_date	DATE	NOT NULL	No	No
COMM_CAL_TOPO_POSITION	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAL_TOPO_POSITION	rec_last_mod_date	DATE	NULL	No	No
COMM_CAL_TOPO_POSITION	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAL_UNVEG_SURF	comm_cal_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_UNVEG_SURF	comm_cal_unveg_surf_id	NUMBER	NOT NULL	Yes	No
COMM_CAL_UNVEG_SURF	d_unvegetated_surface_id	NUMBER	NOT NULL	No	Yes	Community Characterization: Local
COMM_CAL_UNVEG_SURF	display_order	NUMBER	NULL	No	No
COMM_CAL_UNVEG_SURF	max_percent_cover	VARCHAR2(20)	NULL	No	No
COMM_CAL_UNVEG_SURF	min_percent_cover	VARCHAR2(20)	NULL	No	No
COMM_CAL_UNVEG_SURF	modal_percent_cover_id	NUMBER	NULL	No	Yes
COMM_CAL_UNVEG_SURF	rec_create_date	DATE	NOT NULL	No	No
COMM_CAL_UNVEG_SURF	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAL_UNVEG_SURF	rec_last_mod_date	DATE	NULL	No	No
COMM_CAL_UNVEG_SURF	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAL_WATERSHED	comm_cal_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_WATERSHED	comm_cal_watershed_id	NUMBER	NOT NULL	Yes	No
COMM_CAL_WATERSHED	comm_cal_watershed_note	VARCHAR2(2000)	NULL	No	No	Community Characterization: Local
COMM_CAL_WATERSHED	d_occurrence_status_id	NUMBER	NULL	No	Yes
COMM_CAL_WATERSHED	d_watershed_id	NUMBER	NOT NULL	No	Yes
COMM_CAL_WATERSHED	date_assessed	DATE	NULL	No	No
COMM_CAL_WATERSHED	display_order	NUMBER	NULL	No	No
COMM_CAL_WATERSHED	rec_create_date	DATE	NOT NULL	No	No
COMM_CAL_WATERSHED	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAL_WATERSHED	rec_last_mod_date	DATE	NULL	No	No
COMM_CAL_WATERSHED	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAL_WATERSHED	reference_id	NUMBER	NULL	No	Yes
COMM_CAN	additional_topics	VARCHAR2(2000)	NULL	No	No
COMM_CAN	d_ca_completeness_id	NUMBER	NULL	No	Yes
COMM_CAN	d_leaf_phenology_id	NUMBER	NULL	No	Yes	Biotics Data Model Overview
COMM_CAN	d_leaf_type_id	NUMBER	NULL	No	Yes	Community Characterization: National
COMM_CAN	d_succession_stage_id	NUMBER	NULL	No	Yes
COMM_CAN	element_national_id	NUMBER	NOT NULL	Yes	Yes
COMM_CAN	internal_notes	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_adjacent_assoc_com	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_community_com	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_component_species_tax_com	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_data_analysis_methods	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_data_location	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_dynamic_processes_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_economic_com	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_environmental_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_geology	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_heterogeneity	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_hydrologic_influence	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_imagery_com	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_inv_sampling_analysis_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_key_environmental_factors	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_key_field_characteristics	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_max_elev_feet	NUMBER	NULL	No	No
COMM_CAN	n_max_elev_meters	NUMBER	NULL	No	No
COMM_CAN	n_mgmt_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_min_elev_feet	NUMBER	NULL	No	No
COMM_CAN	n_min_elev_meters	NUMBER	NULL	No	No
COMM_CAN	n_natural_disturbances_com	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_other_notable_species_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_permanent_plot_location	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_physiognomy_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_sampling_com	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_seasonal_variation	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_similar_association_com	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_size_com	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_soil_com	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_spatial_relations_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_succession_com	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_variability	VARCHAR2(4000)	NULL	No	No
COMM_CAN	n_vegetation_sum	VARCHAR2(4000)	NULL	No	No
COMM_CAN	rec_create_date	DATE	NOT NULL	No	No
COMM_CAN	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAN	rec_last_mod_date	DATE	NULL	No	No
COMM_CAN	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAN	version_author_name	VARCHAR2(100)	NULL	No	No
COMM_CAN	version_date	DATE	NULL	No	No
COMM_CAN_ADJACENT_ASSOC	adjacent_assoc_comm_natl_id	NUMBER	NOT NULL	No	Yes
COMM_CAN_ADJACENT_ASSOC	adjacent_assoc_note	VARCHAR2(4000)	NULL	No	No
COMM_CAN_ADJACENT_ASSOC	comm_adjacent_assoc_id	NUMBER	NOT NULL	Yes	No	Community Characterization: National
COMM_CAN_ADJACENT_ASSOC	display_order	NUMBER	NULL	No	No
COMM_CAN_ADJACENT_ASSOC	element_national_id	NUMBER	NOT NULL	No	Yes
COMM_CAN_ADJACENT_ASSOC	rec_create_date	DATE	NOT NULL	No	No
COMM_CAN_ADJACENT_ASSOC	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAN_ADJACENT_ASSOC	rec_last_mod_date	DATE	NULL	No	No
COMM_CAN_ADJACENT_ASSOC	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAN_ASPECT	comm_can_aspect_id	NUMBER	NOT NULL	Yes	No
COMM_CAN_ASPECT	d_aspect_id	NUMBER	NOT NULL	No	Yes
COMM_CAN_ASPECT	display_order	NUMBER	NULL	No	No	Community Characterization: National
COMM_CAN_ASPECT	element_national_id	NUMBER	NOT NULL	No	Yes
COMM_CAN_ASPECT	rec_create_date	DATE	NOT NULL	No	No
COMM_CAN_ASPECT	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAN_ASPECT	rec_last_mod_date	DATE	NULL	No	No
COMM_CAN_ASPECT	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAN_COMPOSITION	characteristic_ind	CHAR(1)	NOT NULL	No	No
COMM_CAN_COMPOSITION	comm_can_composition_id	NUMBER	NOT NULL	Yes	No
COMM_CAN_COMPOSITION	comm_can_composition_note	VARCHAR2(2000)	NULL	No	No	Community Characterization: National
COMM_CAN_COMPOSITION	constant_ind	CHAR(1)	NOT NULL	No	No
COMM_CAN_COMPOSITION	d_constancy_id	NUMBER	NULL	No	Yes
COMM_CAN_COMPOSITION	d_lifeform_id	NUMBER	NULL	No	Yes
COMM_CAN_COMPOSITION	d_stratum_id	NUMBER	NULL	No	Yes
COMM_CAN_COMPOSITION	display_order	NUMBER	NULL	No	No
COMM_CAN_COMPOSITION	dominant_ind	CHAR(1)	NOT NULL	No	No
COMM_CAN_COMPOSITION	element_national_id	NUMBER	NOT NULL	No	Yes
COMM_CAN_COMPOSITION	element_taxon_gbl_id	NUMBER	NOT NULL	No	Yes
COMM_CAN_COMPOSITION	max_percent_cover	VARCHAR2(20)	NULL	No	No
COMM_CAN_COMPOSITION	min_percent_cover	VARCHAR2(20)	NULL	No	No
COMM_CAN_COMPOSITION	modal_percent_cover_id	NUMBER	NULL	No	Yes
COMM_CAN_COMPOSITION	rec_create_date	DATE	NOT NULL	No	No
COMM_CAN_COMPOSITION	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAN_COMPOSITION	rec_last_mod_date	DATE	NULL	No	No
COMM_CAN_COMPOSITION	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAN_ECOREGION	comm_can_ecoregion_id	NUMBER	NOT NULL	Yes	No
COMM_CAN_ECOREGION	comm_can_ecoregion_note	VARCHAR2(2000)	NULL	No	No
COMM_CAN_ECOREGION	d_national_ecoregion_id	NUMBER	NOT NULL	No	Yes	Community Characterization: National
COMM_CAN_ECOREGION	d_occurrence_status_id	NUMBER	NULL	No	Yes
COMM_CAN_ECOREGION	date_assessed	DATE	NULL	No	No
COMM_CAN_ECOREGION	display_order	NUMBER	NULL	No	No
COMM_CAN_ECOREGION	element_national_id	NUMBER	NOT NULL	No	Yes
COMM_CAN_ECOREGION	rec_create_date	DATE	NOT NULL	No	No
COMM_CAN_ECOREGION	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAN_ECOREGION	rec_last_mod_date	DATE	NULL	No	No
COMM_CAN_ECOREGION	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAN_ECOREGION	reference_id	NUMBER	NULL	No	Yes
COMM_CAN_EMAP	comm_can_emap_id	NUMBER	NOT NULL	Yes	No
COMM_CAN_EMAP	comm_can_emap_note	VARCHAR2(2000)	NULL	No	No
COMM_CAN_EMAP	d_occurrence_status_id	NUMBER	NULL	No	Yes	Community Characterization: National
COMM_CAN_EMAP	date_assessed	DATE	NULL	No	No
COMM_CAN_EMAP	display_order	NUMBER	NULL	No	No
COMM_CAN_EMAP	element_national_id	NUMBER	NOT NULL	No	Yes
COMM_CAN_EMAP	emap_hexcode	VARCHAR2(20)	NOT NULL	No	No
COMM_CAN_EMAP	rec_create_date	DATE	NOT NULL	No	No
COMM_CAN_EMAP	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAN_EMAP	rec_last_mod_date	DATE	NULL	No	No
COMM_CAN_EMAP	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAN_EMAP	reference_id	NUMBER	NULL	No	Yes
COMM_CAN_HIGHER_TAXON	comm_can_higher_taxon_id	NUMBER	NOT NULL	Yes	No
COMM_CAN_HIGHER_TAXON	display_order	NUMBER	NULL	No	No
COMM_CAN_HIGHER_TAXON	element_national_id	NUMBER	NOT NULL	No	Yes	Community Characterization: National
COMM_CAN_HIGHER_TAXON	higher_taxon_name	VARCHAR2(50)	NULL	No	No
COMM_CAN_HIGHER_TAXON	higher_taxon_note	VARCHAR2(2000)	NULL	No	No
COMM_CAN_HIGHER_TAXON	rec_create_date	DATE	NOT NULL	No	No
COMM_CAN_HIGHER_TAXON	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAN_HIGHER_TAXON	rec_last_mod_date	DATE	NULL	No	No
COMM_CAN_HIGHER_TAXON	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAN_HYDRO_MODIFIER	comm_can_hydro_modifier_id	NUMBER	NOT NULL	Yes	No
COMM_CAN_HYDRO_MODIFIER	d_hydrologic_modifier_id	NUMBER	NOT NULL	No	Yes
COMM_CAN_HYDRO_MODIFIER	display_order	NUMBER	NULL	No	No	Community Characterization: National
COMM_CAN_HYDRO_MODIFIER	element_national_id	NUMBER	NOT NULL	No	Yes
COMM_CAN_HYDRO_MODIFIER	rec_create_date	DATE	NOT NULL	No	No
COMM_CAN_HYDRO_MODIFIER	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAN_HYDRO_MODIFIER	rec_last_mod_date	DATE	NULL	No	No
COMM_CAN_HYDRO_MODIFIER	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAN_KEYWORD	comm_can_keyword_id	NUMBER	NOT NULL	Yes	No
COMM_CAN_KEYWORD	d_ca_keyword_id	NUMBER	NOT NULL	No	Yes
COMM_CAN_KEYWORD	display_order	NUMBER	NULL	No	No	Community Characterization: National
COMM_CAN_KEYWORD	element_national_id	NUMBER	NOT NULL	No	Yes
COMM_CAN_KEYWORD	rec_create_date	DATE	NOT NULL	No	No
COMM_CAN_KEYWORD	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAN_KEYWORD	rec_last_mod_date	DATE	NULL	No	No
COMM_CAN_KEYWORD	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAN_LANDFORM	comm_can_landform_id	NUMBER	NOT NULL	Yes	No
COMM_CAN_LANDFORM	d_landform_id	NUMBER	NOT NULL	No	Yes
COMM_CAN_LANDFORM	display_order	NUMBER	NULL	No	No	Community Characterization: National
COMM_CAN_LANDFORM	element_national_id	NUMBER	NOT NULL	No	Yes
COMM_CAN_LANDFORM	rec_create_date	DATE	NOT NULL	No	No
COMM_CAN_LANDFORM	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAN_LANDFORM	rec_last_mod_date	DATE	NULL	No	No
COMM_CAN_LANDFORM	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAN_LATITUDE_ZONE	comm_can_latitude_zone_id	NUMBER	NOT NULL	Yes	No
COMM_CAN_LATITUDE_ZONE	d_latitude_zone_id	NUMBER	NOT NULL	No	Yes
COMM_CAN_LATITUDE_ZONE	display_order	NUMBER	NULL	No	No	Community Characterization: National
COMM_CAN_LATITUDE_ZONE	element_national_id	NUMBER	NOT NULL	No	Yes
COMM_CAN_LATITUDE_ZONE	rec_create_date	DATE	NOT NULL	No	No
COMM_CAN_LATITUDE_ZONE	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAN_LATITUDE_ZONE	rec_last_mod_date	DATE	NULL	No	No
COMM_CAN_LATITUDE_ZONE	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAN_LOCAL_JURIS	comm_can_local_juris_id	NUMBER	NOT NULL	Yes	No
COMM_CAN_LOCAL_JURIS	comm_can_local_juris_note	VARCHAR2(2000)	NULL	No	No
COMM_CAN_LOCAL_JURIS	d_local_jurisdiction_id	NUMBER	NOT NULL	No	Yes	Community Characterization: National
COMM_CAN_LOCAL_JURIS	d_occurrence_status_id	NUMBER	NULL	No	Yes
COMM_CAN_LOCAL_JURIS	date_assessed	DATE	NULL	No	No
COMM_CAN_LOCAL_JURIS	display_order	NUMBER	NULL	No	No
COMM_CAN_LOCAL_JURIS	element_national_id	NUMBER	NOT NULL	No	Yes
COMM_CAN_LOCAL_JURIS	rec_create_date	DATE	NOT NULL	No	No
COMM_CAN_LOCAL_JURIS	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAN_LOCAL_JURIS	rec_last_mod_date	DATE	NULL	No	No
COMM_CAN_LOCAL_JURIS	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAN_LOCAL_JURIS	reference_id	NUMBER	NULL	No	Yes
COMM_CAN_OTHER_SPECIES	comm_can_other_species_id	NUMBER	NOT NULL	Yes	No
COMM_CAN_OTHER_SPECIES	display_order	NUMBER	NULL	No	No
COMM_CAN_OTHER_SPECIES	element_national_id	NUMBER	NOT NULL	No	Yes	Community Characterization: National
COMM_CAN_OTHER_SPECIES	other_species_note	VARCHAR2(2000)	NULL	No	No
COMM_CAN_OTHER_SPECIES	other_species_taxon_gbl_id	NUMBER	NOT NULL	No	Yes
COMM_CAN_OTHER_SPECIES	rec_create_date	DATE	NOT NULL	No	No
COMM_CAN_OTHER_SPECIES	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAN_OTHER_SPECIES	rec_last_mod_date	DATE	NULL	No	No
COMM_CAN_OTHER_SPECIES	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAN_SIMILAR_ASSOC	comm_can_similar_assoc_id	NUMBER	NOT NULL	Yes	No
COMM_CAN_SIMILAR_ASSOC	display_order	NUMBER	NULL	No	No
COMM_CAN_SIMILAR_ASSOC	element_national_id	NUMBER	NOT NULL	No	Yes	Community Characterization: National
COMM_CAN_SIMILAR_ASSOC	rec_create_date	DATE	NOT NULL	No	No
COMM_CAN_SIMILAR_ASSOC	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAN_SIMILAR_ASSOC	rec_last_mod_date	DATE	NULL	No	No
COMM_CAN_SIMILAR_ASSOC	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAN_SIMILAR_ASSOC	similar_assoc_comm_natl_id	NUMBER	NOT NULL	No	Yes
COMM_CAN_SIMILAR_ASSOC	similar_assoc_note	VARCHAR2(4000)	NULL	No	No
COMM_CAN_SLOPE	comm_can_slope_id	NUMBER	NOT NULL	Yes	No
COMM_CAN_SLOPE	d_slope_id	NUMBER	NOT NULL	No	Yes
COMM_CAN_SLOPE	display_order	NUMBER	NULL	No	No	Community Characterization: National
COMM_CAN_SLOPE	element_national_id	NUMBER	NOT NULL	No	Yes
COMM_CAN_SLOPE	rec_create_date	DATE	NOT NULL	No	No
COMM_CAN_SLOPE	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAN_SLOPE	rec_last_mod_date	DATE	NULL	No	No
COMM_CAN_SLOPE	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAN_SOIL_MOISTURE	comm_can_soil_moisture_id	NUMBER	NOT NULL	Yes	No
COMM_CAN_SOIL_MOISTURE	d_comm_soil_moisture_id	NUMBER	NOT NULL	No	Yes
COMM_CAN_SOIL_MOISTURE	display_order	NUMBER	NULL	No	No	Community Characterization: National
COMM_CAN_SOIL_MOISTURE	element_national_id	NUMBER	NOT NULL	No	Yes
COMM_CAN_SOIL_MOISTURE	rec_create_date	DATE	NOT NULL	No	No
COMM_CAN_SOIL_MOISTURE	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAN_SOIL_MOISTURE	rec_last_mod_date	DATE	NULL	No	No
COMM_CAN_SOIL_MOISTURE	rec_last_mod_user	VARCHAR2(30)	NULL	No	No
COMM_CAN_SOIL_TYPE	comm_can_soil_type_id	NUMBER	NOT NULL	Yes	No
COMM_CAN_SOIL_TYPE	display_order	NUMBER	NULL	No	No
COMM_CAN_SOIL_TYPE	element_national_id	NUMBER	NOT NULL	No	Yes	Community Characterization: National
COMM_CAN_SOIL_TYPE	rec_create_date	DATE	NOT NULL	No	No
COMM_CAN_SOIL_TYPE	rec_create_user	VARCHAR2(30)	NOT NULL	No	No
COMM_CAN_SOI