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

CURRENT_SPCOMP

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

Summary

Abstract

This table contains records of each species which is identified within an observer sampling frame. The count of animals must be positive, zero count records are not permitted. Species composition records always come from a sample which in this presentation layer is denormalized to a summarized and extrapolated data record.

Description

This table contains records of each species which is identified within an observer sampling frame. The count of animals must be positive, zero count records are not permitted. Species composition records always come from a sample which in this presentation layer is denormalized to a summarized and extrapolated data record.

Entity Information

Entity Type
Data Table

Data Attribute / Type Description
T_TABLE
VARCHAR2 		Driving table of origin for this data collection.
PERMIT
VARCCHAR2 		Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
CRUISE
NUMBER 		Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
HAUL_SEQ
NUMBER 		Sequence generated unique identifier for a haul record from ATL_Haul
VESSEL
VARCHAR2 		VessPlnt code from old NORPAC system. This code may ultimately be retired, but is essential to the transitional ETL from Atlas to Inseason and Domestic.
HAUL_DATE
date 		Date of haul retrieval as recorded in NORPAC.ATL_HAUL
HAUL
NUMBER 		Number which is entered by the observer identifying a unique haul within a trip.
SEX
VARCHAR1 		Sex if so identified.

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: CURRENT_SPCOMP
Short Name: CURRENT_SPCOMP
Status: In Work
Abstract:

This table contains records of each species which is identified within an observer sampling frame. The count of animals must be positive, zero count records are not permitted. Species composition records always come from a sample which in this presentation layer is denormalized to a summarized and extrapolated data record.
Purpose:

This table contains records of each species which is identified within an observer sampling frame. The count of animals must be positive, zero count records are not permitted. Species composition records always come from a sample which in this presentation layer is denormalized to a summarized and extrapolated data record.

Keywords

Temporal Keywords

Thesaurus Keyword
UNCONTROLLED
None 2008 AND FORWARD

Spatial Keywords

Thesaurus Keyword
UNCONTROLLED
None BS, AI, BSAI, GOA

Stratum Keywords

Thesaurus Keyword
UNCONTROLLED
None OBSERVER, CURRENT DATA, FISHERY STATISTICS

Physical Location

Organization: Fisheries Monitoring and Analysis
City: Seattle
State/Province: WA
Country: USA
Location Description:

Alaska Fisheries Science Center

Entity Information

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

This table contains records of each species which is identified within an observer sampling frame. The count of animals must be positive, zero count records are not permitted. Species composition records always come from a sample which in this presentation layer is denormalized to a summarized and extrapolated data record.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 T_TABLE VARCHAR2 Driving table of origin for this data collection.
100
 PERMIT VARCCHAR2 Unique Code identifying a vessel or Processor - inherited from the NORPAC data set and created by the RAM division in Juneau
100
 CRUISE NUMBER Sequence generated by Norpac and supplied to the observer as an unique identifier for an observer cruise record.
100
 HAUL_SEQ NUMBER Sequence generated unique identifier for a haul record from ATL_Haul
100
 VESSEL VARCHAR2 VessPlnt code from old NORPAC system. This code may ultimately be retired, but is essential to the transitional ETL from Atlas to Inseason and Domestic.
100
 HAUL_DATE date Date of haul retrieval as recorded in NORPAC.ATL_HAUL
100
 HAUL NUMBER Number which is entered by the observer identifying a unique haul within a trip.
100
 SEX VARCHAR1 Sex if so identified.

Attribute Details

T_TABLE

CC ID: 241819
Seq. Order: 10
Data Storage Type: VARCHAR2
Max Length: 8
Required: No
Primary Key: No
Status: Active
Description:

Driving table of origin for this data collection.
General Data Type: CHARACTER

PERMIT

CC ID: 241820
Seq. Order: 15
Data Storage Type: VARCCHAR2
Max Length: 6
Required: Yes
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: CHARACTER

CRUISE

CC ID: 241821
Seq. Order: 20
Data Storage Type: NUMBER
Max Length: 9
Required: Yes
Primary Key: No
Precision: 9
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: INTEGER

HAUL_SEQ

CC ID: 241822
Seq. Order: 25
Data Storage Type: NUMBER
Max Length: 9
Required: Yes
Primary Key: No
Precision: 9
Scale: 0
Status: Active
Description:

Sequence generated unique identifier for a haul record from ATL_Haul
General Data Type: integer

VESSEL

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

VessPlnt code from old NORPAC system. This code may ultimately be retired, but is essential to the transitional ETL from Atlas to Inseason and Domestic.
General Data Type: CHARACTER

HAUL_DATE

CC ID: 241831
Seq. Order: 35
Data Storage Type: date
Max Length: 12
Required: No
Primary Key: No
Status: Active
Description:

Date of haul retrieval as recorded in NORPAC.ATL_HAUL
General Data Type: DATE

HAUL

CC ID: 241832
Seq. Order: 40
Data Storage Type: NUMBER
Max Length: 8
Required: No
Primary Key: No
Precision: 8
Scale: 0
Status: Active
Description:

Number which is entered by the observer identifying a unique haul within a trip.

General Data Type: INTEGER

SEX

CC ID: 241833
Seq. Order: 45
Data Storage Type: VARCHAR1
Max Length: 1
Required: No
Primary Key: No
Status: Active
Description:

Sex if so identified.
Allowed Values: Y, N, U

Catalog Details

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