View: DEBRIEFED_AGE_SQUASH_CONCAT
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:53917 | Updated: August 9, 2022 | Published / External
-
View As
- Full List View
- Printable Form
- EXPORTS
- InPort XML
- View in Hierarchy
Summary
snapshot table for snapshot OBSINT.DEBRIEFED_AGE_SQUASH_CONCAT
Descriptionsnapshot table for snapshot OBSINT.DEBRIEFED_AGE_SQUASH_CONCAT
Debriefed_age_squash_concat is a materialized view created from the data in the debriefed_age table in a summary format presenting all specimen_types sampled for a single distinct individual animal are concatenated into one column. Also there is another column for all the corresponding concatenated specimen_type_descriptions. The debriefed_age table is a bridge object between the Domestic data (pre 2008) and the ATL data (2008 onwards) As such, refinements to the structure and statistical reliability realized in the redevelopment of Norpac are lost. The use of this table is primarily for status of stocks authors who require a longitudinal view of observer data.
Entity Information
Entity Type
Data View
Data Attribute / Type | Description |
---|---|
ADIPOSE_PRESENT
VARCHAR2 |
Is adipose on a specimen Y, N or U. Null for non adipose specimen. As of 01/01/2014, this attribute is only used for hake data (where atl_haul.haul_purpose_code = 'HAK'). |
AGE
NUMBER |
Age of the animal (Specimen) in years. Populated by Age and Growth Staff without system validation. |
BARCODE
NUMBER |
Whenever a barcode is printed on a vial (otolith) or bag (tag and bag) this attribute contains the value. See salmon_snout_barcode column for barcodes of salmon snouts (used by hake fishery observers only). |
SALMON_SNOUT_BARCODE
NUMBER |
Barcode for salmon snout; used by hake fishery observers only. |
BOTTOM_DEPTH_FATHOMS
NUMBER |
Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. |
CRUISE
NUMBER |
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. |
CDQ_CODE
VARCHAR2 |
Unique AlphaNumeric code representing a CDQ or research group. |
FISHING_DEPTH_FATHOMS
NUMBER |
Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. |
GEAR
NUMBER |
Numeric value from Norpac Domestic Gear or atl_lov_gear_type that combined with the Form defines the unique identifier for a gear record. |
HAUL_JOIN
NUMBER |
Surrogate FK to haul if length record is so derived Composed of concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul. |
HAUL_OFFLOAD
NUMBER |
Number which is entered by the observer identifying a unique haul or offload depending on which was the ultimate data source. |
HAUL_OFFLOAD_DATE
DATE |
Date of offload or haul retrieval depending on whether this length frequency record was derived from an offload or a haul. |
INJURY
VARCHAR2 |
Halibut injury code. |
LATDD_END
NUMBER |
Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. |
LATDD_START
NUMBER |
Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. |
LENGTH
NUMBER |
Inherited from atl_length or observer entered for Domestic Table age records. |
LENGTH_SEQ
NUMBER |
All post 2008 specimen records are derived from length records. length_seq is the FK, This attribute is null for Domestic Table age records. |
LONDD_END
NUMBER |
Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. |
LONDD_START
NUMBER |
Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. |
MATURITY_CODE
VARCHAR2 |
Sexual maturity code. |
MATURITY_DESCRIPTION
VARCHAR2 |
Sexual maturity code description. This attribute is null for Domestic Table age records. |
NMFS_AREA
NUMBER |
Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. |
PERFORMANCE
NUMBER |
Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. |
PERMIT
VARCHAR2 |
Unique Code identifying a Vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau. |
PLANT_SEQ
NUMBER |
Sequence generated unique identifier for a processing plant. |
PORT_JOIN
NUMBER |
Surrogate FK to offload if length record is so derived. Composed of concatenation of cruise, permit and offload_seq. For domestic table records this is a sequence generated unique identifier for a port. |
SAMPLE_SYSTEM
NUMBER |
Code for sampling system employed by the observer. |
SEX
VARCHAR2 |
Sex either inherited from length or recorded in age/atl_fish_inv_specimen if different. |
SPECIAL_PROJECT_CODES
VARCHAR2 |
No longer used. |
SPECIES
NUMBER |
Species either inherited from length or recorded in age/atl_fish_inv_specimen if different. |
SPECIMEN_NUMBER
NUMBER |
A specimen number is unique within a length and specimen type, user defined identifier. In the case of an otolith it is the bar coded sample identifier attached to the collection vial. |
SPECIMEN_TYPES
VARCHAR2 |
All Specimen_type_codes for an individual specimen concatenated in this attribute. |
SPECIMEN_TYPE_DESCRIPTIONS
VARCHAR2 |
All specimen_type_descriptions for an individual specimen concatenated in this attribute. This attribute is null for Domestic Table age records. |
T_TABLE
VARCHAR2 |
Identifier of Source Table. |
VESSEL_CODE
VARCHAR2 |
Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel. |
VESSEL_SEQ
NUMBER |
Sequence generated unique identifier for a vessel. |
VIABILITY
VARCHAR2 |
Halibut viability code. |
WEIGHT
NUMBER |
Weight in kg of the specimen. |
MATURITY_WEIGHT
NUMBER |
Weight of the animal with sex organs removed. No longer used. |
YEAR
NUMBER |
Year extracted from haul retrieval date or offload deleivery end date. |
Child Items
No Child Items for this record.
Contact Information
No contact information is available for this record.
Please contact the owner organization (AFSC) for inquiries on this record.
Item Identification
Title: | View: DEBRIEFED_AGE_SQUASH_CONCAT |
---|---|
Short Name: | DEBRIEFED_AGE_SQUASH_CONCAT |
Status: | Completed |
Abstract: |
snapshot table for snapshot OBSINT.DEBRIEFED_AGE_SQUASH_CONCAT |
Entity Information
Entity Type: | Data View |
---|---|
Active Version?: | Yes |
Schema Name: | OBSINT |
Description: |
snapshot table for snapshot OBSINT.DEBRIEFED_AGE_SQUASH_CONCAT Debriefed_age_squash_concat is a materialized view created from the data in the debriefed_age table in a summary format presenting all specimen_types sampled for a single distinct individual animal are concatenated into one column. Also there is another column for all the corresponding concatenated specimen_type_descriptions. The debriefed_age table is a bridge object between the Domestic data (pre 2008) and the ATL data (2008 onwards) As such, refinements to the structure and statistical reliability realized in the redevelopment of Norpac are lost. The use of this table is primarily for status of stocks authors who require a longitudinal view of observer data. |
Data Attributes
Attribute Summary
Name | Type | Description | ||
---|---|---|---|---|
100
|
ADIPOSE_PRESENT | VARCHAR2 | Is adipose on a specimen Y, N or U. Null for non adipose specimen. As of 01/01/2014, this attribute is only used for hake data (where atl_haul.haul_purpose_code = 'HAK'). | |
100
|
AGE | NUMBER | Age of the animal (Specimen) in years. Populated by Age and Growth Staff without system validation. | |
100
|
BARCODE | NUMBER | Whenever a barcode is printed on a vial (otolith) or bag (tag and bag) this attribute contains the value. See salmon_snout_barcode column for barcodes of salmon snouts (used by hake fishery observers only). | |
100
|
SALMON_SNOUT_BARCODE | NUMBER | Barcode for salmon snout; used by hake fishery observers only. | |
100
|
BOTTOM_DEPTH_FATHOMS | NUMBER | Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. | |
100
|
CRUISE | NUMBER | Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. | |
100
|
CDQ_CODE | VARCHAR2 | Unique AlphaNumeric code representing a CDQ or research group. | |
100
|
FISHING_DEPTH_FATHOMS | NUMBER | Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. | |
100
|
GEAR | NUMBER | Numeric value from Norpac Domestic Gear or atl_lov_gear_type that combined with the Form defines the unique identifier for a gear record. | |
100
|
HAUL_JOIN | NUMBER | Surrogate FK to haul if length record is so derived Composed of concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul. | |
100
|
HAUL_OFFLOAD | NUMBER | Number which is entered by the observer identifying a unique haul or offload depending on which was the ultimate data source. | |
100
|
HAUL_OFFLOAD_DATE | DATE | Date of offload or haul retrieval depending on whether this length frequency record was derived from an offload or a haul. | |
100
|
INJURY | VARCHAR2 | Halibut injury code. | |
100
|
LATDD_END | NUMBER | Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. | |
100
|
LATDD_START | NUMBER | Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. | |
100
|
LENGTH | NUMBER | Inherited from atl_length or observer entered for Domestic Table age records. | |
100
|
LENGTH_SEQ | NUMBER | All post 2008 specimen records are derived from length records. length_seq is the FK, This attribute is null for Domestic Table age records. | |
100
|
LONDD_END | NUMBER | Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. | |
100
|
LONDD_START | NUMBER | Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. | |
100
|
MATURITY_CODE | VARCHAR2 | Sexual maturity code. | |
100
|
MATURITY_DESCRIPTION | VARCHAR2 | Sexual maturity code description. This attribute is null for Domestic Table age records. | |
100
|
NMFS_AREA | NUMBER | Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. | |
100
|
PERFORMANCE | NUMBER | Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. | |
100
|
PERMIT | VARCHAR2 | Unique Code identifying a Vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau. | |
100
|
PLANT_SEQ | NUMBER | Sequence generated unique identifier for a processing plant. | |
100
|
PORT_JOIN | NUMBER | Surrogate FK to offload if length record is so derived. Composed of concatenation of cruise, permit and offload_seq. For domestic table records this is a sequence generated unique identifier for a port. | |
100
|
SAMPLE_SYSTEM | NUMBER | Code for sampling system employed by the observer. | |
100
|
SEX | VARCHAR2 | Sex either inherited from length or recorded in age/atl_fish_inv_specimen if different. | |
100
|
SPECIAL_PROJECT_CODES | VARCHAR2 | No longer used. | |
100
|
SPECIES | NUMBER | Species either inherited from length or recorded in age/atl_fish_inv_specimen if different. | |
100
|
SPECIMEN_NUMBER | NUMBER | A specimen number is unique within a length and specimen type, user defined identifier. In the case of an otolith it is the bar coded sample identifier attached to the collection vial. | |
100
|
SPECIMEN_TYPES | VARCHAR2 | All Specimen_type_codes for an individual specimen concatenated in this attribute. | |
100
|
SPECIMEN_TYPE_DESCRIPTIONS | VARCHAR2 | All specimen_type_descriptions for an individual specimen concatenated in this attribute. This attribute is null for Domestic Table age records. | |
100
|
T_TABLE | VARCHAR2 | Identifier of Source Table. | |
100
|
VESSEL_CODE | VARCHAR2 | Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel. | |
100
|
VESSEL_SEQ | NUMBER | Sequence generated unique identifier for a vessel. | |
100
|
VIABILITY | VARCHAR2 | Halibut viability code. | |
100
|
WEIGHT | NUMBER | Weight in kg of the specimen. | |
100
|
MATURITY_WEIGHT | NUMBER | Weight of the animal with sex organs removed. No longer used. | |
100
|
YEAR | NUMBER | Year extracted from haul retrieval date or offload deleivery end date. |
Attribute Details
ADIPOSE_PRESENT
Seq. Order: | 1 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Is adipose on a specimen Y, N or U. Null for non adipose specimen. As of 01/01/2014, this attribute is only used for hake data (where atl_haul.haul_purpose_code = 'HAK'). |
General Data Type: | VARCHAR2 |
AGE
Seq. Order: | 2 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Age of the animal (Specimen) in years. Populated by Age and Growth Staff without system validation. |
General Data Type: | NUMBER |
BARCODE
Seq. Order: | 3 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Whenever a barcode is printed on a vial (otolith) or bag (tag and bag) this attribute contains the value. See salmon_snout_barcode column for barcodes of salmon snouts (used by hake fishery observers only). |
General Data Type: | NUMBER |
SALMON_SNOUT_BARCODE
Seq. Order: | 4 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Barcode for salmon snout; used by hake fishery observers only. |
General Data Type: | NUMBER |
BOTTOM_DEPTH_FATHOMS
Seq. Order: | 5 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. |
General Data Type: | NUMBER |
CRUISE
Seq. Order: | 6 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 8 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record. |
General Data Type: | NUMBER |
CDQ_CODE
Seq. Order: | 7 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 3 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique AlphaNumeric code representing a CDQ or research group. |
General Data Type: | VARCHAR2 |
FISHING_DEPTH_FATHOMS
Seq. Order: | 8 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. |
General Data Type: | NUMBER |
GEAR
Seq. Order: | 9 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Numeric value from Norpac Domestic Gear or atl_lov_gear_type that combined with the Form defines the unique identifier for a gear record. |
General Data Type: | NUMBER |
HAUL_JOIN
Seq. Order: | 10 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Surrogate FK to haul if length record is so derived Composed of concatenation of cruise, permit and haul_seq. For domestic table records this is a sequence generated unique identifier for a haul. |
General Data Type: | NUMBER |
HAUL_OFFLOAD
Seq. Order: | 11 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Number which is entered by the observer identifying a unique haul or offload depending on which was the ultimate data source. |
General Data Type: | NUMBER |
HAUL_OFFLOAD_DATE
Seq. Order: | 12 |
---|---|
Data Storage Type: | DATE |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Date of offload or haul retrieval depending on whether this length frequency record was derived from an offload or a haul. |
General Data Type: | DATE |
INJURY
Seq. Order: | 13 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 40 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Halibut injury code. |
General Data Type: | VARCHAR2 |
LATDD_END
Seq. Order: | 14 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. |
General Data Type: | NUMBER |
LATDD_START
Seq. Order: | 15 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. |
General Data Type: | NUMBER |
LENGTH
Seq. Order: | 16 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Inherited from atl_length or observer entered for Domestic Table age records. |
General Data Type: | NUMBER |
LENGTH_SEQ
Seq. Order: | 17 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
All post 2008 specimen records are derived from length records. length_seq is the FK, This attribute is null for Domestic Table age records. |
General Data Type: | NUMBER |
LONDD_END
Seq. Order: | 18 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. |
General Data Type: | NUMBER |
LONDD_START
Seq. Order: | 19 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. |
General Data Type: | NUMBER |
MATURITY_CODE
Seq. Order: | 20 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 2 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sexual maturity code. |
General Data Type: | VARCHAR2 |
MATURITY_DESCRIPTION
Seq. Order: | 21 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 60 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sexual maturity code description. This attribute is null for Domestic Table age records. |
General Data Type: | VARCHAR2 |
NMFS_AREA
Seq. Order: | 22 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 3 |
Scale: | 0 |
Status: | Active |
Description: |
Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. |
General Data Type: | NUMBER |
PERFORMANCE
Seq. Order: | 23 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records. |
General Data Type: | NUMBER |
PERMIT
Seq. Order: | 24 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 6 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Unique Code identifying a Vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau. |
General Data Type: | VARCHAR2 |
PLANT_SEQ
Seq. Order: | 25 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier for a processing plant. |
General Data Type: | NUMBER |
PORT_JOIN
Seq. Order: | 26 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Surrogate FK to offload if length record is so derived. Composed of concatenation of cruise, permit and offload_seq. For domestic table records this is a sequence generated unique identifier for a port. |
General Data Type: | NUMBER |
SAMPLE_SYSTEM
Seq. Order: | 27 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Code for sampling system employed by the observer. |
General Data Type: | NUMBER |
SEX
Seq. Order: | 28 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Sex either inherited from length or recorded in age/atl_fish_inv_specimen if different. |
General Data Type: | VARCHAR2 |
SPECIAL_PROJECT_CODES
Seq. Order: | 29 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
No longer used. |
General Data Type: | VARCHAR2 |
SPECIES
Seq. Order: | 30 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Species either inherited from length or recorded in age/atl_fish_inv_specimen if different. |
General Data Type: | NUMBER |
SPECIMEN_NUMBER
Seq. Order: | 31 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
A specimen number is unique within a length and specimen type, user defined identifier. In the case of an otolith it is the bar coded sample identifier attached to the collection vial. |
General Data Type: | NUMBER |
SPECIMEN_TYPES
Seq. Order: | 32 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
All Specimen_type_codes for an individual specimen concatenated in this attribute. |
General Data Type: | VARCHAR2 |
SPECIMEN_TYPE_DESCRIPTIONS
Seq. Order: | 33 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 4000 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
All specimen_type_descriptions for an individual specimen concatenated in this attribute. This attribute is null for Domestic Table age records. |
General Data Type: | VARCHAR2 |
T_TABLE
Seq. Order: | 34 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 50 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Identifier of Source Table. |
General Data Type: | VARCHAR2 |
VESSEL_CODE
Seq. Order: | 35 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 7 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel. |
General Data Type: | VARCHAR2 |
VESSEL_SEQ
Seq. Order: | 36 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Precision: | 9 |
Scale: | 0 |
Status: | Active |
Description: |
Sequence generated unique identifier for a vessel. |
General Data Type: | NUMBER |
VIABILITY
Seq. Order: | 37 |
---|---|
Data Storage Type: | VARCHAR2 |
Max Length: | 1 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Halibut viability code. |
General Data Type: | VARCHAR2 |
WEIGHT
Seq. Order: | 38 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Weight in kg of the specimen. |
General Data Type: | NUMBER |
MATURITY_WEIGHT
Seq. Order: | 39 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Weight of the animal with sex organs removed. No longer used. |
General Data Type: | NUMBER |
YEAR
Seq. Order: | 40 |
---|---|
Data Storage Type: | NUMBER |
Max Length: | 22 |
Required: | No |
Primary Key: | No |
Status: | Active |
Description: |
Year extracted from haul retrieval date or offload deleivery end date. |
General Data Type: | NUMBER |
Catalog Details
Catalog Item ID: | 53917 |
---|---|
GUID: | gov.noaa.nmfs.inport:53917 |
Metadata Record Created By: | Renold E Narita |
Metadata Record Created: | 2018-09-25 18:41+0000 |
Metadata Record Last Modified By: | SysAdmin InPortAdmin |
Metadata Record Last Modified: | 2022-08-09 17:11+0000 |
Metadata Record Published: | 2018-09-25 |
Owner Org: | AFSC |
Metadata Publication Status: | Published Externally |
Do Not Publish?: | N |
Metadata Last Review Date: | 2018-09-25 |
Metadata Review Frequency: | 1 Year |
Metadata Next Review Date: | 2019-09-25 |