RI020AA2_CONF_V
Pacific Islands Fisheries Science Center
Entity
(ENT)
| ID: 53177
| Published / External
Created: 2018-08-01
|
Last Modified: 2022-08-09
Data Set (DS) | ID: 53108
ID: 53177
Entity (ENT)
* Discovery• First Pass
» Metadata Rubric
Item Identification
* » Title | RI020AA2_CONF_V |
---|---|
Short Name | RI020AA2_CONF_V |
* Status | Completed |
Creation Date | |
Revision Date | |
• Publication Date | |
* » Abstract |
Shrimp Morphometric Log data collected on a commercial fishery vessel - CONFIDENTIAL. |
* 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 a commercial fishery vessel - CONFIDENTIAL. |
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 and entered. |
100 | No | No | STATION_NUMBER_LAST | VARCHAR2 | Last station number. |
100 | No | No | LATITUDE_DEGREES | VARCHAR2 | Latitude degrees. Units for values are degrees. Data was collected but not entered. |
100 | No | No | LATITUDE_MINUTES | VARCHAR2 | Latitude minutes, in tenths of a minute. Units for values are minutes. Data was collected but not entered. |
100 | No | No | LATITUDE_DIRECTION | VARCHAR2 | Latitude direction. Data was collected but not entered. |
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. Data was collected but not entered. |
100 | No | No | LONGITUDE_MINUTES | VARCHAR2 | Longitude minutes, in tenths of a minute. Units for values are minutes. Data was collected but not entered. |
100 | No | No | LONGITUDE_DIRECTION | VARCHAR2 | Longitude direction. Data was collected but not entered. |
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. Units for values are millimeters. |
100 | No | No | TOTAL_LENGTH | NUMERIC | Total length, in hundredths of a millimeter. Units for values are millimeters. |
100 | No | No | WEIGHT | VARCHAR2 | Weight, in tenths of a gram. Units for values are grams. |
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., D84371. |
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 | |
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 and entered. |
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. Data was collected but not entered. |
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. Units for values are minutes. Data was collected but not entered. |
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. Data was collected but not entered. |
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_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. Data was collected but not entered. |
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. Units for values are minutes. Data was collected but not entered. |
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. Data was collected but not entered. |
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 | 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 | 2020100 = GUAM |
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 | 6483460301 = HETEROCARPUS ENSIFER; 6483460302 = HETEROCARPUS LAEVIGATUS; 6483460303 = HETEROCARPUS SIBOGAE; 6483460304 = HETEROCARPUS DORSALIS; 6483460305 = HETEROCARPUS LEPIDUS |
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. Units for values are millimeters. |
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. Units for values are millimeters. |
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. Units for values are grams. |
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; M = MALE |
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) |
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 | |
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., D84371. |
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 | 53177 |
---|---|
Metadata Record Created By | Brent M Miyamoto |
Metadata Record Created | 2018-08-01 18:55+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 |
---|