View: DEBRIEFED_AGE_SQUASH_SP_TYPE

Alaska Fisheries Science Center
Entity (ENT) | ID: 53918 | Published / External
Created: 2018-09-25 | Last Modified: 2022-08-09

Parent: AFSC/FMA/North Pacific Observer Debriefed Data Presentation Layer (OBSINT)
Data Set (DS) | ID: 10657

ID: 53918
Entity (ENT)

* Discovery
• First Pass
» Metadata Rubric

Item Identification

* » Title	View: DEBRIEFED_AGE_SQUASH_SP_TYPE
Short Name	DEBRIEFED_AGE_SQUASH_SP_TYPE
* Status	Completed
Creation Date
Revision Date
• Publication Date
* » Abstract	snapshot table for snapshot OBSINT.DEBRIEFED_AGE_SQUASH_SP_TYPE
* Purpose
Notes
Other Citation Details
• Supplemental Information
DOI (Digital Object Identifier)
DOI Registration Authority
DOI Issue Date

Keywords

Theme Keywords

Thesaurus	Keyword

Temporal Keywords

Thesaurus	Keyword

* Spatial Keywords

Thesaurus	Keyword

Stratum Keywords

Thesaurus	Keyword

Instrument Keywords

Thesaurus	Keyword

Platform Keywords

Thesaurus	Keyword

Physical Location

• » Organization
• » City
• » State/Province
• Country
• » Location Description

Entity Information

Entity Type	Data View
Active Version?	Y
Alias
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.
Change Summary

Data Attributes

Attribute Summary

Score	Req'd?	PKey?	» Name	Data Storage Type	Description
100	No	No	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	No	No	AGE	NUMBER	Age of the animal (Specimen) in years. Populated by Age and Growth Staff without system validation.
100	No	No	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	No	No	SALMON_SNOUT_BARCODE	NUMBER	Salmon snout barcode. Barcode for salmon snout only used by Hake fishery observers.
100	No	No	BOTTOM_DEPTH_FATHOMS	NUMBER	Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records.
100	No	No	CRUISE	NUMBER	Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
100	No	No	CDQ_CODE	VARCHAR2	Unique AlphaNumeric code representing a CDQ or research group.
100	No	No	FISHING_DEPTH_FATHOMS	NUMBER	Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records.
100	No	No	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	No	No	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	No	No	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	No	No	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	No	No	INJURY	VARCHAR2	Halibut injury code.
100	No	No	LATDD_END	NUMBER	Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records.
100	No	No	LATDD_START	NUMBER	Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records.
100	No	No	LENGTH	NUMBER	Inherited from atl_length or observer entered for Domestic Table age records.
100	No	No	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	No	No	LONDD_END	NUMBER	Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records.
100	No	No	LONDD_START	NUMBER	Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records.
100	No	No	MATURITY_CODE	VARCHAR2	Sexual maturity code.
100	No	No	MATURITY_DESCRIPTION	VARCHAR2	Sexual maturity code description. This attribute is null for Domestic Table age records.
100	No	No	NMFS_AREA	NUMBER	Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records.
100	No	No	PERFORMANCE	NUMBER	Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records.
100	No	No	PERMIT	VARCHAR2	Unique Code identifying a Vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau.
100	No	No	PLANT_SEQ	NUMBER	Sequence generated unique identifier for a processing plant.
100	No	No	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	No	No	SAMPLE_SYSTEM	NUMBER	Code for sampling system employed by the observer.
100	No	No	SEX	VARCHAR2	Sex either inherited from length or recorded in age/atl_fish_inv_specimen if different.
100	No	No	SPECIAL_PROJECT_CODES	VARCHAR2	No longer used.
100	No	No	SPECIES	NUMBER	Species either inherited from length or recorded in age/atl_fish_inv_specimen if different.
100	No	No	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	No	No	TYPE_1_OTOLITH	CHAR	Specimen type 1 for otolith is denoted by a "Y" if taken; null if not taken.
100	No	No	TYPE_2_SCALE	CHAR	Specimen type 2 for scale is denoted by a "Y" if taken; null if not taken.
100	No	No	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	No	No	TYPE_4_FIN_CLIPS	CHAR	Specimen type 4 for fin_clips is denoted by a "Y" if taken; null if not taken.
100	No	No	TYPE_5_VERTEBRAE	CHAR	Specimen type 5 for vertebrae is denoted by a "Y" if taken; null if not taken.
100	No	No	TYPE_6_SPINES	CHAR	Specimen type 6 for spines is denoted by a "Y" if taken; null if not taken.
100	No	No	TYPE_7_MATURITY_SCAN	CHAR	Specimen type 7 for maturity scan is denoted by a "Y" if taken; null if not taken.
100	No	No	TYPE_8_MATURITY	CHAR	Specimen type 8 for maturity is denoted by a "Y" if taken; null if not taken.
100	No	No	TYPE_9_STOMACHS	CHAR	Specimen type 9 for stomachs is denoted by a "Y" if stomach samples were taken; null if not taken.
100	No	No	TYPE_10_ISOTOPES	CHAR	Specimen type 10 for isotopes is denoted by a "Y" if taken; null if not taken.
100	No	No	TYPE_11_OTHER_TISSUE	CHAR	Specimen type 11 for other tissue is denoted by a "Y" if taken; null if not taken.
100	No	No	TYPE_12_SNOUT	CHAR	Specimen type 12 for snout is denoted by a "Y" if taken; null if not taken.
100	No	No	TYPE_13_ADIPOSE_PRESENT	CHAR	Specimen type 13 for adipose present is denoted by a "Y" if taken; null if not taken.
100	No	No	T_TABLE	VARCHAR2	Identifier of Source Table.
100	No	No	VESSEL_CODE	VARCHAR2	Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel.
100	No	No	VESSEL_SEQ	NUMBER	Sequence generated unique identifier for a vessel.
100	No	No	VIABILITY	VARCHAR2	Halibut viability code.
100	No	No	WEIGHT	NUMBER	Weight in kg of the specimen.
100	No	No	MATURITY_WEIGHT	NUMBER	Weight of the animal with sex organs removed. No longer used.
100	No	No	YEAR	NUMBER	Year extracted from haul retrieval date or offload deleivery end date.

Attribute Details

Attribute Name	ADIPOSE_PRESENT
Seq. Order	1
Data Storage Type	VARCHAR2
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
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
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	AGE
Seq. Order	2
Data Storage Type	NUMBER
Max Length	22
Min Length
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
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	BARCODE
Seq. Order	3
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision
Scale
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
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	SALMON_SNOUT_BARCODE
Seq. Order	4
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Salmon snout barcode. Barcode for salmon snout only used by Hake fishery observers.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	BOTTOM_DEPTH_FATHOMS
Seq. Order	5
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision
Scale
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
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	CRUISE
Seq. Order	6
Data Storage Type	NUMBER
Max Length	22
Min Length
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
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	CDQ_CODE
Seq. Order	7
Data Storage Type	VARCHAR2
Max Length	3
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Unique AlphaNumeric code representing a CDQ or research group.
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	FISHING_DEPTH_FATHOMS
Seq. Order	8
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision
Scale
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
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	GEAR
Seq. Order	9
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision
Scale
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
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	HAUL_JOIN
Seq. Order	10
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision
Scale
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
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	HAUL_OFFLOAD
Seq. Order	11
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision
Scale
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
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	HAUL_OFFLOAD_DATE
Seq. Order	12
Data Storage Type	DATE
Max Length	7
Min Length
Required	No
Primary Key	No
Precision
Scale
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
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	INJURY
Seq. Order	13
Data Storage Type	VARCHAR2
Max Length	40
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Halibut injury code.
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	LATDD_END
Seq. Order	14
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision
Scale
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
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	LATDD_START
Seq. Order	15
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision
Scale
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
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	LENGTH
Seq. Order	16
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Inherited from atl_length or observer entered for Domestic Table age records.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	LENGTH_SEQ
Seq. Order	17
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision
Scale
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
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	LONDD_END
Seq. Order	18
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision
Scale
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
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	LONDD_START
Seq. Order	19
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision
Scale
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
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	MATURITY_CODE
Seq. Order	20
Data Storage Type	VARCHAR2
Max Length	2
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Sexual maturity code.
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	MATURITY_DESCRIPTION
Seq. Order	21
Data Storage Type	VARCHAR2
Max Length	60
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Sexual maturity code description. This attribute is null for Domestic Table age records.
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	NMFS_AREA
Seq. Order	22
Data Storage Type	NUMBER
Max Length	22
Min Length
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
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	PERFORMANCE
Seq. Order	23
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision
Scale
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
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	PERMIT
Seq. Order	24
Data Storage Type	VARCHAR2
Max Length	6
Min Length
Required	No
Primary Key	No
Precision
Scale
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
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	PLANT_SEQ
Seq. Order	25
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision	9
Scale	0
Status	Active
Description	Sequence generated unique identifier for a processing plant.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	PORT_JOIN
Seq. Order	26
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision
Scale
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
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	SAMPLE_SYSTEM
Seq. Order	27
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Code for sampling system employed by the observer.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	SEX
Seq. Order	28
Data Storage Type	VARCHAR2
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Sex either inherited from length or recorded in age/atl_fish_inv_specimen if different.
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	SPECIAL_PROJECT_CODES
Seq. Order	29
Data Storage Type	VARCHAR2
Max Length	4000
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	No longer used.
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	SPECIES
Seq. Order	30
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Species either inherited from length or recorded in age/atl_fish_inv_specimen if different.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	SPECIMEN_NUMBER
Seq. Order	31
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision
Scale
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
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	TYPE_1_OTOLITH
Seq. Order	32
Data Storage Type	CHAR
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Specimen type 1 for otolith is denoted by a "Y" if taken; null if not taken.
General Data Type	CHAR
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	TYPE_2_SCALE
Seq. Order	33
Data Storage Type	CHAR
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Specimen type 2 for scale is denoted by a "Y" if taken; null if not taken.
General Data Type	CHAR
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	TYPE_3_SEX_LENGTH_WEIGHT
Seq. Order	34
Data Storage Type	CHAR
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
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
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	TYPE_4_FIN_CLIPS
Seq. Order	35
Data Storage Type	CHAR
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Specimen type 4 for fin_clips is denoted by a "Y" if taken; null if not taken.
General Data Type	CHAR
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	TYPE_5_VERTEBRAE
Seq. Order	36
Data Storage Type	CHAR
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Specimen type 5 for vertebrae is denoted by a "Y" if taken; null if not taken.
General Data Type	CHAR
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	TYPE_6_SPINES
Seq. Order	37
Data Storage Type	CHAR
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Specimen type 6 for spines is denoted by a "Y" if taken; null if not taken.
General Data Type	CHAR
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	TYPE_7_MATURITY_SCAN
Seq. Order	38
Data Storage Type	CHAR
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Specimen type 7 for maturity scan is denoted by a "Y" if taken; null if not taken.
General Data Type	CHAR
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	TYPE_8_MATURITY
Seq. Order	39
Data Storage Type	CHAR
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Specimen type 8 for maturity is denoted by a "Y" if taken; null if not taken.
General Data Type	CHAR
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	TYPE_9_STOMACHS
Seq. Order	40
Data Storage Type	CHAR
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
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
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	TYPE_10_ISOTOPES
Seq. Order	41
Data Storage Type	CHAR
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Specimen type 10 for isotopes is denoted by a "Y" if taken; null if not taken.
General Data Type	CHAR
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	TYPE_11_OTHER_TISSUE
Seq. Order	42
Data Storage Type	CHAR
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Specimen type 11 for other tissue is denoted by a "Y" if taken; null if not taken.
General Data Type	CHAR
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	TYPE_12_SNOUT
Seq. Order	43
Data Storage Type	CHAR
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Specimen type 12 for snout is denoted by a "Y" if taken; null if not taken.
General Data Type	CHAR
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	TYPE_13_ADIPOSE_PRESENT
Seq. Order	44
Data Storage Type	CHAR
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Specimen type 13 for adipose present is denoted by a "Y" if taken; null if not taken.
General Data Type	CHAR
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	T_TABLE
Seq. Order	45
Data Storage Type	VARCHAR2
Max Length	50
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Identifier of Source Table.
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	VESSEL_CODE
Seq. Order	46
Data Storage Type	VARCHAR2
Max Length	7
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel.
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	VESSEL_SEQ
Seq. Order	47
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision	9
Scale	0
Status	Active
Description	Sequence generated unique identifier for a vessel.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	VIABILITY
Seq. Order	48
Data Storage Type	VARCHAR2
Max Length	1
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Halibut viability code.
General Data Type	VARCHAR2
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	WEIGHT
Seq. Order	49
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Weight in kg of the specimen.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	MATURITY_WEIGHT
Seq. Order	50
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Weight of the animal with sex organs removed. No longer used.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name	YEAR
Seq. Order	51
Data Storage Type	NUMBER
Max Length	22
Min Length
Required	No
Primary Key	No
Precision
Scale
Status	Active
Description	Year extracted from haul retrieval date or offload deleivery end date.
General Data Type	NUMBER
Unit of Measure
Case Restriction
Display Example
Format Mask
Null Value
Null Value Meaning
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Attribute Name
Seq. Order
Data Storage Type
Max Length
Precision
Scale
Required
Primary Key
Status
Description
General Data Type
Case Restriction
Format Mask
Null Value
Null Value Meaning
Min Length
Unit of Measure
Display Example
Allowed Values
Default Value
Foreign Key Relations
Derivation
Validation Rules

Support Roles

» At least one Distributor Org, one Metadata Contact, one Point of Contact, and one Data Steward should be listed.

* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

* » Support Role
* » Date Effective From
Date Effective To
* » Contact
* Contact Instructions

Extents

Currentness Reference

Extent Group 1

Extent Description

Extent Group 1 / Geographic Area

* » W° Bound
* » E° Bound
* » N° Bound
* » S° Bound
* » Description

Extent Group 1 / Vertical Extent

EPSG Code
Vertical Minimum
Vertical Maximum

Extent Group 1 / Time Frame

* » Time Frame Type
* » Start
End
Alternate Start as of Info
Alternate End as of Info
Description

Access Information

* » Security Class
* Security Classification System
Security Handling Description
• Data Access Policy
» Data Access Procedure
• » Data Access Constraints
• Data Use Constraints
Metadata Access Constraints
Metadata Use Constraints

Distribution Information

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Start Date
End Date
» Download URL
Distributor
File Name
Description
File Date/Time
File Type
FGDC Content Type
File Size
Application Version
Compression
Review Status

Activity Log

Activity Time
Activity Type
Responsible Party
Description

Activity Time
Activity Type
Responsible Party
Description

Activity Time
Activity Type
Responsible Party
Description

Issues

Issue Date
Author
Issue

Issue Date
Author
Issue

Issue Date
Author
Issue

FAQs

Date
Author
Question
Answer

Child Items

Rubric scores updated every 15m

Score	Type	Title

Related Items

Item Type	Relationship Type	Title

Catalog Details

Catalog Item ID	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 Workflow State	Published / External
Metadata Last Review Date	2018-09-25
Metadata Review Frequency	1 Year
Metadata Next Review Date	2019-09-25

Tags