Slide Menu
Search Help Show/Hide Menu

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

Rubric Score Primary Key? 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

CC ID: 1272837
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

CC ID: 1272838
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

CC ID: 1272839
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

CC ID: 1272840
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

CC ID: 1272841
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

CC ID: 1272842
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

CC ID: 1272843
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

CC ID: 1272844
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

CC ID: 1272845
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

CC ID: 1272846
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

CC ID: 1272847
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

CC ID: 1272848
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

CC ID: 1272849
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

CC ID: 1272850
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

CC ID: 1272851
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

CC ID: 1272852
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

CC ID: 1272853
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

CC ID: 1272854
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

CC ID: 1272855
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

CC ID: 1272856
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

CC ID: 1272857
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

CC ID: 1272858
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

CC ID: 1272859
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

CC ID: 1272860
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

CC ID: 1272861
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

CC ID: 1272862
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

CC ID: 1272863
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

CC ID: 1272864
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

CC ID: 1272865
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

CC ID: 1272866
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

CC ID: 1272867
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

CC ID: 1272868
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

CC ID: 1272869
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

CC ID: 1272870
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

CC ID: 1272871
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

CC ID: 1272872
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

CC ID: 1272873
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

CC ID: 1272874
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

CC ID: 1272875
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

CC ID: 1272876
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

CC ID: 1272877
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

CC ID: 1272878
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

CC ID: 1272879
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

CC ID: 1272880
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

CC ID: 1272881
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

CC ID: 1272882
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

CC ID: 1272883
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

CC ID: 1272884
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

CC ID: 1272885
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

CC ID: 1272886
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

CC ID: 1272887
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

CC ID: 1272888
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

CC ID: 1272889
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

CC ID: 1272890
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

CC ID: 1272891
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

CC ID: 1272892
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

CC ID: 1272893
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

CC ID: 1272894
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

CC ID: 1272895
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

CC ID: 1272896
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

CC ID: 1272897
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

CC ID: 1272898
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

CC ID: 1272899
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

CC ID: 1272900
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

CC ID: 1272901
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

CC ID: 1272902
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

CC ID: 1272903
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

CC ID: 1272904
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

CC ID: 1272905
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

CC ID: 1272906
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