View: ASMLNH
Entity (ENT) | Northeast Fisheries Science Center (NEFSC)GUID: gov.noaa.nmfs.inport:33555 | Updated: August 9, 2022 | Published / External
Item Identification
Title: | View: ASMLNH |
---|---|
Short Name: | ASMLNH |
Status: | Completed |
Abstract: |
At Sea Monitor Animal Length Header Data |
Notes: |
Loaded by batch 9053, 07-27-2016 19:10 |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | OBDBS |
Description: |
At Sea Monitor Animal Length Header Data |
Data Attributes
Attribute Summary
![]() |
![]() |
Name | Type | Description |
---|---|---|---|---|
100
|
LINK3 | VARCHAR2 | Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable. | |
100
|
LINK1 | VARCHAR2 | 15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable. | |
100
|
PROGRAM | VARCHAR2 | First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. | |
100
|
YEAR | VARCHAR2 | Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. | |
100
|
MONTH | VARCHAR2 | Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. | |
100
|
TRIPID | VARCHAR2 | May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable. | |
100
|
HAULNUM | VARCHAR2 | Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable. | |
100
|
LINK5 | VARCHAR2 | field that combines link3, nespp4, sex, fishdisp, dredgepos; links length header and length detail. Collected for ASM where applicable. | |
100
|
NESPP4 | VARCHAR2 | Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable. | |
100
|
FISHDISP | VARCHAR2 | Three digit code for disposition of each species (catdisp plus discreason). See OBFISHDISP table. IAL: discard reason not recorded previous to 5/1994; last two digits of fishdisp set to 00 (unknown discard reason); Collected for ASM where applicable. | |
100
|
CATDISP | VARCHAR2 | Code to indicate catch disposition. 0 = discarded, 1 = kept, 9 = unknown. Collected for ASM where applicable. | |
100
|
SEX | VARCHAR2 | One digit code for sex of each animal whether it is brought on board or not. 0=unknown; 1=male; 2=female. | |
100
|
DREDGEPOS | VARCHAR2 | Which dredge the sample was taken from : P=port, S=Starboard, A= Aft, U= Unknown. Not recorded before 5/1994; set to unknown; | |
100
|
SAMPWEIGHT | NUMBER | Collective Round, actual weight, of measured animals for species , sex, and market category of fish being sampled. Collected for ASM where applicable. | |
100
|
AGESTRCT | VARCHAR2 | Type of age structure collected for sample: 0 = none, 1 = scales, 2 = otoliths, 3 = shells, 4 = whole, 5 = vertebra, 6 = dorsal spines, 7 = scales and otoliths, 8 = head, 9 = other (see comments). | |
100
|
NAGESTRCT | NUMBER | Total number of animals from which age samples were collected. | |
100
|
VOLMEATS | NUMBER | Volumetric measure of scallop meats, to nearest 50 millileters. Not collected previous to 5/1994; set to unknown. | |
100
|
LNHCOMMENTS | VARCHAR2 | Comments on length record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable. | |
100
|
ASMTEST_STATUS | VARCHAR2 | Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested |
Attribute Details
LINK3
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 19 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Key field linking tables at the haul level; made up of: link1 plus (4-character) haulnum. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
LINK1
Seq. Order: | 2 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 15 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
15-character Key field linking tables at the trip level; made up of: program + year + month + tripid. Appears as first 15 characters in all 'LINK ' fields. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
PROGRAM
Seq. Order: | 3 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
First three digits of links. Code that identifies program, see OBPROGRAM table. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
YEAR
Seq. Order: | 4 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year Landed; characters 4 - 7 of link1 - link6. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
MONTH
Seq. Order: | 5 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Month landed, the 8 - 9 characters in all link fields. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
TRIPID
Seq. Order: | 6 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
May 1994 - current: 6 - character trip id; first three characters are the observer id number (obsid) and the second are the ordinal number of trips the observer has taken for the current year. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
HAULNUM
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Ordinal number of haul within the trip; 4 characters beginning at position 16 of link3. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
LINK5
Seq. Order: | 8 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 29 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
field that combines link3, nespp4, sex, fishdisp, dredgepos; links length header and length detail. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
NESPP4
Seq. Order: | 9 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Northeast commercial fish species code enhanced to accommodate protected and other non-commercial species. See OBSPEC Table. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
FISHDISP
Seq. Order: | 10 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | Yes |
Primary Key: | No |
Status: | Active |
Description: |
Three digit code for disposition of each species (catdisp plus discreason). See OBFISHDISP table. IAL: discard reason not recorded previous to 5/1994; last two digits of fishdisp set to 00 (unknown discard reason); Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
CATDISP
Seq. Order: | 11 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code to indicate catch disposition. 0 = discarded, 1 = kept, 9 = unknown. Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
SEX
Seq. Order: | 12 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
One digit code for sex of each animal whether it is brought on board or not. 0=unknown; 1=male; 2=female. |
General Data Type: | VARCHAR2 |
DREDGEPOS
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Which dredge the sample was taken from : P=port, S=Starboard, A= Aft, U= Unknown. Not recorded before 5/1994; set to unknown; |
General Data Type: | VARCHAR2 |
SAMPWEIGHT
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 6 |
Scale: | 1 |
Status: | Active |
Description: |
Collective Round, actual weight, of measured animals for species , sex, and market category of fish being sampled. Collected for ASM where applicable. |
General Data Type: | NUMBER |
AGESTRCT
Seq. Order: | 15 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Type of age structure collected for sample: 0 = none, 1 = scales, 2 = otoliths, 3 = shells, 4 = whole, 5 = vertebra, 6 = dorsal spines, 7 = scales and otoliths, 8 = head, 9 = other (see comments). |
General Data Type: | VARCHAR2 |
NAGESTRCT
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Total number of animals from which age samples were collected. |
General Data Type: | NUMBER |
VOLMEATS
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 5 |
Scale: | 0 |
Status: | Active |
Description: |
Volumetric measure of scallop meats, to nearest 50 millileters. Not collected previous to 5/1994; set to unknown. |
General Data Type: | NUMBER |
LNHCOMMENTS
Seq. Order: | 18 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 250 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Comments on length record. Prior to 2001 only true (1), false (0). Collected for ASM where applicable. |
General Data Type: | VARCHAR2 |
ASMTEST_STATUS
Seq. Order: | 19 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Test / Load status for At Sea Monitoring trip. PRELIM = preliminary testing, BASE = fully tested |
General Data Type: | VARCHAR2 |
Catalog Details
Catalog Item ID: | 33555 |
---|---|
GUID: | gov.noaa.nmfs.inport:33555 |
Metadata Record Created By: | Patricia L Jones |
Metadata Record Created: | 2016-07-27 19:10+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2016-07-28 |
Owner Org: | NEFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2016-07-28 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2017-07-28 |