MM_CUSTODY_ANIMAL
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:75161 | Updated: May 21, 2025 | Published / External
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
|
|
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
| Data Storage Type: | DATE |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date the animal was collected (MM/DD/YYYY). |
COMMENTS
| 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
| Data Storage Type: | VARCHAR2(100 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Oracle username of the data entry person. |
ENTERED_DATE
| Data Storage Type: | DATE |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date the animal was entered into the database. |
HAUL_NUMBER
| 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
| Data Storage Type: | NUMBER(6,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique identifier of the animal. |
OBSERVED_TAKE_FLAG
| 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
| 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
| Data Storage Type: | VARCHAR2(5 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Agency species code of the animal collected. |
SPECIES_ID
| 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
| 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
| Data Storage Type: | NUMBER(6,0) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Unique identifier of the type of animal collected. |
TAG_NUMBER
| 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
| 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
| 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 |