Search Help Show/Hide Menu
Metadata Rubric
100%
6 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Debriefed Observer Data Interface > AFSC/FMA/North Pacific Observer Debriefed Data... >

Table: DEBRIEFED_AGE

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:10658  |  Updated: August 9, 2022  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Abstract

The debriefed age table was created as a successor to the debriefed age materialized view. The 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.

Description

The debriefed age table was created as a successor to the debriefed age materialized view. The 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 Table

Data Attribute / Type Description
T_TABLE
VARCHAR2 		Identifier of Source Table.
CRUISE
NUMBER 		Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
PERMIT
VARCHAR2 		Unique Code identifying a Vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau.
VESSEL
VARCHAR2 		Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel.
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.
NMFS_AREA
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.
LONDD_START
NUMBER 		Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records.
LATDD_END
NUMBER 		Inherited from parent haul when appropriate NULL for offloads. 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.
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.
PERFORMANCE
NUMBER 		Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records.
FISHING_DEPTH
NUMBER 		Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records.
BOTTOM_DEPTH
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.
WEIGHT
NUMBER 		Weight in kg of the specimen.
SPECIES
NUMBER 		Species either inherited from length or recorded in age/atl_fish_inv_specimen if different.
SEX
VARCHAR2 		Sex either inherited from length or recorded in age/atl_fish_inv_specimen if different.
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.
HAUL_OFFLOAD
NUMBER 		Number which is entered by the observer identifying a unique haul or offload depending on which was the ultimate data source.
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.
AGE
NUMBER 		Age of the animal (Specimen) in years. Populated by Age and Growth Staff without system validation.
MATURITY_CODE
VARCHAR2 		Sexual maturity code.
MATURITY_DESCRIPTION
VARCHAR2 		Sexual maturity code description. This attribute is null for Domestic Table age records.
SPECIMEN_TYPE
NUMBER 		Specimen type code.
SPECIMEN_TYPE_DESCRIPTION
VARCHAR2 		Speciment type code description. This attribute is null for Domestic Table age records.
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.
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.
YEAR
NUMBER 		Year extracted from haul retrieval date or offload deleivery end date.
VIABILITY
VARCHAR2 		Halibut viability code.
INJURY
VARCHAR2 		Halibut injury code.
SPECIAL_PROJECT_CODE
VARCHAR2 		No longer used.
SAMPLE_SYSTEM
NUMBER 		Code for sampling system employed by the observer.
BARCODE
NUMBER 		Whenever a barcode is printed on a vial (otolith) or bag (tag and bag) this attribute contains the value.

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: Table: DEBRIEFED_AGE
Short Name: DEBRIEFED_AGE
Status: Completed
Abstract:

The debriefed age table was created as a successor to the debriefed age materialized view. The 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.
Notes:

Loaded by batch 2535, 11-09-2010 10:55

Entity Information

Entity Type: Data Table
Active Version?: Yes
Schema Name: OBSINT
Description:

The debriefed age table was created as a successor to the debriefed age materialized view. The 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
 T_TABLE VARCHAR2 Identifier of Source Table.
100
 CRUISE NUMBER Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
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
 VESSEL VARCHAR2 Alpha Numeric code from ATL_Lov_Vessel table, which identifies the vessel.
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
 NMFS_AREA 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
 LONDD_START NUMBER Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records.
100
 LATDD_END NUMBER Inherited from parent haul when appropriate NULL for offloads. 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
 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
 PERFORMANCE NUMBER Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records.
100
 FISHING_DEPTH NUMBER Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records.
100
 BOTTOM_DEPTH 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
 WEIGHT NUMBER Weight in kg of the specimen.
100
 SPECIES NUMBER Species either inherited from length or recorded in age/atl_fish_inv_specimen if different.
100
 SEX VARCHAR2 Sex either inherited from length or recorded in age/atl_fish_inv_specimen if different.
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
 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
 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
 AGE NUMBER Age of the animal (Specimen) in years. Populated by Age and Growth Staff without system validation.
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
 SPECIMEN_TYPE NUMBER Specimen type code.
100
 SPECIMEN_TYPE_DESCRIPTION VARCHAR2 Speciment type code description. This attribute is null for Domestic Table age records.
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
 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
 YEAR NUMBER Year extracted from haul retrieval date or offload deleivery end date.
100
 VIABILITY VARCHAR2 Halibut viability code.
100
 INJURY VARCHAR2 Halibut injury code.
100
 SPECIAL_PROJECT_CODE VARCHAR2 No longer used.
100
 SAMPLE_SYSTEM NUMBER Code for sampling system employed by the observer.
100
 BARCODE NUMBER Whenever a barcode is printed on a vial (otolith) or bag (tag and bag) this attribute contains the value.

Attribute Details

T_TABLE

CC ID: 42589
Seq. Order: 1
Data Storage Type: VARCHAR2
Max Length: 20
Required: No
Primary Key: No
Status: Active
Description:

Identifier of Source Table.
General Data Type: VARCHAR2

CRUISE

CC ID: 42590
Seq. Order: 2
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

PERMIT

CC ID: 42591
Seq. Order: 3
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

VESSEL

CC ID: 42592
Seq. Order: 4
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

GEAR

CC ID: 42593
Seq. Order: 5
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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

NMFS_AREA

CC ID: 42594
Seq. Order: 6
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

LATDD_START

CC ID: 42595
Seq. Order: 7
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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: 42596
Seq. Order: 8
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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_END

CC ID: 42597
Seq. Order: 9
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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_END

CC ID: 42598
Seq. Order: 10
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Inherited from parent haul when appropriate NULL for offloads. This attribute is null for Domestic Table age records.
General Data Type: NUMBER

LENGTH_SEQ

CC ID: 42599
Seq. Order: 11
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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

PERFORMANCE

CC ID: 42600
Seq. Order: 12
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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

FISHING_DEPTH

CC ID: 42601
Seq. Order: 13
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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

BOTTOM_DEPTH

CC ID: 42602
Seq. Order: 14
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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: 42603
Seq. Order: 15
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Inherited from atl_length or observer entered for Domestic Table age records.
General Data Type: NUMBER

WEIGHT

CC ID: 42604
Seq. Order: 16
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Weight in kg of the specimen.
General Data Type: NUMBER

SPECIES

CC ID: 42605
Seq. Order: 17
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Species either inherited from length or recorded in age/atl_fish_inv_specimen if different.
General Data Type: NUMBER

SEX

CC ID: 42606
Seq. Order: 18
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

HAUL_OFFLOAD_DATE

CC ID: 42607
Seq. Order: 19
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

HAUL_OFFLOAD

CC ID: 42608
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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

SPECIMEN_NUMBER

CC ID: 42609
Seq. Order: 21
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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

AGE

CC ID: 42610
Seq. Order: 22
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

MATURITY_CODE

CC ID: 42611
Seq. Order: 23
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: 42612
Seq. Order: 24
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

SPECIMEN_TYPE

CC ID: 42613
Seq. Order: 25
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Specimen type code.
General Data Type: NUMBER

SPECIMEN_TYPE_DESCRIPTION

CC ID: 42614
Seq. Order: 26
Data Storage Type: VARCHAR2
Max Length: 25
Required: No
Primary Key: No
Status: Active
Description:

Speciment type code description. This attribute is null for Domestic Table age records.
General Data Type: VARCHAR2

HAUL_JOIN

CC ID: 42615
Seq. Order: 27
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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

PORT_JOIN

CC ID: 42616
Seq. Order: 28
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
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

YEAR

CC ID: 42617
Seq. Order: 29
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Year extracted from haul retrieval date or offload deleivery end date.
General Data Type: NUMBER

VIABILITY

CC ID: 42618
Seq. Order: 30
Data Storage Type: VARCHAR2
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Halibut viability code.
General Data Type: VARCHAR2

INJURY

CC ID: 42619
Seq. Order: 31
Data Storage Type: VARCHAR2
Max Length: 40
Required: No
Primary Key: No
Status: Active
Description:

Halibut injury code.
General Data Type: VARCHAR2

SPECIAL_PROJECT_CODE

CC ID: 42620
Seq. Order: 32
Data Storage Type: VARCHAR2
Max Length: 3
Required: No
Primary Key: No
Status: Active
Description:

No longer used.
General Data Type: VARCHAR2

SAMPLE_SYSTEM

CC ID: 42621
Seq. Order: 33
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Precision: 38
Status: Active
Description:

Code for sampling system employed by the observer.
General Data Type: NUMBER

BARCODE

CC ID: 179977
Seq. Order: 34
Data Storage Type: NUMBER
Max Length: 9
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.
General Data Type: INTEGER
Allowed Values: 0 - 99999999

Catalog Details

Catalog Item ID: 10658
GUID: gov.noaa.nmfs.inport:10658
Metadata Record Created By: Doug Turnbull
Metadata Record Created: 2010-11-09 10:55+0000
Metadata Record Last Modified By: SysAdmin InPortAdmin
Metadata Record Last Modified: 2022-08-09 17:11+0000
Metadata Record Published: 2016-05-18
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Last Review Date: 2016-05-18
Metadata Review Frequency: 1 Year
Metadata Next Review Date: 2017-05-18