individual_hooknline_view
Northwest Fisheries Science Center
Entity
(ENT)
| ID: 36441
| Published / External
Created: 2017-01-25
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 18433
ID: 36441
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | individual_hooknline_view |
---|---|
Short Name | |
* Status | |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract | |
* Purpose | |
Notes | |
Other Citation Details | |
• Supplemental Information | |
DOI (Digital Object Identifier) | |
DOI Registration Authority | |
DOI Issue Date |
Keywords
Theme Keywords
Thesaurus | Keyword |
---|---|
Temporal Keywords
Thesaurus | Keyword |
---|---|
* Spatial Keywords
Thesaurus | Keyword |
---|---|
Stratum Keywords
Thesaurus | Keyword |
---|---|
Instrument Keywords
Thesaurus | Keyword |
---|---|
Platform Keywords
Thesaurus | Keyword |
---|---|
Physical Location
• » Organization | |
---|---|
• » City | |
• » State/Province | |
• Country | |
• » Location Description |
Entity Information
Entity Type | Data View |
---|---|
Active Version? | |
Alias | |
Schema Name | |
» Description |
Hook and Line individual details for only individuals that are not excluded |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | drop_time_dim$hour | int2 | standard representation of the hour |
100 | No | No | sampling_start_time_dim$second | int2 | number of seconds in the minute |
100 | No | No | best_available_taxonomy_observation_detail_dim$measurement_procurement | varchar | how the measurement was achieved |
100 | No | No | most_recent_age_update_date_dim$year | int4 | numeric representation of year |
100 | No | No | best_available_taxonomy_dim$hookandline_species_id | int4 | species identifier used by hook and line |
100 | No | No | best_available_taxonomy_dim$superfamily_48 | varchar | superfamily name |
100 | No | No | most_recent_taxonomy_update_date_dim$month_name | varchar | text representation of month |
100 | No | No | field_identified_taxonomy_dim$grp_nonstandard_taxon_99 | varchar | a pseudo taxonomic level that has a common usage such as Invertebrata, Pisces (Fish). This has been designed to allow for only one level of para- or poly-phyletic group that is the terminus of the definition (it may be associated with a higher level taxonomic hierarchy). Consequently a definition such as Fish->Roundfish would not be supported with this design |
100 | No | No | best_available_taxonomy_dim$kingdom_10 | varchar | kingdom name |
100 | No | No | best_available_taxonomy_dim$trawl_survey_species_id | int4 | species identifier used by the trawl survey |
100 | No | No | drop_time_whid | int8 | Warehouse identifier for the drop time |
100 | No | No | site_dim$tide_station_name | varchar | name of nearest tide station |
100 | No | No | taxon_rank | varchar | name of the lowest taxonomic level used to define scientific name |
100 | No | No | most_recent_taxonomy_update_date_dim$yyyymmdd | bpchar | text representation of year month day |
100 | No | No | best_available_taxonomy_observation_detail_dim$means_of_calculation | varchar | describes how the measurement was calculated |
100 | No | No | date_dim$day_of_month | int2 | numeric representation of the day in month |
100 | No | No | date_dim$month_abbrev | bpchar | three character representation of month in capital letters |
100 | No | No | tow_end_timestamp | timestamp | operation end date timestamp |
100 | No | No | field_identified_taxonomy_dim$observer_species_id | int4 | species identifier used by the observer program |
100 | No | No | field_identified_taxonomy_dim$norpac_species_id | int4 | A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a species_name and a scientific name. |
100 | No | No | operation_dim$vessel_id | int2 | field database vessel id number |
100 | No | No | field_identified_taxonomy_dim$species_sub_category | varchar | mid-level taxonomic ranking |
100 | No | No | operation_dim_whid | int8 | Warehouse identifier to operation details |
100 | No | No | operation_dim$coast_guard_number | varchar | Coast Guard documentation number of vessel |
100 | No | No | most_recent_age_update_date_dim$month_of_year | int2 | numeric representation of month of year |
100 | No | No | hook_id | int4 | Field database hook identifier |
100 | No | No | field_identified_taxonomy_dim$hookandline_species_id | int4 | species identifier used by hook and line |
100 | No | No | best_available_taxonomy_dim$observer_species_id | int4 | species identifier used by the observer program |
100 | No | No | most_recent_taxonomy_update_date_dim$day_of_month | int2 | numeric representation of the day in month |
100 | No | No | drop_time_dim$hh24miss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
100 | No | No | drop_latitude_dim$latitude_in_degrees | numeric | numeric representation of latitude in degrees |
100 | No | No | field_identified_taxonomy_dim$pacfin_spid | varchar | pacfin species id - many taxa may not have one of these |
100 | No | No | drop_longitude_dim$longitude_compass_direction | bpchar | longitude compass direction |
100 | No | No | operation_dim$captain_person_whid | int4 | person reference for the vessel captain |
100 | No | No | pacfin_spid | varchar | pacfin species id - many taxa may not have one of these |
100 | No | No | best_available_taxonomy_dim$tribe_60 | varchar | tribe name |
100 | No | No | operation_dim$state_registration_number | varchar | state registration number for the vessel |
100 | No | No | operation_dim$scientist_2_person_whid | int4 | person reference for the second scientist |
100 | No | No | site_dim$tide_station_longitude_whid | int4 | warehouse identifier to longitude details for site's nearest tide station |
100 | No | No | drop_latitude_dim$latitude_second_units | int2 | numeric representation of latitude that makes up the second unit only |
100 | No | No | hook_whid | int4 | Warehouse identifier to hook details |
100 | No | No | drop_sounder_depth_dim$depth_fathoms | numeric | depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries |
100 | No | No | operation_dim$operation_start_time_whid | int8 | start time reference for the operation |
100 | No | No | best_available_taxonomy_dim$grp_reg_depth_category | varchar | management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf |
67 | No | No | sex | bpchar | |
100 | No | No | best_available_taxonomy_dim$family_50 | varchar | family name |
100 | No | No | operation_dim$field_operation_seg_id | int8 | operation segment id reference to the field operational segment table |
100 | No | No | taxon_source | varchar | name of primary source used to get the measurement |
100 | No | No | drop_sounder_depth_dim$depth_meters | numeric | depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries) |
100 | No | No | site_dim$site_longitude_dd | numeric | site longitude in decimal degrees |
100 | No | No | otolith_number | varchar | Individual otolith tracking number |
100 | No | No | drop_longitude_whid | int4 | Warehouse identifier for the longitude drop to the second unit of measure |
100 | No | No | field_identified_taxonomy_dim$superorder_38 | varchar | superorder name |
100 | No | No | best_available_taxonomy_dim$genus_70 | varchar | genus name |
100 | No | No | drop_time_dim$record_type | varchar | time record or reason record is unavailable |
100 | No | No | operation_dim$return_date_whid | int8 | date reference that vessel returned for the defined leg or trip |
100 | No | No | angler_person_dim$first_name | varchar | first name of person |
100 | No | No | site_dim$inactive_date_whid | int8 | warehouse identifier for the date when the site went inactive |
100 | No | No | lab_maturity_detail_dim$functionally_mature_indicator | varchar | identifies the functional maturity of the individual |
100 | No | No | date_dim$full_date | timestamp | full date value |
100 | No | No | best_available_taxonomy_dim$suborder_42 | varchar | suborder name |
100 | No | No | best_available_taxonomy_dim$worms_aphiaid | int4 | WoRMS taxonomic identifier |
100 | No | No | drop_time_dim$period | bpchar | period of time |
100 | No | No | field_identified_taxonomy_dim$structure_source | varchar | Source of the taxonomic structure |
100 | No | No | operation_dim$operation_end_date_whid | int8 | end date reference for the operation |
100 | No | No | operation_dim$return_port_whid | int4 | port reference for return port |
100 | No | No | trawl_id | int8 | identifier for a sampling operation |
100 | No | No | hook_dim$record_type | varchar | hook record or reason record is unavailable |
100 | No | No | weight_kg | numeric | Individual weight in kilograms |
100 | No | No | sex_dim$record_type | varchar | latitude record type or reason record is unavailable |
100 | No | No | best_available_taxonomy_observation_detail_dim$record_type | varchar | observation detail record type or reason record is unavailable |
100 | No | No | disposition_dim$return_indicator | varchar | Indicates if returned to sea |
100 | No | No | field_identified_taxonomy_dim$phylum_20 | varchar | phylum name |
100 | No | No | best_available_taxonomy_dim$subspecies_82 | varchar | subspecies name |
100 | No | No | date_yyyymmdd | bpchar | text representation of year month day |
100 | No | No | site_dim$tide_station_latitude_whid | int4 | warehouse identifier to latitude details for site's nearest tide station |
100 | No | No | sampling_start_time_dim$record_type | varchar | time record or reason record is unavailable |
100 | No | No | drop_latitude_dim$latitude_compass_direction | bpchar | latitude compass direction |
100 | No | No | drop_longitude_dim$longitude_second_units | int2 | numeric representation of longitude that makes up the second unit only |
100 | No | No | field_identified_taxonomy_dim$acoustics_species_id | int4 | Species ID used in the acoustics program |
100 | No | No | field_identified_taxonomy_dim$genus_70 | varchar | genus name |
100 | No | No | most_recent_age_update_date_dim$month_abbrev | bpchar | three character representation of month in capital letters |
100 | No | No | date_dim$month_of_year | int2 | numeric representation of month of year |
100 | No | No | drop_time_dim$second | int2 | number of seconds in the minute |
100 | No | No | best_available_taxonomy_dim$superorder_38 | varchar | superorder name |
100 | No | No | most_recent_age_update_date_dim$month_name | varchar | text representation of month |
100 | No | No | site_dim$site_number | int4 | site identifier number |
100 | No | No | drop_latitude_dim$latitude_minute_units | int2 | numeric representation of latitude that makes up the minute unit only |
100 | No | No | field_identified_taxonomy_dim$record_type | varchar | record or reason record is unavailable |
100 | No | No | disposition_whid | int2 | Warehouse identifier to disposition details |
100 | No | No | angler_person_dim$full_name | varchar | full name in format of First and Last (Suffix) |
100 | No | No | best_available_taxonomy_dim$infraorder_44 | varchar | infraorder name |
100 | No | No | field_identified_taxonomy_dim$subfamily_52 | varchar | subfamily name |
100 | No | No | net_touchdown_time | time | military time representation of the time |
100 | No | No | sampling_end_hhmmss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
100 | No | No | field_identified_taxonomy_dim$abbreviated_name | varchar | specialized common name, generally for a well-known species of fish such as ATF, LST, SST |
100 | No | No | best_available_taxonomy_dim$class_30 | varchar | class name |
100 | No | No | best_available_taxonomy_dim$acoustics_species_id | int4 | Species ID used in the acoustics program |
100 | No | No | most_recent_taxon_update | timestamp | full date value |
100 | No | No | sampling_start_time_dim$period | bpchar | period of time |
100 | No | No | sampling_end_time_dim$record_type | varchar | time record or reason record is unavailable |
100 | No | No | field_identified_taxonomy_dim$grp_reg_depth_category | varchar | management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf |
100 | No | No | site_dim$area_name | varchar | name of area site is located in |
100 | No | No | most_recent_taxonomy_update_date_whid | int8 | Warehouse identifier for most recent taxonomy update date |
100 | No | No | most_recent_age_update_date_dim$record_type | varchar | date, month, or year record or reason record is unavailable |
100 | No | No | drop_latitude_dim$named_parallel | varchar | name of parallel, boundary, or commonly used geograpical location |
100 | No | No | angler_person_whid | int4 | Warehouse identifier for the angler |
100 | No | No | lab_maturity_detail_dim$record_type | varchar | lab maturity detail record or reason record is unavailable |
100 | No | No | best_available_taxonomy_observation_detail_whid | int4 | Warehouse identifier to taxonomy observation detail |
100 | No | No | drop_latitude_whid | int4 | Warehouse identifier for the latitude drop to the second unit of measure |
100 | No | No | date_dim$year | int4 | numeric representation of year |
100 | No | No | best_available_taxonomy_dim$infraclass_34 | varchar | infraclass name |
100 | No | No | field_identified_taxonomy_dim$subphylum_22 | varchar | subphylum name |
100 | No | No | best_available_taxonomy_dim$phylum_20 | varchar | phylum name |
100 | No | No | best_available_taxonomy_dim$itis_taxonomic_serial_no | int4 | ITIS taxonomic identifier |
100 | No | No | drop_latitude_dim$record_type | varchar | latitude record type or reason record is unavailable |
100 | No | No | sampling_end_time_dim$period | bpchar | period of time |
100 | No | No | tow_start_timestamp | timestamp | operation start date timestamp |
100 | No | No | site_dim$distance_to_port_nm | numeric | distance from site to nearest port in nautical miles |
100 | No | No | site_dim$site_latitude_dd | numeric | site latitude in decimal degrees |
100 | No | No | drop_longitude_dim$longitude_in_degrees | numeric | numeric representation of longitude in decimal degrees |
100 | No | No | site_dim$site_latitude_whid | int4 | warehouse identifier to latitude details for site |
100 | No | No | drop_sounder_depth_dim$boundary_indicator | varchar | depth boundry indicator identifying ifp boundary marks |
100 | No | No | field_identified_taxonomy_dim$superfamily_48 | varchar | superfamily name |
100 | No | No | most_recent_taxonomy_update_date_dim$month_abbrev | bpchar | three character representation of month in capital letters |
100 | No | No | date_dim$record_type | varchar | date, month, or year record or reason record is unavailable |
100 | No | No | drop_sounder_depth_dim$record_type | varchar | depth record or reason record is unavailable |
100 | No | No | operation_dim$operation_type | varchar | type of operation |
100 | No | No | best_available_taxonomy_whid | int4 | Warehouse identifier to best available taxonomy |
100 | No | No | best_available_taxonomy_dim$superclass_28 | varchar | superclass name |
100 | No | No | operation_dim$scientist_1_person_whid | int4 | person reference for the first scientist |
100 | No | No | operation_dim$record_type | varchar | operation record or reason record is unavailable |
100 | No | No | best_available_taxonomy_observation_detail_dim$observation_type | varchar | the type of observation |
100 | No | No | sampling_end_time_dim$military_hour | int2 | military representation of the hour |
100 | No | No | vessel | varchar | name of the vessel used for the operation |
100 | No | No | hook_dim$hook_result | varchar | The result of using the hook |
100 | No | No | field_identified_taxonomy_dim$family_50 | varchar | family name |
100 | No | No | operation_dim$observer_program | varchar | description of the observer program |
100 | No | No | most_recent_age_update_date_dim$day_of_month | int2 | numeric representation of the day in month |
100 | No | No | field_identified_taxonomy_dim$infraclass_34 | varchar | infraclass name |
100 | No | No | site_whid | int4 | Warehouse identifier to site details |
100 | No | No | fish_note | varchar | Fish note details |
100 | No | No | program | varchar | type of fram program |
100 | No | No | best_available_taxonomy_dim$abbreviated_name | varchar | specialized common name, generally for a well-known species of fish such as ATF, LST, SST |
100 | No | No | field_identified_taxonomy_dim$subspecies_82 | varchar | subspecies name |
100 | No | No | operation_dim$operation_start_date_whid | int8 | start date reference for the operation |
67 | No | No | sex_dim$sex | varchar | |
100 | No | No | sex_whid | int2 | Warehouse identifier to sex details |
100 | No | No | operation_dim$scientist_4_person_whid | int4 | person reference for the fourth scientist |
100 | No | No | operation_dim$fpc_person_whid | int4 | person reference for the FPC |
100 | No | No | drop_longitude_dim$longitude_degree_units | int2 | numeric representation of longitude that makes up the degree unit only |
100 | No | No | lab_maturity_detail_dim$functionally_mature_certain_indicator | varchar | identifies the certainty of the functionally mature evaluation |
100 | No | No | best_available_taxonomy_dim$record_type | varchar | record or reason record is unavailable |
100 | No | No | site_dim$record_type | varchar | site record or reason record is unavailable |
100 | No | No | disposition_dim$record_type | varchar | Type of record |
100 | No | No | best_available_taxonomy_dim$pacfin_nom_spid | varchar | PacFIN nominal species identifier |
100 | No | No | performance | varchar | performance of the operation |
100 | No | No | best_available_taxonomy_dim$norpac_species_id | int4 | A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a species_name and a scientific name. |
100 | No | No | sampling_end_time_dim$hour | int2 | standard representation of the hour |
100 | No | No | angler_person_dim$role | varchar | role taken during an operation |
100 | No | No | lab_maturity_detail_dim$biologically_mature_certain_indicator | varchar | identifies the certainty of the biological maturity |
100 | No | No | species_subcategory | varchar | mid-level taxonomic ranking |
100 | No | No | sampling_start_time_whid | int4 | Warehouse identifier for the sampling start time of the site visit |
100 | No | No | field_identified_taxonomy_dim$infraorder_44 | varchar | infraorder name |
100 | No | No | hook_dim$hook_number | int2 | The hook number on the line |
100 | No | No | disposition_dim$disposition | varchar | Identifies condition |
100 | No | No | operation_dim$ifq_account_number | varchar | unique number assigned to user accounts in the Vessel Accounting Database |
100 | No | No | sampling_end_time_whid | int4 | Warehouse identifier for the sampling end time of the site visit |
100 | No | No | best_available_taxonomy_dim$subfamily_52 | varchar | subfamily name |
100 | No | No | most_recent_age_update_date_whid | int8 | Warehouse identifier for most recent age update date |
100 | No | No | lab_maturity_detail_dim$biologically_mature_indicator | varchar | identifies biological maturity of the individual |
100 | No | No | fin_clip_number | varchar | Individual fin clip tracking number |
100 | No | No | hook_dim$gear_performance | varchar | Gear performance |
100 | No | No | lab_maturity_detail_whid | int4 | Warehouse identifier to lab maturity details |
100 | No | No | leg | int2 | leg number of the survey |
100 | No | No | field_identified_taxonomy_dim$kingdom_10 | varchar | kingdom name |
100 | No | No | field_identified_taxonomy_dim$worms_aphiaid | int4 | WoRMS taxonomic identifier |
100 | No | No | most_recent_age_update_date_dim$yyyymmdd | bpchar | text representation of year month day |
100 | No | No | field_identified_taxonomy_dim$itis_taxonomic_serial_no | int4 | ITIS taxonomic identifier |
100 | No | No | sampling_start_time_dim$military_hour | int2 | military representation of the hour |
100 | No | No | age_years | int2 | Individual determined age in years |
100 | No | No | angler_person_dim$record_type | varchar | person record or reason record is unavailable |
100 | No | No | inclusion_whid | int4 | Warehouse identifier for what to include in analysis |
100 | No | No | operation_dim$departure_port_whid | int4 | port reference for the departure port |
100 | No | No | field_identified_taxonomy_dim$pacfin_nom_spid | varchar | PacFIN nominal species identifier |
100 | No | No | field_identified_taxonomy_dim$common_name | varchar | only one broadly used common name is supported by this design. If the common name is not fairly universally used or is used by more than one taxon this should be left null |
100 | No | No | field_identified_taxonomy_dim$species_category | varchar | upper-level taxonomic ranking |
100 | No | No | drop_longitude_dim$record_type | varchar | longitude record type or reason record is unavailable |
100 | No | No | drop_sounder_depth_whid | int4 | Warehouse identifier to the drop depth from the sounder sensor to the tenth of a meter unit |
100 | No | No | field_identified_taxonomy_whid | int4 | Warehouse identifier to field identified taxonomy |
100 | No | No | drop_time_dim$military_hour | int2 | military representation of the hour |
100 | No | No | sampling_start_hhmmss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
100 | No | No | individual_tracking_id | int4 | Field individual identification number |
100 | No | No | most_recent_age_update | timestamp | full date value |
100 | No | No | sampling_start_time_dim$minute | int2 | number of minutes in the hour |
100 | No | No | inclusion_dim$hook_inclusion_indicator | varchar | indicates if hook should be included |
100 | No | No | angler_person_dim$nick_name | varchar | nickname of person |
100 | No | No | operation_dim$trip_id | int4 | trip identifier number |
100 | No | No | species_category | varchar | upper-level taxonomic ranking |
100 | No | No | field_identified_taxonomy_dim$scientific_name_taxonomic_level | varchar | name of the lowest taxonomic level used to define scientific name |
100 | No | No | best_available_taxonomy_observation_detail_dim$method_description | varchar | description of how the observation was taken |
100 | No | No | scientific_name | varchar | scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level |
100 | No | No | sampling_end_time_dim$second | int2 | number of seconds in the minute |
100 | No | No | inclusion_dim$drop_inclusion_indicator | varchar | indicates if drop should be included |
100 | No | No | field_identified_taxonomy_dim$trawl_survey_species_id | int4 | species identifier used by the trawl survey |
100 | No | No | operation_dim$scientist_3_person_whid | int4 | person reference for the third scientist |
100 | No | No | site_dim$site_longitude_whid | int4 | warehouse identifier to longitude details for site |
100 | No | No | date_whid | int8 | Warehouse identifier to date details |
100 | No | No | drop_time_dim$minute | int2 | number of minutes in the hour |
100 | No | No | sampling_end_time_dim$minute | int2 | number of minutes in the hour |
100 | No | No | sampling_start_time_dim$hour | int2 | standard representation of the hour |
100 | No | No | field_identified_taxonomy_dim$scientific_name | varchar | scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level |
100 | No | No | field_identified_taxonomy_dim$order_40 | varchar | order name |
100 | No | No | drop_longitude_dim$longitude_minute_units | int2 | numeric representation of longitude that makes up the minute unit only |
100 | No | No | best_available_taxonomy_dim$grp_nonstandard_taxon_99 | varchar | a pseudo taxonomic level that has a common usage such as Invertebrata, Pisces (Fish). This has been designed to allow for only one level of para- or poly-phyletic group that is the terminus of the definition (it may be associated with a higher level taxonomic hierarchy). Consequently a definition such as Fish->Roundfish would not be supported with this design |
100 | No | No | most_recent_taxonomy_update_date_dim$year | int4 | numeric representation of year |
100 | No | No | most_recent_taxonomy_update_date_dim$month_of_year | int2 | numeric representation of month of year |
100 | No | No | best_available_taxonomy_dim$subphylum_22 | varchar | subphylum name |
100 | No | No | year | int2 | operation year |
100 | No | No | field_identified_taxonomy_dim$tribe_60 | varchar | tribe name |
100 | No | No | best_available_taxonomy_dim$order_40 | varchar | order name |
100 | No | No | operation_dim$operation_end_time_whid | int8 | end time reference for the operation |
100 | No | No | tow | int2 | operation number of the survey |
100 | No | No | common_name | varchar | only one broadly used common name is supported by this design. If the common name is not fairly universally used or is used by more than one taxon this should be left null |
100 | No | No | field_identified_taxonomy_dim$superclass_28 | varchar | superclass name |
100 | No | No | site_dim$cowcod_conservation_area_indicator | varchar | indicates if site falls within the cowcod conservation area |
100 | No | No | best_available_taxonomy_dim$subclass_32 | varchar | subclass name |
100 | No | No | project | varchar | project name |
100 | No | No | field_identified_taxonomy_dim$subclass_32 | varchar | subclass name |
100 | No | No | site_dim$tide_station_noaa_id | varchar | tide station id according to NOAA's Tides and Currents site |
100 | No | No | pass | int4 | pass number of the survey |
100 | No | No | length_cm | numeric | Individual length in centimeters |
100 | No | No | inclusion_dim$record_type | varchar | inclusion record or reason record is unavailable |
100 | No | No | best_available_taxonomy_dim$species_80 | varchar | species name |
100 | No | No | best_available_taxonomy_dim$structure_source | varchar | Source of the taxonomic structure |
100 | No | No | drop_latitude_dim$latitude_in_degree_minute_second | varchar | string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
100 | No | No | operation_dim$limited_entry_permit_number | bpchar | federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California |
100 | No | No | angler_person_dim$middle_initial | bpchar | middle initial of person |
100 | No | No | operation_dim$departure_date_whid | int8 | date reference that vessel departed for the defined leg or trip |
100 | No | No | site_dim$cdfgblock | int4 | CDFG Block Numbers that the sites fall within |
100 | No | No | most_recent_taxonomy_update_date_dim$record_type | varchar | date, month, or year record or reason record is unavailable |
100 | No | No | net_liftoff_time | time | military time representation of the time |
100 | No | No | angler_person_dim$last_name | varchar | last name of person |
100 | No | No | drop_time_dim$time | time | military time representation of the time |
100 | No | No | field_identified_taxonomy_dim$suborder_42 | varchar | suborder name |
100 | No | No | date_dim$month_name | varchar | text representation of month |
100 | No | No | drop_longitude_dim$longitude_in_degree_minute_second | varchar | string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
100 | No | No | field_identified_taxonomy_dim$class_30 | varchar | class name |
100 | No | No | inclusion_dim$site_inclusion_indicator | varchar | indicates if site should be included |
100 | No | No | field_identified_taxonomy_dim$species_80 | varchar | species name |
100 | No | No | drop_latitude_dim$latitude_degree_units | int2 | numeric representation of latitude that makes up the degree unit only |
Attribute Details
Attribute Name | drop_time_dim$hour |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
standard representation of the hour |
General Data Type | |
Unit of Measure | hr |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-12 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_start_time_dim$second |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
number of seconds in the minute |
General Data Type | |
Unit of Measure | sec |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_observation_detail_dim$measurement_procurement |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
how the measurement was achieved |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | NA, Calculated, Estimated, Observed, Measured, Not Documented |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_recent_age_update_date_dim$year |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1978+ |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$hookandline_species_id |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
species identifier used by hook and line |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$superfamily_48 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
superfamily name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_recent_taxonomy_update_date_dim$month_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | January, February, March, April, May, June, July, August, September, October, November, December |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$grp_nonstandard_taxon_99 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
a pseudo taxonomic level that has a common usage such as Invertebrata, Pisces (Fish). This has been designed to allow for only one level of para- or poly-phyletic group that is the terminus of the definition (it may be associated with a higher level taxonomic hierarchy). Consequently a definition such as Fish->Roundfish would not be supported with this design |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$kingdom_10 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
kingdom name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$trawl_survey_species_id |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
species identifier used by the trawl survey |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_time_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for the drop time |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | site_dim$tide_station_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 60 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
name of nearest tide station |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | taxon_rank |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
name of the lowest taxonomic level used to define scientific name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_recent_taxonomy_update_date_dim$yyyymmdd |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of year month day |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_observation_detail_dim$means_of_calculation |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
describes how the measurement was calculated |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | date_dim$day_of_month |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of the day in month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-31 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | date_dim$month_abbrev |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
three character representation of month in capital letters |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | tow_end_timestamp |
---|---|
Seq. Order | |
Data Storage Type | timestamp |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
operation end date timestamp |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$observer_species_id |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
species identifier used by the observer program |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$norpac_species_id |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a species_name and a scientific name. |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$vessel_id |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
field database vessel id number |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$species_sub_category |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
mid-level taxonomic ranking |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | rockfish, flatfish, shark, crab, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier to operation details |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$coast_guard_number |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Coast Guard documentation number of vessel |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_recent_age_update_date_dim$month_of_year |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of month of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-12 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | hook_id |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Field database hook identifier |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$hookandline_species_id |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
species identifier used by hook and line |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$observer_species_id |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
species identifier used by the observer program |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_recent_taxonomy_update_date_dim$day_of_month |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of the day in month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-31 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_time_dim$hh24miss |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_latitude_dim$latitude_in_degrees |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
numeric representation of latitude in degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -90 to 90 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$pacfin_spid |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
pacfin species id - many taxa may not have one of these |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_longitude_dim$longitude_compass_direction |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
longitude compass direction |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | E, W |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$captain_person_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
person reference for the vessel captain |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | pacfin_spid |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
pacfin species id - many taxa may not have one of these |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$tribe_60 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
tribe name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$state_registration_number |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
state registration number for the vessel |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$scientist_2_person_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
person reference for the second scientist |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | site_dim$tide_station_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
warehouse identifier to longitude details for site's nearest tide station |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_latitude_dim$latitude_second_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of latitude that makes up the second unit only |
General Data Type | |
Unit of Measure | sec |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | hook_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier to hook details |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_sounder_depth_dim$depth_fathoms |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
depth low precision measurement in fathoms converted from meters measured to the tenth of a meter except for special fathom boundaries |
General Data Type | |
Unit of Measure | fth |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$operation_start_time_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
start time reference for the operation |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$grp_reg_depth_category |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sex |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description | |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$family_50 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
family name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$field_operation_seg_id |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
operation segment id reference to the field operational segment table |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | taxon_source |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
name of primary source used to get the measurement |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Angler, FPC, Genetics, Lab Exam, Large Scale, Morphometrics, Morphometrics + Genetics, NA, Quality Assurance, Retrospective Review, Taxon Rank Upped, Whole Organism |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_sounder_depth_dim$depth_meters |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries) |
General Data Type | |
Unit of Measure | m |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-1500 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | site_dim$site_longitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 6 |
Scale | |
Status | Active |
Description |
site longitude in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | otolith_number |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Individual otolith tracking number |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for the longitude drop to the second unit of measure |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$superorder_38 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
superorder name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$genus_70 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
genus name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_time_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
time record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$return_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
date reference that vessel returned for the defined leg or trip |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | angler_person_dim$first_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
first name of person |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | site_dim$inactive_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
warehouse identifier for the date when the site went inactive |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | lab_maturity_detail_dim$functionally_mature_indicator |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
identifies the functional maturity of the individual |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Functionally Mature, Not Functionally Mature, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | date_dim$full_date |
---|---|
Seq. Order | |
Data Storage Type | timestamp |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
full date value |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$suborder_42 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
suborder name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$worms_aphiaid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
WoRMS taxonomic identifier |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_time_dim$period |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
period of time |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | AM, PM |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$structure_source |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Source of the taxonomic structure |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$operation_end_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
end date reference for the operation |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$return_port_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
port reference for return port |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | trawl_id |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
identifier for a sampling operation |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | hook_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
hook record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Hook, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | weight_kg |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 2 |
Scale | |
Status | Active |
Description |
Individual weight in kilograms |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sex_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
latitude record type or reason record is unavailable |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_observation_detail_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
observation detail record type or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Observation Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | disposition_dim$return_indicator |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Indicates if returned to sea |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Returned to Sea, Not Returned to Sea, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$phylum_20 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
phylum name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$subspecies_82 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
subspecies name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | date_yyyymmdd |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of year month day |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | site_dim$tide_station_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
warehouse identifier to latitude details for site's nearest tide station |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_start_time_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
time record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_latitude_dim$latitude_compass_direction |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
latitude compass direction |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | N, S |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_longitude_dim$longitude_second_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of longitude that makes up the second unit only |
General Data Type | |
Unit of Measure | sec |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-59 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$acoustics_species_id |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Species ID used in the acoustics program |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$genus_70 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
genus name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_recent_age_update_date_dim$month_abbrev |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
three character representation of month in capital letters |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | date_dim$month_of_year |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of month of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-12 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_time_dim$second |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
number of seconds in the minute |
General Data Type | |
Unit of Measure | sec |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$superorder_38 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
superorder name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_recent_age_update_date_dim$month_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | January, February, March, April, May, June, July, August, September, October, November, December |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | site_dim$site_number |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
site identifier number |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_latitude_dim$latitude_minute_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of latitude that makes up the minute unit only |
General Data Type | |
Unit of Measure | min |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Taxonomy, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | disposition_whid |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier to disposition details |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | angler_person_dim$full_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 100 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
full name in format of First and Last (Suffix) |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$infraorder_44 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
infraorder name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$subfamily_52 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
subfamily name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | net_touchdown_time |
---|---|
Seq. Order | |
Data Storage Type | time |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
military time representation of the time |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_end_hhmmss |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$abbreviated_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
specialized common name, generally for a well-known species of fish such as ATF, LST, SST |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$class_30 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
class name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$acoustics_species_id |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Species ID used in the acoustics program |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_recent_taxon_update |
---|---|
Seq. Order | |
Data Storage Type | timestamp |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
full date value |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_start_time_dim$period |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
period of time |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | AM, PM |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_end_time_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
time record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Time, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$grp_reg_depth_category |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
management grouping mostly for rockfishes (but could be assigned to any species): nearshore, shelf, or slope, or in future shallower shelf and deeper shelf |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | site_dim$area_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
name of area site is located in |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_recent_taxonomy_update_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for most recent taxonomy update date |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_recent_age_update_date_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
date, month, or year record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_latitude_dim$named_parallel |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
name of parallel, boundary, or commonly used geograpical location |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | angler_person_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for the angler |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | lab_maturity_detail_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
lab maturity detail record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Lab Maturity Detail, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_observation_detail_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier to taxonomy observation detail |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for the latitude drop to the second unit of measure |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | date_dim$year |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1978+ |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$infraclass_34 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
infraclass name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$subphylum_22 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
subphylum name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$phylum_20 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
phylum name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$itis_taxonomic_serial_no |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
ITIS taxonomic identifier |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_latitude_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
latitude record type or reason record is unavailable |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Latitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_end_time_dim$period |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
period of time |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | AM, PM |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | tow_start_timestamp |
---|---|
Seq. Order | |
Data Storage Type | timestamp |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
operation start date timestamp |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | site_dim$distance_to_port_nm |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 1 |
Scale | |
Status | Active |
Description |
distance from site to nearest port in nautical miles |
General Data Type | |
Unit of Measure | m |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | site_dim$site_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 6 |
Scale | |
Status | Active |
Description |
site latitude in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_longitude_dim$longitude_in_degrees |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
numeric representation of longitude in decimal degrees |
General Data Type | |
Unit of Measure | dd |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -180 to 180 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | site_dim$site_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
warehouse identifier to latitude details for site |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_sounder_depth_dim$boundary_indicator |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
depth boundry indicator identifying ifp boundary marks |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | IFP Boundary Depth, Standard Contour Depth, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$superfamily_48 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
superfamily name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_recent_taxonomy_update_date_dim$month_abbrev |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
three character representation of month in capital letters |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | date_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
date, month, or year record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_sounder_depth_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
depth record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Depth, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$operation_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
type of operation |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | CTD Cast, Drop, Experiment, Search, Trawl, VPR Tow, [null] |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier to best available taxonomy |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$superclass_28 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
superclass name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$scientist_1_person_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
person reference for the first scientist |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
operation record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Operation, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_observation_detail_dim$observation_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
the type of observation |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | NA, width, length, total_catch_weight, taxonomy, etc |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_end_time_dim$military_hour |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
military representation of the hour |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-24 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | vessel |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
name of the vessel used for the operation |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Aggressor, Amy Lynn, BJ Thomas, Blue Horizon, Captain Jack, Coast Pride, Excalibur, Last Straw, Limit Stalker, Mirage, Miss Leona, Morning Star, Ms. Julie, Noahs Ark, Pacific Sun IV, Raven, Sea Eagle, Toronado |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | hook_dim$hook_result |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The result of using the hook |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No Bait On Hook, Bait Back On Hook, No Hook, Multiple Hook, Fish, Angler Did Not Drop |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$family_50 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
family name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$observer_program |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 150 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
description of the observer program |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_recent_age_update_date_dim$day_of_month |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of the day in month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-31 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$infraclass_34 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
infraclass name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | site_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier to site details |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | fish_note |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 1000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Fish note details |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | program |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
type of fram program |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Bottom Trawl, Hook and Line |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$abbreviated_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
specialized common name, generally for a well-known species of fish such as ATF, LST, SST |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$subspecies_82 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
subspecies name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$operation_start_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
start date reference for the operation |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sex_dim$sex |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description | |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sex_whid |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier to sex details |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$scientist_4_person_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
person reference for the fourth scientist |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$fpc_person_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
person reference for the FPC |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_longitude_dim$longitude_degree_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of longitude that makes up the degree unit only |
General Data Type | |
Unit of Measure | deg |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -180 to 180 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | lab_maturity_detail_dim$functionally_mature_certain_indicator |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
identifies the certainty of the functionally mature evaluation |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Functionally Mature Certain, Not Functionally Mature Certain, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Taxonomy, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | site_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
site record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Site, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | disposition_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Type of record |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Disposition, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$pacfin_nom_spid |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
PacFIN nominal species identifier |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | performance |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
performance of the operation |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Insufficient Information, Indeterminate, Satisfactory, Trawlable, Untrawlable, Unsatisfactory, [null] |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$norpac_species_id |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
A three-digit numeric code assigned by the NMFS Observer Program to each different marine organism expected to be seen in the Bering Sea and northeast Pacific Ocean. Each number is uniquely associated with a species_name and a scientific name. |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_end_time_dim$hour |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
standard representation of the hour |
General Data Type | |
Unit of Measure | hr |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-12 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | angler_person_dim$role |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
role taken during an operation |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Captain, 2nd Captain, FPC, Cook, Scientist, Deck Hand |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | lab_maturity_detail_dim$biologically_mature_certain_indicator |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
identifies the certainty of the biological maturity |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Biologically Mature Certain, Not Biologically Mature Certain, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | species_subcategory |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
mid-level taxonomic ranking |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | rockfish, flatfish, shark, crab, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_start_time_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for the sampling start time of the site visit |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$infraorder_44 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
infraorder name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | hook_dim$hook_number |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
The hook number on the line |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-5 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | disposition_dim$disposition |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Identifies condition |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Live, Dead, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$ifq_account_number |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
unique number assigned to user accounts in the Vessel Accounting Database |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_end_time_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for the sampling end time of the site visit |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$subfamily_52 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
subfamily name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_recent_age_update_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for most recent age update date |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | lab_maturity_detail_dim$biologically_mature_indicator |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
identifies biological maturity of the individual |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Biologically Mature, Not Biologically Mature, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | fin_clip_number |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Individual fin clip tracking number |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | hook_dim$gear_performance |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Gear performance |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | No Problems, Lost Sinker, Minor Tangle, Major Tangle, Lost Gangion, Lost Hook(s), Missing Time, Multiple Hook, Gear Not Deployed |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | lab_maturity_detail_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier to lab maturity details |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | leg |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
leg number of the survey |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1,2,3,4,5,6,7,8 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$kingdom_10 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
kingdom name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$worms_aphiaid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
WoRMS taxonomic identifier |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_recent_age_update_date_dim$yyyymmdd |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of year month day |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$itis_taxonomic_serial_no |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
ITIS taxonomic identifier |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_start_time_dim$military_hour |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
military representation of the hour |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-24 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | age_years |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Individual determined age in years |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | angler_person_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
person record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Person, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | inclusion_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier for what to include in analysis |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$departure_port_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
port reference for the departure port |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$pacfin_nom_spid |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
PacFIN nominal species identifier |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$common_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
only one broadly used common name is supported by this design. If the common name is not fairly universally used or is used by more than one taxon this should be left null |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$species_category |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
upper-level taxonomic ranking |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | fish, invertebrate, mammal, seabird, reptile, nonspecific organics, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_longitude_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
longitude record type or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Longitude, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_sounder_depth_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier to the drop depth from the sounder sensor to the tenth of a meter unit |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier to field identified taxonomy |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_time_dim$military_hour |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
military representation of the hour |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-24 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_start_hhmmss |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | individual_tracking_id |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Field individual identification number |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_recent_age_update |
---|---|
Seq. Order | |
Data Storage Type | timestamp |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
full date value |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_start_time_dim$minute |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
number of minutes in the hour |
General Data Type | |
Unit of Measure | min |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | inclusion_dim$hook_inclusion_indicator |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
indicates if hook should be included |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Include Hook, Do Not Include Hook, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | angler_person_dim$nick_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
nickname of person |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$trip_id |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
trip identifier number |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | species_category |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
upper-level taxonomic ranking |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | fish, invertebrate, mammal, seabird, reptile, nonspecific organics, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$scientific_name_taxonomic_level |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
name of the lowest taxonomic level used to define scientific name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_observation_detail_dim$method_description |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 500 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
description of how the observation was taken |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | scientific_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 120 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_end_time_dim$second |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
number of seconds in the minute |
General Data Type | |
Unit of Measure | sec |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | inclusion_dim$drop_inclusion_indicator |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
indicates if drop should be included |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Include Drop, Do Not Include Drop, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$trawl_survey_species_id |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
species identifier used by the trawl survey |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$scientist_3_person_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
person reference for the third scientist |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | site_dim$site_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
warehouse identifier to longitude details for site |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Warehouse identifier to date details |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_time_dim$minute |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
number of minutes in the hour |
General Data Type | |
Unit of Measure | min |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_end_time_dim$minute |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
number of minutes in the hour |
General Data Type | |
Unit of Measure | min |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-60 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | sampling_start_time_dim$hour |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
standard representation of the hour |
General Data Type | |
Unit of Measure | hr |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-12 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$scientific_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 120 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
scientific name generally composed of the genus and species name and subspecies name if available, but may be the highest taxonomic level |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$order_40 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
order name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_longitude_dim$longitude_minute_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of longitude that makes up the minute unit only |
General Data Type | |
Unit of Measure | min |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0-59 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$grp_nonstandard_taxon_99 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
a pseudo taxonomic level that has a common usage such as Invertebrata, Pisces (Fish). This has been designed to allow for only one level of para- or poly-phyletic group that is the terminus of the definition (it may be associated with a higher level taxonomic hierarchy). Consequently a definition such as Fish->Roundfish would not be supported with this design |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_recent_taxonomy_update_date_dim$year |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1978+ |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_recent_taxonomy_update_date_dim$month_of_year |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of month of year |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1-12 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$subphylum_22 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
subphylum name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | year |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
operation year |
General Data Type | |
Unit of Measure | year |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 2007+ |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$tribe_60 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
tribe name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$order_40 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
order name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$operation_end_time_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
end time reference for the operation |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | tow |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
operation number of the survey |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | common_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
only one broadly used common name is supported by this design. If the common name is not fairly universally used or is used by more than one taxon this should be left null |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$superclass_28 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
superclass name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | site_dim$cowcod_conservation_area_indicator |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 40 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
indicates if site falls within the cowcod conservation area |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Inside_Cowcod_Conservancy_Area, Outside_Cowcod_Conservancy_Area. |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$subclass_32 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
subclass name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | project |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
project name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Groundfish Shelf Survey, Groundfish Slope and Shelf Combination Survery, Groundfish Slope Survey, Groundfish Triennial Shelf Survery, Hypoxia Study, Santa Barbara Basin Study, Shelf Rockfish [2004-2015], Video Study |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$subclass_32 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
subclass name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | site_dim$tide_station_noaa_id |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
tide station id according to NOAA's Tides and Currents site |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | pass |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
pass number of the survey |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1,2,3,4 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | length_cm |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 1 |
Scale | |
Status | Active |
Description |
Individual length in centimeters |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | inclusion_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
inclusion record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Inclusion, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$species_80 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
species name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | best_available_taxonomy_dim$structure_source |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Source of the taxonomic structure |
General Data Type | |
Unit of Measure | unspecified |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_latitude_dim$latitude_in_degree_minute_second |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
General Data Type | |
Unit of Measure | NA |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$limited_entry_permit_number |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
federal limited entry groundfish permit issued to fish in waters off of Washington, Oregon, and California |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | angler_person_dim$middle_initial |
---|---|
Seq. Order | |
Data Storage Type | bpchar |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
middle initial of person |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | operation_dim$departure_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
date reference that vessel departed for the defined leg or trip |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | site_dim$cdfgblock |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
CDFG Block Numbers that the sites fall within |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | most_recent_taxonomy_update_date_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
date, month, or year record or reason record is unavailable |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Date, Month, Year, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | net_liftoff_time |
---|---|
Seq. Order | |
Data Storage Type | time |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
military time representation of the time |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | angler_person_dim$last_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
last name of person |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_time_dim$time |
---|---|
Seq. Order | |
Data Storage Type | time |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
military time representation of the time |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$suborder_42 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
suborder name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | date_dim$month_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
text representation of month |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | January, February, March, April, May, June, July, August, September, October, November, December |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_longitude_dim$longitude_in_degree_minute_second |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 20 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$class_30 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
class name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | inclusion_dim$site_inclusion_indicator |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
indicates if site should be included |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Include Site, Do Not Include Site, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | field_identified_taxonomy_dim$species_80 |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
species name |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | drop_latitude_dim$latitude_degree_units |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
numeric representation of latitude that makes up the degree unit only |
General Data Type | |
Unit of Measure | deg |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | -90 to 90 |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | |
---|---|
Seq. Order | |
Data Storage Type | |
Max Length | |
Precision | |
Scale | |
Required | |
Primary Key | |
Status | |
Description | |
General Data Type | |
Case Restriction | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Min Length | |
Unit of Measure | |
Display Example | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Support Roles
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
* » Support Role | |
---|---|
* » Date Effective From | |
Date Effective To | |
* » Contact | |
* Contact Instructions |
Extents
Currentness Reference |
---|
Extent Group 1
Extent Description |
---|
Extent Group 1 / Geographic Area
* » W° Bound | |
---|---|
* » E° Bound | |
* » N° Bound | |
* » S° Bound | |
* » Description |
Extent Group 1 / Vertical Extent
EPSG Code | |
---|---|
Vertical Minimum | |
Vertical Maximum |
Extent Group 1 / Time Frame
* » Time Frame Type | |
---|---|
* » Start | |
End | |
Alternate Start as of Info | |
Alternate End as of Info | |
Description |
Access Information
* » Security Class | |
---|---|
* Security Classification System |
|
Security Handling Description |
|
• Data Access Policy |
|
» Data Access Procedure |
|
• » Data Access Constraints |
|
• Data Use Constraints |
|
Metadata Access Constraints |
|
Metadata Use Constraints |
|
Distribution Information
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Start Date | |
---|---|
End Date | |
» Download URL | |
Distributor | |
File Name | |
Description | |
File Date/Time | |
File Type | |
FGDC Content Type | |
File Size | |
Application Version | |
Compression | |
Review Status |
Activity Log
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Activity Time | |
---|---|
Activity Type | |
Responsible Party | |
Description |
Issues
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
Issue Date | |
---|---|
Author | |
Issue |
FAQs
Date | |
---|---|
Author | |
Question | |
Answer |
Child Items
Rubric scores updated every 15m
Score | Type | Title |
---|---|---|
Related Items
Item Type | Relationship Type | Title |
---|---|---|
Catalog Details
Catalog Item ID | 36441 |
---|---|
Metadata Record Created By | Jeffrey W Cowen |
Metadata Record Created | 2017-01-25 13:18+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2017-02-13 |
Owner Org | NWFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2017-02-13 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2018-02-13 |
Tags |
---|