MM_CUSTODY_SAMPLE
Entity (ENT) | Alaska Fisheries Science Center (AFSC)GUID: gov.noaa.nmfs.inport:75163 | Updated: May 21, 2025 | Published / External
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
|
|
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
| 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
| 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
| Data Storage Type: | DATE |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Date the sample was destroyed or disposed of. |
DISPOSAL_FLAG
| 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
| 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
| Data Storage Type: | VARCHAR2(100 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Method employed to dispose of the sample. |
SAMPLE_ANATOMICAL_SITE
| 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
| Data Storage Type: | VARCHAR2(1500 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Additional information about the sample. |
SAMPLE_ID
| 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
| 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
| Data Storage Type: | VARCHAR2(100 BYTE) |
|---|---|
| Required: | No |
| Primary Key: | No |
| Status: | Active |
| Description: |
Dimensions, weight, etc., if known. |
SAMPLE_TYPE_CODE
| 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
| 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 |