Account Creation Issues: We have received reports of issues with creating new user accounts and linking accounts to CAM, and are currently investigating the root cause. In the meantime: - If you're experiencing errors creating new users, please use the "Quick Add" feature instead (click the "Quick Add" button on the Manage Users page). - If you're experiencing errors linking CAM accoun...
View All
Search Help Show/Hide Menu
Metadata Rubric
82%
4.94 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > AMMOP > AMMOP Oracle database 1999 - 2013 >

MM_HAUL_SPECIES_SAMPLE

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:75178  |  Updated: May 21, 2025  |  Published / External 
Summary
Item Identification
Entity Info
Data Attributes
Catalog Details

Summary

Description

Captures hard copy Fish/ Shark Sample Form.

Entity Information

Data Attribute / Type Description
COMMENTS
VARCHAR2(2000 BYTE) 		Comments on sample
CONDITION_CODE
VARCHAR2(2 BYTE) 		The AMMOP code for the condition
CONDITION_DESCRIPTION
VARCHAR2(50 BYTE) 		The condition description
CONDITION_ID
NUMBER(6,0) 		The unique database id for the condition code
FORK_LENGTH
NUMBER(4,0) 		The fork length (cm)
GIRTH
NUMBER(4,0) 		The girth (cm)
ID
NUMBER(6,0) 		Unique database identifier
INJURY_CODE
VARCHAR2(2 BYTE) 		The AMMOP code for the fish/shark sample form injury code
INJURY_DESCRIPTION
VARCHAR2(50 BYTE) 		The injury code description
INJURY_ID
NUMBER(6,0) 		The unique database identifier for the injury code
SAMPLE_NUMBER
NUMBER(3,0) 		Unique sequence value within an observer trip.
SAMPLE_WEIGHT
NUMBER(5,1) 		The sample weight (kg.0)
SEQUENCE_NUMBER
NUMBER(4,0) 		Corresponds to haul number
SEX
VARCHAR2(1 BYTE) 		The sex as pick list
SPECIES_CODE
VARCHAR2(5 BYTE) 		The AMMOP code for the species
SPECIES_CONDITION
NUMBER(6,0)
SPECIES_DISPOSITION
NUMBER(6,0)
SPECIES_ID
NUMBER(6,0) 		The unique identifier for the spcies
SPECIES_NAME
VARCHAR2(40 BYTE) 		The common name for the species
TAG_ONE
VARCHAR2(12 BYTE) 		The Tag Number 1 field on the fish/shark sample form
TAG_ONE_STATUS_CODE
VARCHAR2(2 BYTE) 		The AMMOP code for the tag 1 tag status
TAG_ONE_TYPE_CODE
VARCHAR2(2 BYTE) 		The AMMOP code for the tag 1 tag type
TAG_ONE_TYPE_ID
NUMBER(6,0) 		The unique database id for the tag 1 tag type
TAG_TWO
VARCHAR2(12 BYTE) 		The Tag Number 2 field on the fish/shark sample form
TAG_TWO_STATUS_CODE
VARCHAR2(2 BYTE) 		The AMMOP code for the tag 2 tag status
TAG_TWO_TYPE_CODE
VARCHAR2(2 BYTE) 		The AMMOP code for the tag 2 tag type
TAG_TWO_TYPE_ID
NUMBER(6,0) 		The unique database id for the tag 2 tag type
TISSUE_SAMPLE_TAKEN_FLAG
VARCHAR2(1 BYTE) 		Was a tissue sample collected?
TOTAL_LENGTH
NUMBER(4,0) 		The total length (cm)
TRIP_ID
NUMBER(6,0) 		Unique database identifier for AMMOP trip
WEIGHT_TYPE_CODE
VARCHAR2(2 BYTE) 		The AMMOP code for method of obtaining weight.

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: MM_HAUL_SPECIES_SAMPLE

Entity Information

Description:

Captures hard copy Fish/ Shark Sample Form.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 COMMENTS VARCHAR2(2000 BYTE) Comments on sample
100
 CONDITION_CODE VARCHAR2(2 BYTE) The AMMOP code for the condition
100
 CONDITION_DESCRIPTION VARCHAR2(50 BYTE) The condition description
100
 CONDITION_ID NUMBER(6,0) The unique database id for the condition code
100
 FORK_LENGTH NUMBER(4,0) The fork length (cm)
100
 GIRTH NUMBER(4,0) The girth (cm)
100
 ID NUMBER(6,0) Unique database identifier
100
 INJURY_CODE VARCHAR2(2 BYTE) The AMMOP code for the fish/shark sample form injury code
100
 INJURY_DESCRIPTION VARCHAR2(50 BYTE) The injury code description
100
 INJURY_ID NUMBER(6,0) The unique database identifier for the injury code
100
 SAMPLE_NUMBER NUMBER(3,0) Unique sequence value within an observer trip.
100
 SAMPLE_WEIGHT NUMBER(5,1) The sample weight (kg.0)
100
 SEQUENCE_NUMBER NUMBER(4,0) Corresponds to haul number
100
 SEX VARCHAR2(1 BYTE) The sex as pick list
100
 SPECIES_CODE VARCHAR2(5 BYTE) The AMMOP code for the species
67
 SPECIES_CONDITION NUMBER(6,0)
67
 SPECIES_DISPOSITION NUMBER(6,0)
100
 SPECIES_ID NUMBER(6,0) The unique identifier for the spcies
100
 SPECIES_NAME VARCHAR2(40 BYTE) The common name for the species
100
 TAG_ONE VARCHAR2(12 BYTE) The Tag Number 1 field on the fish/shark sample form
100
 TAG_ONE_STATUS_CODE VARCHAR2(2 BYTE) The AMMOP code for the tag 1 tag status
100
 TAG_ONE_TYPE_CODE VARCHAR2(2 BYTE) The AMMOP code for the tag 1 tag type
100
 TAG_ONE_TYPE_ID NUMBER(6,0) The unique database id for the tag 1 tag type
100
 TAG_TWO VARCHAR2(12 BYTE) The Tag Number 2 field on the fish/shark sample form
100
 TAG_TWO_STATUS_CODE VARCHAR2(2 BYTE) The AMMOP code for the tag 2 tag status
100
 TAG_TWO_TYPE_CODE VARCHAR2(2 BYTE) The AMMOP code for the tag 2 tag type
100
 TAG_TWO_TYPE_ID NUMBER(6,0) The unique database id for the tag 2 tag type
100
 TISSUE_SAMPLE_TAKEN_FLAG VARCHAR2(1 BYTE) Was a tissue sample collected?
100
 TOTAL_LENGTH NUMBER(4,0) The total length (cm)
100
 TRIP_ID NUMBER(6,0) Unique database identifier for AMMOP trip
100
 WEIGHT_TYPE_CODE VARCHAR2(2 BYTE) The AMMOP code for method of obtaining weight.

Attribute Details

COMMENTS

CC ID: 1374383
Data Storage Type: VARCHAR2(2000 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Comments on sample

CONDITION_CODE

CC ID: 1374384
Data Storage Type: VARCHAR2(2 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The AMMOP code for the condition

CONDITION_DESCRIPTION

CC ID: 1374385
Data Storage Type: VARCHAR2(50 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The condition description

CONDITION_ID

CC ID: 1374386
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

The unique database id for the condition code

FORK_LENGTH

CC ID: 1374387
Data Storage Type: NUMBER(4,0)
Required: No
Primary Key: No
Status: Active
Description:

The fork length (cm)

GIRTH

CC ID: 1374388
Data Storage Type: NUMBER(4,0)
Required: No
Primary Key: No
Status: Active
Description:

The girth (cm)

ID

CC ID: 1374389
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Unique database identifier

INJURY_CODE

CC ID: 1374390
Data Storage Type: VARCHAR2(2 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The AMMOP code for the fish/shark sample form injury code

INJURY_DESCRIPTION

CC ID: 1374391
Data Storage Type: VARCHAR2(50 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The injury code description

INJURY_ID

CC ID: 1374392
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

The unique database identifier for the injury code

SAMPLE_NUMBER

CC ID: 1374393
Data Storage Type: NUMBER(3,0)
Required: No
Primary Key: No
Status: Active
Description:

Unique sequence value within an observer trip.

SAMPLE_WEIGHT

CC ID: 1374394
Data Storage Type: NUMBER(5,1)
Required: No
Primary Key: No
Status: Active
Description:

The sample weight (kg.0)

SEQUENCE_NUMBER

CC ID: 1374395
Data Storage Type: NUMBER(4,0)
Required: No
Primary Key: No
Status: Active
Description:

Corresponds to haul number

SEX

CC ID: 1374396
Data Storage Type: VARCHAR2(1 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The sex as pick list

SPECIES_CODE

CC ID: 1374397
Data Storage Type: VARCHAR2(5 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The AMMOP code for the species

SPECIES_CONDITION

CC ID: 1374398
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active

SPECIES_DISPOSITION

CC ID: 1374399
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active

SPECIES_ID

CC ID: 1374400
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

The unique identifier for the spcies

SPECIES_NAME

CC ID: 1374401
Data Storage Type: VARCHAR2(40 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The common name for the species

TAG_ONE

CC ID: 1374402
Data Storage Type: VARCHAR2(12 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The Tag Number 1 field on the fish/shark sample form

TAG_ONE_STATUS_CODE

CC ID: 1374403
Data Storage Type: VARCHAR2(2 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The AMMOP code for the tag 1 tag status

TAG_ONE_TYPE_CODE

CC ID: 1374404
Data Storage Type: VARCHAR2(2 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The AMMOP code for the tag 1 tag type

TAG_ONE_TYPE_ID

CC ID: 1374405
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

The unique database id for the tag 1 tag type

TAG_TWO

CC ID: 1374406
Data Storage Type: VARCHAR2(12 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The Tag Number 2 field on the fish/shark sample form

TAG_TWO_STATUS_CODE

CC ID: 1374407
Data Storage Type: VARCHAR2(2 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The AMMOP code for the tag 2 tag status

TAG_TWO_TYPE_CODE

CC ID: 1374408
Data Storage Type: VARCHAR2(2 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The AMMOP code for the tag 2 tag type

TAG_TWO_TYPE_ID

CC ID: 1374409
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

The unique database id for the tag 2 tag type

TISSUE_SAMPLE_TAKEN_FLAG

CC ID: 1374410
Data Storage Type: VARCHAR2(1 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

Was a tissue sample collected?

TOTAL_LENGTH

CC ID: 1374411
Data Storage Type: NUMBER(4,0)
Required: No
Primary Key: No
Status: Active
Description:

The total length (cm)

TRIP_ID

CC ID: 1374412
Data Storage Type: NUMBER(6,0)
Required: No
Primary Key: No
Status: Active
Description:

Unique database identifier for AMMOP trip

WEIGHT_TYPE_CODE

CC ID: 1374413
Data Storage Type: VARCHAR2(2 BYTE)
Required: No
Primary Key: No
Status: Active
Description:

The AMMOP code for method of obtaining weight.

Catalog Details

Catalog Item ID: 75178
GUID: gov.noaa.nmfs.inport:75178
Metadata Record Created By: Rachel Wuest
Metadata Record Created: 2025-03-06 21:48+0000
Metadata Record Last Modified By: Daniel Woodrich
Metadata Record Last Modified: 2025-05-21 19:12+0000
Metadata Record Published: 2025-05-21
Owner Org: AFSC
Metadata Publication Status: Published Externally
Do Not Publish?: N
Metadata Review Frequency: 1 Year