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_INCIDENTAL_TAKE

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

Summary

Description

Captures hard copy Incidental Take Form.

Entity Information

Data Attribute / Type Description
AGE_CLASS
VARCHAR2(1 BYTE) 		The AMMOP code for the animal's age class, from the incidental take form
COMMENTS
VARCHAR2(2000 BYTE) 		Observer text
CONDITION_CODE
VARCHAR2(2 BYTE) 		The AMMOP code for the animal's condition, from the incidental take form
CONDITION_DESCRIPTION
VARCHAR2(60 BYTE) 		The description of the animal's condiiton
CONDITION_ID
NUMBER(6,0) 		The unique database indentifier for the the condition code
DISENTANGLMENT_CODE
VARCHAR2(2 BYTE) 		The AMMOP code for the disentanglement method, from the incidental take form
HORIZONTAL_LOCATION_CODE
VARCHAR2(2 BYTE) 		The AMMOP code for the horizontal location code, from the incidental take form
ID
NUMBER(6,0)
IDENTIFICATION_NUMBER
NUMBER(4,0) 		Sequential number of take for this trip
INJURY_CODE
VARCHAR2(2 BYTE) 		The AMMOP code for the injury code, from the incidential take form
INJURY_DESCRIPTION
VARCHAR2(50 BYTE) 		The description of the animal's injury
INJURY_ID
NUMBER(6,0) 		The unique database indentifier for the injury code
MONTH
VARCHAR2(2 BYTE) 		Month trip began
PHOTO_TAKEN_FLAG
VARCHAR2(1 BYTE) 		Were photos taken of the take/the animal taken?
SAMPLED_FLAG
VARCHAR2(1 BYTE) 		Were biological samples of this animal collected (or, was the animal retained whole)?
SEQUENCE_NUMBER
NUMBER(4,0) 		Corresponds to haul number
SEX
VARCHAR2(1 BYTE) 		The sex of the animal
SPECIES_CODE
VARCHAR2(5 BYTE) 		The AMMOP code for this species
SPECIES_ID
NUMBER(6,0) 		The unique identifier of the Specie Group.
SPECIES_NAME
VARCHAR2(40 BYTE) 		The common name for this species
TAG_ONE_NUMBER
VARCHAR2(12 BYTE) 		The top tag number field on the incidential take form
TAG_ONE_STATUS_CODE
VARCHAR2(1 BYTE) 		The AMMOP code from the indicidental take form for the status of tag (recorded in the top tag type field)
TAG_ONE_TYPE_CODE
VARCHAR2(2 BYTE) 		The AMMOP code from the indicidental take form for the type of tag (recorded in the top tag type field)
TAG_ONE_TYPE_DESC
VARCHAR2(50 BYTE) 		The description of tag type (recorded in the top tag type field)
TAG_ONE_TYPE_ID
NUMBER(6,0) 		The unique database id for the type of tag recorded in the top tag type field
TAG_TWO_NUMBER
VARCHAR2(12 BYTE) 		The bottom tag number field on the incidential take for
TAG_TWO_STATUS_CODE
VARCHAR2(1 BYTE) 		The AMMOP code from the indicidental take form for the status of tag (recorded in the bottom tag type field)
TAG_TWO_TYPE_CODE
VARCHAR2(2 BYTE) 		The AMMOP code from the indicidental take form for the type of tag (recorded in the bottom tag type field)
TAG_TWO_TYPE_DESC
VARCHAR2(50 BYTE) 		The description of tag type (recorded in the bottom tag type field)
TAG_TWO_TYPE_ID
NUMBER(6,0) 		The unique database id for the type of tag recorded in the bottom tag type field
TRIP_CODE
VARCHAR2(6 BYTE) 		AMMOP code for trip
TRIP_ID
NUMBER(6,0)
VERTICAL_LOCATION_CODE
VARCHAR2(2 BYTE) 		The AMMOP code for the vertical location code, from the incidental take form
YEAR
NUMBER(4,0) 		Year trip in which the trip took place

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_INCIDENTAL_TAKE

Entity Information

Description:

Captures hard copy Incidental Take Form.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 AGE_CLASS VARCHAR2(1 BYTE) The AMMOP code for the animal's age class, from the incidental take form
100
 COMMENTS VARCHAR2(2000 BYTE) Observer text
100
 CONDITION_CODE VARCHAR2(2 BYTE) The AMMOP code for the animal's condition, from the incidental take form
100
 CONDITION_DESCRIPTION VARCHAR2(60 BYTE) The description of the animal's condiiton
100
 CONDITION_ID NUMBER(6,0) The unique database indentifier for the the condition code
100
 DISENTANGLMENT_CODE VARCHAR2(2 BYTE) The AMMOP code for the disentanglement method, from the incidental take form
100
 HORIZONTAL_LOCATION_CODE VARCHAR2(2 BYTE) The AMMOP code for the horizontal location code, from the incidental take form
67
 ID NUMBER(6,0)
100
 IDENTIFICATION_NUMBER NUMBER(4,0) Sequential number of take for this trip
100
 INJURY_CODE VARCHAR2(2 BYTE) The AMMOP code for the injury code, from the incidential take form
100
 INJURY_DESCRIPTION VARCHAR2(50 BYTE) The description of the animal's injury
100
 INJURY_ID NUMBER(6,0) The unique database indentifier for the injury code
100
 MONTH VARCHAR2(2 BYTE) Month trip began
100
 PHOTO_TAKEN_FLAG VARCHAR2(1 BYTE) Were photos taken of the take/the animal taken?
100
 SAMPLED_FLAG VARCHAR2(1 BYTE) Were biological samples of this animal collected (or, was the animal retained whole)?
100
 SEQUENCE_NUMBER NUMBER(4,0) Corresponds to haul number
100
 SEX VARCHAR2(1 BYTE) The sex of the animal
100
 SPECIES_CODE VARCHAR2(5 BYTE) The AMMOP code for this species
100
 SPECIES_ID NUMBER(6,0) The unique identifier of the Specie Group.
100
 SPECIES_NAME VARCHAR2(40 BYTE) The common name for this species
100
 TAG_ONE_NUMBER VARCHAR2(12 BYTE) The top tag number field on the incidential take form
100
 TAG_ONE_STATUS_CODE VARCHAR2(1 BYTE) The AMMOP code from the indicidental take form for the status of tag (recorded in the top tag type field)
100
 TAG_ONE_TYPE_CODE VARCHAR2(2 BYTE) The AMMOP code from the indicidental take form for the type of tag (recorded in the top tag type field)
100
 TAG_ONE_TYPE_DESC VARCHAR2(50 BYTE) The description of tag type (recorded in the top tag type field)
100
 TAG_ONE_TYPE_ID NUMBER(6,0) The unique database id for the type of tag recorded in the top tag type field
100
 TAG_TWO_NUMBER VARCHAR2(12 BYTE) The bottom tag number field on the incidential take for
100
 TAG_TWO_STATUS_CODE VARCHAR2(1 BYTE) The AMMOP code from the indicidental take form for the status of tag (recorded in the bottom tag type field)
100
 TAG_TWO_TYPE_CODE VARCHAR2(2 BYTE) The AMMOP code from the indicidental take form for the type of tag (recorded in the bottom tag type field)
100
 TAG_TWO_TYPE_DESC VARCHAR2(50 BYTE) The description of tag type (recorded in the bottom tag type field)
100
 TAG_TWO_TYPE_ID NUMBER(6,0) The unique database id for the type of tag recorded in the bottom tag type field
100
 TRIP_CODE VARCHAR2(6 BYTE) AMMOP code for trip
67
 TRIP_ID NUMBER(6,0)
100
 VERTICAL_LOCATION_CODE VARCHAR2(2 BYTE) The AMMOP code for the vertical location code, from the incidental take form
100
 YEAR NUMBER(4,0) Year trip in which the trip took place

Attribute Details

AGE_CLASS

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

The AMMOP code for the animal's age class, from the incidental take form

COMMENTS

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

Observer text

CONDITION_CODE

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

The AMMOP code for the animal's condition, from the incidental take form

CONDITION_DESCRIPTION

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

The description of the animal's condiiton

CONDITION_ID

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

The unique database indentifier for the the condition code

DISENTANGLMENT_CODE

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

The AMMOP code for the disentanglement method, from the incidental take form

HORIZONTAL_LOCATION_CODE

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

The AMMOP code for the horizontal location code, from the incidental take form

ID

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

IDENTIFICATION_NUMBER

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

Sequential number of take for this trip

INJURY_CODE

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

The AMMOP code for the injury code, from the incidential take form

INJURY_DESCRIPTION

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

The description of the animal's injury

INJURY_ID

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

The unique database indentifier for the injury code

MONTH

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

Month trip began

PHOTO_TAKEN_FLAG

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

Were photos taken of the take/the animal taken?

SAMPLED_FLAG

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

Were biological samples of this animal collected (or, was the animal retained whole)?

SEQUENCE_NUMBER

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

Corresponds to haul number

SEX

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

The sex of the animal

SPECIES_CODE

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

The AMMOP code for this species

SPECIES_ID

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

The unique identifier of the Specie Group.

SPECIES_NAME

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

The common name for this species

TAG_ONE_NUMBER

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

The top tag number field on the incidential take form

TAG_ONE_STATUS_CODE

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

The AMMOP code from the indicidental take form for the status of tag (recorded in the top tag type field)

TAG_ONE_TYPE_CODE

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

The AMMOP code from the indicidental take form for the type of tag (recorded in the top tag type field)

TAG_ONE_TYPE_DESC

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

The description of tag type (recorded in the top tag type field)

TAG_ONE_TYPE_ID

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

The unique database id for the type of tag recorded in the top tag type field

TAG_TWO_NUMBER

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

The bottom tag number field on the incidential take for

TAG_TWO_STATUS_CODE

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

The AMMOP code from the indicidental take form for the status of tag (recorded in the bottom tag type field)

TAG_TWO_TYPE_CODE

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

The AMMOP code from the indicidental take form for the type of tag (recorded in the bottom tag type field)

TAG_TWO_TYPE_DESC

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

The description of tag type (recorded in the bottom tag type field)

TAG_TWO_TYPE_ID

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

The unique database id for the type of tag recorded in the bottom tag type field

TRIP_CODE

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

AMMOP code for trip

TRIP_ID

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

VERTICAL_LOCATION_CODE

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

The AMMOP code for the vertical location code, from the incidental take form

YEAR

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

Year trip in which the trip took place

Catalog Details

Catalog Item ID: 75182
GUID: gov.noaa.nmfs.inport:75182
Metadata Record Created By: Rachel Wuest
Metadata Record Created: 2025-03-06 22:11+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