Slide Menu
Jump to Section...
Account Creation Issues: We have received reports of issues with creating new user accounts and linking accounts to CAM, and are currently investigating the root cause. In the meantime: - If you're experiencing errors creating new users, please use the "Quick Add" feature instead (click the "Quick Add" button on the Manage Users page). - If you're experiencing errors linking CAM accoun...
View All
Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
PIFSC Metadata Library > PIFSC Historical Datasets Metadata Portfolio > Historical Research Pelagics Metadata Portfolio > Surface School Fishing data collected during NO... >

RP052AA1_V

Entity (ENT)  |  Pacific Islands Fisheries Science Center (PIFSC)
GUID: gov.noaa.nmfs.inport:67550  |  Updated: August 9, 2022  |  Published / External 

Item Identification

Title: RP052AA1_V
Short Name: RP052AA1_V
Status: Completed
Abstract:

Surface fishing data collected during NOAA research cruises.

Entity Information

Entity Type: Data Table
Active Version?: Yes
Description:

Surface fishing data collected during NOAA research cruises.

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 number of the cruise, e.g., 0022.
100
 YEAR VARCHAR2 Local year.
100
 MONTH VARCHAR2 Local month.
100
 DAY VARCHAR2 Local day.
100
 LOCAL_TIME VARCHAR2 Local time school sighted.
100
 OCTANT VARCHAR2 Octant of the globe. OCTANT used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1).
100
 LATITUDE_DEGREES VARCHAR2 Latitude degrees. Units for values are degrees.
100
 LATITUDE_MINUTES VARCHAR2 Latitude minutes. Units for values are minutes.
100
 LATITUDE_DIRECTION VARCHAR2 Latitude direction. OCTANT was used to determine LATITUDE_DIRECTION (N/S).
100
 LATITUDE_DD NUMBER Computed latitude, in decimal degrees, of the sampling site. 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 VARCHAR2 Longitude degrees. During data entry, the first digit (0 or 1) was omitted. OCTANT was used to determine the first digit (0 or 1). Units for values are degrees.
100
 LONGITUDE_MINUTES VARCHAR2 Longitude minutes. Units for values are minutes.
100
 LONGITUDE_DIRECTION VARCHAR2 Longitude direction. OCTANT was used to determine LONGITUDE_DIRECTION (E/W).
100
 LONGITUDE_DD NUMBER Computed longitude, in decimal degrees, of the sampling site. Postive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39.
100
 STATION_NUMBER VARCHAR2 Station number.
100
 LOCAL_TIME_SCHOOL_ABANDONED VARCHAR2 Local time school was abandoned.
100
 SPECIES_CODE_IN_SCHOOL VARCHAR2 2-digit species code in school.
100
 FIRST_SPECIES_CODE_IN_CATCH VARCHAR2 2-digit species code of first species in catch. This may or may not be the same as SPECIES_CODE_IN_SCHOOL. The school may have been fished witout results, or it may have been a mixed school with a mixed catch.
100
 FIRST_SPECIES_NUMBER_CAUGHT VARCHAR2 Number of first species caught.
100
 FIRST_SPECIES_AVERAGE_LENGTH VARCHAR2 Average length, in centimeters, of first species. Units for values are centimeters.
100
 SECOND_SPECIES_CODE_IN_CATCH VARCHAR2 2-digit species code of second species in catch.
100
 SECOND_SPECIES_NUMBER_CAUGHT VARCHAR2 Number of second species caught.
100
 SECOND_SPECIES_AVERAGE_LENGTH VARCHAR2 Average length, in centimeters, of second species. Units for values are centimeters.
100
 TOTAL_NUMBER_PASSES VARCHAR2 Total number of passes.
100
 NUMBER_MEN_HOOKING VARCHAR2 Number of men hooking; the collection form field label is NUMBER_HOOKS_FISHING.
100
 SCHOOL_LOCATED_BY_CODE VARCHAR2 Code for how the school was located.
100
 TYPE_OF_SCHOOL_CODE VARCHAR2 Code for the type of school.
100
 NUMBER_BIRDS_IN_FLOCK_CODE VARCHAR2 Code for the number of birds in the flock.
100
 FISH_TAGGED_YN VARCHAR2 Code for whether any fish was tagged.
100
 STOMACH_CONTENTS_YN VARCHAR2 Code for whether the stomach contents were enumerated or preserved.
100
 GONADS_YN VARCHAR2 Code for whether the gonads were examined or preserved.
100
 ADDITIONAL_INFO_YN VARCHAR2 Code for whether there is additional information on other logs.
100
 NUMBER_BUCKETS_BAIT_USED VARCHAR2 Number of buckets of bait used.
100
 BAIT_SPECIES_CODE VARCHAR2 2-digit code for the bait species.
100
 SURFACE_WATER_TEMPERATURE VARCHAR2 Surface water temperature, in tenths of a centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are centigrade. Measures are reported with a precision of 3.
100
 SURFACE_SALINITY VARCHAR2 Surface salinity, in parts per thousand. During data entry, the "3" and the decimal point were omitted; they have been inserted into the data. Units for values are parts per thousand. Measures are reported with a precision of 2.
100
 NUMBER_SPECIES_MEASURED VARCHAR2 This is an additional field that was written on the data collection form. It had no descriptive field name, other than Column 79. And the record format sheet did not have a field name or data description. It may be the number of different species that were measured for the date and time.
100
 TIME_ZONE_CODE VARCHAR2 Code for the time zone.
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: 1178225
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: 1178226
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: 1178227
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: 004 = HUGH M SMITH; 005 = JOHN R MANNING; 007 = CHARLES H GILBERT

CRUISE_NUMBER

CC ID: 1178228
Seq. Order: 4
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Four digit incremental number of the cruise, e.g., 0022.
General Data Type: VARCHAR2

YEAR

CC ID: 1178229
Seq. Order: 5
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Local year.
General Data Type: VARCHAR2

MONTH

CC ID: 1178230
Seq. Order: 6
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Local month.
General Data Type: VARCHAR2

DAY

CC ID: 1178231
Seq. Order: 7
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Local day.
General Data Type: VARCHAR2

LOCAL_TIME

CC ID: 1178232
Seq. Order: 8
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Local time school sighted.
General Data Type: VARCHAR2

OCTANT

CC ID: 1178233
Seq. Order: 9
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Octant of the globe. OCTANT used to determine latitude direction (N/S), longitude direction (E/W) and the first digit of LONGITUDE_DEGREES (0/1).
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

CC ID: 1178234
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Latitude degrees. Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

LATITUDE_MINUTES

CC ID: 1178235
Seq. Order: 11
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Latitude minutes. Units for values are minutes.
General Data Type: VARCHAR2
Unit of Measure: minutes

LATITUDE_DIRECTION

CC ID: 1178236
Seq. Order: 12
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Latitude direction. OCTANT was used to determine LATITUDE_DIRECTION (N/S).
General Data Type: VARCHAR2
Allowed Values: N = NORTH; S = SOUTH

LATITUDE_DD

CC ID: 1178237
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 42
Required: No
Primary Key: No
Scale: 38
Status: Active
Description:

Computed latitude, in decimal degrees, of the sampling site. 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

CC ID: 1178238
Seq. Order: 14
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Longitude degrees. During data entry, the first digit (0 or 1) was omitted. OCTANT was used to determine the first digit (0 or 1). Units for values are degrees.
General Data Type: VARCHAR2
Unit of Measure: degrees

LONGITUDE_MINUTES

CC ID: 1178239
Seq. Order: 15
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Longitude minutes. Units for values are minutes.
General Data Type: VARCHAR2
Unit of Measure: minutes

LONGITUDE_DIRECTION

CC ID: 1178240
Seq. Order: 16
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Longitude direction. OCTANT was used to determine LONGITUDE_DIRECTION (E/W).
General Data Type: VARCHAR2
Allowed Values: E = EAST; W = WEST

LONGITUDE_DD

CC ID: 1178241
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 41
Required: No
Primary Key: No
Scale: 36
Status: Active
Description:

Computed longitude, in decimal degrees, of the sampling site. 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

STATION_NUMBER

CC ID: 1178242
Seq. Order: 18
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Station number.
General Data Type: VARCHAR2

LOCAL_TIME_SCHOOL_ABANDONED

CC ID: 1178243
Seq. Order: 19
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Status: Active
Description:

Local time school was abandoned.
General Data Type: VARCHAR2

SPECIES_CODE_IN_SCHOOL

CC ID: 1178244
Seq. Order: 20
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

2-digit species code in school.
General Data Type: VARCHAR2
Default Value: 00 = NO FISH; 32 = KATSUWONUS PELAMIS, SKIPJACK, AKU; 33 = EUTHYNNUS SPP., LITTLE TUNNY, KAWAKAWA; 34 = THUNNUS OBESUS, BIGEYE TUNA, AHI; 35 = THUNNUS ALBACARES, YELLOWFIN TUNA, AHI; 41 = AUXIS SPP., FRIGATE MACKEREL; 53 = CORYPHAENIDAE, DOLPHINFISH; MAHIMAHI; 73 = MODIDAE, HEADFISHES OR SUNFISHES, MOLAMOLA; 90 = COMBINATION IN SCHOOLS SKIPJACK-YELLOWFIN; 91 = COMBINATION IN SCHOOLS SKIPJACK-LITTLE TUNNY; 93 = COMBINATION IN SCHOOLS SKIPJACK-BIGEYE; 94 = COMBINATION IN SCHOOLS SKIPJACK-MAHIMAHI; 95 = COMBINATION IN SCHOOLS YELLOWFIN-MAHIMAHI; 96 = COMBINATION IN SCHOOLS OTHER FISH IN COMBINATION; 98 = OTHER THINGS; 99 = UNIDENTIFIED

FIRST_SPECIES_CODE_IN_CATCH

CC ID: 1178245
Seq. Order: 21
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

2-digit species code of first species in catch. This may or may not be the same as SPECIES_CODE_IN_SCHOOL. The school may have been fished witout results, or it may have been a mixed school with a mixed catch.
General Data Type: VARCHAR2
Allowed Values: 32 = KATSUWONUS PELAMIS, SKIPJACK, AKU; 33 = EUTHYNNUS SPP., LITTLE TUNNY, KAWAKAWA; 34 = THUNNUS OBESUS, BIGEYE TUNA, AHI; 35 = THUNNUS ALBACARES, YELLOWFIN TUNA, AHI; 41 = AUXIS SPP., FRIGATE MACKEREL; 53 = CORYPHAENIDAE, DOLPHINFISH; MAHIMAHI; 90 = COMBINATION IN SCHOOLS SKIPJACK-YELLOWFIN; 95 = COMBINATION IN SCHOOLS YELLOWFIN-MAHIMAHI; 96 = COMBINATION IN SCHOOLS OTHER FISH IN COMBINATION

FIRST_SPECIES_NUMBER_CAUGHT

CC ID: 1178246
Seq. Order: 22
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Number of first species caught.
General Data Type: VARCHAR2

FIRST_SPECIES_AVERAGE_LENGTH

CC ID: 1178247
Seq. Order: 23
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Average length, in centimeters, of first species. Units for values are centimeters.
General Data Type: VARCHAR2
Unit of Measure: centimeters

SECOND_SPECIES_CODE_IN_CATCH

CC ID: 1178248
Seq. Order: 24
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

2-digit species code of second species in catch.
General Data Type: VARCHAR2
Allowed Values: 00 = NO FISH; 32 = KATSUWONUS PELAMIS, SKIPJACK, AKU; 33 = EUTHYNNUS SPP., LITTLE TUNNY, KAWAKAWA; 34 = THUNNUS OBESUS, BIGEYE TUNA, AHI; 35 = THUNNUS ALBACARES, YELLOWFIN TUNA, AHI; 41 = AUXIS SPP., FRIGATE MACKEREL

SECOND_SPECIES_NUMBER_CAUGHT

CC ID: 1178249
Seq. Order: 25
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Status: Active
Description:

Number of second species caught.
General Data Type: VARCHAR2

SECOND_SPECIES_AVERAGE_LENGTH

CC ID: 1178250
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

Average length, in centimeters, of second species. Units for values are centimeters.
General Data Type: VARCHAR2
Unit of Measure: centimeters

TOTAL_NUMBER_PASSES

CC ID: 1178251
Seq. Order: 27
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Total number of passes.
General Data Type: VARCHAR2

NUMBER_MEN_HOOKING

CC ID: 1178252
Seq. Order: 28
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of men hooking; the collection form field label is NUMBER_HOOKS_FISHING.
General Data Type: VARCHAR2

SCHOOL_LOCATED_BY_CODE

CC ID: 1178253
Seq. Order: 29
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for how the school was located.
General Data Type: VARCHAR2
Allowed Values: 0 = BIRD FLOCK; 1 = JUMPERS; 2 = SURFACE PATCH; 3 = DEBRIS; 4 = BLIND CHUMMING; 9 = OTHER

TYPE_OF_SCHOOL_CODE

CC ID: 1178254
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for the type of school.
General Data Type: VARCHAR2
Allowed Values: 0 = SUB-SURFACE; 1 = JUMPING; 2 = BREEZING; 3 = FINNING

NUMBER_BIRDS_IN_FLOCK_CODE

CC ID: 1178255
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for the number of birds in the flock.
General Data Type: VARCHAR2
Allowed Values: BLANK, NULL = PRESENT BUT NUMBER NOT RECORDED; 1 = 1; 2 = 2 - 5; 3 = 6 - 10; 4 = 11 - 25; 5 = 26 - 50; 6 = 51 - 100; 7 = 101 - 500; 8 = 501 - 1000; 9 = 1001 - 2000; 0 = OVER 2000

FISH_TAGGED_YN

CC ID: 1178256
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for whether any fish was tagged.
General Data Type: VARCHAR2
Allowed Values: 0 = YES; 1 = NO

STOMACH_CONTENTS_YN

CC ID: 1178257
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for whether the stomach contents were enumerated or preserved.
General Data Type: VARCHAR2
Allowed Values: 0 = YES; 1 = NO

GONADS_YN

CC ID: 1178258
Seq. Order: 34
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for whether the gonads were examined or preserved.
General Data Type: VARCHAR2
Allowed Values: 0 = YES; 1 = NO

ADDITIONAL_INFO_YN

CC ID: 1178259
Seq. Order: 35
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for whether there is additional information on other logs.
General Data Type: VARCHAR2
Allowed Values: 0 = YES; 1 = NO

NUMBER_BUCKETS_BAIT_USED

CC ID: 1178260
Seq. Order: 36
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

Number of buckets of bait used.
General Data Type: VARCHAR2

BAIT_SPECIES_CODE

CC ID: 1178261
Seq. Order: 37
Data Storage Type: VARCHAR2
Max Length: 2
Required: No
Primary Key: No
Status: Active
Description:

2-digit code for the bait species.
General Data Type: VARCHAR2
Allowed Values: 01 = ELOPIDAE, TENPOUNDERS, AWAAWA; 03 = HARENGULA VITTATA, MARQUESAN SARDINE; 07 = STOLEPHORUS PURPUREUS, ANCHOVY, NEHU; 22 = POECILIIDAE, TOP MINNOWS, MOSQUITO FISH, SWORDTAILS, MOLLIES; 28 = ATHERINIDAE, SILVERSIDES, IAO; 30 = MUGILIDAE, MULLETS, AMAAMA, UOUOA; 32 = KATSUWONUS PELAMIS, SKIPJACK, AKU; 3A = THREADFIN SHAD (FRESHWATER); 55 = CARANGIDAE, JACKS, SCAD, AMBERJACKS; 56 = KUHLIIDAE, MOUNTAIN BASSES, AHOLEHOLE; 59 = MULLIDAE, GOATFISHES, SURMULLETS, WEKE, MOANA, KUMU, OAMA, UPENEUS ARGE; 60 = CICHLIDAE, TILAPIAS; 97 = BAITFISH COMBINATION; 98 = OTHER THINGS

SURFACE_WATER_TEMPERATURE

CC ID: 1178262
Seq. Order: 38
Data Storage Type: VARCHAR2
Max Length: 4
Required: No
Primary Key: No
Scale: 1
Status: Active
Description:

Surface water temperature, in tenths of a centigrade. During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are centigrade. Measures are reported with a precision of 3.
General Data Type: VARCHAR2
Unit of Measure: centigrade

SURFACE_SALINITY

CC ID: 1178263
Seq. Order: 39
Data Storage Type: VARCHAR2
Max Length: 5
Required: No
Primary Key: No
Scale: 4
Status: Active
Description:

Surface salinity, in parts per thousand. During data entry, the "3" and the decimal point were omitted; they have been inserted into the data. Units for values are parts per thousand. Measures are reported with a precision of 2.
General Data Type: VARCHAR2
Unit of Measure: parts per thousand

NUMBER_SPECIES_MEASURED

CC ID: 1178264
Seq. Order: 40
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

This is an additional field that was written on the data collection form. It had no descriptive field name, other than Column 79. And the record format sheet did not have a field name or data description. It may be the number of different species that were measured for the date and time.
General Data Type: VARCHAR2

TIME_ZONE_CODE

CC ID: 1178265
Seq. Order: 41
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Code for the time zone.
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

SEQUENCE_NUMBER

CC ID: 1178266
Seq. Order: 42
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: 1178267
Seq. Order: 43
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: 67550
GUID: gov.noaa.nmfs.inport:67550
Metadata Record Created By: Brent M Miyamoto
Metadata Record Created: 2022-07-15 19:14+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2022-07-16
Owner Org: PIFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2022-07-16
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2023-07-16