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_SAMPLE

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

Summary

Description

This table captures information about the nature of samples collected from animals recorded by AMMOP observers on the Biological Sample Chain of Custody Form.

Entity Information

Data Attribute / Type Description
ANIMAL_ID
NUMBER(6,0) 		Unique identifier of the animal from which the sample was collected.
DISPOSAL_COMMENTS
VARCHAR2(1500 BYTE) 		Additional information about the disposal or destruction of the sample.
DISPOSAL_DATE
DATE 		Date the sample was destroyed or disposed of.
DISPOSAL_FLAG
VARCHAR2(1 BYTE) 		Flag indicating whether or not the sample has been disposed of: Y or N.
DISPOSAL_LOCATION
VARCHAR2(100 BYTE) 		Location where the sample was either destroyed or disposed of.
DISPOSAL_METHOD
VARCHAR2(100 BYTE) 		Method employed to dispose of the sample.
SAMPLE_ANATOMICAL_SITE
VARCHAR2(100 BYTE) 		Anatomical site on the body of the animal, from which the sample was collected.
SAMPLE_COMMENTS
VARCHAR2(1500 BYTE) 		Additional information about the sample.
SAMPLE_ID
NUMBER(6,0) 		Unique identifier of the sample, within the context of the animal from which the sample was collected.
SAMPLE_PRESERVATION_METHOD
VARCHAR2(100 BYTE) 		Method employed to preserve the sample: fresh, frozen, dmso, etc.
SAMPLE_SIZE
VARCHAR2(100 BYTE) 		Dimensions, weight, etc., if known.
SAMPLE_TYPE_CODE
VARCHAR2(2 BYTE) 		Code representing the description of the sample type.
SAMPLE_TYPE_ID
NUMBER(6,0) 		Unique identifier of the description of the sample type.

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_SAMPLE

Entity Information

Description:

This table captures information about the nature of samples collected from animals recorded by AMMOP observers on the Biological Sample Chain of Custody Form.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 ANIMAL_ID NUMBER(6,0) Unique identifier of the animal from which the sample was collected.
100
 DISPOSAL_COMMENTS VARCHAR2(1500 BYTE) Additional information about the disposal or destruction of the sample.
100
 DISPOSAL_DATE DATE Date the sample was destroyed or disposed of.
100
 DISPOSAL_FLAG VARCHAR2(1 BYTE) Flag indicating whether or not the sample has been disposed of: Y or N.
100
 DISPOSAL_LOCATION VARCHAR2(100 BYTE) Location where the sample was either destroyed or disposed of.
100
 DISPOSAL_METHOD VARCHAR2(100 BYTE) Method employed to dispose of the sample.
100
 SAMPLE_ANATOMICAL_SITE VARCHAR2(100 BYTE) Anatomical site on the body of the animal, from which the sample was collected.
100
 SAMPLE_COMMENTS VARCHAR2(1500 BYTE) Additional information about the sample.
100
 SAMPLE_ID NUMBER(6,0) Unique identifier of the sample, within the context of the animal from which the sample was collected.
100
 SAMPLE_PRESERVATION_METHOD VARCHAR2(100 BYTE) Method employed to preserve the sample: fresh, frozen, dmso, etc.
100
 SAMPLE_SIZE VARCHAR2(100 BYTE) Dimensions, weight, etc., if known.
100
 SAMPLE_TYPE_CODE VARCHAR2(2 BYTE) Code representing the description of the sample type.
100
 SAMPLE_TYPE_ID NUMBER(6,0) Unique identifier of the description of the sample type.

Attribute Details

ANIMAL_ID

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

Unique identifier of the animal from which the sample was collected.

DISPOSAL_COMMENTS

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

Additional information about the disposal or destruction of the sample.

DISPOSAL_DATE

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

Date the sample was destroyed or disposed of.

DISPOSAL_FLAG

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

Flag indicating whether or not the sample has been disposed of: Y or N.

DISPOSAL_LOCATION

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

Location where the sample was either destroyed or disposed of.

DISPOSAL_METHOD

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

Method employed to dispose of the sample.

SAMPLE_ANATOMICAL_SITE

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

Anatomical site on the body of the animal, from which the sample was collected.

SAMPLE_COMMENTS

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

Additional information about the sample.

SAMPLE_ID

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

Unique identifier of the sample, within the context of the animal from which the sample was collected.

SAMPLE_PRESERVATION_METHOD

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

Method employed to preserve the sample: fresh, frozen, dmso, etc.

SAMPLE_SIZE

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

Dimensions, weight, etc., if known.

SAMPLE_TYPE_CODE

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

Code representing the description of the sample type.

SAMPLE_TYPE_ID

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

Unique identifier of the description of the sample type.

Catalog Details

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