individual_fact
Northwest Fisheries Science Center
Entity
(ENT)
| ID: 36438
| Published / External
Created: 2017-01-25
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 18418
ID: 36438
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | individual_fact |
---|---|
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 Table |
---|---|
Active Version? | |
Alias | |
Schema Name | |
» Description |
Individuals caught and measured on the bottom trawl survey |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | actual_station_design_dim$transect_station_longitude_dd | numeric | high precision value of transect station longitude measured in decimal degrees |
100 | No | No | standard_survey_dim$standard_survey_weight_indicator | varchar | identifies if the individual is part of the Standard Weight Survey |
100 | No | No | sampling_start_time_dim$minute | int2 | number of minutes in the hour |
100 | No | No | best_available_taxonomy_dim$phylum_20 | varchar | phylum name |
100 | No | No | performance | varchar | performance of the operation |
100 | No | No | actual_station_design_dim$upper_right_latitude_whid | int4 | upper right latitude warehouse identifier for a design type of grid |
100 | No | No | date_dim$record_type | varchar | date, month, or year record or reason record is unavailable |
100 | No | No | actual_station_design_dim$lower_left_longitude_dd | numeric | high precision value of lower left longitude of design type grid measured in decimal degrees |
100 | No | No | best_available_taxonomy_dim$structure_source | varchar | Source of the taxonomic structure |
100 | No | No | best_available_taxonomy_dim$family_50 | varchar | family name |
100 | No | No | actual_station_design_dim$upper_right_longitude_dd | numeric | high precision value of upper right longitude of design type grid measured in decimal degrees |
100 | No | No | actual_station_design_dim$upper_right_longitude_whid | int4 | upper right longitude warehouse identifier for a design type of grid |
100 | No | No | actual_station_design_dim$lower_left_latitude_whid | int4 | lower left latitude warehouse identifier for a design type of grid |
100 | No | No | best_available_taxonomy_dim$record_type | varchar | record or reason record is unavailable |
100 | No | No | width_observation_detail_dim$method_description | varchar | description of how the observation was taken |
100 | No | No | station_ur_lon_dd | numeric | high precision value of upper right longitude of design type grid measured in decimal degrees |
100 | No | No | most_recent_taxonomy_update_date_dim$day_of_month | int2 | numeric representation of the day in month |
100 | No | No | most_recent_age_update_date_dim$yyyymmdd | bpchar | text representation of year month day |
100 | No | No | individual_tracking_id | int8 | Individual tracking id |
100 | No | No | ovary_id | numeric | Ovary sample number or barcode |
100 | No | No | target_station_design_dim$stn_invalid_for_trawl_date_whid | int8 | station design invalidation date warehouse identifier |
100 | No | No | standard_survey_whid | int4 | Warehouse identifier for standard survey |
100 | No | No | operation_dim$scientist_1_person_whid | int4 | person reference for the first scientist |
100 | No | No | most_recent_maturity_update_date_whid | int8 | Warehouse identifier for most recent maturity update date |
100 | No | No | net_liftoff_time | time | military time representation of the time |
100 | No | No | actual_station_design_dim$variance_depth_m2 | numeric | high precision value of variance depth mesured in squared meters |
100 | No | No | target_station_design_dim$variance_depth_m2 | numeric | high precision value of variance depth mesured in squared meters |
100 | No | No | target_station_design_dim$min_depth_whid | int4 | minimum depth warehouse identifier |
100 | No | No | target_station_design_dim$transect_station_longitude_dd | numeric | high precision value of transect station longitude measured in decimal degrees |
100 | No | No | actual_station_design_dim$lower_left_longitude_whid | int4 | lower left longitude warehouse identifier for a design type of grid |
100 | No | No | field_identified_taxonomy_dim$itis_taxonomic_serial_no | int4 | ITIS taxonomic identifier |
100 | No | No | operation_dim$departure_port_whid | int4 | port reference for the departure port |
100 | No | No | haul_latitude_dim$record_type | varchar | latitude record type or reason record is unavailable |
100 | No | No | sex_whid | int2 | Warehouse identifier to sex details |
100 | No | No | target_station_design_whid | int4 | warehouse identifier for target station design |
100 | No | No | target_station_design_dim$max_latitude_whid | int4 | maximum latitude warehouse identifier for a design type of transect |
100 | No | No | actual_station_design_dim$upper_left_longitude_whid | int4 | upper left longitude warehouse identifier for a design type of grid |
100 | No | No | pass | int4 | pass number of the survey |
100 | No | No | sampling_end_time_dim$period | bpchar | period of time |
100 | No | No | operation_dim$scientist_3_person_whid | int4 | person reference for the third scientist |
100 | No | No | field_identified_taxonomy_dim$structure_source | varchar | Source of the taxonomic structure |
100 | No | No | width_cm | numeric | Individual width measured in centimeters |
100 | No | No | most_recent_taxon_update | timestamp | full date value |
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 | operation_dim$operation_start_date_whid | int8 | start date reference for the operation |
100 | No | No | best_available_taxonomy_dim$observer_species_id | int4 | species identifier used by the observer program |
100 | No | No | project | varchar | project name |
100 | No | No | midtow_lat_named_parallel | varchar | name of parallel, boundary, or commonly used geograpical location |
100 | No | No | field_identified_taxonomy_dim$species_category | varchar | upper-level taxonomic ranking |
100 | No | No | centroid_id | numeric | eight character code representing a unique identifier for a grid cell that is composed of a truncated latitude and longitude central to the cell. For example, 46252413 represents latitude 46 degrees 25 minutes and longitude -124 degrees and 13 minutes. The grid cells are small enough that 8 characters captures uniqueness. Note that these are NOT technically or mathematically centroids of the polygons. |
100 | No | No | sampling_start_time_dim$record_type | varchar | time record or reason record is unavailable |
100 | No | No | operation_dim$field_operation_seg_id | int8 | operation segment id reference to the field operational segment table |
100 | No | No | sampling_end_time_whid | int4 | warehouse identifier for the sampling end time |
100 | No | No | standard_survey_dim$record_type | varchar | standard survey record or reason record is unavailable |
100 | No | No | depth_m | numeric | depth low precision measurement in meters to the tenth of a meter (except for special fathom boundaries) |
100 | No | No | target_station_design_dim$upper_right_longitude_whid | int4 | upper right longitude warehouse identifier for a design type of grid |
100 | No | No | target_station_design_dim$mean_depth_whid | int4 | mean depth warehouse identifier |
100 | No | No | stomach_id | numeric | Stomach sample number or barcode |
100 | No | No | target_station_design_dim$station_design_type | varchar | type of design underlying the survey station set: Transect or Grid to date |
100 | No | No | trawl_id | int8 | identifier for a sampling operation |
100 | No | No | station_ur_lat_dd | numeric | high precision value of upper right latitude of design type grid measured in decimal degrees |
100 | No | No | width_type | varchar | describes how the measurement was calculated |
100 | No | No | best_available_taxonomy_whid | int4 | warehouse identifier to best available taxonomy |
100 | No | No | statistical_partition_dim$record_type | varchar | statistical partition record or reason record is unavailable |
100 | No | No | species_category | varchar | upper-level taxonomic ranking |
100 | No | No | field_identified_taxonomy_dim$hookandline_species_id | int4 | species identifier used by hook and line |
100 | No | No | station_ll_lat_dd | numeric | high precision value of lower left latitude of design type grid measured in decimal degrees |
100 | No | No | best_available_taxonomy_dim$subphylum_22 | varchar | subphylum name |
100 | No | No | field_identified_taxonomy_dim$record_type | varchar | record or reason record is unavailable |
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 | longitude_dd | numeric | numeric representation of longitude in decimal degrees |
100 | No | No | haul_longitude_dim$longitude_minute_units | int2 | numeric representation of longitude that makes up the minute unit only |
100 | No | No | program | varchar | type of fram program |
100 | No | No | width_observation_detail_dim$observation_type | varchar | the type of observation |
100 | No | No | field_identified_taxonomy_dim$superorder_38 | varchar | superorder name |
100 | No | No | operation_dim$operation_end_time_whid | int8 | end time reference for the operation |
100 | No | No | target_station_design_dim$min_latitude_dd | numeric | high precision value of minimum latitude measured in decimal degrees |
100 | No | No | most_recent_maturity_update_date_dim$yyyymmdd | bpchar | text representation of year month day |
100 | No | No | most_recent_maturity_update_date_dim$month_name | varchar | text representation of month |
100 | No | No | operation_dim$operation_start_time_whid | int8 | start time reference for the operation |
100 | No | No | field_identified_taxonomy_dim$infraorder_44 | varchar | infraorder name |
100 | No | No | standard_survey_dim$standard_survey_length_or_width_indicator | varchar | identifies if the individual is part of the Standard Length Survey |
100 | No | No | length_timestamp | timestamp | Timestamp at the point the length is taken on an individual |
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 | best_available_taxonomy_dim$pacfin_nom_spid | varchar | PacFIN nominal species identifier |
100 | No | No | actual_station_design_dim$station_design_type | varchar | type of design underlying the survey station set: Transect or Grid to date |
100 | No | No | field_identified_taxonomy_dim$worms_aphiaid | int4 | WoRMS taxonomic identifier |
100 | No | No | max_depth_m | numeric | high precision value of maximum depth measured in meters |
100 | No | No | field_identified_taxonomy_whid | int4 | warehouse identifier to field identified taxonomy |
100 | No | No | most_recent_age_update_date_dim$month_of_year | int2 | numeric representation of month of year |
100 | No | No | length_type | varchar | describes how the measurement was calculated |
100 | No | No | station_lr_lon_dd | numeric | high precision value of lower right longitude of design type grid measured in decimal degrees |
100 | No | No | haul_longitude_whid | int4 | warehouse identifier for haul longitude |
100 | No | No | date_dim$year | int4 | numeric representation of year |
100 | No | No | actual_station_design_dim$centroid_id | numeric | eight character code representing a unique identifier for a grid cell that is composed of a truncated latitude and longitude central to the cell. For example, 46252413 represents latitude 46 degrees 25 minutes and longitude -124 degrees and 13 minutes. The grid cells are small enough that 8 characters captures uniqueness. Note that these are NOT technically or mathematically centroids of the polygons. |
100 | No | No | actual_station_design_whid | int4 | warehouse identifier for station design |
100 | No | No | operation_dim$coast_guard_number | varchar | Coast Guard documentation number of vessel |
100 | No | No | field_identified_taxonomy_dim$kingdom_10 | varchar | kingdom name |
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 | most_recent_age_update_date_dim$month_name | varchar | text representation of month |
100 | No | No | taxon_source | varchar | name of primary source used to get the measurement |
100 | No | No | field_identified_taxonomy_dim$acoustics_species_id | int4 | Species ID used in the acoustics program |
100 | No | No | sampling_end_time_dim$minute | int2 | number of minutes in the hour |
100 | No | No | date_yyyymmdd | bpchar | text representation of year month day |
100 | No | No | haul_latitude_dim$latitude_in_degree_minute_second | varchar | string representation of latitude in degrees, minutes, and seconds for example 4525'01" |
100 | No | No | haul_latitude_dim$latitude_compass_direction | bpchar | latitude compass direction |
100 | No | No | year | int2 | operation year |
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 | field_identified_taxonomy_dim$subfamily_52 | varchar | subfamily name |
100 | No | No | sampling_start_time_dim$hour | int2 | standard representation of the hour |
100 | No | No | most_recent_maturity_update_date_dim$month_of_year | int2 | numeric representation of month of year |
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$subfamily_52 | varchar | subfamily name |
100 | No | No | otosag_id | int4 | Otolith barcode or sample number |
100 | No | No | haul_latitude_dim$latitude_second_units | int2 | numeric representation of latitude that makes up the second unit only |
100 | No | No | date_whid | int8 | warehouse identifier for date |
100 | No | No | target_station_design_dim$min_latitude_whid | int4 | minimum latitude warehouse identifier for a design type of transect |
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 | operation_dim$departure_date_whid | int8 | date reference that vessel departed for the defined leg or trip |
100 | No | No | length_observation_detail_dim$observation_type | varchar | the type of observation |
100 | No | No | operation_dim$fpc_person_whid | int4 | person reference for the FPC |
100 | No | No | actual_station_design_dim$transect_latitude_whid | int4 | latitude warehouse identifier for a design type of transect |
100 | No | No | length_cm | numeric | Individual length measured in centimeters |
100 | No | No | target_station_design_dim$active_polygon_dd | polygon | collection of vertices of the usuable area inside a station grid measured in decimal degrees |
100 | No | No | operation_dim$operation_end_date_whid | int8 | end date reference for the operation |
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 | actual_station_design_dim$max_depth_whid | int4 | maximum depth warehouse identifier |
100 | No | No | actual_station_design_dim$min_depth_m | numeric | high precision value of minimum depth measured in meters |
100 | No | No | operation_dim$return_date_whid | int8 | date reference that vessel returned for the defined leg or trip |
100 | No | No | haul_longitude_dim$longitude_compass_direction | bpchar | longitude compass direction |
100 | No | No | target_station_design_dim$transect_latitude_whid | int4 | latitude warehouse identifier for a design type of transect |
100 | No | No | date_dim$full_date | timestamp | full date value |
100 | No | No | target_station_design_dim$upper_left_latitude_whid | int4 | upper left latitude warehouse identifier for a design type of grid |
100 | No | No | actual_station_design_dim$mean_depth_whid | int4 | mean depth warehouse identifier |
100 | No | No | min_depth_m | numeric | high precision value of minimum depth measured in meters |
100 | No | No | year_stn_invalid | int2 | Survey year the station became invalid for trawl |
100 | No | No | length_observation_detail_dim$record_type | varchar | observation detail record type or reason record is unavailable |
100 | No | No | target_station_design_dim$upper_left_longitude_whid | int4 | upper left longitude warehouse identifier for a design type of grid |
100 | No | No | station_code | varchar | unique identifier for a station definition |
100 | No | No | station_ul_lat_dd | numeric | high precision value of upper left latitude of design type grid measured in decimal degrees |
100 | No | No | station_ll_lon_dd | numeric | high precision value of lower left longitude of design type grid measured in decimal degrees |
100 | No | No | vessel | varchar | name of the vessel used for the operation |
100 | No | No | most_recent_taxonomy_update_date_dim$month_of_year | int2 | numeric representation of month of year |
100 | No | No | actual_station_design_dim$lower_left_latitude_dd | numeric | high precision value of lower left latitude of design type grid measured in decimal degrees |
100 | No | No | best_available_taxonomy_dim$superfamily_48 | varchar | superfamily name |
100 | No | No | depth_ftm | 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 | actual_station_design_dim$transect_latitude_dd | numeric | high precision value of transect latitude measured in decimal degrees |
100 | No | No | weight_kg | numeric | Individual weight measured in kilograms |
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 | width_observation_detail_dim$source_primary | varchar | name of primary source used to get the measurement |
100 | No | No | target_station_design_dim$transect_station_longitude_whid | int4 | longitude on transect warehouse identifier for a design type of transect |
100 | No | No | actual_station_design_dim$station_grid_dd | polygon | collection of vertices of grid points of a grid design measured in decimal degrees |
100 | No | No | operation_dim$return_port_whid | int4 | port reference for return port |
100 | No | No | actual_station_design_dim$min_latitude_dd | numeric | high precision value of minimum latitude measured in decimal degrees |
100 | No | No | tow_end_timestamp | timestamp | operation end date timestamp |
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 |
100 | No | No | field_identified_taxonomy_dim$subphylum_22 | varchar | subphylum name |
100 | No | No | operation_dim$captain_person_whid | int4 | person reference for the vessel captain |
100 | No | No | target_station_design_dim$lower_left_latitude_whid | int4 | lower left latitude warehouse identifier for a design type of grid |
100 | No | No | length_observation_detail_dim$method_description | varchar | description of how the observation was taken |
100 | No | No | best_available_taxonomy_dim$suborder_42 | varchar | suborder name |
100 | No | No | most_recent_age_update_date_whid | int8 | Warehouse identifier for most recent age update date |
100 | No | No | field_identified_taxonomy_dim$phylum_20 | varchar | phylum name |
100 | No | No | best_available_taxonomy_dim$superclass_28 | varchar | superclass name |
100 | No | No | statistical_partition_whid | int4 | warehouse identifier for statistical partition |
100 | No | No | target_station_design_dim$upper_right_latitude_whid | int4 | upper right latitude warehouse identifier for a design type of grid |
100 | No | No | length_observation_detail_dim$measurement_procurement | varchar | how the measurement was achieved |
100 | No | No | length_observation_detail_whid | int4 | Warehouse identifier to taxonomy observation detail |
100 | No | No | field_identified_taxonomy_dim$pacfin_spid | varchar | pacfin species id - many taxa may not have one of these |
100 | No | No | operation_dim$ifq_account_number | varchar | unique number assigned to user accounts in the Vessel Accounting Database |
100 | No | No | best_available_taxonomy_dim$subspecies_82 | varchar | subspecies name |
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 | width_observation_detail_dim$measurement_procurement | varchar | how the measurement was achieved |
100 | No | No | target_station_design_dim$area_hectares | numeric | station area measured in hectares |
100 | No | No | age_years | numeric | Individual age measured in years |
100 | No | No | sampling_start_hhmmss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
100 | No | No | most_recent_taxonomy_update_date_dim$month_name | varchar | text representation of month |
100 | No | No | best_available_taxonomy_dim$hookandline_species_id | int4 | species identifier used by hook and line |
100 | No | No | best_available_taxonomy_observation_detail_dim$observation_type | varchar | the type of observation |
100 | No | No | field_identified_taxonomy_dim$genus_70 | varchar | genus name |
100 | No | No | most_recent_taxonomy_update_date_dim$year | int4 | numeric representation of year |
100 | No | No | actual_station_design_dim$active_polygon_dd | polygon | collection of vertices of the usuable area inside a station grid measured in decimal degrees |
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 | operation_dim$scientist_4_person_whid | int4 | person reference for the fourth scientist |
100 | No | No | actual_station_design_dim$lower_right_longitude_whid | int4 | lower right longitude warehouse identifier for a design type of grid |
100 | No | No | target_station_design_dim$transect_latitude_dd | numeric | high precision value of transect latitude measured in decimal degrees |
100 | No | No | mean_seafloor_dep_boundary | varchar | depth boundry indicator identifying ifp boundary marks |
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 | sampling_start_time_dim$second | int2 | number of seconds in the minute |
100 | No | No | actual_station_design_dim$station_invalid_survey_year | int2 | Survey year the station became invalid for trawl |
100 | No | No | sampling_start_time_whid | int4 | warehouse identifier for the sampling start time |
100 | No | No | target_station_design_dim$lower_right_longitude_whid | int4 | lower right longitude warehouse identifier for a design type of grid |
100 | No | No | haul_longitude_dim$record_type | varchar | longitude record type or reason record is unavailable |
100 | No | No | tissue_id | numeric | Tissue sample number or barcode |
100 | No | No | actual_station_design_dim$transect_station_longitude_whid | int4 | longitude on transect warehouse identifier for a design type of transect |
100 | No | No | best_available_taxonomy_dim$tribe_60 | varchar | tribe name |
100 | No | No | field_note | varchar | Note made in the field about an individual |
67 | No | No | sex_dim$sex | varchar | |
100 | No | No | actual_station_design_dim$station_code | varchar | unique identifier for a station definition |
100 | No | No | latitude_dd | numeric | numeric representation of latitude in degrees |
100 | No | No | actual_station_design_dim$station_design_name | varchar | name of the design for a collection of stations |
100 | No | No | lab_maturity_detail_dim$biologically_mature_certain_indicator | varchar | identifies the certainty of the biological maturity |
100 | No | No | actual_station_design_dim$lower_right_latitude_whid | int4 | lower right latitude warehouse identifier for a design type of grid |
100 | No | No | haul_longitude_dim$longitude_degree_units | int2 | numeric representation of longitude that makes up the degree unit only |
100 | No | No | best_available_taxonomy_observation_detail_dim$means_of_calculation | varchar | describes how the measurement was calculated |
100 | No | No | most_recent_age_update | timestamp | full date value |
100 | No | No | actual_station_design_dim$area_hectares | numeric | station area measured in hectares |
100 | No | No | taxon_rank | varchar | name of the lowest taxonomic level used to define scientific name |
100 | No | No | best_available_taxonomy_observation_detail_dim$record_type | varchar | observation detail record type or reason record is unavailable |
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 | field_identified_taxonomy_dim$observer_species_id | int4 | species identifier used by the observer program |
100 | No | No | operation_dim_whid | int8 | warehouse identifier for operation |
100 | No | No | operation_dim$scientist_2_person_whid | int4 | person reference for the second scientist |
100 | No | No | most_recent_taxonomy_update_date_dim$yyyymmdd | bpchar | text representation of year month day |
100 | No | No | best_available_taxonomy_dim$genus_70 | varchar | genus name |
100 | No | No | net_touchdown_time | time | military time representation of the time |
100 | No | No | best_available_taxonomy_dim$itis_taxonomic_serial_no | int4 | ITIS taxonomic identifier |
100 | No | No | operation_dim$vessel_id | int2 | field database vessel id number |
100 | No | No | left_pectoral_fin_id | int4 | Left pectoral fin sample number or barcode |
100 | No | No | best_available_taxonomy_dim$worms_aphiaid | int4 | WoRMS taxonomic identifier |
100 | No | No | lab_maturity_detail_dim$biologically_mature_indicator | varchar | identifies biological maturity of the individual |
100 | No | No | most_recent_taxonomy_update_date_whid | int8 | Warehouse identifier for most recent taxonomy update date |
100 | No | No | haul_latitude_whid | int4 | warehouse identifier for haul latitude |
100 | No | No | operation_dim$state_registration_number | varchar | state registration number for the vessel |
100 | No | No | actual_station_design_dim$upper_right_latitude_dd | numeric | high precision value of upper right latitude of design type grid measured in decimal degrees |
100 | No | No | date_dim$month_abbrev | bpchar | three character representation of month in capital letters |
100 | No | No | actual_station_design_dim$upper_left_longitude_dd | numeric | high precision value of upper left longitude of design type grid measured in decimal degrees |
100 | No | No | best_available_taxonomy_observation_detail_dim$method_description | varchar | description of how the observation was taken |
100 | No | No | width_observation_detail_whid | int4 | Warehouse identifier to taxonomy observation detail |
100 | No | No | haul_latitude_dim$latitude_degree_units | int2 | numeric representation of latitude that makes up the degree unit only |
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 | actual_station_design_dim$mean_depth_m | numeric | high precision value of mean depth measured in meters |
100 | No | No | field_identified_taxonomy_dim$pacfin_nom_spid | varchar | PacFIN nominal species identifier |
100 | No | No | field_identified_taxonomy_dim$superclass_28 | varchar | superclass name |
100 | No | No | actual_station_design_dim$max_depth_m | numeric | high precision value of maximum depth measured in meters |
100 | No | No | field_identified_taxonomy_dim$superfamily_48 | varchar | superfamily name |
100 | No | No | most_recent_age_update_date_dim$month_abbrev | bpchar | three character representation of month in capital letters |
100 | No | No | tow_start_timestamp | timestamp | operation start date timestamp |
100 | No | No | actual_station_design_dim$reason_station_invalid | varchar | reason station was invalidated, multiple reasons are comma separated |
100 | No | No | standard_survey_dim$standard_survey_maturity_indicator | varchar | identifies if the individual is part of the Standard Maturity Survey |
100 | No | No | station_lr_lat_dd | numeric | high precision value of lower right latitude of design type grid measured in decimal degrees |
100 | No | No | best_available_taxonomy_dim$infraclass_34 | varchar | infraclass name |
100 | No | No | length_observation_detail_dim$source_primary | varchar | name of primary source used to get the measurement |
100 | No | No | target_station_design_dim$max_latitude_dd | numeric | high precision value of maximum latitude measured in decimal degrees |
100 | No | No | operation_dim$trip_id | int4 | trip identifier number |
100 | No | No | sampling_start_time_dim$period | bpchar | period of time |
100 | No | No | operation_dim$record_type | varchar | operation record or reason record is unavailable |
100 | No | No | sampling_end_hhmmss | bpchar | concatenation of military hour, minute, second, example 230415 equates to 23:04:15 |
100 | No | No | date_dim$month_name | varchar | text representation of month |
100 | No | No | target_station_design_dim$lower_left_longitude_whid | int4 | lower left longitude warehouse identifier for a design type of grid |
100 | No | No | target_station_design_dim$station_grid_dd | polygon | collection of vertices of grid points of a grid design measured in decimal degrees |
100 | No | No | most_recent_age_update_date_dim$day_of_month | int2 | numeric representation of the day in month |
100 | No | No | tow | int2 | operation number of the survey |
100 | No | No | actual_station_design_dim$stn_invalid_for_trawl_date_whid | int8 | station design invalidation date warehouse identifier |
100 | No | No | standard_survey_dim$standard_survey_age_indicator | varchar | identifies if the individual is part of the Standard Age Survey |
100 | No | No | width_observation_detail_dim$record_type | varchar | observation detail record type or reason record is unavailable |
100 | No | No | field_identified_taxonomy_dim$infraclass_34 | varchar | infraclass name |
100 | No | No | most_recent_maturity_update_date_dim$record_type | varchar | date, month, or year record or reason record is unavailable |
100 | No | No | field_identified_taxonomy_dim$subspecies_82 | varchar | subspecies name |
100 | No | No | best_available_taxonomy_dim$acoustics_species_id | int4 | Species ID used in the acoustics program |
100 | No | No | actual_station_design_dim$max_latitude_whid | int4 | maximum latitude warehouse identifier for a design type of transect |
100 | No | No | most_recent_age_update_date_dim$year | int4 | numeric representation of year |
100 | No | No | species_subcategory | varchar | mid-level taxonomic ranking |
100 | No | No | date_dim$day_of_month | int2 | numeric representation of the day in month |
100 | No | No | actual_station_design_dim$upper_left_latitude_dd | numeric | high precision value of upper left latitude of design type grid measured in decimal degrees |
100 | No | No | field_identified_taxonomy_dim$tribe_60 | varchar | tribe name |
100 | No | No | leg | int2 | leg number of the survey |
100 | No | No | field_identified_taxonomy_dim$subclass_32 | varchar | subclass name |
100 | No | No | best_available_taxonomy_observation_detail_whid | int4 | warehouse identifier to best available taxonomy observation detail |
100 | No | No | seafloor_depth_dim$record_type | varchar | depth record or reason record is unavailable |
100 | No | No | station_ul_lon_dd | numeric | high precision value of upper left longitude of design type grid measured in decimal degrees |
100 | No | No | most_recent_taxonomy_update_date_dim$month_abbrev | bpchar | three character representation of month in capital letters |
100 | No | No | field_identified_taxonomy_dim$class_30 | varchar | class name |
100 | No | No | sampling_end_time_dim$hour | int2 | standard representation of the hour |
100 | No | No | actual_station_design_dim$upper_left_latitude_whid | int4 | upper left latitude warehouse identifier for a design type of grid |
100 | No | No | sampling_start_time_dim$military_hour | int2 | military representation of the hour |
100 | No | No | haul_longitude_dim$longitude_in_degree_minute_second | varchar | string representation of longitude in degrees, minutes, and seconds for example 4525'01" |
100 | No | No | reason_stn_invalid | varchar | reason station was invalidated, multiple reasons are comma separated |
100 | No | No | sampling_end_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 | best_available_taxonomy_dim$kingdom_10 | varchar | kingdom name |
100 | No | No | field_identified_taxonomy_dim$trawl_survey_species_id | int4 | species identifier used by the trawl survey |
100 | No | No | actual_station_design_dim$lower_right_latitude_dd | numeric | high precision value of lower right latitude of design type grid measured in decimal degrees |
100 | No | No | partition | varchar | Refines the partition type |
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 | field_identified_taxonomy_dim$suborder_42 | varchar | suborder name |
100 | No | No | field_identified_taxonomy_dim$family_50 | varchar | family name |
100 | No | No | sampling_end_time_dim$record_type | varchar | time record or reason record is unavailable |
100 | No | No | actual_station_design_dim$lower_right_longitude_dd | numeric | high precision value of lower right longitude of design type grid measured in decimal degrees |
100 | No | No | best_available_taxonomy_dim$class_30 | varchar | class name |
100 | No | No | seafloor_depth_whid | int4 | warehouse identifier for seafloor depth |
100 | No | No | target_station_design_dim$mean_depth_m | numeric | high precision value of mean depth measured in meters |
100 | No | No | field_identified_taxonomy_dim$species_sub_category | varchar | mid-level taxonomic ranking |
100 | No | No | operation_dim$observer_program | varchar | description of the observer program |
100 | No | No | lab_maturity_detail_dim$functionally_mature_indicator | varchar | identifies the functional maturity of the individual |
100 | No | No | pacfin_spid | varchar | pacfin species id - many taxa may not have one of these |
100 | No | No | best_available_taxonomy_dim$infraorder_44 | varchar | infraorder name |
100 | No | No | most_recent_maturity_update_date_dim$day_of_month | int2 | numeric representation of the day in month |
100 | No | No | statistical_partition_dim$statistical_partition_type | varchar | Defines the partition type |
100 | No | No | target_station_design_dim$record_type | varchar | station design record or reason record is unavailable |
100 | No | No | best_available_taxonomy_dim$order_40 | varchar | order name |
100 | No | No | actual_station_design_dim$min_depth_whid | int4 | minimum depth warehouse identifier |
100 | No | No | actual_station_design_dim$max_latitude_dd | numeric | high precision value of maximum latitude measured in decimal degrees |
100 | No | No | field_identified_taxonomy_dim$order_40 | varchar | order name |
100 | No | No | field_identified_taxonomy_dim$species_80 | varchar | species name |
100 | No | No | sampling_end_time_dim$military_hour | int2 | military representation of the hour |
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_dim$species_80 | varchar | species name |
100 | No | No | best_available_taxonomy_observation_detail_dim$measurement_procurement | varchar | how the measurement was achieved |
100 | No | No | target_station_design_dim$lower_right_latitude_whid | int4 | lower right latitude warehouse identifier for a design type of grid |
100 | No | No | operation_dim$operation_type | varchar | type of operation |
100 | No | No | haul_latitude_dim$latitude_minute_units | int2 | numeric representation of latitude that makes up the minute unit only |
100 | No | No | actual_station_design_dim$record_type | varchar | station design record or reason record is unavailable |
100 | No | No | target_station_design_dim$max_depth_whid | int4 | maximum depth warehouse identifier |
100 | No | No | best_available_taxonomy_dim$subclass_32 | varchar | subclass name |
100 | No | No | haul_longitude_dim$longitude_second_units | int2 | numeric representation of longitude that makes up the second unit only |
100 | No | No | sex_dim$record_type | varchar | latitude record type or reason record is unavailable |
100 | No | No | actual_station_design_dim$min_latitude_whid | int4 | minimum latitude warehouse identifier for a design type of transect |
100 | No | No | date_dim$month_of_year | int2 | numeric representation of month of year |
100 | No | No | most_recent_maturity_update_date_dim$month_abbrev | bpchar | three character representation of month in capital letters |
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 |
67 | No | No | sex | bpchar | |
100 | No | No | target_station_design_dim$station_design_name | varchar | name of the design for a collection of stations |
100 | No | No | best_available_taxonomy_dim$trawl_survey_species_id | int4 | species identifier used by the trawl survey |
100 | No | No | lab_maturity_detail_whid | int2 | Warehouse identifier for lab maturity details |
100 | No | No | most_recent_maturity_update_date_dim$full_date | timestamp | full date value |
100 | No | No | most_recent_maturity_update_date_dim$year | int4 | numeric representation of year |
Attribute Details
Attribute Name | actual_station_design_dim$transect_station_longitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of transect station longitude measured 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 | standard_survey_dim$standard_survey_weight_indicator |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
identifies if the individual is part of the Standard Weight Survey |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Standard Survey Weight, Not Standard Survey Weight, NA |
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 | 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 | 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 | actual_station_design_dim$upper_right_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
upper right latitude warehouse identifier for a design type of grid |
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$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 | actual_station_design_dim$lower_left_longitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of lower left longitude of design type grid measured 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 | 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 | 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 | actual_station_design_dim$upper_right_longitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of upper right longitude of design type grid measured 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 | actual_station_design_dim$upper_right_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
upper right longitude warehouse identifier for a design type of grid |
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 | actual_station_design_dim$lower_left_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
lower left latitude warehouse identifier for a design type of grid |
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$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 | width_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 | station_ur_lon_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of upper right longitude of design type grid measured 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 | 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 | 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 | individual_tracking_id |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Individual tracking id |
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 | ovary_id |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Ovary sample number or barcode |
General Data Type | |
Unit of Measure | unspecifid |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$stn_invalid_for_trawl_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
station design invalidation date warehouse 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 | standard_survey_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 standard 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_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 | most_recent_maturity_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 maturity 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 | 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 | actual_station_design_dim$variance_depth_m2 |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
high precision value of variance depth mesured in squared meters |
General Data Type | |
Unit of Measure | m2 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$variance_depth_m2 |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
high precision value of variance depth mesured in squared meters |
General Data Type | |
Unit of Measure | m2 |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$min_depth_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
minimum depth warehouse 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 | target_station_design_dim$transect_station_longitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of transect station longitude measured 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 | actual_station_design_dim$lower_left_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
lower left longitude warehouse identifier for a design type of grid |
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$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 | 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 | haul_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 | 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 | target_station_design_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 target station 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 | target_station_design_dim$max_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
maximum latitude warehouse identifier for a design type of transect |
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 | actual_station_design_dim$upper_left_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
upper left longitude warehouse identifier for a design type of grid |
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 | 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 | 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 | 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 | width_cm |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
Individual width measured in centimeters |
General Data Type | |
Unit of Measure | cm |
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_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 | 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 | 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 | 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 | 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 | midtow_lat_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 | 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 | centroid_id |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
eight character code representing a unique identifier for a grid cell that is composed of a truncated latitude and longitude central to the cell. For example, 46252413 represents latitude 46 degrees 25 minutes and longitude -124 degrees and 13 minutes. The grid cells are small enough that 8 characters captures uniqueness. Note that these are NOT technically or mathematically centroids of the polygons. |
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 | 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 | 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 |
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 | standard_survey_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
standard survey 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 | Standard Survey, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | depth_m |
---|---|
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 | target_station_design_dim$upper_right_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
upper right longitude warehouse identifier for a design type of grid |
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 | target_station_design_dim$mean_depth_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
mean depth warehouse 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 | stomach_id |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Stomach sample number or barcode |
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 | target_station_design_dim$station_design_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
type of design underlying the survey station set: Transect or Grid to date |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Transect, Grid |
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 | station_ur_lat_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of upper right latitude of design type grid measured 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 | width_type |
---|---|
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 | 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 | statistical_partition_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
statistical partition 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 | Statistical Partition, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
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$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 | station_ll_lat_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of lower left latitude of design type grid measured 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 | 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 | 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 | 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 | longitude_dd |
---|---|
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 | haul_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 | 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 | width_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 | 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 | 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 | target_station_design_dim$min_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of minimum latitude measured 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 | most_recent_maturity_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 | most_recent_maturity_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 | 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 | 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 | standard_survey_dim$standard_survey_length_or_width_indicator |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
identifies if the individual is part of the Standard Length Survey |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Standard Survey Length, Not Standard Survey Length, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | length_timestamp |
---|---|
Seq. Order | |
Data Storage Type | timestamp |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Timestamp at the point the length is taken on an individual |
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$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 | 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 | actual_station_design_dim$station_design_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 15 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
type of design underlying the survey station set: Transect or Grid to date |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Transect, Grid |
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 | max_depth_m |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
high precision value of maximum depth measured in meters |
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 | 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 | 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 | length_type |
---|---|
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 | station_lr_lon_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of lower right longitude of design type grid measured 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 | haul_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 haul longitude |
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 | actual_station_design_dim$centroid_id |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
eight character code representing a unique identifier for a grid cell that is composed of a truncated latitude and longitude central to the cell. For example, 46252413 represents latitude 46 degrees 25 minutes and longitude -124 degrees and 13 minutes. The grid cells are small enough that 8 characters captures uniqueness. Note that these are NOT technically or mathematically centroids of the polygons. |
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 | actual_station_design_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 station 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | haul_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 | haul_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 | 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 | 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 | 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 | 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 | most_recent_maturity_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 | 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$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 | otosag_id |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Otolith barcode or sample number |
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 | haul_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 | 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 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 | target_station_design_dim$min_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
minimum latitude warehouse identifier for a design type of transect |
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$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 | 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 | length_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 | 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 | actual_station_design_dim$transect_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
latitude warehouse identifier for a design type of transect |
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 | length_cm |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
Individual length measured in centimeters |
General Data Type | |
Unit of Measure | cm |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$active_polygon_dd |
---|---|
Seq. Order | |
Data Storage Type | polygon |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
collection of vertices of the usuable area inside a station grid measured 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 | 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 | 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 | actual_station_design_dim$max_depth_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
maximum depth warehouse 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 | actual_station_design_dim$min_depth_m |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
high precision value of minimum depth measured in meters |
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 | 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 | haul_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 | target_station_design_dim$transect_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
latitude warehouse identifier for a design type of transect |
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$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 | target_station_design_dim$upper_left_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
upper left latitude warehouse identifier for a design type of grid |
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 | actual_station_design_dim$mean_depth_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
mean depth warehouse 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 | min_depth_m |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
high precision value of minimum depth measured in meters |
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 | year_stn_invalid |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Survey year the station became invalid for trawl |
General Data Type | |
Unit of Measure | year |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Any |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | length_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 | target_station_design_dim$upper_left_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
upper left longitude warehouse identifier for a design type of grid |
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 | station_code |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
unique identifier for a station definition |
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 | station_ul_lat_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of upper left latitude of design type grid measured 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 | station_ll_lon_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of lower left longitude of design type grid measured 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 | 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 | 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 | actual_station_design_dim$lower_left_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of lower left latitude of design type grid measured 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 | 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 | depth_ftm |
---|---|
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 | actual_station_design_dim$transect_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of transect latitude measured 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 | weight_kg |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 3 |
Scale | |
Status | Active |
Description |
Individual weight measured in kilograms |
General Data Type | |
Unit of Measure | kg |
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$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 | width_observation_detail_dim$source_primary |
---|---|
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 | target_station_design_dim$transect_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 |
longitude on transect warehouse identifier for a design type of transect |
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 | actual_station_design_dim$station_grid_dd |
---|---|
Seq. Order | |
Data Storage Type | polygon |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
collection of vertices of grid points of a grid design measured 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 | 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 | actual_station_design_dim$min_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of minimum latitude measured 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 | 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 | 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 | 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 | 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 | target_station_design_dim$lower_left_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
lower left latitude warehouse identifier for a design type of grid |
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 | length_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 | 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 | 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 | 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$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 | statistical_partition_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 statistical partition |
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 | target_station_design_dim$upper_right_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
upper right latitude warehouse identifier for a design type of grid |
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 | length_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 | length_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 | 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 | 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 | 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 | 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 | width_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 | target_station_design_dim$area_hectares |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
station area measured in hectares |
General Data Type | |
Unit of Measure | hectares |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | age_years |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
Individual age measured in years |
General Data Type | |
Unit of Measure | yrs |
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_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 | 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 | 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_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 | 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_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 | actual_station_design_dim$active_polygon_dd |
---|---|
Seq. Order | |
Data Storage Type | polygon |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
collection of vertices of the usuable area inside a station grid measured 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 | 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 | 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 | actual_station_design_dim$lower_right_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
lower right longitude warehouse identifier for a design type of grid |
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 | target_station_design_dim$transect_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of transect latitude measured 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 | mean_seafloor_dep_boundary |
---|---|
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 | 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 | 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 | actual_station_design_dim$station_invalid_survey_year |
---|---|
Seq. Order | |
Data Storage Type | int2 |
Max Length | 16 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Survey year the station became invalid for trawl |
General Data Type | |
Unit of Measure | year |
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_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 |
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 | target_station_design_dim$lower_right_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
lower right longitude warehouse identifier for a design type of grid |
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 | haul_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 | tissue_id |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Tissue sample number or barcode |
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 | actual_station_design_dim$transect_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 |
longitude on transect warehouse identifier for a design type of transect |
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 | field_note |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 1000 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Note made in the field about an individual |
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 | actual_station_design_dim$station_code |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
unique identifier for a station definition |
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 | latitude_dd |
---|---|
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 | actual_station_design_dim$station_design_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
name of the design for a collection of stations |
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_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 | actual_station_design_dim$lower_right_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
lower right latitude warehouse identifier for a design type of grid |
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 | haul_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 | 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 | 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 | actual_station_design_dim$area_hectares |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
station area measured in hectares |
General Data Type | |
Unit of Measure | hectares |
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 | 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 | 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 | 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 | 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 for 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$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 | 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_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 | 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 | 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 | 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 | left_pectoral_fin_id |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 25 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Left pectoral fin sample number or barcode |
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$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 | 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 | 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 | haul_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 haul latitude |
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 | actual_station_design_dim$upper_right_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of upper right latitude of design type grid measured 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 | 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 | actual_station_design_dim$upper_left_longitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of upper left longitude of design type grid measured 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 | 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 | width_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 | haul_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 | 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 | actual_station_design_dim$mean_depth_m |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
high precision value of mean depth measured in meters |
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 | 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$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 | actual_station_design_dim$max_depth_m |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
high precision value of maximum depth measured in meters |
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 | 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_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 | 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 | actual_station_design_dim$reason_station_invalid |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 150 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
reason station was invalidated, multiple reasons are comma separated |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | California State MPA, Cowcod Conservation Area, ENC Avoidance, Farallon Island Radioactive Waste Dump, ONMS MPA, ONMS Permit Exclusion, Outside Survey Extent, Mooring, San Clemente Is. Military test range |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | standard_survey_dim$standard_survey_maturity_indicator |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
identifies if the individual is part of the Standard Maturity Survey |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Standard Survey Maturity, Not Standard Survey Maturity, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | station_lr_lat_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of lower right latitude of design type grid measured 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 | 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 | length_observation_detail_dim$source_primary |
---|---|
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 | target_station_design_dim$max_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of maximum latitude measured 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 | 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 | 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 | 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 | 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 | 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 | target_station_design_dim$lower_left_longitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
lower left longitude warehouse identifier for a design type of grid |
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 | target_station_design_dim$station_grid_dd |
---|---|
Seq. Order | |
Data Storage Type | polygon |
Max Length | |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
collection of vertices of grid points of a grid design measured 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 | 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 | 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 | actual_station_design_dim$stn_invalid_for_trawl_date_whid |
---|---|
Seq. Order | |
Data Storage Type | int8 |
Max Length | 64 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
station design invalidation date warehouse 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 | standard_survey_dim$standard_survey_age_indicator |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
identifies if the individual is part of the Standard Age Survey |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Standard Survey Age, Not Standard Survey Age, NA |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | width_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 | 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 | most_recent_maturity_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 | 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 | 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 | actual_station_design_dim$max_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
maximum latitude warehouse identifier for a design type of transect |
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$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 | 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 | 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 | actual_station_design_dim$upper_left_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of upper left latitude of design type grid measured 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 | 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 | 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$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 | 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 best available 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 | seafloor_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 | station_ul_lon_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of upper left longitude of design type grid measured 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 | 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 | 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 | 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 | actual_station_design_dim$upper_left_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
upper left latitude warehouse identifier for a design type of grid |
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$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 | haul_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 | reason_stn_invalid |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 150 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
reason station was invalidated, multiple reasons are comma separated |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | California State MPA, Cowcod Conservation Area, ENC Avoidance, Farallon Island Radioactive Waste Dump, ONMS MPA, ONMS Permit Exclusion, Outside Survey Extent, Mooring, San Clemente Is. Military test range |
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 | 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 | 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 | 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 | actual_station_design_dim$lower_right_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of lower right latitude of design type grid measured 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 | partition |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Refines the partition type |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Life stage: YOY, larvae, eggs and egg cases, adult, subadult; Size: Large, Small, Unspecified; Gender: Male, Female |
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 | 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 | 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 | 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 | actual_station_design_dim$lower_right_longitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of lower right longitude of design type grid measured 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 | 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 | seafloor_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 for seafloor depth |
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 | target_station_design_dim$mean_depth_m |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 4 |
Scale | |
Status | Active |
Description |
high precision value of mean depth measured in meters |
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 | 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$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 | 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 | 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$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 | most_recent_maturity_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 | statistical_partition_dim$statistical_partition_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Defines the partition type |
General Data Type | |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | Life Stage, Size, Gender |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
station design 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 | Station Design, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
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 | actual_station_design_dim$min_depth_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
minimum depth warehouse 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 | actual_station_design_dim$max_latitude_dd |
---|---|
Seq. Order | |
Data Storage Type | numeric |
Max Length | 12 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 8 |
Scale | |
Status | Active |
Description |
high precision value of maximum latitude measured 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 | 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 | 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 | 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 | 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_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_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 | target_station_design_dim$lower_right_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
lower right latitude warehouse identifier for a design type of grid |
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_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 | haul_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 | actual_station_design_dim$record_type |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 30 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
station design 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 | Station Design, Not Applicable, Unknown/Missing, Bad/Corrupt Data, Not Yet Assigned |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | target_station_design_dim$max_depth_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
maximum depth warehouse 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 | 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 | haul_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 | 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 | actual_station_design_dim$min_latitude_whid |
---|---|
Seq. Order | |
Data Storage Type | int4 |
Max Length | 32 |
Min Length | |
Required | No |
Primary Key | No |
Precision | 0 |
Scale | |
Status | Active |
Description |
minimum latitude warehouse identifier for a design type of transect |
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_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 | most_recent_maturity_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 | 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 | 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 | target_station_design_dim$station_design_name |
---|---|
Seq. Order | |
Data Storage Type | varchar |
Max Length | 50 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
name of the design for a collection of stations |
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 | lab_maturity_detail_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 for 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 | most_recent_maturity_update_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 | most_recent_maturity_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 | |
---|---|
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 | 36438 |
---|---|
Metadata Record Created By | Jeffrey W Cowen |
Metadata Record Created | 2017-01-25 13:15+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 |
---|