RI036AA2_RSCH_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:64307 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | RI036AA2_RSCH_V |
---|---|
Short Name: | RI036AA2_RSCH_V |
Status: | Completed |
Abstract: |
Lobster tagging and morphometric data collected during two NOAA R/V Townsend Cromwell cruises. |
Entity Information
Entity Type: | Data Table |
---|---|
Active Version?: | Yes |
Description: |
Lobster tagging and morphometric data collected during two NOAA R/V Townsend Cromwell cruises. |
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-digit incremental number of the cruise for the year. | |
100
|
HAUL_YEAR | VARCHAR2 | Year that the string was hauled. | |
100
|
HAUL_MONTH | VARCHAR2 | Month that the string was hauled. | |
100
|
HAUL_DAY | VARCHAR2 | Day that the string was hauled. | |
100
|
STRING_NUMBER | VARCHAR2 | String number of traps. | |
100
|
STATION_NUMBER | VARCHAR2 | Station number of lobster operation. | |
100
|
NUMBER_TRAPS | VARCHAR2 | Number of traps. | |
100
|
START_DEPTH | VARCHAR2 | Start depth, in tenths of a fathom. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are fathoms. Measures are reported with a precision of 5. | |
100
|
END_DEPTH | VARCHAR2 | End depth, in tenths of a fathom. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are fathoms. Measures are reported with a precision of 5. | |
100
|
START_LATITUDE_DEGREES | VARCHAR2 | Start latitude degrees, in degrees. Units for values are degrees. | |
100
|
START_LATITUDE_MINUTES | VARCHAR2 | Start latitude minutes, in hundredths 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 4. | |
100
|
START_LATITUDE_DIRECTION | VARCHAR2 | Start latitude direction. | |
100
|
START_LATITUDE_DD | NUMBER | Computed start latitude, in decimal degrees. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. | |
100
|
START_LONGITUDE_DEGREES | VARCHAR2 | Start longitude degrees, in degrees. Units for values are degrees. | |
100
|
START_LONGITUDE_MINUTES | VARCHAR2 | Start longitude minutes, in hundredths 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 4. | |
100
|
START_LONGITUDE_DIRECTION | VARCHAR2 | Start longitude direction. | |
100
|
START_LONGITUDE_DD | NUMBER | Computed start longitude, in decimal degrees. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. | |
100
|
END_LATITUDE_DEGREES | VARCHAR2 | End latitude degrees, in degrees. Units for values are degrees. | |
100
|
END_LATITUDE_MINUTES | VARCHAR2 | End latitude minutes, in hundredths 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 4. | |
100
|
END_LATITUDE_DIRECTION | VARCHAR2 | End latitude direction. | |
100
|
END_LATITUDE_DD | NUMBER | Computed end latitude, in decimal degrees. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. | |
100
|
END_LONGITUDE_DEGREES | VARCHAR2 | End longitude degrees, in degrees. Units for values are degrees. | |
100
|
END_LONGITUDE_MINUTES | VARCHAR2 | End longitude minutes, in hundredths 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 4. | |
100
|
END_LONGITUDE_DIRECTION | VARCHAR2 | End longitude direction. | |
100
|
END_LONGITUDE_DD | NUMBER | Computed end longitude, in decimal degrees. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. | |
100
|
RELEASE_LATITUDE_DEGREES | VARCHAR2 | Release latitude degrees, in degrees. Units for values are degrees. | |
100
|
RELEASE_LATITUDE_MINUTES | VARCHAR2 | Release latitude minutes, in hundredths 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 4. | |
100
|
RELEASE_LATITUDE_DIRECTION | VARCHAR2 | Release latitude direction. | |
100
|
RELEASE_LATITUDE_DD | NUMBER | Computed release latitude, in decimal degrees. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. | |
100
|
RELEASE_LONGITUDE_DEGREES | VARCHAR2 | Release longitude degrees, in degrees. Units for values are degrees. | |
100
|
RELEASE_LONGITUDE_MINUTES | VARCHAR2 | Release longitude minutes, in hundredths 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 4. | |
100
|
RELEASE_LONGITUDE_DIRECTION | VARCHAR2 | Release longitude direction. | |
100
|
RELEASE_LONGITUDE_DD | NUMBER | Computed release longitude, in decimal degrees. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. | |
100
|
SAMPLE_NUMBER | VARCHAR2 | Unique consecutive number assigned to each catch on the data collection form. It starts at 001 for each string number. | |
100
|
SPECIES | VARCHAR2 | Species of lobster caught. | |
100
|
SEX_CODE | VARCHAR2 | Code for the sex of the lobster. | |
100
|
CARAPACE_LENGTH | VARCHAR2 | Carapace length, in hundredths of a millimeter, During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5. | |
100
|
TAIL_WIDTH | VARCHAR2 | Tail width, in hundredths of a millimeter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5. | |
100
|
OVA_COLOR_CODE | VARCHAR2 | Code for the color of the ova. | |
100
|
TAG_NUMBER | VARCHAR2 | Unique tag number. | |
100
|
TAG_COLOR_CODE | VARCHAR2 | Code for the color of the tag. | |
100
|
TAG_CODE | VARCHAR2 | Code for TAG_NUMBER/TAG_COLOR_CODE. | |
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., D99272. | |
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: |
Last two digits of the year of the cruise and two-digit incremental number of the cruise for the year. |
General Data Type: | VARCHAR2 |
HAUL_YEAR
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year that the string was hauled. |
General Data Type: | VARCHAR2 |
HAUL_MONTH
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Month that the string was hauled. |
General Data Type: | VARCHAR2 |
HAUL_DAY
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Day that the string was hauled. |
General Data Type: | VARCHAR2 |
STRING_NUMBER
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
String number of traps. |
General Data Type: | VARCHAR2 |
STATION_NUMBER
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Station number of lobster operation. |
General Data Type: | VARCHAR2 |
NUMBER_TRAPS
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number of traps. |
General Data Type: | VARCHAR2 |
START_DEPTH
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
Start depth, in tenths of a fathom. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are fathoms. Measures are reported with a precision of 5. |
General Data Type: | VARCHAR2 |
Unit of Measure: | fathoms |
END_DEPTH
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Scale: | 1 |
Status: | Active |
Description: |
End depth, in tenths of a fathom. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are fathoms. Measures are reported with a precision of 5. |
General Data Type: | VARCHAR2 |
Unit of Measure: | fathoms |
START_LATITUDE_DEGREES
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Start latitude degrees, in degrees. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
START_LATITUDE_MINUTES
Seq. Order: | 14 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Scale: | 2 |
Status: | Active |
Description: |
Start latitude minutes, in hundredths 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 4. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
START_LATITUDE_DIRECTION
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Start latitude direction. |
General Data Type: | VARCHAR2 |
START_LATITUDE_DD
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 41 |
Required: | No |
Primary Key: | No |
Scale: | 38 |
Status: | Active |
Description: |
Computed start latitude, in decimal degrees. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. |
General Data Type: | NUMBER |
Unit of Measure: | degrees |
START_LONGITUDE_DEGREES
Seq. Order: | 17 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Start longitude degrees, in degrees. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
START_LONGITUDE_MINUTES
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Scale: | 2 |
Status: | Active |
Description: |
Start longitude minutes, in hundredths 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 4. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
START_LONGITUDE_DIRECTION
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Start longitude direction. |
General Data Type: | VARCHAR2 |
START_LONGITUDE_DD
Seq. Order: | 20 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 41 |
Required: | No |
Primary Key: | No |
Scale: | 36 |
Status: | Active |
Description: |
Computed start longitude, in decimal degrees. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. |
General Data Type: | NUMBER |
Unit of Measure: | degrees |
END_LATITUDE_DEGREES
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
End latitude degrees, in degrees. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
END_LATITUDE_MINUTES
Seq. Order: | 22 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Scale: | 2 |
Status: | Active |
Description: |
End latitude minutes, in hundredths 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 4. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
END_LATITUDE_DIRECTION
Seq. Order: | 23 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
End latitude direction. |
General Data Type: | VARCHAR2 |
END_LATITUDE_DD
Seq. Order: | 24 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 41 |
Required: | No |
Primary Key: | No |
Scale: | 38 |
Status: | Active |
Description: |
Computed end latitude, in decimal degrees. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. |
General Data Type: | NUMBER |
Unit of Measure: | degrees |
END_LONGITUDE_DEGREES
Seq. Order: | 25 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
End longitude degrees, in degrees. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
END_LONGITUDE_MINUTES
Seq. Order: | 26 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Scale: | 2 |
Status: | Active |
Description: |
End longitude minutes, in hundredths 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 4. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
END_LONGITUDE_DIRECTION
Seq. Order: | 27 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
End longitude direction. |
General Data Type: | VARCHAR2 |
END_LONGITUDE_DD
Seq. Order: | 28 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 41 |
Required: | No |
Primary Key: | No |
Scale: | 36 |
Status: | Active |
Description: |
Computed end longitude, in decimal degrees. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. |
General Data Type: | NUMBER |
Unit of Measure: | degrees |
RELEASE_LATITUDE_DEGREES
Seq. Order: | 29 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Release latitude degrees, in degrees. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
RELEASE_LATITUDE_MINUTES
Seq. Order: | 30 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Scale: | 2 |
Status: | Active |
Description: |
Release latitude minutes, in hundredths 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 4. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
RELEASE_LATITUDE_DIRECTION
Seq. Order: | 31 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Release latitude direction. |
General Data Type: | VARCHAR2 |
RELEASE_LATITUDE_DD
Seq. Order: | 32 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 41 |
Required: | No |
Primary Key: | No |
Scale: | 38 |
Status: | Active |
Description: |
Computed release latitude, in decimal degrees. Positive values are North latitudes; negative values are South latitudes. Units for values are degrees. Measures are reported with a precision of 40. |
General Data Type: | NUMBER |
Unit of Measure: | degrees |
RELEASE_LONGITUDE_DEGREES
Seq. Order: | 33 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Release longitude degrees, in degrees. Units for values are degrees. |
General Data Type: | VARCHAR2 |
Unit of Measure: | degrees |
RELEASE_LONGITUDE_MINUTES
Seq. Order: | 34 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Scale: | 2 |
Status: | Active |
Description: |
Release longitude minutes, in hundredths 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 4. |
General Data Type: | VARCHAR2 |
Unit of Measure: | minutes |
RELEASE_LONGITUDE_DIRECTION
Seq. Order: | 35 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Release longitude direction. |
General Data Type: | VARCHAR2 |
RELEASE_LONGITUDE_DD
Seq. Order: | 36 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 41 |
Required: | No |
Primary Key: | No |
Scale: | 36 |
Status: | Active |
Description: |
Computed release longitude, in decimal degrees. Positive values are East longitudes; negative values are West longitudes. Units for values are degrees. Measures are reported with a precision of 39. |
General Data Type: | NUMBER |
Unit of Measure: | degrees |
SAMPLE_NUMBER
Seq. Order: | 37 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique consecutive number assigned to each catch on the data collection form. It starts at 001 for each string number. |
General Data Type: | VARCHAR2 |
SPECIES
Seq. Order: | 38 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 10 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Species of lobster caught. |
General Data Type: | VARCHAR2 |
SEX_CODE
Seq. Order: | 39 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the sex of the lobster. |
General Data Type: | VARCHAR2 |
CARAPACE_LENGTH
Seq. Order: | 40 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Scale: | 2 |
Status: | Active |
Description: |
Carapace length, in hundredths of a millimeter, During data entry, the decimal point was omitted; it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5. |
General Data Type: | VARCHAR2 |
Unit of Measure: | millimeters |
TAIL_WIDTH
Seq. Order: | 41 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Scale: | 2 |
Status: | Active |
Description: |
Tail width, in hundredths of a millimeter. During data entry the decimal point was omitted; it has been inserted into the data. Units for values are millimeters. Measures are reported with a precision of 5. |
General Data Type: | VARCHAR2 |
Unit of Measure: | millimeters |
OVA_COLOR_CODE
Seq. Order: | 42 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the color of the ova. |
General Data Type: | VARCHAR2 |
TAG_NUMBER
Seq. Order: | 43 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 5 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique tag number. |
General Data Type: | VARCHAR2 |
TAG_COLOR_CODE
Seq. Order: | 44 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for the color of the tag. |
General Data Type: | VARCHAR2 |
TAG_CODE
Seq. Order: | 45 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for TAG_NUMBER/TAG_COLOR_CODE. |
General Data Type: | VARCHAR2 |
JOB_NUMBER
Seq. Order: | 46 |
---|---|
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., D99272. |
General Data Type: | VARCHAR2 |
SEQUENCE_NUMBER
Seq. Order: | 47 |
---|---|
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: | 48 |
---|---|
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: | 64307 |
---|---|
GUID: | gov.noaa.nmfs.inport:64307 |
Metadata Record Created By: | Brent M Miyamoto |
Metadata Record Created: | 2021-02-23 03:47+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2021-03-02 |
Owner Org: | PIFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2021-03-02 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2022-03-02 |