RS002AA3_RSCH_V
Entity (ENT) | Pacific Islands Fisheries Science Center (PIFSC)GUID: gov.noaa.nmfs.inport:70758 | Updated: September 7, 2023 | Published / External
Item Identification
| Title: | RS002AA3_RSCH_V |
|---|---|
| Short Name: | RS002AA3_RSCH_V |
| Status: | Completed |
| Abstract: |
Armorhead morphometric data collected during NOAA R/V Townsend Cromwell cruises in 1982 and 1983. |
Entity Information
| Entity Type: | Data Table |
|---|---|
| Active Version?: | Yes |
| Description: |
Armorhead morphometric data collected during NOAA R/V Townsend Cromwell cruises in 1982 and 1983. |
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
|
CRUISE_NUMBER | VARCHAR2 | Vessel code and the last two digits of the year of the cruise and two digits incremental number of the cruise, e.g., TC8205. | |
|
100
|
SPECIES_CODE | VARCHAR2 | Five-digit CZM species code for armorhead, Pentaceros richardsoni. | |
|
100
|
SPECIMEN_NUMBER | VARCHAR2 | Unique identification number assigned to each specimen. | |
|
100
|
BODY_TYPE_CODE | VARCHAR2 | Body type code. | |
|
100
|
BANK_CODE | VARCHAR2 | Code for the area or bank of capture. | |
|
100
|
WEIGHT | VARCHAR2 | Wet weight, in grams. Units for values are grams. | |
|
100
|
STANDARD_LENGTH | VARCHAR2 | Standard length, in millimeters. Units for values are millimeters. | |
|
100
|
SYSTEMATIC_STANDARD_LENGTH | VARCHAR2 | Systematic standard length, in millimeters. Units for values are millimeters. | |
|
100
|
FORK_LENGTH | VARCHAR2 | Fork length, in millimeters. Units for values are millimeters. | |
|
100
|
GREATEST_ORBIT_DIAMETER | VARCHAR2 | Greatest orbit diameter, in millimeters. Units for values are millimeters. | |
|
100
|
LENGTH_ORBIT | VARCHAR2 | Length of orbit, in millimeters. Units for values are millimeters. | |
|
100
|
LEAST_BONY_INTERORBITAL_WIDTH | VARCHAR2 | Least bony interorbital width, in millimeters. Units for values are millimeters. | |
|
100
|
LEAST_BONY_INTERORBITAL_WIDTH2 | VARCHAR2 | Least bony interorbital width, in millimeters. Units for values are millimeters. | |
|
100
|
SNOUT_LENGTH | VARCHAR2 | Snout length, in millimeters. Units for values are millimeters. | |
|
100
|
HEAD_LENGTH | VARCHAR2 | Head length, in millimeters. Units for values are millimeters. | |
|
100
|
HEAD_LENGTH2 | VARCHAR2 | Head length, in millimeters. Units for values are millimeters. | |
|
100
|
PREDORSAL_LENGTH | VARCHAR2 | Predorsal length, in millimeters. Units for values are millimeters. | |
|
100
|
PECTORAL_FIN_LENGTH | VARCHAR2 | Pectoral fin length, in millimeters. Units for values are millimeters. | |
|
100
|
BODY_DEPTH_1ST_DORSAL_2_PELVIC | VARCHAR2 | Body depth from first dorsal origin to pelvic origin, in millimeters. Units for values are millimeters. | |
|
100
|
BODY_DEPTH_1ST_ANAL_SPINE | VARCHAR2 | Body depth at first anal spine, in millimeters. Units for values are millimeters. | |
|
100
|
MAXIMUM_BODY_DEPTH | VARCHAR2 | Maximum body depth, in millimeters. Units for values are millimeters. | |
|
100
|
WIDTH_BASE_PELVIC_SPINE | VARCHAR2 | Width at base of pelvic spines, in millimeters. Units for values are millimeters. | |
|
100
|
POST_DORSAL_2_POST_ANAL_BASE | VARCHAR2 | Posterior at dorsal fin base to posterior of anal fin base, in millimeters. Units for values are millimeters. | |
|
100
|
NUMBER_DORSAL_SPINES | VARCHAR2 | Number of dorsal spines. | |
|
100
|
NUMBER_DORSAL_SOFT_RAYS | VARCHAR2 | Number of dorsal soft rays. | |
|
100
|
NUMBER_ANAL_SPINES | VARCHAR2 | Number of anal spines. | |
|
100
|
NUMBER_ANAL_SOFT_RAYS | VARCHAR2 | Number of anal soft rays. | |
|
100
|
NUMBER_PECTORAL_RAYS | VARCHAR2 | Number of pectoral rays. | |
|
100
|
NUMBER_LATERAL_LINE_SCALES | VARCHAR2 | Number of lateral line scales in standard length. | |
|
100
|
SCALE_ROWS_BELOW_LATERAL_LINE | VARCHAR2 | Scale rows below lateral line. | |
|
100
|
THROAT_SCALES_ISTHMUS_PELVIC | VARCHAR2 | Midline throat scales from isthmus to pelvic fin insertions. | |
|
100
|
NUMBER_GILL_RAKERS_UPPER_ARCH | VARCHAR2 | Number of gill rakers on upper arch. | |
|
100
|
NUMBER_GILL_RAKERS_LOWER_ARCH | VARCHAR2 | Number of gill rakers on lower arch. | |
|
100
|
NUMBER_PRECAUDAL_VERTEBRATA | VARCHAR2 | Number of precaudal vertebrata. | |
|
100
|
NUMBER_CAUDAL_VERTEBRATA | VARCHAR2 | Number of caudal vertebrata. | |
|
100
|
TOTAL_NUMBER_VERTEBRATA | VARCHAR2 | Total number of vertebrata. | |
|
100
|
BODY_TYPE_HARDY_CLASS | VARCHAR2 | Body type, classified according to Hardy. | |
|
100
|
SEX_CODE | VARCHAR2 | Sex 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., D85306. | |
|
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: 1270634
| 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: 1270635
| 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 |
CRUISE_NUMBER
CC ID: 1270636
| Seq. Order: | 3 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 6 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Vessel code and the last two digits of the year of the cruise and two digits incremental number of the cruise, e.g., TC8205. |
| General Data Type: | VARCHAR2 |
SPECIES_CODE
CC ID: 1270637
| Seq. Order: | 4 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 5 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Five-digit CZM species code for armorhead, Pentaceros richardsoni. |
| General Data Type: | VARCHAR2 |
SPECIMEN_NUMBER
CC ID: 1270638
| Seq. Order: | 5 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique identification number assigned to each specimen. |
| General Data Type: | VARCHAR2 |
BODY_TYPE_CODE
CC ID: 1270639
| Seq. Order: | 6 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Body type code. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | 1 = LEAN; 2 = INTERMEDIATE; 3 = FAT |
BANK_CODE
CC ID: 1270640
| Seq. Order: | 7 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Code for the area or bank of capture. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | 1 = SE HANCOCK; 2 = NW HANCOCK; 3 = COLAHAN-HANCOCK SEAMOUNT COMPLEX |
WEIGHT
CC ID: 1270641
| Seq. Order: | 8 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 4 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Wet weight, in grams. Units for values are grams. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | grams |
STANDARD_LENGTH
CC ID: 1270642
| Seq. Order: | 9 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Standard length, in millimeters. Units for values are millimeters. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | millimeters |
SYSTEMATIC_STANDARD_LENGTH
CC ID: 1270643
| Seq. Order: | 10 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Systematic standard length, in millimeters. Units for values are millimeters. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | millimeters |
FORK_LENGTH
CC ID: 1270644
| Seq. Order: | 11 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Fork length, in millimeters. Units for values are millimeters. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | millimeters |
GREATEST_ORBIT_DIAMETER
CC ID: 1270645
| Seq. Order: | 12 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Greatest orbit diameter, in millimeters. Units for values are millimeters. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | millimeters |
LENGTH_ORBIT
CC ID: 1270646
| Seq. Order: | 13 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Length of orbit, in millimeters. Units for values are millimeters. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | millimeters |
LEAST_BONY_INTERORBITAL_WIDTH
CC ID: 1270647
| Seq. Order: | 14 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Least bony interorbital width, in millimeters. Units for values are millimeters. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | millimeters |
LEAST_BONY_INTERORBITAL_WIDTH2
CC ID: 1270648
| Seq. Order: | 15 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Least bony interorbital width, in millimeters. Units for values are millimeters. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | millimeters |
SNOUT_LENGTH
CC ID: 1270649
| Seq. Order: | 16 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Snout length, in millimeters. Units for values are millimeters. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | millimeters |
HEAD_LENGTH
CC ID: 1270650
| Seq. Order: | 17 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Head length, in millimeters. Units for values are millimeters. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | millimeters |
HEAD_LENGTH2
CC ID: 1270651
| Seq. Order: | 18 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Head length, in millimeters. Units for values are millimeters. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | millimeters |
PREDORSAL_LENGTH
CC ID: 1270652
| Seq. Order: | 19 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Predorsal length, in millimeters. Units for values are millimeters. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | millimeters |
PECTORAL_FIN_LENGTH
CC ID: 1270653
| Seq. Order: | 20 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Pectoral fin length, in millimeters. Units for values are millimeters. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | millimeters |
BODY_DEPTH_1ST_DORSAL_2_PELVIC
CC ID: 1270654
| Seq. Order: | 21 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Body depth from first dorsal origin to pelvic origin, in millimeters. Units for values are millimeters. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | millimeters |
BODY_DEPTH_1ST_ANAL_SPINE
CC ID: 1270655
| Seq. Order: | 22 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Body depth at first anal spine, in millimeters. Units for values are millimeters. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | millimeters |
MAXIMUM_BODY_DEPTH
CC ID: 1270656
| Seq. Order: | 23 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Maximum body depth, in millimeters. Units for values are millimeters. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | millimeters |
WIDTH_BASE_PELVIC_SPINE
CC ID: 1270657
| Seq. Order: | 24 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Width at base of pelvic spines, in millimeters. Units for values are millimeters. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | millimeters |
POST_DORSAL_2_POST_ANAL_BASE
CC ID: 1270658
| Seq. Order: | 25 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 3 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Posterior at dorsal fin base to posterior of anal fin base, in millimeters. Units for values are millimeters. |
| General Data Type: | VARCHAR2 |
| Unit of Measure: | millimeters |
NUMBER_DORSAL_SPINES
CC ID: 1270659
| Seq. Order: | 26 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of dorsal spines. |
| General Data Type: | VARCHAR2 |
NUMBER_DORSAL_SOFT_RAYS
CC ID: 1270660
| Seq. Order: | 27 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of dorsal soft rays. |
| General Data Type: | VARCHAR2 |
NUMBER_ANAL_SPINES
CC ID: 1270661
| Seq. Order: | 28 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of anal spines. |
| General Data Type: | VARCHAR2 |
NUMBER_ANAL_SOFT_RAYS
CC ID: 1270662
| Seq. Order: | 29 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of anal soft rays. |
| General Data Type: | VARCHAR2 |
NUMBER_PECTORAL_RAYS
CC ID: 1270663
| Seq. Order: | 30 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of pectoral rays. |
| General Data Type: | VARCHAR2 |
NUMBER_LATERAL_LINE_SCALES
CC ID: 1270664
| Seq. Order: | 31 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of lateral line scales in standard length. |
| General Data Type: | VARCHAR2 |
SCALE_ROWS_BELOW_LATERAL_LINE
CC ID: 1270665
| Seq. Order: | 32 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Scale rows below lateral line. |
| General Data Type: | VARCHAR2 |
THROAT_SCALES_ISTHMUS_PELVIC
CC ID: 1270666
| Seq. Order: | 33 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Midline throat scales from isthmus to pelvic fin insertions. |
| General Data Type: | VARCHAR2 |
NUMBER_GILL_RAKERS_UPPER_ARCH
CC ID: 1270667
| Seq. Order: | 34 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of gill rakers on upper arch. |
| General Data Type: | VARCHAR2 |
NUMBER_GILL_RAKERS_LOWER_ARCH
CC ID: 1270668
| Seq. Order: | 35 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of gill rakers on lower arch. |
| General Data Type: | VARCHAR2 |
NUMBER_PRECAUDAL_VERTEBRATA
CC ID: 1270669
| Seq. Order: | 36 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of precaudal vertebrata. |
| General Data Type: | VARCHAR2 |
NUMBER_CAUDAL_VERTEBRATA
CC ID: 1270670
| Seq. Order: | 37 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Number of caudal vertebrata. |
| General Data Type: | VARCHAR2 |
TOTAL_NUMBER_VERTEBRATA
CC ID: 1270671
| Seq. Order: | 38 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 2 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Total number of vertebrata. |
| General Data Type: | VARCHAR2 |
BODY_TYPE_HARDY_CLASS
CC ID: 1270672
| Seq. Order: | 39 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Body type, classified according to Hardy. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | I; P; W |
SEX_CODE
CC ID: 1270673
| Seq. Order: | 40 |
|---|---|
| Data Storage Type: | VARCHAR2 |
| Max Length: | 1 |
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Sex code. |
| General Data Type: | VARCHAR2 |
| Allowed Values: | 1 = FEMALE; 2 = MALE |
JOB_NUMBER
CC ID: 1270674
| Seq. Order: | 41 |
|---|---|
| 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., D85306. |
| General Data Type: | VARCHAR2 |
SEQUENCE_NUMBER
CC ID: 1270675
| 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: 1270676
| 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: | 70758 |
|---|---|
| GUID: | gov.noaa.nmfs.inport:70758 |
| Metadata Record Created By: | Brent M Miyamoto |
| Metadata Record Created: | 2023-09-04 23:22+0000 |
| Metadata Record Last Modified By: | Brent M Miyamoto |
| Metadata Record Last Modified: | 2023-09-07 18:09+0000 |
| Metadata Record Published: | 2023-09-06 |
| Owner Org: | PIFSC |
| Metadata Publication Status: | Published Externally |
| Do Not Publish?: | N |
| Metadata Last Review Date: | 2023-09-06 |
| Metadata Review Frequency: | 1 Year |
| Metadata Next Review Date: | 2024-09-06 |