Metadata Rubric

100%

6 / 6

Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Debriefed Observer Data Interface > AFSC/FMA/North Pacific Observer Debriefed Data... >

View: DEBRIEFED_AGE_SQUASH_SP_TYPE

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:53918 | Updated: August 9, 2022 | Published / External

Summary

Item Identification

Entity Info

Data Attributes

Catalog Details

Abstract

snapshot table for snapshot OBSINT.DEBRIEFED_AGE_SQUASH_SP_TYPE

Description

snapshot table for snapshot OBSINT.DEBRIEFED_AGE_SQUASH_SP_TYPE

Debriefed_age_sp_type is a materialized view created from the data in the debriefed_age table in a summary format presenting all specimen_types and specimen_type_descriptions in their own columns, with each row representing a distinct individual animal. Each specimen_type taken is denoted by a "Y" in its own column. The column is null for all specimen types not taken. 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 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. Does not include the salmon snout barcode, used only by hake fishery observers; see separate salmon_snout_barcode column for this data.
SALMON_SNOUT_BARCODE NUMBER	Salmon snout barcode. Barcode for salmon snout only used by Hake fishery observers.
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.
TYPE_1_OTOLITH CHAR	Specimen type 1 for otolith is denoted by a "Y" if taken; null if not taken.
TYPE_2_SCALE CHAR	Specimen type 2 for scale is denoted by a "Y" if taken; null if not taken.
TYPE_3_SEX_LENGTH_WEIGHT CHAR	Specimen type 3 for sex_length_weight is denoted by a "Y" if taken; null if not taken.
TYPE_4_FIN_CLIPS CHAR	Specimen type 4 for fin_clips is denoted by a "Y" if taken; null if not taken.
TYPE_5_VERTEBRAE CHAR	Specimen type 5 for vertebrae is denoted by a "Y" if taken; null if not taken.
TYPE_6_SPINES CHAR	Specimen type 6 for spines is denoted by a "Y" if taken; null if not taken.
TYPE_7_MATURITY_SCAN CHAR	Specimen type 7 for maturity scan is denoted by a "Y" if taken; null if not taken.
TYPE_8_MATURITY CHAR	Specimen type 8 for maturity is denoted by a "Y" if taken; null if not taken.
TYPE_9_STOMACHS CHAR	Specimen type 9 for stomachs is denoted by a "Y" if stomach samples were taken; null if not taken.
TYPE_10_ISOTOPES CHAR	Specimen type 10 for isotopes is denoted by a "Y" if taken; null if not taken.
TYPE_11_OTHER_TISSUE CHAR	Specimen type 11 for other tissue is denoted by a "Y" if taken; null if not taken.
TYPE_12_SNOUT CHAR	Specimen type 12 for snout is denoted by a "Y" if taken; null if not taken.
TYPE_13_ADIPOSE_PRESENT CHAR	Specimen type 13 for adipose present is denoted by a "Y" if taken; null if not taken.
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.

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. Does not include the salmon snout barcode, used only by hake fishery observers; see separate salmon_snout_barcode column for this data.

SALMON_SNOUT_BARCODE
NUMBER

Salmon snout barcode. Barcode for salmon snout only used by Hake fishery observers.

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.

TYPE_1_OTOLITH
CHAR

Specimen type 1 for otolith is denoted by a "Y" if taken; null if not taken.

TYPE_2_SCALE
CHAR

Specimen type 2 for scale is denoted by a "Y" if taken; null if not taken.

TYPE_3_SEX_LENGTH_WEIGHT
CHAR

Specimen type 3 for sex_length_weight is denoted by a "Y" if taken; null if not taken.

TYPE_4_FIN_CLIPS
CHAR

Specimen type 4 for fin_clips is denoted by a "Y" if taken; null if not taken.

TYPE_5_VERTEBRAE
CHAR

Specimen type 5 for vertebrae is denoted by a "Y" if taken; null if not taken.

TYPE_6_SPINES
CHAR

Specimen type 6 for spines is denoted by a "Y" if taken; null if not taken.

TYPE_7_MATURITY_SCAN
CHAR

Specimen type 7 for maturity scan is denoted by a "Y" if taken; null if not taken.

TYPE_8_MATURITY
CHAR

Specimen type 8 for maturity is denoted by a "Y" if taken; null if not taken.

TYPE_9_STOMACHS
CHAR

Specimen type 9 for stomachs is denoted by a "Y" if stomach samples were taken; null if not taken.

TYPE_10_ISOTOPES
CHAR

Specimen type 10 for isotopes is denoted by a "Y" if taken; null if not taken.

TYPE_11_OTHER_TISSUE
CHAR

Specimen type 11 for other tissue is denoted by a "Y" if taken; null if not taken.

TYPE_12_SNOUT
CHAR

Specimen type 12 for snout is denoted by a "Y" if taken; null if not taken.

TYPE_13_ADIPOSE_PRESENT
CHAR

Specimen type 13 for adipose present is denoted by a "Y" if taken; null if not taken.

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.

No Child Items for this record.

No contact information is available for this record.

Please contact the owner organization (AFSC) for inquiries on this record.

Title:	View: DEBRIEFED_AGE_SQUASH_SP_TYPE
Short Name:	DEBRIEFED_AGE_SQUASH_SP_TYPE
Status:	Completed
Abstract:	snapshot table for snapshot OBSINT.DEBRIEFED_AGE_SQUASH_SP_TYPE

Entity Type:	Data View
Active Version?:	Yes
Schema Name:	OBSINT
Description:	snapshot table for snapshot OBSINT.DEBRIEFED_AGE_SQUASH_SP_TYPE Debriefed_age_sp_type is a materialized view created from the data in the debriefed_age table in a summary format presenting all specimen_types and specimen_type_descriptions in their own columns, with each row representing a distinct individual animal. Each specimen_type taken is denoted by a "Y" in its own column. The column is null for all specimen types not taken. 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.

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. Does not include the salmon snout barcode, used only by hake fishery observers; see separate salmon_snout_barcode column for this data.
100	SALMON_SNOUT_BARCODE	NUMBER	Salmon snout barcode. Barcode for salmon snout only used by Hake fishery observers.
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	TYPE_1_OTOLITH	CHAR	Specimen type 1 for otolith is denoted by a "Y" if taken; null if not taken.
100	TYPE_2_SCALE	CHAR	Specimen type 2 for scale is denoted by a "Y" if taken; null if not taken.
100	TYPE_3_SEX_LENGTH_WEIGHT	CHAR	Specimen type 3 for sex_length_weight is denoted by a "Y" if taken; null if not taken.
100	TYPE_4_FIN_CLIPS	CHAR	Specimen type 4 for fin_clips is denoted by a "Y" if taken; null if not taken.
100	TYPE_5_VERTEBRAE	CHAR	Specimen type 5 for vertebrae is denoted by a "Y" if taken; null if not taken.
100	TYPE_6_SPINES	CHAR	Specimen type 6 for spines is denoted by a "Y" if taken; null if not taken.
100	TYPE_7_MATURITY_SCAN	CHAR	Specimen type 7 for maturity scan is denoted by a "Y" if taken; null if not taken.
100	TYPE_8_MATURITY	CHAR	Specimen type 8 for maturity is denoted by a "Y" if taken; null if not taken.
100	TYPE_9_STOMACHS	CHAR	Specimen type 9 for stomachs is denoted by a "Y" if stomach samples were taken; null if not taken.
100	TYPE_10_ISOTOPES	CHAR	Specimen type 10 for isotopes is denoted by a "Y" if taken; null if not taken.
100	TYPE_11_OTHER_TISSUE	CHAR	Specimen type 11 for other tissue is denoted by a "Y" if taken; null if not taken.
100	TYPE_12_SNOUT	CHAR	Specimen type 12 for snout is denoted by a "Y" if taken; null if not taken.
100	TYPE_13_ADIPOSE_PRESENT	CHAR	Specimen type 13 for adipose present is denoted by a "Y" if taken; null if not taken.
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.

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

100

SALMON_SNOUT_BARCODE

NUMBER

Salmon snout barcode. Barcode for salmon snout only used by Hake fishery observers.

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

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

TYPE_1_OTOLITH

CHAR

Specimen type 1 for otolith is denoted by a "Y" if taken; null if not taken.

100

TYPE_2_SCALE

CHAR

Specimen type 2 for scale is denoted by a "Y" if taken; null if not taken.

100

TYPE_3_SEX_LENGTH_WEIGHT

CHAR

Specimen type 3 for sex_length_weight is denoted by a "Y" if taken; null if not taken.

100

TYPE_4_FIN_CLIPS

CHAR

Specimen type 4 for fin_clips is denoted by a "Y" if taken; null if not taken.

100

TYPE_5_VERTEBRAE

CHAR

Specimen type 5 for vertebrae is denoted by a "Y" if taken; null if not taken.

100

TYPE_6_SPINES

CHAR

Specimen type 6 for spines is denoted by a "Y" if taken; null if not taken.

100

TYPE_7_MATURITY_SCAN

CHAR

Specimen type 7 for maturity scan is denoted by a "Y" if taken; null if not taken.

100

TYPE_8_MATURITY

CHAR

Specimen type 8 for maturity is denoted by a "Y" if taken; null if not taken.

100

TYPE_9_STOMACHS

CHAR

Specimen type 9 for stomachs is denoted by a "Y" if stomach samples were taken; null if not taken.

100

TYPE_10_ISOTOPES

CHAR

Specimen type 10 for isotopes is denoted by a "Y" if taken; null if not taken.

100

TYPE_11_OTHER_TISSUE

CHAR

Specimen type 11 for other tissue is denoted by a "Y" if taken; null if not taken.

100

TYPE_12_SNOUT

CHAR

Specimen type 12 for snout is denoted by a "Y" if taken; null if not taken.

100

TYPE_13_ADIPOSE_PRESENT

CHAR

Specimen type 13 for adipose present is denoted by a "Y" if taken; null if not taken.

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

CC ID: 782408

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

CC ID: 782409

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

CC ID: 782410

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. Does not include the salmon snout barcode, used only by hake fishery observers; see separate salmon_snout_barcode column for this data.
General Data Type:	NUMBER

SALMON_SNOUT_BARCODE

CC ID: 782411

Seq. Order:	4
Data Storage Type:	NUMBER
Max Length:	22
Required:	No
Primary Key:	No
Status:	Active
Description:	Salmon snout barcode. Barcode for salmon snout only used by Hake fishery observers.
General Data Type:	NUMBER

BOTTOM_DEPTH_FATHOMS

CC ID: 782412

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

CC ID: 782413

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

CC ID: 782414

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

CC ID: 782415

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

CC ID: 782416

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

CC ID: 782417

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

CC ID: 782418

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

CC ID: 782419

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

CC ID: 782420

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

CC ID: 782421

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

CC ID: 782422

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

CC ID: 782423

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

CC ID: 782424

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

CC ID: 782425

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

CC ID: 782426

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

CC ID: 782427

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

CC ID: 782428

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

CC ID: 782429

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

CC ID: 782430

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

CC ID: 782431

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

CC ID: 782432

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

CC ID: 782433

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

CC ID: 782434

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

CC ID: 782435

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

CC ID: 782436

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

CC ID: 782437

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

CC ID: 782438

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

TYPE_1_OTOLITH

CC ID: 782439

Seq. Order:	32
Data Storage Type:	CHAR
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Specimen type 1 for otolith is denoted by a "Y" if taken; null if not taken.
General Data Type:	CHAR

TYPE_2_SCALE

CC ID: 782440

Seq. Order:	33
Data Storage Type:	CHAR
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Specimen type 2 for scale is denoted by a "Y" if taken; null if not taken.
General Data Type:	CHAR

TYPE_3_SEX_LENGTH_WEIGHT

CC ID: 782441

Seq. Order:	34
Data Storage Type:	CHAR
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Specimen type 3 for sex_length_weight is denoted by a "Y" if taken; null if not taken.
General Data Type:	CHAR

TYPE_4_FIN_CLIPS

CC ID: 782442

Seq. Order:	35
Data Storage Type:	CHAR
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Specimen type 4 for fin_clips is denoted by a "Y" if taken; null if not taken.
General Data Type:	CHAR

TYPE_5_VERTEBRAE

CC ID: 782443

Seq. Order:	36
Data Storage Type:	CHAR
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Specimen type 5 for vertebrae is denoted by a "Y" if taken; null if not taken.
General Data Type:	CHAR

TYPE_6_SPINES

CC ID: 782444

Seq. Order:	37
Data Storage Type:	CHAR
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Specimen type 6 for spines is denoted by a "Y" if taken; null if not taken.
General Data Type:	CHAR

TYPE_7_MATURITY_SCAN

CC ID: 782445

Seq. Order:	38
Data Storage Type:	CHAR
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Specimen type 7 for maturity scan is denoted by a "Y" if taken; null if not taken.
General Data Type:	CHAR

TYPE_8_MATURITY

CC ID: 782446

Seq. Order:	39
Data Storage Type:	CHAR
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Specimen type 8 for maturity is denoted by a "Y" if taken; null if not taken.
General Data Type:	CHAR

TYPE_9_STOMACHS

CC ID: 782447

Seq. Order:	40
Data Storage Type:	CHAR
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Specimen type 9 for stomachs is denoted by a "Y" if stomach samples were taken; null if not taken.
General Data Type:	CHAR

TYPE_10_ISOTOPES

CC ID: 782448

Seq. Order:	41
Data Storage Type:	CHAR
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Specimen type 10 for isotopes is denoted by a "Y" if taken; null if not taken.
General Data Type:	CHAR

TYPE_11_OTHER_TISSUE

CC ID: 782449

Seq. Order:	42
Data Storage Type:	CHAR
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Specimen type 11 for other tissue is denoted by a "Y" if taken; null if not taken.
General Data Type:	CHAR

TYPE_12_SNOUT

CC ID: 782450

Seq. Order:	43
Data Storage Type:	CHAR
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Specimen type 12 for snout is denoted by a "Y" if taken; null if not taken.
General Data Type:	CHAR

TYPE_13_ADIPOSE_PRESENT

CC ID: 782451

Seq. Order:	44
Data Storage Type:	CHAR
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Specimen type 13 for adipose present is denoted by a "Y" if taken; null if not taken.
General Data Type:	CHAR

T_TABLE

CC ID: 782452

Seq. Order:	45
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

CC ID: 782453

Seq. Order:	46
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

CC ID: 782454

Seq. Order:	47
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

CC ID: 782455

Seq. Order:	48
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	No
Primary Key:	No
Status:	Active
Description:	Halibut viability code.
General Data Type:	VARCHAR2

WEIGHT

CC ID: 782456

Seq. Order:	49
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

CC ID: 782457

Seq. Order:	50
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

CC ID: 782458

Seq. Order:	51
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 Item ID:	53918
GUID:	gov.noaa.nmfs.inport:53918
Metadata Record Created By:	Renold E Narita
Metadata Record Created:	2018-09-25 18:42+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

Summary

Entity Information

Child Items

Contact Information

Item Identification

Entity Information

Data Attributes

Attribute Summary

Attribute Details

ADIPOSE_PRESENT

AGE

BARCODE

SALMON_SNOUT_BARCODE

BOTTOM_DEPTH_FATHOMS

CRUISE

CDQ_CODE

FISHING_DEPTH_FATHOMS

GEAR

HAUL_JOIN

HAUL_OFFLOAD

HAUL_OFFLOAD_DATE

INJURY

LATDD_END

LATDD_START

LENGTH

LENGTH_SEQ

LONDD_END

LONDD_START

MATURITY_CODE

MATURITY_DESCRIPTION

NMFS_AREA

PERFORMANCE

PERMIT

PLANT_SEQ

PORT_JOIN

SAMPLE_SYSTEM

SEX

SPECIAL_PROJECT_CODES

SPECIES

SPECIMEN_NUMBER

TYPE_1_OTOLITH

TYPE_2_SCALE

TYPE_3_SEX_LENGTH_WEIGHT

TYPE_4_FIN_CLIPS

TYPE_5_VERTEBRAE

TYPE_6_SPINES

TYPE_7_MATURITY_SCAN

TYPE_8_MATURITY

TYPE_9_STOMACHS

TYPE_10_ISOTOPES

TYPE_11_OTHER_TISSUE

TYPE_12_SNOUT

TYPE_13_ADIPOSE_PRESENT

T_TABLE

VESSEL_CODE

VESSEL_SEQ

VIABILITY

WEIGHT

MATURITY_WEIGHT

YEAR

Catalog Details