Slide Menu
Jump to Section...
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_POSSESSION

Entity (ENT)  |  Alaska Fisheries Science Center (AFSC)
GUID: gov.noaa.nmfs.inport:75164  |  Updated: May 21, 2025  |  Published / External 

Item Identification

Title: MM_CUSTODY_SAMPLE_POSSESSION

Entity Information

Description:

This table logs information about carcass or sample locations and status, as recorded on the AMMOP 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
 BEGIN_DATE DATE Date this custodian received the sample.
100
 COLLECTOR_FLAG VARCHAR2(1 BYTE) Flag indicating whether or not the custodian named on this record is the person who collected the sample: Y or N.
100
 COMMENTS VARCHAR2(1500 BYTE) Additional information about the sample and its status.
100
 CURRENT_CUSTODIAN_FLAG VARCHAR2(1 BYTE) Flag indicating whether or not the sample is currently in the possession of this custodian: Y or N.
100
 CUSTODIAN_EMAIL VARCHAR2(50 BYTE) Email address of the custodian.
100
 CUSTODIAN_LOCATION VARCHAR2(100 BYTE) Physical location of the custodian. Should be the same location as the sample; if not, explain in comments.
100
 CUSTODIAN_NAME VARCHAR2(50 BYTE) Name of the custodian.
100
 CUSTODIAN_PHONE VARCHAR2(20 BYTE) Phone number of the custodian.
100
 END_DATE DATE Date the sample left the possession of this custodian.
100
 POSSESSION_CLASS_CODE VARCHAR2(2 BYTE) One- or two-digit code representing the order of possession of the sample.
100
 POSSESSION_CLASS_ID NUMBER(6,0) Unique identifier of the possession class.
100
 SAMPLE_ID NUMBER(6,0) Unique identifier of the sample.
100
 SAMPLE_LOCATION VARCHAR2(100 BYTE) Physical location of the sample. Should be the same location as the custodian; if not, explain in comments.
100
 SAMPLE_STATUS_CODE VARCHAR2(2 BYTE) Code representing the status of the sample.
100
 SAMPLE_STATUS_ID NUMBER(6,0) Unique identifier of the status of the sample.
100
 SEQUENCE_NUMBER NUMBER(6,0) Unique identifier of the possession record, within the context of the animal and the sample.

Attribute Details

ANIMAL_ID

CC ID: 1374230
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.

BEGIN_DATE

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

Date this custodian received the sample.

COLLECTOR_FLAG

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

Flag indicating whether or not the custodian named on this record is the person who collected the sample: Y or N.

COMMENTS

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

Additional information about the sample and its status.

CURRENT_CUSTODIAN_FLAG

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

Flag indicating whether or not the sample is currently in the possession of this custodian: Y or N.

CUSTODIAN_EMAIL

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

Email address of the custodian.

CUSTODIAN_LOCATION

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

Physical location of the custodian. Should be the same location as the sample; if not, explain in comments.

CUSTODIAN_NAME

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

Name of the custodian.

CUSTODIAN_PHONE

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

Phone number of the custodian.

END_DATE

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

Date the sample left the possession of this custodian.

POSSESSION_CLASS_CODE

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

One- or two-digit code representing the order of possession of the sample.

POSSESSION_CLASS_ID

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

Unique identifier of the possession class.

SAMPLE_ID

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

Unique identifier of the sample.

SAMPLE_LOCATION

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

Physical location of the sample. Should be the same location as the custodian; if not, explain in comments.

SAMPLE_STATUS_CODE

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

Code representing the status of the sample.

SAMPLE_STATUS_ID

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

Unique identifier of the status of the sample.

SEQUENCE_NUMBER

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

Unique identifier of the possession record, within the context of the animal and the sample.

Catalog Details

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