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

Summary

Abstract

snapshot table for snapshot OBSINT.DEBRIEFED_AGE_SQUASH_CONCAT

Description

snapshot table for snapshot OBSINT.DEBRIEFED_AGE_SQUASH_CONCAT

Debriefed_age_squash_concat is a materialized view created from the data in the debriefed_age table in a summary format presenting all specimen_types sampled for a single distinct individual animal are concatenated into one column. Also there is another column for all the corresponding concatenated specimen_type_descriptions. 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. See salmon_snout_barcode column for barcodes of salmon snouts (used by hake fishery observers only).
SALMON_SNOUT_BARCODE
NUMBER
Barcode for salmon snout; used by hake fishery observers only.
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.
SPECIMEN_TYPES
VARCHAR2
All Specimen_type_codes for an individual specimen concatenated in this attribute.
SPECIMEN_TYPE_DESCRIPTIONS
VARCHAR2
All specimen_type_descriptions for an individual specimen concatenated in this attribute. This attribute is null for Domestic Table age records.
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_CONCAT
Short Name: DEBRIEFED_AGE_SQUASH_CONCAT
Status: Completed
Abstract:

snapshot table for snapshot OBSINT.DEBRIEFED_AGE_SQUASH_CONCAT

Entity Information

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

snapshot table for snapshot OBSINT.DEBRIEFED_AGE_SQUASH_CONCAT

Debriefed_age_squash_concat is a materialized view created from the data in the debriefed_age table in a summary format presenting all specimen_types sampled for a single distinct individual animal are concatenated into one column. Also there is another column for all the corresponding concatenated specimen_type_descriptions. 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. See salmon_snout_barcode column for barcodes of salmon snouts (used by hake fishery observers only).
100
SALMON_SNOUT_BARCODE NUMBER Barcode for salmon snout; used by hake fishery observers only.
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
SPECIMEN_TYPES VARCHAR2 All Specimen_type_codes for an individual specimen concatenated in this attribute.
100
SPECIMEN_TYPE_DESCRIPTIONS VARCHAR2 All specimen_type_descriptions for an individual specimen concatenated in this attribute. This attribute is null for Domestic Table age records.
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: 782368
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: 782369
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: 782370
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. See salmon_snout_barcode column for barcodes of salmon snouts (used by hake fishery observers only).

General Data Type: NUMBER

SALMON_SNOUT_BARCODE

CC ID: 782371
Seq. Order: 4
Data Storage Type: NUMBER
Max Length: 22
Required: No
Primary Key: No
Status: Active
Description:

Barcode for salmon snout; used by hake fishery observers only.

General Data Type: NUMBER

BOTTOM_DEPTH_FATHOMS

CC ID: 782372
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: 782373
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: 782374
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: 782375
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: 782376
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: 782377
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: 782378
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: 782379
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: 782380
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: 782381
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: 782382
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: 782383
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: 782384
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: 782385
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: 782386
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: 782387
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: 782388
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: 782389
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: 782390
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: 782391
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: 782392
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: 782393
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: 782394
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: 782395
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: 782396
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: 782397
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: 782398
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

SPECIMEN_TYPES

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

All Specimen_type_codes for an individual specimen concatenated in this attribute.

General Data Type: VARCHAR2

SPECIMEN_TYPE_DESCRIPTIONS

CC ID: 782400
Seq. Order: 33
Data Storage Type: VARCHAR2
Max Length: 4000
Required: No
Primary Key: No
Status: Active
Description:

All specimen_type_descriptions for an individual specimen concatenated in this attribute. This attribute is null for Domestic Table age records.

General Data Type: VARCHAR2

T_TABLE

CC ID: 782401
Seq. Order: 34
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: 782402
Seq. Order: 35
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: 782403
Seq. Order: 36
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: 782404
Seq. Order: 37
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: 782405
Seq. Order: 38
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: 782406
Seq. Order: 39
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: 782407
Seq. Order: 40
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: 53917
GUID: gov.noaa.nmfs.inport:53917
Metadata Record Created By: Renold E Narita
Metadata Record Created: 2018-09-25 18:41+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