RV001AA3_CONF_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:70843 | Updated: October 7, 2023 | Published / External
Item Identification
Title: | RV001AA3_CONF_V |
---|---|
Short Name: | RV001AA3_CONF_V |
Status: | Completed |
Abstract: |
Occurrence of birds, aquatic mammals and fish schools log. |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Description: |
Occurrence of birds, aquatic mammals and fish schools log. |
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 | Four digit incremental cruise number of the vessel, e.g., 0001, or the last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 7604. | |
100
|
YEAR | VARCHAR2 | Local year of sighting. | |
100
|
MONTH | VARCHAR2 | Local month of sighting. | |
100
|
DAY | VARCHAR2 | Local day of sighting. | |
100
|
TIME_ZONE_CODE | VARCHAR2 | Time zone code of sighting. | |
100
|
LOCAL_TIME | VARCHAR2 | Local time of sighting; the hour and minute fields were merged into one field. | |
100
|
OCTANT_FLOCK_SCHOOL | VARCHAR2 | Octant of the bird flock or fish school sighting. | |
100
|
LATITUDE_DEGREES_FLOCK_SCHOOL | VARCHAR2 | Latitude degrees when the bird flock or fish school was sighted. Units for values are degrees. | |
100
|
LATITUDE_MINUTES_FLOCK_SCHOOL | VARCHAR2 | Latitude minutes when the bird flock or fish school was sighted. Units for values are minutes. | |
100
|
LATITUDE_DIRECTION_FLOCK_SCHOOL | VARCHAR2 | Latitude direction when the bird flock or fish school was sighted. OCTANT used to determine LATITUDE_DIRECTION_FLOCK_SCHOOL (N/S). | |
100
|
LATITUDE_DD_FLOCK_SCHOOL | NUMBER | Computed latitude, in decimal degrees, when the bird flock or fish school was sighted. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. | |
100
|
LONGITUDE_DEGREES_FLOCK_SCHOOL | VARCHAR2 | Longitude degrees when the bird flock or fish school was sighted. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using OCTANT. Units for values are degrees. | |
100
|
LONGITUDE_MINUTES_FLOCK_SCHOOL | VARCHAR2 | Longitude minutes when the bird flock or fish school was sighted. Units for values are minutes. | |
100
|
LONGITUDE_DIRECTION_FLOCK_SCHOOL | VARCHAR2 | Longitude direction when the bird flock or fish school was sighted. OCTANT used to determine LONGITUDE_DIRECTION_FLOCK_SCHOOL (E/W). | |
100
|
LONGITUDE_DD_FLOCK_SCHOOL | NUMBER | Computed longitude, in decimal degrees, when the bird flock or fish school was sighted. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. | |
100
|
SIZE_FLOCK_CODE | VARCHAR2 | Code for the size of the bird flock. | |
100
|
SOOTY_TERN_PRESENT_CODE | VARCHAR2 | Code whether SOOTY TERN was present. Value could also be SIZE_FLOCK_CODE. | |
100
|
NODDY_TERN_PRESENT_CODE | VARCHAR2 | Code whether NOODY TERN was present. Value could also be SIZE_FLOCK_CODE. | |
100
|
WHITE_TERN_PRESENT_CODE | VARCHAR2 | Code whether WHITE TERN was present. Value could also be SIZE_FLOCK_CODE. | |
100
|
BOOBY_PRESENT_CODE | VARCHAR2 | Code whether BOOBY was present. Value could also be SIZE_FLOCK_CODE. | |
100
|
TROPIC_BIRD_PRESENT_CODE | VARCHAR2 | Code whether TROPIC BIRD was present. Value could also be SIZE_FLOCK_CODE. | |
100
|
FRIGATE_BIRD_PRESENT_CODE | VARCHAR2 | Code whether FRIGATE BIRD was present. Value could also be SIZE_FLOCK_CODE. | |
100
|
PETREL_SHEARWATER_PRESENT_CODE | VARCHAR2 | Code whether PETREL or SHEARWATER was present. Value could also be SIZE_FLOCK_CODE. | |
100
|
STORM_PETREL_PRESENT_CODE | VARCHAR2 | Code whether STORM PETREL was present. Value could also be SIZE_FLOCK_CODE. | |
100
|
ALBATROSS_PRESENT_CODE | VARCHAR2 | Code whether ALBATROSS was present. Value could also be SIZE_FLOCK_CODE. | |
100
|
OTHER_BIRDS_PRESENT_CODE | VARCHAR2 | Code whether OTHER BIRDS were present. Value could also be SIZE_FLOCK_CODE. | |
100
|
SPECIES_CODE_FLOCK_SCHOOL_2 | VARCHAR2 | Two-digit species code of the bird flock or fish school. | |
100
|
SPECIES_CODE_FLOCK_SCHOOL_5 | VARCHAR2 | Five-digit CZM species code of the bird flock or fish school. | |
100
|
SPECIES_CODE_FLOCK_SCHOOL | VARCHAR2 | Ten-digit CZM species code of the bird flock or fish school. Originally two-digit, five_digit or ten-digit species codes resided in the one column. They are now in separate columns, and there is a corresponding ten-digit code for each two-digit and five_digit species code. | |
100
|
AVERAGE_SIZE_FISH_KG | VARCHAR2 | Average fish weight, in kilograms. Units for values are kilograms. | |
100
|
AVERAGE_SIZE_FISH_LB | VARCHAR2 | Average fish weight, in pounds. Units for values are pounds. | |
100
|
SIZE_SCHOOL_CODE | VARCHAR2 | Code for the size of the fish school. | |
100
|
TIME_POSITION_TAKEN | VARCHAR2 | Time position taken; the hour field and minute field were merged into one field. | |
100
|
OCTANT_SCATTER | VARCHAR2 | Octant of the sighting of scattered species. | |
100
|
LATITUDE_DEGREES_SCATTER | VARCHAR2 | Latitude degrees when the scattered species was sighted. Units for values are degrees. | |
100
|
LATITUDE_MINUTES_SCATTER | VARCHAR2 | Latitude minutes when the scattered species was sighted. Units for values are minutes. | |
100
|
LATITUDE_DIRECTION_SCATTER | VARCHAR2 | Latitude direction when the scattered species was sighted. OCTANT used to determine LATITUDE_DIRECTION_SCATTER (N/S). | |
100
|
LATITUDE_DD_SCATTER | NUMBER | Computed latitude, in decimal degree, when the scattered species was sighted. Postive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. | |
100
|
LONGITUDE_DEGREES_SCATTER | VARCHAR2 | Longitude degrees when the scattered species was sighted. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using OCTANT. Units for values are degrees. | |
100
|
LONGITUDE_MINUTES_SCATTER | VARCHAR2 | Longitude minutes when the scattered species was sighted. Units for values are minutes. | |
100
|
LONGITUDE_DIRECTION_SCATTER | VARCHAR2 | Longitude direction when the scattered species was sighted. OCTANT used to determine LONGITUDE_DIRECTION_SCATTER (E/W). | |
100
|
LONGITUDE_DD_SCATTER | NUMBER | Computed longitude, in decimal degrees, when the scattered species was sighted. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. | |
100
|
SOOTY_TERN_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered SOOTY TERN sighted. See SIZE_FLOCK_CODE. | |
100
|
NODDY_TERN_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered NODDY TERN sighted. See SIZE_FLOCK_CODE. | |
100
|
WHITE_TERN_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered WHITE TERN sighted. See SIZE_FLOCK_CODE. | |
100
|
BOOBY_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered BOOBY sighted. See SIZE_FLOCK_CODE. | |
100
|
TROPIC_BIRD_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered TROPIC BIRD TERN sighted. See SIZE_FLOCK_CODE. | |
100
|
FRIGATE_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered FRIGATE BIRD sighted. See SIZE_FLOCK_CODE. | |
100
|
PETREL_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered PETREL or SHEARWATER sighted. See SIZE_FLOCK_CODE. | |
100
|
STORM_PETREL_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered STORM PETREL sighted. See SIZE_FLOCK_CODE. | |
100
|
ALBATROSS_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered ALBATROSS sighted. See SIZE_FLOCK_CODE. | |
100
|
OTHER_BIRDS_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered OTHER BIRDS sighted. See SIZE_FLOCK_CODE. | |
100
|
WHALES_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered WHALES sighted. See SIZE_FLOCK_CODE. | |
100
|
PORPOISES_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered PORPOISES sighted. See SIZE_FLOCK_CODE. | |
100
|
SEALS_SCATTER_COUNT_CODE | VARCHAR2 | Count code for the scattered SEALS sighted. See SIZE_FLOCK_CODE. | |
100
|
SPECIES_CODE_OTHERS_SCATTER_2 | VARCHAR2 | Two-digit species code of scattered other species sighted. | |
100
|
SPECIES_CODE_OTHERS_SCATTER_5 | VARCHAR2 | Five-digit CZM species code of scattered other species sighted. | |
100
|
SPECIES_CODE_OTHERS_SCATTER | VARCHAR2 | Ten-digit CZM species code of scattered other species sighted. Originally two-digit, five_digit or ten-digit species codes resided in the one column. They are now in separate columns, and there is a corresponding ten-digit code for each two-digit and five_digit species code. | |
100
|
OTHERS_SCATTER_COUNT | VARCHAR2 | Count of scattered other species sighted. | |
100
|
OTHERS_SCATTER_COUNT_CODE | VARCHAR2 | Count code for scattered other species sighted. See SIZE_FLOCK_CODE. | |
100
|
NUMBER_HOURS_WATCHED_0800 | VARCHAR2 | Number of hours watched ending at 0800 or the time the position was taken (FIELD 36). | |
100
|
NUMBER_HOURS_WATCHED_1200 | VARCHAR2 | Number of hours watched ending at 1200 or the time the position was taken (FIELD 36). | |
100
|
NUMBER_HOURS_WATCHED_1600 | VARCHAR2 | Number of hours watched ending at 1600 or the time the position was taken (FIELD 36). | |
100
|
NUMBER_HOURS_WATCHED_2000 | VARCHAR2 | Number of hours watched ending a 2000 or the time the position was taken (FIELD 36). | |
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., D84109. | |
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 |
CRUISE_NUMBER
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Four digit incremental cruise number of the vessel, e.g., 0001, or the last two digits of the year of the cruise and two digits incremental number of the cruise for the year, e.g., 7604. |
General Data Type: | VARCHAR2 |
YEAR
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Local year of sighting. |
General Data Type: | VARCHAR2 |
MONTH
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Local month of sighting. |
General Data Type: | VARCHAR2 |
DAY
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Local day of sighting. |
General Data Type: | VARCHAR2 |
TIME_ZONE_CODE
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time zone code of sighting. |
General Data Type: | VARCHAR2 |
Allowed Values: | A = MINUS 1; B = MINUS 2; C = MINUS 3; D = MINUS 4; E = MINUS 5; F = MINUS 6; G = MINUS 7; H = MINUS 8; I = MINUS 9; K = MINUS 10; L = MINUS 11; M = MINUS 12; N = PLUS 1; O = PLUS 2; P = PLUS 3; Q = PLUS 4; R = PLUS 5; S = PLUS 6; T = PLUS 7; U = PLUS 8; V = PLUS 9; W = PLUS 10; X = PLUS 11; Y = PLUS 12; Z = 0 |
LOCAL_TIME
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Local time of sighting; the hour and minute fields were merged into one field. |
General Data Type: | VARCHAR2 |
OCTANT_FLOCK_SCHOOL
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Octant of the bird flock or fish school sighting. |
General Data Type: | VARCHAR2 |
Allowed Values: | 0 = NORTH LATITUDE, 00 DEG WEST TO 89 DEG 59 MIN WEST LONGITUDE; 1 = NORTH LATITUDE, 90 DEG WEST TO 179 DEG 59 MIN WEST LONGITUDE; 2 = NORTH LATITUDE, 180 DEG TO 90 DEG 01 MIN EAST LONGITUDE; 3 = NORTH LATITUDE, 90 DEG EAST TO 00 DEG 01 MIN EAST LONGITUDE; 5 = SOUTH LATITUDE, 00 DEG WEST TO 89 DEG 59 MIN WEST LONGITUDE; 6 = SOUTH LATITUDE, 90 DEG WEST TO 179 DEG 59 MIN WEST LONGITUDE; 7 = SOUTH LATITUDE, 180 DEG TO 90 DEG 01 MIN EAST LONGITUDE; 8 = SOUTH LATITUDE, 90 DEG EAST TO 00 DEG 01 MIN EAST LONGITUDE |
LATITUDE_DEGREES_FLOCK_SCHOOL
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude degrees when the bird flock or fish school was sighted. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
LATITUDE_MINUTES_FLOCK_SCHOOL
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude minutes when the bird flock or fish school was sighted. Units for values are minutes. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
LATITUDE_DIRECTION_FLOCK_SCHOOL
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude direction when the bird flock or fish school was sighted. OCTANT used to determine LATITUDE_DIRECTION_FLOCK_SCHOOL (N/S). |
General Data Type: | VARCHAR2 |
Allowed Values: | N = NORTH; S = SOUTH |
LATITUDE_DD_FLOCK_SCHOOL
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 42 |
Required: | No |
Primary Key: | No |
Scale: | 38 |
Status: | Active |
Description: |
Computed latitude, in decimal degrees, when the bird flock or fish school was sighted. 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 |
LONGITUDE_DEGREES_FLOCK_SCHOOL
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude degrees when the bird flock or fish school was sighted. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using OCTANT. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
LONGITUDE_MINUTES_FLOCK_SCHOOL
Seq. Order: | 16 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude minutes when the bird flock or fish school was sighted. Units for values are minutes. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
LONGITUDE_DIRECTION_FLOCK_SCHOOL
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude direction when the bird flock or fish school was sighted. OCTANT used to determine LONGITUDE_DIRECTION_FLOCK_SCHOOL (E/W). |
General Data Type: | VARCHAR2 |
Allowed Values: | E = EAST; W = WEST |
LONGITUDE_DD_FLOCK_SCHOOL
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 41 |
Required: | No |
Primary Key: | No |
Scale: | 36 |
Status: | Active |
Description: |
Computed longitude, in decimal degrees, when the bird flock or fish school was sighted. 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 |
SIZE_FLOCK_CODE
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the size of the bird flock. |
General Data Type: | VARCHAR2 |
Allowed Values: | FOR YEARS 1954 - 1963: 1 = 1; 2 = 2 - 5; 3 = 6 - 10; 4 = 11 - 25; 5 = 26 - 50; 6 = 51 - 100; 7 = 101 - 500; 8 = 501 - 1000; 9 = PRESENT BUT NUMBERS NOT KNOWN; FOR YEARS 1964 - 1980: 1 = 1 - 5; 2 = 6 - 10; 3 = 11 - 25; 4 = 26 - 50; 5 = 51 - 100; 6 = 101 - 500; 7 = 501 - 1000; 8 = OVER 1000; 9 = PRESENT BUT NUMBERS NOT KNOWN |
SOOTY_TERN_PRESENT_CODE
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code whether SOOTY TERN was present. Value could also be SIZE_FLOCK_CODE. |
General Data Type: | VARCHAR2 |
Allowed Values: | 1 = PRESENT; NULL = NOT PRESENT |
NODDY_TERN_PRESENT_CODE
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code whether NOODY TERN was present. Value could also be SIZE_FLOCK_CODE. |
General Data Type: | VARCHAR2 |
Allowed Values: | 1 = PRESENT; NULL = NOT PRESENT |
WHITE_TERN_PRESENT_CODE
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code whether WHITE TERN was present. Value could also be SIZE_FLOCK_CODE. |
General Data Type: | VARCHAR2 |
Allowed Values: | 1 = PRESENT; NULL = NOT PRESENT |
BOOBY_PRESENT_CODE
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code whether BOOBY was present. Value could also be SIZE_FLOCK_CODE. |
General Data Type: | VARCHAR2 |
Allowed Values: | 1 = PRESENT; NULL = NOT PRESENT |
TROPIC_BIRD_PRESENT_CODE
Seq. Order: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code whether TROPIC BIRD was present. Value could also be SIZE_FLOCK_CODE. |
General Data Type: | VARCHAR2 |
Allowed Values: | 1 = PRESENT; NULL = NOT PRESENT |
FRIGATE_BIRD_PRESENT_CODE
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code whether FRIGATE BIRD was present. Value could also be SIZE_FLOCK_CODE. |
General Data Type: | VARCHAR2 |
Allowed Values: | 1 = PRESENT; NULL = NOT PRESENT |
PETREL_SHEARWATER_PRESENT_CODE
Seq. Order: | 26 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code whether PETREL or SHEARWATER was present. Value could also be SIZE_FLOCK_CODE. |
General Data Type: | VARCHAR2 |
Allowed Values: | 1 = PRESENT; NULL = NOT PRESENT |
STORM_PETREL_PRESENT_CODE
Seq. Order: | 27 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code whether STORM PETREL was present. Value could also be SIZE_FLOCK_CODE. |
General Data Type: | VARCHAR2 |
Allowed Values: | 1 = PRESENT; NULL = NOT PRESENT |
ALBATROSS_PRESENT_CODE
Seq. Order: | 28 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code whether ALBATROSS was present. Value could also be SIZE_FLOCK_CODE. |
General Data Type: | VARCHAR2 |
Allowed Values: | 1 = PRESENT; NULL = NOT PRESENT |
OTHER_BIRDS_PRESENT_CODE
Seq. Order: | 29 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code whether OTHER BIRDS were present. Value could also be SIZE_FLOCK_CODE. |
General Data Type: | VARCHAR2 |
Allowed Values: | 1 = PRESENT; NULL = NOT PRESENT |
SPECIES_CODE_FLOCK_SCHOOL_2
Seq. Order: | 30 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Two-digit species code of the bird flock or fish school. |
General Data Type: | VARCHAR2 |
Allowed Values: | 32 = KATSUWONUS PELAMIS, SKIPJACK, AKU; 35 = THUNNUS ALBACARES, YELLOWFIN TUNA, AHI; 90 = COMBINATION IN SCHOOLS SKIPJACK-YELLOWFIN; 99 = UNIDENTIFIED |
SPECIES_CODE_FLOCK_SCHOOL_5
Seq. Order: | 31 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Five-digit CZM species code of the bird flock or fish school. |
General Data Type: | VARCHAR2 |
Allowed Values: | 20332 = KATSUWONUS PELAMIS, SKIPJACK, AKU; 99999 = UNIDENTIFIED |
SPECIES_CODE_FLOCK_SCHOOL
Seq. Order: | 32 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Ten-digit CZM species code of the bird flock or fish school. Originally two-digit, five_digit or ten-digit species codes resided in the one column. They are now in separate columns, and there is a corresponding ten-digit code for each two-digit and five_digit species code. |
General Data Type: | VARCHAR2 |
Allowed Values: | 8555740401 = KATSUWONUS PELAMIS, SKIPJACK, AKU; 8555740703 = THUNNUS ALBACARES, YELLOWFINFIN TUNA, AHI; 9999999998 = COMBINATION IN SCHOOLS - KATSUWONUS PELAMIS & THUNNUS ALBACARES; 9999999999 = UNIDENTIFIED |
AVERAGE_SIZE_FISH_KG
Seq. Order: | 33 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Average fish weight, in kilograms. Units for values are kilograms. |
General Data Type: | VARCHAR2 |
Unit of Measure: | kilograms |
AVERAGE_SIZE_FISH_LB
Seq. Order: | 34 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Average fish weight, in pounds. Units for values are pounds. |
General Data Type: | VARCHAR2 |
Unit of Measure: | pounds |
SIZE_SCHOOL_CODE
Seq. Order: | 35 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the size of the fish school. |
General Data Type: | VARCHAR2 |
Allowed Values: | S = SMALL; M = MEDIUM; L = LARGE |
TIME_POSITION_TAKEN
Seq. Order: | 36 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Time position taken; the hour field and minute field were merged into one field. |
General Data Type: | VARCHAR2 |
OCTANT_SCATTER
Seq. Order: | 37 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Octant of the sighting of scattered species. |
General Data Type: | VARCHAR2 |
Allowed Values: | 0 = NORTH LATITUDE, 00 DEG WEST TO 89 DEG 59 MIN WEST LONGITUDE; 1 = NORTH LATITUDE, 90 DEG WEST TO 179 DEG 59 MIN WEST LONGITUDE; 2 = NORTH LATITUDE, 180 DEG TO 90 DEG 01 MIN EAST LONGITUDE; 3 = NORTH LATITUDE, 90 DEG EAST TO 00 DEG 01 MIN EAST LONGITUDE; 5 = SOUTH LATITUDE, 00 DEG WEST TO 89 DEG 59 MIN WEST LONGITUDE; 6 = SOUTH LATITUDE, 90 DEG WEST TO 179 DEG 59 MIN WEST LONGITUDE; 7 = SOUTH LATITUDE, 180 DEG TO 90 DEG 01 MIN EAST LONGITUDE; 8 = SOUTH LATITUDE, 90 DEG EAST TO 00 DEG 01 MIN EAST LONGITUDE |
LATITUDE_DEGREES_SCATTER
Seq. Order: | 38 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude degrees when the scattered species was sighted. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
LATITUDE_MINUTES_SCATTER
Seq. Order: | 39 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude minutes when the scattered species was sighted. Units for values are minutes. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
LATITUDE_DIRECTION_SCATTER
Seq. Order: | 40 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Latitude direction when the scattered species was sighted. OCTANT used to determine LATITUDE_DIRECTION_SCATTER (N/S). |
General Data Type: | VARCHAR2 |
Allowed Values: | N = NORTH; S = SOUTH |
LATITUDE_DD_SCATTER
Seq. Order: | 41 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 42 |
Required: | No |
Primary Key: | No |
Scale: | 38 |
Status: | Active |
Description: |
Computed latitude, in decimal degree, when the scattered species was sighted. 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 |
LONGITUDE_DEGREES_SCATTER
Seq. Order: | 42 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude degrees when the scattered species was sighted. During data entry, the first digit (0 or 1) was omitted. It has been inserted into the data using OCTANT. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
LONGITUDE_MINUTES_SCATTER
Seq. Order: | 43 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude minutes when the scattered species was sighted. Units for values are minutes. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
LONGITUDE_DIRECTION_SCATTER
Seq. Order: | 44 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Longitude direction when the scattered species was sighted. OCTANT used to determine LONGITUDE_DIRECTION_SCATTER (E/W). |
General Data Type: | VARCHAR2 |
Allowed Values: | E = EAST; W = WEST |
LONGITUDE_DD_SCATTER
Seq. Order: | 45 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 41 |
Required: | No |
Primary Key: | No |
Scale: | 36 |
Status: | Active |
Description: |
Computed longitude, in decimal degrees, when the scattered species was sighted. 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 |
SOOTY_TERN_SCATTER_COUNT_CODE
Seq. Order: | 46 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Count code for the scattered SOOTY TERN sighted. See SIZE_FLOCK_CODE. |
General Data Type: | VARCHAR2 |
NODDY_TERN_SCATTER_COUNT_CODE
Seq. Order: | 47 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Count code for the scattered NODDY TERN sighted. See SIZE_FLOCK_CODE. |
General Data Type: | VARCHAR2 |
WHITE_TERN_SCATTER_COUNT_CODE
Seq. Order: | 48 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Count code for the scattered WHITE TERN sighted. See SIZE_FLOCK_CODE. |
General Data Type: | VARCHAR2 |
BOOBY_SCATTER_COUNT_CODE
Seq. Order: | 49 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Count code for the scattered BOOBY sighted. See SIZE_FLOCK_CODE. |
General Data Type: | VARCHAR2 |
TROPIC_BIRD_SCATTER_COUNT_CODE
Seq. Order: | 50 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Count code for the scattered TROPIC BIRD TERN sighted. See SIZE_FLOCK_CODE. |
General Data Type: | VARCHAR2 |
FRIGATE_SCATTER_COUNT_CODE
Seq. Order: | 51 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Count code for the scattered FRIGATE BIRD sighted. See SIZE_FLOCK_CODE. |
General Data Type: | VARCHAR2 |
PETREL_SCATTER_COUNT_CODE
Seq. Order: | 52 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Count code for the scattered PETREL or SHEARWATER sighted. See SIZE_FLOCK_CODE. |
General Data Type: | VARCHAR2 |
STORM_PETREL_SCATTER_COUNT_CODE
Seq. Order: | 53 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Count code for the scattered STORM PETREL sighted. See SIZE_FLOCK_CODE. |
General Data Type: | VARCHAR2 |
ALBATROSS_SCATTER_COUNT_CODE
Seq. Order: | 54 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Count code for the scattered ALBATROSS sighted. See SIZE_FLOCK_CODE. |
General Data Type: | VARCHAR2 |
OTHER_BIRDS_SCATTER_COUNT_CODE
Seq. Order: | 55 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Count code for the scattered OTHER BIRDS sighted. See SIZE_FLOCK_CODE. |
General Data Type: | VARCHAR2 |
WHALES_SCATTER_COUNT_CODE
Seq. Order: | 56 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Count code for the scattered WHALES sighted. See SIZE_FLOCK_CODE. |
General Data Type: | VARCHAR2 |
PORPOISES_SCATTER_COUNT_CODE
Seq. Order: | 57 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Count code for the scattered PORPOISES sighted. See SIZE_FLOCK_CODE. |
General Data Type: | VARCHAR2 |
SEALS_SCATTER_COUNT_CODE
Seq. Order: | 58 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Count code for the scattered SEALS sighted. See SIZE_FLOCK_CODE. |
General Data Type: | VARCHAR2 |
SPECIES_CODE_OTHERS_SCATTER_2
Seq. Order: | 59 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Two-digit species code of scattered other species sighted. |
General Data Type: | VARCHAR2 |
SPECIES_CODE_OTHERS_SCATTER_5
Seq. Order: | 60 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Five-digit CZM species code of scattered other species sighted. |
General Data Type: | VARCHAR2 |
SPECIES_CODE_OTHERS_SCATTER
Seq. Order: | 61 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Ten-digit CZM species code of scattered other species sighted. Originally two-digit, five_digit or ten-digit species codes resided in the one column. They are now in separate columns, and there is a corresponding ten-digit code for each two-digit and five_digit species code. |
General Data Type: | VARCHAR2 |
OTHERS_SCATTER_COUNT
Seq. Order: | 62 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Count of scattered other species sighted. |
General Data Type: | VARCHAR2 |
OTHERS_SCATTER_COUNT_CODE
Seq. Order: | 63 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Count code for scattered other species sighted. See SIZE_FLOCK_CODE. |
General Data Type: | VARCHAR2 |
NUMBER_HOURS_WATCHED_0800
Seq. Order: | 64 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of hours watched ending at 0800 or the time the position was taken (FIELD 36). |
General Data Type: | VARCHAR2 |
NUMBER_HOURS_WATCHED_1200
Seq. Order: | 65 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of hours watched ending at 1200 or the time the position was taken (FIELD 36). |
General Data Type: | VARCHAR2 |
NUMBER_HOURS_WATCHED_1600
Seq. Order: | 66 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of hours watched ending at 1600 or the time the position was taken (FIELD 36). |
General Data Type: | VARCHAR2 |
NUMBER_HOURS_WATCHED_2000
Seq. Order: | 67 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of hours watched ending a 2000 or the time the position was taken (FIELD 36). |
General Data Type: | VARCHAR2 |
JOB_NUMBER
Seq. Order: | 68 |
---|---|
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., D84109. |
General Data Type: | VARCHAR2 |
SEQUENCE_NUMBER
Seq. Order: | 69 |
---|---|
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: | 70 |
---|---|
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: | 70843 |
---|---|
GUID: | gov.noaa.nmfs.inport:70843 |
Metadata Record Created By: | Brent M Miyamoto |
Metadata Record Created: | 2023-09-15 00:48+0000 |
Metadata Record Last Modified By: | Brent M Miyamoto |
Metadata Record Last Modified: | 2023-10-07 02:44+0000 |
Metadata Record Published: | 2023-10-07 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2023-10-07 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2024-10-07 |