RI020AA2_RSCH_V
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 53175
| Published / External
Created: 2018-08-01
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 5843
ID: 53175
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | RI020AA2_RSCH_V |
---|---|
Short Name | RI020AA2_RSCH_V |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Shrimp Morphometric Log data collected on NOAA R/V Townsend Cromwell cruises. |
* 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? | Y |
Alias | |
Schema Name | |
» Description |
Shrimp Morphometric Log data collected on NOAA R/V Townsend Cromwell cruises. |
Change Summary |
Data Attributes
Attribute Summary
Score | Req'd? | PKey? | » Name | Data Storage Type | Description |
---|---|---|---|---|---|
100 | No | No | DATASET_CODE | VARCHAR2 | Source ID Code assigned by the data entry staff. |
100 | No | No | VERSION_CODE | VARCHAR2 | Code for the format version assigned by the data entry staff. |
100 | No | No | VESSEL_CODE | VARCHAR2 | Code for the vessel. |
100 | No | No | CRUISE_NUMBER | VARCHAR2 | Last two digits of the year of the cruise and two-digit incremental number of the cruise for the year. |
100 | No | No | YEAR | VARCHAR2 | Year of capture. |
100 | No | No | MONTH | VARCHAR2 | Month of capture. |
100 | No | No | DAY | VARCHAR2 | Day of capture. |
100 | No | No | STATION_NUMBER_FIRST | VARCHAR2 | First station number. For AA1 format, there was only one capture station number collected. For AA2 format, if only one station number was collected, the same number was entered into STATION_NUMBER_FIRST and STATION_NUMBER_LAST. |
100 | No | No | STATION_NUMBER_LAST | VARCHAR2 | Last station number. |
100 | No | No | LATITUDE_DEGREES | VARCHAR2 | Latitude degrees. Units for values are degrees. |
100 | No | No | LATITUDE_MINUTES | VARCHAR2 | Latitude minutes, in tenths of a minute. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3. |
100 | No | No | LATITUDE_DIRECTION | VARCHAR2 | Latitude direction. |
100 | No | No | LATITUDE_DD | NUMERIC | Computed latitude, in decimal degrees. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. |
100 | No | No | LONGITUDE_DEGREES | VARCHAR2 | Longitude degrees. Units for values are degrees. |
100 | No | No | LONGITUDE_MINUTES | VARCHAR2 | Longitude minutes, in tenths of a minute. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3. |
100 | No | No | LONGITUDE_DIRECTION | VARCHAR2 | Longitude direction. |
100 | No | No | LONGITUDE_DD | NUMERIC | Computed longitude, in decimal degrees. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. |
100 | No | No | BANK_CODE | VARCHAR2 | Seven digit bank code. |
100 | No | No | DEPTH_SET | VARCHAR2 | Set depth, in fathoms. Units for values are fathoms. |
100 | No | No | DEPTH_HAUL | VARCHAR2 | Haul depth in fathoms. Units for values are fathoms. |
100 | No | No | DEPTH_MINIMUM | VARCHAR2 | Minimum depth, in fathoms. For AA1 format, if only one depth, the same number was entered into DEPTH_MINIMUM and DEPTH_MAXIMUM. Units for values are fathoms. |
100 | No | No | DEPTH_MAXIMUM | VARCHAR2 | Maximum depth, in fathoms. Units for values are fathoms. |
100 | No | No | LINE_NUMBER | NUMERIC | A consecutive number for each entry on the collection form. |
100 | No | No | SPECIES_CODE | VARCHAR2 | Czm 10-digit species code. |
100 | No | No | STRING_NUMBER | VARCHAR2 | The consecutive number of the string of traps. |
100 | No | No | GEAR_CODE | VARCHAR2 | Code for the type of gear used. |
100 | No | No | TRAP_NUMBER_FIRST | VARCHAR2 | First trap number. For AA2 format if only one trap number, the same number was entered into TRAP_NUMBER_FIRST AND TRAP_NUMBER_LAST. |
100 | No | No | TRAP_NUMBER_LAST | VARCHAR2 | Last trap number. |
100 | No | No | CARAPACE_LENGTH | VARCHAR2 | Carapace length, in hundredths of a millimeter. For AA1 format, data was collected in tens of millimeter and reformated to hundreds of millimeter. During data entry the decimal point was omitted; it has have been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5. |
100 | No | No | CARAPACE_WIDTH | VARCHAR2 | Carapace width, in hundredths of a millimeter. During data entry the decimal point was omitted; it has have been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5. |
100 | No | No | TOTAL_LENGTH | NUMERIC | Total length, in hundredths of a millimeter. During data entry the decimal point was omitted; it has have been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5. |
100 | No | No | WEIGHT | VARCHAR2 | Weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 3. |
100 | No | No | SEX_CODE | VARCHAR2 | Code for the sex of the species. |
100 | No | No | BERRIED_OVA_COLOR_CODE | VARCHAR2 | Code for the color of the berried ova. |
100 | No | No | MALE_MATURITY_CODE | VARCHAR2 | Code for the maturity of the male. |
100 | No | No | GILL_PARASITE_CODE | VARCHAR2 | Code for the presence of gill parasites. |
100 | No | No | JOB_NUMBER | VARCHAR2 | A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D84233. |
100 | No | No | SEQUENCE_NUMBER | VARCHAR2 | A consecutive number assigned to each record for a block of data. |
100 | No | No | DATE_LOADED | DATE | Date when the record was loaded into Oracle or updated. |
Attribute Details
Attribute Name | DATASET_CODE |
---|---|
Seq. Order | 1 |
Data Storage Type | VARCHAR2 |
Max Length | 5 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Source ID Code assigned by the data entry staff. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | VERSION_CODE |
---|---|
Seq. Order | 2 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for the format version assigned by the data entry staff. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | VESSEL_CODE |
---|---|
Seq. Order | 3 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for the vessel. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 001 = NOAA R/V TOWNSEND CROMWELL |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CRUISE_NUMBER |
---|---|
Seq. Order | 4 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Last two digits of the year of the cruise and two-digit incremental number of the cruise for the year. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | YEAR |
---|---|
Seq. Order | 5 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Year of capture. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MONTH |
---|---|
Seq. Order | 6 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Month of capture. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DAY |
---|---|
Seq. Order | 7 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Day of capture. |
General Data Type | VARCHAR2 |
Unit of 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_NUMBER_FIRST |
---|---|
Seq. Order | 8 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
First station number. For AA1 format, there was only one capture station number collected. For AA2 format, if only one station number was collected, the same number was entered into STATION_NUMBER_FIRST and STATION_NUMBER_LAST. |
General Data Type | VARCHAR2 |
Unit of 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_NUMBER_LAST |
---|---|
Seq. Order | 9 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Last station number. |
General Data Type | VARCHAR2 |
Unit of 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_DEGREES |
---|---|
Seq. Order | 10 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitude degrees. Units for values are degrees. |
General Data Type | VARCHAR2 |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LATITUDE_MINUTES |
---|---|
Seq. Order | 11 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 1 |
Status | Active |
Description |
Latitude minutes, in tenths of a minute. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3. |
General Data Type | VARCHAR2 |
Unit of Measure | minutes |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LATITUDE_DIRECTION |
---|---|
Seq. Order | 12 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Latitude direction. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | N = NORTH; S= SOUTH |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LATITUDE_DD |
---|---|
Seq. Order | 13 |
Data Storage Type | NUMERIC |
Max Length | 41 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 38 |
Status | Active |
Description |
Computed latitude, in decimal degrees. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. |
General Data Type | NUMERIC |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LONGITUDE_DEGREES |
---|---|
Seq. Order | 14 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude degrees. Units for values are degrees. |
General Data Type | VARCHAR2 |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LONGITUDE_MINUTES |
---|---|
Seq. Order | 15 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 1 |
Status | Active |
Description |
Longitude minutes, in tenths of a minute. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3. |
General Data Type | VARCHAR2 |
Unit of Measure | minutes |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LONGITUDE_DIRECTION |
---|---|
Seq. Order | 16 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Longitude direction. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | E = EAST; W = WEST |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LONGITUDE_DD |
---|---|
Seq. Order | 17 |
Data Storage Type | NUMERIC |
Max Length | 41 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 36 |
Status | Active |
Description |
Computed longitude, in decimal degrees. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. |
General Data Type | NUMERIC |
Unit of Measure | degrees |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BANK_CODE |
---|---|
Seq. Order | 18 |
Data Storage Type | VARCHAR2 |
Max Length | 7 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Seven digit bank code. |
General Data Type | VARCHAR2 |
Unit of 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_SET |
---|---|
Seq. Order | 19 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Set depth, in fathoms. Units for values are fathoms. |
General Data Type | VARCHAR2 |
Unit of Measure | fathoms |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEPTH_HAUL |
---|---|
Seq. Order | 20 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Haul depth in fathoms. Units for values are fathoms. |
General Data Type | VARCHAR2 |
Unit of Measure | fathoms |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEPTH_MINIMUM |
---|---|
Seq. Order | 21 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Minimum depth, in fathoms. For AA1 format, if only one depth, the same number was entered into DEPTH_MINIMUM and DEPTH_MAXIMUM. Units for values are fathoms. |
General Data Type | VARCHAR2 |
Unit of Measure | fathoms |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | DEPTH_MAXIMUM |
---|---|
Seq. Order | 22 |
Data Storage Type | VARCHAR2 |
Max Length | 3 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Maximum depth, in fathoms. Units for values are fathoms. |
General Data Type | VARCHAR2 |
Unit of Measure | fathoms |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | LINE_NUMBER |
---|---|
Seq. Order | 23 |
Data Storage Type | NUMERIC |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A consecutive number for each entry on the collection form. |
General Data Type | NUMERIC |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SPECIES_CODE |
---|---|
Seq. Order | 24 |
Data Storage Type | VARCHAR2 |
Max Length | 10 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Czm 10-digit species code. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | STRING_NUMBER |
---|---|
Seq. Order | 25 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
The consecutive number of the string of traps. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GEAR_CODE |
---|---|
Seq. Order | 26 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for the type of gear used. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRAP_NUMBER_FIRST |
---|---|
Seq. Order | 27 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
First trap number. For AA2 format if only one trap number, the same number was entered into TRAP_NUMBER_FIRST AND TRAP_NUMBER_LAST. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TRAP_NUMBER_LAST |
---|---|
Seq. Order | 28 |
Data Storage Type | VARCHAR2 |
Max Length | 2 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Last trap number. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CARAPACE_LENGTH |
---|---|
Seq. Order | 29 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 2 |
Status | Active |
Description |
Carapace length, in hundredths of a millimeter. For AA1 format, data was collected in tens of millimeter and reformated to hundreds of millimeter. During data entry the decimal point was omitted; it has have been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5. |
General Data Type | VARCHAR2 |
Unit of Measure | millimeters |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | CARAPACE_WIDTH |
---|---|
Seq. Order | 30 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 2 |
Status | Active |
Description |
Carapace width, in hundredths of a millimeter. During data entry the decimal point was omitted; it has have been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5. |
General Data Type | VARCHAR2 |
Unit of Measure | millimeters |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | TOTAL_LENGTH |
---|---|
Seq. Order | 31 |
Data Storage Type | NUMERIC |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 2 |
Status | Active |
Description |
Total length, in hundredths of a millimeter. During data entry the decimal point was omitted; it has have been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5. |
General Data Type | NUMERIC |
Unit of Measure | millimeters |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | WEIGHT |
---|---|
Seq. Order | 32 |
Data Storage Type | VARCHAR2 |
Max Length | 4 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | 1 |
Status | Active |
Description |
Weight, in tenths of a gram. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are grams. Measures are reported with a precision of 3. |
General Data Type | VARCHAR2 |
Unit of Measure | grams |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SEX_CODE |
---|---|
Seq. Order | 33 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for the sex of the species. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | F = FEMALE; I = IMMATURE; M = MALE; U = UNKNOWN, UNDETERMINED |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | BERRIED_OVA_COLOR_CODE |
---|---|
Seq. Order | 34 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for the color of the berried ova. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1 = ORANGE; 2 = BROWN; 3 = WHITE; 4 = BLUE; 5 = BERRIED (COLOR NOT RECORDED); } = UNKNOWN CODE |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | MALE_MATURITY_CODE |
---|---|
Seq. Order | 35 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for the maturity of the male. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 0 = BLANK OR -; 3 = I, IMMATURE; 5 = IU, BETWEEN IMMATURE/UNDERDEVELOPED; 7 = U, UNDEVELOPED 9 = CU, COMPLETELY UNDEVELOPED; } = UNKNOWN CODE |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | GILL_PARASITE_CODE |
---|---|
Seq. Order | 36 |
Data Storage Type | VARCHAR2 |
Max Length | 1 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Code for the presence of gill parasites. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | 1 = GILL PARASITE PRESENT |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | JOB_NUMBER |
---|---|
Seq. Order | 37 |
Data Storage Type | VARCHAR2 |
Max Length | 6 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A consecutive number assigned by the data entry staff to a block of data that is entered and verified. Format DYYNNN, where D is constant, YY is the last two digits of the year and NNN is the consecutive number that starts with 001 at the beginning of each calendar year, e.g., D84233. |
General Data Type | VARCHAR2 |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
Allowed Values | |
Default Value | |
Foreign Key Relations | |
Derivation | |
Validation Rules |
Attribute Name | SEQUENCE_NUMBER |
---|---|
Seq. Order | 38 |
Data Storage Type | VARCHAR2 |
Max Length | 8 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
A consecutive number assigned to each record for a block of data. |
General Data Type | VARCHAR2 |
Unit of 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_LOADED |
---|---|
Seq. Order | 39 |
Data Storage Type | DATE |
Max Length | 22 |
Min Length | |
Required | No |
Primary Key | No |
Precision | |
Scale | |
Status | Active |
Description |
Date when the record was loaded into Oracle or updated. |
General Data Type | DATE |
Unit of Measure | |
Case Restriction | |
Display Example | |
Format Mask | |
Null Value | |
Null Value Meaning | |
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 |
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 | 53175 |
---|---|
Metadata Record Created By | Brent M Miyamoto |
Metadata Record Created | 2018-08-01 18:53+0000 |
Metadata Record Last Modified By | SysAdmin InPortAdmin |
» Metadata Record Last Modified | 2022-08-09 17:11+0000 |
Metadata Record Published | 2021-01-14 |
Owner Org | PIFSC |
Metadata Publication Status | Published Externally |
Do Not Publish? | N |
Metadata Workflow State | Published / External |
Metadata Last Review Date | 2021-01-14 |
Metadata Review Frequency | 1 Year |
Metadata Next Review Date | 2022-01-14 |
Tags |
---|