Search Help Show/Hide Menu
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

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 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. 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.

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_SP_TYPE
Short Name: DEBRIEFED_AGE_SQUASH_SP_TYPE
Status: Completed
Abstract:

snapshot table for snapshot OBSINT.DEBRIEFED_AGE_SQUASH_SP_TYPE

Entity Information

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.

Data Attributes

Attribute Summary

Rubric Score Primary Key? 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.

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 Details

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