RP050AA3_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:65531 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | RP050AA3_V |
---|---|
Short Name: | RP050AA3_V |
Status: | Completed |
Abstract: |
Pelagic surface longline data collected during a NOAA R/V Townsend Crowell cruise in 1990 at SE Hancock Seamount. |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Description: |
Pelagic surface longline data collected during a NOAA R/V Townsend Crowell cruise in 1990 at SE Hancock Seamount. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
DATASET_CODE | VARCHAR2 | Source ID Code assigned by the data entry staff. | |
100
|
VERSION_CODE | VARCHAR2 | Code for the format version assigned by the data entry staff. | |
100
|
VESSEL_CODE | VARCHAR2 | Code for the vessel. | |
100
|
CRUISE_NUMBER | VARCHAR2 | Last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 9006. | |
100
|
DATA_TYPE_CODE | VARCHAR2 | Code for the type of longline operation. | |
100
|
STATION_NUMBER | VARCHAR2 | Station number of the longline operataion. | |
100
|
BANK_CODE | VARCHAR2 | Seven digit bank code. | |
100
|
SET_LATITUDE_DEGREES | VARCHAR2 | Set latitude degrees. Units for values are degrees. | |
100
|
SET_LATITUDE_MINUTES | VARCHAR2 | Set 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
|
SET_LATITUDE_DIRECTION | VARCHAR2 | Set latitude direction. | |
100
|
SET_LATITUDE_DD | NUMBER | Computed set latitude, in decimal degrees. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. | |
100
|
SET_LONGITUDE_DEGREES | VARCHAR2 | Set longitude degrees. Units for values are degrees. | |
100
|
SET_LONGITUDE_MINUTES | VARCHAR2 | Set 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
|
SET_LONGITUDE_DIRECTION | VARCHAR2 | Set longitude direction. | |
100
|
SET_LONGITUDE_DD | NUMBER | Computed set longitude, in decimal degrees. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. | |
100
|
HAUL_LATITUDE_DEGREES | VARCHAR2 | Haul latitude degrees. Units for values are degrees. | |
100
|
HAUL_LATITUDE_MINUTES | VARCHAR2 | Haul 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
|
HAUL_LATITUDE_DIRECTION | VARCHAR2 | Haul latitude direction. | |
100
|
HAUL_LATITUDE_DD | NUMBER | Computed haul latitude, in decimal degrees. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. | |
100
|
HAUL_LONGITUDE_DEGREES | VARCHAR2 | Haul longitude degrees. Units for values are degrees. | |
100
|
HAUL_LONGITUDE_MINUTES | VARCHAR2 | Haul longitude minutes, in tenths of a minute. During data entry, the decimal was omitted; it has been inserted into the data. Units for values are minutes. Measures are reported with a precision of 3. | |
100
|
HAUL_LONGITUDE_DIRECTION | VARCHAR2 | Haul longitude direction. | |
100
|
HAUL_LONGITUDE_DD | NUMBER | Computed haul longitude, in decimal degrees. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. | |
100
|
SET_YEAR | VARCHAR2 | Set year. | |
100
|
SET_MONTH | VARCHAR2 | Set month. | |
100
|
SET_DAY | VARCHAR2 | Set day. | |
100
|
SET_TIME | VARCHAR2 | Set time. | |
100
|
SET_START_DEPTH | VARCHAR2 | Set start depth. Units not written, but assumed to be fathoms, since AA1 and AA2 depth units are fathoms. Units for values are fathoms. | |
100
|
SET_END_DEPTH | VARCHAR2 | Set end depth. Units not written, but assumed to be fathoms, since AA1 and AA2 depth units are fathoms. Units for values are fathoms. | |
100
|
HAUL_YEAR | VARCHAR2 | Haul year. | |
100
|
HAUL_MONTH | VARCHAR2 | Haul month. | |
100
|
HAUL_DAY | VARCHAR2 | Haul day. | |
100
|
HAUL_TIME | VARCHAR2 | Haul time. | |
100
|
HAUL_START_DEPTH | VARCHAR2 | Haul start depth. Units not written, but assumed to be fathoms, since the AA1 and AA2 depth units are fathoms. Units for values are fathoms. | |
100
|
HAUL_END_DEPTH | VARCHAR2 | Haul end depth. Units not written, but assumed to be fathoms, since AA1 and AA2 depth units are fathoms. Units for values are fathoms. | |
100
|
FLOATLINE | VARCHAR2 | Floatline, in fathoms. Units for values are fathoms. | |
100
|
DROPPER_LENGTH | VARCHAR2 | Dropper length, in meters. Units for values are meters. | |
100
|
DROPPER_SPACING | VARCHAR2 | Dropper spacing, in fathoms. Units for values are fathoms. | |
100
|
TOTAL_HOOKS | VARCHAR2 | Total number of hooks. | |
100
|
HOOK_TYPE_1 | VARCHAR2 | Hook Type 1. | |
100
|
HOOK_TYPE_2 | VARCHAR2 | Hook Type 2. | |
100
|
HOOK_TYPE_3 | VARCHAR2 | Hook Type 3. | |
100
|
HOOK_TYPE_4 | VARCHAR2 | Hook Type 4. | |
100
|
BAIT_CODE | VARCHAR2 | Code for the bait used. | |
100
|
TEMPERATURE_SURFACE | VARCHAR2 | Surface temperature, in tenths of a degree Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Centigrade. Measures are reported with a precision of 3. | |
100
|
TEMPERATURE_BOTTOM | VARCHAR2 | Bottom temperature, in tenths of a degree Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Centigrade. Measures are reported with a precision of 3. | |
100
|
STRING_NUMBER | VARCHAR2 | String number. | |
100
|
HOOK_NUMBER | VARCHAR2 | Hook number. | |
100
|
HOOK_SIZE | VARCHAR2 | Hook size. | |
100
|
FISH_NUMBER | VARCHAR2 | Fish number. | |
100
|
SPECIES_CODE | VARCHAR2 | Ten digit CZM species code. | |
100
|
FORK_LENGTH | VARCHAR2 | Fork length, tenths of a centimeter. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 4. | |
100
|
WEIGHT | VARCHAR2 | Weight, in hundredths of a kilogram. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are kilograms. Measures are reported with a precision of 4. | |
100
|
SHARK_EATEN | VARCHAR2 | Shark eaten, null = blank, 1 = checked. | |
100
|
HOOK_LOST | VARCHAR2 | Hook lost, null = blank, 1 = checked. | |
100
|
BAIT | VARCHAR2 | Bait, null = blank, 1 = checked. | |
100
|
TANGLE | VARCHAR2 | Tangle, null = blank, 1 = checked. | |
100
|
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., D90327. | |
100
|
SEQUENCE_NUMBER | VARCHAR2 | A consecutive number assigned to each record for a block of data. | |
100
|
DATE_LOADED | DATE | Date when the record was loaded into Oracle or updated. |
Attribute Details
DATASET_CODE
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Source ID Code assigned by the data entry staff. |
General Data Type: | VARCHAR2 |
VERSION_CODE
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the format version assigned by the data entry staff. |
General Data Type: | VARCHAR2 |
VESSEL_CODE
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the vessel. |
General Data Type: | VARCHAR2 |
Allowed Values: | 001 = NOAA R/V TOWNSEND CROMWELL |
CRUISE_NUMBER
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 9006. |
General Data Type: | VARCHAR2 |
DATA_TYPE_CODE
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the type of longline operation. |
General Data Type: | VARCHAR2 |
Allowed Values: | 3 = PELAGIC SURFACE LONGLINE |
STATION_NUMBER
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Station number of the longline operataion. |
General Data Type: | VARCHAR2 |
BANK_CODE
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Seven digit bank code. |
General Data Type: | VARCHAR2 |
Allowed Values: | 1270100 = SE HANCOCK SEAMOUNT |
SET_LATITUDE_DEGREES
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Set latitude degrees. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
SET_LATITUDE_MINUTES
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
Set 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 |
SET_LATITUDE_DIRECTION
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Set latitude direction. |
General Data Type: | VARCHAR2 |
Allowed Values: | N = NORTH; S = SOUTH |
SET_LATITUDE_DD
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 41 |
Required: | No |
Primary Key: | No |
Scale: | 38 |
Status: | Active |
Description: |
Computed set latitude, in decimal degrees. Postive 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: | NUMBER |
Unit of Measure: | degrees |
SET_LONGITUDE_DEGREES
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Set longitude degrees. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
SET_LONGITUDE_MINUTES
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
Set 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 |
SET_LONGITUDE_DIRECTION
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Set longitude direction. |
General Data Type: | VARCHAR2 |
Allowed Values: | E = EAST; W = WEST |
SET_LONGITUDE_DD
Seq. Order: | 15 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Scale: | 36 |
Status: | Active |
Description: |
Computed set longitude, in decimal degrees. Postive 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: | NUMBER |
Unit of Measure: | degrees |
HAUL_LATITUDE_DEGREES
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul latitude degrees. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
HAUL_LATITUDE_MINUTES
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
Haul 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 |
HAUL_LATITUDE_DIRECTION
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul latitude direction. |
General Data Type: | VARCHAR2 |
Allowed Values: | N = NORTH; S = SOUTH |
HAUL_LATITUDE_DD
Seq. Order: | 19 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 41 |
Required: | No |
Primary Key: | No |
Scale: | 38 |
Status: | Active |
Description: |
Computed haul latitude, in decimal degrees. Postive 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: | NUMBER |
Unit of Measure: | degrees |
HAUL_LONGITUDE_DEGREES
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul longitude degrees. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
HAUL_LONGITUDE_MINUTES
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
Haul longitude minutes, in tenths of a minute. During data entry, the decimal 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 |
HAUL_LONGITUDE_DIRECTION
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul longitude direction. |
General Data Type: | VARCHAR2 |
Allowed Values: | E = EAST; W = WEST |
HAUL_LONGITUDE_DD
Seq. Order: | 23 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Scale: | 36 |
Status: | Active |
Description: |
Computed haul longitude, in decimal degrees. Postive 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: | NUMBER |
Unit of Measure: | degrees |
SET_YEAR
Seq. Order: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Set year. |
General Data Type: | VARCHAR2 |
SET_MONTH
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Set month. |
General Data Type: | VARCHAR2 |
SET_DAY
Seq. Order: | 26 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Set day. |
General Data Type: | VARCHAR2 |
SET_TIME
Seq. Order: | 27 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Set time. |
General Data Type: | VARCHAR2 |
SET_START_DEPTH
Seq. Order: | 28 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Set start depth. Units not written, but assumed to be fathoms, since AA1 and AA2 depth units are fathoms. Units for values are fathoms. |
General Data Type: | VARCHAR2 |
Unit of Measure: | fathoms |
SET_END_DEPTH
Seq. Order: | 29 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Set end depth. Units not written, but assumed to be fathoms, since AA1 and AA2 depth units are fathoms. Units for values are fathoms. |
General Data Type: | VARCHAR2 |
Unit of Measure: | fathoms |
HAUL_YEAR
Seq. Order: | 30 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul year. |
General Data Type: | VARCHAR2 |
HAUL_MONTH
Seq. Order: | 31 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul month. |
General Data Type: | VARCHAR2 |
HAUL_DAY
Seq. Order: | 32 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul day. |
General Data Type: | VARCHAR2 |
HAUL_TIME
Seq. Order: | 33 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul time. |
General Data Type: | VARCHAR2 |
HAUL_START_DEPTH
Seq. Order: | 34 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul start depth. Units not written, but assumed to be fathoms, since the AA1 and AA2 depth units are fathoms. Units for values are fathoms. |
General Data Type: | VARCHAR2 |
Unit of Measure: | fathoms |
HAUL_END_DEPTH
Seq. Order: | 35 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Haul end depth. Units not written, but assumed to be fathoms, since AA1 and AA2 depth units are fathoms. Units for values are fathoms. |
General Data Type: | VARCHAR2 |
Unit of Measure: | fathoms |
FLOATLINE
Seq. Order: | 36 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Floatline, in fathoms. Units for values are fathoms. |
General Data Type: | VARCHAR2 |
Unit of Measure: | fathoms |
DROPPER_LENGTH
Seq. Order: | 37 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Dropper length, in meters. Units for values are meters. |
General Data Type: | VARCHAR2 |
Unit of Measure: | meters |
DROPPER_SPACING
Seq. Order: | 38 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Dropper spacing, in fathoms. Units for values are fathoms. |
General Data Type: | VARCHAR2 |
Unit of Measure: | fathoms |
TOTAL_HOOKS
Seq. Order: | 39 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Total number of hooks. |
General Data Type: | VARCHAR2 |
HOOK_TYPE_1
Seq. Order: | 40 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Hook Type 1. |
General Data Type: | VARCHAR2 |
HOOK_TYPE_2
Seq. Order: | 41 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Hook Type 2. |
General Data Type: | VARCHAR2 |
HOOK_TYPE_3
Seq. Order: | 42 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Hook Type 3. |
General Data Type: | VARCHAR2 |
HOOK_TYPE_4
Seq. Order: | 43 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Hook Type 4. |
General Data Type: | VARCHAR2 |
BAIT_CODE
Seq. Order: | 44 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the bait used. |
General Data Type: | VARCHAR2 |
Allowed Values: | 04 = SQUID |
TEMPERATURE_SURFACE
Seq. Order: | 45 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
Surface temperature, in tenths of a degree Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Centigrade. Measures are reported with a precision of 3. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees Centigrade |
TEMPERATURE_BOTTOM
Seq. Order: | 46 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
Bottom temperature, in tenths of a degree Centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are degrees Centigrade. Measures are reported with a precision of 3. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees Centigrade |
STRING_NUMBER
Seq. Order: | 47 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
String number. |
General Data Type: | VARCHAR2 |
HOOK_NUMBER
Seq. Order: | 48 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Hook number. |
General Data Type: | VARCHAR2 |
HOOK_SIZE
Seq. Order: | 49 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Hook size. |
General Data Type: | VARCHAR2 |
FISH_NUMBER
Seq. Order: | 50 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Fish number. |
General Data Type: | VARCHAR2 |
SPECIES_CODE
Seq. Order: | 51 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Ten digit CZM species code. |
General Data Type: | VARCHAR2 |
Allowed Values: | 0000000000 = NO CATCH; 8516080102 = ALOPIAS PELAGICUS; 8516120101 = PRIONACE GLAUCA; 8516120505 = CARCHARHINUS GALAPAGENSIS; 8516120506 = CARCHARHINUS MAOU (CZM LIST 10/78)(C. LONGIMANUS); 8555720201 = PROMETHICHTHYS PROMETHEUS; 8555740200 = SCOMBER SP.; 8555740703 = THUNNUS ALBACARES; 8555750101 = XIPHIAS GLADIUS; NULL = LOST GEAR |
FORK_LENGTH
Seq. Order: | 52 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
Fork length, tenths of a centimeter. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are centimeters. Measures are reported with a precision of 4. |
General Data Type: | VARCHAR2 |
Unit of Measure: | centimeters |
WEIGHT
Seq. Order: | 53 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Scale: | 2 |
Status: | Active |
Description: |
Weight, in hundredths of a kilogram. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are kilograms. Measures are reported with a precision of 4. |
General Data Type: | VARCHAR2 |
Unit of Measure: | kilograms |
SHARK_EATEN
Seq. Order: | 54 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Shark eaten, null = blank, 1 = checked. |
General Data Type: | VARCHAR2 |
Allowed Values: | NULL = SHARK EATEN CELL BLANK; 1 = SHARK EATEN CELL CHECKED ON DATA COLLECTION FORM |
HOOK_LOST
Seq. Order: | 55 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Hook lost, null = blank, 1 = checked. |
General Data Type: | VARCHAR2 |
Allowed Values: | NULL = HOOK LOST CELL BLANK; 1 = HOOK LOST CELL CHECKED ON DATA COLLECTION FORM |
BAIT
Seq. Order: | 56 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Bait, null = blank, 1 = checked. |
General Data Type: | VARCHAR2 |
Allowed Values: | NULL = BAIT CELL BLANK; 1 =BAIT CELL CHECKED ON DATA COLLECTION FORM |
TANGLE
Seq. Order: | 57 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Tangle, null = blank, 1 = checked. |
General Data Type: | VARCHAR2 |
Allowed Values: | NULL = TANGLE CELL BLANK; 1 = TANGLE CELL CHECKED ON DATA COLLECTION FORM |
JOB_NUMBER
Seq. Order: | 58 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
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., D90327. |
General Data Type: | VARCHAR2 |
SEQUENCE_NUMBER
Seq. Order: | 59 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 8 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A consecutive number assigned to each record for a block of data. |
General Data Type: | VARCHAR2 |
DATE_LOADED
Seq. Order: | 60 |
---|---|
Data Storage Type: | DATE |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date when the record was loaded into Oracle or updated. |
General Data Type: | DATE |
Catalog Details
Catalog Item ID: | 65531 |
---|---|
GUID: | gov.noaa.nmfs.inport:65531 |
Metadata Record Created By: | Brent M Miyamoto |
Metadata Record Created: | 2021-09-24 02:05+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2021-09-24 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-09-24 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-09-24 |