Table: DEBRIEFED_AGE
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:10658 | Updated: August 9, 2022 | Published / External
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 |