Metadata Rubric

100%

6 / 6

Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > Salmon Genetics From Observer Specimens > AFSC/FMA/Salmon Genetics From Observer Specimen... >

ABL_GEN_SALMON_BYCATCH

Entity (ENT) | Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:27651 | Updated: August 9, 2022 | Published / External

Item Identification

Title:	ABL_GEN_SALMON_BYCATCH
Short Name:	Salmon Genetics
Status:	In Work
Abstract:	Genetic data of salmon bycatch samples used for mixed-stock analyses to determine geographic region of origin.

Keywords

Temporal Keywords

Thesaurus	Keyword
UNCONTROLLED
None	Annual Assessment

Thesaurus

Keyword

UNCONTROLLED

None

Annual Assessment

Spatial Keywords

Thesaurus	Keyword
UNCONTROLLED
None	Region of origin

Thesaurus

Keyword

UNCONTROLLED

None

Region of origin

Stratum Keywords

Thesaurus	Keyword
UNCONTROLLED
None	Salmon

Thesaurus

Keyword

UNCONTROLLED

None

Salmon

Physical Location

Organization:	Alaska Fisheries Science Center
City:	Seattle
State/Province:	WA
Country:	USA
Location Description:	The data is compiled and analysis done at TSMRI. It is ultimately archived with observer derived fishery statistics at the AFSC in Seattle.

Entity Information

Entity Type:	Data Table
Active Version?:	Yes
Alias:	Salmon Genetics
Schema Name:	obsint
Description:	These data are the output of genetics analysis of tissues collected by observers at sea.

Data Attributes

Attribute Summary

	Name	Type	Description
100	SAL_BYCATCH_SEQ	Number	Oracle Generated Unique Identifier of a record
100	CRUISE	Number	Observer Cruise Inherited from debriefed_age
100	PERMIT	VARCHAR2	Vessel federal fisheries permit Inherited from debriefed_age
100	SPECIMEN_NUMBER	NUMBER	Inherited from debriefed_age, a specimen number is unique within a cruise, permit, length and specimen type. It is a user defined identifier.
100	HAUL_OFFLOAD	NUMBER	Haul or offload from which the genetics specimen was collected.
100	SPECIMEN_TYPE	NUMBER	Specimen type code. This references the definition about what is being measured or commented.
100	SEX	VARCHAR2	Sex either inherited from length or recorded in age/atl_fish_inv_specimen if different.
100	SPECIES	NUMBER	Species either inherited from length or recorded in age/atl_fish_inv_specimen if different.
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	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	SPECIMEN_SEQ	NUMBER	Oracle Generated Unique Identifier of a specimen record from the Observer database entered into record by a before insert record trigger on the table.
100	SAMPLE_ID	VARCHAR2	Intelligent key assigned by staff uniquely identifying this record.
100	YEAR	NUMBER	Year that the genetic sample was collected and analysis done.
100	OKI100_1	NUMBER	First allele at genetic marker OKI100
100	OKI100_2	NUMBER	Second allele at genetic marker OKI100
100	OMM1070_1	NUMBER	First allele at genetic marker OMM1070
100	OMM1070_2	NUMBER	Second allele at genetic marker OMM 1070
100	OMY1011_1	NUMBER	First allele at genetic marker OMY1011
100	OMY1011_2	NUMBER	Second allele at genetic marker OMY1011
100	ONE101_1	NUMBER	First allele at genetic marker ONE101
100	ONE101_2	NUMBER	Second allele at genetic marker ONE102
100	ONE102_1	NUMBER	First allele at genetic marker ONE102
100	ONE102_2	NUMBER	Second allele at genetic marker ONE102
100	ONE104_1	NUMBER	First allele at genetic marker ONE104
100	ONE104_2	NUMBER	Second allele at genetic marker ONE104
100	ONE114_1	NUMBER	First allele at genetic marker ONE114
100	ONE114_2	NUMBER	Second allele at genetic marker ONE114
100	OTS103_1	NUMBER	First allele at genetic marker OTS103
100	OTS103_2	NUMBER	Second allele at genetic marker OTS103
100	OTS3_1	NUMBER	First allele at genetic marker OTS3
100	OTS3_2	NUMBER	Second allele at genetic marker OTS3
100	OTSG68_1	NUMBER	First allele at genetic marker OTSG68
100	OTSG68_2	NUMBER	Second allele at genetic marker OTSG68
100	SSA419_1	NUMBER	First allele at genetic marker SSA419
100	SSA419_2	NUMBER	Second allele at genetic marker SSA 419
100	BINARY	VARCHAR2	Binary format of alleles at each genetic marker.

Name

Type

Description

100

SAL_BYCATCH_SEQ

Number

Oracle Generated Unique Identifier of a record

100

CRUISE

Number

Observer Cruise Inherited from debriefed_age

100

PERMIT

VARCHAR2

Vessel federal fisheries permit Inherited from debriefed_age

100

SPECIMEN_NUMBER

NUMBER

Inherited from debriefed_age, a specimen number is unique within a cruise, permit, length and specimen type. It is a user defined identifier.

100

HAUL_OFFLOAD

NUMBER

Haul or offload from which the genetics specimen was collected.

100

SPECIMEN_TYPE

NUMBER

Specimen type code. This references the definition about what is being measured or commented.

100

SEX

VARCHAR2

Sex either inherited from length or recorded in age/atl_fish_inv_specimen if different.

100

SPECIES

NUMBER

Species either inherited from length or recorded in age/atl_fish_inv_specimen if different.

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

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

SPECIMEN_SEQ

NUMBER

Oracle Generated Unique Identifier of a specimen record from the Observer database entered into record by a before insert record trigger on the table.

100

SAMPLE_ID

VARCHAR2

Intelligent key assigned by staff uniquely identifying this record.

100

YEAR

NUMBER

Year that the genetic sample was collected and analysis done.

100

OKI100_1

NUMBER

First allele at genetic marker OKI100

100

OKI100_2

NUMBER

Second allele at genetic marker OKI100

100

OMM1070_1

NUMBER

First allele at genetic marker OMM1070

100

OMM1070_2

NUMBER

Second allele at genetic marker OMM 1070

100

OMY1011_1

NUMBER

First allele at genetic marker OMY1011

100

OMY1011_2

NUMBER

Second allele at genetic marker OMY1011

100

ONE101_1

NUMBER

First allele at genetic marker ONE101

100

ONE101_2

NUMBER

Second allele at genetic marker ONE102

100

ONE102_1

NUMBER

First allele at genetic marker ONE102

100

ONE102_2

NUMBER

Second allele at genetic marker ONE102

100

ONE104_1

NUMBER

First allele at genetic marker ONE104

100

ONE104_2

NUMBER

Second allele at genetic marker ONE104

100

ONE114_1

NUMBER

First allele at genetic marker ONE114

100

ONE114_2

NUMBER

Second allele at genetic marker ONE114

100

OTS103_1

NUMBER

First allele at genetic marker OTS103

100

OTS103_2

NUMBER

Second allele at genetic marker OTS103

100

OTS3_1

NUMBER

First allele at genetic marker OTS3

100

OTS3_2

NUMBER

Second allele at genetic marker OTS3

100

OTSG68_1

NUMBER

First allele at genetic marker OTSG68

100

OTSG68_2

NUMBER

Second allele at genetic marker OTSG68

100

SSA419_1

NUMBER

First allele at genetic marker SSA419

100

SSA419_2

NUMBER

Second allele at genetic marker SSA 419

100

BINARY

VARCHAR2

Binary format of alleles at each genetic marker.

Attribute Details

SAL_BYCATCH_SEQ

CC ID: 233506

Seq. Order:	1
Data Storage Type:	Number
Max Length:	9
Required:	Yes
Primary Key:	Yes
Precision:	9
Scale:	0
Status:	Active
Description:	Oracle Generated Unique Identifier of a record

CRUISE

CC ID: 233507

Seq. Order:	5
Data Storage Type:	Number
Max Length:	9
Required:	Yes
Primary Key:	No
Precision:	9
Scale:	0
Status:	Active
Description:	Observer Cruise Inherited from debriefed_age

PERMIT

CC ID: 233508

Seq. Order:	10
Data Storage Type:	VARCHAR2
Max Length:	7
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Vessel federal fisheries permit Inherited from debriefed_age

SPECIMEN_NUMBER

CC ID: 233509

Seq. Order:	15
Data Storage Type:	NUMBER
Max Length:	6
Required:	Yes
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Inherited from debriefed_age, a specimen number is unique within a cruise, permit, length and specimen type. It is a user defined identifier.

HAUL_OFFLOAD

CC ID: 233510

Seq. Order:	20
Data Storage Type:	NUMBER
Max Length:	6
Required:	Yes
Primary Key:	No
Precision:	6
Scale:	0
Status:	Active
Description:	Haul or offload from which the genetics specimen was collected.

SPECIMEN_TYPE

CC ID: 233511

Seq. Order:	25
Data Storage Type:	NUMBER
Max Length:	2
Required:	Yes
Primary Key:	No
Precision:	2
Scale:	0
Status:	Active
Description:	Specimen type code. This references the definition about what is being measured or commented.

SEX

CC ID: 233513

Seq. Order:	30
Data Storage Type:	VARCHAR2
Max Length:	1
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Sex either inherited from length or recorded in age/atl_fish_inv_specimen if different.

SPECIES

CC ID: 233514

Seq. Order:	35
Data Storage Type:	NUMBER
Max Length:	4
Required:	Yes
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Species either inherited from length or recorded in age/atl_fish_inv_specimen if different.

PORT_JOIN

CC ID: 233515

Seq. Order:	40
Data Storage Type:	NUMBER
Max Length:	16
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.

HAUL_JOIN

CC ID: 233516

Seq. Order:	45
Data Storage Type:	NUMBER
Max Length:	16
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.

SPECIMEN_SEQ

CC ID: 233517

Seq. Order:	50
Data Storage Type:	NUMBER
Max Length:	9
Required:	Yes
Primary Key:	No
Precision:	9
Scale:	0
Status:	Active
Description:	Oracle Generated Unique Identifier of a specimen record from the Observer database entered into record by a before insert record trigger on the table.

SAMPLE_ID

CC ID: 233518

Seq. Order:	55
Data Storage Type:	VARCHAR2
Max Length:	150
Required:	No
Primary Key:	No
Status:	Active
Description:	Intelligent key assigned by staff uniquely identifying this record.

YEAR

CC ID: 233519

Seq. Order:	60
Data Storage Type:	NUMBER
Max Length:	4
Required:	No
Primary Key:	No
Precision:	4
Scale:	0
Status:	Active
Description:	Year that the genetic sample was collected and analysis done.

OKI100_1

CC ID: 233520

Seq. Order:	65
Data Storage Type:	NUMBER
Max Length:	3
Required:	No
Primary Key:	No
Precision:	3
Status:	Active
Description:	First allele at genetic marker OKI100

OKI100_2

CC ID: 233521

Seq. Order:	70
Data Storage Type:	NUMBER
Max Length:	3
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Second allele at genetic marker OKI100

OMM1070_1

CC ID: 233523

Seq. Order:	73
Data Storage Type:	NUMBER
Max Length:	3
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	First allele at genetic marker OMM1070

OMM1070_2

CC ID: 233522

Seq. Order:	75
Data Storage Type:	NUMBER
Max Length:	3
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Second allele at genetic marker OMM 1070

OMY1011_1

CC ID: 233524

Seq. Order:	80
Data Storage Type:	NUMBER
Max Length:	3
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	First allele at genetic marker OMY1011

OMY1011_2

CC ID: 233525

Seq. Order:	85
Data Storage Type:	NUMBER
Max Length:	3
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Second allele at genetic marker OMY1011

ONE101_1

CC ID: 233526

Seq. Order:	90
Data Storage Type:	NUMBER
Max Length:	3
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	First allele at genetic marker ONE101

ONE101_2

CC ID: 233527

Seq. Order:	100
Data Storage Type:	NUMBER
Max Length:	3
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Second allele at genetic marker ONE102

ONE102_1

CC ID: 233528

Seq. Order:	105
Data Storage Type:	NUMBER
Max Length:	3
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	First allele at genetic marker ONE102

ONE102_2

CC ID: 233530

Seq. Order:	107
Data Storage Type:	NUMBER
Max Length:	3
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Second allele at genetic marker ONE102

ONE104_1

CC ID: 233529

Seq. Order:	110
Data Storage Type:	NUMBER
Max Length:	3
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	First allele at genetic marker ONE104

ONE104_2

CC ID: 261800

Seq. Order:	112
Data Storage Type:	NUMBER
Max Length:	3
Min Length:	0
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Second allele at genetic marker ONE104

ONE114_1

CC ID: 233531

Seq. Order:	115
Data Storage Type:	NUMBER
Max Length:	3
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	First allele at genetic marker ONE114

ONE114_2

CC ID: 233532

Seq. Order:	120
Data Storage Type:	NUMBER
Max Length:	3
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Second allele at genetic marker ONE114

OTS103_1

CC ID: 233533

Seq. Order:	125
Data Storage Type:	NUMBER
Max Length:	3
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	First allele at genetic marker OTS103

OTS103_2

CC ID: 233534

Seq. Order:	130
Data Storage Type:	NUMBER
Max Length:	3
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Second allele at genetic marker OTS103

OTS3_1

CC ID: 233535

Seq. Order:	135
Data Storage Type:	NUMBER
Max Length:	3
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	First allele at genetic marker OTS3

OTS3_2

CC ID: 233536

Seq. Order:	140
Data Storage Type:	NUMBER
Max Length:	3
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Second allele at genetic marker OTS3

OTSG68_1

CC ID: 233537

Seq. Order:	145
Data Storage Type:	NUMBER
Max Length:	3
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	First allele at genetic marker OTSG68

OTSG68_2

CC ID: 233538

Seq. Order:	150
Data Storage Type:	NUMBER
Max Length:	3
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Second allele at genetic marker OTSG68

SSA419_1

CC ID: 233539

Seq. Order:	155
Data Storage Type:	NUMBER
Max Length:	3
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	First allele at genetic marker SSA419

SSA419_2

CC ID: 233540

Seq. Order:	160
Data Storage Type:	NUMBER
Max Length:	3
Required:	No
Primary Key:	No
Precision:	3
Scale:	0
Status:	Active
Description:	Second allele at genetic marker SSA 419

BINARY

CC ID: 233541

Seq. Order:	165
Data Storage Type:	VARCHAR2
Max Length:	1062
Required:	Yes
Primary Key:	No
Status:	Active
Description:	Binary format of alleles at each genetic marker.

Catalog Details

Catalog Item ID:	27651
GUID:	gov.noaa.nmfs.inport:27651
Metadata Record Created By:	Julie A Blair
Metadata Record Created:	2015-10-02 18:19+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