Search Help Show/Hide Menu
Metadata Rubric
83%
5 / 6
View Report
Alaska Fisheries Science Center Metadata Librar... > Fisheries Management and Analysis Division > AMMOP > AMMOP Oracle database 1999 - 2013 >

MM_CUSTODY_ANIMAL

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

Summary

Description

This table captures the animal information recorded on the Biological Sample Chain of Custody Form, for any carcass or samples collected from a carcass, by Alaska Marine Mammal Observer Program observers.

Entity Information

Data Attribute / Type Description
COLLECTION_DATE
DATE 		Date the animal was collected (MM/DD/YYYY).
COMMENTS
VARCHAR2(1500 BYTE) 		Comments as needed. Note here if observer who completes form differs from primary trip observer.
ENTERED_BY
VARCHAR2(100 BYTE) 		Oracle username of the data entry person.
ENTERED_DATE
DATE 		Date the animal was entered into the database.
HAUL_NUMBER
NUMBER(4,0) 		If the animal was collected during a trip, this is the haul number during which the animal was collected.
ID
NUMBER(6,0) 		Unique identifier of the animal.
OBSERVED_TAKE_FLAG
VARCHAR2(1 BYTE) 		Flag indicating whether or not this animal was an observed take: Y or N.
SEQUENCE_NUMBER
NUMBER(4,0) 		If the animal was collected during a trip, this is the sequence number of the haul during which the animal was collected.
SPECIES_CODE
VARCHAR2(5 BYTE) 		Agency species code of the animal collected.
SPECIES_ID
NUMBER(6,0) 		Unique identifier of the agency species code of the animal collected.
SPECIES_TYPE_CODE
VARCHAR2(2 BYTE) 		Code indicating the type of animal collected: B = Bird, M = Mammal, F = Fish/Shark, O = Other.
SPECIES_TYPE_ID
NUMBER(6,0) 		Unique identifier of the type of animal collected.
TAG_NUMBER
VARCHAR2(10 BYTE) 		Number from the carcass tag applied by the observer (A####).
TRIP_CODE
VARCHAR2(6 BYTE) 		Unique code identifying the trip during which the animal was collected.
TRIP_ID
NUMBER(6,0) 		Unique identifier of the trip during which the animal was collected.

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_CUSTODY_ANIMAL

Entity Information

Description:

This table captures the animal information recorded on the Biological Sample Chain of Custody Form, for any carcass or samples collected from a carcass, by Alaska Marine Mammal Observer Program observers.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 COLLECTION_DATE DATE Date the animal was collected (MM/DD/YYYY).
100
 COMMENTS VARCHAR2(1500 BYTE) Comments as needed. Note here if observer who completes form differs from primary trip observer.
100
 ENTERED_BY VARCHAR2(100 BYTE) Oracle username of the data entry person.
100
 ENTERED_DATE DATE Date the animal was entered into the database.
100
 HAUL_NUMBER NUMBER(4,0) If the animal was collected during a trip, this is the haul number during which the animal was collected.
100
 ID NUMBER(6,0) Unique identifier of the animal.
100
 OBSERVED_TAKE_FLAG VARCHAR2(1 BYTE) Flag indicating whether or not this animal was an observed take: Y or N.
100
 SEQUENCE_NUMBER NUMBER(4,0) If the animal was collected during a trip, this is the sequence number of the haul during which the animal was collected.
100
 SPECIES_CODE VARCHAR2(5 BYTE) Agency species code of the animal collected.
100
 SPECIES_ID NUMBER(6,0) Unique identifier of the agency species code of the animal collected.
100
 SPECIES_TYPE_CODE VARCHAR2(2 BYTE) Code indicating the type of animal collected: B = Bird, M = Mammal, F = Fish/Shark, O = Other.
100
 SPECIES_TYPE_ID NUMBER(6,0) Unique identifier of the type of animal collected.
100
 TAG_NUMBER VARCHAR2(10 BYTE) Number from the carcass tag applied by the observer (A####).
100
 TRIP_CODE VARCHAR2(6 BYTE) Unique code identifying the trip during which the animal was collected.
100
 TRIP_ID NUMBER(6,0) Unique identifier of the trip during which the animal was collected.

Attribute Details

COLLECTION_DATE

CC ID: 1374192
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Date the animal was collected (MM/DD/YYYY).

COMMENTS

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

Comments as needed. Note here if observer who completes form differs from primary trip observer.

ENTERED_BY

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

Oracle username of the data entry person.

ENTERED_DATE

CC ID: 1374195
Data Storage Type: DATE
Required: No
Primary Key: No
Status: Active
Description:

Date the animal was entered into the database.

HAUL_NUMBER

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

If the animal was collected during a trip, this is the haul number during which the animal was collected.

ID

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

Unique identifier of the animal.

OBSERVED_TAKE_FLAG

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

Flag indicating whether or not this animal was an observed take: Y or N.

SEQUENCE_NUMBER

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

If the animal was collected during a trip, this is the sequence number of the haul during which the animal was collected.

SPECIES_CODE

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

Agency species code of the animal collected.

SPECIES_ID

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

Unique identifier of the agency species code of the animal collected.

SPECIES_TYPE_CODE

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

Code indicating the type of animal collected: B = Bird, M = Mammal, F = Fish/Shark, O = Other.

SPECIES_TYPE_ID

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

Unique identifier of the type of animal collected.

TAG_NUMBER

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

Number from the carcass tag applied by the observer (A####).

TRIP_CODE

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

Unique code identifying the trip during which the animal was collected.

TRIP_ID

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

Unique identifier of the trip during which the animal was collected.

Catalog Details

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