Account Creation Issues: We have received reports of issues with creating new user accounts and linking accounts to CAM, and are currently investigating the root cause. In the meantime: - If you're experiencing errors creating new users, please use the "Quick Add" feature instead (click the "Quick Add" button on the Manage Users page). - If you're experiencing errors linking CAM accoun...
View All
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_TYPE

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

Summary

Description

Control table containing the types of samples that may be represented on the Biological Sample Chain of Custody Form.

Entity Information

Data Attribute / Type Description
BEGIN_DATE
DATE 		Effective date of the sample type.
CODE
VARCHAR2(2 BYTE) 		One- or two-letter code representing the type of sample.
DESCRIPTION
VARCHAR2(100 BYTE) 		Description of the type of sample.
END_DATE
DATE 		Retirement date of the sample type.
ID
NUMBER(6,0) 		Unique identifier 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_TYPE

Entity Information

Description:

Control table containing the types of samples that may be represented on the Biological Sample Chain of Custody Form.

Data Attributes

Attribute Summary

Rubric Score Primary Key? Name Type Description
100
 BEGIN_DATE DATE Effective date of the sample type.
100
 CODE VARCHAR2(2 BYTE) One- or two-letter code representing the type of sample.
100
 DESCRIPTION VARCHAR2(100 BYTE) Description of the type of sample.
100
 END_DATE DATE Retirement date of the sample type.
100
 ID NUMBER(6,0) Unique identifier of the sample type.

Attribute Details

BEGIN_DATE

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

Effective date of the sample type.

CODE

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

One- or two-letter code representing the type of sample.

DESCRIPTION

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

Description of the type of sample.

END_DATE

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

Retirement date of the sample type.

ID

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

Unique identifier of the sample type.

Catalog Details

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